/// <summary>
/// 通过过滤条件获取分销商App列表
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>分销商App列表</returns>
/// 2014-05-06 余勇 创建
public override Pager <CBDsDealerApp> GetDealerList(ParaDsDealerAppFilter filter)
{
const string sql = @"(SELECT A.*
,B.MallName
FROM DsDealerApp A
LEFT JOIN DsMallType B ON A.MallTypeSysNo = B.SysNo
) tb";
var dataList = Context.Select <CBDsDealerApp>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var pager = new Pager <CBDsDealerApp>()
{
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-03 周唐炬 创建</remarks> public abstract Pager <CBDsDealerApp> GetDealerList(ParaDsDealerAppFilter filter);
/// <summary>
/// 通过过滤条件获取分销商App列表
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>分销商App列表</returns>
/// 2014-05-06 余勇 创建
public Pager <CBDsDealerApp> GetDealerList(ParaDsDealerAppFilter filter)
{
return(IDsDealerAppDao.Instance.GetDealerList(filter));
}
