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