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 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 List <OrderEntity> GetOrders(EnumSearchType searchtype, string typeid, int status, int paystatus, int invoicestatus, int returnstatus, string searchuserid, string searchteamid, string searchagentid,
string begintime, string endtime, string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string agentid, string clientid)
{
List <OrderEntity> list = new List <OrderEntity>();
DataSet ds = OrdersDAL.BaseProvider.GetOrders((int)searchtype, typeid, status, paystatus, invoicestatus, returnstatus, searchuserid, searchteamid, searchagentid, begintime, endtime, keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, userid, agentid, clientid);
foreach (DataRow dr in ds.Tables[0].Rows)
{
OrderEntity model = new OrderEntity();
model.FillData(dr);
model.OrderType = SystemBusiness.BaseBusiness.GetOrderTypeByID(model.TypeID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.StatusStr = CommonBusiness.GetEnumDesc((EnumOrderStatus)model.Status);
if (model.Status == 2)
{
model.SendStatusStr = CommonBusiness.GetEnumDesc((EnumSendStatus)model.SendStatus);
}
else if (model.Status < 2)
{
model.SendStatusStr = "--";
}
list.Add(model);
}
return(list);
}
public List <OrderEntity> GetOpportunityaByCustomerID(string customerid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string agentid, string clientid)
{
List <OrderEntity> list = new List <OrderEntity>();
DataTable dt = CommonBusiness.GetPagerData("Orders", "*", "CustomerID='" + customerid + "' and Status =0 ", "AutoID", pageSize, pageIndex, out totalCount, out pageCount, false);
foreach (DataRow dr in dt.Rows)
{
OrderEntity model = new OrderEntity();
model.FillData(dr);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.Stage = SystemBusiness.BaseBusiness.GetOpportunityStageByID(model.StageID, model.AgentID, model.ClientID);
list.Add(model);
}
return(list);
}
public List <OrderEntity> GetOpportunitys(EnumSearchType searchtype, string typeid, string stageid, string searchuserid, string searchteamid, string searchagentid,
string begintime, string endtime, string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string agentid, string clientid)
{
List <OrderEntity> list = new List <OrderEntity>();
DataSet ds = OrdersDAL.BaseProvider.GetOpportunitys((int)searchtype, typeid, stageid, searchuserid, searchteamid, searchagentid, begintime, endtime, keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, userid, agentid, clientid);
foreach (DataRow dr in ds.Tables[0].Rows)
{
OrderEntity model = new OrderEntity();
model.FillData(dr);
model.OrderType = SystemBusiness.BaseBusiness.GetOrderTypeByID(model.TypeID, model.AgentID, model.ClientID);
model.Stage = SystemBusiness.BaseBusiness.GetOpportunityStageByID(model.StageID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
list.Add(model);
}
return(list);
}
public OrderEntity GetOrderByID(string orderid, string agentid, string clientid)
{
DataSet ds = OrdersDAL.BaseProvider.GetOrderByID(orderid, agentid, clientid);
OrderEntity model = new OrderEntity();
if (ds.Tables["Order"].Rows.Count > 0)
{
model.FillData(ds.Tables["Order"].Rows[0]);
model.OrderType = SystemBusiness.BaseBusiness.GetOrderTypeByID(model.TypeID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.AgentID);
model.StatusStr = CommonBusiness.GetEnumDesc((EnumOrderStatus)model.Status);
model.ExpressTypeStr = CommonBusiness.GetEnumDesc((EnumExpressType)model.ExpressType);
if (model.Status == 2)
{
model.SendStatusStr = CommonBusiness.GetEnumDesc((EnumSendStatus)model.SendStatus);
}
else if (model.Status < 2)
{
model.SendStatusStr = "--";
}
model.City = CommonBusiness.GetCityByCode(model.CityCode);
if (ds.Tables["Customer"].Rows.Count > 0)
{
model.Customer = new CustomerEntity();
model.Customer.FillData(ds.Tables["Customer"].Rows[0]);
}
model.Details = new List <OrderDetail>();
if (ds.Tables["Details"].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables["Details"].Rows)
{
OrderDetail detail = new OrderDetail();
detail.FillData(dr);
model.Details.Add(detail);
}
}
}
return(model);
}
