From f8141b591a3290e4338dbbbd5a7b57801cdf30a5 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期六, 07 十月 2023 09:14:32 +0800
Subject: [PATCH] 1
---
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