日计划导入增加生产订单明细行号功能

王 垚

2021-03-01 4b0ac821502f956d7b0acd73f80a384ee41f6a6a

 src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs

@@ -15,6 +15,9 @@
using System.Diagnostics;
using System.Collections.Generic;
using ZD.Share.Common;
using Kingdee.K3.Core.SCM.STK;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.K3.SCM.ServiceHelper;

namespace Demo.TimedTaskPlugIn.PRD
{
@@ -34,7 +37,7 @@
                Context = ctx;
                string sql = @"/*dialect*/ select count(*) from 
(
select a.FSTOCKORGID,sum(b.FACTUALQTY)FACTUALQTY,b.FMATERIALID from T_PRD_PICKMTRL A
select a.FSTOCKORGID,sum(b.FACTUALQTY)FACTUALQTY,b.FMATERIALID from T_PRD_FEEDMTRL A
join T_PRD_PICKMTRLDATA b on a.FID =b.FID 
where a.FAPPROVEDATE is not null and DATEDIFF(D,GETDATE(),FDATE)=0
group by FSTOCKORGID,FMATERIALID
@@ -366,6 +369,7 @@
                            ModelEnty.Add("FHSourceID", new JObject() { ["Fnumber"] = _item.FHSourceID });//生产资源FHSourceID
                            ModelEnty.Add("FNumerator", _item.FNumerator);//分母
                            ModelEnty.Add("FDenominator", _item.FDenominator);//分子
                            ModelEnty.Add("FDwyl", Convert.ToDecimal(_item.FNumerator) / Convert.ToDecimal(_item.FDenominator));//单位用料
                            ModelEnty.Add("FFIXSCRAPQTY", _item.FFIXSCRAPQTY);//固定损耗
                            ModelEnty.Add("FHQtyScrap", _item.FHQtyScrap);//变动损耗率%
                            Entry.Add(ModelEnty);
@@ -766,5 +770,7 @@
            }
            DBServiceHelper.ExecuteBatch(Context, sqlList);
        }

       
    }
}