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(EnumUserRole.Admin, () => { using (DbConn PubConn = DbConn.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(EnumUserRole.Admin, () => { using (DbConn PubConn = DbConn.CreateConn(Config.TaskConnectString)) { PubConn.Open(); tb_category_dal dal = new tb_category_dal(); dal.Add(PubConn, model.categoryname); return RedirectToAction("index"); } })); }
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 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 List <tb_category_model> GetList(DbConn PubConn, string keyword) { return(SqlHelper.Visit(ps => { string sql = "select id,categoryname,categorycreatetime from tb_category "; if (!string.IsNullOrWhiteSpace(keyword)) { ps.Add("keyword", keyword); sql += "where categoryname like '%'+@keyword+'%'"; } DataSet ds = new DataSet(); PubConn.SqlToDataSet(ds, sql, ps.ToParameters()); List <tb_category_model> Model = new List <tb_category_model>(); foreach (DataRow dr in ds.Tables[0].Rows) { tb_category_model m = CreateModel(dr); Model.Add(m); } return Model; })); }
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); }