public IEnumerable <Task> Get(string userId, FilterTasks filterTasks) { var tasks = _context.Tasks .Include(x => x.Category) .Where(x => x.UserId == userId && x.IsExecuted == filterTasks.IsExecuted); if (filterTasks.CategoryId != 0) { tasks = tasks.Where(x => x.CategoryId == filterTasks.CategoryId); } if (!string.IsNullOrWhiteSpace(filterTasks.Title)) { tasks = tasks.Where(x => x.Title.Contains(filterTasks.Title)); } return(tasks.OrderBy(x => x.Term).ToList()); }
public IEnumerable <Task> Get(string userId, FilterTasks filterTasks) { return(_unitOfWork.Task.Get(userId, filterTasks)); }
public JsonResult GetTasks(string filter, string userID, string clientID) { var paras = new FilterTasks(); if (!string.IsNullOrEmpty(filter)) { paras = JsonConvert.DeserializeObject <FilterTasks>(filter); } int pageCount = 0; int totalCount = 0; string ownerID = userID; List <TaskEntity> list = TaskBusiness.GetTasks(paras.keyWords.Trim(), ownerID, paras.filtertype, paras.status, paras.finishStatus, -1, -1, paras.colorMark, paras.taskType, paras.beginDate, paras.endDate, string.Empty, string.Empty, paras.orderType, paras.orderProcessID, paras.orderStageID, (EnumTaskOrderColumn)paras.taskOrderColumn, paras.isAsc, clientID, paras.pageSize, paras.pageIndex, ref totalCount, ref pageCount); var lables = SystemBusiness.BaseBusiness.GetLableColor(clientID, EnumMarkType.Tasks).ToList(); List <Dictionary <string, object> > tasks = new List <Dictionary <string, object> >(); string domainUrl = Request.Url.Scheme + "://" + Request.Url.Host; foreach (var item in list) { Dictionary <string, object> task = new Dictionary <string, object>(); task.Add("taskID", item.TaskID); task.Add("title", item.Title); task.Add("mark", item.Mark); task.Add("colorMark", item.ColorMark); string colorValue = string.Empty; var lable = lables.Find(m => m.ColorID == item.ColorMark); if (lable != null) { colorValue = lable.ColorValue; } task.Add("colorValue", colorValue); task.Add("finishStatus", item.FinishStatus); task.Add("preTitle", item.PreTitle); task.Add("preFinishStatus", item.PreFinishStatus); task.Add("pEndTime", item.PEndTime.ToString("yyyy-MM-dd") != "0001-01-01" ? item.PEndTime.ToString("yyyy-MM-dd") : ""); task.Add("orderType", item.OrderType); var orderImg = item.OrderImg; if (!string.IsNullOrEmpty(item.OrderImg) && !item.OrderImg.Contains("bkt.clouddn.com")) { orderImg = domainUrl + item.OrderImg; } task.Add("orderImg", orderImg); task.Add("acceptTime", item.AcceptTime.ToString("yyyy-MM-dd") != "0001-01-01" ? item.AcceptTime.ToString("yyyy-MM-dd"):""); task.Add("endTime", item.EndTime.ToString("yyyy-MM-dd") != "0001-01-01" ? item.EndTime.ToString("yyyy-MM-dd"):""); task.Add("completeTime", item.CompleteTime.ToString("yyyy-MM-dd") != "0001-01-01" ? item.CompleteTime.ToString("yyyy-MM-dd"):""); task.Add("createTime", item.CreateTime.ToString("yyyy-MM-dd")); Dictionary <string, object> order = new Dictionary <string, object>(); var orderItem = item.Order; order.Add("goodsName", orderItem.GoodsName); order.Add("goodsCode", orderItem.IntGoodsCode); order.Add("planTime", orderItem.PlanTime.ToString("yyyy-MM-dd")); task.Add("order", order); tasks.Add(task); } JsonDictionary.Add("tasks", tasks); JsonDictionary.Add("totalCount", totalCount); JsonDictionary.Add("pageCount", pageCount); return(new JsonResult { Data = JsonDictionary, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }