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

namespace BLL
{
    class ClsXt_SystemParameterHlp
    {
        private string mvarReportTitle;

        public string MvarReportTitle
        {
            get { return mvarReportTitle; }
            set { mvarReportTitle = value; }
        }
        public string WherePart;
        public string ClsName;
        //
        public ClsXt_SystemParameter_Model oModel = new ClsXt_SystemParameter_Model();
        //
        //
        public ClsXt_SystemParameterHlp()
        {
            mvarReportTitle = "系统参数设置";
            ClsName = "系统参数";
        }
       
        public bool GetInfoByID(long sItemID,ref string s)
        {
            DataSet DS ;
            ClsCN oCn = new ClsCN();
            try
            {
                DS = oCn.RunProcReturn("Select * from Xt_SystemParameter Where HItemID=" + sItemID + "", "Xt_SystemParameter");
                if (DS.Tables[0].Rows.Count  == 0)
                    return false;
                else
                {
                    oModel.HInterID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HInterID"]);
                    oModel.HItemID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HItemID"]);
                    oModel.HModClass = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HModClass"]);
                    oModel.HKey = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HKey"]);
                    oModel.HCaption = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HCaption"]);
                    oModel.HValue = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HValue"]);
                    oModel.HReadonly = DBUtility.ClsPub.isBool(DS.Tables[0].Rows[0]["HReadonly"]);
                    oModel.HExplanation = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HExplanation"]);
                    oModel.HFarmat = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HFarmat"]);
                    return true;
                }
            }
            catch (Exception e)
            {
                s = e.Message;
                return false;
            }
        }
       
    }
}