From 1b23b7f2e874036accaf5a565852ce1e01589281 Mon Sep 17 00:00:00 2001
From: lu <99954486@qq.com>
Date: 星期五, 21 三月 2025 15:32:49 +0800
Subject: [PATCH] 查询
---
DevApp/Gs.DevApp/UserControl/ShowFilter.cs | 109 ++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 93 insertions(+), 16 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/ShowFilter.cs b/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
index c36f003..f33093a 100644
--- a/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
+++ b/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
@@ -1,8 +1,11 @@
锘縰sing System;
using System.Collections.Generic;
using System.Data;
+using System.Data.SqlTypes;
using System.Text;
using System.Windows.Forms;
+using DevExpress.Pdf.Native.BouncyCastle.Utilities.Collections;
+using DevExpress.PivotGrid.OLAP.Mdx;
using DevExpress.Utils.DirectXPaint;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
@@ -10,8 +13,10 @@
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Base.ViewInfo;
using FastReport.MSChart;
+using Gs.DevApp.Entity;
using Gs.DevApp.ToolBox;
using Newtonsoft.Json;
+using Newtonsoft.Json.Linq;
namespace Gs.DevApp.UserControl
{
@@ -47,12 +52,17 @@
gridView1.OptionsFind.ShowSearchNavButtons = false;
// this.gridView1.OptionsView.ShowAutoFilterRow = true;
gridView1.OptionsView.ShowGroupPanel = false;
+ gvQuery.OptionsView.ShowGroupPanel = false;
+ gvTable.OptionsView.ShowGroupPanel = false;
btnEsc.Click += BtnEsc_Click;
btnQuery.Click += BtnQuery_Click;
getPageList();
//涓嬮潰涓烘煡璇㈤厤缃�
+ this.btnSqlTable.Click += BtnSqlTable_Click;
getPageListQuery();
}
+
+
/// <summary>
/// 鏌ヨ闆嗗悎
@@ -218,18 +228,67 @@
#region MyRegion
+ /// <summary>
+ /// 鎴彇琛ㄥ悕
+ /// </summary>
+ /// <param name="strName"></param>
+ /// <returns></returns>
+ private string _getTableName(string strName)
+ {
+ var _tableName = strName.Split('(')[0];
+ return _tableName;
+ }
+ private void BtnSqlTable_Click(object sender, EventArgs e)
+ {
+ //System.Text.StringBuilder sb = new System.Text.StringBuilder();
+ //var list = txt_table.Properties.Items.GetCheckedValues();
+ //foreach (var obj in list)
+ //{
+ // if (sb.Length > 0)
+ // sb.Append(",");
+ // sb.Append(_getTableName(obj.ToString()));
+
+ //}
+
+ //if (sb.Length < 0)
+ //{
+ // Gs.DevApp.ToolBox.MsgHelper.Warning("璇烽�夋嫨鍏宠仈琛紒");
+ // txt_table.Focus();
+ // return;
+ //}
+
+ //var _obj = new
+ //{
+ // guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //涓诲缓
+ // djlx = djlx,//鍗曟嵁绫诲瀷
+ // salesId = _sqGuid,//閿�鍞崟鍙�
+ // inRemark = FNote.Trim(),//澶囨敞
+ // list = new List<dynamic>(),
+ //};
+ //try
+ //{
+ // string strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModel", JsonConvert.SerializeObject(_obj));
+ // ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
+ // ToolBox.MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
+ // if (_rtn.rtnCode > 0)
+ // {
+ // lbGuid.Text = _rtn.rtnData.outGuid;
+ // txt_billNo.Text = _rtn.rtnData.outNo;
+ // toolBarMenu1.isSetBtn = true;
+ // List<DevExpress.XtraGrid.Views.Grid.GridView> gvList = new List<DevExpress.XtraGrid.Views.Grid.GridView>();
+ // gvList.Add(gvMx1);
+ // UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false, gvList);
+ // toolBarMenu1.currentAction = "";
+ // }
+ //}
+ //catch (Exception ex)
+ //{
+ // ToolBox.MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
+ //}
+
+ }
private void getPageListQuery()
{
- //foreach (GridColumn col in _columns)
- // if (col.Tag != null && col.Tag.ToString().StartsWith("query"))
- // {
- // var item = new CboItemEntity();
- // item.Text = col.Tag.ToString().Replace("query_", "") +
- // "锛�" + col.Caption + "锛�";
- // //item.Value = col.FieldName;
- // item.Value = col.Tag.ToString().Replace("query_", "");
- // repositoryItemComboBox1.Items.Add(item);
- // }
repositoryItemComboBoxSql.Items.Clear();
repositoryItemComboBoxSql.Items.Add("1");
repositoryItemComboBoxSql.Items.Add("1");
@@ -241,19 +300,37 @@
};
foreach (GridColumn col in _columns)
{
- _obj.list.Add(new {
- colName= col.Name.ToString(),
- colCap=col.Caption
+ _obj.list.Add(new
+ {
+ colName = col.Name.ToString(),
+ colCap = col.Caption
});
}
try
{
var strJson = UtilityHelper.HttpPost("",
"Fm/GetQuery", JsonConvert.SerializeObject(_obj));
- var dt = UtilityHelper.ReturnToList(strJson);
- DataTable _newTable = dt.rtnData;
+ ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
+ JObject _job = JObject.Parse(strJson);
+ ////////////
+ JArray array = new JArray();
+ foreach (var a in _job["rtnData"]["list"])
+ {
+ array.Add(a);
+ }
+ DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
+ gcTable.BindingContext = new BindingContext();
+ gcTable.DataSource = dt;
+ gcTable.ForceInitialize();
+ ////////////
+ JArray array2 = new JArray();
+ foreach (var a in _job["rtnData"]["list2"])
+ {
+ array2.Add(a);
+ }
+ DataTable dt2 = JsonConvert.DeserializeObject<DataTable>(array2.ToString());
gcQuery.BindingContext = new BindingContext();
- gcQuery.DataSource = _newTable;
+ gcQuery.DataSource = dt2;
gcQuery.ForceInitialize();
}
catch (Exception ex)
--
Gitblit v1.9.3