From 4fc28e0f94344c452210e4f6dc9c1f01fcc51d65 Mon Sep 17 00:00:00 2001
From: lu <123456>
Date: 星期五, 29 八月 2025 08:04:09 +0800
Subject: [PATCH] bug
---
DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs | 9 ++++++---
1 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs b/DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs
index ea4bccf..557c3d7 100644
--- a/DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs
+++ b/DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs
@@ -33,10 +33,13 @@
public void getSuppler(string orgId, string _dftVale = "")
{
lookSearchSupplier.EditValue = null;
- string _keyWhere = "";
+ System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(orgId))
- _keyWhere = " and a.FSubsidiary ='" + orgId + "'";
- var pgq = new PageQueryModel(1, 999999, "a.FSubsidiary asc,a.departmentcode", "asc", "", " and 1=1" + _keyWhere);
+ _sbSqlWhere.Append(" and a.FSubsidiary ='" + orgId + "'");
+ _sbSqlWhere.Append(" and a.FSubsidiary in");
+ _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
+
+ var pgq = new PageQueryModel(1, 999999, "a.FSubsidiary asc,a.departmentcode", "asc", "", " and 1=1" + _sbSqlWhere.ToString());
var json = JsonConvert.SerializeObject(pgq);
try
{
--
Gitblit v1.9.3