派生自 MES-WEB-API
WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_DayPlanPlatFormBillController.cs
@@ -41,7 +41,7 @@ omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere); ds = oCN.RunProcReturn($"exec h_p_JIT_Sc_WorkBillSortBill_Query '{omdelMian.HPlanBeginDate}',{(omdelMian.HProdORGID == null ? 0 : omdelMian.HProdORGID)},'{omdelMian.HSeOrderBillNo}'" + $",'{omdelMian.HPlanEndDate.AddDays(1).AddSeconds(-1)}',{omdelMian.HMaterID},'{omdelMian.HICMOBillNo}',{omdelMian.HWorkShopID}", "h_p_JIT_Sc_WorkBillSortBill_Query"); $",'{omdelMian.HPlanEndDate.AddDays(1)}',{omdelMian.HMaterID},'{omdelMian.HICMOBillNo}',{omdelMian.HWorkShopID}", "h_p_JIT_Sc_WorkBillSortBill_Query"); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -73,7 +73,7 @@ { if (num == 1) { ds = oCN.RunProcReturn($"select isnull(DATEDIFF(DAY,GETDATE(),CONVERT(varchar(10),max(HMasterDate),20)),0) DayNum from Sc_WorkBillSortBillSub where HInterID in ({sWhere}) and HMasterDate>=CONVERT(varchar(10),GETDATE(),20) and HLockedSub=1", "Sc_WorkBillSortBillSub"); ds = oCN.RunProcReturn($"select isnull(DATEDIFF(DAY,GETDATE(),CONVERT(varchar(10),max(HMasterDate),20))+1,0) DayNum from Sc_WorkBillSortBillSub where HInterID in ({sWhere}) and HMasterDate>=CONVERT(varchar(10),GETDATE(),20) and HLockedSub=1", "Sc_WorkBillSortBillSub"); } else if (num == 2) { @@ -187,8 +187,9 @@ var HOrderLev = list[i]["订åç级"].ToString(); var HMainSourceInterID = list[i]["æºå主å ç "].ToString(); var HMainSourceEntryID = list[i]["æºååå ç "].ToString(); var HPlanQty = list[i]["计åæ°é"].ToString(); if (HSourceID == "") if (HSourceID == ""|| HSourceID == "0") { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -197,7 +198,7 @@ return objJsonResult; } ds = oCN.RunProcReturn($"select * from Sc_WorkBillSortBillMain where HMainSourceEntryID={HMainSourceEntryID}" + ds = oCN.RunProcReturn($"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" + $" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", "Sc_WorkBillSortBillMain"); if (ds.Tables[0].Rows.Count > 0) { @@ -219,14 +220,55 @@ " HMaterID, HMaterName, HMaterModel, HUnitID, HSeOrderBillQty," + " HOrderNeedQty, HSplitQty, HDayPlanSumQty,HPlanBeginDate," + "HSeOrderBillNo,HICMOBillType,HSourceStockInQty,HLeftPlanQty,HOrderLev,HPreparatDate," + "HMainSourceInterID,HMainSourceEntryID)values" + "HMainSourceInterID,HMainSourceEntryID,HICMOInterID_Sec,HICMOEntryID_Sec,HPlanQty)values" + $"({HInterID},'{HBillNo}',{DateTime.Now.Year},{DateTime.Now.Month},'{BillType}'," + $"'{BillType}',GETDATE(),1,'{user}',getdate(),'{HICMOBillNo}','{HOrderType}'," + $"{(HICMOEntrySEQ == "" ? 0.ToString() : HICMOEntrySEQ)},{(HWorkShopID == "" ? 0.ToString() : HWorkShopID)},{(HSourceID == "" ? 0.ToString() : HSourceID)}, {(HYX == "" ? 0.ToString() : HYX)}, {(HProdORGID == "" ? 0.ToString() : HProdORGID)}," + $" {(HMaterID == "" ? 0.ToString() : HMaterID)}, '{HMaterName}', '{HMaterModel}', {(HUnitID == "" ? 0.ToString() : HUnitID)}, {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}," + $" 0, {(HSplitQty == "" ? 0.ToString() : HSplitQty)}, {(HDayPlanSumQty == "" ? 0.ToString() : HDayPlanSumQty)},'{HPlanBeginDate}'," + $"'{HSeOrderBillNo}','{HICMOBillType}',{(HSourceStockInQty == "" ? 0.ToString() : HSourceStockInQty)},{(HLeftPlanQty == "" ? 0.ToString() : HLeftPlanQty)},'{HOrderLev}',getdate()," + $"{HMainSourceInterID},{HMainSourceEntryID})"); $"{HMainSourceInterID},{HMainSourceEntryID},{HMainSourceInterID},{HMainSourceEntryID},{HPlanQty})"); } else { var HMainSourceInterID = list[i]["æºå主å ç "].ToString(); var HMainSourceEntryID = list[i]["æºååå ç "].ToString(); var HICMOBillNo = list[i]["ç产订åå·"].ToString(); var HICMOEntrySEQ = list[i]["ç产订åæç»è¡å·"].ToString(); var HSourceID = list[i]["HSourceID"].ToString(); var HYX = list[i]["ä¼å 级"].ToString(); if (HSourceID == "" || HSourceID == "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = $"第{i + 1}è¡ç产èµæºä¸è½ä¸ºç©º!"; objJsonResult.data = null; return objJsonResult; } var str = 0; if (!int.TryParse(HYX, out str)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = $"第{i + 1}è¡ä¼å 级:{HYX},请è¾å ¥æ°å!"; objJsonResult.data = null; return objJsonResult; } ds = oCN.RunProcReturn($"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" + $" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", "Sc_WorkBillSortBillMain"); if (ds.Tables[0].Rows.Count > 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = $"第{i + 1}è¡ç产èµæºæéå¤,请修æ¹!"; objJsonResult.data = null; return objJsonResult; } oCN.RunProc($"update Sc_WorkBillSortBillMain set HSourceID={(HSourceID == "" ? 0.ToString() : HSourceID)},HYX={HYX} where HInterID={list[i]["hmainid"].ToString()} and HBillNo='{list[i]["åæ®å·"].ToString()}'"); } oCN.RunProc($"update Sc_WorkBillSortBillMain set HDayPlanSumQty={list[i]["æ¥è®¡åæ°éæ»é"].ToString()} where HInterID={(HInterID==0?int.Parse(list[i]["hmainid"].ToString()):HInterID)} and HBillNo='{(HBillNo==""?list[i]["åæ®å·"].ToString(): HBillNo)}'"); @@ -482,6 +524,14 @@ /// ä»åºç¼ç /// </summary> public string FStockNumber { get; set; } /// <summary> /// æ¹å· /// </summary> public string HLOT { get; set; } /// <summary> /// id /// </summary> public string HInventoryFID { get; set; } } #endregion @@ -645,6 +695,9 @@ public string FStock { get; set; } //è½¦é´ public string FWorkShop { get; set; } //æ¹å· public string HLOT { get; set; } public string HInventoryFID { get; set; } } #endregion @@ -704,10 +757,11 @@ //è·åå½åå³æ¶åºå åºåæ°é+åºåç»ç»+ç©æ+货主+ä»åº ds = oCN.RunProcReturn(@" select distinct isnull(a.FBASEQTY,0) FBASEQTY,b.FNumber,a.FOwnerTypeId,a.FOwnerId,c.FNUMBER as FOwnerNumber,a.FSTOCKID,d.FNUMBER as FStockNumber from select distinct isnull(a.FBASEQTY,0) FBASEQTY,b.FNumber,a.FOwnerTypeId,a.FOwnerId,c.FNUMBER as FOwnerNumber,a.FSTOCKID,d.FNUMBER as FStockNumber ,a.FLOT HLOT,a.FID HInventoryFID from ( select distinct a.HProdORGID FStockOrgId,T2.FMATERIALID,FNumber from SC_WORKBILLSORTBILLMAIN a join SC_WORKBILLSORTBILLSub b on a.HInterID = b.HInterID select distinct a.HProdORGID FStockOrgId,T2.FMATERIALID,FNumber from Sc_WorkBillSortBillMain a join Sc_WorkBillSortBillSub b on a.HInterID = b.HInterID join AIS20210811135644..T_PRD_PPBOM T1 on a.HICMOInterID_Sec = t1.FMoId and a.HICMOEntryID_Sec = t1.FMOENTRYID LEFT JOIN AIS20210811135644..T_PRD_PPBOMENTRY T2 on T1.FID = t2.FID join AIS20210811135644..T_BD_MATERIAL T3 on T2.FMATERIALID = T3.FMATERIALID @@ -738,7 +792,7 @@ from ( select sum(HSourceStockInQty)FCXStockInQty,HICMOEntryID_Sec FPRDMOENTYID from SC_WORKBILLSORTBILLMAIN a --where a.HInterID IN ({0}) where a.HInterID IN ({0}) group by HICMOEntryID_Sec ) a join AIS20210811135644..T_PRD_PPBOM T1 on a.FPRDMOENTYID = t1.FMOENTRYID @@ -922,7 +976,9 @@ FComPlete = jskcQty >= need ? "é½å¥" : "æªé½å¥", FPlanDate = item.HMasterDate, // æ¥è®¡åæ¥æ FStock = Inventory.FSTOCKID,//ä»åº FWorkShop = _item.HWorkShopID //è½¦é´ FWorkShop = _item.HWorkShopID, //è½¦é´ HLOT = Inventory.HLOT, //æ¹å· HInventoryFID = Inventory.HInventoryFID //id }); //æ£åæ»åºåæ°é jskcQty = jskcQty >= fCompleteCount ? jskcQty - fCompleteCount : 0; @@ -1001,6 +1057,8 @@ insertDT.Columns.Add("FWORKSHOPID", typeof(long)); insertDT.Columns.Add("FSTOCKID", typeof(long)); insertDT.Columns.Add("FOCCUPYPICKEDCOUNT", typeof(decimal)); insertDT.Columns.Add("HLOT", typeof(long)); insertDT.Columns.Add("HInventoryFID", typeof(string)); int jdtmmm = 1; ds = oCN.RunProcReturn("select max(HInterID)FID FROM JIT_MOMaterReadysBill", "JIT_MOMaterReadysBill"); int maxFid = int.Parse(ds.Tables[0].Rows[0][0].ToString() == "" ? "0" : ds.Tables[0].Rows[0][0].ToString()); @@ -1033,6 +1091,8 @@ dr["FWORKSHOPID"] = item.FWorkShop == null ? "0" : item.FWorkShop; dr["FSTOCKID"] = item.FStock == null ? "0" : item.FStock; dr["FOCCUPYPICKEDCOUNT"] = item.FOccupyPickedCount; dr["HLOT"] = item.HLOT == null? "0" : item.HLOT; dr["HInventoryFID"] = item.HInventoryFID == null ? "0" : item.HInventoryFID; insertDT.Rows.Add(dr); jdtmmm++; } @@ -1048,12 +1108,14 @@ ", HICMOEntryID, HMaterID, HStockORGID, HStockQty, HLeftQty" + ", HProdORGID, HUnitDosage, HSumPlanQty, HICMOBillNo, HOwnerID" + ", HOwnerTypeID, HPlanDate, HComplete, HLackQty, HOccupyQty" + ", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY,HMainICMOBillNo)values" + ", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY,HMainICMOBillNo" + ",HLOT,HInventoryFID)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["HMainICMOBillNo"].ToString()}')"); $", {item["FCOMPLETECOUNT1"].ToString()}, {item["FERPCLSID"].ToString()}, {item["FWORKSHOPID"].ToString()}, {item["FSTOCKID"].ToString()}, {item["FOCCUPYPICKEDCOUNT"].ToString()}, '{item["HMainICMOBillNo"].ToString()}'" + $",{item["HLOT"].ToString()},'{item["HInventoryFID"].ToString()}')"); } LogService.Write("æ¹éæå ¥å°æ°æ®åºç¨æ¶ï¼" + sw.Elapsed); //æ§è¡å®æå æ´æ°æ¥è®¡åå·¥åç¶æ @@ -1097,15 +1159,17 @@ #region ç产æ¥è®¡åå¹³å° éå® [Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHLockedDay")] [HttpGet] public object JIT_DayPlanPlatFormBillHLockedDay(string sWhere, int HLockedDay) public object JIT_DayPlanPlatFormBillHLockedDay(int HLockedDay,int HWorkShopID) { try { if (sWhere != null && sWhere != "") { oCN.RunProc("update Sc_WorkBillSortBillSub set HLockedSub=1" + $" where HInterID in ({sWhere}) and HMasterDate between DATEADD(day, -1, getdate()) and DATEADD(day,{(HLockedDay - 1)},getdate()) "); } oCN.RunProc("update b set HLockedSub=0 from Sc_WorkBillSortBillMain a join Sc_WorkBillSortBillSub b on a.HInterID = b.HInterID " + $" where a.HWorkShopID={HWorkShopID}"); oCN.RunProc("update b set HLockedSub=1 from Sc_WorkBillSortBillMain a join Sc_WorkBillSortBillSub b on a.HInterID = b.HInterID " + $" where HMasterDate between DATEADD(day, -1, getdate()) " + $"and DATEADD(day,{(HLockedDay - 1)},getdate()) and a.HWorkShopID={HWorkShopID}"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; @@ -1126,15 +1190,13 @@ #region ç产æ¥è®¡åå¹³å° è§£é [Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHUnlockDay")] [HttpGet] public object JIT_DayPlanPlatFormBillHUnlockDay(string sWhere, int HLockedDay) public object JIT_DayPlanPlatFormBillHUnlockDay(int HWorkShopID) { try { if (sWhere != null && sWhere != "") { oCN.RunProc("update Sc_WorkBillSortBillSub set HLockedSub=0" + $" where HInterID in ({sWhere}) and HMasterDate between DATEADD(day, -1, getdate()) and DATEADD(day,{(HLockedDay - 1)},getdate()) "); } oCN.RunProc("update b set HLockedSub=0 from Sc_WorkBillSortBillMain a join Sc_WorkBillSortBillSub b on a.HInterID = b.HInterID " + $" where a.HWorkShopID={HWorkShopID}"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; @@ -1155,18 +1217,67 @@ #region ç产æ¥è®¡åå¹³å° ç产订åæ¥è¯¢ [Route("JIT_DayPlanPlatFormBill/JIT_ICMOBillList")] [HttpGet] public object JIT_ICMOBillList(string hmainid, string HEntryID) public object JIT_ICMOBillList(string hmainid) { try { var list = hmainid.Split(','); List<DataTable> listdt = new List<DataTable>(); DataTable dtable = new DataTable("dt"); for (int i = 0; i < list.Length; i++) { var listEvery = list[i].Split('_'); ds = oCN.RunProcReturn($"exec h_p_ICMOBillList_PrimarySubTable '{listEvery[0]}','{listEvery[1]}'", "h_p_ICMOBillList_PrimarySubTable"); oCN.RunProc("exec h_p_ICMOBillList_PrimarySubTable"); ds = oCN.RunProcReturn($"select * from ##ICMOBillList where æºå主å ç in({hmainid}) and æºååå ç in({HEntryID})", "##ICMOBillList"); var dt = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBillList where æºå主å ç in({ds.Tables[0].Rows[0]["æºå主å ç "].ToString()}) and æºååå ç in({ds.Tables[0].Rows[0]["æºååå ç "].ToString()})", "h_v_JIT_Sc_WorkBillSortBillList"); if (dt.Tables[0].Rows.Count > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ç产æç»è¡éå¤,éå¤çç产订åå·:" + ds.Tables[0].Rows[i]["ç产订åå·"].ToString() + ",æç»è¡å·:" + ds.Tables[0].Rows[i]["ç产订åæç»è¡å·"].ToString(); objJsonResult.data = null; return objJsonResult; } if (i == 0) { //æ·»å åå for (int j = 0; j < ds.Tables[0].Columns.Count; j++) { dtable.Columns.Add(ds.Tables[0].Columns[j].ToString()); } } listdt.Add(ds.Tables[0]); } //è·åéåæ°æ® for (int i = 0; i < listdt.Count; i++) { DataRow row = dtable.NewRow(); for (int j = 0; j < listdt[i].Columns.Count; j++) { if (listdt[i].Columns[j].ColumnName == "计åæ°é") { row[j] = double.Parse(listdt[i].Rows[0][j].ToString()).ToString(); } else { row[j] = listdt[i].Rows[0][j].ToString(); } } dtable.Rows.Add(row); } //æ·»å å¨ææ¥æ for (int j = 1; j <= 31; j++) { dtable.Columns.Add(DateTime.Now.AddDays(j - 1).ToString("yyyy-MM-dd"), typeof(Int32)); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.data = dtable; return objJsonResult; } catch (Exception e)
