From 719a47b4aff725d4224b85e2b2079983cb31cf89 Mon Sep 17 00:00:00 2001
From: lg <123456>
Date: 星期二, 23 十二月 2025 13:28:36 +0800
Subject: [PATCH] 增加临时查询方案
---
DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs | 157 ++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 122 insertions(+), 35 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs b/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs
index f581373..51bcaa6 100644
--- a/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs
+++ b/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs
@@ -29,6 +29,7 @@
/// </summary>
private void InitializeComponent()
{
+ DevExpress.XtraGrid.GridLevelNode gridLevelNode1 = new DevExpress.XtraGrid.GridLevelNode();
DevExpress.XtraEditors.Controls.EditorButtonImageOptions editorButtonImageOptions1 = new DevExpress.XtraEditors.Controls.EditorButtonImageOptions();
DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject1 = new DevExpress.Utils.SerializableAppearanceObject();
DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject2 = new DevExpress.Utils.SerializableAppearanceObject();
@@ -44,8 +45,8 @@
DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject10 = new DevExpress.Utils.SerializableAppearanceObject();
DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject11 = new DevExpress.Utils.SerializableAppearanceObject();
DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject12 = new DevExpress.Utils.SerializableAppearanceObject();
+ System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ShowFilter));
this.panel1 = new System.Windows.Forms.Panel();
- this.btnEsc = new DevExpress.XtraEditors.SimpleButton();
this.btnQuery = new DevExpress.XtraEditors.SimpleButton();
this.xtraTabControl1 = new DevExpress.XtraTab.XtraTabControl();
this.xtraTabPage1 = new DevExpress.XtraTab.XtraTabPage();
@@ -73,16 +74,22 @@
this.gridColumn12 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn14 = new DevExpress.XtraGrid.Columns.GridColumn();
this.repositoryItemButtonEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit();
+ this.gridColumn19 = new DevExpress.XtraGrid.Columns.GridColumn();
this.panQueryTable = new System.Windows.Forms.Panel();
this.btnSqlTable = new DevExpress.XtraEditors.SimpleButton();
this.gcQuery = new DevExpress.XtraGrid.GridControl();
this.gvQuery = new DevExpress.XtraGrid.Views.Grid.GridView();
this.gridColumn5 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn7 = new DevExpress.XtraGrid.Columns.GridColumn();
- this.repositoryItemComboBoxSql = new DevExpress.XtraEditors.Repository.RepositoryItemComboBox();
+ this.repositoryItemSearchLookUpEdit2Sql = new DevExpress.XtraEditors.Repository.RepositoryItemSearchLookUpEdit();
+ this.repositoryItemSearchLookUpEdit2View = new DevExpress.XtraGrid.Views.Grid.GridView();
+ this.gridColumn17 = new DevExpress.XtraGrid.Columns.GridColumn();
+ this.gridColumn18 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn6 = new DevExpress.XtraGrid.Columns.GridColumn();
this.repositoryItemComboBox3Sql = new DevExpress.XtraEditors.Repository.RepositoryItemComboBox();
this.gridColumn9 = new DevExpress.XtraGrid.Columns.GridColumn();
+ this.btnFa = new DevExpress.XtraEditors.SimpleButton();
+ this.btnEsc = new DevExpress.XtraEditors.SimpleButton();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.xtraTabControl1)).BeginInit();
this.xtraTabControl1.SuspendLayout();
@@ -107,34 +114,33 @@
this.panQueryTable.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.gcQuery)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gvQuery)).BeginInit();
- ((System.ComponentModel.ISupportInitialize)(this.repositoryItemComboBoxSql)).BeginInit();
+ ((System.ComponentModel.ISupportInitialize)(this.repositoryItemSearchLookUpEdit2Sql)).BeginInit();
+ ((System.ComponentModel.ISupportInitialize)(this.repositoryItemSearchLookUpEdit2View)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemComboBox3Sql)).BeginInit();
this.SuspendLayout();
//
// panel1
//
this.panel1.Controls.Add(this.btnEsc);
+ this.panel1.Controls.Add(this.btnFa);
this.panel1.Controls.Add(this.btnQuery);
this.panel1.Dock = System.Windows.Forms.DockStyle.Bottom;
- this.panel1.Location = new System.Drawing.Point(0, 517);
+ this.panel1.Location = new System.Drawing.Point(0, 529);
this.panel1.Name = "panel1";
- this.panel1.Size = new System.Drawing.Size(734, 56);
+ this.panel1.Size = new System.Drawing.Size(734, 44);
this.panel1.TabIndex = 1;
- //
- // btnEsc
- //
- this.btnEsc.Location = new System.Drawing.Point(391, 15);
- this.btnEsc.Name = "btnEsc";
- this.btnEsc.Size = new System.Drawing.Size(94, 29);
- this.btnEsc.TabIndex = 1;
- this.btnEsc.Text = "鍙栨秷";
//
// btnQuery
//
- this.btnQuery.Location = new System.Drawing.Point(270, 15);
+ this.btnQuery.Appearance.BackColor = DevExpress.LookAndFeel.DXSkinColors.FillColors.Primary;
+ this.btnQuery.Appearance.Options.UseBackColor = true;
+ this.btnQuery.Appearance.Options.UseFont = true;
+ this.btnQuery.Dock = System.Windows.Forms.DockStyle.Right;
+ this.btnQuery.ImageOptions.Image = global::Gs.DevApp.Properties.Resources.zoom100_16x16;
+ this.btnQuery.Location = new System.Drawing.Point(640, 0);
this.btnQuery.Name = "btnQuery";
- this.btnQuery.Size = new System.Drawing.Size(94, 29);
- this.btnQuery.TabIndex = 0;
+ this.btnQuery.Size = new System.Drawing.Size(94, 44);
+ this.btnQuery.TabIndex = 3;
this.btnQuery.Text = "纭畾鏌ヨ";
//
// xtraTabControl1
@@ -160,6 +166,9 @@
// gcMain
//
this.gcMain.Dock = System.Windows.Forms.DockStyle.Fill;
+ gridLevelNode1.RelationName = "Level1";
+ this.gcMain.LevelTree.Nodes.AddRange(new DevExpress.XtraGrid.GridLevelNode[] {
+ gridLevelNode1});
this.gcMain.Location = new System.Drawing.Point(0, 0);
this.gcMain.MainView = this.gridView1;
this.gcMain.Name = "gcMain";
@@ -167,7 +176,7 @@
this.repositoryItemComboBox1,
this.repositoryItemComboBox2,
this.repositoryItemButtonEdit1});
- this.gcMain.Size = new System.Drawing.Size(734, 517);
+ this.gcMain.Size = new System.Drawing.Size(734, 529);
this.gcMain.TabIndex = 0;
this.gcMain.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
this.gridView1});
@@ -312,7 +321,8 @@
this.gridColumn13,
this.gridColumn11,
this.gridColumn12,
- this.gridColumn14});
+ this.gridColumn14,
+ this.gridColumn19});
this.gvTable.GridControl = this.gcTable;
this.gvTable.Name = "gvTable";
this.gvTable.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom;
@@ -391,6 +401,8 @@
//
// gridColumn12
//
+ this.gridColumn12.AppearanceCell.ForeColor = System.Drawing.Color.Blue;
+ this.gridColumn12.AppearanceCell.Options.UseForeColor = true;
this.gridColumn12.AppearanceHeader.ForeColor = System.Drawing.Color.Blue;
this.gridColumn12.AppearanceHeader.Options.UseForeColor = true;
this.gridColumn12.Caption = "鍒悕";
@@ -422,6 +434,14 @@
this.repositoryItemButtonEdit2.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
this.repositoryItemButtonEdit2.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.repositoryItemButtonEdit2_ButtonClick);
//
+ // gridColumn19
+ //
+ this.gridColumn19.Caption = "涓婚敭Guid";
+ this.gridColumn19.FieldName = "guid";
+ this.gridColumn19.MinWidth = 25;
+ this.gridColumn19.Name = "gridColumn19";
+ this.gridColumn19.Width = 94;
+ //
// panQueryTable
//
this.panQueryTable.Controls.Add(this.btnSqlTable);
@@ -446,8 +466,8 @@
this.gcQuery.MainView = this.gvQuery;
this.gcQuery.Name = "gcQuery";
this.gcQuery.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
- this.repositoryItemComboBoxSql,
- this.repositoryItemComboBox3Sql});
+ this.repositoryItemComboBox3Sql,
+ this.repositoryItemSearchLookUpEdit2Sql});
this.gcQuery.Size = new System.Drawing.Size(734, 331);
this.gcQuery.TabIndex = 3;
this.gcQuery.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
@@ -465,7 +485,7 @@
//
// gridColumn5
//
- this.gridColumn5.Caption = "鍒桰D(鏍囬)";
+ this.gridColumn5.Caption = "鍒楄〃ID(鏍囬)";
this.gridColumn5.FieldName = "gvNameCap";
this.gridColumn5.MinWidth = 25;
this.gridColumn5.Name = "gridColumn5";
@@ -476,8 +496,12 @@
//
// gridColumn7
//
- this.gridColumn7.Caption = "瀵瑰簲瀛楁";
- this.gridColumn7.ColumnEdit = this.repositoryItemComboBoxSql;
+ this.gridColumn7.AppearanceCell.ForeColor = System.Drawing.Color.Blue;
+ this.gridColumn7.AppearanceCell.Options.UseForeColor = true;
+ this.gridColumn7.AppearanceHeader.ForeColor = System.Drawing.Color.Blue;
+ this.gridColumn7.AppearanceHeader.Options.UseForeColor = true;
+ this.gridColumn7.Caption = "瀵瑰簲鏁版嵁搴撳瓧娈�";
+ this.gridColumn7.ColumnEdit = this.repositoryItemSearchLookUpEdit2Sql;
this.gridColumn7.FieldName = "sqlField";
this.gridColumn7.MinWidth = 25;
this.gridColumn7.Name = "gridColumn7";
@@ -485,18 +509,51 @@
this.gridColumn7.VisibleIndex = 1;
this.gridColumn7.Width = 94;
//
- // repositoryItemComboBoxSql
+ // repositoryItemSearchLookUpEdit2Sql
//
- this.repositoryItemComboBoxSql.AutoHeight = false;
- this.repositoryItemComboBoxSql.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
+ this.repositoryItemSearchLookUpEdit2Sql.AutoHeight = false;
+ this.repositoryItemSearchLookUpEdit2Sql.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
- this.repositoryItemComboBoxSql.Name = "repositoryItemComboBoxSql";
- this.repositoryItemComboBoxSql.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
- this.repositoryItemComboBoxSql.EditValueChanged += new System.EventHandler(this.repositoryItemComboBoxSql_EditValueChanged);
+ this.repositoryItemSearchLookUpEdit2Sql.DisplayMember = "tableOtherName";
+ this.repositoryItemSearchLookUpEdit2Sql.Name = "repositoryItemSearchLookUpEdit2Sql";
+ this.repositoryItemSearchLookUpEdit2Sql.NullText = "璇烽�夋嫨";
+ this.repositoryItemSearchLookUpEdit2Sql.PopupView = this.repositoryItemSearchLookUpEdit2View;
+ this.repositoryItemSearchLookUpEdit2Sql.ValueMember = "tableOtherName";
+ this.repositoryItemSearchLookUpEdit2Sql.EditValueChanged += new System.EventHandler(this.repositoryItemSearchLookUpEdit2Sql_EditValueChanged);
+ //
+ // repositoryItemSearchLookUpEdit2View
+ //
+ this.repositoryItemSearchLookUpEdit2View.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
+ this.gridColumn17,
+ this.gridColumn18});
+ this.repositoryItemSearchLookUpEdit2View.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
+ this.repositoryItemSearchLookUpEdit2View.Name = "repositoryItemSearchLookUpEdit2View";
+ this.repositoryItemSearchLookUpEdit2View.OptionsSelection.EnableAppearanceFocusedCell = false;
+ this.repositoryItemSearchLookUpEdit2View.OptionsView.ShowGroupPanel = false;
+ //
+ // gridColumn17
+ //
+ this.gridColumn17.Caption = "瀛楁鍚嶇О";
+ this.gridColumn17.FieldName = "tableOtherName";
+ this.gridColumn17.Name = "gridColumn17";
+ this.gridColumn17.Visible = true;
+ this.gridColumn17.VisibleIndex = 0;
+ //
+ // gridColumn18
+ //
+ this.gridColumn18.Caption = "瀛楁澶囨敞";
+ this.gridColumn18.FieldName = "remark";
+ this.gridColumn18.Name = "gridColumn18";
+ this.gridColumn18.Visible = true;
+ this.gridColumn18.VisibleIndex = 1;
//
// gridColumn6
//
- this.gridColumn6.Caption = "瀛楁绫诲瀷";
+ this.gridColumn6.AppearanceCell.ForeColor = System.Drawing.Color.Blue;
+ this.gridColumn6.AppearanceCell.Options.UseForeColor = true;
+ this.gridColumn6.AppearanceHeader.ForeColor = System.Drawing.Color.Blue;
+ this.gridColumn6.AppearanceHeader.Options.UseForeColor = true;
+ this.gridColumn6.Caption = "鏁版嵁搴撳瓧娈电被鍨�";
this.gridColumn6.ColumnEdit = this.repositoryItemComboBox3Sql;
this.gridColumn6.FieldName = "sqlFieldType";
this.gridColumn6.MinWidth = 25;
@@ -511,7 +568,9 @@
this.repositoryItemComboBox3Sql.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemComboBox3Sql.Items.AddRange(new object[] {
- "",
+ "-璇烽�夋嫨-",
+ "瀛楃涓茬被鍨�",
+ "鏁板�肩被鍨�",
"鏃堕棿绫诲瀷",
"Bit绫诲瀷"});
this.repositoryItemComboBox3Sql.Name = "repositoryItemComboBox3Sql";
@@ -528,6 +587,28 @@
this.gridColumn9.Visible = true;
this.gridColumn9.VisibleIndex = 3;
this.gridColumn9.Width = 94;
+ //
+ // btnFa
+ //
+ this.btnFa.Appearance.Options.UseFont = true;
+ this.btnFa.Dock = System.Windows.Forms.DockStyle.Right;
+ this.btnFa.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnFa.ImageOptions.Image")));
+ this.btnFa.Location = new System.Drawing.Point(459, 0);
+ this.btnFa.Name = "btnFa";
+ this.btnFa.Size = new System.Drawing.Size(181, 44);
+ this.btnFa.TabIndex = 1;
+ this.btnFa.Text = "淇濆瓨涓轰复鏃舵煡璇㈡柟妗�";
+ //
+ // btnEsc
+ //
+ this.btnEsc.Appearance.Options.UseFont = true;
+ this.btnEsc.Dock = System.Windows.Forms.DockStyle.Right;
+ this.btnEsc.ImageOptions.Image = global::Gs.DevApp.Properties.Resources.removegroupfooter_16x16;
+ this.btnEsc.Location = new System.Drawing.Point(365, 0);
+ this.btnEsc.Name = "btnEsc";
+ this.btnEsc.Size = new System.Drawing.Size(94, 44);
+ this.btnEsc.TabIndex = 4;
+ this.btnEsc.Text = "鍙栨秷鍏抽棴";
//
// ShowFilter
//
@@ -566,7 +647,8 @@
this.panQueryTable.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.gcQuery)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gvQuery)).EndInit();
- ((System.ComponentModel.ISupportInitialize)(this.repositoryItemComboBoxSql)).EndInit();
+ ((System.ComponentModel.ISupportInitialize)(this.repositoryItemSearchLookUpEdit2Sql)).EndInit();
+ ((System.ComponentModel.ISupportInitialize)(this.repositoryItemSearchLookUpEdit2View)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemComboBox3Sql)).EndInit();
this.ResumeLayout(false);
@@ -574,7 +656,6 @@
#endregion
private System.Windows.Forms.Panel panel1;
- private DevExpress.XtraEditors.SimpleButton btnEsc;
private DevExpress.XtraEditors.SimpleButton btnQuery;
private DevExpress.XtraTab.XtraTabControl xtraTabControl1;
private DevExpress.XtraTab.XtraTabPage xtraTabPage1;
@@ -586,7 +667,7 @@
private DevExpress.XtraGrid.GridControl gcMain;
private DevExpress.XtraEditors.Repository.RepositoryItemComboBox repositoryItemComboBox1;
private DevExpress.XtraEditors.Repository.RepositoryItemComboBox repositoryItemComboBox2;
-
+
private DevExpress.XtraTab.XtraTabPage xtraTabPage3;
private DevExpress.XtraEditors.SplitContainerControl splitContainerControl1;
private DevExpress.XtraGrid.GridControl gcTable;
@@ -599,7 +680,6 @@
private DevExpress.XtraGrid.Views.Grid.GridView gvQuery;
private DevExpress.XtraGrid.Columns.GridColumn gridColumn5;
private DevExpress.XtraGrid.Columns.GridColumn gridColumn7;
- private DevExpress.XtraEditors.Repository.RepositoryItemComboBox repositoryItemComboBoxSql;
private DevExpress.XtraGrid.Columns.GridColumn gridColumn9;
private DevExpress.XtraGrid.Columns.GridColumn gridColumn12;
private DevExpress.XtraGrid.Columns.GridColumn gridColumn13;
@@ -613,5 +693,12 @@
private DevExpress.XtraGrid.Columns.GridColumn gridColumn6;
private DevExpress.XtraEditors.Repository.RepositoryItemComboBox repositoryItemComboBox3Sql;
private DevExpress.XtraGrid.Columns.GridColumn gridColumn8;
+ private DevExpress.XtraEditors.Repository.RepositoryItemSearchLookUpEdit repositoryItemSearchLookUpEdit2Sql;
+ private DevExpress.XtraGrid.Views.Grid.GridView repositoryItemSearchLookUpEdit2View;
+ private DevExpress.XtraGrid.Columns.GridColumn gridColumn17;
+ private DevExpress.XtraGrid.Columns.GridColumn gridColumn18;
+ private DevExpress.XtraGrid.Columns.GridColumn gridColumn19;
+ private DevExpress.XtraEditors.SimpleButton btnFa;
+ private DevExpress.XtraEditors.SimpleButton btnEsc;
}
}
\ No newline at end of file
--
Gitblit v1.9.3