objectlist_ajax.aspx.cs

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

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;

namespace isqlweb
{
    public partial class objectList_ajax : AjaxPage
    {
        #region Page_Load
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Page.IsPostBack) return;

            if (!CheckConnection())
            {
                Response.Write("连接数据库失败");
                return;
            }

            if (IsCmd("loadAllDatabases"))
            {
                LoadAllDatabases();
            }
            else if (IsCmd("loadSubKind"))
            {
                LoadSubKind();
            }
            else if (IsCmd("loadTable"))
            {
                LoadTable();
            }
            else if (IsCmd("loadView"))
            {
                LoadView();
            }
            else if (IsCmd("loadProcedure"))
            {
                LoadProcedure();
            }
            else if (IsCmd("loadFunction"))
            {
                LoadFunction();
            }
            else if (IsCmd("loadTrigger"))
            {
                LoadTrigger();
            }
            else if (IsCmd("loadColumn"))
            {
                LoadColumn();
            }
        }
        #endregion

        #region LoadAllDatabases 加载所有数据库
        /// <summary>
        /// 加载所有数据库
        /// </summary>
        private void LoadAllDatabases()
        {
            DataTable dt = DataProvider.GetAllDatabase(Conn);

            Control parent = this;
            ObjectList_Database table = (ObjectList_Database)LoadControl("ObjectList_Database.ascx");
            parent.Controls.Add(table);
            table.BindData(IsqlwebProvider.ServerName + "(" + IsqlwebProvider.UserName + ")", dt);
        }
        #endregion

        #region LoadSubKind 加载数据库对象子分类
        /// <summary>
        /// 加载数据库对象子分类
        /// </summary>
        private void LoadSubKind()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("name", typeof(string)));
            dt.Columns.Add(new DataColumn("value", typeof(string)));
            DataRow row = dt.NewRow();
            row["name"] = "用户表"; row["value"] = "table";
            dt.Rows.Add(row);
            row = dt.NewRow();
            row["name"] = "视图"; row["value"] = "view";
            dt.Rows.Add(row);
            row = dt.NewRow();
            row["name"] = "存储过程"; row["value"] = "procedure";
            dt.Rows.Add(row);
            row = dt.NewRow();
            row["name"] = "函数"; row["value"] = "function";
            dt.Rows.Add(row);
            row = dt.NewRow();
            row["name"] = "触发器"; row["value"] = "trigger";
            dt.Rows.Add(row);
            

            Control parent = this;
            ObjectList_SubKind table = (ObjectList_SubKind)LoadControl("ObjectList_SubKind.ascx");
            parent.Controls.Add(table);
            table.BindData(Text, dt);
        }
        #endregion

        #region LoadTable 加载数据表
        /// <summary>
        /// 加载数据表
        /// </summary>
        private void LoadTable()
        {
            string[] name = Text.Split('/');

            DataTable dt = DataProvider.GetAllTable(Conn, name[0]);

            Control parent = this;
            ObjectList_Table table = (ObjectList_Table)LoadControl("ObjectList_Table.ascx");
            parent.Controls.Add(table);
            table.BindData(Text, dt);
        }
        #endregion

        #region LoadView 加载数据视图
        /// <summary>
        /// 加载数据视图
        /// </summary>
        private void LoadView()
        {
            string[] name = Text.Split('/');

            DataTable dt = DataProvider.GetAllView(Conn, name[0]);

            Control parent = this;
            ObjectList_View table = (ObjectList_View)LoadControl("ObjectList_View.ascx");
            parent.Controls.Add(table);
            table.BindData(Text, dt);
        }
        #endregion

        #region LoadProcedure 加载存储过程
        /// <summary>
        /// 加载存储过程
        /// </summary>
        private void LoadProcedure()
        {
            string[] name = Text.Split('/');

            DataTable dt = DataProvider.GetAllProcedure(Conn, name[0]);

            Control parent = this;
            ObjectList_Procedure table = (ObjectList_Procedure)LoadControl("ObjectList_Procedure.ascx");
            parent.Controls.Add(table);
            table.BindData(Text, dt);
        }
        #endregion

        #region LoadFunction 加载函数
        /// <summary>
        /// 加载函数
        /// </summary>
        private void LoadFunction()
        {
            string[] name = Text.Split('/');

            DataTable dt = DataProvider.GetAllFunction(Conn, name[0]);

            Control parent = this;
            ObjectList_Function table = (ObjectList_Function)LoadControl("ObjectList_Function.ascx");
            parent.Controls.Add(table);
            table.BindData(Text, dt);
        }
        #endregion

        #region LoadTrigger 加载触发器
        /// <summary>
        /// 加载触发器
        /// </summary>
        private void LoadTrigger()
        {
            string[] name = Text.Split('/');

            DataTable dt = DataProvider.GetAllTrigger(Conn, name[0]);

            Control parent = this;
            ObjectList_Trigger table = (ObjectList_Trigger)LoadControl("ObjectList_Trigger.ascx");
            parent.Controls.Add(table);
            table.BindData(Text, dt);
        }
        #endregion

        #region LoadColumn 加载列
        /// <summary>
        /// 加载列
        /// </summary>
        private void LoadColumn()
        {
            string[] name = Text.Split('/');

            DataTable dt = DataProvider.GetAllColumns(Conn, name[0], name[2]);

            Control parent = this;
            ObjectList_Column table = (ObjectList_Column)LoadControl("ObjectList_Column.ascx");
            parent.Controls.Add(table);
            table.BindData(Text, dt);
        }
        #endregion
    }
}