From 97137b400964c84c9c16e7c7ffd1803d84b53cfb Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期三, 15 六月 2022 09:22:28 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/生产管理/报工台工序/Sc_MESBeginStepWorkBillController.cs | 98 ++++++++++++++++++++++++++++++++---------------- 1 files changed, 65 insertions(+), 33 deletions(-) diff --git "a/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/Sc_MESBeginStepWorkBillController.cs" "b/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/Sc_MESBeginStepWorkBillController.cs" index 1d97bf2..c8a07f5 100644 --- "a/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/Sc_MESBeginStepWorkBillController.cs" +++ "b/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/Sc_MESBeginStepWorkBillController.cs" @@ -1526,6 +1526,7 @@ string BillNo = ""; long MainId = 0; string EntyID = ""; + if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DateTime.Now, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; @@ -1557,7 +1558,7 @@ return objJsonResult; } } - + //鐢熶骇璁㈠崟缂栧彿銆佺敓浜ц鍗曚富ID銆佺敓浜ц鍗曚富ID+瀛怚D BillNo = oItem.HMainSourceBillNo; MainId = oItem.HMainSourceInterID; EntyID = oItem.HMainSourceEntryID; @@ -1579,43 +1580,74 @@ oBill.omodel = oItem; } - //淇濆瓨 - //淇濆瓨瀹屾瘯鍚庡鐞� bool bResult; if (oBill.omodel.HInterID == 0) { oCN.BeginTran(); - //淇敼閲戣澏鐢熶骇鍗曠殑鐘舵�� - oCN.RunProc("update AIS20200908101915zs..T_PRD_MOENTRY_A set FSTATUS=4,FCONVEYDATE=getdate() where FENTRYID=" + (EntyID).Split('-')[1]); + + //鏍规嵁鐢熶骇璁㈠崟瀛怚D鎵惧搴旂殑鐢熶骇鐢ㄦ枡娓呭崟 + DataSet Ds = oCN.RunProcReturn("select b.FID,b.FBILLNO,b.FDOCUMENTSTATUS from Sc_ICMOBillSub a left join AIS20200908101915zs..T_PRD_PPBOM b on a.HERPEntryID=b.FMOENTRYID where a.HEntryID=" + (EntyID).Split('-')[1], "Sc_ICMOBillSub"); + //鏌ユ壘褰撳墠鐢熶骇璁㈠崟鏄庣粏鐘舵�� + DataSet Dss = oCN.RunProcReturn("select FSTATUS from AIS20200908101915zs..T_PRD_MOENTRY_A where FENTRYID=" + (EntyID).Split('-')[1], "AIS20200908101915zs..T_PRD_MOENTRY_A"); + //鍒ゆ柇閲戣澏鐢熶骇鍗曠殑鐘舵�佷笉涓�4鍒欐墽琛屽紑宸� + if (Dss.Tables[0].Rows[0][0].ToString() != "4") + { + oCN.RunProc("update AIS20200908101915zs..T_PRD_MOENTRY_A set FSTATUS=4,FCONVEYDATE=getdate() where FENTRYID=" + (EntyID).Split('-')[1]); + } + else + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插紑宸ワ紒"; + objJsonResult.data = null; + return objJsonResult; + } + //璁块棶閲戣澏 - //var loginRet = InvokeHelper.Login(); - //var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); - //if (isSuccess == 0) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鎿嶄綔澶辫触,閲戣澏璐﹀彿鐧诲綍寮傚父銆�" + loginRet; - // objJsonResult.data = null; - // return objJsonResult; - //} - //var json = new - //{ - // //CreateOrgId = 0, - // Numbers = BillNo, - // //Ids = (EntyID).Split('-')[0], - // PkEntryIds = (EntyID).Split('-')[1] - //}; - //Console.Write("json=" + json); - //var result = InvokeHelper.ExcuteOperation("PRD_MO", "ToStart", JsonConvert.SerializeObject(json)); - //if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") - //{ - // oCN.RollBack(); - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀵瑰簲閲戣澏浜戠敓浜ц鍗曟洿鏀瑰紑宸ョ姸鎬佸け璐ワ紒" + result; - // objJsonResult.data = null; - // return objJsonResult; - //} + var loginRet = InvokeHelper.Login(); + var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); + if (isSuccess == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鎿嶄綔澶辫触,閲戣澏璐﹀彿鐧诲綍寮傚父銆�" + loginRet; + objJsonResult.data = null; + return objJsonResult; + } + var json = new + { + //CreateOrgId = 0, + //Numbers = BillNo, + Ids = Ds.Tables[0].Rows[0][0].ToString(), + //PkEntryIds = (EntyID).Split('-')[1] + }; + LogService.Write("json=" + json); + string result1 = string.Empty; + string result2 = string.Empty; + + //鍒ゆ柇褰撳墠鐢ㄧ敓浜ф枡娓呭崟鍗曠姸鎬佲�斺�斿凡鍒涘缓鍒欏厛鎻愪氦鍐嶅鏍搞�佷互鎻愪氦鍒欏彧瀹℃牳 + if (Ds.Tables[0].Rows[0][2].ToString() == "A") + { + result1 = InvokeHelper.Submit("PRD_PPBOM", JsonConvert.SerializeObject(json)); + result2 = InvokeHelper.Audit("PRD_PPBOM", JsonConvert.SerializeObject(json)); + } + if (Ds.Tables[0].Rows[0][2].ToString() == "B") + { + result2 = InvokeHelper.Audit("PRD_PPBOM", JsonConvert.SerializeObject(json)); + } + //鍒ゆ柇瀹℃牳鏄惁鎴愬姛 + if (JObject.Parse(result2)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = $"瀵瑰簲鐢熶骇鐢ㄦ枡娓呭崟,鍗曞彿{Ds.Tables[0].Rows[0][1].ToString()},瀹℃牳澶辫触锛�" + result2; + objJsonResult.data = null; + return objJsonResult; + } + + //淇濆瓨 ////鎵ц淇濆瓨 bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); if (bResult) -- Gitblit v1.9.1