articlecategorymappingcontroller.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
{

    public partial class ArticleCategoryMappingController
    {
        [DataObjectMethod(DataObjectMethodType.Select, true)]
        public ArticleCollection GetPagingArticlesByCategoryName(string categoryName, int? startRowIndex, int? maximumRows)
        {
            Category cate = new Category(Category.Columns.Name, categoryName);
            if (cate.IsNew)
                return new ArticleCollection();
            else
            {
                //使用储存过程
                System.Data.IDataReader dr = SPs.GetPagingCategoryRelveantArticles(new int?(cate.PKId), startRowIndex, maximumRows, false).GetReader();
                ArticleCollection ac = new ArticleCollection();
                ac.LoadAndCloseReader(dr);
                return ac;
            }

        }
        public int GetCount(string categoryName) 
        {
            Category cate = new Category(Category.Columns.Name, categoryName);
            if (cate.IsNew)
                return 0;
            else
                return new Select().From<Article>().Where(Article.Columns.PKId).In(new Select(ArticleCategoryMapping.Columns.ArticleId).From<ArticleCategoryMapping>().Where(ArticleCategoryMapping.Columns.CategoryId).IsEqualTo(cate.PKId)).ExecuteAsCollection<ArticleCollection>().Count;
        }

    }

}