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 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 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);
            }
        } 
        #endregion
    }
}