派生自 MES-WEB-API
WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_DayPlanPlatFormBillController.cs
@@ -265,6 +265,9 @@ return objJsonResult; } //åæ¥æ¥è®¡åå·¥å oCN.RunProc("exec REALESE_SC_ICMOBILLSTATUS_TMP"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; @@ -304,7 +307,7 @@ if (count != 1) { //æå ¥å表 oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HEntryID," + oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ," + "HMasterDate,HQty)" + $"values({HInterID}, {(ds.Tables[0].Rows.Count + 1)}," + $" '{date}', {HQTY})"); @@ -323,7 +326,10 @@ #region æ¸ åé ææ¹å¼ public class PRD_PPBOM { /// <summary> /// æ¥è®¡åå·¥åå· /// </summary> public string HMainICMOBillNo { get; set; } /// <summary> /// æ¥è®¡åå·¥åFID /// </summary> @@ -538,6 +544,10 @@ /// </summary> public string FHMainICMOEntryID { get; set; } /// <summary> /// æ¥è®¡å订ååå·ï¼HMainICMOBillNo /// </summary> public string HMainICMOBillNo { get; set; } /// <summary> /// æ¥è®¡å订å主å ç ï¼FHICMOInterID /// </summary> public string FHICMOInterID { get; set; } @@ -643,7 +653,6 @@ { try { oCN.BeginTran(); Stopwatch sw = new Stopwatch(); omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere); string sql = $"exec JIT_qtfx {omdelMian.HProdORGID},{omdelMian.HWorkShopID},'{user}' "; @@ -653,7 +662,14 @@ DataTable resulTable = ds.Tables[0]; if (resulTable.Rows[0][0].ToString().Contains("失败")) { return resulTable.Rows[0][0].ToString(); //éæ¾é½å¥æä½ é¿å å¤äººåæ¶è¿è¡é½å¥åæ oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 "); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = resulTable.Rows[0][0].ToString(); objJsonResult.data = null; return objJsonResult; } else { @@ -664,7 +680,14 @@ string fDayPlanFEntryids = string.Empty; if (BomList.Count == 0) { return "没æéè¦è¿è¡é½å¥åæçæ°æ®"; //éæ¾é½å¥æä½ é¿å å¤äººåæ¶è¿è¡é½å¥åæ oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 "); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "没æéè¦è¿è¡é½å¥åæçæ°æ®"; objJsonResult.data = null; return objJsonResult; } else { @@ -787,6 +810,7 @@ FHStockOrgID = _item.FStockOrgId, FHPRDORGID = _item.FStockOrgId, FPRDBillNo = _item.HICMOBillNo, HMainICMOBillNo = _item.HMainICMOBillNo, FOwnerTypeId = "", FUnitDosage = _item.dwyl,//åä½ç¨é FSumPlanCount = planNeed,//计åæ»æ°é @@ -830,6 +854,7 @@ FHStockOrgID = _item.FStockOrgId, FHPRDORGID = _item.FStockOrgId, FPRDBillNo = _item.HICMOBillNo, HMainICMOBillNo = _item.HMainICMOBillNo, FOwnerTypeId = "", FUnitDosage = _item.dwyl,//åä½ç¨é FSumPlanCount = planNeed,//计åæ»æ°é @@ -881,6 +906,7 @@ FHPRDORGID = _item.FStockOrgId, FErpClsID = _item.FErpClsID, FPRDBillNo = _item.HICMOBillNo, HMainICMOBillNo = _item.HMainICMOBillNo, FOwnerTypeId = Inventory.FOwnerTypeId, FOwnerId = Inventory.FOwnerId, FUnitDosage = _item.dwyl,//åä½ç¨é @@ -924,6 +950,7 @@ FHStockOrgID = _item.FStockOrgId, FHPRDORGID = _item.FStockOrgId, FPRDBillNo = _item.HICMOBillNo, HMainICMOBillNo = _item.HMainICMOBillNo, FOwnerTypeId = "", FUnitDosage = _item.dwyl,//åä½ç¨é FSumPlanCount = planNeed,//计åæ»æ°é @@ -960,6 +987,7 @@ insertDT.Columns.Add("FUNITDOSAGE", typeof(decimal)); insertDT.Columns.Add("FSUMPLANCOUNT", typeof(decimal)); insertDT.Columns.Add("FPRDBILLNO", typeof(string)); insertDT.Columns.Add("HMainICMOBillNo", typeof(string)); insertDT.Columns.Add("FOWNERID", typeof(long)); insertDT.Columns.Add("FOWNERTYPEID", typeof(string)); insertDT.Columns.Add("FPLANDATE", typeof(DateTime)); @@ -991,6 +1019,7 @@ dr["FUNITDOSAGE"] = item.FUnitDosage; dr["FSUMPLANCOUNT"] = item.FSumPlanCount; dr["FPRDBILLNO"] = item.FPRDBillNo; dr["HMainICMOBillNo"] = item.HMainICMOBillNo; dr["FOWNERID"] = item.FOwnerId == null ? "0" : item.FOwnerId; dr["FOWNERTYPEID"] = item.FOwnerTypeId; dr["FPLANDATE"] = item.FPlanDate.ToString("yyyy-MM-dd"); @@ -1017,12 +1046,12 @@ ", HICMOEntryID, HMaterID, HStockORGID, HStockQty, HLeftQty" + ", HProdORGID, HUnitDosage, HSumPlanQty, HICMOBillNo, HOwnerID" + ", HOwnerTypeID, HPlanDate, HComplete, HLackQty, HOccupyQty" + ", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY)values" + ", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY,HMainICMOBillNo)values" + $"({item["FID"].ToString()}, 1, {item["FHMAINICMOINTERIDR"].ToString()}, {item["FHMAINICMOENTRYID"].ToString()}, {item["FHICMOINTERID"].ToString()}" + $", {item["FHICMOENTRYID"].ToString()}, {item["FHMATERID"].ToString()}, {item["FHSTOCKORGID"].ToString()}, {item["FHSTOCKQTY"].ToString()}, {item["FHLEFTQTY"].ToString()}" + $" , {item["FHPRDORGID"].ToString()}, {item["FUNITDOSAGE"].ToString()}, {item["FSUMPLANCOUNT"].ToString()}, '{item["FPRDBILLNO"].ToString()}', {item["FOWNERID"].ToString()}" + $", '{item["FOWNERTYPEID"].ToString()}', '{item["FPLANDATE"].ToString()}','{item["FCOMPLETE"].ToString()}', {item["FLACKCOUNT"].ToString()}, {item["FOCCUPYCOUNT"].ToString()}" + $", {item["FCOMPLETECOUNT1"].ToString()}, {item["FERPCLSID"].ToString()}, {item["FWORKSHOPID"].ToString()}, {item["FSTOCKID"].ToString()}, {item["FOCCUPYPICKEDCOUNT"].ToString()})"); $", {item["FCOMPLETECOUNT1"].ToString()}, {item["FERPCLSID"].ToString()}, {item["FWORKSHOPID"].ToString()}, {item["FSTOCKID"].ToString()}, {item["FOCCUPYPICKEDCOUNT"].ToString()}, '{item["HMainICMOBillNo"].ToString()}')"); } LogService.Write("æ¹éæå ¥å°æ°æ®åºç¨æ¶ï¼" + sw.Elapsed); //æ§è¡å®æå æ´æ°æ¥è®¡åå·¥åç¶æ @@ -1045,8 +1074,6 @@ sw.Stop();//ç»æè®¡æ¶ LogService.Write("é½å¥åæè¿è¡æ»æ¶é¿ï¼" + sw.Elapsed); oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "æä½æå"; @@ -1055,7 +1082,6 @@ } catch (Exception e) { oCN.RollBack(); LogService.Write("æä½å¤±è´¥ï¼" + e.Message.ToString()); objJsonResult.code = "0"; objJsonResult.count = 0;
