private void DoSelect()
{
if (SearchCriterion.Orders.Count == 0)
{
SearchCriterion.Orders.Add(new OrderCriterionItem("RootCode", true));
SearchCriterion.Orders.Add(new OrderCriterionItem("Code", true));
}
string dateFlag = this.RequestData["Date"] == null ? "365" : this.RequestData["Date"].ToString();
switch (dateFlag)
{
case "3":
SearchCriterion.SetSearch("PlanEndDate", DateTime.Now.AddDays(3), SearchModeEnum.LessThanEqual);
break;
case "7":
SearchCriterion.SetSearch("PlanEndDate", DateTime.Now.AddDays(7), SearchModeEnum.LessThanEqual);
break;
case "14":
SearchCriterion.SetSearch("PlanEndDate", DateTime.Now.AddDays(14), SearchModeEnum.LessThanEqual);
break;
case "30":
SearchCriterion.SetSearch("PlanEndDate", DateTime.Now.AddMonths(1), SearchModeEnum.LessThanEqual);
break;
case "31":
SearchCriterion.SetSearch("PlanEndDate", DateTime.Now.AddMonths(1), SearchModeEnum.LessThanEqual);
break;
case "180":
SearchCriterion.SetSearch("PlanEndDate", DateTime.Now.AddMonths(3), SearchModeEnum.LessThanEqual);
break;
case "365":
SearchCriterion.SetSearch("PlanEndDate", DateTime.Now.AddYears(1), SearchModeEnum.LessThanEqual);
break;
}
if (this.RequestData.Get <string>("Status") == "2")
{
ents = V_TaskWBS.FindAll(SearchCriterion, Expression.Sql(" (DutyId like '%" + this.UserInfo.UserID + "%' or UserIds like '%" + this.UserInfo.UserID + "%')"), Expression.Eq("State", "2"));
}
else if (this.RequestData.Get <string>("Status") == "1.5")
{
ents = V_TaskWBS.FindAll(SearchCriterion, Expression.Sql(" (DutyId like '%" + this.UserInfo.UserID + "%' or UserIds like '%" + this.UserInfo.UserID + "%')"), Expression.Eq("State", "1.5"));
}
else
{
ents = V_TaskWBS.FindAll(SearchCriterion, Expression.Sql(" (DutyId like '%" + this.UserInfo.UserID + "%' or UserIds like '%" + this.UserInfo.UserID + "%')"), Expression.Not(Expression.In("State", new string[] { "0", "1.5", "2" })));
}
PageState.Add("SysWorkFlowTaskList", ents);
}
