导入编制日期 取值 等于 计划开工日期

王 垚

2021-02-28 156e06ad46f0e4cb61c5f74553f6c2bc51e21a04

 src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGSH.cs

@@ -27,13 +27,13 @@
            e.FieldKeys.Add("FSrcBillNo");
            e.FieldKeys.Add("FBillNo");
            e.FieldKeys.Add("FDayPlanId");
            e.FieldKeys.Add("FDayPlanFentryId"); 
            e.FieldKeys.Add("FHQtyMust"); 
            e.FieldKeys.Add("FDayPlanFentryId");
            e.FieldKeys.Add("FHQtyMust");
            e.FieldKeys.Add("FHQtyMustNew");
            e.FieldKeys.Add("FUseRate");
            e.FieldKeys.Add("FUseRateNew");
            e.FieldKeys.Add("FHPPBomEntryID");
            e.FieldKeys.Add("FDwyl"); 
            e.FieldKeys.Add("FDwyl");
        }
        /// <summary>
        ///审核更新日计划用料清单领料数量
@@ -48,44 +48,13 @@
            Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息
            foreach (var billObj in e.SelectedRows)
            {
                DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity)
                            as DynamicObjectCollection;
                foreach (var entryRow in entryRows)
                {
                    string fDayPlanFentryId = entryRow["FDayPlanFentryId"].ToString();
                    string fHQtyMustNew = entryRow["FHQtyMustNew"].ToString();
                    string fUseRateNew = entryRow["FUseRateNew"].ToString();
                    string fDwyl = entryRow["FDwyl"].ToString();
                    string fHPPBomEntryID = entryRow["FHPPBomEntryID"].ToString();
                    if (fHQtyMustNew == "0")
                        continue;
                    sql = string.Format($"/*dialect*/update Sc_DayPlanPPBomBillSub set FHQtyMust = {fHQtyMustNew},FUseRate = { fUseRateNew}  where FEntryID ={fDayPlanFentryId} ");
                    sqlList.Add(sql);
                    sql = string.Format(@"/*dialect*/
update T_PRD_PPBOMENTRY set 
FBASENEEDQTY = c.FHQtyMust,
FBASEMUSTQTY = c.FHQtyMust,
FSTDQTY = c.FHQtyMust,
FNEEDQTY = c.FHQtyMust,
FMUSTQTY = c.FHQtyMust,
FUSERATE = (c.FHQtyMust / {0} / b.FQTY *100)
from T_PRD_PPBOMENTRY a
join T_PRD_PPBOM b on a.FID=b.FID
join (select sum(FHQtyMust)   FHQtyMust,FHPPBomEntryID from Sc_DayPlanPPBomBillSub where FHPPBomEntryID = {1} group by FHPPBomEntryID) c on a.FENTRYID=c.FHPPBomEntryID
where a.FENTRYID = {1}", fDwyl, fHPPBomEntryID);
                    sqlList.Add(sql);
                    sql = string.Format(@"/*dialect*/
update T_PRD_PPBOMENTRY_Q set 
FNOPICKEDQTY = b.FMUSTQTY - a.FPICKEDQTY,
FBASENOPICKEDQTY = b.FMUSTQTY - a.FPICKEDQTY
from T_PRD_PPBOMENTRY_Q a 
join T_PRD_PPBOMENTRY   b on a.FENTRYID=b.FENTRYID
where a.FENTRYID = {0}
", fHPPBomEntryID);
                    sqlList.Add(sql);
                }
                sql = $"/*dialect*/ exec pr_SHRjhylqdBgUpdate {billObj["Id"].ToString()}";
                sqlList.Add(sql);
            }
            DBServiceHelper.ExecuteBatch(Context, sqlList);
        }
    }
}