| | |
|---|
| | | { |
|---|
| | | string sql = string.Format(@" |
|---|
| | | /*dialect*/ |
|---|
| | | select t1.FID,t1.FEntryID,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 FPPBOMENTRYID,isnull(T9.FBillNo,'')FBillNo,t10.FNUMBER FORGNUMBER,t11.FNUMBER FHSOURCENUMBER,FSCRAPRATE,FFIXSCRAPQTY,T9.FID AS DayPlanFID,t2.FSCORDERNO, |
|---|
| | | select t1.FID,t1.FSEQ FDayPlanFSEQ,t1.FEntryID,T2.FBILLNO AS FDayPlanFBILLNO,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 FPPBOMENTRYID,isnull(T9.FBillNo,'')FBillNo,t10.FNUMBER FORGNUMBER,t11.FNUMBER FHSOURCENUMBER,FSCRAPRATE,FFIXSCRAPQTY,T9.FID AS DayPlanFID,t2.FSCORDERNO, |
|---|
| | | t3.FMOENTRYID,t3.FBILLNO FPPBOMBILLNO,T4.FSEQ,tc.FOWNERTYPEID,tc.FOWNERID,tc.FEntrustPickOrgId,torg.FNUMBER as FORGNUMBER,t3.FMOID,FIssueType,FMaterialType |
|---|
| | | FROM Sc_WorkBillSortBillSub t1 |
|---|
| | | JOIN Sc_WorkBillSortBillMAIN t2 on t1.FID = t2.FID |
|---|
| | |
|---|
| | | FEntrustPickOrgId = dr["FORGNUMBER"].ToString(), |
|---|
| | | FMOID = dr["FMOID"].ToString(), |
|---|
| | | FIssueType = dr["FIssueType"].ToString(), |
|---|
| | | FMaterialType = dr["FMaterialType"].ToString() |
|---|
| | | FMaterialType = dr["FMaterialType"].ToString(), |
|---|
| | | FDayPlanFSEQ = dr["FDayPlanFSEQ"].ToString(), |
|---|
| | | FDayPlanFBILLNO = dr["FDayPlanFBILLNO"].ToString() |
|---|
| | | }); |
|---|
| | | } |
|---|
| | | LogHelper.Info($"日计划用料清单，数据准备完成，保存到Model实体，总行数：{DayPlanMaterial.Count}，耗时：" + sw.Elapsed); |
|---|
| | |
|---|
| | | model.Add("FHQty", _DayPlanMaterial[0].FHQty);//主产品数量：FHQty |
|---|
| | | model.Add("FHUnitID", new JObject() { ["Fnumber"] = _DayPlanMaterial[0].FHUnitID });//单位：FHUnitID |
|---|
| | | model.Add("FDayPlanFID", _DayPlanMaterial[0].FDayPlanFID);//日计划工单内码 |
|---|
| | | model.Add("FDayPlanFSEQ", _DayPlanMaterial[0].FDayPlanFSEQ);//日计划工单明细行号 |
|---|
| | | model.Add("FDayPlanFBillNo", _DayPlanMaterial[0].FDayPlanFBILLNO);//日计划工单单据编号 |
|---|
| | | JArray Entry = new JArray(); |
|---|
| | | int FSEQ = 1; |
|---|
| | | foreach (var _item in _DayPlanMaterial) |
|---|
