From ebac4c0aaf96258fc67cd3ad6b3d1ac1991df632 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期六, 27 二月 2021 10:53:57 +0800
Subject: [PATCH] 日计划用料清单增加条件
---
src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs | 17 ++++++++---------
1 files changed, 8 insertions(+), 9 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs
index 9320029..75c3257 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs
@@ -105,7 +105,6 @@
as DynamicObjectCollection;
foreach (var entryRow in entryRows)
{
-
string srcFormId = "PRD_PPBOM";
string srcSrcBillNo = entryRow["FPPBOMBILLNO"]?.ToString();
string FPPBOMFID = entryRow["FPPOMFID"]?.ToString();
@@ -159,14 +158,14 @@
if (FentryIdList.Count > 0)
{
string FentryId = string.Join(",", FentryIdList.ToArray());
- sql = string.Format(@"/*dialect*/
- update a set FBASEQTY = FQTY
- from T_STK_STKTRANSFERINENTRY_LK a
- join T_STK_STKTRANSFERINENTRY b on a.FENTRYID = b.FENTRYID
- where
- --a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and
- a.FENTRYID in ({0})", FentryId);
- sqlList.Add(sql);
+ // sql = string.Format(@"/*dialect*/
+ //update a set FBASEQTY = FQTY
+ //from T_STK_STKTRANSFERINENTRY_LK a
+ //join T_STK_STKTRANSFERINENTRY b on a.FENTRYID = b.FENTRYID
+ //where
+ //--a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and
+ //a.FENTRYID in ({0})", FentryId);
+ // sqlList.Add(sql);
sql = string.Format(@"/*dialect*/update T_STK_STKTRANSFERINENTRY_R
set FSrcBillTypeId = 'PRD_PPBOM',FSRCBILLNO=b.FPPBOMBILLNO
,FTRANSRESERVELINK=1
--
Gitblit v1.9.1