/// <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; }
/// <summary> /// 获取任务详情 /// </summary> /// <param name="taskID"></param> /// <returns></returns> public static TaskEntity GetTaskDetail(string taskID) { TaskEntity model = null; DataSet ds = TaskDAL.BaseProvider.GetTaskDetail(taskID); DataTable taskTB= ds.Tables["OrderTask"]; if (taskTB.Rows.Count == 1) { model = new TaskEntity(); model.FillData(taskTB.Rows[0]); model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID); DataTable memberTB = ds.Tables["TaskMember"]; model.TaskMembers = new List<IntFactoryEntity.Task.TaskMember>(); if (memberTB.Rows.Count > 0) { foreach (DataRow m in memberTB.Rows) { TaskMember member = new TaskMember(); member.FillData(m); member.Member = OrganizationBusiness.GetUserByUserID(member.MemberID, member.AgentID); model.TaskMembers.Add(member); } } } return model; }
/// <summary> /// 获取订单的任务列表 /// </summary> /// <param name="orderID"></param> /// <returns></returns> public static List<TaskEntity> GetTasksByOrderID(string orderID) { List<TaskEntity> list = new List<TaskEntity>(); DataTable dt = TaskDAL.BaseProvider.GetTasksByOrderID(orderID); foreach (DataRow dr in dt.Rows) { TaskEntity model = new TaskEntity(); model.FillData(dr); model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID); list.Add(model); } return list; }
public static List<TaskEntity> GetTasksByEndTime(string startEndTime, string endEndTime, int orderType, int filterType, int finishStatus,int preFinishStatus,int taskType, string userID, string clientID, int pageSize, int pageIndex, ref int totalCount, ref int pageCount) { List<TaskEntity> list = new List<TaskEntity>(); DataSet ds = TaskDAL.BaseProvider.GetTasksByEndTime(startEndTime, endEndTime, orderType, filterType, finishStatus,preFinishStatus,taskType, userID, 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.GetUserByUserID(model.OwnerID, model.AgentID); 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.UseDays = (DateTime.Now - model.CompleteTime).Days; } list.Add(model); } return list; }