From e73cecaa6174aca2b8a4ef90bd265ae594622afd Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期三, 13 十月 2021 17:36:23 +0800
Subject: [PATCH] 器具管理所有页面列表加登录组织过滤
---
WorkM/流转卡管理/Sc_ProcessExchangeBillQuery.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillQuery.cs" "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillQuery.cs"
index 3ffcfdc..a84cd38 100644
--- "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillQuery.cs"
+++ "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillQuery.cs"
@@ -56,11 +56,11 @@
//杩囨护鏉′欢
if (frmCondition.SqlStr.Trim().Length == 0)
{
- sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " order by 鏃ユ湡 desc,hsubid ";
+ sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + " order by 鏃ユ湡 desc,hsubid ";
}
else
{
- sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " order by 鏃ユ湡 desc,hsubid ";
+ sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + " order by 鏃ユ湡 desc,hsubid ";
}
//
DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
--
Gitblit v1.9.1