1

yxj

2023-11-07 5ce11d0a8055b7a541b9f88d9068bc98908a3e29

 DBUtility/»ù´¡×ÊÁÏ/ClsGy_Base_Ctl.cs

@@ -128,6 +128,105 @@
            }
        }

        //关闭
        public bool CloseByID(Int64 sItemID, ref string sReturn)
        {
            try
            {
                string HCloseEmp = ClsPub.CurUserName;
                oCn.RunProc("Update " + MvarItemKey + "   set HCloseEmp = '" + HCloseEmp + "',HCloseDate=getdate()  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

        //反关闭
        public bool DeCloseByID(Int64 sItemID, ref string sReturn)
        {
            try
            {
                oCn.RunProc("Update " + MvarItemKey + "   set HCloseEmp = '', HCloseDate=null  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

        //审核2 HCheckTime
        public bool AuditByID2(Int64 sItemID, ref string sReturn)
        {
            try
            {
                string HCheckEmp = ClsPub.CurUserName;
                oCn.RunProc("Update " + MvarItemKey + "   set HCheckEmp = '" + HCheckEmp + "',HCheckTime=getdate()  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

        //反审核2 HCheckTime
        public bool DeAuditByID2(Int64 sItemID, ref string sReturn)
        {
            try
            {
                oCn.RunProc("Update " + MvarItemKey + "   set HCheckEmp = '', HCheckTime=null  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

        //关闭2 HCloseTime
        public bool CloseByID2(Int64 sItemID, ref string sReturn)
        {
            try
            {
                string HCloseEmp = ClsPub.CurUserName;
                oCn.RunProc("Update " + MvarItemKey + "   set HCloseEmp = '" + HCloseEmp + "',HCloseTime=getdate()  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

        //反关闭2 HCloseTime
        public bool DeCloseByID2(Int64 sItemID, ref string sReturn)
        {
            try
            {
                oCn.RunProc("Update " + MvarItemKey + "   set HCloseEmp = '', HCloseTime=null  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

        //删除
        public bool DeleteByID(Int64 sItemID)
        {