htmlpageutility.cs

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

namespace ASPNET.StarterKit.Communities.HtmlPage {

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


    //*********************************************************************
    //
    // HtmlPageUtility Class
    //
    // Contains static utility methods for working with HTML pages. 
    //
    //*********************************************************************

    public class HtmlPageUtility {

        
        //*********************************************************************
        //
        // GetHtmlPage Method
        //
        // Retrieves an HTML page from the database given
        // as section ID.
        //
        //*********************************************************************

        public static string GetHtmlPage(int sectionID) {
            string htmlPage;
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);    
            SqlCommand cmdGetPage = new SqlCommand("Community_HtmlPageGetPage",conPortal);
            cmdGetPage.CommandType = CommandType.StoredProcedure;
            cmdGetPage.Parameters.Add("@sectionID", sectionID);
            conPortal.Open();
            htmlPage = (string)cmdGetPage.ExecuteScalar();
            conPortal.Close();
            if (htmlPage == null)
                return String.Empty;
            else
                return htmlPage;          
        }    

    
        //*********************************************************************
        //
        // UpdateHtmlPage Method
        //
        // Updates HTML page in database. 
        //
        //*********************************************************************

        public static void UpdateHtmlPage(int sectionID,string htmlPage) {
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);    
            SqlCommand cmdUpdatePage = new SqlCommand("Community_HtmlPageUpdatePage",conPortal);
            cmdUpdatePage.CommandType = CommandType.StoredProcedure;
            cmdUpdatePage.Parameters.Add("@sectionID", sectionID);
            cmdUpdatePage.Parameters.Add("@content", SqlDbType.NText);
			cmdUpdatePage.Parameters[ "@content" ].Value = htmlPage;
            conPortal.Open();
            cmdUpdatePage.ExecuteNonQuery();
            conPortal.Close();
        }    
    
    
        //*********************************************************************
        //
        // HtmlPageUtility Constructor
        //
        // Use private constructor for class with static methods. 
        //
        //*********************************************************************

        private HtmlPageUtility() {}
        
    }
}