From 5572195c2d91b1145a3360f0e3651aa67ea425db Mon Sep 17 00:00:00 2001
From: lu <99954486@qq.com>
Date: 星期五, 21 三月 2025 17:13:22 +0800
Subject: [PATCH] 查询
---
DevApp/Gs.DevApp/UserControl/ShowFilter.cs | 169 ++++++++++++++++++++++++++++++++++++++++----------------
1 files changed, 121 insertions(+), 48 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/ShowFilter.cs b/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
index f33093a..d7a4886 100644
--- a/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
+++ b/DevApp/Gs.DevApp/UserControl/ShowFilter.cs
@@ -240,51 +240,55 @@
}
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);
- //}
+ if (string.IsNullOrEmpty(_fullName))
+ {
+ Gs.DevApp.ToolBox.MsgHelper.Warning("璇烽�夋嫨椤甸潰锛�");
+ return;
+ }
+ var _obj = new
+ {
+ formPath = _fullName,
+ list = new List<dynamic>(),
+ };
+ gvTable.CloseEditor();
+ gvTable.UpdateCurrentRow();
+ if (gvTable.DataRowCount <= 0)
+ {
+ MsgHelper.ShowError("鏄庣粏涓嶈兘涓虹┖锛岃閫夋嫨浣犵殑鏄庣粏锛�");
+ return;
+ }
+ for (var i = 0; i < gvTable.DataRowCount; i++)
+ {
+ var row = gvTable.GetDataRow(i);
+ if (row != null)
+ {
+ string _msl = row["tableOtherName"].ToString();
+ if (string.IsNullOrEmpty(_msl))
+ {
+ MsgHelper.ShowError("鍒悕涓嶈兘涓虹┖锛�");
+ return;
+ }
+ _obj.list.Add(new
+ {
+ tableName = (row["tableName"].ToString()),
+ tableOtherName = row["tableOtherName"].ToString(),
+ });
+ }
+ }
+ try
+ {
+ string strJson = UtilityHelper.HttpPost("", "Fm/EditQuery", JsonConvert.SerializeObject(_obj));
+ ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
+ ToolBox.MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
+ if (_rtn.rtnCode > 0)
+ {
+ getPageListQuery();
+ }
+ }
+ catch (Exception ex)
+ {
+ ToolBox.MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
+ }
}
private void getPageListQuery()
@@ -312,6 +316,14 @@
"Fm/GetQuery", JsonConvert.SerializeObject(_obj));
ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
JObject _job = JObject.Parse(strJson);
+ //璇诲墠閫夋嫨
+ JArray array00 = new JArray();
+ foreach (var a in _job["rtnData"]["list3"])
+ {
+ array00.Add(a);
+ }
+ DataTable dt00 = JsonConvert.DeserializeObject<DataTable>(array00.ToString());
+ this.repositoryItemSearchLookUpEdit1.DataSource = dt00;
////////////
JArray array = new JArray();
foreach (var a in _job["rtnData"]["list"])
@@ -319,9 +331,17 @@
array.Add(a);
}
DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
- gcTable.BindingContext = new BindingContext();
- gcTable.DataSource = dt;
- gcTable.ForceInitialize();
+ if (dt.Rows.Count > 0)
+ {
+ gcTable.BindingContext = new BindingContext();
+ gcTable.DataSource = dt;
+ gcTable.ForceInitialize();
+ gvTable.BestFitColumns();
+ }
+ else
+ {
+ Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcTable, gvTable);
+ }
////////////
JArray array2 = new JArray();
foreach (var a in _job["rtnData"]["list2"])
@@ -332,12 +352,65 @@
gcQuery.BindingContext = new BindingContext();
gcQuery.DataSource = dt2;
gcQuery.ForceInitialize();
+ gvQuery.BestFitColumns();
}
catch (Exception ex)
{
MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
}
}
+
+ private void repositoryItemSearchLookUpEdit1_EditValueChanged(object sender, EventArgs e)
+ {
+ SearchLookUpEdit LookupEdit = sender as SearchLookUpEdit;
+ DataRowView SelectedDataRow = (DataRowView)LookupEdit.GetSelectedDataRow();
+ gvTable.SetFocusedRowCellValue("tableName", SelectedDataRow["tableName"].ToString());
+ gvTable.SetFocusedRowCellValue("tableCap", SelectedDataRow["tableCap"].ToString());
+ gvTable.CloseEditor();
+ 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)
+ {
+ if (_rtn.rtnCode > 0) getPageListQuery();
+ }
+ MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
+ }
+ catch (Exception ex)
+ {
+ MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
+ }
+ }
+ }
+
#endregion
+
+
}
}
\ No newline at end of file
--
Gitblit v1.9.3