From d6c5a95d053db65ae6051e5086cc3472f9fd7812 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期日, 09 十月 2022 09:55:29 +0800 Subject: [PATCH] 修改 生产计划平台 --- WebAPI/Controllers/POStockInBillController.cs | 32 ++++++++++++++++++++------------ 1 files changed, 20 insertions(+), 12 deletions(-) diff --git a/WebAPI/Controllers/POStockInBillController.cs b/WebAPI/Controllers/POStockInBillController.cs index aa1353d..1e8517e 100644 --- a/WebAPI/Controllers/POStockInBillController.cs +++ b/WebAPI/Controllers/POStockInBillController.cs @@ -1474,8 +1474,12 @@ DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill(); var hinterID = list[0].HInterID; var FID = list[0].FID; + + #region 閲戣澏瀹℃牳鍚庝細閲嶆柊鍚屾鍗曟嵁鍒癿es 鏁呬笉闇�瑕佹洿鏂癿es鐨勬敹鏂欓�氱煡鍗� + /* oCn.BeginTran(); string sql = string.Empty; + foreach (var item in list) { if (item.HSQty == 0) @@ -1484,6 +1488,15 @@ oCn.RunProc(sql); } oCn.RunProc("exec h_p_Cg_UpDatePOOrderRelation_Del " + hinterID);//鍒犻櫎鍏宠仈鍏崇郴 + sql = string.Format(@"update Cg_POInStockBillMain set +HBillStatus = 2 , +HCheckDate = getdate() +where HInterID in ({0})", HInterID); + oCn.RunProc(sql);//鏇存柊mes鐘舵�� + //鏇存柊鎴愬姛鍚� 鍚屾鏇存柊閲戣澏 + oCn.Commit(); + **/ + #endregion JObject jsonRoot = new JObject(); jsonRoot.Add("Creator", ""); @@ -1502,10 +1515,10 @@ continue; JObject jsonFPOOrderEntry = new JObject(); jsonFPOOrderEntry.Add("FEntryID", item.FEntryID); - jsonFPOOrderEntry.Add("FHQty ", item.HSQty); ; + jsonFPOOrderEntry.Add("FActReceiveQty ", item.HSQty); ; Entry.Add(jsonFPOOrderEntry); } - jsonModel.Add("FEntity", Entry); + jsonModel.Add("FDetailEntity", Entry); jsonRoot.Add("Model", jsonModel); var loginRet = InvokeHelper.Login(); var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); @@ -1519,7 +1532,7 @@ } var result = InvokeHelper.Save("PUR_ReceiveBill", jsonRoot.ToString()); //LogService.Write(result); - if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE") + if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") { LogService.Write("鏀舵枡閫氱煡鍗曚慨鏀瑰け璐sonRoot:" + jsonRoot.ToString()); objJsonResult.code = "0"; @@ -1559,13 +1572,7 @@ } - sql = string.Format(@"update Cg_POInStockBillMain set -HBillStatus = 2 , -HCheckDate = getdate() -where HInterID in ({0})", HInterID); - oCn.RunProc(sql);//鏇存柊mes鐘舵�� - //鏇存柊鎴愬姛鍚� 鍚屾鏇存柊閲戣澏 - oCn.Commit(); + objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "鎿嶄綔鎴愬姛锛�"; @@ -1574,7 +1581,7 @@ } catch (Exception e) { - oCn.RollBack(); + //oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "寮傚父锛�" + e.ToString(); @@ -1596,8 +1603,9 @@ { try { + //var code = HBarcode.Split('#')[0]; //鏍¢獙鏉$爜鏄惁瀛樺湪 - string sql = $"select* from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode}'"; + string sql = $"select* from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode.Split('#')[0]}' and HQty = {HBarcode.Split('#')[1]}"; DataSet ds = oCn.RunProcReturn(sql, "H_v_SRM_POOrderBillList"); if (ds.Tables[0].Rows.Count == 0) { -- Gitblit v1.9.1