From 22793391f525b8171828a9d01c73e5420c60e772 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 12 九月 2023 11:23:29 +0800
Subject: [PATCH] 生产资源 工艺子路线 权限 物料加字段

---
 WebAPI/Controllers/MoveStockBillController.cs |  172 +++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 166 insertions(+), 6 deletions(-)

diff --git a/WebAPI/Controllers/MoveStockBillController.cs b/WebAPI/Controllers/MoveStockBillController.cs
index 1e612ef..75a5bf1 100644
--- a/WebAPI/Controllers/MoveStockBillController.cs
+++ b/WebAPI/Controllers/MoveStockBillController.cs
@@ -46,6 +46,7 @@
         public ClsKF_PonderationBillMain_Temp model = new ClsKF_PonderationBillMain_Temp();
         private JsonResult objJsonResult = new JsonResult();
         private json objjson = new json();
+        private object oCn;
 
         /// <summary>
         /// 璋冩嫧鍗�/杩斿洖鍑哄叆搴撴潯鐮佷复鏃惰〃/鐩存帴璋冪敤webservice
@@ -542,8 +543,11 @@
             WebS.WebService1 oWebs = new WebS.WebService1();
             WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();
             string sExpressNumber = "";
+
+            var sJXCode = POStockInBillController.JX_Json(sCode, sInterID, HBillType, HStockOutOrgID, sBillNo,sMaker);
             //WebSoBar = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);
-            WebSoBar = oWebs.get_BarCode_MoveStock(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, HSCWhID, HSCSPID, sQty, SourceFlag, sSourceBillNo, sHSourceBillType, HStockInOrgID,HStockOutOrgID,HScanStyle, ref DBUtility.ClsPub.sErrInfo);
+            string HCustom1 = "", HCustom2 = "";
+            WebSoBar = oWebs.get_BarCode_MoveStock(sJXCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, HSCWhID, HSCSPID, sQty, SourceFlag, sSourceBillNo, sHSourceBillType, HStockInOrgID,HStockOutOrgID,HScanStyle, ref DBUtility.ClsPub.sErrInfo, HCustom1, HCustom2);
             if (WebSoBar == null)
             {
                 objJsonResult.code = "0";
@@ -572,6 +576,10 @@
         {
             var _value = oMain["oMain"].ToString();
             string msg1 = _value.ToString();
+
+
+          
+
             //List<Model.ClsKf_MoveStockBillMain> lsmain = new List<Model.ClsKf_MoveStockBillMain>();
             //ListModels oListModels = new ListModels();
             //lsmain = oListModels.getMoveStockBillMainByJson(msg1);
@@ -607,18 +615,50 @@
                 websLsmain.HBillerID = 0;
                 websLsmain.HExplanation = "";
                 websLsmain.HInnerBillNo = "";
-                websLsmain.HRedBlueFlag = true;
+                websLsmain.HRedBlueFlag = false;
                 websLsmain.HMainSourceBillType = "-1";
                 websLsmain.HStockStyle = "";
                 websLsmain.HBillType = "1207";
+                websLsmain.HBillSubType = lsmain[0].HBillSubType;
                 websLsmain.HSupID = 0;
                 //websLsmain.HGroupID = lsmain[0].HGroupID;
+                string sErrMsg = "";
+                ////涓婁紶鍓嶅垽鏂�
+                //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+                //DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_MoveStockBill_AR " + websLsmain.HInterID.ToString() + ",'" + websLsmain.HBillNo + "','" + websLsmain.HBillType + "'", "h_p_WMS_BeforeUpload_MoveStockBill_AR");
+                //if (Ds == null || Ds.Tables[0].Rows.Count == 0)
+                //{
+                //    sErrMsg = "鏍¢獙涓婁紶鍓嶅垽鏂紝鍙戠敓閿欒锛�"; 
+                //    //return false;
+
+                //    objJsonResult.code = "99";
+                //    objJsonResult.count = 0;
+                //    objJsonResult.Message = "涓婁紶澶辫触锛�" + sErrMsg;
+                //    objJsonResult.data = null;
+                //    return objJsonResult;
+                //}
+                //else
+                //{
+                //    if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1)
+                //    {
+                //        sErrMsg = "鍗曟嵁鍙凤細" + websLsmain.HBillNo + "锛屽崟鎹甀D锛�" + websLsmain.HInterID + "锛�" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
+                //        //return false;
+                //        objJsonResult.code = "99";
+                //        objJsonResult.count = 0;
+                //        objJsonResult.Message = "涓婁紶澶辫触锛�" + sErrMsg;
+                //        objJsonResult.data = null;
+                //        return objJsonResult;
+
+                //    }
+                //}
+
+
 
                 if (webserver.set_SaveMoveStockBill(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))
                 {
                     objJsonResult.code = "0";
                     objJsonResult.count = 1;
-                    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
+                    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;  //鎴愬姛锛�
                     objJsonResult.data = null;
                     return objJsonResult;
                 }
@@ -626,7 +666,8 @@
                 {
                     objJsonResult.code = "99";
                     objJsonResult.count = 0;
-                    objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo;
+                    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;  //澶辫触锛�
+                    //objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo;
                     objJsonResult.data = null;
                     return objJsonResult;
                 }
@@ -641,6 +682,123 @@
                 return objJsonResult;
             }
         }
+
+
+
+        /// <summary>
+        /// 瀹夌憺鐩樼偣鍗�
+        /// </summary>
+        /// <returns></returns>
+        //[Route("MoveStockBill/set_SaveMoveStockBill_PD")]
+        //[HttpPost]
+        //public object set_SaveMoveStockBill_PD([FromBody] JObject oMain)
+        //{
+        //    var _value = oMain["oMain"].ToString();
+        //    string msg1 = _value.ToString();
+
+
+
+
+        //    //List<Model.ClsKf_MoveStockBillMain> lsmain = new List<Model.ClsKf_MoveStockBillMain>();
+        //    //ListModels oListModels = new ListModels();
+        //    //lsmain = oListModels.getMoveStockBillMainByJson(msg1);
+        //    //lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
+        //    //lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
+        //    //string sSourceBillType = lsmain[0].HBillType;
+        //    //BLL.ClsKf_MoveStockBill bll = new BLL.ClsKf_MoveStockBill();
+        //    //return bll.set_SaveMoveStockBill(lsmain[0], sSourceBillType, ref DBUtility.ClsPub.sErrInfo);
+        //    try
+        //    {
+        //        List<Model.ClsKf_MoveStockBillMain> lsmain = new List<Model.ClsKf_MoveStockBillMain>();
+        //        ListModels oListModels = new ListModels();
+        //        lsmain = oListModels.getMoveStockBillMainByJson(msg1);
+        //        lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
+        //        lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
+        //        string sSourceBillType = lsmain[0].HBillType;
+        //        //string sSourceBillType = "-1";
+
+
+        //        WebAPI.WebS.ClsKf_MoveStockBillMain websLsmain = new WebS.ClsKf_MoveStockBillMain();
+        //        websLsmain.HInterID = lsmain[0].HInterID;
+        //        websLsmain.HDate = lsmain[0].HDate;
+        //        websLsmain.HBillNo = lsmain[0].HBillNo;
+        //        websLsmain.HDeptID = lsmain[0].HDeptID;
+        //        websLsmain.HEmpID = lsmain[0].HEmpID;
+        //        websLsmain.HRemark = lsmain[0].HRemark;
+        //        websLsmain.HMaker = lsmain[0].HMaker;
+        //        websLsmain.HWHID = lsmain[0].HWHID;
+        //        websLsmain.HSCWHID = lsmain[0].HSCWHID;
+        //        websLsmain.HKeeperID = lsmain[0].HKeeperID;
+        //        websLsmain.HSecManagerID = lsmain[0].HSecManagerID;
+        //        websLsmain.HManagerID = 0;
+        //        websLsmain.HBillerID = 0;
+        //        websLsmain.HExplanation = "";
+        //        websLsmain.HInnerBillNo = "";
+        //        websLsmain.HRedBlueFlag = true;
+        //        websLsmain.HMainSourceBillType = "-1";
+        //        websLsmain.HStockStyle = "";
+        //        websLsmain.HBillType = "1207";
+        //        websLsmain.HSupID = 0;
+        //        //websLsmain.HGroupID = lsmain[0].HGroupID;
+        //        //string sErrMsg = "";
+        //        //涓婁紶鍓嶅垽鏂�
+        //        //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+        //        //DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_MoveStockBill_AR " + websLsmain.HInterID.ToString() + ",'" + websLsmain.HBillNo + "','" + websLsmain.HBillType + "'", "h_p_WMS_BeforeUpload_MoveStockBill_AR");
+        //        //if (Ds == null || Ds.Tables[0].Rows.Count == 0)
+        //        //{
+        //        //    sErrMsg = "鏍¢獙涓婁紶鍓嶅垽鏂紝鍙戠敓閿欒锛�";
+        //        //    //return false;
+
+        //        //    objJsonResult.code = "99";
+        //        //    objJsonResult.count = 0;
+        //        //    objJsonResult.Message = "涓婁紶澶辫触锛�" + sErrMsg;
+        //        //    objJsonResult.data = null;
+        //        //    return objJsonResult;
+        //        //}
+        //        //else
+        //        //{
+        //        //    if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1)
+        //        //    {
+        //        //        sErrMsg = "鍗曟嵁鍙凤細" + websLsmain.HBillNo + "锛屽崟鎹甀D锛�" + websLsmain.HInterID + "锛�" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
+        //        //        //return false;
+        //        //        objJsonResult.code = "99";
+        //        //        objJsonResult.count = 0;
+        //        //        objJsonResult.Message = "涓婁紶澶辫触锛�" + sErrMsg;
+        //        //        objJsonResult.data = null;
+        //        //        return objJsonResult;
+
+        //        //    }
+        //        //}
+
+
+
+        //        if (webserver.set_SaveMoveStockBill_PD(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))
+        //        {
+        //            objJsonResult.code = "0";
+        //            objJsonResult.count = 1;
+        //            objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
+        //            objJsonResult.data = null;
+        //            return objJsonResult;
+        //        }
+        //        else
+        //        {
+        //            objJsonResult.code = "99";
+        //            objJsonResult.count = 0;
+        //            objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo;
+        //            objJsonResult.data = null;
+        //            return objJsonResult;
+        //        }
+        //    }
+        //    catch (Exception e)
+        //    {
+
+        //        objJsonResult.code = "3";
+        //        objJsonResult.count = 0;
+        //        objJsonResult.Message = "涓婁紶澶辫触锛�" + e.ToString();
+        //        objJsonResult.data = null;
+        //        return objJsonResult;
+        //    }
+        //}
 
 
 
@@ -700,7 +858,8 @@
                 {
                     objJsonResult.code = "0";
                     objJsonResult.count = 1;
-                    objJsonResult.Message = "鐢熸垚璋冩嫧鍗曟垚鍔燂紒鍗曟嵁鍙蜂负锛�";
+                    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;  //鎴愬姛锛�
+                    //objJsonResult.Message = "鐢熸垚璋冩嫧鍗曟垚鍔燂紒鍗曟嵁鍙蜂负锛�";
                     objJsonResult.data = null;
                     return objJsonResult;
                 }
@@ -708,7 +867,8 @@
                 {
                     objJsonResult.code = "99";
                     objJsonResult.count = 0;
-                    objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo;
+                    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;  //澶辫触锛�
+                    //objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo;
                     objJsonResult.data = null;
                     return objJsonResult;
                 }

--
Gitblit v1.9.1