/// <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(); } }