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