articlecontroller.cs

Maolz个人展示网站源码,全部的代码,.net

using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace SubSonic.Generated
{
    using System.Linq;
    /// <summary>
    /// Controller class for Articles
    /// </summary>
    public partial class ArticleController
    {
        public List<Article> FetchAllByPKIdDesc() 
        {
            return FetchAll().OrderByDescending(t => t.PKId).ToList<Article>();
        }
        [DataObjectMethod(DataObjectMethodType.Select, true)]
        public List<Article> FetchByPaging(int categoryId, int currentPageIndex, int pageSize) 
        {
            Category cate = new Category(categoryId);
            if (cate.IsLoaded)
                return cate.GetArticleCollection().OrderByDescending(t => t.PKId).Skip((currentPageIndex - 1) * pageSize).Take(pageSize).ToList<Article>();
            else
                return FetchAllByPKIdDesc().Skip((currentPageIndex - 1) * pageSize).Take(pageSize).ToList<Article>();
        }
        [DataObjectMethod(DataObjectMethodType.Select, true)]
        public TagCollection GetRelveantTagsByArticleId(int articleId)
        {
            Article arti = new Article(articleId);
            return arti.GetTagCollection();
        }
    }


}