增加推送报表

lu

2025-09-22 3f08b93ffba05c8a12d6a013303e372442854f5f

 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 = "",//入库明细表guid
                    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();
            }
        }
    }