From 102334b2ab255b279f9c492b146276baeb2910d1 Mon Sep 17 00:00:00 2001
From: cwjbxqmz <1134865194@qq.com>
Date: 星期四, 28 九月 2023 14:38:37 +0800
Subject: [PATCH] 计量单位列表：增加 审核，反审核，禁用，反禁用，按钮设置 等按钮；并修改视图，将 审核人，审核日期，禁用人，禁用日期 4列 显示出来；
---
DBUtility/基础资料/ClsGy_Base_Ctl.cs | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 insertions(+), 0 deletions(-)
diff --git "a/DBUtility/\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Base_Ctl.cs" "b/DBUtility/\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Base_Ctl.cs"
index e841d82..a58b22a 100644
--- "a/DBUtility/\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Base_Ctl.cs"
+++ "b/DBUtility/\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Base_Ctl.cs"
@@ -67,6 +67,38 @@
}
}
+ //瀹℃牳
+ public bool AuditByID(Int64 sItemID, ref string sReturn)
+ {
+ try
+ {
+ string HCheckEmp = ClsPub.CurUserName;
+ oCn.RunProc("Update " + MvarItemKey + " set HCheckEmp = '" + HCheckEmp + "',HCheckDate=getdate() where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
+ sReturn = "";
+ return true;
+ }
+ catch (Exception e)
+ {
+ sReturn = e.Message;
+ throw (e);
+ }
+ }
+
+ //鍙嶅鏍�
+ public bool DeAuditByID(Int64 sItemID, ref string sReturn)
+ {
+ try
+ {
+ oCn.RunProc("Update " + MvarItemKey + " set HCheckEmp = '', HCheckDate=null where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
+ sReturn = "";
+ return true;
+ }
+ catch (Exception e)
+ {
+ sReturn = e.Message;
+ throw (e);
+ }
+ }
//绂佺敤
public bool StopByID(Int64 sItemID)
--
Gitblit v1.9.1