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