datapage.cs

基于vs2.0开发的WEB管理SQL功能该软件是一个用于管理SQL Server的工具

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections.Generic;

namespace isqlweb
{
    /// <summary>
    /// 访问数据库的页面
    /// </summary>
    public class DataPage : Page
    {
        #region Conn 数据库连接
        private SqlConnection _conn = null;
        /// <summary>
        /// 数据库连接
        /// </summary>
        public SqlConnection Conn
        {
            get
            {
                if (_conn == null)
                {
                    _conn = IsqlwebProvider.Conn;
                    if (_conn != null)
                        _conn.InfoMessage += new SqlInfoMessageEventHandler(Conn_InfoMessage);
                }

                //if (_conn == null)
                //{
                //    if (!IsNotNeedConnection())
                //    {
                //        throw new Exception("连接数据库失败");
                //        //WebProvider.ShowMessage("连接数据库失败。", "错误");
                //    }
                //    return null;
                //}

                try
                {
                    DataProvider.OpenConnection(_conn);
                }
                catch
                {
                    if (!IsNotNeedConnection())
                    {
                        throw new Exception("连接数据库失败");
                        //WebProvider.ShowMessage("连接数据库失败。", "错误");
                        //return null;
                    }
                }

                return _conn;
            }
            set
            {
                _conn = value;
            }
        }

        /// <summary>
        /// 服务器消息到达
        /// </summary>
        void Conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
        {
            if (e.Errors.Count == 0) return;

            for (int i = 0; i < e.Errors.Count; i++)
            {
                if (e.Errors[i].Number == 5701) //更改上下文(数据库名称)
                    continue;

                SQLMessage.Add(e.Errors[i].Message);
            }
        }
        #endregion

        #region SQLMessage SQL消息
        /// <summary>
        /// SQL消息
        /// </summary>
        public List<string> SQLMessage = new List<string>();

        /// <summary>
        /// 是否消息为空
        /// </summary>
        /// <returns></returns>
        public bool IsEmptySQLMessage()
        {
            if (SQLMessage == null || SQLMessage.Count == 0) 
                return true;
            else
                return false;
        }
        /// <summary>
        /// 获取消息字符串
        /// </summary>
        /// <returns></returns>
        public string GetSQLMessageString()
        {
            if (SQLMessage == null || SQLMessage.Count == 0) return string.Empty;
            string str = string.Empty;
            for (int i = 0; i < SQLMessage.Count; i++)
            {
                str += SQLMessage[i] + "。";
            }
            return str;
        }
        #endregion

        #region Dispose
        public override void Dispose()
        {
            base.Dispose();
            DataProvider.CloseConnection(_conn);
        }
        #endregion

        #region IsNotNeedConnection 是否不必须连接成功
        /// <summary>
        /// 是否不必须连接成功
        /// </summary>
        /// <returns></returns>
        public bool IsNotNeedConnection()
        {
            if (typeof(Login).IsInstanceOfType(this) || typeof(MessageBox).IsInstanceOfType(this))
                return true;
            else
                return false;
        } 
        #endregion

        #region CheckConnection 检查连接
        /// <summary>
        /// 检查连接
        /// </summary>
        /// <returns></returns>
        public bool CheckConnection()
        {
            if (Conn == null || Conn.State != ConnectionState.Open)
            {
                return false;
            }
            else
            {
                return true;
            }
        } 
        #endregion
    }
}