public ActionResult Create(TimeLineModel model) { ApiResult <bool> result = new ApiResult <bool>(); //编写创建model逻辑 using (var dbContext = new TimeLineDb()) { TimeLineModel newModel = model; try { newModel.CreateTime = DateTime.Now; newModel.UpdateTime = DateTime.Now; newModel.IsDeleted = false; dbContext.timeLineModels.Add(newModel); int ret = dbContext.SaveChanges(); if (ret > 0) { result.Code = 10000; result.Data = true; result.IsSuccess = true; } else { result.Code = 20000; result.Data = false; result.IsSuccess = false; } } catch (Exception e) { Console.Write(e.Message); } } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(TimeLineModel model) { ApiResult <TimeLineModel> result = new ApiResult <TimeLineModel>(); using (var db = new TimeLineDb()) { var dbmodel = db.timeLineModels.Where(p => p.Id == model.Id).First(); if (dbmodel != null) { dbmodel.Copy = model.Copy; dbmodel.Images = model.Images; dbmodel.TitleYear = model.TitleYear; dbmodel.TitleMonth = model.TitleMonth; dbmodel.TitleDay = model.TitleDay; dbmodel.UpdateTime = DateTime.Now; } db.Entry(dbmodel).State = System.Data.Entity.EntityState.Modified; var ret = db.SaveChanges(); if (ret > 0) { result.Code = 200; result.Data = dbmodel; result.IsSuccess = true; } return(Json(result)); } }
public ActionResult Delete(int id) { ApiResult <bool> result = new ApiResult <bool>(); int ret = 0; using (var db = new TimeLineDb()) { var model = db.timeLineModels.Where(p => p.Id == id).First(); if (model != null) { model.IsDeleted = true; model.UpdateTime = DateTime.Now; db.Entry(model).State = System.Data.Entity.EntityState.Modified; ret = db.SaveChanges(); } } if (ret > 0) { result.Code = 200; result.Data = true; result.IsSuccess = true; } else { result.Code = 500; result.Data = false; result.IsSuccess = false; } return(Json(result)); }
public ActionResult Index() { List <TimeLineModel> model = new List <TimeLineModel>(); using (var db = new TimeLineDb()) { model = db.timeLineModels.Where(p => p.IsDeleted == false).OrderByDescending(o => o.Id).ToList <TimeLine.Models.TimeLineModel>(); } ViewBag.models = model; ViewBag.json = JsonConvert.SerializeObject(model); return(View()); }
public ActionResult Edit(int id) { TimeLineModel model = new TimeLineModel(); using (var db = new TimeLineDb()) { var findModel = db.timeLineModels.Where(p => p.Id == id).First(); if (findModel != null) { model = findModel; } } return(View(model)); }
public ActionResult AjaxLineList(int page = 1, int limit = 10) { var list = new List <TimeLineModel>(); LayUIResult <TimeLineModel> result = null; using (var db = new TimeLineDb()) { list = db.timeLineModels.Where(i => i.IsDeleted == false).OrderByDescending(p => p.CreateTime).ToList(); var currentlist = list.Skip(((page - 1) * limit)).Take(limit).ToList(); if (list != null && list.Count > 0) { result = new LayUIResult <TimeLineModel>(); result.code = 0; result.msg = "请求成功"; result.count = list.Count; result.data = currentlist; } } return(Json(result, JsonRequestBehavior.AllowGet)); }