MarkItUp.SingleUserBlog/Services/SqlBlogDataProvider.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Collections.Generic;
using System.Text;
using MarkItUp.SingleUserBlog.Common;
using System.Data.SqlClient;
using System.Reflection;
using System.Web.Configuration;

namespace MarkItUp.SingleUserBlog.Services {
    public class SqlBlogDataProvider : BlogDataProvider {
        private string _connectionString;
        private SqlHelper _sqlHelper;

        public SqlBlogDataProvider() {
            this.ConnectionString = WebConfigurationManager.ConnectionStrings["SqlBlogDataProviderConnectionString"].ConnectionString;
        }

        public SqlBlogDataProvider(string connectionString) {
            this.ConnectionString = connectionString;
        }

        public string ConnectionString {
            get { return _connectionString; }
            set { _connectionString = value; }
        }

        protected SqlHelper SqlHelper {
            get {
                if (_sqlHelper == null) {
                    _sqlHelper = new SqlHelper(this.ConnectionString);
                }
                return _sqlHelper;
            }
        }

        #region Helper Methods

        private FeedbackItem ReadFeedbackItem(SqlDataReader reader) {
            FeedbackItem item = new FeedbackItem();
            item.Fill(reader);
            return item;
        }

        private Post ReadPost(SqlDataReader reader) {
            Post post = new Post();
            post.Fill(reader);
            return post;
        }

        private Category ReadCategory(SqlDataReader reader) {
            Category post = new Category();
            post.Fill(reader);
            return post;
        }

        #endregion

        public override bool Authenticate(string username, string password) {
            if (password == Globals.UserPassword && username == Globals.UserLoginName) {
                return true;