frmoptimize.cs

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

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

namespace DS.EMIS.StartPrepare
{
	/// <summary>
	/// FrmOptimize 的摘要说明。
	/// </summary>
	public class FrmOptimize : FrmAncestor
	{
		string taskName = "OptiDBTask";
		private OptimizeManager  opManager = new OptimizeManager();		
		private System.Windows.Forms.Panel panel1;
		private System.Windows.Forms.Panel panel2;
		private System.Windows.Forms.Splitter splitter1;
		private System.Windows.Forms.Panel panel3;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.Panel panel4;
		private System.Windows.Forms.Panel panel5;
		private System.Windows.Forms.Panel panel7;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox txtConfigPath;
		private System.Windows.Forms.Button btnOpen;
		private System.Windows.Forms.Button btnCheck;
		private System.Windows.Forms.Button btnExecute;
		private System.Windows.Forms.Button btnFinish;
		private DS.Win.UltraWinGrid.UltraGrid dgConfig;
		private System.Windows.Forms.ImageList imageList1;
		private DS.EMIS.StartPrepare.CtrlResultPanel ctrlResultPanel1;
		private System.ComponentModel.IContainer components;

		public FrmOptimize()
		{
			//
			// 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()
		{
			this.components = new System.ComponentModel.Container();
			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");
			DS.Win.UltraWinGrid.UltraGridColumn ultraGridColumn4 = new DS.Win.UltraWinGrid.UltraGridColumn("UpdateTime");
			DS.Win.UltraWinGrid.UltraGridColumn ultraGridColumn5 = new DS.Win.UltraWinGrid.UltraGridColumn("StateImage", -1, null, 0, DS.Win.UltraWinGrid.SortIndicator.Ascending, false);
			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();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(FrmOptimize));
			this.panel1 = new System.Windows.Forms.Panel();
			this.btnFinish = new System.Windows.Forms.Button();
			this.btnExecute = new System.Windows.Forms.Button();
			this.btnCheck = new System.Windows.Forms.Button();
			this.panel2 = new System.Windows.Forms.Panel();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.panel7 = new System.Windows.Forms.Panel();
			this.ctrlResultPanel1 = new DS.EMIS.StartPrepare.CtrlResultPanel();
			this.splitter1 = new System.Windows.Forms.Splitter();
			this.panel3 = new System.Windows.Forms.Panel();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.panel5 = new System.Windows.Forms.Panel();
			this.dgConfig = new DS.Win.UltraWinGrid.UltraGrid();
			this.panel4 = new System.Windows.Forms.Panel();
			this.btnOpen = new System.Windows.Forms.Button();
			this.txtConfigPath = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			this.imageList1 = new System.Windows.Forms.ImageList(this.components);
			this.panel1.SuspendLayout();
			this.panel2.SuspendLayout();
			this.groupBox2.SuspendLayout();
			this.panel7.SuspendLayout();
			this.panel3.SuspendLayout();
			this.groupBox1.SuspendLayout();
			this.panel5.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dgConfig)).BeginInit();
			this.panel4.SuspendLayout();
			this.SuspendLayout();
			// 
			// panel1
			// 
			this.panel1.Controls.Add(this.btnFinish);
			this.panel1.Controls.Add(this.btnExecute);
			this.panel1.Controls.Add(this.btnCheck);
			this.panel1.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.panel1.Location = new System.Drawing.Point(0, 438);
			this.panel1.Name = "panel1";
			this.panel1.Size = new System.Drawing.Size(576, 40);
			this.panel1.TabIndex = 0;
			// 
			// btnFinish
			// 
			this.btnFinish.Location = new System.Drawing.Point(360, 8);
			this.btnFinish.Name = "btnFinish";
			this.btnFinish.TabIndex = 5;
			this.btnFinish.Text = "完成";
			this.btnFinish.Click += new System.EventHandler(this.btnFinish_Click);
			// 
			// btnExecute
			// 
			this.btnExecute.Location = new System.Drawing.Point(256, 8);
			this.btnExecute.Name = "btnExecute";
			this.btnExecute.TabIndex = 4;
			this.btnExecute.Text = "执行";
			this.btnExecute.Click += new System.EventHandler(this.btnExecute_Click);
			// 
			// btnCheck
			// 
			this.btnCheck.Location = new System.Drawing.Point(152, 8);
			this.btnCheck.Name = "btnCheck";
			this.btnCheck.TabIndex = 3;
			this.btnCheck.Text = "检测";
			this.btnCheck.Visible = false;
			this.btnCheck.Click += new System.EventHandler(this.btnCheck_Click);
			// 
			// panel2
			// 
			this.panel2.Controls.Add(this.groupBox2);
			this.panel2.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.panel2.Location = new System.Drawing.Point(0, 238);
			this.panel2.Name = "panel2";
			this.panel2.Size = new System.Drawing.Size(576, 200);
			this.panel2.TabIndex = 1;
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.panel7);
			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(576, 200);
			this.groupBox2.TabIndex = 0;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "执行日志";
			// 
			// panel7
			// 
			this.panel7.Controls.Add(this.ctrlResultPanel1);
			this.panel7.Dock = System.Windows.Forms.DockStyle.Fill;
			this.panel7.Location = new System.Drawing.Point(3, 17);
			this.panel7.Name = "panel7";
			this.panel7.Size = new System.Drawing.Size(570, 180);
			this.panel7.TabIndex = 1;
			// 
			// ctrlResultPanel1
			// 
			this.ctrlResultPanel1.AutoScroll = true;
			this.ctrlResultPanel1.Dock = System.Windows.Forms.DockStyle.Fill;
			this.ctrlResultPanel1.Location = new System.Drawing.Point(0, 0);
			this.ctrlResultPanel1.Name = "ctrlResultPanel1";
			this.ctrlResultPanel1.Size = new System.Drawing.Size(570, 180);
			this.ctrlResultPanel1.TabIndex = 0;
			// 
			// splitter1
			// 
			this.splitter1.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.splitter1.Location = new System.Drawing.Point(0, 235);
			this.splitter1.Name = "splitter1";
			this.splitter1.Size = new System.Drawing.Size(576, 3);
			this.splitter1.TabIndex = 2;
			this.splitter1.TabStop = false;
			// 
			// panel3
			// 
			this.panel3.Controls.Add(this.groupBox1);
			this.panel3.Dock = System.Windows.Forms.DockStyle.Fill;
			this.panel3.Location = new System.Drawing.Point(0, 0);
			this.panel3.Name = "panel3";
			this.panel3.Size = new System.Drawing.Size(576, 235);
			this.panel3.TabIndex = 3;
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.panel5);
			this.groupBox1.Controls.Add(this.panel4);
			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(576, 235);
			this.groupBox1.TabIndex = 0;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "数据库优化";
			// 
			// panel5
			// 
			this.panel5.Controls.Add(this.dgConfig);
			this.panel5.Dock = System.Windows.Forms.DockStyle.Fill;
			this.panel5.Location = new System.Drawing.Point(3, 56);
			this.panel5.Name = "panel5";
			this.panel5.Size = new System.Drawing.Size(570, 176);
			this.panel5.TabIndex = 1;
			// 
			// dgConfig
			// 
			appearance1.BackColor = System.Drawing.SystemColors.Window;
			appearance1.BorderColor = System.Drawing.SystemColors.InactiveCaption;
			this.dgConfig.DisplayLayout.Appearance = appearance1;
			this.dgConfig.DisplayLayout.AutoFitStyle = DS.Win.UltraWinGrid.AutoFitStyle.ResizeAllColumns;
			ultraGridColumn1.Header.Caption = "选择";
			ultraGridColumn1.Header.VisiblePosition = 0;
			ultraGridColumn1.Width = 44;
			ultraGridColumn2.CellActivation = DS.Win.UltraWinGrid.Activation.NoEdit;
			ultraGridColumn2.Header.Caption = "脚本功能";
			ultraGridColumn2.Header.VisiblePosition = 1;
			ultraGridColumn2.Width = 143;
			ultraGridColumn3.CellActivation = DS.Win.UltraWinGrid.Activation.NoEdit;
			ultraGridColumn3.Header.Caption = "文件名";
			ultraGridColumn3.Header.VisiblePosition = 2;
			ultraGridColumn3.Width = 187;
			ultraGridColumn4.CellActivation = DS.Win.UltraWinGrid.Activation.NoEdit;
			ultraGridColumn4.Header.Caption = "创建/修改时间";
			ultraGridColumn4.Header.VisiblePosition = 3;
			ultraGridColumn4.Width = 194;
			ultraGridColumn5.Header.Caption = "执行状态";
			ultraGridColumn5.Header.VisiblePosition = 4;
			ultraGridColumn5.Hidden = true;
			ultraGridColumn5.Width = 112;
			ultraGridBand1.Columns.AddRange(new object[] {
															 ultraGridColumn1,
															 ultraGridColumn2,
															 ultraGridColumn3,
															 ultraGridColumn4,
															 ultraGridColumn5});
			this.dgConfig.DisplayLayout.BandsSerializer.Add(ultraGridBand1);
			this.dgConfig.DisplayLayout.BorderStyle = DS.Win.UIElementBorderStyle.Solid;
			this.dgConfig.DisplayLayout.CaptionVisible = DS.Win.DefaultableBoolean.False;
			appearance2.BackColor = System.Drawing.SystemColors.ActiveBorder;
			appearance2.BackColor2 = System.Drawing.SystemColors.ControlDark;
			appearance2.BackGradientStyle = DS.Win.GradientStyle.Vertical;
			appearance2.BorderColor = System.Drawing.SystemColors.Window;
			this.dgConfig.DisplayLayout.GroupByBox.Appearance = appearance2;
			appearance3.ForeColor = System.Drawing.SystemColors.GrayText;
			this.dgConfig.DisplayLayout.GroupByBox.BandLabelAppearance = appearance3;
			this.dgConfig.DisplayLayout.GroupByBox.BorderStyle = DS.Win.UIElementBorderStyle.Solid;
			appearance4.BackColor = System.Drawing.SystemColors.ControlLightLight;
			appearance4.BackColor2 = System.Drawing.SystemColors.Control;
			appearance4.BackGradientStyle = DS.Win.GradientStyle.Horizontal;
			appearance4.ForeColor = System.Drawing.SystemColors.GrayText;
			this.dgConfig.DisplayLayout.GroupByBox.PromptAppearance = appearance4;
			this.dgConfig.DisplayLayout.MaxColScrollRegions = 1;
			this.dgConfig.DisplayLayout.MaxRowScrollRegions = 1;
			appearance5.BackColor = System.Drawing.SystemColors.Window;
			appearance5.ForeColor = System.Drawing.SystemColors.ControlText;
			this.dgConfig.DisplayLayout.Override.ActiveCellAppearance = appearance5;
			appearance6.BackColor = System.Drawing.SystemColors.Highlight;
			appearance6.ForeColor = System.Drawing.SystemColors.HighlightText;
			this.dgConfig.DisplayLayout.Override.ActiveRowAppearance = appearance6;
			this.dgConfig.DisplayLayout.Override.BorderStyleCell = DS.Win.UIElementBorderStyle.Dotted;