From 916df97475e59ca952e1df41bbd0d52ed65a300c Mon Sep 17 00:00:00 2001
From: 沈泽 <211959439@qq.com>
Date: 星期四, 14 十月 2021 15:33:11 +0800
Subject: [PATCH] 新增考勤汇报表及相应功能和显示
---
WorkM/流转卡管理/Sc_ProcessExchangeBillList.cs | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillList.cs" "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillList.cs"
index b1514a5..d445727 100644
--- "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillList.cs"
+++ "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillList.cs"
@@ -53,11 +53,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 ";
}
//
@@ -858,6 +858,7 @@
// MessageBox.Show("娌℃湁杈撳叆鏉′欢!");
// return;
//}
+ sFastSQL = sFastSQL + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + "";
sDlgWhere = sFastSQL;
Display();
sDlgWhere = "";
--
Gitblit v1.9.1