public PartlyCollection <VCollectUserTask> GetList(VCollectUserTaskFilter filter) { var where = filter.ConvertToWhereBuilder(); var tuple = GetPageSplitedCollection(filter.RowIndex, filter.PageSize, where.ToSqlString(TSqlBuilder.Instance)); return(tuple); }
public PartlyCollection <VCollectUserTask> GetViewList(VCollectUserTaskFilter filter) { return(_vCollectUserTaskAdapter.GetList(filter)); }
public IHttpActionResult GetTaskList([FromBody] TaskFilter filter) { #region 计算时间范围 DateTime date = DateTime.MinValue; DateTime dateNow = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); if (filter.TimeRange.HasValue) { switch (filter.TimeRange) { case 1: date = dateNow; break; case 2: date = dateNow.AddDays(-1); break; case 3: date = dateNow.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek))) - 7); break; case 4: date = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-1); break; case 5: date = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-3); break; case 6: date = DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(-1); break; //default: // date = dateNow; // break; } } #endregion VCollectUserTaskFilter queryFilter = new VCollectUserTaskFilter(); queryFilter.TemplateConfigInstanceName = filter.TaskTitle; queryFilter.CreatorTimeStart = date; //var roles = RoleinfoOperator.Instance.GetBelongsToRoles(WebHelper.GetCurrentUser().EmployeeCode); if (!UserInfoOperator.Instance.IsAdmin() || filter.IsOnlySelf) { queryFilter.CreatorLoginName = WebHelper.GetCurrentUser().LoginName; } if (UserInfoOperator.Instance.IsAdmin() && !string.IsNullOrEmpty(filter.TaskCreatorLoginName)) { queryFilter.CreatorLoginOrName = filter.TaskCreatorLoginName; } //if (!filter.IsOnlySelf) //{ // var startOrg = AuthHelper.GetPrivilegeStartOrg(); // queryFilter.UnitFullPath = startOrg; //} queryFilter.PageIndex = filter.PageIndex; queryFilter.PageSize = filter.PageSize; #region 计算任务类型 switch (filter.TaskType) { case 1: { queryFilter.TaskTypeList = new List <int>() { 1, 3 }; queryFilter.StatusList = new List <int>() { 0, 1, 2, 3 }; } break; case 2: { //queryFilter.TaskTypeList = new List<int>() { 1, 2, 3 }; queryFilter.StatusList = new List <int>() { 4 }; } break; case 3: { queryFilter.TaskTypeList = new List <int>() { 2 }; queryFilter.StatusList = new List <int>() { 0, 1, 2, 3 }; } break; //default: // { // queryFilter.TaskTypeList = new List<int>() { 1, 3 }; // queryFilter.StatusList = new List<int>() { 0, 1, 2, 3 }; // } // break; } #endregion if (filter.TaskStatus.HasValue) { queryFilter.StatusList = new List <int>() { filter.TaskStatus.Value }; } //queryFilter.TaskTypeList = filter.TaskType == 1 ? new List<int>() { 2 } : new List<int>() { 1, 3 }; //queryFilter.StatusList = new List<int>() { 0, 1, 2, 3 }; var data = VCollectUserTaskOperator.Instance.GetViewList(queryFilter); var tasks = data.Select(x => { var task = new Task(); task.ConvertEntity(x); return(task); }); return(BizResult(new ViewData <Task>() { Data = tasks, TotalCount = data.TotalCount })); }
public PartlyCollection <VCollectUserTask> SearchTask(string TempName, string time, int PageIndex, int PageSize, bool isWithFinish) { if (!string.IsNullOrEmpty(TempName)) { TempName = HttpUtility.UrlDecode(TempName.Trim()); } else { TempName = string.Empty; } if (!string.IsNullOrEmpty(time)) { time = base64Decode(HttpUtility.UrlDecode(time.Trim())); } DateTime date = DateTime.MinValue; DateTime dateNow = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); switch (time) { case "1": date = dateNow; break; case "2": date = dateNow.AddDays(-1); break; case "3": date = dateNow.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek))) - 7); break; case "4": date = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-1); break; case "5": date = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-3); break; case "6": date = DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(-1); break; } VCollectUserTaskFilter filter = new VCollectUserTaskFilter(); filter.TemplateConfigInstanceName = TempName; filter.CreatorTimeStart = date; filter.CreatorLoginName = WebHelper.GetCurrentUser().LoginName; filter.PageIndex = PageIndex; filter.PageSize = PageSize; var statusList = new List <int>(); statusList.Add(0); statusList.Add(1); statusList.Add(2); statusList.Add(3); if (isWithFinish) { statusList.Add(4); } filter.StatusList = statusList; var result = VCollectUserTaskOperator.Instance.GetViewList(filter); return(result); //return new {DataList = result, TotalCount = result.TotalCount}; }