/// <summary> /// 分页查询分销商商城信息列表 /// </summary> /// <param name="pager">分销商商城信息列表分页对象</param> /// <param name="filter">查询条件</param> /// <returns></returns> /// <remarks> /// 2013-09-18 郑荣华 创建 /// </remarks> public override void GetDsDealerMallList(ref Pager <CBDsDealerMall> pager, ParaDsDealerMallFilter filter) { using (var context = Context.UseSharedConnection(true)) { const string sqlSelect = @"t.*,a.dealername,b.mallcode,b.mallname,c.AppName"; const string sqlFrom = @"DsDealerMall t left join DsDealer a on t.dealersysno=a.sysno left join DsMallType b on t.malltypesysno=b.sysno left join DsDealerApp c on t.DealerAppSysNo=c.sysno "; const string sqlWhere = @"(@ShopName is null or charindex(t.ShopName,@ShopName)>0) and (@DealerSysNo is null or t.DealerSysNo= @DealerSysNo) and (@status is null or t.status= @status) and (@MallTypeSysNo is null or t.MallTypeSysNo=@MallTypeSysNo) and (@IsSelfSupport is null or t.IsSelfSupport=@IsSelfSupport) "; #region sqlcount const string sqlCount = @" select count(1) from DsDealerMall t where " + sqlWhere; pager.TotalRows = context.Sql(sqlCount) .Parameter("ShopName", filter.ShopName) .Parameter("DealerSysNo", filter.DealerSysNo) .Parameter("status", filter.Status) .Parameter("MallTypeSysNo", filter.MallTypeSysNo) .Parameter("IsSelfSupport", filter.IsSelfSupport) .QuerySingle <int>(); #endregion pager.Rows = context.Select <CBDsDealerMall>(sqlSelect) .From(sqlFrom) .Where(sqlWhere) .Parameter("ShopName", filter.ShopName) .Parameter("DealerSysNo", filter.DealerSysNo) .Parameter("status", filter.Status) .Parameter("MallTypeSysNo", filter.MallTypeSysNo) .Parameter("IsSelfSupport", filter.IsSelfSupport) .OrderBy("t.sysno desc") .Paging(pager.CurrentPage, pager.PageSize) .QueryMany(); } }
/// <summary> /// 分页查询分销商商城信息列表 /// </summary> /// <param name="pager">分销商商城信息列表分页对象</param> /// <param name="filter">查询条件</param> /// <returns></returns> /// <remarks> /// 2013-09-18 郑荣华 创建 /// </remarks> public void GetDsDealerMallList(ref Pager <CBDsDealerMall> pager, ParaDsDealerMallFilter filter) { IDsDealerMallDao.Instance.GetDsDealerMallList(ref pager, filter); }
/// <summary> /// 分页查询分销商商城信息列表 /// </summary> /// <param name="pager">分销商商城信息列表分页对象</param> /// <param name="filter">查询条件</param> /// <returns></returns> /// <remarks> /// 2013-09-18 郑荣华 创建 /// </remarks> public abstract void GetDsDealerMallList(ref Pager <CBDsDealerMall> pager, ParaDsDealerMallFilter filter);