From 00882b1b7952163bf6e2ef3e98286cd1fe22a103 Mon Sep 17 00:00:00 2001 From: cdk <2441919651@qq.com> Date: 星期四, 04 九月 2025 09:24:01 +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