/// <summary>
/// 获取任务列表
/// </summary>
/// <param name="keyWords"></param>
/// <param name="ownerID"></param>
/// <param name="finishStatus">-1：所有；0：进行中；1：已完成</param>
/// <param name="beginDate"></param>
/// <param name="EndDate"></param>
/// <param name="clientID"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="TotalCount"></param>
/// <param name="PageCount"></param>
/// <returns></returns>
public static List<TaskEntity> GetTasks(string keyWords, string ownerID, int isParticipate, int status, int finishStatus, int invoiceStatus,int preFinishStatus,
int colorMark, int taskType, string beginDate, string endDate, string beginEndDate, string endEndDate,
int orderType, string orderProcessID, string orderStageID,
EnumTaskOrderColumn taskOrderColumn,int isAsc, string clientID,
int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
List<TaskEntity> list = new List<TaskEntity>();
DataTable dt = TaskDAL.BaseProvider.GetTasks(keyWords, ownerID,isParticipate, status, finishStatus, invoiceStatus,preFinishStatus,
colorMark, taskType, beginDate, endDate, beginEndDate,endEndDate,
orderType, orderProcessID, orderStageID,
(int)taskOrderColumn, isAsc, clientID,
pageSize, pageIndex, ref totalCount, ref pageCount);
foreach (DataRow dr in dt.Rows)
{
TaskEntity model = new TaskEntity();
model.FillData(dr);
//model.Stage = SystemBusiness.BaseBusiness.GetOrderStageByID(model.StageID, model.ProcessID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
if (model.FinishStatus == 1)
{
if (model.EndTime <= DateTime.Now)
{
model.WarningStatus = 2;
model.WarningTime = "超期：" + (DateTime.Now - model.EndTime).Days.ToString("D2") + "天 " + (DateTime.Now - model.EndTime).Hours.ToString("D2") + "时 " + (DateTime.Now - model.EndTime).Minutes.ToString("D2") + "分";
model.WarningDays = (DateTime.Now - model.EndTime).Days;
model.UseDays = (model.EndTime - model.AcceptTime).Days;
}
else if ((model.EndTime - DateTime.Now).TotalHours * 3 < (model.EndTime - model.AcceptTime).TotalHours)
{
model.WarningStatus = 1;
model.WarningTime = "剩余：" + (model.EndTime - DateTime.Now).Days.ToString("D2") + "天 " + (model.EndTime - DateTime.Now).Hours.ToString("D2") + "时 " + (model.EndTime - DateTime.Now).Minutes.ToString("D2") + "分";
model.WarningDays = (model.EndTime - DateTime.Now).Days;
model.UseDays = (DateTime.Now - model.AcceptTime).Days;
}
else
{
model.WarningTime = "剩余：" + (model.EndTime - DateTime.Now).Days.ToString("D2") + "天 " + (model.EndTime - DateTime.Now).Hours.ToString("D2") + "时 " + (model.EndTime - DateTime.Now).Minutes.ToString("D2") + "分";
model.WarningDays = (model.EndTime - DateTime.Now).Days;
model.UseDays = (DateTime.Now - model.AcceptTime).Days;
}
}
else
{
model.UseDays = (model.EndTime - model.AcceptTime).Days;
}
list.Add(model);
}
return list;
}
public static List <TaskEntity> GetTasks(string keyWords, string ownerID, int filterType, int status, int finishStatus, int invoiceStatus, int preFinishStatus,
int colorMark, int taskType, string beginDate, string endDate, string beginEndDate, string endEndDate,
int orderType, string orderProcessID, string orderStageID,
EnumTaskOrderColumn taskOrderColumn, int isAsc, string clientID,
int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
List <TaskEntity> list = new List <TaskEntity>();
DataSet ds = TaskDAL.BaseProvider.GetTasks(keyWords, ownerID, filterType, status, finishStatus, invoiceStatus, preFinishStatus,
colorMark, taskType, beginDate, endDate, beginEndDate, endEndDate,
orderType, orderProcessID, orderStageID,
(int)taskOrderColumn, isAsc, clientID,
pageSize, pageIndex, ref totalCount, ref pageCount);
DataTable dt = ds.Tables["Tasks"];
DataTable orders = ds.Tables["Orders"];
foreach (DataRow dr in dt.Rows)
{
TaskEntity model = new TaskEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID);
if (orders.Rows.Count > 0)
{
foreach (DataRow dr2 in orders.Select(" OrderID='" + model.OrderID + "'"))
{
OrderEntity order = new OrderEntity();
order.FillData(dr2);
model.Order = order;
}
}
if (model.FinishStatus == 1)
{
if (model.EndTime <= DateTime.Now)
{
model.WarningStatus = 2;
model.WarningTime = "超期：" + (DateTime.Now - model.EndTime).Days.ToString("D2") + "天 " + (DateTime.Now - model.EndTime).Hours.ToString("D2") + "时 " + (DateTime.Now - model.EndTime).Minutes.ToString("D2") + "分";
model.WarningDays = (DateTime.Now - model.EndTime).Days;
model.UseDays = (model.EndTime - model.AcceptTime).Days;
}
else if ((model.EndTime - DateTime.Now).TotalHours * 3 < (model.EndTime - model.AcceptTime).TotalHours)
{
model.WarningStatus = 1;
model.WarningTime = "剩余：" + (model.EndTime - DateTime.Now).Days.ToString("D2") + "天 " + (model.EndTime - DateTime.Now).Hours.ToString("D2") + "时 " + (model.EndTime - DateTime.Now).Minutes.ToString("D2") + "分";
model.WarningDays = (model.EndTime - DateTime.Now).Days;
model.UseDays = (DateTime.Now - model.AcceptTime).Days;
}
else
{
model.WarningTime = "剩余：" + (model.EndTime - DateTime.Now).Days.ToString("D2") + "天 " + (model.EndTime - DateTime.Now).Hours.ToString("D2") + "时 " + (model.EndTime - DateTime.Now).Minutes.ToString("D2") + "分";
model.WarningDays = (model.EndTime - DateTime.Now).Days;
model.UseDays = (DateTime.Now - model.AcceptTime).Days;
}
}
else
{
model.WarningStatus = 3;
model.UseDays = (model.EndTime - model.AcceptTime).Days;
model.WarningDays = (DateTime.Now - model.CompleteTime).Days;
}
list.Add(model);
}
return(list);
}
