From 374ce4ffd0c459bb4067e8d5765f972668aff9b1 Mon Sep 17 00:00:00 2001 From: wzp <2040239371@qq.com> Date: 星期四, 02 三月 2023 14:56:23 +0800 Subject: [PATCH] 变更oracle访问组件 --- web/web/GwOrderList.aspx.cs | 92 ++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 88 insertions(+), 4 deletions(-) diff --git a/web/web/GwOrderList.aspx.cs b/web/web/GwOrderList.aspx.cs index 7a26a7d..de99ec0 100644 --- a/web/web/GwOrderList.aspx.cs +++ b/web/web/GwOrderList.aspx.cs @@ -14,6 +14,8 @@ protected List<GwProduct> GwProductList; protected List<GwClient> GwClientList; + //杩斿洖URL + public string backUrl = ""; public string sDate { @@ -37,10 +39,41 @@ } } + 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"); } } @@ -80,9 +113,9 @@ } if (productId.Equals(bean.Id)) - stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.Id, (object)bean.Name); + stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.Id, (object)bean.Name); else - stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.Id, (object)bean.Name); + stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.Id, (object)bean.Name); } return stringBuilder.ToString(); } @@ -97,10 +130,61 @@ foreach (GwClient bean in this.GwClientList) { if (clientId.Equals(bean.ClientID)) - stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.ClientID, (object)bean.ClientName); + stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.ClientID, (object)bean.Company); else - stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.ClientID, (object)bean.ClientName); + 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; + } } -- Gitblit v1.9.1