/// <summary> /// 查询分销商EAS关联 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分销商EAS关联分页数据</returns> /// <remarks>2013-10-10 黄志勇 创建</remarks> public override Pager <CBDsEasAssociation> Query(ParaDsEasFilter filter) { const string sql = @"(SELECT a.SYSNO,a.DEALERMALLSYSNO,a.SELLERNICK,a.CODE,a.STATUS,a.CREATEDBY,a.CREATEDDATE,a.LASTUPDATEBY,a.LASTUPDATEDATE,b.SHOPNAME,b.SHOPACCOUNT,c.MALLNAME FROM DSEASASSOCIATION a LEFT JOIN DSDEALERMALL b ON a.DEALERMALLSYSNO = b.SYSNO LEFT JOIN DSMALLTYPE c ON c.SYSNO = b.MALLTYPESYSNO where (@0 is null or b.MallTypeSysNo=@0) and (@1 is null or a.Status=@1) and (@2 is null or charindex(b.ShopName,@2)>0) and (@3 is null or charindex(b.ShopAccount,@3)>0) and (@4 is null or charindex(a.SellerNick,@4)>0) and (@5 is null or charindex(a.Code,@5)>0) and (@6 is null or a.CreatedDate>=@6) and --日期(起) (@7 is null or a.CreatedDate<@7) --日期(止) ) tb"; var paras = new object[] { filter.MallTypeSysNo, filter.Status, filter.ShopName, filter.ShopAccount, filter.SellerNick, filter.Code, filter.BeginDate, filter.EndDate }; var dataList = Context.Select <CBDsEasAssociation>("tb.*").From(sql); var dataCount = Context.Select <int>("count(0)").From(sql); dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <CBDsEasAssociation> { PageSize = filter.PageSize, CurrentPage = filter.Id, TotalRows = dataCount.QuerySingle(), Rows = dataList.OrderBy("tb.CreatedDate desc").Paging(filter.Id, filter.PageSize).QueryMany() }; return(pager); }
/// <summary> /// 查询分销商EAS关联 /// </summary> /// <param name="filter">查询参数</param> /// <remarks>分销商EAS关联分页数据</remarks> /// <remarks>2013-10-10 黄志勇 创建</remarks> public abstract Pager <CBDsEasAssociation> Query(ParaDsEasFilter filter);
/// <summary> /// 分页查询分销商EAS关联 /// </summary> /// <param name="filter">升舱订单查询参数</param> /// <returns></returns> /// <remarks>2013-10-10 黄志勇 创建</remarks> public Pager <CBDsEasAssociation> Query(ParaDsEasFilter filter) { return(IDsEasDao.Instance.Query(filter)); }