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