private void DoBatchDelete()
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
A_TaskWBS.DoBatchDelete(idList.ToArray());
}
}
protected void Page_Load(object sender, EventArgs e)
{
A_TaskWBS ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Delete:
ent = this.GetTargetData <A_TaskWBS>();
ent.Delete();
this.SetMessage("删除成功！");
break;
default:
if (RequestActionString == "batchdelete")
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
A_TaskWBS.DoBatchDelete(idList.ToArray());
}
}
else
{
SearchCriterion.SetSearch("DutyId", this.UserInfo.UserID);
SearchCriterion.SetOrder("SubmitDate", false);
string dateFlag = this.RequestData["Date"] == null ? "180" : this.RequestData["Date"].ToString();
switch (dateFlag)
{
case "3":
SearchCriterion.SetSearch("SubmitDate", DateTime.Now.AddDays(-3), SearchModeEnum.GreaterThanEqual);
break;
case "7":
SearchCriterion.SetSearch("SubmitDate", DateTime.Now.AddDays(-7), SearchModeEnum.GreaterThanEqual);
break;
case "14":
SearchCriterion.SetSearch("SubmitDate", DateTime.Now.AddDays(-14), SearchModeEnum.GreaterThanEqual);
break;
case "30":
SearchCriterion.SetSearch("SubmitDate", DateTime.Now.AddMonths(-1), SearchModeEnum.GreaterThanEqual);
break;
case "31":
SearchCriterion.SetSearch("SubmitDate", DateTime.Now.AddMonths(-1), SearchModeEnum.LessThanEqual);
break;
case "180":
SearchCriterion.SetSearch("SubmitDate", DateTime.Now.AddMonths(3), SearchModeEnum.LessThanEqual);
break;
}
if (this.RequestData.Get <string>("Status") == "0")
{
ents = A_TaskWBS.FindAll(SearchCriterion, Expression.IsNull("Tag"));
}
else
{
ents = A_TaskWBS.FindAll(SearchCriterion, Expression.IsNotNull("Tag"));
}
this.PageState.Add("SysWorkFlowTaskList", ents);
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
A_TaskWBS ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Delete:
ent = this.GetTargetData <A_TaskWBS>();
ent.Delete();
this.SetMessage("删除成功！");
break;
default:
if (RequestActionString == "batchdelete")
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
A_TaskWBS.DoBatchDelete(idList.ToArray());
}
}
else if (RequestActionString == "batchsubmit")
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
A_TaskWBS[] tents = A_TaskWBS.FindAll(Expression.In("Id", idList.ToArray()));
foreach (A_TaskWBS tent in tents)
{
tent.State = "2";
tent.Save();
}
}
}
else if (RequestActionString == "batchback")
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
A_TaskWBS[] tents = A_TaskWBS.FindAll(Expression.In("Id", idList.ToArray()));
foreach (A_TaskWBS tent in tents)
{
tent.State = "1";
tent.Save();
}
}
}
else
{
if (SearchCriterion.Orders.Count == 0)
{
SearchCriterion.Orders.Add(new OrderCriterionItem("PlanEndDate", 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 = A_TaskWBS.FindAll(SearchCriterion, Expression.Sql(" ParentId in (select Id from " + db + "..A_TaskWBS where DutyId like '%" + this.UserInfo.UserID + "%' ) and State='2'"));
}
else
{
ents = A_TaskWBS.FindAll(SearchCriterion, Expression.Sql(" ParentId in (select Id from " + db + "..A_TaskWBS where DutyId like '%" + this.UserInfo.UserID + "%' ) and State='1.5'"), Expression.IsNotNull("ParentID"));
}
this.PageState.Add("SysWorkFlowTaskList", ents);
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = RequestData.Get <string>("id", String.Empty);
ids = RequestData.GetList <string>("ids");
pids = RequestData.GetList <string>("pids");
year = RequestData.Get <string>("Year", String.Empty);
A_TaskWBS ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Update:
ent = this.GetMergedData <A_TaskWBS>();
ent.ParentID = String.IsNullOrEmpty(ent.ParentID) ? null : ent.ParentID;
ent.Update();
this.SetMessage("更新成功！");
break;
default:
if (RequestActionString == "batchdelete")
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
A_TaskWBS.DoBatchDelete(idList.ToArray());
}
}
else if (RequestActionString == "paste")
{
DoPaste();
}
else if (RequestActionString == "submittask")
{
ent = A_TaskWBS.Find(this.RequestData.Get <string>("Id"));
ent.State = "1";
ent.SubmitDate = DateTime.Now;
ent.SubmitUserId = this.UserInfo.UserID;
ent.SubmitUserName = this.UserInfo.Name;
ent.Save();
}
else if (RequestActionString == "backtask")
{
ent = A_TaskWBS.Find(this.RequestData.Get <string>("Id"));
ent.State = "0";
ent.Save();
}
else
{
DoSelect();
this.PageState.Add("BudgetType", SysEnumeration.GetEnumDict("BudgetType"));
this.PageState.Add("Years", SysEnumeration.GetEnumDict("Year"));
this.PageState.Add("AimType", SysEnumeration.GetEnumDict("AimType"));
}
if (this.RequestData.Get <string>("ChartSearch") == "T")
{
string sql = "select Name TaskType,0 CountFinish,0 CountNormal from dbo.SysEnumeration where ParentId='5cf5990a-a68d-40b7-8ae5-558b1732cc92'";
DataTable dt = DataHelper.QueryDataTable(sql);
string sqlAll = "";
string deptName = this.RequestData.Get <string>("DeptName");
string Year = this.RequestData.Get <string>("Year");
DataTable newDt = new DataTable();
foreach (DataColumn col in dt.Columns)
{
newDt.Columns.Add(col.ColumnName, col.DataType);
}
foreach (DataRow row in dt.Rows)
{
DataRow newrow = newDt.NewRow();
newrow.ItemArray = row.ItemArray;
newDt.Rows.Add(newrow);
string rootId = DataHelper.QueryValue <string>("select isnull(Id,'') from " + db + "..A_TaskWBS where (DeptName='" + deptName + "' or DutyName='" + deptName + "') and Year='" + year + "' and TaskType='" + row["TaskType"].ToString() + "'");
newrow["CountFinish"] = DataHelper.QueryValue("select isnull(count(*),0) from " + db + "..A_TaskWBS where (DeptName='" + deptName + "' or DutyName='" + deptName + "') and Year='" + year + "' and Path like '%" + rootId + "%' and State='2'");
newrow["CountNormal"] = DataHelper.QueryValue("select isnull(count(*),0) from " + db + "..A_TaskWBS where (DeptName='" + deptName + "' or DutyName='" + deptName + "') and Year='" + year + "' and Path like '%" + rootId + "%' and State<>'2'");
}
this.PageState.Add("ChartData", DataHelper.DataTableToDictList(newDt));
}
break;
}
}
