/// <summary> /// 分页获取申请列表 /// </summary> /// <param name="pager"></param> /// <param name="filter"></param> public abstract void GetDsDealerApplyWebList(ref Pager <DsDealerApplyWeb> pager, ParaDsDealerApplyWebFilter filter);
/// <summary>
/// 分页获取申请列表
/// </summary>
/// <param name="pager"></param>
/// <param name="filter"></param>
public void GetDsDealerApplyWebList(ref Pager <DsDealerApplyWeb> pager, ParaDsDealerApplyWebFilter filter)
{
ICrCustomerQuestionDao.Instance.GetDsDealerApplyWebList(ref pager, filter);
}
/// <summary>
/// 分页获取申请列表
/// </summary>
/// <param name="pager"></param>
/// <param name="filter"></param>
public override void GetDsDealerApplyWebList(ref Pager <DsDealerApplyWeb> pager, ParaDsDealerApplyWebFilter filter)
{
using (var context = Context.UseSharedConnection(true))
{
const string sqlSelect = @" * ";
const string sqlFrom = @" DsDealerApplyWeb ";
string sqlWhere = " DealerSysNo=" + filter.DealerSysno;
if (filter.Status != 0)
{
sqlWhere += @" and Status=" + filter.Status;
}
#region sqlcount
string sqlCount = @" select count(1) from DsDealerApplyWeb where " + sqlWhere;
pager.TotalRows = context.Sql(sqlCount)
.QuerySingle <int>();
#endregion
pager.Rows = context.Select <DsDealerApplyWeb>(sqlSelect)
.From(sqlFrom)
.Where(sqlWhere)
.OrderBy(" CreatedDate desc ")
.Paging(pager.CurrentPage, pager.PageSize)
.QueryMany();
}
}
