public ActionResult GetSingleProjInfo(string id) { var pj = this.service.Project.Get(id); ProjInfoVm pvm = new ProjInfoVm(); if (pj != null) { pvm.Address = pj.ProjectAddr; if (String.IsNullOrWhiteSpace(pj.ProjectAddr)) { double bd_lng = 0; double bd_lat = 0; pvm.Lat = bd_lat; pvm.Lng = bd_lng; } pvm.LinkMan = pj.LinkMan; pvm.LinkTel = pj.Tel; pvm.Name = pj.ProjectName; pvm.ProjId = pj.ID; pvm.TskVms = new List <TasksVm>(); string cmpStatus = "007003"; //已完成 string undoStatus = "007004"; //已撤销 //var avlibCts = unitOfWork.CarTaskRepository.Get(s => s.StatusID != cmpStatus.Id && s.StatusID != undoStatus.Id && (!s.Task.Completed)).ToList(); var avlibCts = this.service.ShippingDocument.Query().Where(s => s.Status != cmpStatus && s.Status != undoStatus).ToList(); string carnos = ""; //未完成任务单 //var tsks = unitOfWork.TaskRepository.Get(s => !s.Completed && s.ProjectID == pj.ID).ToList(); var tsks = this.service.ProduceTask.Query().Where(t => !t.IsCompleted && t.ProjectID == pj.ID).ToList(); foreach (var t in tsks) { var cts = avlibCts.Where(s => s.TaskID == t.ID).ToList(); foreach (var c in cts) { carnos += (c.CarID + " "); } TasksVm tv = new TasksVm(); tv.TaskNo = t.ID; tv.ConsPos = t.ConsPos; tv.PlanCube = t.PlanCube; tv.ProvidedCube = t.ProvidedCube; tv.Grade = t.ConStrength; pvm.TskVms.Add(tv); } //本月已完成方量 //var cmpCts = unitOfWork.CarTaskRepository.Get(s => s.StatusID == cmpStatus.Id && (s.Task.ProjectID == pj.ID)).ToList(); var cmpCts = this.service.ShippingDocument.Query().Where(s => !s.IsEffective && (s.ProjectID == pj.ID)).ToList(); var now = DateTime.Now; var theMon = new DateTime(now.Year, now.Month, 1); var theDay = new DateTime(now.Year, now.Month, now.Day); var monCube = cmpCts.Where(s => s.ProduceDate >= theMon).Sum(s => s.Cube); var dayCube = cmpCts.Where(s => s.ProduceDate >= theDay).Sum(s => s.Cube); pvm.MonCube = monCube == null ? 0.0M :monCube; pvm.DayCube = dayCube == null ? 0.0M :monCube; pvm.carNos = carnos; //该工地线路 //pvm.ProjectPaths = unitOfWork.ProjectPathRepository.Get(s => s.ProjectID == id && s.IsUsed && s.IsComplete).ToList(); } return(Json(pvm, JsonRequestBehavior.AllowGet)); }
public TasksVm GetTasks(string sortColumn = "", bool descending = false) { var tasks = _taskRepository.GetTasks(sortColumn, descending); TasksVm tasksVm = new TasksVm { Tasks = tasks }; return(tasksVm); }
public TasksVm GetTasksPaging(int page, string sortColumn = "", bool descending = false) { int pageSize = Convert.ToInt32(ConfigurationManager.AppSettings["DefaultPageSize"]); var pagiList = _taskRepository.GetTasks(sortColumn, descending); IEnumerable <TodolistModel> tasksPerPages = pagiList.Skip((page - 1) * pageSize).Take(pageSize); PagingInfo pagingInfo = new PagingInfo { PageNumber = page, PageSize = pageSize, TotalItems = pagiList.Count }; TasksVm tasksVm = new TasksVm { PagingInfoVm = pagingInfo, TasksPage = tasksPerPages }; return(tasksVm); }
public TasksVm GetTasksPaging(int page = 1, int length = 0) { int pageSize = length; TasksVm tasksVm; var pagiList = _taskRepository.GetTasks(); if (length == 0) { tasksVm = new TasksVm { TasksPage = pagiList }; return(tasksVm); } IEnumerable <TodolistModel> tasksPerPages = pagiList.Skip((page - 1) * pageSize).Take(pageSize); PagingInfo pagingInfo = new PagingInfo { PageNumber = page, PageSize = pageSize, TotalItems = pagiList.Count }; tasksVm = new TasksVm { PagingInfoVm = pagingInfo, TasksPage = tasksPerPages }; return(tasksVm); }