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