From 3f08b93ffba05c8a12d6a013303e372442854f5f Mon Sep 17 00:00:00 2001
From: lu <123456>
Date: 星期一, 22 九月 2025 11:24:40 +0800
Subject: [PATCH] 增加推送报表
---
DevApp/Gs.DevApp/UserControl/SelectMesCgthSqLink.cs | 85 +++++++++++++++++++++++++++++++++---------
1 files changed, 67 insertions(+), 18 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/SelectMesCgthSqLink.cs b/DevApp/Gs.DevApp/UserControl/SelectMesCgthSqLink.cs
index d3d0383..b3d8c90 100644
--- a/DevApp/Gs.DevApp/UserControl/SelectMesCgthSqLink.cs
+++ b/DevApp/Gs.DevApp/UserControl/SelectMesCgthSqLink.cs
@@ -4,12 +4,15 @@
using System;
using System.Collections.Generic;
using System.Data;
+using System.Threading.Tasks;
+using System.Web.UI.WebControls;
using System.Windows.Forms;
namespace Gs.DevApp.UserControl
{
public partial class SelectMesCgthSqLink : DevExpress.XtraEditors.XtraForm
{
+ private List<FilterEntity> _filterList = new List<FilterEntity>();
public readonly string _webServiceName = "MesItemsManager/";
public string orgId = "";
/// <summary>
@@ -22,34 +25,48 @@
{
InitializeComponent();
this.orgId = _orgId;
- Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, null, null, null, "", null, null, false);
+ this.pageBar1.setBar(false);
+ pageBar1.PagerEvent += PageBar1_PagerEvent;
+ Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1);
getPageList(1);
}
-
-
- /// <summary>
- /// 閫夋嫨鍚庣殑鍥炶皟浜嬩欢
- /// </summary>
- public event EventHandler<UpdateParentEventArgs> UpdateParent;
-
- /// <summary>
- /// </summary>
- /// <param name="curPage">绗嚑椤�</param>
- /// <param name="pageSize">姣忛〉鍑犳潯</param>
+ #region 婧愮墿鏂欐暟鎹粦瀹�
+ private void GridView1_ColumnFilterChanged(object sender, EventArgs e)
+ {
+ _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1);
+ Task.Delay(100);
+ getPageList(1);
+ } /// <summary>
+ /// 鍒嗛〉浜嬩欢
+ /// </summary>
+ /// <param name="curPage"></param>
+ /// <param name="pageSize"></param>
+ private void PageBar1_PagerEvent(int curPage, int pageSize)
+ {
+ getPageList(curPage);
+ } /// <summary>
+ /// </summary>
+ /// <param name="curPage">绗嚑椤�</param>
+ /// <param name="pageSize">姣忛〉鍑犳潯</param>
private void getPageList(int curPage)
{
- var _sbSqlWhere = " and a.FSubsidiary=" + orgId;
- var pgq = new PageQueryModel(curPage, 999999, "org.FNumber asc ,a.staff_no", "asc", "", _sbSqlWhere.ToString());
+ gcMain.DataSource = null;
+ System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
+ _sbSqlWhere.Append(" and a.FSubsidiary=" + orgId);
+ _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
+ var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "org.FNumber asc", "asc", "", _sbSqlWhere.ToString());
var json = JsonConvert.SerializeObject(pgq);
try
{
var strReturn = UtilityHelper.HttpPost("",
- _webServiceName + "GetListPage2", json);
+ _webServiceName + "GetListSelect", json);
var dd = UtilityHelper.ReturnToTablePage(strReturn);
if (dd.rtnCode > 0)
{
+
DataTable dt = dd.rtnData.list;
gcMain.BindingContext = new BindingContext();
+ gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
if (dt.Rows.Count > 0)
{
gcMain.DataSource = dt;
@@ -58,6 +75,10 @@
}
else
UtilityHelper.SetDefaultTable(gcMain, gridView1);
+ gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
+ pageBar1.TotalPages = dd.rtnData.pages;//鎬婚〉
+ pageBar1.CurrentPage = curPage;//褰撳墠椤�
+ pageBar1.RecordCount = dd.rtnData.total;//鎬昏褰曟暟
}
else
{
@@ -69,6 +90,16 @@
MsgHelper.ShowError("鎻愮ず锛�" + ex.Message);
}
}
+ #endregion
+
+
+
+ /// <summary>
+ /// 閫夋嫨鍚庣殑鍥炶皟浜嬩欢
+ /// </summary>
+ public event EventHandler<UpdateParentEventArgs> UpdateParent;
+
+
/// <summary>
/// 閫夋嫨鐗╂枡
/// </summary>
@@ -82,7 +113,7 @@
if (e.Button.Index == 0)
{
var dr = gridView1.GetDataRow(rowhandle);
- var itemId = dr["itemId"].ToString();
+ var itemId = dr["id"].ToString();
if (string.IsNullOrEmpty(itemId))
{
return;
@@ -90,10 +121,28 @@
var list = new List<dynamic>();
list.Add(new
{
- itemId = itemId,
+ id = "",
+ mid = "",
+ rkmxGuid = "",//鍏ュ簱鏄庣粏琛╣uid
+ cgdh = "",//閲囪喘鍗曞彿
+ invWorkLine = "",//琛屽彿,
+ wlbm = dr["itemNo"].ToString(), //鐗╂枡缂栧彿,
+ wlmc = dr["itemName"].ToString(), //鐗╂枡鍚嶇О,
+ wlgg = dr["itemModel"].ToString(),//瑙勬牸鍨嬪彿,
+ rksl = "", //鍏ュ簱鏁伴噺,
+ dwName = dr["dwName"].ToString(),
+ eid = "",
+ erpid = "",
+ itemId = dr["id"].ToString(), //鐗╂枡id,
+ ysNum = "0",//宸叉壂鏁伴噺
+ remark = "",
+ orderNo = "0", //搴忓彿
+ kcQty = dr["kcQty"].ToString(),//搴撳瓨鏁伴噺
+ depotId = dr["depotId"].ToString(),//
+ depotName = dr["depotName"].ToString(),//
});
UpdateParent?.Invoke(this, new UpdateParentEventArgs { DynamicList = list });
- Close();
+ // Close();
}
}
}
--
Gitblit v1.9.3