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

namespace BLL
{
    class ClsXt_Xtgnb
    {
        private string _mvarItemKey;

        public string MvarItemKey
        {
            get { return _mvarItemKey; }
            set { _mvarItemKey = value; }
        }
        private string _mvarReportTitle;

        public string MvarReportTitle
        {
            get { return _mvarReportTitle; }
            set { _mvarReportTitle = value; }
        }
        ClsCN oCN = new ClsCN();
        public long id;
        public string gnbm;
        public string gnsy;
        public string gnmc;
        public string gnms;
        public string sjgnbm;
        public bool mjbz;
        public bool MenuList;
        public bool RightFlag;
        public bool useflag;
        public bool NetMenuList;
        //原代码 用于 替换子项目
        public string  HOldNumber;
        //新增
        public bool AddNew()
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Insert into Xt_Xtgnb " +
                    " (gnbm,gnsy,gnmc" +
                    ",gnms,sjgnbm,mjbz" +
                    ",MenuList,RightFlag,useflag,NetMenuList) " +
                    " Values('" + this.gnbm + "','" + this.gnsy + "','" + this.gnmc +
                    "','" + this.gnms + "','" + this.sjgnbm + "'," + Convert.ToString(this.mjbz ? 1 : 0) +
                    "," + Convert.ToString(this.MenuList ? 1 : 0) + "," + Convert.ToString(this.RightFlag ? 1 : 0) + "," + Convert.ToString(this.useflag ? 1 : 0) + "," + Convert.ToString(this.NetMenuList ? 1 : 0) + ")");
                //修改上级为非末级代码
                //oCN.RunProc("Update Xt_Xtgnb set HEndflag=0 where HItemID=" + this.HParentID);
                oCN.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                return false; 
            }
        }
       
        //修改
        public bool ModifyByID(long sItemID)
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Update Xt_Xtgnb set " +
                    " gnbm='" + this.gnbm + "'" +
                    ",gnsy='" + this.gnsy + "'" +
                    ",gnmc='" + this.gnmc + "'" +
                    ",gnms='" + this.gnms + "'" +
                    ",sjgnbm='" + this.sjgnbm + "'" +
                    ",mjbz=" + Convert.ToString(this.mjbz ? 1 : 0) +
                    ",MenuList=" + Convert.ToString(this.MenuList ? 1 : 0) +
                    ",RightFlag=" + Convert.ToString(this.RightFlag ? 1 : 0) +
                    ",useflag=" + Convert.ToString(this.useflag ? 1 : 0) +
                    ",NetMenuList= " + Convert.ToString(this.NetMenuList ? 1 : 0) + " Where id=" + sItemID);
               
                oCN.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                return false;
            }
        }

        #region 固定代码
        //是否存在子项目
        public bool HavChildCodes(long sItemID)
        {
            DataSet DS ;
            try
            {
                DS = oCN.RunProcReturn("Select id from Xt_Xtgnb Where sjgnbm='" + sItemID + "'", "Xt_Xtgnb");
                if (DS.Tables[0].Rows.Count==0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
        //根据代码判断信息
        public bool HavParentCode(string sCode, long sItemID)
        {
            DataSet DS ;
            try
            {
                DS = oCN.RunProcReturn("Select * from Xt_Xtgnb Where gnbm='" + sCode + "' and id<>'" + sItemID + "'", "Xt_Xtgnb");
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    id = Convert.ToInt64(DS.Tables[0].Rows[0]["id"]);
                    gnbm = DS.Tables[0].Rows[0]["gnbm"].ToString().Trim();
                    gnsy = DS.Tables[0].Rows[0]["gnsy"].ToString().Trim();
                    gnmc = DS.Tables[0].Rows[0]["gnmc"].ToString().Trim();
                    gnms = DS.Tables[0].Rows[0]["gnms"].ToString().Trim();
                    sjgnbm = DS.Tables[0].Rows[0]["sjgnbm"].ToString().Trim();
                    mjbz = (bool)DS.Tables[0].Rows[0]["mjbz"];
                    MenuList = (bool)DS.Tables[0].Rows[0]["MenuList"];
                    RightFlag = (bool)DS.Tables[0].Rows[0]["RightFlag"];
                    useflag = (bool)DS.Tables[0].Rows[0]["useflag"];
                    NetMenuList = (bool)DS.Tables[0].Rows[0]["NetMenuList"];
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
        //重复代码
        public bool HavSameNumber(long sItemID, string sNumber)
        {
            DataSet DS ;
            try
            {
                DS = oCN.RunProcReturn("Select id from Xt_Xtgnb Where id<>'" + sItemID + "' and gnbm='" + sNumber + "'", "Xt_Xtgnb");
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
        //删除
        public bool DeleteByID(long sItemID,ref string s)
        {
            try
            {
                oCN.RunProc("Delete from Xt_Xtgnb where id='" + sItemID + "'");
                return true;
            }
            catch (Exception e)
            {
                s = e.Message;
                return false;
            }
        }
        //构造函数
        public ClsXt_Xtgnb() 
        {
            MvarItemKey = "Xt_Xtgnb";
            MvarReportTitle = "系统功能表设置";
        }
        #endregion
    }
}