createtable.aspx.cs

通过配置表中的各列支持绝大部分的基础数据

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Comm.include;
using System.Configuration;
namespace comm
{
	/// <summary>
	/// createtable 的摘要说明。
	/// </summary>
	public class createtable : System.Web.UI.Page
	{
        protected System.Web.UI.WebControls.TextBox txt_tabletitle;
        protected System.Web.UI.WebControls.TextBox txt_table_enname;
        protected System.Web.UI.WebControls.TextBox txt_table_colcnt;
        protected System.Web.UI.WebControls.TextBox txt_menu_name;
        protected System.Web.UI.WebControls.DropDownList ddl_parent_id;
        protected System.Web.UI.WebControls.Button btn_createtable;
        protected System.Web.UI.WebControls.TextBox txt_columnMaxLength;
        include.Db db=new include.Db();
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
            if(Request["system"]!=null)
            {
                this.Session["system"]=Request["system"].Trim();
                this.Session["IP"]="";
                this.Session["usr"]=ConfigurationSettings.AppSettings["usr"];
                this.Session["pwd"]=ConfigurationSettings.AppSettings["pwd"];
            }
            if(Session["system"]==null)
            {

                db.Msgbox("超时！请重新登陆！","",this.Page);
                return;
            }
            db.DataBase =this.Session["system"].ToString();
            db.IP =  this.Session["IP"].ToString();
            db.Usr=   this.Session["usr"].ToString();
            db.Pwd= this.Session["pwd"].ToString();  
            if(!this.IsPostBack)
            {
                db.LoadDdl(this.ddl_parent_id,"select * from menu_table",false);
            }
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
            this.btn_createtable.Click += new System.EventHandler(this.btn_createtable_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
		#endregion

        private void btn_createtable_Click(object sender, System.EventArgs e)
        {
            if(this.txt_menu_name.Text.Trim()==""||
                this.txt_tabletitle.Text.Trim()==""||
                this.txt_table_enname.Text.Trim()==""||
                this.txt_table_colcnt.Text.Trim()==""||
                this.txt_columnMaxLength.Text.Trim()==""||
                this.ddl_parent_id.SelectedItem==null)
            {
                db.Msgbox("填完所有项目!","",this.Page);
                return ;
            }
            System.Data.OleDb.OleDbParameter[] prms=new System.Data.OleDb.OleDbParameter[6];
            int ret=9;
            bool isok;
            prms[0]=new System.Data.OleDb.OleDbParameter();
            prms[0].Direction=System.Data.ParameterDirection.Input;
            prms[0].DbType=System.Data.DbType.String;
            prms[0].Value =this.txt_table_enname.Text.Trim();
            //
            prms[1]=new System.Data.OleDb.OleDbParameter();
            prms[1].Direction=System.Data.ParameterDirection.Input;
            prms[1].DbType=System.Data.DbType.String;
            prms[1].Value =this.txt_tabletitle.Text.Trim();
            //
            prms[2]=new System.Data.OleDb.OleDbParameter();
            prms[2].Direction=System.Data.ParameterDirection.Input;
            prms[2].DbType=System.Data.DbType.Int32;
            prms[2].Value =this.txt_table_colcnt.Text.Trim();
            //
            prms[3]=new System.Data.OleDb.OleDbParameter();
            prms[3].Direction=System.Data.ParameterDirection.Input;
            prms[3].DbType=System.Data.DbType.Int32;
            prms[3].Value =this.txt_columnMaxLength.Text.Trim();
            //
            prms[4]=new System.Data.OleDb.OleDbParameter();
            prms[4].Direction=System.Data.ParameterDirection.Input;
            prms[4].DbType=System.Data.DbType.Int32;
            prms[4].Value =this.ddl_parent_id.SelectedValue.Trim();
            //
            prms[5]=new System.Data.OleDb.OleDbParameter();
            prms[5].Direction=System.Data.ParameterDirection.Input;
            prms[5].DbType=System.Data.DbType.String;
            prms[5].Value =this.txt_menu_name.Text.Trim();
            
            isok=db.ExecSQL("trans_createtable",prms,this.Page);
            if(isok)
            {
                db.Msgbox("成功建立表！","建立表成功",this.Page);
            }
            else
            {
                    db.Msgbox("其他错误！","建立表错误",this.Page);
            }
         }
	}
}