changedb.aspx.cs

酒店管理 主要实现了基础设施管理（客房管理、客房类型管理）、业务管理（入住、退房、数据库切换） 本系统简单明了,适合初学者学习,采用三层加抽象工厂实现

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.OleDb;
using System.Data.SqlClient;
using System.IO;

public partial class ChangeDb : System.Web.UI.Page
{
    private OleDbConnection oleDb = null;
    private SqlConnection sql = null;

    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btn_Change_Click(object sender, EventArgs e)
    {
        try
        {
            if (this.radBtn_Access.Checked)
            {
                //如果文件存在
                if (File.Exists("HotelManager.mdb"))
                {
                    //如果app.config中有AppSettings并且键不为空
                    if (ConfigurationManager.AppSettings["DAL"] != null)
                    {
                        ConfigurationManager.AppSettings.Set("DAL", "Access");
                        using (oleDb = new OleDbConnection(ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString))
                        {
                            oleDb.Open();
                            if (oleDb.State == ConnectionState.Open)
                                Response.Redirect("~/Login.aspx");
                            else
                                Response.Write("<script>alert('数据库无法连接!!')</script>");
                        }
                    }
                    else
                        ConfigurationManager.AppSettings.Add("DAL", "Access");
                }
                else
                {
                    Response.Write("<script>alert('数据库文件不存在!!')</script>");
                }
            }
            else
            {
                if (ConfigurationManager.AppSettings["DAL"] != null)
                {
                    ConfigurationManager.AppSettings.Set("DAL", "SQLServer");
                    using (sql = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLServerConnectionString"].ConnectionString))
                    {
                        sql.Open();
                        if (sql.State == ConnectionState.Open)
                            Response.Redirect("~/Login.aspx");
                        else
                            Response.Write("<script>alert('数据库无法连接!!')</script>");
                    }
                }
                else
                    ConfigurationManager.AppSettings.Add("DAL", "SQLServer");
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('" + ex.Message + ex.StackTrace + "')</script>");
        }

    }
    protected void btn_TestCon_Click(object sender, EventArgs e)
    {
        try
        {
            if (this.radBtn_Access.Checked)
            {
                //如果文件存在
                if (File.Exists("HotelManager.mdb"))
                {
                    //如果app.config中有AppSettings并且键不为空
                    if (ConfigurationManager.AppSettings["DAL"] != null)
                    {
                        ConfigurationManager.AppSettings.Set("DAL", "Access");
                        using (oleDb = new OleDbConnection(ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString))
                        {
                            oleDb.Open();
                            if (oleDb.State == ConnectionState.Open)
                                Response.Write("<script>alert('Test Successful!!')</script>");
                            else
                                Response.Write("<script>alert('Test Fail!!')</script>");
                        }
                    }
                    else
                        ConfigurationManager.AppSettings.Add("DAL", "Access");
                }
                else
                {
                    Response.Write("<script>alert('数据库文件不存在')</script>");
                }
            }
            else
            {
                if (ConfigurationManager.AppSettings["DAL"] != null)
                {
                    ConfigurationManager.AppSettings.Set("DAL", "SQLServer");
                    using (sql = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLServerConnectionString"].ConnectionString))
                    {
                        sql.Open();
                        if (sql.State == ConnectionState.Open)
                            Response.Write("<script>alert('Test Successful!!')</script>");
                        else
                            Response.Write("<script>alert('Test Fail!!')</script>");
                    }
                }
                else
                    ConfigurationManager.AppSettings.Add("DAL", "SQLServer");
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('" + ex.Message + ex.StackTrace + "')</script>");
        }
    }
}