isqlwebprovider.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.Web.SessionState;
using System.Data.SqlClient;

namespace isqlweb
{
    /// <summary>
    /// isqlweb 业务类
    /// </summary>
    public static class IsqlwebProvider
    {
        #region ServerName 连接服务器
        /// <summary>
        /// 连接服务器
        /// </summary>
        public static string ServerName
        {
            get { return Utils.Parse<string>(WebProvider.CurrentSession["ServerName"]); }
            set { WebProvider.CurrentSession["ServerName"] = value; }
        }
        #endregion

        #region UserName 连接用户名
        /// <summary>
        /// 连接用户名
        /// </summary>
        public static string UserName
        {
            get { return Utils.Parse<string>(WebProvider.CurrentSession["UserName"]); }
            set { WebProvider.CurrentSession["UserName"] = value; }
        }
        #endregion

        #region Password 连接密码
        /// <summary>
        /// 连接密码
        /// </summary>
        public static string Password
        {
            get { return Utils.Parse<string>(WebProvider.CurrentSession["Password"]); }
            set { WebProvider.CurrentSession["Password"] = value; }
        }
        #endregion

        #region DbServer 数据库服务器信息
        /// <summary>
        /// 数据库服务器信息
        /// </summary>
        public static DatabaseServer DbServer
        {
            get
            {
                DatabaseServer server = new DatabaseServer();
                server.ServerName = ServerName;
                server.UserName = UserName;
                server.Password = Password;
                return server;
            }
            set
            {
                DatabaseServer server = value;
                ServerName = server.ServerName;
                UserName = server.UserName;
                Password = server.Password;
            }
        }
        #endregion

        #region Conn 数据库连接
        /// <summary>
        /// 数据库连接
        /// </summary>
        public static SqlConnection Conn
        {
            get
            {
                if (Utils.IsEmpty(ServerName) || Utils.IsEmpty(UserName))
                    return null;

                DatabaseServer server = new DatabaseServer();
                server.ServerName = ServerName;
                server.UserName = UserName;
                server.Password = Password;
                SqlConnection conn = DataProvider.CreateConn(server);
                return conn;
            }
        }
        #endregion
    }


}