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