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