frmcreateemisdb.cs

自己编写的基本Orcale的通用的数据库初始化工具。

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using DS.EMIS.StartPrepare.Common;

namespace DS.EMIS.StartPrepare
{
	/// <summary>
	/// FrmCreateEMISDB 的摘要说明。
	/// </summary>
	public class FrmCreateEMISDB :FrmAncestor
	{
        private System.Windows.Forms.TabPage tabPage1;
        private DS.Win.UltraWinTabControl.UltraTabControl TabControl;
        private DS.Win.UltraWinTabControl.UltraTabSharedControlsPage ultraTabSharedControlsPage1;
        private DS.Win.UltraWinTabControl.UltraTabPageControl ultraTabPageControl2;
        private System.Windows.Forms.GroupBox groupBox3;
        private System.Windows.Forms.GroupBox groupBox1;
        private System.Windows.Forms.DateTimePicker dateTimePicker1;
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.DateTimePicker dateTimePicker2;
        private System.Windows.Forms.Label label4;
        private DS.Win.UltraWinTabControl.UltraTabPageControl tpCreateTable;
        private System.Windows.Forms.Splitter splitter1;
        private System.Windows.Forms.Splitter splitter2;
        private System.Windows.Forms.Panel panel1;
        private System.Windows.Forms.GroupBox groupBox2;
        private System.Windows.Forms.Panel panel2;
        private System.Windows.Forms.Button Btn_Save;
        private System.Windows.Forms.Button Btn_Excut;
        private System.Windows.Forms.Button Btn_Cancel;
        private System.Windows.Forms.Button Btn_Check;
        private System.Windows.Forms.Panel panel3;
        private System.Windows.Forms.Button button1;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.TextBox textBox1;
        private System.Windows.Forms.Splitter splitter3;
        private System.Windows.Forms.Splitter splitter4;
        private System.Windows.Forms.Panel panel4;
        private System.Windows.Forms.Panel panel5;
        private System.Windows.Forms.GroupBox groupBox4;
        private System.Windows.Forms.Panel panel6;
        private System.Windows.Forms.Button btn_Finish;
        private System.Windows.Forms.Button button4;
        private System.Windows.Forms.Panel panel7;
        private System.Windows.Forms.Button button6;
        private System.Windows.Forms.Label label2;
        private System.Windows.Forms.TextBox textBox2;
        private System.Windows.Forms.Splitter splitter5;
        private System.Windows.Forms.Splitter splitter6;
        private System.Windows.Forms.Panel panel8;
        private System.Windows.Forms.Button bnt_check1;
        private System.Windows.Forms.Button Btn_Excut1;
        private System.Windows.Forms.RichTextBox txtLogtb;
        private System.Windows.Forms.RichTextBox txtLogsp;
        private System.Windows.Forms.RichTextBox rtxttb;
        private System.Windows.Forms.RichTextBox rtxtsp;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public FrmCreateEMISDB()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
            DS.Win.UltraWinTabControl.UltraTab ultraTab1 = new DS.Win.UltraWinTabControl.UltraTab();
            DS.Win.UltraWinTabControl.UltraTab ultraTab2 = new DS.Win.UltraWinTabControl.UltraTab();
            this.tpCreateTable = new DS.Win.UltraWinTabControl.UltraTabPageControl();
            this.panel1 = new System.Windows.Forms.Panel();
            this.groupBox2 = new System.Windows.Forms.GroupBox();
            this.panel4 = new System.Windows.Forms.Panel();
            this.rtxttb = new System.Windows.Forms.RichTextBox();
            this.splitter4 = new System.Windows.Forms.Splitter();
            this.splitter3 = new System.Windows.Forms.Splitter();
            this.panel3 = new System.Windows.Forms.Panel();
            this.button1 = new System.Windows.Forms.Button();
            this.label1 = new System.Windows.Forms.Label();
            this.textBox1 = new System.Windows.Forms.TextBox();
            this.panel2 = new System.Windows.Forms.Panel();
            this.Btn_Save = new System.Windows.Forms.Button();
            this.Btn_Excut = new System.Windows.Forms.Button();
            this.Btn_Cancel = new System.Windows.Forms.Button();
            this.Btn_Check = new System.Windows.Forms.Button();
            this.splitter1 = new System.Windows.Forms.Splitter();
            this.groupBox3 = new System.Windows.Forms.GroupBox();
            this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
            this.label3 = new System.Windows.Forms.Label();
            this.txtLogtb = new System.Windows.Forms.RichTextBox();
            this.ultraTabPageControl2 = new DS.Win.UltraWinTabControl.UltraTabPageControl();
            this.panel5 = new System.Windows.Forms.Panel();
            this.groupBox4 = new System.Windows.Forms.GroupBox();
            this.panel8 = new System.Windows.Forms.Panel();
            this.rtxtsp = new System.Windows.Forms.RichTextBox();
            this.splitter6 = new System.Windows.Forms.Splitter();
            this.splitter5 = new System.Windows.Forms.Splitter();
            this.panel7 = new System.Windows.Forms.Panel();
            this.button6 = new System.Windows.Forms.Button();
            this.label2 = new System.Windows.Forms.Label();
            this.textBox2 = new System.Windows.Forms.TextBox();
            this.panel6 = new System.Windows.Forms.Panel();
            this.btn_Finish = new System.Windows.Forms.Button();
            this.Btn_Excut1 = new System.Windows.Forms.Button();
            this.button4 = new System.Windows.Forms.Button();
            this.bnt_check1 = new System.Windows.Forms.Button();
            this.splitter2 = new System.Windows.Forms.Splitter();
            this.groupBox1 = new System.Windows.Forms.GroupBox();
            this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker();
            this.label4 = new System.Windows.Forms.Label();
            this.txtLogsp = new System.Windows.Forms.RichTextBox();
            this.tabPage1 = new System.Windows.Forms.TabPage();
            this.TabControl = new DS.Win.UltraWinTabControl.UltraTabControl();
            this.ultraTabSharedControlsPage1 = new DS.Win.UltraWinTabControl.UltraTabSharedControlsPage();
            this.tpCreateTable.SuspendLayout();
            this.panel1.SuspendLayout();
            this.groupBox2.SuspendLayout();
            this.panel4.SuspendLayout();
            this.panel3.SuspendLayout();
            this.panel2.SuspendLayout();
            this.groupBox3.SuspendLayout();
            this.ultraTabPageControl2.SuspendLayout();
            this.panel5.SuspendLayout();
            this.groupBox4.SuspendLayout();
            this.panel8.SuspendLayout();
            this.panel7.SuspendLayout();
            this.panel6.SuspendLayout();
            this.groupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.TabControl)).BeginInit();
            this.TabControl.SuspendLayout();
            this.SuspendLayout();
            // 
            // tpCreateTable
            // 
            this.tpCreateTable.Controls.Add(this.panel1);
            this.tpCreateTable.Controls.Add(this.splitter1);
            this.tpCreateTable.Controls.Add(this.groupBox3);
            this.tpCreateTable.Location = new System.Drawing.Point(-10000, -10000);
            this.tpCreateTable.Name = "tpCreateTable";
            this.tpCreateTable.Size = new System.Drawing.Size(688, 521);
            // 
            // panel1
            // 
            this.panel1.Controls.Add(this.groupBox2);
            this.panel1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.panel1.Location = new System.Drawing.Point(0, 0);
            this.panel1.Name = "panel1";
            this.panel1.Size = new System.Drawing.Size(688, 322);
            this.panel1.TabIndex = 21;
            // 
            // groupBox2
            // 
            this.groupBox2.Controls.Add(this.panel4);
            this.groupBox2.Controls.Add(this.splitter4);
            this.groupBox2.Controls.Add(this.splitter3);
            this.groupBox2.Controls.Add(this.panel3);
            this.groupBox2.Controls.Add(this.panel2);
            this.groupBox2.Dock = System.Windows.Forms.DockStyle.Fill;
            this.groupBox2.Location = new System.Drawing.Point(0, 0);
            this.groupBox2.Name = "groupBox2";
            this.groupBox2.Size = new System.Drawing.Size(688, 322);
            this.groupBox2.TabIndex = 19;
            this.groupBox2.TabStop = false;
            this.groupBox2.Text = "创建表";
            // 
            // panel4
            // 
            this.panel4.Controls.Add(this.rtxttb);
            this.panel4.Dock = System.Windows.Forms.DockStyle.Fill;
            this.panel4.Location = new System.Drawing.Point(3, 51);
            this.panel4.Name = "panel4";
            this.panel4.Size = new System.Drawing.Size(682, 233);
            this.panel4.TabIndex = 35;
            // 
            // rtxttb
            // 
            this.rtxttb.Dock = System.Windows.Forms.DockStyle.Fill;
            this.rtxttb.Location = new System.Drawing.Point(0, 0);
            this.rtxttb.Name = "rtxttb";
            this.rtxttb.Size = new System.Drawing.Size(682, 233);
            this.rtxttb.TabIndex = 5;
            this.rtxttb.Text = "";
            // 
            // splitter4
            // 
            this.splitter4.Dock = System.Windows.Forms.DockStyle.Top;
            this.splitter4.Location = new System.Drawing.Point(3, 48);
            this.splitter4.Name = "splitter4";
            this.splitter4.Size = new System.Drawing.Size(682, 3);
            this.splitter4.TabIndex = 34;
            this.splitter4.TabStop = false;
            // 
            // splitter3
            // 
            this.splitter3.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.splitter3.Location = new System.Drawing.Point(3, 284);
            this.splitter3.Name = "splitter3";
            this.splitter3.Size = new System.Drawing.Size(682, 3);
            this.splitter3.TabIndex = 33;
            this.splitter3.TabStop = false;
            // 
            // panel3
            // 
            this.panel3.Controls.Add(this.button1);
            this.panel3.Controls.Add(this.label1);
            this.panel3.Controls.Add(this.textBox1);
            this.panel3.Dock = System.Windows.Forms.DockStyle.Top;
            this.panel3.Location = new System.Drawing.Point(3, 17);
            this.panel3.Name = "panel3";
            this.panel3.Size = new System.Drawing.Size(682, 31);
            this.panel3.TabIndex = 32;
            // 
            // button1
            // 
            this.button1.Location = new System.Drawing.Point(574, 7);
            this.button1.Name = "button1";
            this.button1.Size = new System.Drawing.Size(32, 23);
            this.button1.TabIndex = 10;
            this.button1.Text = "...";
            this.button1.Click += new System.EventHandler(this.button1_Click);
            // 
            // label1
            // 
            this.label1.Location = new System.Drawing.Point(22, 7);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(80, 20);
            this.label1.TabIndex = 9;
            this.label1.Text = "创建表脚本";
            // 
            // textBox1
            // 
            this.textBox1.Location = new System.Drawing.Point(102, 7);
            this.textBox1.Name = "textBox1";
            this.textBox1.ReadOnly = true;
            this.textBox1.Size = new System.Drawing.Size(472, 21);
            this.textBox1.TabIndex = 8;
            this.textBox1.Text = "";
            // 
            // panel2
            // 
            this.panel2.Controls.Add(this.Btn_Save);
            this.panel2.Controls.Add(this.Btn_Excut);
            this.panel2.Controls.Add(this.Btn_Cancel);
            this.panel2.Controls.Add(this.Btn_Check);
            this.panel2.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.panel2.Location = new System.Drawing.Point(3, 287);
            this.panel2.Name = "panel2";
            this.panel2.Size = new System.Drawing.Size(682, 32);
            this.panel2.TabIndex = 31;
            // 
            // Btn_Save
            // 
            this.Btn_Save.Location = new System.Drawing.Point(311, 3);
            this.Btn_Save.Name = "Btn_Save";
            this.Btn_Save.TabIndex = 34;
            this.Btn_Save.Text = "修改/保存";
            this.Btn_Save.Click += new System.EventHandler(this.Btn_Save_Click);
            // 
            // Btn_Excut
            // 
            this.Btn_Excut.Location = new System.Drawing.Point(219, 3);
            this.Btn_Excut.Name = "Btn_Excut";
            this.Btn_Excut.TabIndex = 33;
            this.Btn_Excut.Text = "执行";
            this.Btn_Excut.Click += new System.EventHandler(this.Btn_Excut_Click);
            // 
            // Btn_Cancel
            // 
            this.Btn_Cancel.Location = new System.Drawing.Point(399, 3);
            this.Btn_Cancel.Name = "Btn_Cancel";
            this.Btn_Cancel.TabIndex = 32;
            this.Btn_Cancel.Text = "下一步";
            this.Btn_Cancel.Click += new System.EventHandler(this.Btn_Cancel_Click);
            // 
            // Btn_Check
            // 
            this.Btn_Check.Location = new System.Drawing.Point(135, 3);
            this.Btn_Check.Name = "Btn_Check";
            this.Btn_Check.TabIndex = 31;
            this.Btn_Check.Text = "检测";
            this.Btn_Check.Click += new System.EventHandler(this.Btn_Check_Click);
            // 
            // splitter1
            // 
            this.splitter1.Dock = System.Windows.Forms.DockStyle.Bottom;