tableedit.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;
using System.Data.SqlClient;

namespace isqlweb
{
    public partial class TableEdit : IsqlwebPage
    {
        #region Page_Load
        SqlConnection conn = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            conn = Conn;
            if (conn == null)
                ShowMessage("连接数据库失败。", "错误");

            if (!Page.IsPostBack)
            {
                if (Utils.IsEmpty(DbName) || Utils.IsEmpty(TableName))
                {
                    ShowMessage("参数错误。", "错误");
                }
                
                LoadData();
            }
        } 
        #endregion

        #region DbName 数据库名称
        /// <summary>
        /// 数据库名称
        /// </summary>
        public string DbName
        {
            get
            {
                try
                {
                    return Utils.Parse<string>(Request["DbName"]);
                }
                catch
                {
                    return string.Empty;
                }
            }
        }
        #endregion

        #region TableName 表名称
        /// <summary>
        /// 表名称
        /// </summary>
        public string TableName
        {
            get
            {
                try
                {
                    return Utils.Parse<string>(Request["TableName"]);
                }
                catch
                {
                    return string.Empty;
                }
            }
        }
        #endregion

        #region LoadData 加载数据
        /// <summary>
        /// 加载数据
        /// </summary>
        private void LoadData()
        {
            
            try
            {
                this.lab_dbName.Text = DbName;
                this.lab_tableName.Text = TableName;

                this.grid.DataSource = DataProvider.GetAllColumns(conn, DbName, TableName);
                this.grid.DataBind();
            }
            catch (Exception ex)
            {
                ShowMessage(ex.Message, "错误");
            }
        }
        #endregion

        #region Refresh 刷新
        /// <summary>
        /// 刷新
        /// </summary>
        public void Refresh()
        {
            Response.Redirect(Page.Request.RawUrl);   
        } 
        #endregion

        #region 删除表
        protected void btn_delTable_Click(object sender, EventArgs e)
        {
            try
            {
                DataProvider.DeleteTable(conn, DbName, TableName);
                ShowMessage("删除 " + TableName + " 表成功。");
            }
            catch (Exception ex)
            {
                WebProvider.Alert("出现错误：\r\n" + ex.Message);
            }
        } 
        #endregion

        #region RowDataBound
        protected void grid_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            DataRowView drv=(DataRowView)e.Row.DataItem;
            CheckBox txt_isnull = (CheckBox)e.Row.FindControl("txt_isnull");
            if (drv == null || txt_isnull == null) return;

            e.Row.Attributes["onmouseover"] = "showRowBtn(" + e.Row.RowIndex + ");";
            e.Row.Attributes["onmouseout"] = "hideRowBtn(" + e.Row.RowIndex + ");";

            txt_isnull.Checked = Utils.Parse<bool>(drv["isnullable"]);
        } 
        #endregion

        #region 添加列
        protected void btn_ColumnAdd_Click(object sender, EventArgs e)
        {
            string columnName = this.txta_columnName.Text;
            string coltype = this.txta_columnType.Text;
            bool isnull = this.txta_isnull.Checked;

            try
            {
                DataProvider.AddColumn(conn, DbName, TableName, columnName, coltype, isnull, null, null, string.Empty);
            }
            catch (Exception ex)
            {
                ShowMessage(ex);
            }

            Refresh();
        } 
        #endregion

        #region 删除列
        protected void btn_ColumnDelete_Click(object sender, EventArgs e)
        {
            if (Utils.IsEmpty(hid_editName.Value))
                return;

            try
            {
                DataProvider.DeleteColumn(conn, DbName, TableName, hid_editName.Value);
            }
            catch (Exception ex)
            {
                ShowMessage(ex);
            }
            Refresh();
        } 
        #endregion
    }
}