messageutility.cs

ASP开发网站的 关于网站的设计和说明 还有SQL的程序 数据库

namespace ASPNET.StarterKit.Communities {

    using System;
    using System.Data;
    using System.Data.SqlClient;


    //*********************************************************************
    //
    // MessageUtility Class
    //
    // Contains static methods for working with messages. 
    //
    //*********************************************************************

    public class MessageUtility {


        //*********************************************************************
        //
        // GetMessage Class
        //
        // Returns a message given a message name. 
        //
        //*********************************************************************
    
        public static MessageInfo GetMessage(string messageName) {
            MessageInfo messageInfo = new MessageInfo();
        
            SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
            SqlCommand cmdGet = new SqlCommand( "Community_MessagesGetMessage", conPortal );
            cmdGet.CommandType = CommandType.StoredProcedure;

            cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdGet.Parameters.Add("@messageName", messageName);
            
            conPortal.Open();
            SqlDataReader dr = cmdGet.ExecuteReader();
            if (dr.Read()) {
                messageInfo.Name = (string)dr["message_name"];
                messageInfo.Description = (string)dr["message_description"];
                messageInfo.Title = (string)dr["message_title"];
                messageInfo.Body = (string)dr["message_body"];
            }
            conPortal.Close();
        
            return messageInfo;
        }
    
    
        //*********************************************************************
        //
        // MessageUtility Constructor
        //
        // Use private constructor for static class. 
        //
        //*********************************************************************

        private MessageUtility() {}
    }
}