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