订单日期查询优化

yzh

2022-06-30 737fef976ec1c6b79195fd5c55ece01053373674

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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
 
using Common;
using Model;
using System;
using System.Web;
using System.Web.Profile;
using System.Web.SessionState;
using System.Collections.Generic;
using System.Text;
using Dao;
 
public partial class _GwOrderList : PageBase<SysUser>, IRequiresSessionState
{
 
    protected List<GwProduct> GwProductList;
    protected List<GwClient> GwClientList;
    //返回URL
    public string backUrl = "";
 
    public string sDate
    {
        get
        {
            string @string = this.AppContext.GetString("sDate");
            if (string.IsNullOrEmpty(@string))
                return DateTime.Now.AddDays(-1.0).ToString("yyyy-MM-dd");
            return @string;
        }
    }
 
    public string eDate
    {
        get
        {
            string @string = this.AppContext.GetString("eDate");
            if (string.IsNullOrEmpty(@string))
                return DateTime.Now.ToString("yyyy-MM-dd");
            return @string;
        }
    }
 
    public string ClientId
    {
        get
        {
            if (!string.IsNullOrEmpty(this.AppContext.GetString("clientId")))
            {
                GwClient gwClient = new GwClient();
                using (GwClientDao gwClientDao = new GwClientDao())
                {
                    gwClient = gwClientDao.Get(this.AppContext.GetString("clientId") );
 
                    if (gwClient.Is_Enable == 1)
                    {
                        backUrl = "GwClient.aspx?IsEnable=1";
                    }
                    else
                    {
                        backUrl = "GwClient.aspx?IsEnable=0";
                    }
                }
            }
 
            return this.AppContext.GetString("clientId");
        }
    }
 
    public string SpID
    {
        get
        {
            if (!string.IsNullOrEmpty(this.AppContext.GetString("spId")))
            {
                backUrl = "GwSp.aspx";
            }
 
            return this.AppContext.GetString("spId");
        }
    }
 
    protected void Page_Load(object sender, EventArgs e)
    {
        this.CheckRight("3022", FailedOperation.ErrorMsgOnly);
 
        using (GwClientDao gwClientDao = new GwClientDao())
            this.GwClientList = gwClientDao.Clientlist();
 
        //获取产品或产品分类
        using (GwProductDao gwProductDao = new GwProductDao())
        {
            GwProduct bean = new GwProduct();
            bean.Classes = -1;
            bean.IsEnable = -1;
            bean.IsDefault = -1;
            this.GwProductList = gwProductDao.getAllList(bean);
        }
    }
 
 
    //获取产品信息
    public string GetProductOptions(string productId)
    {
        StringBuilder stringBuilder = new StringBuilder();
        if (this.GwProductList.Count == 0)
            return "<option value='0'>无</option>";
        stringBuilder.AppendFormat("<option value=\"{0}\" >{1}</option>", (object)0, (object)"无");
        foreach (GwProduct bean in this.GwProductList)
        {
            //停用的产品分类不再显示
            if (bean.IsEnable == 0)
            {
                continue;
            }
 
            if (productId.Equals(bean.Id))
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.Id, (object)bean.Name);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.Id, (object)bean.Name);
        }
        return stringBuilder.ToString();
    }
 
    //获取客户信息
    public string GetClientOptions(string clientId)
    {
        StringBuilder stringBuilder = new StringBuilder();
        if (this.GwClientList.Count == 0)
            return "<option value='0'>无</option>";
        stringBuilder.AppendFormat("<option value=\"{0}\" >{1}</option>", (object)0, (object)"无");
        foreach (GwClient bean in this.GwClientList)
        {
            if (clientId.Equals(bean.ClientID))
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.ClientID, (object)bean.Company);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.ClientID, (object)bean.Company);
        }
        return stringBuilder.ToString();
    }
 
    //产品ID转换名称
    public string ProductIdToName(string productId)
    {
        if (this.GwProductList.Count == 0)
            return productId;
        foreach (GwProduct bean in this.GwProductList)
        {
            if (productId.Equals(bean.Name))
                return bean.Name;
            else
                continue;
        }
 
        return productId;
    }
 
    //客户ID转换名称
    public string ClientIdToName(string clientId)
    {
        if (this.GwClientList.Count == 0)
            return clientId;
        foreach (GwClient bean in this.GwClientList)
        {
            if (clientId.Equals(bean.ClientID))
                return bean.Company;
            else
                continue;
        }
 
        return clientId;
    }
 
    //状态转换名称
    public string StatusToName(string status)
    {
        if (string.IsNullOrEmpty(status))
            return "";
        else if (status.Equals("0"))
            return "待审核";
        else if (status.Equals("1"))
            return "审核中";
        else if (status.Equals("2"))
            return "审核通过";
        else if (status.Equals("3"))
            return "审核不通过";
        else if (status.Equals("4"))
            return "取消";
        else
            return status;
    }
}