public JsonResult Edit(AppProductionLine model) { string msg = "修改成功"; var user = LoginUserInfo.GetLoginUser(); if (model.CN_ID == 0) { msg = "添加成功"; model.CN_GUID = Guid.NewGuid(); model.CN_DT_CREATE = DateTime.Now; model.CN_CREATE_BY = user.UserId; model.CN_CREATE_LOGIN = user.Login; model.CN_CREATE_NAME = user.Name; db.AppProductionLines.Add(model); } else { db.AppProductionLines.Attach(model); db.Entry(model).Property(x => x.CN_LINE_NAME).IsModified = true; db.Entry(model).Property(x => x.CN_LINE_CODE).IsModified = true; db.Entry(model).Property(x => x.CN_DT_EFFECTIVE).IsModified = true; db.Entry(model).Property(x => x.CN_DT_EXPIRY).IsModified = true; db.Entry(model).Property(x => x.CN_LINE_INFO).IsModified = true; } db.SaveChanges(); return(Json(ResultInfo.Success(msg.ToString()))); }
public JsonResult PageList(AppProductionLine model, int page = 1, int rows = 10) { var query = db.AppProductionLines.AsQueryable(); if (!string.IsNullOrWhiteSpace(model.CN_LINE_NAME)) { query = query.Where(m => m.CN_LINE_NAME.Contains(model.CN_LINE_NAME)); } if (!string.IsNullOrWhiteSpace(model.CN_LINE_CODE)) { query = query.Where(m => m.CN_LINE_CODE.Contains(model.CN_LINE_CODE)); } var list = query.OrderBy(obj => obj.CN_LINE_NAME).Skip((page - 1) * rows).Take(rows).ToList(); var count = query.Count(); return(Json(ResultInfo.Success(new { rows = list, total = count }))); }