public ActionResult SyMessagesList(CBSyJobPool model)
{
if (Request.IsAjaxRequest())
{
var pager = new Pager <CBSyJobPool>
{
PageFilter =
{
Status = model.Status == 0 ? 0 : model.Status,//默认2，,未处理
TaskType = 0,
ExecutorSysNo = CurrentUser.Base.SysNo
},
CurrentPage = model.id
};
//当前用户对应分销商，2015-12-19 王耀发 创建
if (CurrentUser.IsBindDealer)
{
pager.PageFilter.DealerSysNo = CurrentUser.Dealer.SysNo;
pager.PageFilter.IsBindDealer = CurrentUser.IsBindDealer;
}
//是否绑定所有经销商
pager.PageFilter.IsBindAllDealer = CurrentUser.IsBindAllDealer;
pager.PageFilter.DealerCreatedBy = CurrentUser.Base.SysNo;
SyJobPoolManageBo.Instance.GetMessageList(pager);
//SyJobPoolManageBo.Instance.GetJobSpoolList(pager);
var list = new PagedList <CBSyJobPool>
{
TData = pager.Rows,
CurrentPageIndex = pager.CurrentPage,
TotalItemCount = pager.TotalRows,
PageSize = pager.PageSize
};
return(PartialView("_AjaxPagerSyMessages", list));
}
var item = new SelectListItem()
{
Text = @"全部", Value = "", Selected = true
};
var statustList = new List <SelectListItem>()
{
item
};
Util.EnumUtil.ToListItem <SystemStatus.任务池状态>(ref statustList);
ViewBag.Status = new SelectList(statustList, "Value", "Text");
return(View());
}
public ActionResult SearchSmsConfig(CBSyJobPool model)
{
model.id = model.id > 0 ? model.id : 1;
model.PageSize = 10;
var configModel = SyJobSmsConfigBo.Instance.GetFirst();
var hours = configModel != null ? configModel.MaxDealTime : 3;
var pager = Hyt.BLL.Sys.SyJobPoolManageBo.Instance.GetOverTimeSyJobsList(hours, model);
var list = new PagedList <CBSyJobPool>();
list.TData = pager.Rows;
list.CurrentPageIndex = pager.CurrentPage;
list.TotalItemCount = pager.TotalRows;
list.PageSize = pager.PageSize;
return(PartialView("_SyJobSmsConfig", list));
}
public ActionResult Search(CBSyJobPool model)
{
var pager = new Pager <CBSyJobPool>
{
PageFilter =
{
Status = model.Status,
ExecutorSysNo = model.ExecutorSysNo,
TaskSysNo = model.TaskSysNo,
TaskType = model.TaskType,
Sort = model.Sort,
SelectedAgentSysNo = model.AgentSysNo,
SelectedDealerSysNo = model.DealerSysNo
}
};
//当前用户对应仓库权限，2016-6-13 王耀发 创建
pager.PageFilter.HasAllWarehouse = SyUserGroupBo.Instance.IsHasAllWarehouse(CurrentUser.Base.SysNo);
pager.PageFilter.Warehouses = CurrentUser.Warehouses;
//当前用户对应分销商，2016-2-16 王耀发 创建
if (CurrentUser.IsBindDealer)
{
int DealerSysNo = CurrentUser.Dealer.SysNo;
pager.PageFilter.DealerSysNo = DealerSysNo;
pager.PageFilter.IsBindDealer = CurrentUser.IsBindDealer;
}
//是否绑定所有经销商
pager.PageFilter.IsBindAllDealer = CurrentUser.IsBindAllDealer;
pager.PageFilter.DealerCreatedBy = CurrentUser.Base.SysNo;
pager.CurrentPage = model.id;
Hyt.BLL.Sys.SyJobPoolManageBo.Instance.GetJobSpoolList(pager);
var list = new PagedList <CBSyJobPool>();
list.TData = pager.Rows;
list.CurrentPageIndex = pager.CurrentPage;
list.TotalItemCount = pager.TotalRows;
list.PageSize = pager.PageSize;
return(PartialView("_AjaxPager", list));
}
public ActionResult SyJobSmsConfig(CBSyJobPool model)
{
var hours = 3;
var configModel = SyJobSmsConfigBo.Instance.GetFirst();
if (configModel != null)
{
hours = configModel.MaxDealTime;
}
var list = SyJobPoolManageBo.Instance.GetDealingOverTimeSyJobs(hours);
int pagecount = list.Count;
if (pagecount > model.id * model.PageSize)
{
list = list.Skip(model.id * model.PageSize).Take(model.PageSize).ToList();
}
ViewBag.PageIndex = model.id;
return(View(list));
}
/// <summary>
/// 分页查询当日达未处理订单
/// </summary>
/// <param name="hours">几小时之类未处理</param>
/// <param name="model">订单池查询实体类</param>
/// <returns>当日达未处理订单列表</returns>
/// <remarks>2014-08-05 余勇 创建</remarks>
public override Pager <CBSyJobPool> GetOverTimeSyJobsList(int hours, CBSyJobPool model)
{
const string sql = @"(select c.*,b.username as ExecutorSysName,b.mobilephonenumber
from SyJobPool c left join SyUser b on b.SysNo=c.ExecutorSysNo
where (@0 = 0 or c.TaskSysNo like @0)
and(
(@1 = 2 and (c.Status =@2)) --已分配
or (@1 = 1 and c.Status = @3) --待分配
or (@1 = 0 and (c.Status=@2 or c.Status=@3)) --待处理或待分配
)
and (c.taskType=(@4) or c.tasktype=(@5)) --任务类型为订单审核或出库
and (case when convert(char(10),c.AssignDate,110)='1900-01-01' then floor(datediff(c.CreatedDate,SYSDATETIME())*24)
else floor(datediff(c.AssignDate,SYSDATETIME())*24) end) >=@6
)tb";
var dataList = Context.Select <CBSyJobPool>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
var paras = new object[]
{
model.TaskSysNo,
model.Status,
(int)SystemStatus.任务池状态.待处理,
(int)SystemStatus.任务池状态.待分配,
(int)SystemStatus.任务对象类型.客服订单审核,
(int)SystemStatus.任务对象类型.客服订单提交出库,
hours
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var sort = "(case when convert(char(10),AssignDate,110)='1900-01-01' then SYSDATETIME()-CreatedDate else SYSDATETIME()-AssignDate end) desc";
var pager = new Pager <CBSyJobPool>
{
CurrentPage = model.id,
TotalRows = dataCount.QuerySingle(),
Rows = dataList.OrderBy(sort).Paging(model.id, model.PageSize).QueryMany()
};
return(pager);
}
public JsonResult JobPool(CBSyJobPool model)
{
var pager = new Pager <CBSyJobPool>
{
PageFilter =
{
//Status = model.Status == 0 ? 0 : model.Status,//默认2，,未处理
Status = (int)SystemStatus.任务池状态.待处理,
TaskType = 0,
ExecutorSysNo = CurrentUser.Base.SysNo
},
PageSize = 99,
CurrentPage = model.id
};
//当前用户对应分销商，2015-12-19 王耀发 创建
if (CurrentUser.IsBindDealer)
{
pager.PageFilter.DealerSysNo = CurrentUser.Dealer.SysNo;
pager.PageFilter.IsBindDealer = CurrentUser.IsBindDealer;
}
//是否绑定所有经销商
pager.PageFilter.IsBindAllDealer = CurrentUser.IsBindAllDealer;
pager.PageFilter.DealerCreatedBy = CurrentUser.Base.SysNo;
Hyt.BLL.Sys.SyJobPoolManageBo.Instance.GetMessageList(pager);
var list = new PagedList <CBSyJobPool>
{
TData = pager.Rows,
CurrentPageIndex = pager.CurrentPage,
TotalItemCount = pager.TotalRows,
PageSize = pager.PageSize
};
return(Json(from item in list.TData select new { JobDescription = item.JobDescription, JobUrl = item.JobUrl, TaskType = Hyt.Util.EnumUtil.GetDescription(typeof(Hyt.Model.WorkflowStatus.SystemStatus.任务对象类型), item.TaskType), Status = Hyt.Util.EnumUtil.GetDescription(typeof(Hyt.Model.WorkflowStatus.SystemStatus.任务池状态), item.Status) }));
}
public ActionResult JobPooSearch(CBSyJobPool model)
{
var pager = new Pager <CBSyJobPool>
{
PageFilter =
{
Status = (int)SystemStatus.任务池状态.待处理,
TaskType = 0,
ExecutorSysNo = CurrentUser.Base.SysNo
},
PageSize = 10,
CurrentPage = model.id
};
//当前用户对应分销商，2015-12-19 王耀发 创建
if (CurrentUser.IsBindDealer)
{
pager.PageFilter.DealerSysNo = CurrentUser.Dealer.SysNo;
pager.PageFilter.IsBindDealer = CurrentUser.IsBindDealer;
}
//是否绑定所有经销商
pager.PageFilter.IsBindAllDealer = CurrentUser.IsBindAllDealer;
pager.PageFilter.DealerCreatedBy = CurrentUser.Base.SysNo;
Hyt.BLL.Sys.SyJobPoolManageBo.Instance.GetMessageList(pager);
PagedList <CBSyJobPool> list = new PagedList <CBSyJobPool>();
list.TData = pager.Rows;
list.CurrentPageIndex = pager.CurrentPage;
list.TotalItemCount = pager.TotalRows;
list.PageSize = pager.PageSize;
//获取待回复的咨询数量
ViewBag.QueCounts = CrCustomerQuestionBo.Instance.GetCusQuestionCounts((int)CustomerStatus.会员咨询状态.待回复);
return(PartialView("_SyMessages", list));
}
/// <summary> /// 分页查询当日达未处理订单 /// </summary> /// <param name="hours">几小时之类未处理</param> /// <param name="model">订单池查询实体类</param> /// <returns>当日达未处理订单列表</returns> /// <remarks>2014-08-05 余勇 创建</remarks> public abstract Pager <CBSyJobPool> GetOverTimeSyJobsList(int hours, CBSyJobPool model);
/// <summary>
/// 分页查询当日达未处理订单
/// </summary>
/// <param name="hours">几小时之类未处理</param>
/// <param name="model">订单池查询实体类</param>
/// <returns>当日达未处理订单列表</returns>
/// <remarks>2014-08-05 余勇 创建</remarks>
public Pager <CBSyJobPool> GetOverTimeSyJobsList(int hours, CBSyJobPool model)
{
return(ISyJobPoolDao.Instance.GetOverTimeSyJobsList(hours, model));
}
