public int Update(SliderInfo model)
{
string strSql = SQL_UPDATE + PK_PARA_SET;
DbParameter[] paras = makeParameterForUpdate(model);
return(Db.Helper.ExecuteNonQuery(strSql, paras));
}
public int Update(SliderInfo model, DbTransaction tran)
{
string strSql = SQL_UPDATE + PK_PARA_SET;
DbParameter[] para = makeParameterForUpdate(model);
return(Db.Helper.ExecuteNonQuery(tran, strSql, para));
}
private void fillModel(DbDataReader dr, SliderInfo model)
{
model.ID = dr.GetInt32(0);
model.Name = dr.GetString(1);
model.PicPath = dr.GetString(2);
model.Url = dr.GetString(3);
model.AddTime = dr.GetDateTime(4);
model.AddUserName = dr.GetString(5);
model.SortOrder = dr.GetInt32(6);
model.IsTop = dr.GetInt32(7);
model.IsShow = dr.GetInt32(8);
}
private DbParameter[] makeParameterForAdd(SliderInfo model)
{
DbParameter[] paras =
{
Db.Helper.MakeInParameter("@Name", model.Name),
Db.Helper.MakeInParameter("@PicPath", model.PicPath),
Db.Helper.MakeInParameter("@Url", model.Url),
Db.Helper.MakeInParameter("@AddTime", model.AddTime),
Db.Helper.MakeInParameter("@AddUserName", model.AddUserName),
Db.Helper.MakeInParameter("@SortOrder", model.SortOrder),
Db.Helper.MakeInParameter("@IsTop", model.IsTop),
Db.Helper.MakeInParameter("@IsShow", model.IsShow)
};
return(paras);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string name = tbName.Text.Trim();
string cover = tbCoverPath.Text.Trim();
string url = tbUrl.Text.Trim();
if (name.ValidateIsNullOrEmpty("请输入商品名称！"))
{
return;
}
if (url.ValidateIsNullOrEmpty("请输入url地址！"))
{
return;
}
if (cover.ValidateIsNullOrEmpty("请上传照片！"))
{
return;
}
var model = new TMS.SliderInfo();
model.AddTime = DateTime.Now;
model.AddUserName = CurrentAdmin.UserName;
model.IsTop = 0;
model.Name = name;
model.Url = url;
model.IsShow = 0;
model.SortOrder = 0;
model.PicPath = cover;
new TMS.Slider().Add(model);
tbUrl.Text = "";
tbName.Text = "";
tbCoverPath.Text = "";
MessageBox.Show("添加成功！");
}
public int Add(SliderInfo model)
{
DbParameter[] paras = makeParameterForAdd(model);
return(Db.Helper.ExecuteNonQuery(SQL_ADD, paras));
}
public int Add(SliderInfo model, DbTransaction tran)
{
DbParameter[] para = makeParameterForAdd(model);
return(Db.Helper.ExecuteNonQuery(tran, SQL_ADD, para));
}
