查询

lu

2025-03-21 1b23b7f2e874036accaf5a565852ce1e01589281

 DevApp/Gs.DevApp/UserControl/ShowFilter.cs

@@ -1,8 +1,11 @@
using 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)