public JsonResult ProcessPageList(AppProductionLineProductProcess model, int page = 1, int rows = 10) { var query = db.AppProductionLineProductProcesses.AsQueryable(); if (model.CN_GUID_LINE_PRODUCT != Guid.Empty) { query = query.Where(m => m.CN_GUID_LINE_PRODUCT == model.CN_GUID_LINE_PRODUCT); } if (!string.IsNullOrWhiteSpace(model.CN_PROCESS_NAME)) { query = query.Where(m => m.CN_PROCESS_INFO.Contains(model.CN_PROCESS_INFO)); } if (!string.IsNullOrWhiteSpace(model.CN_PROCESS_ORDER)) { query = query.Where(m => m.CN_PROCESS_INFO.Contains(model.CN_PROCESS_INFO)); } if (!string.IsNullOrWhiteSpace(model.CN_PROCESS_INFO)) { query = query.Where(m => m.CN_PROCESS_INFO.Contains(model.CN_PROCESS_INFO)); } var list = query.OrderBy(obj => obj.CN_PROCESS_ORDER).Skip((page - 1) * rows).Take(rows).ToList(); var count = query.Count(); return(Json(ResultInfo.Success(new { rows = list, total = count }))); }
public JsonResult RemoveProcess(AppProductionLineProductProcess process) { if (process.CN_ID == 0) { return(Json(ResultInfo.Fail(Lang.ParamIsEmpty))); } db.AppProductionLineProductProcesses.Attach(process); db.AppProductionLineProductProcesses.Remove(process); db.SaveChanges(); return(Json(ResultInfo.Success("删除成功!"))); }
public JsonResult AddProcess(AppProductionLineProductProcess process) { if (process.CN_GUID_LINE_PRODUCT == Guid.Empty || string.IsNullOrWhiteSpace(process.CN_PROCESS_NAME) || string.IsNullOrWhiteSpace(process.CN_PROCESS_ORDER) ) { return(Json(ResultInfo.Fail(Lang.ParamIsEmpty))); } var user = LoginUserInfo.GetLoginUser(); var now = DateTime.Now; process.CN_DT_CREATE = now; process.CN_CREATE_BY = user.UserId; process.CN_CREATE_NAME = user.Name; process.CN_CREATE_LOGIN = user.Login; db.AppProductionLineProductProcesses.Add(process); db.SaveChanges(); return(Json(ResultInfo.Success("添加成功!"))); }