From 54a976bab1ce8da78435bbdf8a651aa2d1af0898 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 14 九月 2022 17:22:48 +0800
Subject: [PATCH] nothing
---
MES/src/BLL/Demo.BillView/PRD/SalOrderSaveVal.cs | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/MES/src/BLL/Demo.BillView/PRD/SalOrderSaveVal.cs b/MES/src/BLL/Demo.BillView/PRD/SalOrderSaveVal.cs
index fd19a41..4f50b7b 100644
--- a/MES/src/BLL/Demo.BillView/PRD/SalOrderSaveVal.cs
+++ b/MES/src/BLL/Demo.BillView/PRD/SalOrderSaveVal.cs
@@ -36,12 +36,10 @@
//for寰幆,璇诲彇鏁版嵁
foreach (var data in dataEntities)
{
- //LogService.Write("鏍￠獙鍣ㄦ祴璇�");
var FID = data.DataEntity["Id"]?.ToString();//鏃ヨ鍒掑伐鍗旻ID
var FPRDMOENTYID = Convert.ToInt32(data.DataEntity["FPRDMOENTYID"]?.ToString());//鐢熶骇璁㈠崟鏄庣粏 FentryID
var FSRCBILLENTRYSEQ = data.DataEntity["FSRCBILLENTRYSEQ"]?.ToString();//鐢熶骇璁㈠崟鏄庣粏琛屽彿
var FSCOrderNo = data.DataEntity["FSCOrderNo"]?.ToString(); //鐢熶骇璁㈠崟鍙�
- var FOrderQuantity = Convert.ToDecimal(data.DataEntity["FOrderQuantity"]?.ToString()); //鐢熶骇璁㈠崟鎬绘暟
var FDayPlanQuantity = Convert.ToDecimal(data.DataEntity["FDayPlanQuantity"]?.ToString()); //鏃ヨ鍒掓暟閲忔�婚噺
var FMOENTRYID = Convert.ToInt32(data.DataEntity["FMOENTRYID"]?.ToString());//鐢熶骇璁㈠崟鏄庣粏 FMOENTRYID(鏂�)
@@ -50,9 +48,12 @@
if (FMOENTRYID == 0 || FMOENTRYID == FPRDMOENTYID)
{
- //LogService.Write($"{FPRDMOENTYID},,{FSRCBILLENTRYSEQ},,{FSCOrderNo},,{FOrderQuantity},,{FOrderQuantity},,{FDayPlanQuantity},,,,");
+ 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);
+
bool isSave = FOrderCount + FDayPlanQuantity > FOrderQuantity;
if (isSave)
{
@@ -87,8 +88,11 @@
where FPRDMOENTYID ={0} and FMOENTRYID in({0},0 )
and FID <> {1}
) t1", FMOENTRYID, FID);
+ LogService.Write("_sql:"+ _sql);
//string sql = $"select convert(decimal(18,2),sum(FDayPlanQuantity)) from Sc_WorkBillSortBillMain where FMoEntryId = {FMOENTRYID} and FID <>{FID}";
decimal FOrderCount = DBServiceHelper.ExecuteScalar<decimal>(Context, _sql, 0);
+ var FOrderQuantity = DBServiceHelper.ExecuteScalar<decimal>(Context, "select Fqty from t_prd_moentry where fentryid =" + FMOENTRYID.ToString(), 0);
+ //LogService.Write("FOrderCount:" + FOrderCount);
bool isSave = FOrderCount + FDayPlanQuantity > FOrderQuantity;
if (isSave)
{
--
Gitblit v1.9.1