From 05e8d342bbff483c73ac4fc481ea16f203a78ba1 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期三, 10 五月 2023 10:28:12 +0800 Subject: [PATCH] 斯莫尔生产订单 货主 工序流转卡批量复制 --- WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs | 106 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 106 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs index 187c835..f48232e 100644 --- a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs +++ b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs @@ -373,6 +373,112 @@ //} #endregion + #region[鏂板鍗曟嵁-淇濆瓨鎸夐挳-鎵归噺澶嶅埗] + /// <summary> + /// 鏂板鍗曟嵁-淇濆瓨鎸夐挳 + ///鍙傛暟锛歴tring sql銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Sc_ProcessExchangeBill/AddBill_Copy_pl")] + [HttpPost] + public object AddBill_Copy_pl([FromBody] JObject sMainSub) + { + var _value = sMainSub["sMainSub"].ToString(); + string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + int msg2 = int.Parse(sArray[0].ToString()); + string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); + string msg5 = sArray[3].ToString(); + + string UserName = ""; + ListModels oListModels = new ListModels(); + string sReturn = ""; + try + { + if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); + DBUtility.ClsPub.HOrgID = long.Parse(msg5); + DBUtility.ClsPub.CurUserName = msg4; + oBill.ShowBill(long.Parse(msg3), ref sReturn); + + ds = oCN.RunProcReturn("select isnull(sum(HQty),0) from Sc_ProcessExchangeBillMain where HICMOBillNo='" + oBill.omodel.HICMOBillNo + "' and HInterID <>"+ oBill.omodel.HInterID, "Sc_ProcessExchangeBillMain"); + var HQty = double.Parse(ds.Tables[0].Rows[0][0].ToString()); + int num = 0; + //鍗曟嵁鏁伴噺 * 寮犳暟 + 宸茬敓鎴愪笉鍖呮嫭鏈崟鎹殑鏁伴噺 >鐢熶骇璁㈠崟鏁伴噺 + if ((oBill.omodel.HQty * msg2) + HQty > oBill.omodel.HPlanQty) + { + if (((oBill.omodel.HPlanQty - oBill.omodel.HQty - HQty) % oBill.omodel.HQty) == 0) + { + num = (int)((oBill.omodel.HPlanQty - oBill.omodel.HQty - HQty) / oBill.omodel.HQty); + } else + { + num = (int)((oBill.omodel.HPlanQty - oBill.omodel.HQty - HQty) / oBill.omodel.HQty); + num += 1; + } + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏈�澶氬彲浠ュ鍒�" + num + "寮狅紒"; + objJsonResult.data = null; + return objJsonResult; + } + + if (num == 0) { + double HPlanQty = oBill.omodel.HPlanQty - oBill.omodel.HQty - HQty; + for (int i = 0; i < msg2; i++) + { + oBill.omodel.HBillNo = DBUtility.ClsPub.CreateBillCode("3772", ref DBUtility.ClsPub.sExeReturnInfo, true); + oBill.omodel.HDate =DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); + oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); + oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); + oBill.omodel.HChecker = ""; + oBill.omodel.HCheckDate = ""; + oBill.omodel.HMaker = msg4; + + if (HPlanQty < oBill.omodel.HQty) + { + oBill.omodel.HQty = HPlanQty; + } + + //淇濆瓨瀹屾瘯鍚庡鐞� + bool bResult; + + bResult = oBill.AddBill(ref sReturn); + if (bResult) + { + num++; + HPlanQty -= oBill.omodel.HQty; + } + } + + } + + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "澶嶅埗浜�" + num + "寮犲崟鎹紒"; + objJsonResult.data = 1; + return objJsonResult; + + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.ToString(); + objJsonResult.data = 1; + return objJsonResult; + } + } + #endregion + #region[鎵归噺鏂板鍗曟嵁-淇濆瓨鎸夐挳] /// <summary> /// 鏂板鍗曟嵁-淇濆瓨鎸夐挳 -- Gitblit v1.9.1