From 6bb722be12f95d3f55a141555be2c79b8fcaeca9 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 07 二月 2025 08:35:44 +0800 Subject: [PATCH] 订单打印能查看合同 --- CY_ECommercePlatform/CY.WebForm/Pages/business/OrderDeatil.aspx.cs | 33 ++++++++++++++++++++++++++++++++- 1 files changed, 32 insertions(+), 1 deletions(-) diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderDeatil.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderDeatil.aspx.cs index d87a2f2..0ae4a99 100644 --- a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderDeatil.aspx.cs +++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderDeatil.aspx.cs @@ -30,6 +30,8 @@ using CY.BLL; using CY.Model.Inquiry; using CY.BLL.Sys; +using CY.SQLDAL; +using System.Data.SqlClient; namespace CY.WebForm.Pages.business { @@ -39,7 +41,9 @@ public partial class OrderDeatil : BasePage { EC_OrderBasicBLL _eC_OrderBasicBLL = new EC_OrderBasicBLL(); - + Sys_DictionaryBLL _sys_DictionaryBLL = new Sys_DictionaryBLL();//瀛楀吀涓氬姟閫昏緫鎿嶄綔绫诲璞� + public int ContractCount = 0; + public string BuyerId = ""; /// <summary> /// 椤甸潰鍔犺浇浜嬩欢 /// </summary> @@ -140,6 +144,33 @@ { _inquiryCommonModel.PrintDemand = _inquiryCommonModel.PrintCountName + "锛�" + _inquiryCommonModel.PrintDemand; } + var sys_Dictionarie = _sys_DictionaryBLL.GetDataByType("鍗板埛鍗曚綅").FirstOrDefault(x=>x.MeanValue == _inquiryCommonModel.Unit); + if (sys_Dictionarie != null) + { + _eC_OrderBasic.UnitName = sys_Dictionarie.Name; + } + BuyerId = _eC_OrderBasic.BuyerId.ToString(); + //鏌ヨ瀹㈡埛鏄惁鏈夊悎鍚� + Database DC = new Database(); + try + { + + string sqlStr = string.Format("select count(*) from [dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}'", _eC_OrderBasic.BuyerId); + SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection); + ContractCount = (int)myCmd.ExecuteScalar(); + } + catch (Exception) + { + + ContractCount = 0; + } + finally + { + if (DC.Connection.State != System.Data.ConnectionState.Closed) + DC.Connection.Close(); + } + + rptOrder.DataSource = new List<EC_OrderBasic>() { _eC_OrderBasic }; rptOrder.DataBind(); rptAccpteWay.DataSource = "鑷彁".Equals(_inquiryCommonModel.DeliveryModeName) ? null : new List<EC_AcceptWayByOrder>() { _eC_AcceptWayByOrder }; -- Gitblit v1.9.1