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

namespace BLL
{
    class ClsXt_SystemParameter
    {
        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 ClsXt_SystemParameter_Model oModel = new ClsXt_SystemParameter_Model();
        //原代码 用于 替换子项目
        public string  HOldNumber;
        //新增
        public bool AddNew()
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Insert into Xt_SystemParameter " +
                    " (HInterID,HModClass,HKey,HCaption" +
                    ",HValue,HReadonly,HExplanation,HFarmat) " +
                    " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HModClass + "','" + oModel.HKey + "','" + oModel.HCaption + "'" +
                    ",'" + oModel.HValue + "'," + Convert.ToString(oModel.HReadonly ? 1 : 0) + ",'" + oModel.HExplanation + "','" + oModel.HFarmat + "'" +
                    ")");
                //修改上级为非末级代码
                //oCN.RunProc("Update Xt_SystemParameter 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_SystemParameter set " +
                    " HInterID=" + oModel.HInterID.ToString() +
                    ",HModClass='" + oModel.HModClass + "'" +
                    ",HKey='" + oModel.HKey + "'" +
                    ",HCaption='" + oModel.HCaption + "'" +
                    ",HValue='" + oModel.HValue + "'" +
                    ",HReadonly=" + Convert.ToString(oModel.HReadonly ? 1 : 0) +
                    ",HExplanation='" + oModel.HExplanation + "'" +
                    ",HFarmat= '" + oModel.HFarmat + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo);
               
                oCN.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                return false;
            }
        }

        #region 固定代码
        //删除
        public bool DeleteByID(long sItemID,ref string s)
        {
            try
            {
                oCN.RunProc("Delete from Xt_SystemParameter where HItemID='" + sItemID + "'");
                return true;
            }
            catch (Exception e)
            {
                s = e.Message;
                return false;
            }
        }
        //构造函数
        public ClsXt_SystemParameter() 
        {
            MvarItemKey = "Xt_SystemParameter";
            MvarReportTitle = "系统参数设置";
        }
        #endregion
    }
}