/// <summary> /// 通过过滤条件获取分销商列表 /// </summary> /// <param name="filter">过滤条件</param> /// <returns>分销商列表</returns> ///<remarks>2013-09-03 周唐炬 创建</remarks> public override Pager <CBDsDealer> GetDealerList(ParaDealerFilter filter) { string sqlWhere = "1=1"; //判断是否绑定所有分销商 if (!filter.IsBindAllDealer) { //判断是否绑定分销商 if (filter.IsBindDealer) { sqlWhere += " and A.SysNo = @3"; } else { sqlWhere += " and A.CreatedBy = @4"; } } if (filter.SelectedDealerSysNo != -1) { sqlWhere += " and A.SysNo = @5"; } string sql = @"(SELECT A.* ,B.SysNo As PrePaymentSysNo ,B.TOTALPRESTOREAMOUNT ,B.AVAILABLEAMOUNT ,B.FROZENAMOUNT FROM DsDealer A LEFT JOIN DsPrePayment B ON A.Sysno = B.dealersysno WHERE (@0 IS NULL OR A.AREASYSNO = @0) AND (@1 IS NULL OR A.STATUS = @1) AND (@2 IS NULL OR charindex(A.DEALERNAME, @2) > 0) AND " + sqlWhere + ") tb"; var dataList = Context.Select <CBDsDealer>("tb.*").From(sql); var dataCount = Context.Select <int>("count(1)").From(sql); var paras = new object[] { filter.AddressSysNo, filter.Status, filter.DealerName, filter.DealerSysNo, filter.DealerCreatedBy, filter.SelectedDealerSysNo }; dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <CBDsDealer>() { Rows = dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, filter.PageSize).QueryMany(), TotalRows = dataCount.QuerySingle() }; return(pager); }
/// <summary> /// 创建分销商预存款往来账明细 /// </summary> /// <param name="filter">过滤条件</param> /// <returns>分销商预存款往来账明细列表</returns> /// <remarks>2013-09-11 周唐炬 创建</remarks> public PagedList <CBDsPrePaymentItem> GetDsPrePaymentItemList(ParaDealerFilter filter) { if (filter != null) { var model = new PagedList <CBDsPrePaymentItem>(); filter.PageSize = model.PageSize; var pager = IDsPrePaymentItemDao.Instance.GetDsPrePaymentItemList(filter); if (null != pager) { model.TData = pager.Rows; model.TotalItemCount = pager.TotalRows; model.CurrentPageIndex = filter.CurrentPage; } return(model); } return(null); }
/// <summary> /// 通过过滤条件获取分销商列表 /// </summary> /// <param name="filter">过滤条件</param> /// <returns>分销商列表</returns> ///<remarks>2013-09-03 周唐炬 创建</remarks> public abstract Pager <CBDsDealer> GetDealerList(ParaDealerFilter filter);
/// <summary> /// 创建分销商预存款往来账明细 /// </summary> /// <param name="filter">过滤条件</param> /// <returns>分销商预存款往来账明细列表</returns> /// <remarks>2013-09-11 周唐炬 创建</remarks> public abstract Pager <CBDsPrePaymentItem> GetDsPrePaymentItemList(ParaDealerFilter filter);