public IActionResult Change(string id) { var model = new SwGoods(); Service.Command <SwGoods>((db, o) => { if (!string.IsNullOrEmpty(id)) { model = db.Queryable <SwGoods>().Where(m => m.ID == id).First(); } else { model.ID = ""; } var tList = db.Queryable <SwGoodType>().ToList(); ViewBag.TypeList = tList; }); return(View(model)); }
public JsonResult ChangeSubmit(SwGoods Model) { var jsonm = new ResultJson(); jsonm.data = Model; var model = new SwGoods(); try { using (var db = SugarBase.GetIntance()) { if (!string.IsNullOrEmpty(Model.ID)) { model = db.Queryable <SwGoods>().Where(m => m.ID == Model.ID).First(); } if (model == null) { model = new SwGoods(); } model.Title = Model.Title; model.Content = Model.Content; model.GoodsKeys = Model.GoodsKeys; model.Sort = Model.Sort; model.IsHot = Model.IsHot; if (Model.IsTop) { if (!model.IsTop) { var TopSortModel = db.Queryable <SwGoods>().Where(m => m.ID != model.ID).Select(m => new { TopSort = SqlFunc.AggregateMax(m.TopSort) }).First(); model.TopSort = TopSortModel.TopSort + 1; } } else { model.TopSort = 0; } model.IsTop = Model.IsTop; model.Status = Model.Status; model.TypeID = Model.TypeID; if (!string.IsNullOrEmpty(model.TypeID)) { var typeModel = db.Queryable <SwGoodType>().Where(m => m.ID == model.TypeID).First(); if (typeModel != null) { model.TypeName = typeModel.Title; } } if (string.IsNullOrEmpty(Model.ID)) { SetSysLog("【添加文章】" + Model.Title, 3, 1); db.Insertable(model).ExecuteCommand(); jsonm.status = 200; } else { SetSysLog("【编辑文章】" + model.Title, 3, 1); db.Updateable(model).ExecuteCommand(); jsonm.status = 200; } } } catch (Exception ex) { LogProvider.Error("编辑文章", ex); jsonm.status = 500; jsonm.msg = "保存失败"; } return(Json(jsonm)); }