frmsetconfig.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>
	/// FrmSetConfig 的摘要说明。
	/// </summary>
	public class FrmSetConfig : System.Windows.Forms.Form
	{	
		public delegate void ConfigChangHandler(string fileName);
		public event ConfigChangHandler ConfigChangEvent; 
		private string configFileName = string.Empty;
		private string nodeName = string.Empty; 
		private DS.Win.Misc.UltraGroupBox ultraGroupBox1;
		private DS.Win.Misc.UltraGroupBox ultraGroupBox2;
		private DS.Win.Misc.UltraLabel ultraLabel1;
		private DS.Win.Misc.UltraLabel ultraLabel2;
		private System.Windows.Forms.RadioButton rbtInitData;
		private System.Windows.Forms.RadioButton rbtOptDB;
		private DS.Win.UltraWinGrid.UltraGrid dgFile;
		private System.Windows.Forms.TextBox txtDisplayName;
		private System.Windows.Forms.Button btnAdd;
		private System.Windows.Forms.Button btnDelete;
		private System.Windows.Forms.Button btnClose;
		private DS.Win.Misc.UltraGroupBox gbAdd;
		private System.Windows.Forms.ComboBox ddlFileName;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public FrmSetConfig()
		{
			//
			// 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.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.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();
            DS.Win.Appearance appearance13 = new DS.Win.Appearance();
            DS.Win.Appearance appearance14 = new DS.Win.Appearance();
            this.ultraGroupBox1 = new DS.Win.Misc.UltraGroupBox();
            this.rbtInitData = new System.Windows.Forms.RadioButton();
            this.rbtOptDB = new System.Windows.Forms.RadioButton();
            this.ultraGroupBox2 = new DS.Win.Misc.UltraGroupBox();
            this.dgFile = new DS.Win.UltraWinGrid.UltraGrid();
            this.btnAdd = new System.Windows.Forms.Button();
            this.txtDisplayName = new System.Windows.Forms.TextBox();
            this.ultraLabel1 = new DS.Win.Misc.UltraLabel();
            this.ultraLabel2 = new DS.Win.Misc.UltraLabel();
            this.btnDelete = new System.Windows.Forms.Button();
            this.btnClose = new System.Windows.Forms.Button();
            this.gbAdd = new DS.Win.Misc.UltraGroupBox();
            this.ddlFileName = new System.Windows.Forms.ComboBox();
            ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).BeginInit();
            this.ultraGroupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox2)).BeginInit();
            this.ultraGroupBox2.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dgFile)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.gbAdd)).BeginInit();
            this.gbAdd.SuspendLayout();
            this.SuspendLayout();
            // 
            // ultraGroupBox1
            // 
            this.ultraGroupBox1.Controls.Add(this.rbtInitData);
            this.ultraGroupBox1.Controls.Add(this.rbtOptDB);
            this.ultraGroupBox1.Dock = System.Windows.Forms.DockStyle.Top;
            this.ultraGroupBox1.Location = new System.Drawing.Point(0, 0);
            this.ultraGroupBox1.Name = "ultraGroupBox1";
            this.ultraGroupBox1.Size = new System.Drawing.Size(464, 48);
            this.ultraGroupBox1.SupportThemes = false;
            this.ultraGroupBox1.TabIndex = 0;
            this.ultraGroupBox1.Text = "选择配置";
            // 
            // rbtInitData
            // 
            this.rbtInitData.Location = new System.Drawing.Point(176, 24);
            this.rbtInitData.Name = "rbtInitData";
            this.rbtInitData.TabIndex = 1;
            this.rbtInitData.Text = "初始化数据";
            this.rbtInitData.CheckedChanged += new System.EventHandler(this.rbtInitData_CheckedChanged);
            // 
            // rbtOptDB
            // 
            this.rbtOptDB.Checked = true;
            this.rbtOptDB.Location = new System.Drawing.Point(32, 24);
            this.rbtOptDB.Name = "rbtOptDB";
            this.rbtOptDB.TabIndex = 0;
            this.rbtOptDB.TabStop = true;
            this.rbtOptDB.Text = "优化数据库";
            // 
            // ultraGroupBox2
            // 
            this.ultraGroupBox2.Controls.Add(this.dgFile);
            this.ultraGroupBox2.Dock = System.Windows.Forms.DockStyle.Top;
            this.ultraGroupBox2.Location = new System.Drawing.Point(0, 48);
            this.ultraGroupBox2.Name = "ultraGroupBox2";
            this.ultraGroupBox2.Size = new System.Drawing.Size(464, 224);
            this.ultraGroupBox2.SupportThemes = false;
            this.ultraGroupBox2.TabIndex = 1;
            this.ultraGroupBox2.Text = "脚本列表";
            this.ultraGroupBox2.ViewStyle = DS.Win.Misc.GroupBoxViewStyle.Office2003;
            // 
            // dgFile
            // 
            appearance1.BackColor = System.Drawing.SystemColors.Window;
            appearance1.BorderColor = System.Drawing.SystemColors.InactiveCaption;
            this.dgFile.DisplayLayout.Appearance = appearance1;
            this.dgFile.DisplayLayout.AutoFitStyle = DS.Win.UltraWinGrid.AutoFitStyle.ExtendLastColumn;
            ultraGridColumn1.Header.Caption = "选择";
            ultraGridColumn1.Header.VisiblePosition = 0;
            ultraGridColumn1.Width = 53;
            ultraGridColumn2.CellActivation = DS.Win.UltraWinGrid.Activation.NoEdit;
            ultraGridColumn2.Header.Caption = "脚本名称";
            ultraGridColumn2.Header.VisiblePosition = 1;
            ultraGridColumn2.Width = 187;
            ultraGridColumn3.CellActivation = DS.Win.UltraWinGrid.Activation.NoEdit;
            ultraGridColumn3.Header.Caption = "文件名";
            ultraGridColumn3.Header.VisiblePosition = 2;
            ultraGridBand1.Columns.AddRange(new object[] {
                                                             ultraGridColumn1,
                                                             ultraGridColumn2,
                                                             ultraGridColumn3});
            this.dgFile.DisplayLayout.BandsSerializer.Add(ultraGridBand1);
            this.dgFile.DisplayLayout.BorderStyle = DS.Win.UIElementBorderStyle.Solid;
            this.dgFile.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.dgFile.DisplayLayout.GroupByBox.Appearance = appearance2;
            appearance3.ForeColor = System.Drawing.SystemColors.GrayText;
            this.dgFile.DisplayLayout.GroupByBox.BandLabelAppearance = appearance3;
            this.dgFile.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.dgFile.DisplayLayout.GroupByBox.PromptAppearance = appearance4;
            this.dgFile.DisplayLayout.MaxColScrollRegions = 1;
            this.dgFile.DisplayLayout.MaxRowScrollRegions = 1;
            appearance5.BackColor = System.Drawing.SystemColors.Window;
            appearance5.ForeColor = System.Drawing.SystemColors.ControlText;
            this.dgFile.DisplayLayout.Override.ActiveCellAppearance = appearance5;
            appearance6.BackColor = System.Drawing.SystemColors.Highlight;
            appearance6.ForeColor = System.Drawing.SystemColors.HighlightText;
            this.dgFile.DisplayLayout.Override.ActiveRowAppearance = appearance6;
            this.dgFile.DisplayLayout.Override.BorderStyleCell = DS.Win.UIElementBorderStyle.Dotted;
            this.dgFile.DisplayLayout.Override.BorderStyleRow = DS.Win.UIElementBorderStyle.Dotted;
            appearance7.BackColor = System.Drawing.SystemColors.Window;
            this.dgFile.DisplayLayout.Override.CardAreaAppearance = appearance7;
            appearance8.BorderColor = System.Drawing.Color.Silver;
            appearance8.TextTrimming = DS.Win.TextTrimming.EllipsisCharacter;
            this.dgFile.DisplayLayout.Override.CellAppearance = appearance8;
            this.dgFile.DisplayLayout.Override.CellClickAction = DS.Win.UltraWinGrid.CellClickAction.EditAndSelectText;
            this.dgFile.DisplayLayout.Override.CellPadding = 0;
            appearance9.BackColor = System.Drawing.SystemColors.Control;
            appearance9.BackColor2 = System.Drawing.SystemColors.ControlDark;
            appearance9.BackGradientAlignment = DS.Win.GradientAlignment.Element;
            appearance9.BackGradientStyle = DS.Win.GradientStyle.Horizontal;
            appearance9.BorderColor = System.Drawing.SystemColors.Window;
            this.dgFile.DisplayLayout.Override.GroupByRowAppearance = appearance9;
            appearance10.TextHAlign = DS.Win.HAlign.Left;
            this.dgFile.DisplayLayout.Override.HeaderAppearance = appearance10;
            this.dgFile.DisplayLayout.Override.HeaderClickAction = DS.Win.UltraWinGrid.HeaderClickAction.SortMulti;
            this.dgFile.DisplayLayout.Override.HeaderStyle = DS.Win.HeaderStyle.WindowsXPCommand;
            appearance11.BackColor = System.Drawing.SystemColors.Window;
            appearance11.BorderColor = System.Drawing.Color.Silver;
            this.dgFile.DisplayLayout.Override.RowAppearance = appearance11;
            this.dgFile.DisplayLayout.Override.RowSelectors = DS.Win.DefaultableBoolean.False;
            appearance12.BackColor = System.Drawing.SystemColors.ControlLight;
            this.dgFile.DisplayLayout.Override.TemplateAddRowAppearance = appearance12;
            this.dgFile.DisplayLayout.ScrollBounds = DS.Win.UltraWinGrid.ScrollBounds.ScrollToFill;
            this.dgFile.DisplayLayout.ScrollStyle = DS.Win.UltraWinGrid.ScrollStyle.Immediate;
            this.dgFile.Dock = System.Windows.Forms.DockStyle.Fill;
            this.dgFile.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
            this.dgFile.Location = new System.Drawing.Point(2, 20);
            this.dgFile.Name = "dgFile";
            this.dgFile.Size = new System.Drawing.Size(460, 202);
            this.dgFile.TabIndex = 0;
            // 
            // btnAdd
            // 
            this.btnAdd.Location = new System.Drawing.Point(64, 360);
            this.btnAdd.Name = "btnAdd";
            this.btnAdd.TabIndex = 2;
            this.btnAdd.Text = "添加";
            this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
            // 
            // txtDisplayName
            // 
            this.txtDisplayName.Location = new System.Drawing.Point(88, 32);
            this.txtDisplayName.Name = "txtDisplayName";
            this.txtDisplayName.Size = new System.Drawing.Size(96, 21);
            this.txtDisplayName.TabIndex = 3;
            this.txtDisplayName.Text = "";
            // 
            // ultraLabel1
            // 
            appearance13.TextVAlign = DS.Win.VAlign.Middle;
            this.ultraLabel1.Appearance = appearance13;
            this.ultraLabel1.Location = new System.Drawing.Point(16, 32);
            this.ultraLabel1.Name = "ultraLabel1";
            this.ultraLabel1.Size = new System.Drawing.Size(64, 23);
            this.ultraLabel1.TabIndex = 4;
            this.ultraLabel1.Text = "脚本名称:";