| | |
| | | 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") |
| | | { |
| | |
| | | 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("操作成功"); |