From 0a9e6a87e3361a54dc42f920c9f6f0f303da118c Mon Sep 17 00:00:00 2001
From: lu <99954486@qq.com>
Date: 星期四, 27 三月 2025 16:33:18 +0800
Subject: [PATCH] 查询条件
---
DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs | 13 ++++
DevApp/Gs.DevApp/UserControl/ShowFilter.cs | 110 +++++++++++++++++++++++-------------
2 files changed, 81 insertions(+), 42 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs b/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs
index c8e643c..219f32a 100644
--- a/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs
+++ b/DevApp/Gs.DevApp/UserControl/ShowFilter.Designer.cs
@@ -73,6 +73,7 @@
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();
@@ -326,7 +327,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;
@@ -435,6 +437,14 @@
this.repositoryItemButtonEdit2.Name = "repositoryItemButtonEdit2";
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
//
@@ -669,5 +679,6 @@
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;
}
}
\ No newline at end of file
diff --git a/DevApp/Gs.DevApp/UserControl/ShowFilter.cs b/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
index c541b5a..995270c 100644
--- a/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
+++ b/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
@@ -241,6 +241,12 @@
#region MyRegion
+
+ /// <summary>
+ /// 淇濆瓨缁戝畾鐨勮〃
+ /// </summary>
+ /// <param name="sender"></param>
+ /// <param name="e"></param>
private void BtnSqlTable_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(_fullName))
@@ -282,7 +288,7 @@
{
string strJson = UtilityHelper.HttpPost("", "Fm/EditQuery", JsonConvert.SerializeObject(_obj));
ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
- ToolBox.MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
+ ToolBox.MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnData.outMsg);
if (_rtn.rtnCode > 0)
{
getPageListQuery();
@@ -294,6 +300,56 @@
}
}
+
+ /// <summary>
+ /// 鍒犻櫎缁戝畾琛�
+ /// </summary>
+ /// <param name="sender"></param>
+ /// <param name="e"></param>
+ private void repositoryItemButtonEdit2_ButtonClick(object sender, ButtonPressedEventArgs e)
+ {
+ var rowhandle = gvTable.FocusedRowHandle;
+ if (rowhandle < 0)
+ return;
+ if (e.Button.Index == 0)
+ {
+ var dr = gvTable.GetDataRow(rowhandle);
+ var mxGuid = dr["guid"].ToString();
+ if (!MsgHelper.AskQuestion("浣犻�夋嫨浜�1鏉℃暟鎹紝纭畾鍒犻櫎鍚楋紵"))
+ return;
+ if (string.IsNullOrEmpty(mxGuid))
+ {
+ gvTable.DeleteRow(rowhandle);
+ return;
+ }
+ var _obj = new
+ {
+ guid = mxGuid,
+ };
+ try
+ {
+ var strJson = UtilityHelper.HttpPost("",
+ "Fm/DeleteQuery",
+ JsonConvert.SerializeObject(_obj));
+ var _rtn = UtilityHelper.ReturnToDynamic(strJson);
+ if (_rtn.rtnCode > 0)
+ {
+ // getPageListQuery();
+ }
+ MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
+ }
+ catch (Exception ex)
+ {
+ MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
+ }
+ }
+ }
+
+
+ /// <summary>
+ /// 璇诲彇缁戝畾
+ /// </summary>
+
private void getPageListQuery()
{
@@ -378,44 +434,13 @@
gvTable.PostEditor();
gvTable.UpdateCurrentRow();
}
- private void repositoryItemButtonEdit2_ButtonClick(object sender, ButtonPressedEventArgs e)
- {
- var rowhandle = gvTable.FocusedRowHandle;
- if (rowhandle < 0)
- return;
- if (e.Button.Index == 0)
- {
- var dr = gvTable.GetDataRow(rowhandle);
- var mxGuid = dr["guid"].ToString();
- if (!MsgHelper.AskQuestion("浣犻�夋嫨浜�1鏉℃暟鎹紝纭畾鍒犻櫎鍚楋紵"))
- return;
- if (string.IsNullOrEmpty(mxGuid))
- {
- gvTable.DeleteRow(rowhandle);
- return;
- }
- var _obj = new
- {
- guid = mxGuid,
- };
- try
- {
- var strJson = UtilityHelper.HttpPost("",
- "Fm/DeleteQuery",
- JsonConvert.SerializeObject(_obj));
- var _rtn = UtilityHelper.ReturnToDynamic(strJson);
- if (_rtn.rtnCode > 0)
- {
- // getPageListQuery();
- }
- MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
- }
- catch (Exception ex)
- {
- MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
- }
- }
- }
+
+ /// <summary>
+ /// 缂栬緫鍒楁煡璇�
+ /// </summary>
+ /// <param name="sender"></param>
+ /// <param name="e"></param>
+
private void repositoryItemComboBox3Sql_EditValueChanged(object sender, EventArgs e)
{
ComboBoxEdit comboBox = sender as ComboBoxEdit;
@@ -452,6 +477,11 @@
}
}
}
+ /// <summary>
+ /// 缂栬緫鍒楁煡璇�
+ /// </summary>
+ /// <param name="sender"></param>
+ /// <param name="e"></param>
private void repositoryItemSearchLookUpEdit2Sql_EditValueChanged(object sender, EventArgs e)
{
string _txt = "";
@@ -491,8 +521,6 @@
MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
}
}
-
-
}
#endregion
--
Gitblit v1.9.3