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