From b95525c2b6e4409a6b0ef3e9e598123828a4f73a Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 17 十月 2024 15:57:21 +0800
Subject: [PATCH] 订单锁单

---
 CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs            |   47 +++++++++++++++
 CY_ECommercePlatform/CY.WebForm/js/business/Order.js             |   22 +++++++
 CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs               |   11 +++
 CY_ECommercePlatform/CY.Model/EC/EC_OrderBasic.cs                |   27 +++++++++
 CY_ECommercePlatform/CY.Model/EC/EC_OrderBasicExtend.cs          |   15 +++++
 CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx    |    9 ++
 CY_ECommercePlatform/CY.IDAL/EC/IEC_OrderBasicDAL.cs             |    8 ++
 CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs |   22 +++++++
 8 files changed, 160 insertions(+), 1 deletions(-)

diff --git a/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs b/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs
index 8d97fd8..c6c67a2 100644
--- a/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs
+++ b/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs
@@ -122,6 +122,17 @@
         }
 
         /// <summary>
+        /// 閿佸畾璁㈠崟
+        /// </summary>
+        /// <param name="orderId">璁㈠崟缂栧彿</param>
+        /// <param name="operator">鎿嶄綔浜�</param>
+        /// <returns></returns>
+        public bool SuodingOrder(int orderId, string operater)
+        {
+            return _eC_OrderBasicDAL.SuodingOrder(orderId, operater);
+        }
+
+        /// <summary>
         /// 鎵归噺鍙楃悊璁㈠崟
         /// </summary>
         /// <param name="orderIds"></param>
diff --git a/CY_ECommercePlatform/CY.IDAL/EC/IEC_OrderBasicDAL.cs b/CY_ECommercePlatform/CY.IDAL/EC/IEC_OrderBasicDAL.cs
index f82425d..f620fa7 100644
--- a/CY_ECommercePlatform/CY.IDAL/EC/IEC_OrderBasicDAL.cs
+++ b/CY_ECommercePlatform/CY.IDAL/EC/IEC_OrderBasicDAL.cs
@@ -80,6 +80,14 @@
         bool AcceptOrder(int orderId, double commission);
 
         /// <summary>
+        /// 鍙楃悊璁㈠崟
+        /// </summary>
+        /// <param name="orderId">璁㈠崟缂栧彿</param>
+        /// <param name="operator">鎿嶄綔浜�</param>
+        /// <returns></returns>
+        bool SuodingOrder(int orderId, string operater);
+
+        /// <summary>
         /// 鎵归噺鍙楃悊璁㈠崟
         /// </summary>
         /// <param name="orderIds"></param>
diff --git a/CY_ECommercePlatform/CY.Model/EC/EC_OrderBasic.cs b/CY_ECommercePlatform/CY.Model/EC/EC_OrderBasic.cs
index b2450d2..ce51109 100644
--- a/CY_ECommercePlatform/CY.Model/EC/EC_OrderBasic.cs
+++ b/CY_ECommercePlatform/CY.Model/EC/EC_OrderBasic.cs
@@ -246,6 +246,33 @@
             get;
             set;
         }
+
+
+
+        /// <summary>
+        /// 閿佸崟鐘舵��
+        /// </summary>
+        public bool? SuodanState
+        {
+            get;
+            set;
+        }
+        /// <summary>
+        /// 閿佸崟鏃堕棿
+        /// </summary>
+        public DateTime? SuodanTime
+        {
+            get;
+            set;
+        }
+        /// <summary>
+        /// 閿佸崟鎿嶄綔浜�
+        /// </summary>
+        public string SuodanOperator
+        {
+            get;
+            set;
+        }
         /// <summary>
         /// 瀹屽伐澶囨敞
         /// </summary>
diff --git a/CY_ECommercePlatform/CY.Model/EC/EC_OrderBasicExtend.cs b/CY_ECommercePlatform/CY.Model/EC/EC_OrderBasicExtend.cs
index 3a86f41..dfe6cfe 100644
--- a/CY_ECommercePlatform/CY.Model/EC/EC_OrderBasicExtend.cs
+++ b/CY_ECommercePlatform/CY.Model/EC/EC_OrderBasicExtend.cs
@@ -927,6 +927,21 @@
                 this.yssldw = isChange ? MyConvert.ConvertToString(value) : this.yssldw;
                 theValue = this.yssldw;
             }
+            else if ("SuodanState".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 97)
+            {
+                this.SuodanState = isChange ? MyConvert.ConvertToBoolean(value) : this.CompledState;
+                theValue = this.SuodanState;
+            }
+            else if ("SuodanTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 98)
+            {
+                this.SuodanTime = isChange ? MyConvert.ConvertToDateTime(value) : this.SuodanTime;
+                theValue = this.SuodanTime;
+            }
+            else if ("SuodanOperator".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 99)
+            {
+                this.SuodanOperator = isChange ? MyConvert.ConvertToString(value) : this.SuodanOperator;
+                theValue = this.SuodanOperator;
+            }
             #endregion
 
             return theValue;
diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs
index 4795903..fb2a15a 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs
@@ -1382,6 +1382,53 @@
 
         }
 
+
+
+        /// <summary>
+        /// 閿佸崟璁㈠崟
+        /// </summary>
+        /// <param name="orderId">璁㈠崟缂栧彿</param>
+        /// <param name="operater">鎿嶄綔浜�</param>
+        /// <returns></returns>
+        public bool SuodingOrder(int orderId, string operater)
+        {
+            if (0 >= orderId || 0 >= orderId)
+            {
+                return false;
+            }
+            else
+            {
+            }
+           
+            IList<SqlParameter> sqlParms = new List<SqlParameter>()
+            {
+                  
+                    new SqlParameter("@SuodanState",true),
+                    new SqlParameter("@SuodanTime",DateTime.Now),
+                     new SqlParameter("@SuodanOperator",operater),
+                        new SqlParameter("@Keyid",orderId),
+            };
+            IList<SqlParameter> sqlParms1 = new List<SqlParameter>()
+            {
+                        new SqlParameter("@Keyid",orderId),
+            };
+            try
+            {
+                string sql = "Update EC_OrderBasic Set [SuodanState]=@SuodanState,[SuodanTime]=@SuodanTime,[SuodanOperator]=@SuodanOperator  where [Keyid] =@Keyid ";
+                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
+                
+                string sql1 = "Update CoreCmsPlanOrder Set [status]=2  where [orderkeyid] =@Keyid ";
+                _dataBase.ExecuteSql(sql1, sqlParms1.ToArray<SqlParameter>());
+
+
+            }
+            catch (Exception ex)
+            {
+                throw ex;
+            }
+            return true;
+        }
+
         /// <summary>
         /// 鎵归噺鍙楃悊璁㈠崟
         /// </summary>
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx
index fbe5a95..d267260 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx
@@ -5,7 +5,7 @@
 <head id="Head1" runat="server">
     <title>璁㈠崟鍒楄〃</title>
     <uc:cmshead id="CMSHead1" runat="server" />
-    <script src="../../js/business/Order.js?v=5" type="text/javascript"></script>
+    <script src="../../js/business/Order.js?v=6" type="text/javascript"></script>
     <script type="text/javascript">
         //璁㈠崟璇勪环
         function evaluationModel(orderid) {
@@ -358,6 +358,9 @@
                         <th width="26" menu_member_case_id="case_ToAccept" menu_member_case_name="鍙楃悊">
                             鍙楃悊
                         </th>
+                         <th width="26" menu_member_case_id="case_ToAccept" menu_member_case_name="閿佸崟">
+                            閿佸崟
+                        </th>
                           <th width="26" >
                             灏佺
                         </th>
@@ -470,6 +473,10 @@
                                     <span class="<%#IsCanOpearte(Eval("Keyid"),Eval("OrderState"),Eval("OutId"),"鍙楃悊")?"hand_yes":"hand_no"%>" <%#IsOpearted(Eval("Keyid"), Eval("OrderState"), "鍙楃悊") ?"title='宸插彈鐞�'":"title='鍙楃悊'"%> onclick="ToAccept(<%#Eval("SumPrice" )%>,'<%#Eval("SellerOrderId")%>',<%#Eval("Keyid")%>,<%#Eval("OrderTypeId")%>)">
                                         <%#IsOpearted(Eval("Keyid"), Eval("OrderState"), "鍙楃悊") ? "鈭�" : "鍙楃悊"%></span>
                                 </td>
+                                 <td >
+                                    <span  <%#"37" == Eval("PrintTypeId").ToString()? "style='display:block;'" : "style='display:none;'" %>    <%#true.Equals(Eval("SuodanState"))?"title='宸查攣鍗�'":"title='閿佸崟'"%>    onclick="<%#true.Equals(Eval("SuodanState"))?"":"ToSuodan("+Eval("Keyid")+",'"+Eval("SellerOrderId")+"')"%>">
+                                        <%#true.Equals(Eval("SuodanState")) ? "鈭�" : "閿佸崟"%></span>
+                                </td>
                                  <td  >
                                     <%-- <span class="hand look" title="鏌ョ湅鎴栨墦鍗�" onclick='ShowOrder(<%#Eval("Keyid") %>)'>鎵撳嵃</span>--%>
                                     <span class="hand_yes" <%#true.Equals(Eval("IsPrintfengqian"))? "title='宸叉墦鍗�'" : "title='鎵撳嵃'"%> onclick='ShowOrderFengqian(<%#Eval("Keyid") %>)'>
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs
index f53930f..fe545c7 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs
@@ -105,6 +105,9 @@
                     case "AcceptOrder":
                         Accept();
                         break;
+                    case "SuodanOrder":
+                        Suodan();
+                        break;
                     case "AcceptOrderAll":
                         AcceptAll();
                         break;
@@ -278,6 +281,25 @@
             Response.Write(_eC_OrderBasicBLL.AcceptOrder(orderId.Value, commission.Value) ? "1" : "0");
         }
 
+
+        /// <summary>
+        /// 閿佸崟
+        /// </summary>
+        private void Suodan()
+        {
+            Response.Clear();
+            int? orderId = string.IsNullOrEmpty(Request["id"]) ? null : MyConvert.ConvertToInt32(Request["id"]);
+            if (!orderId.HasValue)
+            {
+                Response.Write("-2");
+                return;
+            }
+            else
+            {
+            }
+            Response.Write(_eC_OrderBasicBLL.SuodingOrder(orderId.Value, CurrentUser.ShortName) ? "1" : "0");
+        }
+
         /// <summary>
         /// 鎵归噺鍙楃悊璁㈠崟
         /// </summary>
diff --git a/CY_ECommercePlatform/CY.WebForm/js/business/Order.js b/CY_ECommercePlatform/CY.WebForm/js/business/Order.js
index e1241fc..f7a528f 100644
--- a/CY_ECommercePlatform/CY.WebForm/js/business/Order.js
+++ b/CY_ECommercePlatform/CY.WebForm/js/business/Order.js
@@ -50,6 +50,28 @@
     });
 }
 
+
+
+/*
+纭鍙楃悊
+*/
+function ToSuodan(orderId, orderShowId) {
+
+
+    var msg ='纭閿佸崟璁㈠崟:' + orderShowId + '?';
+    top.Dialog.confirm(msg, function () {
+        CallServer({ Target: "SuodanOrder", id: orderId }, function (data, textStatus) {
+            if ('1' == data) {
+                alertMsg('鎿嶄綔鎴愬姛锛�');
+                RefreshDIVOpener();   //鍏抽棴椤甸潰
+            } else {
+                alertMsg('-1' == data ? '閿佸崟杩囩▼涓彂鐢熷紓甯革紝璇烽噸鏂板彈鐞嗭紒' : '閿佸崟澶辫触锛�');
+                //dialog.close();
+            }
+        });
+    });
+}
+
 ///鎵归噺鍙楃悊
 function ToAllAccept() {
     var commission = parseFloat(document.getElementById('txtCommission').value);

--
Gitblit v1.9.1