/// <summary>
/// 根据 DictType 更新数据字典类型表记录
/// </summary>
/// <returns>返回数据字典类型受影响的行数</returns>
public virtual int Update(DictronaryType dictronarytype)
{
return(db.ExecuteNoQuery("UPDATE T_BASE_DICTRONARY_TYPE SET DICT_TYPE_NAME = @DICT_TYPE_NAME, DICT_TYPE_DESC = @DICT_TYPE_DESC WHERE DICT_TYPE = @DICT_TYPE",
db.GetDataParameter("@DICT_TYPE", dictronarytype.DictType),
db.GetDataParameter("@DICT_TYPE_NAME", dictronarytype.DictTypeName),
db.GetDataParameter("@DICT_TYPE_DESC", dictronarytype.DictTypeDesc)));
}
/// <summary>
/// 新增一条数据字典类型记录
/// </summary>
/// <param name="dictronarytype">System.String[]<param>
/// <returns>返回数据字典类型受影响的行数</returns>
public virtual int Add(DictronaryType dictronarytype)
{
return(db.ExecuteNoQuery("INSERT INTO T_BASE_DICTRONARY_TYPE (DICT_TYPE, DICT_TYPE_NAME, DICT_TYPE_DESC) VALUES (@DICT_TYPE, @DICT_TYPE_NAME, @DICT_TYPE_DESC)",
db.GetDataParameter("@DICT_TYPE", dictronarytype.DictType),
db.GetDataParameter("@DICT_TYPE_NAME", dictronarytype.DictTypeName),
db.GetDataParameter("@DICT_TYPE_DESC", dictronarytype.DictTypeDesc)));
}
private DictronaryType SetValue()
{
DictronaryType m_Base = new DictronaryType();
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
m_Base.DictType = txtDictType.Text;
}
else
{
m_Base.DictType = txtDictType.Text;
}
m_Base.DictTypeName = txtDictTypeName.Text; //
m_Base.DictTypeDesc = txtDictTypeDesc.Text; //
return(m_Base);
}
protected void lbtSave_Click(object sender, EventArgs e)
{
DictronaryType sg = SetValue();
try
{
if (Request.QueryString["id"] == null)
{
new DictronaryTypeDAL().Add(sg);
}
else
{
new DictronaryTypeDAL().Update(sg);
}
base.Close("tr");
}
catch (Exception ex)
{
base.Alert(ex.Message);
}
}
