优化查询

schangxiang@126.com

2025-09-17 f1859bb8b72998c4852aa23a605f6f7628599a2c

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
using FineUIPro;
using FineUIPro.iWareWms;
using iWareCommon.Common.Entity;
using iWareExcel.EXCEL.Service;
using System;
using System.Collections.Generic;
 
namespace iWareWms.View.EXCEL.WorkBook
{
    public partial class ViewWorkSheet : PageBase
    {
        protected override Grid GetGrid()
        {
            return WorkSheetGrid;
        }
 
        protected override FineUIPro.DropDownList GetPageSizeDropDownList()
        {
            return ddlPageSize;
        }
 
        protected override List<object> GetDataSource(int pageIndex, int pageSize, out string msg, out int totalNum, out int currentPage)
        {
 
            var workSheets = WorkSheetService.GetInstance().QueryByParam(new QueryParam
            {
                Search = new Dictionary<string, object> { { "Name", tbWorkSheetName.Text.Trim() } },
                Filter=new Dictionary<string,object>(){{"WorkBookId",Request.QueryString["WorkBookId"]}},
                PageIndex = pageIndex,
                PageSize = pageSize
            }, out msg, out totalNum, out currentPage);
 
            var res = new List<object>();
 
            workSheets.ForEach(x => res.Add(x));
 
            return res;
        }
 
        protected override void Delete(int id, out string msg)
        {
            WorkSheetService.GetInstance().Delete(id, out msg);
        }
 
        protected override void Delete(List<int> ids, out string msg)
        {
            WorkSheetService.GetInstance().Delete(ids, out msg);
        }
 
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //判断删除复选框是否选择了至少一项纪录
                ResolveDeleteButtonForGrid(Button3, WorkSheetGrid);
                Button1.OnClientClick = Window1.GetShowReference("~/View/EXCEL/WorkBook/ViewWorkSheetDetail.aspx?WorkBookId="+Request .QueryString["WorkBookId"], "新增工作页");
                Query(1);
            }
        }
 
    }
}