| | |
|---|
| | | string userGuid = LoginInfoModel.CurrentUser.LoginUserGuid; |
|---|
| | | 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='组织' ) "); |
|---|
| | | 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 |
|---|
