From cc286e3641ef72fe7cb1312487a6d4e40bda81fe Mon Sep 17 00:00:00 2001 From: cdk <2441919651@qq.com> Date: 星期三, 03 九月 2025 09:23:31 +0800 Subject: [PATCH] Merge branch 'master' of http://git.gs-mes.com:8080/r/~tjx/GsMesClient --- DevApp/Gs.DevApp/DevFrm/FrmMain.cs | 5 ++++- 1 files changed, 4 insertions(+), 1 deletions(-) diff --git a/DevApp/Gs.DevApp/DevFrm/FrmMain.cs b/DevApp/Gs.DevApp/DevFrm/FrmMain.cs index 6b93081..c20dd77 100644 --- a/DevApp/Gs.DevApp/DevFrm/FrmMain.cs +++ b/DevApp/Gs.DevApp/DevFrm/FrmMain.cs @@ -485,7 +485,10 @@ private void GetOrg() { string userGuid = LoginInfoModel.CurrentUser.LoginUserGuid; - var pgq = new PageQueryModel(1, 999999, "FID", "asc", userGuid, " and IS_STATUS=1"); + System.Text.StringBuilder sbSql= new System.Text.StringBuilder(); + sbSql.Append(" and IS_STATUS=1"); + sbSql.Append(" and fid in( select org.FID from [dbo].[SYS_USER_BIND] b left join SYS_ORGANIZATION org on b.aboutGuid=org.FID where userGuid='"+ LoginInfoModel.CurrentUser.LoginUserGuid + "' and fType='缁勭粐' ) "); + var pgq = new PageQueryModel(1, 999999, "FID", "asc", userGuid, sbSql.ToString()); var json = JsonConvert.SerializeObject(pgq); try { -- Gitblit v1.9.3