/// <summary>
/// 招商加盟申请列表（改）
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override Pager <PdProductPrivateList> GetPdProductPrivateLists(ParaProductPrivateFilter filter)
{
const string sql = @"(select a.*
from PdProductPrivate a
where (@0 is null or a.Status = @1)
) tb";
var dataList = Context.Select <PdProductPrivateList>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.Status, filter.Status
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <PdProductPrivateList>
{
CurrentPage = filter.Id,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy("tb.LastUpdateDate desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
/// <summary>
/// 招商加盟申请列表（改）
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public Pager <PdProductPrivateList> GetPdProductPrivateLists(ParaProductPrivateFilter filter)
{
return(IPdProductPrivateDao.Instance.GetPdProductPrivateLists(filter));
}
/// <summary> /// 招商加盟申请列表（改） /// </summary> /// <param name="filter"></param> /// <returns></returns> public abstract Pager <PdProductPrivateList> GetPdProductPrivateLists(ParaProductPrivateFilter filter);
