articleutility.cs

一个ASP.NET下的中文内容管理和社区系统

namespace ASPNET.StarterKit.Communities.Articles {

    using System;
    using System.Web;
    using System.Data;
    using System.Data.SqlClient;
    using System.Collections;
    using ASPNET.StarterKit.Communities;


    //*********************************************************************
    //
    // ArticleUtility Class
    //
    // Contains static utility methods used by the Articles section. 
    //
    //*********************************************************************

    public class ArticleUtility {
    

        //*********************************************************************
        //
        // AddArticle Method
        //
        // Adds a new article to the database. 
        //
        //*********************************************************************

        public static int AddArticle
        (
            string username, 
            int sectionID, 
            int topicID,
            string title, 
            string introText,
            int moderationStatus,
            string bodyText
        ) {
        
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdAdd = new SqlCommand( "Community_ArticlesAddArticle", conPortal);
            cmdAdd.CommandType = CommandType.StoredProcedure;
            
            cmdAdd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
            cmdAdd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdAdd.Parameters.Add("@sectionID", sectionID);
            cmdAdd.Parameters.Add("@username", username);
            cmdAdd.Parameters.Add("@topicID", topicID);
            cmdAdd.Parameters.Add("@title", title);
            cmdAdd.Parameters.Add("@introText", introText);
            cmdAdd.Parameters.Add("@metaDescription", ContentPageUtility.CalculateMetaDescription(introText));
            cmdAdd.Parameters.Add("@metaKeys", ContentPageUtility.CalculateMetaKeys(introText));
            cmdAdd.Parameters.Add("@moderationStatus", moderationStatus );
			cmdAdd.Parameters.Add("@bodyText", SqlDbType.NText);
			cmdAdd.Parameters[ "@bodyText" ].Value = bodyText;
            
            conPortal.Open();
            cmdAdd.ExecuteNonQuery();
            int result = (int)cmdAdd.Parameters["@RETURN_VALUE"].Value;

            // Add Search Keys
            SearchUtility.AddSearchKeys(conPortal, sectionID, result, title, introText);

            conPortal.Close();
            
            return result;
          }
        

        //*********************************************************************
        //
        // EditArticle Method
        //
        // Edits an existing article in the database. 
        //
        //*********************************************************************

        public static void EditArticle
        (
            string username, 
            int sectionID,
            int contentPageID, 
            int topicID,
            string title, 
            string introText,
            string bodyText
        ) {
        
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdEdit = new SqlCommand( "Community_ArticlesEditArticle", conPortal);
            cmdEdit.CommandType = CommandType.StoredProcedure;
            
            cmdEdit.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdEdit.Parameters.Add("@contentPageID", contentPageID);
            cmdEdit.Parameters.Add("@username", username);
            cmdEdit.Parameters.Add("@topicID", topicID);
            cmdEdit.Parameters.Add("@title", title);
            cmdEdit.Parameters.Add("@introText", introText);
            cmdEdit.Parameters.Add("@metaDescription", ContentPageUtility.CalculateMetaDescription(introText));
            cmdEdit.Parameters.Add("@metaKeys", ContentPageUtility.CalculateMetaKeys(introText));
			cmdEdit.Parameters.Add("@bodyText", SqlDbType.NText);
			cmdEdit.Parameters[ "@bodyText" ].Value = bodyText;
            
            conPortal.Open();
            cmdEdit.ExecuteNonQuery();


            // Edit Search Keys
            SearchUtility.EditSearchKeys(conPortal, sectionID, contentPageID, title, introText);

            conPortal.Close();
        }


        //*********************************************************************
        //
        // GetArticles Method
        //
        // Gets articles for this section. 
        //
        //*********************************************************************

        public static ArrayList GetArticles(string username, int sectionID, int pageSize, int pageIndex, string sortOrder) {
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdGet = new SqlCommand( "Community_ArticlesGetArticles", conPortal);
            cmdGet.CommandType = CommandType.StoredProcedure;
            cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdGet.Parameters.Add("@username", username);
            cmdGet.Parameters.Add("@sectionID", sectionID);
            cmdGet.Parameters.Add("@pageSize", pageSize);
            cmdGet.Parameters.Add("@pageIndex", pageIndex);
            cmdGet.Parameters.Add("@sortOrder", sortOrder);
            
            ArrayList colArticles = new ArrayList();

            conPortal.Open();
            SqlDataReader dr = cmdGet.ExecuteReader();
            while (dr.Read())
                colArticles.Add(new ArticleInfo(dr));
            conPortal.Close();
            return colArticles;    
        }



        //*********************************************************************
        //
        // GetArticleInfo Method
        //
        // Gets a particular article from the database. 
        //
        //*********************************************************************

        public static ContentInfo GetArticleInfo(string username, int contentPageID) {
            ArticleInfo _articleInfo = null;

            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdGet = new SqlCommand( "Community_ArticlesGetArticle", conPortal);
            cmdGet.CommandType = CommandType.StoredProcedure;
            cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdGet.Parameters.Add("@username", username);
            cmdGet.Parameters.Add("@contentPageID", contentPageID);
            conPortal.Open();
            SqlDataReader dr = cmdGet.ExecuteReader();
            if (dr.Read())
                _articleInfo = new ArticleInfo(dr);
            conPortal.Close();
            return (ContentInfo) _articleInfo;
        }


    }
}