📄 frminitdata.cs
字号:
//
// splitter2
//
this.splitter2.Dock = System.Windows.Forms.DockStyle.Bottom;
this.splitter2.Location = new System.Drawing.Point(3, 243);
this.splitter2.Name = "splitter2";
this.splitter2.Size = new System.Drawing.Size(690, 3);
this.splitter2.TabIndex = 44;
this.splitter2.TabStop = false;
//
// panel5
//
this.panel5.Controls.Add(this.brn_OpenFile);
this.panel5.Controls.Add(this.label1);
this.panel5.Controls.Add(this.txtScriptFileName);
this.panel5.Dock = System.Windows.Forms.DockStyle.Top;
this.panel5.Location = new System.Drawing.Point(3, 17);
this.panel5.Name = "panel5";
this.panel5.Size = new System.Drawing.Size(690, 35);
this.panel5.TabIndex = 43;
//
// brn_OpenFile
//
this.brn_OpenFile.Location = new System.Drawing.Point(586, 9);
this.brn_OpenFile.Name = "brn_OpenFile";
this.brn_OpenFile.Size = new System.Drawing.Size(32, 23);
this.brn_OpenFile.TabIndex = 43;
this.brn_OpenFile.Text = "...";
this.brn_OpenFile.Click += new System.EventHandler(this.brn_OpenFile_Click);
//
// label1
//
this.label1.Location = new System.Drawing.Point(20, 12);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(92, 15);
this.label1.TabIndex = 42;
this.label1.Text = "初始化脚本文件";
//
// txtScriptFileName
//
this.txtScriptFileName.Location = new System.Drawing.Point(114, 9);
this.txtScriptFileName.Name = "txtScriptFileName";
this.txtScriptFileName.ReadOnly = true;
this.txtScriptFileName.Size = new System.Drawing.Size(472, 21);
this.txtScriptFileName.TabIndex = 41;
this.txtScriptFileName.Text = "";
//
// panel3
//
this.panel3.Controls.Add(this.Btn_Rollback);
this.panel3.Controls.Add(this.Btn_Excut);
this.panel3.Controls.Add(this.Btn_Finish);
this.panel3.Dock = System.Windows.Forms.DockStyle.Bottom;
this.panel3.Location = new System.Drawing.Point(3, 246);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(690, 32);
this.panel3.TabIndex = 41;
//
// Btn_Rollback
//
this.Btn_Rollback.Enabled = false;
this.Btn_Rollback.Location = new System.Drawing.Point(308, 5);
this.Btn_Rollback.Name = "Btn_Rollback";
this.Btn_Rollback.TabIndex = 40;
this.Btn_Rollback.Text = "回滚";
this.Btn_Rollback.Click += new System.EventHandler(this.Btn_Rollback_Click);
//
// Btn_Excut
//
this.Btn_Excut.Location = new System.Drawing.Point(216, 5);
this.Btn_Excut.Name = "Btn_Excut";
this.Btn_Excut.TabIndex = 39;
this.Btn_Excut.Text = "执行";
this.Btn_Excut.Click += new System.EventHandler(this.Btn_Excut_Click);
//
// Btn_Finish
//
this.Btn_Finish.Location = new System.Drawing.Point(396, 5);
this.Btn_Finish.Name = "Btn_Finish";
this.Btn_Finish.TabIndex = 38;
this.Btn_Finish.Text = "完成";
this.Btn_Finish.Click += new System.EventHandler(this.Btn_Finish_Click);
//
// ultraDataSource1
//
this.ultraDataSource1.Band.Columns.AddRange(new object[] {
ultraDataColumn1,
ultraDataColumn2,
ultraDataColumn3});
//
// dgInitializeInfo
//
appearance1.BackColor = System.Drawing.SystemColors.Window;
appearance1.BorderColor = System.Drawing.SystemColors.InactiveCaption;
this.dgInitializeInfo.DisplayLayout.Appearance = appearance1;
this.dgInitializeInfo.DisplayLayout.AutoFitStyle = DS.Win.UltraWinGrid.AutoFitStyle.ResizeAllColumns;
ultraGridColumn1.Header.Caption = "选择";
ultraGridColumn1.Header.VisiblePosition = 0;
ultraGridColumn1.Width = 55;
ultraGridColumn2.CellActivation = DS.Win.UltraWinGrid.Activation.NoEdit;
ultraGridColumn2.Header.Caption = "脚本功能";
ultraGridColumn2.Header.VisiblePosition = 1;
ultraGridColumn2.Width = 173;
ultraGridColumn3.CellActivation = DS.Win.UltraWinGrid.Activation.NoEdit;
ultraGridColumn3.Header.Caption = "文件名";
ultraGridColumn3.Header.VisiblePosition = 2;
ultraGridColumn3.Width = 226;
ultraGridColumn4.CellActivation = DS.Win.UltraWinGrid.Activation.NoEdit;
ultraGridColumn4.Header.Caption = "创建/修改时间";
ultraGridColumn4.Header.VisiblePosition = 3;
ultraGridColumn4.Width = 234;
ultraGridColumn5.Header.Caption = "执行状态";
ultraGridColumn5.Header.VisiblePosition = 4;
ultraGridColumn5.Hidden = true;
ultraGridColumn5.Width = 112;
ultraGridBand1.Columns.AddRange(new object[] {
ultraGridColumn1,
ultraGridColumn2,
ultraGridColumn3,
ultraGridColumn4,
ultraGridColumn5});
this.dgInitializeInfo.DisplayLayout.BandsSerializer.Add(ultraGridBand1);
this.dgInitializeInfo.DisplayLayout.BorderStyle = DS.Win.UIElementBorderStyle.Solid;
this.dgInitializeInfo.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.dgInitializeInfo.DisplayLayout.GroupByBox.Appearance = appearance2;
appearance3.ForeColor = System.Drawing.SystemColors.GrayText;
this.dgInitializeInfo.DisplayLayout.GroupByBox.BandLabelAppearance = appearance3;
this.dgInitializeInfo.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.dgInitializeInfo.DisplayLayout.GroupByBox.PromptAppearance = appearance4;
this.dgInitializeInfo.DisplayLayout.MaxColScrollRegions = 1;
this.dgInitializeInfo.DisplayLayout.MaxRowScrollRegions = 1;
appearance5.BackColor = System.Drawing.SystemColors.Window;
appearance5.ForeColor = System.Drawing.SystemColors.ControlText;
this.dgInitializeInfo.DisplayLayout.Override.ActiveCellAppearance = appearance5;
appearance6.BackColor = System.Drawing.SystemColors.Highlight;
appearance6.ForeColor = System.Drawing.SystemColors.HighlightText;
this.dgInitializeInfo.DisplayLayout.Override.ActiveRowAppearance = appearance6;
this.dgInitializeInfo.DisplayLayout.Override.BorderStyleCell = DS.Win.UIElementBorderStyle.Dotted;
this.dgInitializeInfo.DisplayLayout.Override.BorderStyleRow = DS.Win.UIElementBorderStyle.Dotted;
appearance7.BackColor = System.Drawing.SystemColors.Window;
this.dgInitializeInfo.DisplayLayout.Override.CardAreaAppearance = appearance7;
appearance8.BorderColor = System.Drawing.Color.Silver;
appearance8.TextTrimming = DS.Win.TextTrimming.EllipsisCharacter;
this.dgInitializeInfo.DisplayLayout.Override.CellAppearance = appearance8;
this.dgInitializeInfo.DisplayLayout.Override.CellClickAction = DS.Win.UltraWinGrid.CellClickAction.EditAndSelectText;
this.dgInitializeInfo.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.dgInitializeInfo.DisplayLayout.Override.GroupByRowAppearance = appearance9;
appearance10.TextHAlign = DS.Win.HAlign.Left;
this.dgInitializeInfo.DisplayLayout.Override.HeaderAppearance = appearance10;
this.dgInitializeInfo.DisplayLayout.Override.HeaderClickAction = DS.Win.UltraWinGrid.HeaderClickAction.SortMulti;
this.dgInitializeInfo.DisplayLayout.Override.HeaderStyle = DS.Win.HeaderStyle.WindowsXPCommand;
appearance11.BackColor = System.Drawing.SystemColors.Window;
appearance11.BorderColor = System.Drawing.Color.Silver;
this.dgInitializeInfo.DisplayLayout.Override.RowAppearance = appearance11;
this.dgInitializeInfo.DisplayLayout.Override.RowSelectors = DS.Win.DefaultableBoolean.False;
appearance12.BackColor = System.Drawing.SystemColors.ControlLight;
this.dgInitializeInfo.DisplayLayout.Override.TemplateAddRowAppearance = appearance12;
this.dgInitializeInfo.DisplayLayout.ScrollBounds = DS.Win.UltraWinGrid.ScrollBounds.ScrollToFill;
this.dgInitializeInfo.DisplayLayout.ScrollStyle = DS.Win.UltraWinGrid.ScrollStyle.Immediate;
this.dgInitializeInfo.Dock = System.Windows.Forms.DockStyle.Fill;
this.dgInitializeInfo.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.dgInitializeInfo.Location = new System.Drawing.Point(0, 0);
this.dgInitializeInfo.Name = "dgInitializeInfo";
this.dgInitializeInfo.Size = new System.Drawing.Size(690, 188);
this.dgInitializeInfo.TabIndex = 1;
this.dgInitializeInfo.InitializeLayout += new DS.Win.UltraWinGrid.InitializeLayoutEventHandler(this.dgInitializeInfo_InitializeLayout);
//
// FrmInitData
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(696, 481);
this.Controls.Add(this.panel2);
this.Controls.Add(this.splitter1);
this.Controls.Add(this.panel1);
this.Name = "FrmInitData";
this.Text = "数据库初始化";
this.Load += new System.EventHandler(this.FrmInitData_Load);
this.panel1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
this.panel2.ResumeLayout(false);
this.groupBox1.ResumeLayout(false);
this.panel4.ResumeLayout(false);
this.panel5.ResumeLayout(false);
this.panel3.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.ultraDataSource1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dgInitializeInfo)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void brn_OpenFile_Click(object sender, System.EventArgs e)
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "SQL文件|*.sql";
string currAppPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase;;
currAppPath += ".\\Resources\\Script\\";
openFileDialog1.InitialDirectory = currAppPath;
if(openFileDialog1.ShowDialog() == DialogResult.OK)
{
string strLine = GlobalObject.Instance.LocalSession.ReadSQLScript(openFileDialog1.FileName);
DataTable dt = new DataTable();
dt.Columns.Add("filename");
dt.Columns.Add("length");
dt.Columns.Add("isinitialized");
DataRow dr = dt.NewRow();
dr["filename"] = openFileDialog1.FileName;
dr["length"] = strLine.Length.ToString();
dr["isinitialized"] = "NO";
dt.Rows.Add(dr);
this.dgInitializeInfo.DataSource = dt;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -