public static TaskEntity GetPushTaskForFinishTask(string taskid) { TaskEntity model = new TaskEntity(); DataSet ds = TaskDAL.BaseProvider.GetPushTaskForFinishTask(taskid); if (ds.Tables.Count > 0) { DataTable taskTB = ds.Tables["OrderTask"]; if (taskTB.Rows.Count == 1) { model = new TaskEntity(); model.FillData(taskTB.Rows[0]); model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID); } DataTable orderTB = ds.Tables["Order"]; if (orderTB != null && orderTB.Rows.Count == 1) { OrderEntity order = new OrderEntity(); order.FillData(orderTB.Rows[0]); model.Order = order; } } return(model); }
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.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); }
public static TaskEntity GetTaskByID(string taskid) { TaskEntity model = new TaskEntity(); DataTable dt = TaskDAL.BaseProvider.GetTaskByID(taskid); if (dt.Rows.Count > 0) { model.FillData(dt.Rows[0]); model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID); } return(model); }
public static List <TaskEntity> GetTasksByYXOrderID(string yxOrderID) { List <TaskEntity> list = new List <TaskEntity>(); DataTable dt = TaskDAL.BaseProvider.GetTasksByYXOrderID(yxOrderID); foreach (DataRow dr in dt.Rows) { TaskEntity model = new TaskEntity(); model.FillData(dr); model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID); list.Add(model); } return(list); }
public static TaskEntity GetPushTaskForChangeTaskOwner(string taskid) { TaskEntity model = null; DataSet ds = TaskDAL.BaseProvider.GetPushTaskForChangeTaskOwner(taskid); if (ds.Tables.Count > 0) { DataTable taskTB = ds.Tables["OrderTask"]; if (taskTB.Rows.Count == 1) { model = new TaskEntity(); model.FillData(taskTB.Rows[0]); } } return(model); }
public static TaskEntity GetTaskDetail(string taskID) { TaskEntity model = null; DataSet ds = TaskDAL.BaseProvider.GetTaskDetail(taskID); DataTable taskTB = ds.Tables["OrderTask"]; if (taskTB.Rows.Count > 0) { model = new TaskEntity(); model.FillData(taskTB.Rows[0]); model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID); //成员 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.GetUserCacheByUserID(member.MemberID, model.ClientID); model.TaskMembers.Add(member); } } //订单基本信息 model.Order = new OrderEntity(); model.Order.FillData(ds.Tables["Order"].Rows[0]); if (!string.IsNullOrEmpty(model.Order.BigCategoryID)) { var category = SystemBusiness.BaseBusiness.GetProcessCategoryByID(model.Order.BigCategoryID); model.Order.ProcessCategoryName = category == null ? "" : category.Name; } if (!string.IsNullOrEmpty(model.Order.CategoryID)) { var category = ProductsBusiness.BaseBusiness.GetCategoryByID(model.Order.CategoryID); var pcategory = ProductsBusiness.BaseBusiness.GetCategoryByID(category.PID); model.Order.CategoryName = pcategory.CategoryName + " > " + category.CategoryName; } } return(model); }
public static List <TaskEntity> GetPushTasksForNewOrder(string orderid) { List <TaskEntity> list = new List <TaskEntity>(); DataSet ds = TaskDAL.BaseProvider.GetPushTasksForNewOrder(orderid); if (ds.Tables.Count > 0) { DataTable taskTB = ds.Tables["OrderTask"]; foreach (DataRow dr in taskTB.Rows) { TaskEntity model = new TaskEntity(); model.FillData(dr); model.Owner = OrganizationBusiness.GetUserCacheByUserID(model.OwnerID, model.ClientID); list.Add(model); } } return(list); }