public int Update(SiteSettingInfo model, DbTransaction tran) { string strSql = SQL_UPDATE + PK_PARA_SET; DbParameter[] para = makeParameterForUpdate(model); return(Db.Helper.ExecuteNonQuery(tran, strSql, para)); }
public int Update(SiteSettingInfo model) { string strSql = SQL_UPDATE + PK_PARA_SET; DbParameter[] paras = makeParameterForUpdate(model); return(Db.Helper.ExecuteNonQuery(strSql, paras)); }
private DbParameter[] makeParameterForUpdate(SiteSettingInfo model) { DbParameter[] paras = { Db.Helper.MakeInParameter("@HotSearchWords", model.HotSearchWords), Db.Helper.MakeInParameter("@ExtraFields", FieldsHelper.XmlSerialize(model.ExtraFields)), Db.Helper.MakeInParameter("@ID", model.ID) }; return(paras); }
protected void Page_Load(object sender, EventArgs e) { SetNav("版权设置"); ltTips.Text = "在此,您可以设置版权信息。"; if (!Page.IsPostBack) { TMS.SiteSettingInfo setting = bll.Select(1); if (setting != null) { tbName.Text = setting.Copyright; } } }
protected void Page_Load(object sender, EventArgs e) { SetNav("热词设置"); ltTips.Text = "在此,您可以设置热词搜索,设置的热词将会在搜索框下显示,最多显示10个。"; if (!Page.IsPostBack) { TMS.SiteSettingInfo setting = bll.Select(1); if (setting != null) { tbName.Text = setting.HotSearchWords; } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string name = tbName.Text.Trim(); if (name.IsNullOrEmpty()) { MessageBox.Show("请输入版权信息!"); return; } TMS.SiteSettingInfo setting = bll.Select(1); if (setting != null) { setting.Copyright = name; } bll.Update(setting); MessageBox.Show("设置成功!"); }
public int Add(SiteSettingInfo model) { DbParameter[] paras = makeParameterForAdd(model); return(Db.Helper.ExecuteNonQuery(SQL_ADD, paras)); }
private void fillModel(DbDataReader dr, SiteSettingInfo model) { model.ID = dr.GetInt32(0); model.HotSearchWords = dr.GetString(1); model.ExtraFields = FieldsHelper.XmlDeserialize(dr.GetString(2)); }
public int Add(SiteSettingInfo model, DbTransaction tran) { DbParameter[] para = makeParameterForAdd(model); return(Db.Helper.ExecuteNonQuery(tran, SQL_ADD, para)); }