frminitdata.cs

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

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

namespace DS.EMIS.StartPrepare
{
	/// <summary>
	/// FrmInitData 的摘要说明。
	/// </summary>
	public class FrmInitData : FrmAncestor
	{
        private System.Windows.Forms.Panel panel1;
        private System.Windows.Forms.GroupBox groupBox2;
        private System.Windows.Forms.DateTimePicker dateTimePicker1;
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.Splitter splitter1;
        private System.Windows.Forms.Panel panel2;
        private System.Windows.Forms.GroupBox groupBox1;
        private System.Windows.Forms.Panel panel3;
        private System.Windows.Forms.Button Btn_Rollback;
        private System.Windows.Forms.Button Btn_Excut;
        private System.Windows.Forms.Button Btn_Finish;
        private System.Windows.Forms.Panel panel5;
        private System.Windows.Forms.Button brn_OpenFile;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.Splitter splitter2;
        private System.Windows.Forms.Splitter splitter3;
        private System.Windows.Forms.Panel panel4;
        private DS.Win.UltraWinDataSource.UltraDataSource ultraDataSource1;
        private System.Windows.Forms.TextBox txtScriptFileName;
        private System.Windows.Forms.RichTextBox txtLog;
        private DS.Win.UltraWinGrid.UltraGrid dgInitializeInfo;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

        
		public FrmInitData()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();	
			FrmSetConfig frmSetConfig = new FrmSetConfig();
			frmSetConfig.ConfigChangEvent += new FrmSetConfig.ConfigChangHandler(FrmSetConfig_OnEvent);
			//
			// 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.UltraWinDataSource.UltraDataColumn ultraDataColumn1 = new DS.Win.UltraWinDataSource.UltraDataColumn("filename");
            DS.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn2 = new DS.Win.UltraWinDataSource.UltraDataColumn("length");
            DS.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn3 = new DS.Win.UltraWinDataSource.UltraDataColumn("isinitialized");
            DS.Win.Appearance appearance1 = new DS.Win.Appearance();
            DS.Win.UltraWinGrid.UltraGridBand ultraGridBand1 = new DS.Win.UltraWinGrid.UltraGridBand("Band 0", -1);
            DS.Win.UltraWinGrid.UltraGridColumn ultraGridColumn1 = new DS.Win.UltraWinGrid.UltraGridColumn("Select");
            DS.Win.UltraWinGrid.UltraGridColumn ultraGridColumn2 = new DS.Win.UltraWinGrid.UltraGridColumn("DisplayName");
            DS.Win.UltraWinGrid.UltraGridColumn ultraGridColumn3 = new DS.Win.UltraWinGrid.UltraGridColumn("FileName", -1, null, 0, DS.Win.UltraWinGrid.SortIndicator.Ascending, false);
            DS.Win.UltraWinGrid.UltraGridColumn ultraGridColumn4 = new DS.Win.UltraWinGrid.UltraGridColumn("UpdateTime");
            DS.Win.UltraWinGrid.UltraGridColumn ultraGridColumn5 = new DS.Win.UltraWinGrid.UltraGridColumn("StateImage");
            DS.Win.Appearance appearance2 = new DS.Win.Appearance();
            DS.Win.Appearance appearance3 = new DS.Win.Appearance();
            DS.Win.Appearance appearance4 = new DS.Win.Appearance();
            DS.Win.Appearance appearance5 = new DS.Win.Appearance();
            DS.Win.Appearance appearance6 = new DS.Win.Appearance();
            DS.Win.Appearance appearance7 = new DS.Win.Appearance();
            DS.Win.Appearance appearance8 = new DS.Win.Appearance();
            DS.Win.Appearance appearance9 = new DS.Win.Appearance();
            DS.Win.Appearance appearance10 = new DS.Win.Appearance();
            DS.Win.Appearance appearance11 = new DS.Win.Appearance();
            DS.Win.Appearance appearance12 = new DS.Win.Appearance();
            this.panel1 = new System.Windows.Forms.Panel();
            this.groupBox2 = new System.Windows.Forms.GroupBox();
            this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
            this.label3 = new System.Windows.Forms.Label();
            this.txtLog = new System.Windows.Forms.RichTextBox();
            this.splitter1 = new System.Windows.Forms.Splitter();
            this.panel2 = new System.Windows.Forms.Panel();
            this.groupBox1 = new System.Windows.Forms.GroupBox();
            this.panel4 = new System.Windows.Forms.Panel();
            this.splitter3 = new System.Windows.Forms.Splitter();
            this.splitter2 = new System.Windows.Forms.Splitter();
            this.panel5 = new System.Windows.Forms.Panel();
            this.brn_OpenFile = new System.Windows.Forms.Button();
            this.label1 = new System.Windows.Forms.Label();
            this.txtScriptFileName = new System.Windows.Forms.TextBox();
            this.panel3 = new System.Windows.Forms.Panel();
            this.Btn_Rollback = new System.Windows.Forms.Button();
            this.Btn_Excut = new System.Windows.Forms.Button();
            this.Btn_Finish = new System.Windows.Forms.Button();
            this.ultraDataSource1 = new DS.Win.UltraWinDataSource.UltraDataSource();
            this.dgInitializeInfo = new DS.Win.UltraWinGrid.UltraGrid();
            this.panel1.SuspendLayout();
            this.groupBox2.SuspendLayout();
            this.panel2.SuspendLayout();
            this.groupBox1.SuspendLayout();
            this.panel4.SuspendLayout();
            this.panel5.SuspendLayout();
            this.panel3.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.ultraDataSource1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.dgInitializeInfo)).BeginInit();
            this.SuspendLayout();
            // 
            // panel1
            // 
            this.panel1.Controls.Add(this.groupBox2);
            this.panel1.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.panel1.Location = new System.Drawing.Point(0, 285);
            this.panel1.Name = "panel1";
            this.panel1.Size = new System.Drawing.Size(696, 196);
            this.panel1.TabIndex = 30;
            // 
            // groupBox2
            // 
            this.groupBox2.Controls.Add(this.dateTimePicker1);
            this.groupBox2.Controls.Add(this.label3);
            this.groupBox2.Controls.Add(this.txtLog);
            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(696, 196);
            this.groupBox2.TabIndex = 30;
            this.groupBox2.TabStop = false;
            this.groupBox2.Text = "日志";
            // 
            // dateTimePicker1
            // 
            this.dateTimePicker1.Enabled = false;
            this.dateTimePicker1.Location = new System.Drawing.Point(420, 24);
            this.dateTimePicker1.Name = "dateTimePicker1";
            this.dateTimePicker1.TabIndex = 6;
            // 
            // label3
            // 
            this.label3.Location = new System.Drawing.Point(356, 24);
            this.label3.Name = "label3";
            this.label3.Size = new System.Drawing.Size(56, 23);
            this.label3.TabIndex = 5;
            this.label3.Text = "创建时间";
            // 
            // txtLog
            // 
            this.txtLog.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.txtLog.Location = new System.Drawing.Point(3, 53);
            this.txtLog.Name = "txtLog";
            this.txtLog.Size = new System.Drawing.Size(690, 140);
            this.txtLog.TabIndex = 0;
            this.txtLog.Text = "";
            // 
            // splitter1
            // 
            this.splitter1.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.splitter1.Location = new System.Drawing.Point(0, 281);
            this.splitter1.Name = "splitter1";
            this.splitter1.Size = new System.Drawing.Size(696, 4);
            this.splitter1.TabIndex = 31;
            this.splitter1.TabStop = false;
            // 
            // panel2
            // 
            this.panel2.Controls.Add(this.groupBox1);
            this.panel2.Dock = System.Windows.Forms.DockStyle.Fill;
            this.panel2.Location = new System.Drawing.Point(0, 0);
            this.panel2.Name = "panel2";
            this.panel2.Size = new System.Drawing.Size(696, 281);
            this.panel2.TabIndex = 32;
            // 
            // groupBox1
            // 
            this.groupBox1.Controls.Add(this.panel4);
            this.groupBox1.Controls.Add(this.splitter3);
            this.groupBox1.Controls.Add(this.splitter2);
            this.groupBox1.Controls.Add(this.panel5);
            this.groupBox1.Controls.Add(this.panel3);
            this.groupBox1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.groupBox1.Location = new System.Drawing.Point(0, 0);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Size = new System.Drawing.Size(696, 281);
            this.groupBox1.TabIndex = 1;
            this.groupBox1.TabStop = false;
            this.groupBox1.Text = "配置信息";
            // 
            // panel4
            // 
            this.panel4.Controls.Add(this.dgInitializeInfo);
            this.panel4.Dock = System.Windows.Forms.DockStyle.Fill;
            this.panel4.Location = new System.Drawing.Point(3, 55);
            this.panel4.Name = "panel4";
            this.panel4.Size = new System.Drawing.Size(690, 188);
            this.panel4.TabIndex = 47;
            // 
            // splitter3
            // 
            this.splitter3.Dock = System.Windows.Forms.DockStyle.Top;
            this.splitter3.Location = new System.Drawing.Point(3, 52);
            this.splitter3.Name = "splitter3";
            this.splitter3.Size = new System.Drawing.Size(690, 3);
            this.splitter3.TabIndex = 45;
            this.splitter3.TabStop = false;