From 4c8a86bce9a4f19322935d91917576f6460a40bb Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期三, 03 九月 2025 09:23:21 +0800
Subject: [PATCH] 调整空值报错的问题
---
DevApp/Gs.DevApp/DevFrm/FrmMain.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/DevApp/Gs.DevApp/DevFrm/FrmMain.cs b/DevApp/Gs.DevApp/DevFrm/FrmMain.cs
index 9ee0d2e..c20dd77 100644
--- a/DevApp/Gs.DevApp/DevFrm/FrmMain.cs
+++ b/DevApp/Gs.DevApp/DevFrm/FrmMain.cs
@@ -487,7 +487,7 @@
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
--
Gitblit v1.9.3