From d456623c6516e66cee457369a0a2b4bda2489bde Mon Sep 17 00:00:00 2001 From: yxj <1qaz@123> Date: 星期五, 14 五月 2021 16:01:21 +0800 Subject: [PATCH] 直接调拨单(源单:调拨申请单、无源单)上传生成CLOUD单据回滚修改 --- CLOUDWEB/WebService1.asmx.cs | 52 ++++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 40 insertions(+), 12 deletions(-) diff --git a/CLOUDWEB/WebService1.asmx.cs b/CLOUDWEB/WebService1.asmx.cs index 73da70b..495ab9d 100644 --- a/CLOUDWEB/WebService1.asmx.cs +++ b/CLOUDWEB/WebService1.asmx.cs @@ -5017,9 +5017,9 @@ private bool SaveMoveOut_CLD(Model.ClsKf_MoveStockBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + DataSet Ds; try { - DataSet Ds; // oCn.BeginTran(); //鍐欏叆WMS璋冩嫧鍗� @@ -5046,13 +5046,22 @@ //瀹℃牳鍗曟嵁 oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120),HBillStatus=2 where HInterID= " + oMain.HInterID.ToString()); } - + oCn.Commit(); + } + catch (Exception e) + { + sErrMsg = "鐢熸垚鐩存帴璋冩嫧鍗曞け璐�111锛�" + e.Message; + oCn.RollBack(); + return false; + } + try + { //鏍规嵁TMP琛� 杩斿洖 瀛愯〃淇℃伅 Ds = oCn.RunProcReturn("exec h_p_Kf_GetMoveOutBill_CLD " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetMoveOutBill_CLD"); if (Ds == null || Ds.Tables[0].Rows.Count == 0 || Ds.Tables[1].Rows.Count == 0) { sErrMsg = "鑾峰彇瀛愯〃淇℃伅澶辫触锛�"; - oCn.RollBack(); + //oCn.RollBack(); return false; } else @@ -5243,19 +5252,19 @@ if (HReturn.Contains("\"IsSuccess\":false") == true) { sErrMsg = "鐢熸垚鐩存帴璋冩嫧鍗曞け璐ワ紒" + HReturn + sJson; - oCn.RollBack(); + //oCn.RollBack(); return false; } else { - oCn.Commit(); + //oCn.Commit(); return true; } } else { sErrMsg = "鐢熸垚鐩存帴璋冩嫧鍗曞け璐ワ紒鐧诲綍澶辫触锛�"; - oCn.RollBack(); + //oCn.RollBack(); return false; } } @@ -5263,7 +5272,7 @@ catch (Exception e) { sErrMsg = "鐢熸垚鐩存帴璋冩嫧鍗曞け璐ワ紒" + e.Message; - oCn.RollBack(); + //oCn.RollBack(); return false; } } @@ -6087,7 +6096,16 @@ //瀹℃牳鍗曟嵁 oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120) where HInterID= " + oMain.HInterID.ToString()); } - + oCn.Commit(); + } + catch (Exception e) + { + sErrMsg = "鐢熸垚棰嗘枡璋冩嫧鍗曞け璐�111锛�" + e.Message; + oCn.RollBack(); + return false; + } + try + { //鏍规嵁TMP琛� 杩斿洖 瀛愯〃淇℃伅 DataSet Ds; Ds = oCn.RunProcReturn("exec h_p_Kf_GetMoveStockBill_MoveStockRequest_CLD_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetMoveStockBill_MoveStockRequest_CLD_New"); @@ -6099,6 +6117,15 @@ } else { + string sJson_StockStyle = ""; + if (oSystemParameterMain.WMS_CampanyName == "闊╃數") //绯荤粺鍙傛暟 瀹㈡埛瀹氬埗鍖栧悕绉� 绌虹櫧涓洪�氱敤 + { + sJson_StockStyle = "\"F_CHLX\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["F_CHLX"]) + "\","; //鍑鸿揣绫诲瀷 + } + else + { + sJson_StockStyle = ""; + } string sJson_Main = "{\"Creator\":\"\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"IsDeleteEntry\":\"True\",\"SubSystemId\":\"\",\"IsVerifyBaseDataField\":\"false\"," + "\"IsEntryBatchFill\":\"True\",\"ValidateFlag\":\"True\",\"NumberSearch\":\"True\",\"InterationFlags\":\"\"," + "\"Model\":{ " + @@ -6130,6 +6157,7 @@ //\"FThirdSystem\":\"\", //\"FThirdSrcBillNo\":\"\", //\"FThirdSrcId\":\"\", + sJson_StockStyle + "\"FBillEntry\": [ "; string sJson_Entry = ""; for (int i = 0; i < Ds.Tables[1].Rows.Count; i++) @@ -6304,19 +6332,19 @@ if (HReturn.Contains("\"IsSuccess\":false") == true) { sErrMsg = "鐢熸垚鐩存帴璋冩嫧鍗曞け璐ワ紒" + HReturn + sJson; - oCn.RollBack(); + //oCn.RollBack(); return false; } else { - oCn.Commit(); + //oCn.Commit(); return true; } } else { sErrMsg = "鐢熸垚鐩存帴璋冩嫧鍗曞け璐ワ紒鐧诲綍澶辫触锛�"; - oCn.RollBack(); + //oCn.RollBack(); return false; } } @@ -6324,7 +6352,7 @@ catch (Exception e) { sErrMsg = "鐢熸垚鐩存帴璋冩嫧鍗曞け璐ワ紒" + e.Message; - oCn.RollBack(); + //oCn.RollBack(); return false; } } -- Gitblit v1.9.1