using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DBUtility
{
    public class ClsGy_Base_Ctl
    {
        public string MvarItemKey;
        public string MvarReportTitle;
        public Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper(); 
        //新增
        public virtual bool AddNew()
        {
            return true;
        }

        //修改
        public virtual bool ModifyByID(Int64 sItemID)
        {
            return true;
        }

        #region 固定代码
        //是否存在子项目
        public bool HavChildCodes(Int64 sItemID)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select HItemID from " + MvarItemKey + " Where HParentID='" + sItemID + "'", MvarItemKey , ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
        //根据代码判断信息
        public virtual bool HavParentCode(string sCode, Int64 sItemID)
        {
            return true;
        }
        //重复代码
        public bool HavSameNumber(Int64 sItemID, string sNumber)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select HItemID from " + MvarItemKey + " Where HItemID<>" + sItemID + " and HNumber='" + sNumber + "'", MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        //审核
        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)
        {
            try
            {
                oCn.RunProc("Update " + MvarItemKey + "   set HStopflag=1  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        //反禁用
        public bool UnStopByID(Int64 sItemID)
        {
            try
            {
                oCn.RunProc("Update " + MvarItemKey + "   set HStopflag=0  where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        //关闭
        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)
        {
            try
            {
                oCn.RunProc("Delete from " + MvarItemKey + " where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }


        //删除
        public bool DeleteByNumber(string  sNumber)
        {
            try
            {
                oCn.RunProc("Delete from " + MvarItemKey + " where HNumber='" + sNumber + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }


        /// <summary>
        /// 审核
        /// </summary>
        /// <param name="HItemID">内码</param>
        /// <param name="HMaker">操作人</param>
        /// <returns></returns>
        public bool CheckByHItemID(Int64 HItemID, string HMaker, ref string sReturn)
        {
            try
            {
                DataSet DS = oCn.RunProcReturn("select * from " + MvarItemKey + " where HItemID='" + HItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                {
                    sReturn = "未查询到任何数据，请刷新数据后重新选择！";
                    return false;
                }
                else
                {
                    if (DS.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
                    {
                        sReturn = "单据已审核，不允许重复审核！";
                        return false;
                    }
                    //审核
                    oCn.BeginTran();
                    oCn.RunProc("Update " + MvarItemKey + " set HCheckEmp = '" + HMaker + "',HCheckTime=getdate() where HItemID=" + HItemID, ref Pub_Class.ClsPub.sExeReturnInfo);
                    //写入日志
                    DBUtility.ClsPub.Add_Log("", MvarReportTitle+ "审核，代码：" + DS.Tables[0].Rows[0]["HNumber"].ToString() + ",名称：" + DS.Tables[0].Rows[0]["HName"].ToString(), HMaker);
                    sReturn = "";
                    oCn.Commit();
                    return true;
                }
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }

        /// <summary>
        /// 反审核
        /// </summary>
        /// <param name="HItemID">内码</param>
        /// <param name="HMaker">操作人</param>
        /// <returns></returns>
        public bool AbandonCheckByHItemID(Int64 HItemID, string HMaker, ref string sReturn)
        {
            try
            {
                DataSet DS = oCn.RunProcReturn("select * from " + MvarItemKey + " where HItemID='" + HItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                {
                    sReturn = "未查询到任何数据，请刷新数据后重新选择！";
                    return false;
                }
                else
                {
                    if (DS.Tables[0].Rows[0]["HCheckEmp"].ToString() == "")
                    {
                        sReturn = "单据未审核，不允许反审核！";
                        return false;
                    }
                    //反审核
                    oCn.BeginTran();
                    oCn.RunProc("Update " + MvarItemKey + " set HCheckEmp = '',HCheckTime=null where HItemID=" + HItemID, ref Pub_Class.ClsPub.sExeReturnInfo);
                    //写入日志
                    DBUtility.ClsPub.Add_Log("", MvarReportTitle + "反审核，代码：" + DS.Tables[0].Rows[0]["HNumber"].ToString() + ",名称：" + DS.Tables[0].Rows[0]["HName"].ToString(), HMaker);
                    sReturn = "";
                    oCn.Commit();
                    return true;
                }
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }

        /// <summary>
        /// 禁用
        /// </summary>
        /// <param name="HItemID">内码</param>
        /// <param name="HMaker">操作人</param>
        /// <returns></returns>
        public bool StopByHItemID(Int64 HItemID, string HMaker, ref string sReturn)
        {
            try
            {
                DataSet DS = oCn.RunProcReturn("select * from " + MvarItemKey + " where HItemID='" + HItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                {
                    sReturn = "未查询到任何数据，请刷新数据后重新选择！";
                    return false;
                }
                else
                {
                    if (DS.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
                    {
                        sReturn = "单据已禁用，不允许重复禁用！";
                        return false;
                    }

                    DataSet DsHavChildCodes = oCn.RunProcReturn("select HItemID from " + MvarItemKey + " where HStopflag=0 and HParentID='" + HItemID + "'", MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
                    if (DsHavChildCodes.Tables[0].Rows.Count > 0)
                    {
                        sReturn = "所选单据存在未禁用的子项目,不允许禁用！";
                        return false;
                    }

                    //禁用
                    oCn.BeginTran();
                    oCn.RunProc("Update " + MvarItemKey + " set HStopflag=1,HStopEmp = '" + HMaker + "',HStopTime=getdate() where HItemID=" + HItemID, ref Pub_Class.ClsPub.sExeReturnInfo);
                    //写入日志
                    DBUtility.ClsPub.Add_Log("", MvarReportTitle + "禁用，代码：" + DS.Tables[0].Rows[0]["HNumber"].ToString() + ",名称：" + DS.Tables[0].Rows[0]["HName"].ToString(), HMaker);
                    sReturn = "";
                    oCn.Commit();
                    return true;
                }
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }

        /// <summary>
        /// 反禁用
        /// </summary>
        /// <param name="HItemID">内码</param>
        /// <param name="HMaker">操作人</param>
        /// <returns></returns>
        public bool AbandonStopByHItemID(Int64 HItemID, string HMaker, ref string sReturn)
        {
            try
            {
                DataSet DS = oCn.RunProcReturn("select * from " + MvarItemKey + " where HItemID='" + HItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                {
                    sReturn = "未查询到任何数据，请刷新数据后重新选择！";
                    return false;
                }
                else
                {
                    if (DS.Tables[0].Rows[0]["HStopEmp"].ToString() == "")
                    {
                        sReturn = "单据未禁用，不允许反禁用！";
                        return false;
                    }

                    DataSet DsHavChildCodes = oCn.RunProcReturn("select HItemID from " + MvarItemKey + " where HStopflag=1 and HItemID='" + DS.Tables[0].Rows[0]["HParentID"].ToString() + "'", MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
                    if (DsHavChildCodes.Tables[0].Rows.Count > 0)
                    {
                        sReturn = "所选单据上级项目已禁用,不允许反禁用！";
                        return false;
                    }

                    //禁用
                    oCn.BeginTran();
                    oCn.RunProc("Update " + MvarItemKey + " set HStopflag=0,HStopEmp = '',HStopTime=null where HItemID=" + HItemID, ref Pub_Class.ClsPub.sExeReturnInfo);
                    //写入日志
                    DBUtility.ClsPub.Add_Log("", MvarReportTitle + "反禁用，代码：" + DS.Tables[0].Rows[0]["HNumber"].ToString() + ",名称：" + DS.Tables[0].Rows[0]["HName"].ToString(), HMaker);
                    sReturn = "";
                    oCn.Commit();
                    return true;
                }
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }


        #endregion
    }
}