王 垚
2021-04-19 e7b25b1c1d8d3310aa5deae5f72a3e0cc36c6fc2
src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs
@@ -1,5 +1,4 @@
using System.ComponentModel;
using Kingdee.BOS.Contracts;
using Kingdee.BOS;
using Kingdee.BOS.Core;
using Kingdee.BOS.ServiceHelper;
@@ -9,15 +8,12 @@
using System;
using Kingdee.BOS.Util;
using System.Linq;
using ZD.Cloud.WebApi;
using Demo.Model.Model;
using Demo.Model.Model.PODemandPlan;
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;
using ZD.Cloud.WebApi;
namespace Demo.TimedTaskPlugIn.PRD
{
@@ -25,7 +21,7 @@
    [HotUpdate]
    public class StockChangeDynamicAlignment : Kingdee.BOS.Contracts.IScheduleService
    {
        CloudClient cloudClient = new CloudClient("http://localhost/K3Cloud/");
        CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");
        public Context Context;
        List<PRD_Inventory> ListInventory;//库存明细
        List<PRD_Inventory> ListInventoryByStockOrgId;//物料总库存
@@ -37,7 +33,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
@@ -369,6 +365,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);