From 3552bcc7bc07052a80dce7fc3933d71ec6748341 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期一, 05 六月 2023 11:23:40 +0800
Subject: [PATCH] 提料运算
---
WebAPI/Controllers/SCGL/日计划管理/JIT_DayPlanPlatFormBillController.cs | 822 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 822 insertions(+), 0 deletions(-)
diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs"
index 5118795..d5eff85 100644
--- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs"
+++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs"
@@ -1156,6 +1156,828 @@
}
#endregion
+
+ #region 鐢熶骇鏃ヨ鍒掑钩鍙� 鎻愭枡杩愮畻
+
+ #region 鏃ヨ鍒掑睍寮�鏁版嵁鏄庣粏
+ public class DayPlanPpbom
+ {
+
+ /// <summary>
+ /// 鏃ヨ鍒掑伐鍗曚富ID
+ /// </summary>
+ public long FID { get; set; }
+ /// <summary>
+ /// 鐢熶骇璁㈠崟鍙�
+ /// </summary>
+ public string FBILLNO { get; set; }
+ /// <summary>
+ /// 鏃ヨ鍒掓槑缁嗘棩鏈�
+ /// </summary>
+ public DateTime FHMASTERDATE { get; set; }
+ /// <summary>
+ /// 鏃ヨ鍒掓槑缁嗘暟閲�
+ /// </summary>
+ public decimal FHQTY { get; set; }
+ /// <summary>
+ /// 榻愬鏁�
+ /// </summary>
+ public decimal FCOMPLETECOUNT { get; set; }
+ /// <summary>
+ /// 鐢熶骇璁㈠崟宸ュ崟ID
+ /// </summary>
+ public long FPRDMOMAINID { get; set; }
+ /// <summary>
+ /// 瀛愯〃ID
+ /// </summary>
+ public int FENTRYID { get; set; }
+ /// <summary>
+ /// 鍗曚綅鐢ㄦ枡
+ /// </summary>
+ public decimal FNeedQty { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ public string FMATERIALID { get; set; }
+ /// <summary>
+ /// 鎻愬墠澶╂暟
+ /// </summary>
+ public int FFIXLEADTIME { get; set; }
+ /// <summary>
+ ///鏈�澶у寘瑁�
+ /// </summary>
+ public decimal FMAXPOQTY { get; set; }
+ /// <summary>
+ /// 鏈�灏忓寘瑁呴噺
+ /// </summary>
+ public decimal FMINPOQTY { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ public string FNumber { get; set; }
+ /// <summary>
+ /// 瀹為檯闇�姹�
+ /// </summary>
+ public decimal NeedQty { get; set; }
+
+ /// <summary>
+ /// 搴撳瓨缁勭粐
+ /// </summary>
+ public long FStockOrgId { get; set; }
+ /// <summary>
+ /// jit鐗╂枡鍒嗙被
+ /// </summary>
+ public string FJITmaterialGroup { get; set; }
+ /// <summary>
+ /// JIT鐗╂枡闇�姹備緵璐у懆鏈�
+ /// </summary>
+ public string FJITMaterielDemand { get; set; }
+ /// <summary>
+ /// JIT瀹夊叏搴撳瓨
+ /// </summary>
+ public string FJITSafeStock { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡灞炴��
+ /// </summary>
+ public string FErpClsID { get; set; }
+ /// <summary>
+ /// 闇�姹傚崟鍙凤紙閿�鍞鍗曞彿锛�
+ /// </summary>
+ public string FXQD { get; set; }
+ /// <summary>
+ /// 鏃ヨ鍒掑伐鍗曞崟鍙�
+ /// </summary>
+ public string FDAYPLANBILLNO { get; set; }
+ /// <summary>
+ /// 鐢熶骇杞﹂棿缂栫爜
+ /// </summary>
+ public string FWORKSHOPNUMBER { get; set; }
+
+
+ }
+ #endregion
+
+ #region 閲囪喘璁㈠崟鐗╂枡搴撳瓨
+ public class PurchaseInventory
+ {
+ /// <summary>
+ /// 閲囪喘FID
+ /// </summary>
+ public long FID { get; set; }
+ //閲囪喘璁㈠崟鍗曞彿
+ public string FBillNo { get; set; }
+ /// <summary>
+ /// 閲囪喘瀛愯〃鏍囪瘑
+ /// </summary>
+ public long FENTRYID { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟唅d
+ /// </summary>
+ public long FSUPPLIERID { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗗悕绉�
+ /// </summary>
+ public string FNUMBER { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ public string FMATERIALID { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ public string FMATERIALNUMBER { get; set; }
+
+ /// <summary>
+ /// 閲囪喘鏁伴噺
+ /// </summary>
+ public decimal FQTY { get; set; }
+
+ /// <summary>
+ /// 閲囪喘缁勭粐
+ /// </summary>
+ public long FStockOrgId { get; set; }
+ /// <summary>
+ /// 缁勭粐缂栫爜
+ /// </summary>
+ public string FORGNumber { get; set; }
+ /// <summary>
+ /// 鎻愬墠鏈�
+ /// </summary>
+ public int FFIXLEADTIME { get; set; }
+
+ /// <summary>
+ /// 闇�姹傚崟鍙�
+ /// </summary>
+ public string FXQD { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟涓婄殑鍒涘缓浜�
+ /// </summary>
+ public string FCREATORID { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟涓婄殑鍒涘缓浜哄悕绉�
+ /// </summary>
+ public string FName { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟涓婄殑閲囪喘鏃ユ湡
+ /// </summary>
+ public DateTime FDate { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟涓婄殑浜よ揣鏃ユ湡
+ /// </summary>
+ public DateTime FDeliveryDate { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛ㄥご鎽樿
+ /// </summary>
+ public string F_QIMB_NOTE { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛ㄤ綋澶囨敞
+ /// </summary>
+ public string FNOTE { get; set; }
+ //閲囪喘閮ㄩ棬
+ public string FPURCHASEDEPTNUMBER { get; set; }
+
+ /// <summary>
+ /// 鏀舵枡浣嗘槸娌″叆搴撻儴鍒� 闇�瑕佷紭鍏堝幓鎵ｉ櫎
+ /// </summary>
+ public decimal FReceiveNotInQty { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟鏁伴噺
+ /// </summary>
+ public decimal FPURCHASEQTY { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟鍏宠仈鏁伴噺
+ /// </summary>
+ public decimal FJOINQTY { get; set; }
+
+ /// <summary>
+ /// 鏀舵枡鍗曟暟閲�
+ /// </summary>
+ public decimal FReceiveQty { get; set; }
+ }
+ #endregion
+
+ #region 鎻愭枡璁″垝涓存椂鍌ㄥ瓨
+ public class PODemandPlanTemp
+ {
+ /// <summary>
+ /// 鏃ヨ鍒掑伐鍗曚富ID
+ /// </summary>
+ public long FID { get; set; }
+ /// <summary>
+ /// 鏃ヨ鍒掑伐鍗曠紪鍙�
+ /// </summary>
+ public string FBILLNO { get; set; }
+ /// <summary>
+ /// 鏃ヨ鍒掓槑缁嗘棩鏈�
+ /// </summary>
+ public DateTime FHMASTERDATE { get; set; }
+ /// <summary>
+ /// 鏃ヨ鍒掓槑缁嗘暟閲�
+ /// </summary>
+ public decimal FHQTY { get; set; }
+ /// <summary>
+ /// 鐢熶骇璁㈠崟宸ュ崟ID
+ /// </summary>
+ public long FPRDMOMAINID { get; set; }
+ /// <summary>
+ /// 瀛愯〃ID
+ /// </summary>
+ public int FENTRYID { get; set; }
+ /// <summary>
+ /// 鏁伴噺
+ /// </summary>
+ public decimal FQty { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ public string FMATERIALID { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ public string FNumber { get; set; }
+
+ /// <summary>
+ /// 閲囪喘FID
+ /// </summary>
+ public long PurchseFID { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟鍗曞彿
+ /// </summary>
+ public string PurchseFBillNo { get; set; }
+ /// <summary>
+ /// 閲囪喘瀛愯〃鏍囪瘑
+ /// </summary>
+ public long PurchseFentryID { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟唅d
+ /// </summary>
+ public long FSUPPLIERID { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗗悕绉�
+ /// </summary>
+ public string PurchseFNUMBER { get; set; }
+
+ /// <summary>
+ /// 鏃ヨ鍒掓棩鏈�
+ /// </summary>
+ public DateTime OLDDATE { get; set; }
+
+ /// <summary>
+ /// 閲囪喘璁㈠崟鏁伴噺
+ /// </summary>
+ public decimal PurchseFqty { get; set; }
+
+ /// <summary>
+ /// 鎻愬墠鏈�
+ /// </summary>
+ public double FFIXLEADTIME { get; set; }
+
+ /// <summary>
+ /// 閲囪喘缁勭粐
+ /// </summary>
+ public long FStockOrgId { get; set; }
+ /// <summary>
+ /// 缁勭粐缂栫爜
+ /// </summary>
+ public string FORGNumber { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡灞炴��
+ /// </summary>
+ public string FErpClsID { get; set; }
+
+ /// <summary>
+ /// 闇�姹傚崟鍙�
+ /// </summary>
+ public string FXQD { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟涓婄殑鍒涘缓浜�
+ /// </summary>
+ public string FCREATORID { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟涓婄殑鍒涘缓浜哄悕绉�
+ /// </summary>
+ public string FName { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟涓婄殑閲囪喘鏃ユ湡
+ /// </summary>
+ public DateTime FDate { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟涓婄殑浜よ揣鏃ユ湡
+ /// </summary>
+ public DateTime FDeliveryDate { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛ㄥご鎽樿
+ /// </summary>
+ public string F_QIMB_NOTE { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛ㄤ綋澶囨敞
+ /// </summary>
+ public string FNOTE { get; set; }
+
+ /// <summary>
+ /// 閲囪喘閮ㄩ棬
+ /// </summary>
+ public string FPURCHASEDEPTNUMBER { get; set; }
+ /// <summary>
+ /// 鏃ヨ鍒掑伐鍗曞崟鍙�
+ /// </summary>
+ public string FDAYPLANBILLNO { get; set; }
+ /// <summary>
+ /// 鐢熶骇杞﹂棿缂栫爜
+ /// </summary>
+ public string FWORKSHOPNUMBER { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟鏁伴噺
+ /// </summary>
+ public decimal FPURCHASEQTY { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟鍏宠仈鏁伴噺
+ /// </summary>
+ public decimal FJOINQTY { get; set; }
+ }
+ #endregion
+
+ [Route("JIT_DayPlanPlatFormBill/JIT_TLYS")]
+ [HttpGet]
+ public object JIT_TLYS(string sWhere, string user)
+ {
+ try
+ {
+ omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);
+
+ DataSet DaSet = oCN.RunProcReturn($"select * from JIT_MOMaterReadysBill where HWorkShopID={omdelMian.HWorkShopID} and HProdORGID={omdelMian.HProdORGID}", "JIT_MOMaterReadysBill");
+
+ if (DaSet.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁鏁版嵁,璇峰厛榻愬鍒嗘瀽!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ string fProWorkShopId = omdelMian.HWorkShopID.ToString();
+ var fPrdOrgId = omdelMian.HProdORGID;
+
+ LogService.Write($"鎻愭枡璁″垝閲嶇畻 杞﹂棿锛歿fProWorkShopId}锛岀粍缁囷細{fPrdOrgId}");
+ Stopwatch sw = new Stopwatch();
+
+ sw.Start();//寮�濮嬭鏃�
+ //鎻愭枡璁″垝棰勫鐞� 娓呯悊鎻愭枡璁″垝鍗曟暟鎹� 鏇存柊閲囪喘璁㈠崟鎻愭枡璁″垝鏁伴噺 骞朵笖鏌ヨ鍑洪渶瑕佽繘琛岃繍绠楃殑鏁版嵁
+
+ oCN.BeginTran(); //寮�濮嬩簨鍔�
+
+ ds = oCN.RunProcReturn($"exec h_p_PROC_JIT_TLPLANYCL '{fProWorkShopId}','{fPrdOrgId}'", "h_p_PROC_JIT_TLPLANYCL");
+ List<DayPlanPpbom> DayPlanPpbom = ds.ToModelList<DayPlanPpbom>();
+
+ if (DayPlanPpbom.Count == 0)
+ {
+ oCN.RollBack();//鍥炴粴浜嬪姟
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犳暟鎹繍绠�!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ //閲囪喘璁㈠崟鏁版嵁 锛堝墿浣欐敹鏂欐暟閲忥級
+
+ //t2.FXQD t2.FSTOCKINQTY,t2.FReceiveQty 鏈湴娌℃湁杩欎簺瀛楁
+ string sql = string.Format(@"
+ /*dialect*/
+select t4.FSTOCKINQTY,t4.FReceiveQty,t1.FID,t1.FBillNo,t2.FENTRYID,t1.FSUPPLIERID,t3.fnumber,t2.FMATERIALID,(t4.FREMAINRECEIVEQTY-t2.FPODemandPlanCount)FQTY
+,FPurchaseOrgId FStockOrgId,t5.FNUMBER FORGNumber,FCloseStatus,FMRPCLOSESTATUS,FPURCHASEDEPTID,t7.FNUMBER as FPURCHASEDEPTNUMBER
+,t1.FCREATORID,t8.FName ,t1.FDate,tD.FDeliveryDate,t2.FNOTE,(t4.FReceiveQty - t4.FSTOCKINQTY) as FReceiveNotInQty,'' FXQD,T2.FQTY AS FPURCHASEQTY,FJOINQTY,
+isnull((select top 1 HLeadTime + HLeadTime_Sec from Cg_PODemandPlanConfigBillMain a
+join Cg_PODemandPlanConfigBillSub b on a.HInterID =b.HInterID
+left join Xt_ORGANIZATIONS o on a.HOrgID=o.HItemID
+left join Gy_Supplier s on b.HSupplierID=s.HItemID
+ where o.HNumber = t5.FNUMBER and s.HNumber = t3.FNUMBER), 0)FFIXLEADTIME
+from AIS20210811135644..t_PUR_POOrder t1
+join AIS20210811135644..t_PUR_POOrderEntry t2 on t1.FID = t2.FID
+join AIS20210811135644..t_BD_Supplier t3 on t1.FSUPPLIERID = t3.FSUPPLIERID
+join AIS20210811135644..T_PUR_POORDERENTRY_R t4 on t2.FENTRYID = t4.FENTRYID
+join AIS20210811135644..T_PUR_POORDERENTRY_D tD on t2.FENTRYID = tD.FENTRYID
+join AIS20210811135644..T_ORG_Organizations t5 on t1.FPurchaseOrgId = t5.FORGID
+join AIS20210811135644..T_SEC_user t8 on t1.FCREATORID = t8.FuserId
+join AIS20210811135644..T_BD_DEPARTMENT T7 ON t1.FPURCHASEDEPTID = T7.FDEPTID
+where t4.FREMAINRECEIVEQTY-t2.FPODemandPlanCount>0
+and FCloseStatus in('A') and FMRPCLOSESTATUS in('A')
+and t1.FBillTypeID in('83d822ca3e374b4ab01e5dd46a0062bd','6d01d059713d42a28bb976c90a121142')
+and FPurchaseOrgId = '{0}'
+", fPrdOrgId);
+
+ ds = oCN.RunProcReturn(sql, "PurchaseInventoryList");
+
+ if (ds.Tables[0].Rows.Count == 0) {
+ oCN.RollBack();//鍥炴粴浜嬪姟
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏌ユ棤閲囪喘璁㈠崟鏁版嵁!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ List<PurchaseInventory> PurchaseInventory = ds.ToModelList<PurchaseInventory>();
+ //鐗╂枡+搴撳瓨缁勭粐鍒嗙被
+ var MaterialIDList = DayPlanPpbom.GroupBy(p => new { p.FMATERIALID, p.FStockOrgId }).Select(x => new PODemandPlanTemp { FMATERIALID = x.Key.FMATERIALID, FStockOrgId = x.Key.FStockOrgId }).ToList();
+
+ //鎻愭枡璁″垝鏁版嵁闆嗕复鏃跺瓨鍌ㄩ泦鍚�
+ List<PODemandPlanTemp> PODemandPlanTemp = new List<PODemandPlanTemp>();
+ //sql闆嗗悎 鏇存柊閲囪喘璁㈠崟鍗犵敤鐨勬彁鏂欒鍒掓暟閲�
+ List<string> sqlList = new List<string>();
+
+ foreach (var item in MaterialIDList)
+ {
+ //this.View.Session["ProcessRateValue"] = Convert.ToInt32((Convert.ToDecimal(75) / MaterialIDList.Count) * i);
+ //褰撳墠鐗╂枡鍜屽簱瀛樼粍缁囧搴旂殑闇�杩涜鎻愭枡璁″垝鐨勬暟鎹�
+ List<DayPlanPpbom> _DayPlanPpbom = DayPlanPpbom.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId).ToList();
+ decimal NeedQty = 0;
+ foreach (var _item in _DayPlanPpbom)
+ {
+ //鏌ヨ鏈夋病鏈夊彲浠ョ敤浜庢彁鏂欑殑閲囪喘璁㈠崟鏁版嵁
+ var _PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x => x.FENTRYID).ToList();
+ if (_PurchaseInventory.Count == 0)
+ {
+ //鏃犻噰璐鍗曠洿鎺ヤ笅涓�涓墿鏂�
+ sql = $"INSERT INTO JIT_TLPLANERROR(HROGID,HUSERID,HWORKSHOPID,HDAYPLANID,HDAYPLANENTRYID,HMATERIALID,HQTY,HTYPE) VALUES({fPrdOrgId},{user},{fProWorkShopId},{_item.FID},{_item.FENTRYID},{_item.FMATERIALID},{_item.NeedQty},0) ";
+ sqlList.Add(sql);
+ break;
+ }
+ //闇�姹傛暟閲�
+ NeedQty = _item.NeedQty;
+ //澧炲姞涓�涓攢鍞鍗曞彿鍖归厤鐨勯�昏緫 浼樺厛寰幆
+ var PurchaseInventoryBySalOrder = _PurchaseInventory.Where(x => x.FXQD == _item.FXQD).OrderBy(x => x.FENTRYID).ToList();
+ if (PurchaseInventoryBySalOrder.Count > 0)
+ {
+ foreach (var Purchase in PurchaseInventoryBySalOrder)
+ {
+ double _FFIXLEADTIME = Purchase.FFIXLEADTIME;//鎻愬墠鏈�
+ DateTime _DATE = Convert.ToDateTime(_item.FHMASTERDATE).AddDays(-_FFIXLEADTIME);
+ if (Purchase.FQTY >= NeedQty)
+ {
+ PODemandPlanTemp.Add(new PODemandPlanTemp
+ {
+ FID = _item.FID,
+ FHMASTERDATE = _DATE,
+ FQty = NeedQty,
+ FBILLNO = _item.FBILLNO,
+ FENTRYID = _item.FENTRYID,
+ FMATERIALID = _item.FMATERIALID,
+ FNumber = _item.FNumber,
+ OLDDATE = _item.FHMASTERDATE,
+ FFIXLEADTIME = _FFIXLEADTIME,
+ FErpClsID = _item.FErpClsID,
+ FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
+ FDAYPLANBILLNO = _item.FDAYPLANBILLNO,
+
+ PurchseFentryID = Purchase.FENTRYID,
+ FSUPPLIERID = Purchase.FSUPPLIERID,
+ PurchseFNUMBER = Purchase.FNUMBER,
+ PurchseFBillNo = Purchase.FBillNo,
+ PurchseFqty = Purchase.FQTY,
+ FStockOrgId = Purchase.FStockOrgId, //閲囪喘缁勭粐
+ FORGNumber = Purchase.FORGNumber,
+ FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
+
+ FXQD = _item.FXQD,
+ FCREATORID = Purchase.FCREATORID,
+ FName = Purchase.FName,
+ FDate = Purchase.FDate,
+ FDeliveryDate = Purchase.FDeliveryDate,
+ F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
+ FNOTE = Purchase.FNOTE,
+ FPURCHASEQTY = Purchase.FPURCHASEQTY,
+ FJOINQTY = Purchase.FJOINQTY
+
+ });
+ //鎵ｉ櫎鏃ヨ鍒掓槑缁嗗凡琚垎閰嶇殑鏁伴噺
+ _item.NeedQty = 0;
+ //鎵ｉ櫎褰撳墠琛屽搴旈噰璐鍗曟暟閲�
+ Purchase.FQTY -= NeedQty;
+ //鏇存柊閲囪喘璁㈠崟
+ //sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
+ //闇�姹傛暟閲忓彉涓�0
+ NeedQty = 0;
+ break;
+ }
+ else//閲囪喘璁㈠崟鏁版嵁涓嶈兘婊¤冻璁㈠崟鎵�闇�鏁伴噺
+ {
+ //閲囪喘璁㈠崟鏁伴噺
+ decimal _NeedQty = Purchase.FQTY;
+ PODemandPlanTemp.Add(new PODemandPlanTemp
+ {
+ FID = _item.FID,
+ FHMASTERDATE = _DATE,
+ FQty = _NeedQty,
+ FBILLNO = _item.FBILLNO,
+ FENTRYID = _item.FENTRYID,
+ FMATERIALID = _item.FMATERIALID,
+ FNumber = _item.FNumber,
+ OLDDATE = _item.FHMASTERDATE,
+ FFIXLEADTIME = _FFIXLEADTIME,
+ FErpClsID = _item.FErpClsID,
+ FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
+ FDAYPLANBILLNO = _item.FDAYPLANBILLNO,
+
+ PurchseFentryID = Purchase.FENTRYID,
+ FSUPPLIERID = Purchase.FSUPPLIERID,
+ PurchseFNUMBER = Purchase.FNUMBER,
+ PurchseFBillNo = Purchase.FBillNo,
+ PurchseFqty = Purchase.FQTY,
+ FStockOrgId = Purchase.FStockOrgId, //閲囪喘缁勭粐
+ FORGNumber = Purchase.FORGNumber,
+ FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
+
+ FXQD = _item.FXQD,
+ FCREATORID = Purchase.FCREATORID,
+ FName = Purchase.FName,
+ FDate = Purchase.FDate,
+ FDeliveryDate = Purchase.FDeliveryDate,
+ F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
+ FNOTE = Purchase.FNOTE,
+ FPURCHASEQTY = Purchase.FPURCHASEQTY,
+ FJOINQTY = Purchase.FJOINQTY
+ });
+ //鏇存柊閲囪喘璁㈠崟
+ //sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Purchase.FQTY}' where FENTRYID = {Purchase.FENTRYID}");
+ //鏇存柊璁㈠崟闇�姹傛暟閲�
+ NeedQty = NeedQty - Purchase.FQTY;
+ //鎵ｉ櫎鏃ヨ鍒掓槑缁嗗凡琚垎閰嶇殑鏁伴噺
+ _item.NeedQty -= _NeedQty;
+ //鎵ｉ櫎褰撳墠琛屽搴旈噰璐鍗曟暟閲�
+ Purchase.FQTY = 0;
+ }
+ }
+ }
+ if (NeedQty == 0)
+ continue;
+ var PurchaseInventoryElse = _PurchaseInventory.Where(x => x.FXQD != _item.FXQD).OrderBy(x => x.FENTRYID).ToList();
+ foreach (var Purchase in PurchaseInventoryElse)
+ {
+ double _FFIXLEADTIME = Purchase.FFIXLEADTIME;//鎻愬墠鏈�
+ DateTime _DATE = Convert.ToDateTime(_item.FHMASTERDATE).AddDays(-_FFIXLEADTIME);
+ if (Purchase.FQTY >= NeedQty)
+ {
+ PODemandPlanTemp.Add(new PODemandPlanTemp
+ {
+ FID = _item.FID,
+ FHMASTERDATE = _DATE,
+ FQty = _item.NeedQty,
+ FBILLNO = _item.FBILLNO,
+ FENTRYID = _item.FENTRYID,
+ FMATERIALID = _item.FMATERIALID,
+ FNumber = _item.FNumber,
+ OLDDATE = _item.FHMASTERDATE,
+ FFIXLEADTIME = _FFIXLEADTIME,
+ FErpClsID = _item.FErpClsID,
+ FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
+ FDAYPLANBILLNO = _item.FDAYPLANBILLNO,
+
+ PurchseFentryID = Purchase.FENTRYID,
+ FSUPPLIERID = Purchase.FSUPPLIERID,
+ PurchseFNUMBER = Purchase.FNUMBER,
+ PurchseFBillNo = Purchase.FBillNo,
+ PurchseFqty = Purchase.FQTY,
+ FStockOrgId = Purchase.FStockOrgId, //閲囪喘缁勭粐
+ FORGNumber = Purchase.FORGNumber,
+ FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
+
+ FXQD = _item.FXQD,
+ FCREATORID = Purchase.FCREATORID,
+ FName = Purchase.FName,
+ FDate = Purchase.FDate,
+ FDeliveryDate = Purchase.FDeliveryDate,
+ F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
+ FNOTE = Purchase.FNOTE,
+ FPURCHASEQTY = Purchase.FPURCHASEQTY,
+ FJOINQTY = Purchase.FJOINQTY
+ });
+ //鏇存柊閲囪喘璁㈠崟
+ //sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
+ //鎵ｉ櫎鏃ヨ鍒掓槑缁嗗凡琚垎閰嶇殑鏁伴噺
+ _item.NeedQty = 0;
+ //鎵ｉ櫎褰撳墠琛屽搴旈噰璐鍗曟暟閲�
+ Purchase.FQTY -= NeedQty;
+ //闇�姹傛暟閲忓彉涓�0
+ NeedQty = 0;
+ break;
+ }
+ else//閲囪喘璁㈠崟鏁版嵁涓嶈兘婊¤冻璁㈠崟鎵�闇�鏁伴噺
+ {
+ //鏇存柊鎬婚渶姹傛暟閲�
+ NeedQty = NeedQty - Purchase.FQTY;
+ //閲囪喘璁㈠崟鏁伴噺
+ decimal _NeedQty = Purchase.FQTY;
+ PODemandPlanTemp.Add(new PODemandPlanTemp
+ {
+ FID = _item.FID,
+ FHMASTERDATE = _DATE,
+ FQty = _NeedQty,
+ FBILLNO = _item.FBILLNO,
+ FENTRYID = _item.FENTRYID,
+ FMATERIALID = _item.FMATERIALID,
+ FNumber = _item.FNumber,
+ OLDDATE = _item.FHMASTERDATE,
+ FFIXLEADTIME = _FFIXLEADTIME,
+ FErpClsID = _item.FErpClsID,
+ FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
+ FDAYPLANBILLNO = _item.FDAYPLANBILLNO,
+
+ PurchseFentryID = Purchase.FENTRYID,
+ FSUPPLIERID = Purchase.FSUPPLIERID,
+ PurchseFNUMBER = Purchase.FNUMBER,
+ PurchseFBillNo = Purchase.FBillNo,
+ PurchseFqty = Purchase.FQTY,
+ FStockOrgId = Purchase.FStockOrgId, //閲囪喘缁勭粐
+ FORGNumber = Purchase.FORGNumber,
+ FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
+
+ FXQD = _item.FXQD,
+ FCREATORID = Purchase.FCREATORID,
+ FName = Purchase.FName,
+ FDate = Purchase.FDate,
+ FDeliveryDate = Purchase.FDeliveryDate,
+ F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
+ FNOTE = Purchase.FNOTE,
+ FPURCHASEQTY = Purchase.FPURCHASEQTY,
+ FJOINQTY = Purchase.FJOINQTY
+ });
+ //鏇存柊閲囪喘璁㈠崟
+ //sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Purchase.FQTY}' where FENTRYID = {Purchase.FENTRYID}");
+ //鎵ｉ櫎鏃ヨ鍒掓槑缁嗗凡琚垎閰嶇殑鏁伴噺
+ _item.NeedQty -= _NeedQty;
+ //鎵ｉ櫎褰撳墠琛屽搴旈噰璐鍗曟暟閲�
+ Purchase.FQTY = 0;
+ }
+ }
+ if (NeedQty > 0)
+ {
+ sql = $"INSERT INTO JIT_TLPLANERROR(HROGID,HUSERID,HWORKSHOPID,HDAYPLANID,HDAYPLANENTRYID,HMATERIALID,HQTY,HTYPE,HERRORTYPE) VALUES({fPrdOrgId},{user},{fProWorkShopId},{_item.FID},{_item.FENTRYID},{_item.FMATERIALID},{NeedQty},0,1) ";
+ sqlList.Add(sql);
+ }
+ }
+ }
+
+ //渚涘簲鍟嗭紝鎻愭枡鏃ユ湡锛岀敓浜ц溅闂达紝閲囪喘鍛� 鍒嗙粍
+ var PODemandPlanList = PODemandPlanTemp.GroupBy(p => new { p.PurchseFNUMBER, p.FHMASTERDATE, p.FWORKSHOPNUMBER, p.FCREATORID }).Select(x => new PODemandPlanTemp { PurchseFNUMBER = x.Key.PurchseFNUMBER, FHMASTERDATE = x.Key.FHMASTERDATE, FWORKSHOPNUMBER = x.Key.FWORKSHOPNUMBER, FCREATORID = x.Key.FCREATORID }).ToList();
+
+ LogService.Write("鎻愭枡璁″垝閲嶇畻 锛屾暟鎹噯澶囧畬鎴愶紝淇濆瓨鍒癕odel瀹炰綋 鐢ㄦ椂锛�" + sw.Elapsed + "鎬昏鏁帮細" + PODemandPlanTemp.Count);
+
+ int tlmmm = 0;
+ JArray FinalyResult = new JArray();
+ foreach (var item in PODemandPlanList)
+ {
+ tlmmm++;
+
+ DateTime date = item.FHMASTERDATE;
+ long HSettleCurrId = 1;//璐у竵 榛樿鏈湴浜烘皯甯�
+
+ var dataSup= oCN.RunProcReturn(@"select * from Gy_Supplier p
+ inner join AIS20210811135644..t_BD_Supplier fp on p.HNumber=fp.FNUMBER and p.HUSEORGID=fp.FUSEORGID
+ where FNUMBER='" + item.PurchseFNUMBER + "' and HUSEORGID ='"+ fPrdOrgId + "'", "Gy_Supplier");
+ long HSupplierID = dataSup.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataSup.Tables[0].Rows[0]["HItemID"].ToString()); //渚涘簲鍟�
+
+ var dataUser = oCN.RunProcReturn("select Czymc from gy_czygl where Czybm = '" + user + "'", "gy_czygl");
+ string HMaker = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//鍒跺崟浜�
+ string HUpDater = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//淇敼浜�
+
+ var dataOrg= oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
+ inner join AIS20210811135644..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
+ where FNUMBER='" + PODemandPlanTemp[0].FORGNumber + "' and HItemID ='" + fPrdOrgId + "'", "Xt_ORGANIZATIONS");
+ long HPURCHASEORGID = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); //閲囪喘缁勭粐
+
+ string PurchseFNUMBER = item.PurchseFNUMBER;
+ string FWorkshopNumber = item.FWORKSHOPNUMBER;
+ string FCreatorID = item.FCREATORID;
+
+ var HInterID= DBUtility.ClsPub.CreateBillID("4608", ref DBUtility.ClsPub.sExeReturnInfo);
+ var HBillNo = DBUtility.ClsPub.CreateBillCode("4608", ref DBUtility.ClsPub.sExeReturnInfo, true);
+ //涓昏〃
+ oCN.RunProc("insert into JIT_Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" +
+ ",HBillSubType,HDate,HBillStatus,HMaker,HMakeDate" +
+ ",HSubORGID ,HAddress,HPURCHASEORGID,HSupplierID ,HSettleCurrId" +
+ ",HRemark,HExplanation,HUpDater,HUpDateDate)" +
+ $"values({HInterID}, '{HBillNo}', {DateTime.Now.Year}, {DateTime.Now.Month}, '4608'" +
+ $", '4608','{date}',1, '{HMaker}',GETDATE()," +
+ $"{HPURCHASEORGID},'',{HPURCHASEORGID}, {HSupplierID}, {HSettleCurrId}" +
+ $",'','','{HUpDater}',getdate())");
+
+ JArray Fentity = new JArray();
+ List<PODemandPlanTemp> _PODemandPlanList = PODemandPlanTemp.Where(x => x.FHMASTERDATE == date && x.PurchseFNUMBER == PurchseFNUMBER && x.FWORKSHOPNUMBER == FWorkshopNumber && x.FCREATORID == FCreatorID).ToList();
+ int i = 0;
+ foreach (var _item in _PODemandPlanList)
+ {
+ i++;
+
+ var dataSet = oCN.RunProcReturn(@"select m.* from Gy_Material m
+ inner join AIS20210811135644..T_BD_MATERIAL fm on m.HNumber = fm.FNUMBER and m.HUSEORGID=fm.FUSEORGID
+ where FNUMBER='" + _item.FNumber + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Material");
+ string HMaterID = "0"; //鐗╂枡
+ string HMaterModel = ""; //鐗╂枡浠ｇ爜
+ string HMaterName = ""; //鐗╂枡鍚嶇О
+ if (dataSet.Tables[0].Rows.Count != 0)
+ {
+ HMaterID = dataSet.Tables[0].Rows[0]["HItemID"].ToString(); //鐗╂枡
+ HMaterModel = dataSet.Tables[0].Rows[0]["HNumber"].ToString(); //鐗╂枡浠ｇ爜
+ HMaterName = dataSet.Tables[0].Rows[0]["HName"].ToString(); //鐗╂枡鍚嶇О
+ }
+
+ decimal HQty = _item.FQty; //鏁伴噺
+ long HSourceInterID = _item.FID; //鏃ヨ鍒掑伐鍗旻ID
+ long HSourceEntryID = _item.FENTRYID;//鏃ヨ鍒掑伐鍗旻ENTRYID
+ string HSourceBillNo = _item.FBILLNO; //鐢熶骇璁㈠崟鍙�
+ string HSourceBillType = ""; //鏃ヨ鍒掑伐鍗曠被鍨�
+ DateTime HDayPlanDate = _item.OLDDATE; // 宸ュ崟鐢熶骇鏃ユ湡
+ decimal HRelationQty = _item.PurchseFqty; // 鍏宠仈鏁伴噺
+ double HFixleadTime = _item.FFIXLEADTIME; // 鎻愬墠鏈�
+
+ dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
+ inner join AIS20210811135644..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
+ where FNUMBER='" + _item.FORGNumber + "' and HItemID ='" + fPrdOrgId + "'", "Xt_ORGANIZATIONS");
+ long HPURCHASEORGIDSub = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); // 閲囪喘缁勭粐
+ long HPOOrderInterID = _item.PurchseFID; // 閲囪喘璁㈠崟鍐呯爜
+ long HPOOrderEntryID = _item.PurchseFentryID; // 閲囪喘璁㈠崟瀛愬唴鐮�
+ string HPOOrderBillNo = _item.PurchseFBillNo; // 閲囪喘璁㈠崟鍙�
+ string HErpClsID = _item.FErpClsID; // 鐗╂枡灞炴��
+ long HUnitID = 10101; // 璁￠噺鍗曚綅 鍏堟寜鐓ф湰鍦版潵 榛樿 Pcs
+ string HSeOrderBillNo = _item.FXQD; // 閿�鍞鍗曞彿 闇�姹傚崟鍙�
+ string HOrderEmpID = _item.FCREATORID; // 閲囪喘鍛�
+ DateTime HPOOrderBillDate = _item.FDate; // 閲囪喘璁㈠崟鍗曟嵁鏃ユ湡
+ DateTime HPOOrderBillDeliveryDate = _item.FDeliveryDate; // 閲囪喘璁㈠崟浜よ揣鏃ユ湡
+ string HPOOrderBillRemark = _item.F_QIMB_NOTE; // 閲囪喘璁㈠崟鎽樿
+ string HPOOrderBillNote = _item.FNOTE; // 閲囪喘璁㈠崟琛ㄤ綋澶囨敞
+ string HDayPlanBillNo = _item.FDAYPLANBILLNO; // 鏃ヨ鍒掑伐鍗曞彿
+
+ dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
+ inner join AIS20210811135644..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
+ where FNUMBER='" + _item.FWORKSHOPNUMBER + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Department");
+ string HWorkShopID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // 鐢熶骇杞﹂棿
+
+ dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
+ inner join AIS20210811135644..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
+ where FNUMBER='" + _item.FPURCHASEDEPTNUMBER + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Department");
+ string HPurchaseDeptID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // 閲囪喘閮ㄩ棬
+
+ decimal HPURCHASEQTY = _item.FPURCHASEQTY; // 閲囪喘璁㈠崟鏁伴噺
+ decimal HJoinQty = _item.FJOINQTY; // 閲囪喘璁㈠崟鍏宠仈鏁伴噺
+
+ oCN.RunProc("insert into JIT_Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" +
+ ", HMaterModel, HUnitID, HErpClsID, HQty, HRemark" +
+ ", HPURCHASEORGID, HStatus, HFixleadTime, HDayPlanBillNo, HSourceInterID" +
+ ", HSourceEntryID, HSourceBillNo, HSourceBillType, HWorkShopID, HDayPlanDate" +
+ ", HRelationQty1, HPOOrderInterID, HPOOrderEntryID, HPOOrderBillNo, HPOOrderBillSEQ" +
+ ", HWWOrderInterID, HWWOrderEntryID, HWWOrderBillNo, HPurchaseDeptID, HCloseTypeSub" +
+ ", HCloseMan, HEntryCloseDate, HSendQty, HReciveQty, HCloseStatus" +
+ ", HRemoveQty, HSeOrderBillNo, HUnReciveQty, HPOOrderBillDate, HPOOrderBillDeliveryDate" +
+ ", HPOOrderBillRemark, HPOOrderBillNote)" +
+ $"values({HInterID}, {i}, '', {(HMaterID == null ? "0" : HMaterID)}, '{HMaterName}'" +
+ $", '{HMaterModel}', {HUnitID}, '{HErpClsID}', {HQty}, ''" +
+ $", {HPURCHASEORGIDSub}, '', {HFixleadTime}, '{HDayPlanBillNo}', {HSourceInterID}" +
+ $", {HSourceEntryID}, '{HSourceBillNo}', '{HSourceBillType}', {HWorkShopID}, '{HDayPlanDate}'" +
+ $", {HRelationQty}, {HPOOrderInterID},{HPOOrderEntryID}, '{HPOOrderBillNo}',0" +
+ $",0,0, '',{HPurchaseDeptID}, '0'" +
+ $", '','',0,0, '0'" +
+ $",0, '{HSeOrderBillNo}',0, '{HPOOrderBillDate}', '{HPOOrderBillDeliveryDate}'" +
+ $", '{HPOOrderBillRemark}', '{HPOOrderBillNote}')");
+ }
+ }
+
+ if (tlmmm == PODemandPlanList.Count)
+ {
+ oCN.Commit();
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "杩愮畻鎴愬姛!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ oCN.RollBack();//浜嬪姟鍥炴粴
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "杩愮畻澶辫触!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ }
+ catch (Exception e)
+ {
+ LogService.Write("鎿嶄綔澶辫触锛�" + e.Message.ToString());
+ oCN.RollBack();//浜嬪姟鍥炴粴
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.Message.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
#region 鐢熶骇鏃ヨ鍒掑钩鍙� 閿佸畾
[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHLockedDay")]
[HttpGet]
--
Gitblit v1.9.1