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