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 |   26 ++++++++++++++++++++++++++
 1 files changed, 26 insertions(+), 0 deletions(-)

diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderDeatil.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderDeatil.aspx.cs
index dcc717a..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
 {
@@ -40,6 +42,8 @@
     {
         EC_OrderBasicBLL _eC_OrderBasicBLL = new EC_OrderBasicBLL();
         Sys_DictionaryBLL _sys_DictionaryBLL = new Sys_DictionaryBLL();//瀛楀吀涓氬姟閫昏緫鎿嶄綔绫诲璞�
+        public int ContractCount = 0;
+        public string BuyerId = "";
         /// <summary>
         /// 椤甸潰鍔犺浇浜嬩欢
         /// </summary>
@@ -145,6 +149,28 @@
             {
                 _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