日计划工单关闭 可以关闭未生产入库单据

王 垚

2021-02-28 5068b25b0dcc939027f27c735433d7a09e9a5d70

日计划工单关闭 可以关闭未生产入库单据

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

@@ -83,11 +83,11 @@
left join T_PRD_INSTOCKENTRY c on b.FENTRYID = c.FSrcEntryId
where a.FEntryID in ({0})", selectedRow["Id"]);
                    decimal FRealQty = DBServiceHelper.ExecuteScalar<decimal>(Context, sql, 0);
                    if (FRealQty == 0)
                    {
                        result.Append($"分录行：{selectedRow["Seq"]}，日计划明细未下推生成生产入库单\r\n");
                        continue;
                    }
                    //if (FRealQty == 0)
                    //{
                    //    result.Append($"分录行：{selectedRow["Seq"]}，日计划明细未下推生成生产入库单\r\n");
                    //    continue;
                    //}
                    sql = string.Format(@"
/*dialect*/
select count(*)res from Sc_WorkBillSortBillSub a 
@@ -99,7 +99,7 @@
                    decimal Count = DBServiceHelper.ExecuteScalar<decimal>(Context, sql, 0);
                    if (Count > 0)
                    {
                        result.Append($"分录行：{selectedRow["Seq"]}，下游领料单的已领料数小于入库的标准用量\r\n");
                        result.Append($"分录行：{selectedRow["Seq"]}，下游领料单的已领料数大于入库的标准用量\r\n");
                        continue;
                    }
                    sql = string.Format(@"