From a75a2d05afbd147ecb44fc1b520180424b99c910 Mon Sep 17 00:00:00 2001 From: lu <123456> Date: 星期六, 23 八月 2025 10:21:11 +0800 Subject: [PATCH] bug --- 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..9ee0d2e 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