From fbe33a615f1c4e798a0f8e58163e68c3ce789614 Mon Sep 17 00:00:00 2001
From: lg <123456>
Date: 星期四, 20 十一月 2025 10:17:49 +0800
Subject: [PATCH] 初始化标准版
---
DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs | 15 +++++++++++----
1 files changed, 11 insertions(+), 4 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs b/DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs
index ea4bccf..afa06cf 100644
--- a/DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs
+++ b/DevApp/Gs.DevApp/UserControl/UcLookDepartment.cs
@@ -30,13 +30,20 @@
if (EditChanged != null) EditChanged(this, e);
}
- public void getSuppler(string orgId, string _dftVale = "")
+ public void getSuppler(string orgId, string _dftVale = "", string strWhere = "")
{
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());
+ if (!string.IsNullOrEmpty(strWhere))
+ {
+ _sbSqlWhere.Append(" and " + strWhere);
+ }
+ _sbSqlWhere.Append(" and a.Depextr4 = 'A'");
+ 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