王 垚
2021-02-18 0139536a43bc0ec80a31984b8e50c58286cfb5fa
src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
@@ -112,13 +112,15 @@
where FEntryID={1}", FRealQty, selectedRow["Id"]);
                    sqlList.Add(sql);
                }
                var fid = this.View.Model.GetPKValue();
                sqlList.Add($"update Sc_WorkBillSortBillMain set FCloseCount = (select sum(FNotInStockCount) from Sc_WorkBillSortBillSub where FID ={fid}) where FID ={fid}");
                DBServiceHelper.ExecuteBatch(Context, sqlList);
                this.View.Refresh();
                if (string.IsNullOrEmpty(result.ToString()))
                    this.View.ShowMessage("操作成功");
                else
                    this.View.ShowErrMessage(result.ToString());
            }
            else if (e.BarItemKey.ToUpper() == "TBROWCANCELCLOSE")
            {
@@ -140,6 +142,8 @@
where FEntryID={0}", selectedRow["Id"]);
                    sqlList.Add(sql);
                }
                var fid = this.View.Model.GetPKValue();
                sqlList.Add($"update Sc_WorkBillSortBillMain set FCloseCount = (select sum(FNotInStockCount) from Sc_WorkBillSortBillSub where FID ={fid}) where FID ={fid}");
                DBServiceHelper.ExecuteBatch(Context, sqlList);
                this.View.Refresh();
                this.View.ShowMessage("操作成功");