/// <summary> /// 分页 /// </summary> /// <param name="t"></param> public PagerViewModel <T> GetPageList(TViewModel viewModel, QueryTermViewModel queryTermViewModel, IDbConnection conn = null, IDbTransaction tran = null) { return(CommonAction <BaseViewModel, PagerViewModel <T> >(viewModel, conn, tran, (o, con, tr) => { if (null == queryTermViewModel.SortList || queryTermViewModel.SortList.Count == 0) { queryTermViewModel.SortList = new List <ISort>() { new Sort() { Ascending = false, PropertyName = "ID" } }; } var list = con.GetPage <T>(queryTermViewModel.PredGroup, queryTermViewModel.SortList, viewModel.PageIndex - 1, viewModel.PageCount, tr); var count = con.Count <T>(queryTermViewModel.PredGroup, tr); var pager = new PagerViewModel <T>() { TotalCount = count }; if (null != list) { pager.ItemList = list.ToList <T>(); } return pager; })); }
/// <summary> /// 谓词动态查询条件 /// </summary> /// <param name="predGroup"></param> /// <returns></returns> public IList <T> GetList(QueryTermViewModel queryTermViewModel, IDbConnection conn = null, IDbTransaction tran = null) { return(CommonAction <QueryTermViewModel, IList <T> >(queryTermViewModel, conn, tran, (o, con, tr) => { if (null == queryTermViewModel.SortList || queryTermViewModel.SortList.Count == 0) { queryTermViewModel.SortList = new List <ISort>() { new Sort() { Ascending = true, PropertyName = "ID" } }; } var list = con.GetList <T>(o.PredGroup, o.SortList, tr); if (null != list && list.Count() > 0) { return list.ToList <T>(); } return null; })); }
public override IList <ContractsInfo> GetList(ContractsInfoViewModel viewModel) { var queryTermViewModel = new QueryTermViewModel() { }; var pg = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List <IPredicate>() }; return(SingleHepler <ContractsInfoDAL> .Instance.GetList(queryTermViewModel)); }
public override IList <GroupInfo> GetList(BaseViewModel viewModel) { var queryTermViewModel = new QueryTermViewModel() { }; queryTermViewModel.SortList = new List <ISort>() { new Sort() { Ascending = false, PropertyName = "ID" } }; return(SingleHepler <GroupInfoDAL> .Instance.GetList(queryTermViewModel)); }