| | |
|---|
| | | var FOrderQuantity = DBServiceHelper.ExecuteScalar<decimal>(Context, "select Fqty from t_prd_moentry where fentryid ="+ FPRDMOENTYID.ToString(), 0); |
|---|
| | | string sql = $"select convert(decimal(18,2),sum(FDayPlanQuantity)) from Sc_WorkBillSortBillMain where FPRDMOENTYID = {FPRDMOENTYID} and (FMoEntryId = 0 or FMoEntryId = FPRDMOENTYID ) and FID <>{FID}"; |
|---|
| | | decimal FOrderCount = DBServiceHelper.ExecuteScalar<decimal>(Context, sql, 0); |
|---|
| | | LogService.Write("sql:" + sql); |
|---|
| | | LogService.Write("FOrderCount:" + FOrderCount); |
|---|
| | | //LogService.Write("sql:" + sql); |
|---|
| | | //LogService.Write("FOrderCount:" + FOrderCount); |
|---|
| | | |
|---|
| | | bool isSave = FOrderCount + FDayPlanQuantity > FOrderQuantity; |
|---|
| | | if (isSave) |
|---|
