优化查询

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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
using FineUIPro;
using FineUIPro.iWareWms;
using iWareCommon.Common.Entity;
using iWareExcel.EXCEL.Entity;
using iWareExcel.EXCEL.Service;
using System;
using System.Collections.Generic;
 
namespace iWareWms.View.EXCEL.WorkSheet
{
    public partial class WorkSheetDetail : PageBase
    {
 
        protected override void Save(out string msg)
        {
            WorkSheetService.GetInstance().Save(GetWorkSheet(), out msg);
        }
 
        protected override void Update(out string msg)
        {
 
            var workSheet = GetWorkSheet();
            workSheet.Id = Convert.ToInt32(Request.QueryString["Id"]);
 
            WorkSheetService.GetInstance().Update(workSheet, out msg);
        }
 
        private WorkSheetEntity GetWorkSheet()
        {
            return new WorkSheetEntity
            {
                Name = Name.Text.Trim(),
                ClassName = ClassName.Text.Trim(),
                WorkBookId = Convert.ToInt32(WorkBookId.SelectedValue),
                WorkBookName = WorkBookId.SelectedText.Trim(),
                HeadStartLine = Convert.ToInt32(HeadStartLine.Text.Trim()),
                DataStartLine = Convert.ToInt32(DataStartLine.Text.Trim()),
                SheetIndex = Convert.ToInt32(SheetIndex.Text)
            };
        }
 
 
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
               string msg;
                var workBooks = WorkBookService.GetInstance().QueryByParam(new QueryParam(), out msg);
            
                workBooks.ForEach(x => WorkBookId.Items.Add(x.Name, x.Id.ToString()));
 
                if (string.IsNullOrEmpty(Request.QueryString["IsEdit"]))
                {
                    DataStartLine.Text = "0";
                    HeadStartLine.Text = "0";
                    return;
                }
 
                var workSheets = WorkSheetService.GetInstance().QueryByParam(new QueryParam { Filter = new Dictionary<string, object> { { "Id", Request.QueryString["Id"] } } }, out msg);
 
                if (!string.IsNullOrEmpty(msg))
                {
                    Alert.ShowInTop(msg);
                    return;
 
                }
 
                Name.Text = workSheets.Count > 0 ? workSheets[0].Name : "";
                ClassName.Text = workSheets.Count > 0 ? workSheets[0].ClassName : "";
                WorkBookId.SelectedValue = workSheets[0].WorkBookId.ToString();
                DataStartLine.Text = workSheets[0].DataStartLine.ToString();
                HeadStartLine.Text = workSheets[0].HeadStartLine.ToString();
                SheetIndex.Text = workSheets[0].SheetIndex.ToString();
            }
        }
    }
}