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