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