public M_AdCategory GetModel(int AdCategoryId)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@AdCategoryId", SqlDbType.Int, 4), new SqlParameter("@PageSize", SqlDbType.Int, 4), new SqlParameter("@PageIndex", SqlDbType.Int, 4), new SqlParameter("@WhereString", SqlDbType.NVarChar, 0x7d0) };
commandParameters[0].Value = 1;
commandParameters[1].Value = AdCategoryId;
commandParameters[4].Value = "";
M_AdCategory category = new M_AdCategory();
DataTable table = SqlHelper.ExecuteTable(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_AdCategory_Get", commandParameters);
category.AdCategoryId = AdCategoryId;
if (table.Rows.Count > 0)
{
category.CategoryName = table.Rows[0]["CategoryName"].ToString();
if (table.Rows[0]["IsDisabled"].ToString() != "")
{
category.IsDisabled = int.Parse(table.Rows[0]["IsDisabled"].ToString());
}
category.WidthHeigth = table.Rows[0]["WidthHeigth"].ToString();
if (table.Rows[0]["DisplayType"].ToString() != "")
{
category.DisplayType = int.Parse(table.Rows[0]["DisplayType"].ToString());
}
category.Description = table.Rows[0]["Description"].ToString();
return category;
}
return null;
}
private void ExcuteSet(int type, M_AdCategory model)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@AdCategoryId", SqlDbType.Int, 4), new SqlParameter("@CategoryName", SqlDbType.NVarChar, 50), new SqlParameter("@IsDisabled", SqlDbType.Int, 4), new SqlParameter("@WidthHeigth", SqlDbType.VarChar, 12), new SqlParameter("@DisplayType", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.NVarChar, 50) };
commandParameters[0].Value = type;
commandParameters[1].Value = model.AdCategoryId;
commandParameters[2].Value = (model.CategoryName == null) ? "" : model.CategoryName;
commandParameters[3].Value = model.IsDisabled;
commandParameters[4].Value = (model.WidthHeigth == null) ? "||" : model.WidthHeigth;
commandParameters[5].Value = model.DisplayType;
commandParameters[6].Value = (model.Description == null) ? "" : model.Description;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_AdCategory_Set", commandParameters);
}
/// <summary>
/// 在修改时绑定数据
/// </summary>
void BindOnUpdate()
{
Model = Bll.GetModel(CategoryId);
if (Model != null)
{
txtCategoryName.Text = Model.CategoryName;
txtDescription.Text = Model.Description;
string[] param = Model.WidthHeigth.Split('|');
if (param.Length == 3)
{
txtHeigth.Text = param[1];
txtWidth.Text = param[0];
txtPer.Text = param[2];
}
rblDisplayType.SelectedIndex = Model.DisplayType - 1;
rblIsDisable.SelectedIndex = Model.IsDisabled - 1;
if (Model.DisplayType == 5)
{ TrMatrix.Attributes.Add("style","display:''"); }
}
else
{
Function.ShowSysMsg(0, "<li>没有获取到数据</li><li><a href='other/PushCategoryList.aspx'>返回广告位列表</a></li>");
}
}
public void Update(M_AdCategory model)
{
this.dal.Update(model);
}
public void Add(M_AdCategory model)
{
this.dal.Add(model);
}
public void Update(M_AdCategory model)
{
this.ExcuteSet(2, model);
}
public void Delete(int AdCategoryId)
{
M_AdCategory model = new M_AdCategory();
model.AdCategoryId = AdCategoryId;
this.ExcuteSet(3, model);
}
public void Add(M_AdCategory model)
{
this.ExcuteSet(1, model);
}
