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

namespace BLL
{
    class ClsXt_XtgnbHlp
    {
        private string mvarReportTitle;

        public string MvarReportTitle
        {
            get { return mvarReportTitle; }
            set { mvarReportTitle = value; }
        }
        public string WherePart;
        public string ClsName;
        //
        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 ClsXt_XtgnbHlp()
        {
            mvarReportTitle = "系统功能表设置";
            ClsName = "系统功能表";
        }
       
        public bool GetInfoByID(long sItemID,ref string s)
        {
            DataSet DS ;
            ClsCN oCn = new ClsCN();
            try
            {
                DS = oCn.RunProcReturn("Select * from Xt_Xtgnb Where id=" + sItemID + "", "Xt_Xtgnb");
                if (DS.Tables[0].Rows.Count  == 0)
                    return false;
                else
                {
                    id =DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["id"]);
                    gnbm = DS.Tables[0].Rows[0]["gnbm"].ToString();
                    gnsy = DS.Tables[0].Rows[0]["gnsy"].ToString();
                    gnmc = DS.Tables[0].Rows[0]["gnmc"].ToString();
                    gnms = DS.Tables[0].Rows[0]["gnms"].ToString();
                    sjgnbm = DS.Tables[0].Rows[0]["sjgnbm"].ToString().Trim();
                    mjbz = DBUtility.ClsPub.isBool( DS.Tables[0].Rows[0]["mjbz"]);
                    MenuList = DBUtility.ClsPub.isBool( DS.Tables[0].Rows[0]["MenuList"]);
                    RightFlag = DBUtility.ClsPub.isBool( DS.Tables[0].Rows[0]["RightFlag"]);
                    useflag = DBUtility.ClsPub.isBool( DS.Tables[0].Rows[0]["useflag"]);
                    NetMenuList = DBUtility.ClsPub.isBool( DS.Tables[0].Rows[0]["NetMenuList"]);
                    return true;
                }
            }
            catch (Exception e)
            {
                s = e.Message;
                return false;
            }
        }
       
    }
}