/// <summary>
/// 添加/编辑
/// </summary>
/// <returns></returns>
public IActionResult AddOrEdit(Model.DB.Category model)
{
User loginuser = HttpContext.Session.GetObject <User>("loginuser");
model.operate_by = loginuser.username;
category_dal.AddOrEdit(model);
return(Json(new { Code = 200 }));
}
public IActionResult changestatus(Model.DB.Category model)
{
if (model.c_id == 0)
{
return(Json(new { Code = 100, res = "id不能为0" }));
}
else
{
return(Json(new { Code = 200, res = category_dal.changestatus(model.is_enable, model.c_id) }));
}
}
public bool AddOrEdit(Model.DB.Category model)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@c_id", model.c_id);
parameters.Add("@c_name", model.c_name);
parameters.Add("@operate_by", model.operate_by);
parameters.Add("@img_path", model.img_path);
parameters.Add("@is_enable", model.is_enable);
parameters.Add("@create_at", DateTime.Now.ToShortDateString());
parameters.Add("@operate_at", DateTime.Now.ToShortDateString());
if (model.c_id == 0)
{
string sqlstr = "insert into category (c_name,operate_by,img_path,is_enable,create_at,operate_at) values (@c_name,@operate_by,@img_path,@is_enable,@create_at,@operate_at)";
return(AddOrEdit(sqlstr, parameters));
}
else
{
string sqlstr = "update category set c_name=@c_name,operate_by=@operate_by,img_path=@img_path,operate_at=@operate_at where c_id=@c_id";
return(AddOrEdit(sqlstr, parameters));
}
}
