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/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..65f6425 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