From 3f08b93ffba05c8a12d6a013303e372442854f5f Mon Sep 17 00:00:00 2001
From: lu <123456>
Date: 星期一, 22 九月 2025 11:24:40 +0800
Subject: [PATCH] 增加推送报表
---
DevApp/Gs.DevApp/DevFrm/Work/Frm_WorkTechniqueShow.cs | 42 +++++++++++++++++++++++-------------------
1 files changed, 23 insertions(+), 19 deletions(-)
diff --git a/DevApp/Gs.DevApp/DevFrm/Work/Frm_WorkTechniqueShow.cs b/DevApp/Gs.DevApp/DevFrm/Work/Frm_WorkTechniqueShow.cs
index 18a21eb..74fba48 100644
--- a/DevApp/Gs.DevApp/DevFrm/Work/Frm_WorkTechniqueShow.cs
+++ b/DevApp/Gs.DevApp/DevFrm/Work/Frm_WorkTechniqueShow.cs
@@ -1,5 +1,4 @@
-锘縰sing DevExpress.XtraGrid.Views.Grid;
-using Gs.DevApp.Entity;
+锘縰sing Gs.DevApp.Entity;
using Gs.DevApp.ToolBox;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
@@ -14,14 +13,14 @@
public partial class Frm_WorkTechniqueShow : DevExpress.XtraEditors.XtraForm
{
private List<FilterEntity> _filterList = new List<FilterEntity>();
- private readonly string _webServiceName = "MesQmCheckitemManager/";
+ private readonly string _webServiceName = "WorkTechnique/";
private string sourceGuid = "";//婧恎uid
/// <summary>
///
/// </summary>
/// <param name="_sourceGuid"></param>
/// <param name="_strType"></param>
- public Frm_WorkTechniqueShow(string _sourceGuid, string _strType)
+ public Frm_WorkTechniqueShow(string _sourceGuid)
{
InitializeComponent();
sourceGuid = _sourceGuid;
@@ -149,10 +148,13 @@
/// <param name="pageSize">姣忛〉鍑犳潯</param>
private void getPageList(int curPage)
{
- gcMain.DataSource = null;
- var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
- //_sbSqlWhere += " and q.guid is null";
- var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "item_no", "asc", "", _sbSqlWhere.ToString());
+ gcMain.DataSource = null;
+ System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
+ _sbSqlWhere.Append(" and org.fid in");
+ _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
+ _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
+ // var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "item_no", "asc", "", _sbSqlWhere.ToString(), "workTechnique");
+ var pgq = new PageQueryModel(curPage, 5000, "item_no", "asc", "", _sbSqlWhere.ToString(), "workTechnique");
var json = JsonConvert.SerializeObject(pgq);
try
{
@@ -198,19 +200,22 @@
try
{
var strJson = UtilityHelper.HttpPost("",
- _webServiceName + "GetModel",
+ _webServiceName + "GetModel",
JsonConvert.SerializeObject(_obj));
- var _rtn =
- UtilityHelper.ReturnToDynamic(strJson);
+ var _rtn = UtilityHelper.ReturnToDynamic(strJson);
if (_rtn.rtnCode > 0)
{
- var dy = _rtn.rtnData;
- var gvList = new List<GridView>();
+ dynamic dy = _rtn.rtnData;
+ List<DevExpress.XtraGrid.Views.Grid.GridView> gvList = new List<DevExpress.XtraGrid.Views.Grid.GridView>();
gvList.Add(gvMx1);
- var _job = JObject.Parse(strJson);
- var array = new JArray();
- foreach (var a in _job["rtnData"]["list"]) array.Add(a);
- var dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
+ UtilityHelper.SetValueByObj(this.layoutMx1.Controls, dy, false, gvList);
+ 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());
if (dt.Rows.Count > 0)
{
gcMx1.BindingContext = new BindingContext();
@@ -220,9 +225,8 @@
}
else
{
- UtilityHelper.SetDefaultTable(gcMx1, gvMx1);
+ Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx1, gvMx1);
}
- UtilityHelper.SetDefaultTable(gcMainCopy, gvMainCopy);
}
else
{
--
Gitblit v1.9.3