From df0fc2993b41f0cb617b90bedbcbd7e61002f52c Mon Sep 17 00:00:00 2001 From: lu <99954486@qq.com> Date: 星期日, 23 三月 2025 13:32:08 +0800 Subject: [PATCH] 查询 --- DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs | 82 ++++++++++++++++++++++++++++++++--------- 1 files changed, 64 insertions(+), 18 deletions(-) diff --git a/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs b/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs index f581373..f86fa0f 100644 --- a/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs +++ b/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs @@ -79,7 +79,10 @@ 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(); @@ -107,7 +110,8 @@ 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(); // @@ -446,8 +450,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 +469,7 @@ // // gridColumn5 // - this.gridColumn5.Caption = "鍒桰D(鏍囬)"; + this.gridColumn5.Caption = "鍒楄〃ID(鏍囬)"; this.gridColumn5.FieldName = "gvNameCap"; this.gridColumn5.MinWidth = 25; this.gridColumn5.Name = "gridColumn5"; @@ -476,8 +480,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 +493,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 +552,8 @@ 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"; @@ -566,7 +608,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); @@ -586,7 +629,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 +642,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 +655,9 @@ 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; } } \ No newline at end of file -- Gitblit v1.9.3