Esempio n. 1
0
        public IEnumerable <NovelView> GetPagerList(string where, string orderBy, out int rowCount, int pageIndex, int pageSize, object param, string table = "[dbo].[Novel] as n ", string columns = "*")
        {
            IEnumerable <NovelView> list = null;

            using (var conn = DbConnection(DbOperation.Read))
            {
                var repo = new Repository.NovelRepo(conn);

                list = repo.GetPagerList(columns, where, orderBy, out rowCount, pageIndex, pageSize, table, param);
            }

            return(list);
        }
Esempio n. 2
0
        public Novel GetNovel(int novelId, int status = 1)
        {
            Novel novel = null;

            if (novelId > 0)
            {
                using (var conn = DbConnection(DbOperation.Read))
                {
                    var repo = new Repository.NovelRepo(conn);
                    novel = repo.GetDetail(novelId, status);
                }
            }

            return(novel);
        }