From fe4782024b58742f763989b457973b95382adf7b Mon Sep 17 00:00:00 2001
From: ch <37327@LLOOCCY>
Date: 星期四, 23 十二月 2021 14:45:34 +0800
Subject: [PATCH] 修改了 销售出库、产品入库单据缓存列表功能

---
 DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs |   35 +++++++++++++++++++++++++++++++++++
 1 files changed, 35 insertions(+), 0 deletions(-)

diff --git a/DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs b/DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs
index a2890db..938647e 100644
--- a/DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs
+++ b/DAL/WMS/ClsKF_PonderationBillMain_Temp_Ctl.cs
@@ -14,6 +14,41 @@
 
 
 
+        //宸蹭笂浼犲垪琛ㄧ晫闈紝鎾ら攢鍔熻兘锛屽垹闄MS琛ㄥ拰鏈湴鍑哄叆搴撳崟璁板綍锛屽苟鏇存柊TEMP琛ㄤ腑鐨勪笂浼犲瓧娈� HRelationInterID=0
+        public bool DeleteICStockBillAndWMS(Int64 sHInterID, string sHBillNo, string sHBillType, ref string sErrMsg)
+        {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+            try
+            {
+                oCn.BeginTran();
+                DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_ICStockBillAndWMS_Delete " + sHInterID + ",'" + sHBillNo + "','" + sHBillType + "'", "h_p_WMS_ICStockBillAndWMS_Delete");
+                if (Ds == null || Ds.Tables[0].Rows.Count == 0)
+                {
+                    sErrMsg = "鎾ら攢鍗曟嵁澶辫触锛屾暟鎹簱杩炴帴澶辫触锛�";
+                    oCn.RollBack();
+                    return false;
+                }
+                if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 0)
+                {
+                    sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
+                    oCn.Commit();
+                    return true;
+                }
+                else
+                {
+                    sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
+                    oCn.RollBack();
+                    return false;
+                }
+            }
+            catch (Exception e)
+            {
+                sErrMsg = e.Message;
+                oCn.RollBack();
+                return false;
+            }
+        }
+
         //鍒ゆ柇鏉$爜 鍏ュ簱鏁伴噺鏄惁瓒呰繃鏉$爜鏈韩棰濆畾鏁伴噺
         public bool IsBarCode(string sBarCode, string sBillType, bool sRedBlueFlag, ref double sQty, ref string sReturn)
         {

--
Gitblit v1.9.1