public bool Update(DbConn PubConn, tb_category_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { new ProcedureParameter("@categoryname", model.categoryname), new ProcedureParameter("@id", model.id), }; int rev = PubConn.ExecuteSql(@"update tb_category set categoryname=@categoryname where id=@id", Par); return rev == 1; }
public JsonResult Update(tb_category_model model) { return this.Visit(Core.EnumUserRole.Admin, () => { using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString)) { PubConn.Open(); tb_category_dal dal = new tb_category_dal(); dal.Update(PubConn, model); return Json(new { code = 1, msg = "Success" }); } }); }
public ActionResult Add(tb_category_model model) { return this.Visit(Core.EnumUserRole.Admin, () => { using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString)) { PubConn.Open(); tb_category_dal dal = new tb_category_dal(); dal.Add(PubConn, model.categoryname); return RedirectToAction("index"); } }); }
public virtual bool Edit(DbConn PubConn, tb_category_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { //分类名 new ProcedureParameter("@categoryname", model.categoryname), //分类创建时间 new ProcedureParameter("@categorycreatetime", model.categorycreatetime) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_category set categoryname=@categoryname,categorycreatetime=@categorycreatetime where id=@id", Par); return rev == 1; }
public virtual bool Add(DbConn PubConn, tb_category_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { //分类名 new ProcedureParameter("@categoryname", model.categoryname), //分类创建时间 new ProcedureParameter("@categorycreatetime", model.categorycreatetime) }; int rev = PubConn.ExecuteSql(@"insert into tb_category(categoryname,categorycreatetime) values(@categoryname,@categorycreatetime)", Par); return rev == 1; }
public virtual tb_category_model CreateModel(DataRow dr) { var o = new tb_category_model(); // if(dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } //分类名 if(dr.Table.Columns.Contains("categoryname")) { o.categoryname = dr["categoryname"].Tostring(); } //分类创建时间 if(dr.Table.Columns.Contains("categorycreatetime")) { o.categorycreatetime = dr["categorycreatetime"].ToDateTime(); } return o; }