From 0fcc730fb3fa804c6e38f6f980eb15ee0a84eb33 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 08 九月 2021 13:24:15 +0800
Subject: [PATCH] 送货计划保存删除 反写提料计划 服务插件
---
src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs b/src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs
index 91bfb29..6ea520c 100644
--- a/src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs
+++ b/src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs
@@ -21,6 +21,7 @@
using Kingdee.BOS.Core.Metadata;
using Kingdee.K3.MFG.ServiceHelper;
using Kingdee.BOS;
+using ZD.Cloud.Logger;
namespace Demo.BillView.PRD
{
@@ -37,19 +38,20 @@
{
int FSupplierId = GetSupplierId();
if (FSupplierId > 0)
- e.FilterString = " FSUPPLIERID IN (102629)";
+ e.FilterString = $" FSUPPLIERID IN ({FSupplierId})";
}
else
{
int FSupplierId = GetSupplierId();
if (FSupplierId > 0)
- e.FilterString += " AND FSUPPLIERID IN (102629)";
+ e.FilterString += $" AND FSUPPLIERID IN (FSupplierId)";
}
}
public int GetSupplierId()
{
long userId = this.Context.UserId;
string sql = $"/*dialect*/ select FSupplierId from T_SEC_user a join T_SCP_USERDATA b on a.FUSERID = b.FUSERID where FUSERTYPE = 2 and a.FUSERID ={userId}";
+ //LogHelper.Info(sql);
int FSupplierId = DBServiceHelper.ExecuteScalar<int>(Context, sql, 0);
return FSupplierId;
}
--
Gitblit v1.9.1