/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> public override Pager <CBDsDealerBailOrder> Query(ParaDsDealerBailOrderFilter filter) { var where = "1=1"; //判断是否绑定所有分销商 if (!filter.IsBindAllDealer) { //判断是否绑定分销商 if (filter.IsBindDealer) { where += " and dea.SysNo = " + filter.DealerSysNo; } else { where += " and dea.CreatedBy = " + filter.DealerCreatedBy; } } if (filter.SelectedAgentSysNo != -1) { if (filter.SelectedDealerSysNo != -1) { where += " and dea.SysNo = " + filter.SelectedDealerSysNo; } else { where += " and dea.CreatedBy = " + filter.SelectedAgentSysNo; } } string sql = @"(select a.*,(select SysNo from fnreceiptvoucher where Source = 20 and SourceSysNo = a.SysNo) as FnReceiptVoucherSysNo,dea.DealerName from DsDealerBailOrder a left join CrCustomer c on a.CustomerSysNo = c.SysNo left join DsDealer dea on c.DealerSysNo = dea.SysNo where " + where + " and ((@0 is null or charindex(a.ContactName,@1)>0) or (@2 is null or charindex(a.ContactWay,@3)>0) )) tb"; var dataList = Context.Select <CBDsDealerBailOrder>("tb.*").From(sql); var dataCount = Context.Select <int>("count(1)").From(sql); var paras = new object[] { filter.ContactName, filter.ContactName, filter.ContactWay, filter.ContactWay }; dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <CBDsDealerBailOrder> { CurrentPage = filter.Id, PageSize = filter.PageSize }; var totalRows = dataCount.QuerySingle(); var rows = dataList.OrderBy("tb.CreateDate desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany(); pager.TotalRows = totalRows; pager.Rows = rows; return(pager); }
public ActionResult DoDsDealerBailOrderQuery(ParaDsDealerBailOrderFilter filter) { //当前用户对应分销商,2015-12-19 王耀发 创建 if (CurrentUser.IsBindDealer) { int DealerSysNo = CurrentUser.Dealer.SysNo; filter.DealerSysNo = DealerSysNo; filter.IsBindDealer = CurrentUser.IsBindDealer; } //是否绑定所有经销商 filter.IsBindAllDealer = CurrentUser.IsBindAllDealer; filter.DealerCreatedBy = CurrentUser.Base.SysNo; filter.PageSize = 10; var pager = DsDealerBailOrderBo.Instance.Query(filter); var list = new PagedList <CBDsDealerBailOrder> { TData = pager.Rows, CurrentPageIndex = pager.CurrentPage, TotalItemCount = pager.TotalRows }; return(PartialView("_DsDealerBailOrderPager", list)); }
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> public abstract Pager <CBDsDealerBailOrder> Query(ParaDsDealerBailOrderFilter filter);
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> public Pager <CBDsDealerBailOrder> Query(ParaDsDealerBailOrderFilter filter) { return(IDsDealerBailOrderDao.Instance.Query(filter)); }