Пример #1
0
        public List <Email> PageSearch(int pageIndex, int pageSize, out int totalCount, IEnumerable <string> wheres = null, string orderBy = "", params System.Data.SqlClient.SqlParameter[] sqlParameters)
        {
            string sql = SQLUtls.GeneratePageSearchSQL(pageIndex, pageSize, "[email]", wheres, orderBy);

            return(_dbContext.PageSearch <Email>(sql, out totalCount, sqlParameters));
        }
Пример #2
0
        public List <User> PageSearch(int pageIndex, int pageSize, out int totalCount, IEnumerable <string> wheres = null, string orderBy = "", params SqlParameter[] sqlParameters)
        {
            string sql = SQLUtls.GeneratePageSearchSQL(pageIndex, pageSize, "[user]", wheres, orderBy);

            return(_dbContext.PageSearch <User>(sql, out totalCount, sqlParameters));
        }