看板系统设置模块修改，外购件仓库看板模块修改

yxj

2024-01-08 b2abf37fac8885c23706eee389ccb4be07aceaa4

 DBUtility/»ù´¡×ÊÁÏ/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)
@@ -96,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)
        {