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)); }