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
|
}
|
}
|
