frmsqlscript.cs

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

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.IO;
using System.Text.RegularExpressions;
using System.Threading;

namespace DS.EMIS.StartPrepare
{
	/// <summary>
	/// FrmSqlScript 的摘要说明。
	/// </summary>
	public class FrmSqlScript :Form
	{
	#region ###控件变量###	
		private DS.Win.UltraWinToolbars.UltraToolbarsManager MainUltraToolbarsManager;
		private System.Windows.Forms.Panel FrmSqlScript_Fill_Panel;
		private DS.Win.UltraWinToolbars.UltraToolbarsDockArea _FrmSqlScript_Toolbars_Dock_Area_Left;
		private DS.Win.UltraWinToolbars.UltraToolbarsDockArea _FrmSqlScript_Toolbars_Dock_Area_Right;
		private DS.Win.UltraWinToolbars.UltraToolbarsDockArea _FrmSqlScript_Toolbars_Dock_Area_Top;
		private DS.Win.UltraWinToolbars.UltraToolbarsDockArea _FrmSqlScript_Toolbars_Dock_Area_Bottom;
		private System.Windows.Forms.ImageList TbImageList;
		private System.Windows.Forms.ImageList TreeImageList;
		private System.Windows.Forms.Panel pnlMiddle;
		private System.Windows.Forms.Panel panel2;
		private System.Windows.Forms.TabControl tabControlSql;
		private System.Windows.Forms.TabPage tabPageResult;
		private System.Windows.Forms.Splitter splitter2;
		private System.Windows.Forms.Panel panel1;
		private System.Windows.Forms.RichTextBox TxtBoxSql;
		private DS.Win.UltraWinStatusBar.UltraStatusBar ultraStatusBar1;
		private System.Windows.Forms.TextBox txtResult;
		private System.ComponentModel.IContainer components;

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			DS.Win.UltraWinToolbars.UltraToolbar ultraToolbar1 = new DS.Win.UltraWinToolbars.UltraToolbar("UltraToolbarMenu");
			DS.Win.UltraWinToolbars.PopupMenuTool popupMenuTool1 = new DS.Win.UltraWinToolbars.PopupMenuTool("系统");
			DS.Win.UltraWinToolbars.PopupMenuTool popupMenuTool2 = new DS.Win.UltraWinToolbars.PopupMenuTool("工具");
			DS.Win.UltraWinToolbars.UltraToolbar ultraToolbar2 = new DS.Win.UltraWinToolbars.UltraToolbar("UltraToolbarTb");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool1 = new DS.Win.UltraWinToolbars.ButtonTool("OPEN");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool2 = new DS.Win.UltraWinToolbars.ButtonTool("SAVE");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool3 = new DS.Win.UltraWinToolbars.ButtonTool("CHECK");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool4 = new DS.Win.UltraWinToolbars.ButtonTool("EXECUTE");
			DS.Win.UltraWinToolbars.PopupMenuTool popupMenuTool3 = new DS.Win.UltraWinToolbars.PopupMenuTool("系统");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool5 = new DS.Win.UltraWinToolbars.ButtonTool("OPEN");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool6 = new DS.Win.UltraWinToolbars.ButtonTool("SAVE");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool7 = new DS.Win.UltraWinToolbars.ButtonTool("EXIT");
			DS.Win.UltraWinToolbars.PopupMenuTool popupMenuTool4 = new DS.Win.UltraWinToolbars.PopupMenuTool("工具");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool8 = new DS.Win.UltraWinToolbars.ButtonTool("CHECK");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool9 = new DS.Win.UltraWinToolbars.ButtonTool("EXECUTE");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool10 = new DS.Win.UltraWinToolbars.ButtonTool("EXECUTE");
			DS.Win.Appearance appearance1 = new DS.Win.Appearance();
			DS.Win.UltraWinToolbars.ButtonTool buttonTool11 = new DS.Win.UltraWinToolbars.ButtonTool("CHECK");
			DS.Win.Appearance appearance2 = new DS.Win.Appearance();
			DS.Win.UltraWinToolbars.ButtonTool buttonTool12 = new DS.Win.UltraWinToolbars.ButtonTool("EXIT");
			DS.Win.UltraWinToolbars.ButtonTool buttonTool13 = new DS.Win.UltraWinToolbars.ButtonTool("OPEN");
			DS.Win.Appearance appearance3 = new DS.Win.Appearance();
			DS.Win.UltraWinToolbars.ButtonTool buttonTool14 = new DS.Win.UltraWinToolbars.ButtonTool("SAVE");
			DS.Win.Appearance appearance4 = new DS.Win.Appearance();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(FrmSqlScript));
			DS.Win.UltraWinStatusBar.UltraStatusPanel ultraStatusPanel1 = new DS.Win.UltraWinStatusBar.UltraStatusPanel();
			DS.Win.UltraWinStatusBar.UltraStatusPanel ultraStatusPanel2 = new DS.Win.UltraWinStatusBar.UltraStatusPanel();
			this.MainUltraToolbarsManager = new DS.Win.UltraWinToolbars.UltraToolbarsManager(this.components);
			this.TbImageList = new System.Windows.Forms.ImageList(this.components);
			this.FrmSqlScript_Fill_Panel = new System.Windows.Forms.Panel();
			this.pnlMiddle = new System.Windows.Forms.Panel();
			this.panel1 = new System.Windows.Forms.Panel();
			this.TxtBoxSql = new System.Windows.Forms.RichTextBox();
			this.splitter2 = new System.Windows.Forms.Splitter();
			this.panel2 = new System.Windows.Forms.Panel();
			this.tabControlSql = new System.Windows.Forms.TabControl();
			this.tabPageResult = new System.Windows.Forms.TabPage();
			this.txtResult = new System.Windows.Forms.TextBox();
			this.TreeImageList = new System.Windows.Forms.ImageList(this.components);
			this._FrmSqlScript_Toolbars_Dock_Area_Left = new DS.Win.UltraWinToolbars.UltraToolbarsDockArea();
			this._FrmSqlScript_Toolbars_Dock_Area_Right = new DS.Win.UltraWinToolbars.UltraToolbarsDockArea();
			this._FrmSqlScript_Toolbars_Dock_Area_Top = new DS.Win.UltraWinToolbars.UltraToolbarsDockArea();
			this._FrmSqlScript_Toolbars_Dock_Area_Bottom = new DS.Win.UltraWinToolbars.UltraToolbarsDockArea();
			this.ultraStatusBar1 = new DS.Win.UltraWinStatusBar.UltraStatusBar();
			((System.ComponentModel.ISupportInitialize)(this.MainUltraToolbarsManager)).BeginInit();
			this.FrmSqlScript_Fill_Panel.SuspendLayout();
			this.pnlMiddle.SuspendLayout();
			this.panel1.SuspendLayout();
			this.panel2.SuspendLayout();
			this.tabControlSql.SuspendLayout();
			this.tabPageResult.SuspendLayout();
			this.SuspendLayout();
			// 
			// MainUltraToolbarsManager
			// 
			this.MainUltraToolbarsManager.DesignerFlags = 1;
			this.MainUltraToolbarsManager.DockWithinContainer = this;
			this.MainUltraToolbarsManager.ImageListLarge = this.TbImageList;
			this.MainUltraToolbarsManager.ShowFullMenusDelay = 500;
			this.MainUltraToolbarsManager.ShowQuickCustomizeButton = false;
			ultraToolbar1.DockedColumn = 0;
			ultraToolbar1.DockedRow = 0;
			ultraToolbar1.IsMainMenuBar = true;
			ultraToolbar1.Text = "UltraToolbarMenu";
			ultraToolbar1.Tools.AddRange(new DS.Win.UltraWinToolbars.ToolBase[] {
																					popupMenuTool1,
																					popupMenuTool2});
			ultraToolbar2.DockedColumn = 0;
			ultraToolbar2.DockedRow = 1;
			ultraToolbar2.FloatingSize = new System.Drawing.Size(309, 58);
			ultraToolbar2.Text = "UltraToolbarTb";
			ultraToolbar2.Tools.AddRange(new DS.Win.UltraWinToolbars.ToolBase[] {
																					buttonTool1,
																					buttonTool2,
																					buttonTool3,
																					buttonTool4});
			this.MainUltraToolbarsManager.Toolbars.AddRange(new DS.Win.UltraWinToolbars.UltraToolbar[] {
																										   ultraToolbar1,
																										   ultraToolbar2});
			popupMenuTool3.SharedProps.Caption = "系统";
			popupMenuTool3.Tools.AddRange(new DS.Win.UltraWinToolbars.ToolBase[] {
																					 buttonTool5,
																					 buttonTool6,
																					 buttonTool7});
			popupMenuTool4.SharedProps.Caption = "工具";
			popupMenuTool4.Tools.AddRange(new DS.Win.UltraWinToolbars.ToolBase[] {
																					 buttonTool8,
																					 buttonTool9});
			appearance1.Image = 4;
			buttonTool10.SharedProps.AppearancesLarge.Appearance = appearance1;
			buttonTool10.SharedProps.Caption = "执行";
			buttonTool10.SharedProps.DisplayStyle = DS.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
			appearance2.Image = 1;
			buttonTool11.SharedProps.AppearancesLarge.Appearance = appearance2;
			buttonTool11.SharedProps.Caption = "检查语法";
			buttonTool11.SharedProps.DisplayStyle = DS.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
			buttonTool11.SharedProps.Enabled = false;
			buttonTool11.SharedProps.Visible = false;
			buttonTool12.SharedProps.Caption = "退出";
			buttonTool12.SharedProps.DisplayStyle = DS.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
			appearance3.Image = 5;
			buttonTool13.SharedProps.AppearancesLarge.Appearance = appearance3;
			buttonTool13.SharedProps.Caption = "打开";
			buttonTool13.SharedProps.DisplayStyle = DS.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
			appearance4.Image = 8;
			buttonTool14.SharedProps.AppearancesLarge.Appearance = appearance4;
			buttonTool14.SharedProps.Caption = "保存";
			buttonTool14.SharedProps.DisplayStyle = DS.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
			this.MainUltraToolbarsManager.Tools.AddRange(new DS.Win.UltraWinToolbars.ToolBase[] {
																									popupMenuTool3,
																									popupMenuTool4,
																									buttonTool10,
																									buttonTool11,
																									buttonTool12,
																									buttonTool13,
																									buttonTool14});
			this.MainUltraToolbarsManager.UseLargeImagesOnToolbar = true;
			this.MainUltraToolbarsManager.ToolClick += new DS.Win.UltraWinToolbars.ToolClickEventHandler(this.MainUltraToolbarsManager_ToolClick);
			// 
			// TbImageList
			// 
			this.TbImageList.ImageSize = new System.Drawing.Size(32, 32);
			this.TbImageList.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("TbImageList.ImageStream")));
			this.TbImageList.TransparentColor = System.Drawing.Color.Transparent;
			// 
			// FrmSqlScript_Fill_Panel
			// 
			this.FrmSqlScript_Fill_Panel.Controls.Add(this.pnlMiddle);
			this.FrmSqlScript_Fill_Panel.Cursor = System.Windows.Forms.Cursors.Default;
			this.FrmSqlScript_Fill_Panel.Dock = System.Windows.Forms.DockStyle.Fill;
			this.FrmSqlScript_Fill_Panel.Location = new System.Drawing.Point(0, 62);
			this.FrmSqlScript_Fill_Panel.Name = "FrmSqlScript_Fill_Panel";
			this.FrmSqlScript_Fill_Panel.Size = new System.Drawing.Size(760, 377);
			this.FrmSqlScript_Fill_Panel.TabIndex = 0;
			// 
			// pnlMiddle
			// 
			this.pnlMiddle.BackColor = System.Drawing.SystemColors.Window;
			this.pnlMiddle.Controls.Add(this.panel1);
			this.pnlMiddle.Controls.Add(this.splitter2);
			this.pnlMiddle.Controls.Add(this.panel2);
			this.pnlMiddle.Dock = System.Windows.Forms.DockStyle.Fill;
			this.pnlMiddle.Location = new System.Drawing.Point(0, 0);
			this.pnlMiddle.Name = "pnlMiddle";
			this.pnlMiddle.Size = new System.Drawing.Size(760, 377);
			this.pnlMiddle.TabIndex = 2;
			// 
			// panel1
			// 
			this.panel1.BackColor = System.Drawing.SystemColors.Window;
			this.panel1.Controls.Add(this.TxtBoxSql);
			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(760, 233);
			this.panel1.TabIndex = 7;
			// 
			// TxtBoxSql
			// 
			this.TxtBoxSql.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.TxtBoxSql.BulletIndent = 500;
			this.TxtBoxSql.Dock = System.Windows.Forms.DockStyle.Fill;
			this.TxtBoxSql.Location = new System.Drawing.Point(0, 0);
			this.TxtBoxSql.Name = "TxtBoxSql";
			this.TxtBoxSql.Size = new System.Drawing.Size(760, 233);
			this.TxtBoxSql.TabIndex = 0;
			this.TxtBoxSql.Text = "";
			this.TxtBoxSql.TextChanged += new System.EventHandler(this.TxtBoxSql_TextChanged);
			// 
			// splitter2
			// 
			this.splitter2.BackColor = System.Drawing.SystemColors.ScrollBar;
			this.splitter2.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.splitter2.Location = new System.Drawing.Point(0, 233);
			this.splitter2.Name = "splitter2";
			this.splitter2.Size = new System.Drawing.Size(760, 8);
			this.splitter2.TabIndex = 6;
			this.splitter2.TabStop = false;
			// 
			// panel2
			// 
			this.panel2.BackColor = System.Drawing.SystemColors.Window;
			this.panel2.Controls.Add(this.tabControlSql);
			this.panel2.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.panel2.Location = new System.Drawing.Point(0, 241);
			this.panel2.Name = "panel2";
			this.panel2.Size = new System.Drawing.Size(760, 136);
			this.panel2.TabIndex = 5;
			// 
			// tabControlSql
			// 
			this.tabControlSql.Alignment = System.Windows.Forms.TabAlignment.Bottom;
			this.tabControlSql.Controls.Add(this.tabPageResult);
			this.tabControlSql.Dock = System.Windows.Forms.DockStyle.Fill;
			this.tabControlSql.Location = new System.Drawing.Point(0, 0);
			this.tabControlSql.Name = "tabControlSql";
			this.tabControlSql.SelectedIndex = 0;
			this.tabControlSql.Size = new System.Drawing.Size(760, 136);
			this.tabControlSql.TabIndex = 0;
			// 
			// tabPageResult
			// 
			this.tabPageResult.BackColor = System.Drawing.SystemColors.Window;
			this.tabPageResult.Controls.Add(this.txtResult);
			this.tabPageResult.Location = new System.Drawing.Point(4, 4);
			this.tabPageResult.Name = "tabPageResult";
			this.tabPageResult.Size = new System.Drawing.Size(752, 111);
			this.tabPageResult.TabIndex = 0;
			this.tabPageResult.Text = "结果";
			// 
			// txtResult
			// 
			this.txtResult.AutoSize = false;
			this.txtResult.Dock = System.Windows.Forms.DockStyle.Fill;
			this.txtResult.Location = new System.Drawing.Point(0, 0);
			this.txtResult.Multiline = true;
			this.txtResult.Name = "txtResult";
			this.txtResult.Size = new System.Drawing.Size(752, 111);
			this.txtResult.TabIndex = 0;
			this.txtResult.Text = "";
			// 
			// TreeImageList