From 4b0a1f01a9d67ca51765a39ac24cfbafaed4c4c9 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 12 三月 2021 13:34:55 +0800
Subject: [PATCH] 用于上查打开界面的通用插件（表单插件）
---
src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs | 11 +++++------
1 files changed, 5 insertions(+), 6 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs b/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs
index e6cfec4..83fd6ca 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs
@@ -159,13 +159,12 @@
return;
string FentryId = string.Join(",", FentryIdList.ToArray());
List<string> sqlList = new List<string>();
- // string sql = string.Format(@"/*dialect*/
- //update a set FBASEACTUALQTY = b.FBASEACTUALQTY
- // from T_PRD_PICKMTRLDATA_LK a
- // join T_PRD_PICKMTRLDATA b on a.FENTRYID = b.FENTRYID
- // where a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and a.FENTRYID in ({0})", FentryId);
- // sqlList.Add(sql);
string sql = string.Format(@"/*dialect*/
+ update a set FSTOCKAPPQTY = FAPPQTY,FSTOCKACTUALQTY=FACTUALQTY
+ from T_PRD_PICKMTRLDATA a
+ where a.FENTRYID in ({0})", FentryId);
+ sqlList.Add(sql);
+ sql = string.Format(@"/*dialect*/
update a set
FSrcBillType='PRD_PPBOM',
FSrcBillNo = b.FPPBOMBILLNO,
--
Gitblit v1.9.1