王 垚
2021-02-16 211bb749ab809dab4276c66a5d23bb5ea053ba8f
src/BLL/Demo.BillView/PRD/Pro_SCLLSH.cs
@@ -34,6 +34,7 @@
            e.FieldKeys.Add("FBaseJoinQty");
            e.FieldKeys.Add("FDayPlanBillNo");
            e.FieldKeys.Add("FDayPlanFentryId");
            e.FieldKeys.Add("FBaseActualQty");
        }
        /// <summary>
        ///反审核 反更新日计划用料清单领料数量
@@ -52,12 +53,11 @@
                            as DynamicObjectCollection;
                foreach (var entryRow in entryRows)
                {
                    //生产用料清单为空时
                    if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "")
                        continue;
                    string fentryId = entryRow["FDayPlanFentryId"].ToString();
                    sql = string.Format($"/*dialect*/update Sc_DayPlanPPBomBillSub set  FPickedQty = (select sum(FBaseActualQty) from T_PRD_PICKMTRLDATA where FDayPlanFentryId = {fentryId})where FEntryID = {fentryId} ");
                    LogHelper.Info("领料单的日计划用料清单ID:" + fentryId);
                    if (fentryId == "0")
                        continue;
                    sql = string.Format($"/*dialect*/update Sc_DayPlanPPBomBillSub set  FPickedQty = FPickedQty + {Convert.ToDecimal(entryRow["BaseActualQty"])} where FEntryID = {fentryId} ");
                    //LogHelper.Info("领料单的日计划用料清单ID:" + fentryId);
                    sqlList.Add(sql);
                }
            }