From 529179f84e3fd76c359d604815788414a540deba Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期二, 24 十一月 2020 13:43:11 +0800
Subject: [PATCH] 2020.11.24 测试更改上传
---
src/BLL/Demo.TimedTaskPlugIn/PRD/DayPlanPPBomBillTimeTask.cs | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/src/BLL/Demo.TimedTaskPlugIn/PRD/DayPlanPPBomBillTimeTask.cs b/src/BLL/Demo.TimedTaskPlugIn/PRD/DayPlanPPBomBillTimeTask.cs
index 7db3fe0..4e3e74f 100644
--- a/src/BLL/Demo.TimedTaskPlugIn/PRD/DayPlanPPBomBillTimeTask.cs
+++ b/src/BLL/Demo.TimedTaskPlugIn/PRD/DayPlanPPBomBillTimeTask.cs
@@ -25,7 +25,7 @@
{
string sql = string.Format(@"
/*dialect*/
-select t1.FID,t3.FMATERIALID,T5.FNUMBER,t1.FHMASTERDATE,t1.FHQTY,t4.FMATERIALID FMATERIALID2,T6.FNUMBER FNUMBER2,T7.FNUMBER FUNITNUMBER,FNumerator,FDenominator,convert(decimal(18,2),(FNumerator/FDenominator) *t1.FHQTY) FHQtyMust,T4.FUnitID,t8.FNUMBER FUNITNUMBER2,T3.FID FPPBOM,T4.FENTRYID,isnull(T9.FBillNo,'')FBillNo
+select t1.FID,t3.FMATERIALID,T5.FNUMBER,t1.FHMASTERDATE,t1.FHQTY,t4.FMATERIALID FMATERIALID2,T6.FNUMBER FNUMBER2,T7.FNUMBER FUNITNUMBER,FNumerator,FDenominator,convert(decimal(18,2),(FNumerator/FDenominator) *t1.FHQTY) FHQtyMust,T4.FUnitID,t8.FNUMBER FUNITNUMBER2,T3.FID FPPBOM,T4.FENTRYID,isnull(T9.FBillNo,'')FBillNo,t10.FNUMBER FORGNUMBER,t11.FNUMBER FHSOURCENUMBER
FROM Sc_WorkBillSortBillSub t1
JOIN Sc_WorkBillSortBillMAIN t2 on t1.FID = t2.FID
JOIN T_PRD_PPBOM T3 on T2.FPRDMOMAINID=t3.FMOID AND T2.FPRDMOENTYID=T3.FMOENTRYID
@@ -35,6 +35,8 @@
JOIN T_BD_UNIT T7 ON T3.FUNITID = T7.FUNITID
JOIN T_BD_UNIT T8 ON T4.FUNITID = T8.FUNITID
LEFT JOIN Sc_DayPlanPPBomBillMain T9 ON T1.FID=T9.FDayPlanFID
+ join T_ORG_Organizations t10 on t2.FHPRDORGID = t10.FORGID
+ join T_ENG_WORKCENTER t11 on t2.FHSOURCEID = t11.FID
where DATEDIFF(DAY,GETDATE(),FHMASTERDATE)=2
"
);
@@ -67,6 +69,7 @@
}
JObject model = new JObject();
model.Add("FHDate", DateTime.Now);
+ model.Add("FOrgId", new JObject() { ["Fnumber"] = DataRow[0]["FORGNUMBER"].ToString() });//鍙戞枡缁勭粐
model.Add("FHMaterID", new JObject() { ["Fnumber"] = DataRow[0]["FNUMBER"].ToString() });//鐗╂枡
model.Add("FHWorkDate", DataRow[0]["FHMASTERDATE"].ToString());//鏃ュ伐鍗曟棩鏈� FHWorkDate
model.Add("FHQty", DataRow[0]["FHQTY"].ToString());//涓讳骇鍝佹暟閲忥細FHQty
@@ -82,6 +85,8 @@
ModelEnty.Add("FHQtySub", DataRow[i]["FHQtyMust"].ToString());//鏁伴噺FHQtySub
ModelEnty.Add("FHPPBomInterID", DataRow[i]["FPPBOM"].ToString());//鐢ㄦ枡娓呭崟涓诲唴鐮丗HPPBomInterID
ModelEnty.Add("FHPPBomEntryID", DataRow[i]["FENTRYID"].ToString());//鐢ㄦ枡娓呭崟瀛愬唴鐮丗HPPBomEntryID
+ ModelEnty.Add("FHSourceID", new JObject() { ["Fnumber"] = DataRow[i]["FHSOURCENUMBER"].ToString() });//鐢熶骇璧勬簮FHSourceID
+
//model.Add("FHMaterSubID", DataRow[i]["FHQtyMust"].ToString());//鍒嗘瘝鍒嗗瓙
Entry.Add(ModelEnty);
}
--
Gitblit v1.9.1