报表优化

duheng

2025-02-19 bb7165071ee890cfac760dbb15cd921e6f6e3096

 WinFrmUI/Yw.WinFrmUI.Hydro.Core/06-visual/01-reservoir/HydroReservoirListCtrl.cs

@@ -1,4 +1,6 @@
using Yw.Model;
using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraPrinting;
using Yw.Model;

namespace Yw.WinFrmUI
{
@@ -40,32 +42,50 @@
            get { return _allList != null && _allList.Count > 0; }
        }

        //所有列表
        private List<HydroReservoirViewModel> _allList = null;
        //所有绑定列表
        private List<HydroReservoirViewModel> _allBindingList = null;

        private List<HydroReservoirViewModel> _allList = null;//所有列表
        private List<HydroReservoirViewModel> _allBindingList = null; //所有绑定列表
        private HydroChangeHelper _changeHelper = null;//改变辅助类
        private HydroPropStatusHelper _propStatusHelper = null;//属性状态辅助类

        /// <summary>
        /// 绑定数据
        /// </summary>
        public void SetBindingData(Yw.Model.HydroModelInfo hydroInfo)
        public void SetBindingData
            (
                Yw.Model.HydroModelInfo hydroInfo,
                HydroChangeHelper changeHelper = null,
                HydroPropStatusHelper propStatusHelper = null
            )
        {
            SetBindingData(hydroInfo, allCalcuResultList: null);
            SetBindingData(hydroInfo, allCalcuResultList: null, changeHelper, propStatusHelper);
        }

        /// <summary>
        /// 绑定数据
        /// </summary>
        public void SetBindingData(Yw.Model.HydroModelInfo hydroInfo, List<HydroCalcuVisualResult> allCalcuResultList)
        public void SetBindingData
            (
                Yw.Model.HydroModelInfo hydroInfo,
                List<HydroCalcuVisualResult> allCalcuResultList,
                HydroChangeHelper changeHelper = null,
                HydroPropStatusHelper propStatusHelper = null
            )
        {
            var allCalcuResultVisualDict = allCalcuResultList?.ToDictionary(x => x.Code);
            SetBindingData(hydroInfo, allCalcuResultVisualDict);
            SetBindingData(hydroInfo, allCalcuResultVisualDict, changeHelper, propStatusHelper);
        }

        /// <summary>
        /// 绑定数据
        /// </summary>
        public void SetBindingData(Yw.Model.HydroModelInfo hydroInfo, Dictionary<string, HydroCalcuVisualResult> allCalcuResultVisualDict)
        public void SetBindingData
            (
                Yw.Model.HydroModelInfo hydroInfo,
                Dictionary<string, HydroCalcuVisualResult> allCalcuResultVisualDict,
                HydroChangeHelper changeHelper = null,
                HydroPropStatusHelper propStatusHelper = null
            )
        {
            _allList = new List<HydroReservoirViewModel>();
            if (hydroInfo != null && hydroInfo.Reservoirs != null && hydroInfo.Reservoirs.Count > 0)
@@ -81,13 +101,20 @@
                    _allList.Add(vm);
                }
            }
            _changeHelper = changeHelper;
            _propStatusHelper = propStatusHelper;
            Search();
        }

        /// <summary>
        /// 绑定数据
        /// </summary>
        public void SetBindingData(List<HydroVisualViewModel> allVisualViewModelList)
        public void SetBindingData
            (
                List<HydroVisualViewModel> allVisualViewModelList,
                HydroChangeHelper changeHelper = null,
                HydroPropStatusHelper propStatusHelper = null
            )
        {
            _allList = new List<HydroReservoirViewModel>();
            allVisualViewModelList?.ForEach(x =>
@@ -97,6 +124,8 @@
                    _allList.Add(x as HydroReservoirViewModel);
                }
            });
            _changeHelper = changeHelper;
            _propStatusHelper = propStatusHelper;
            Search();
        }

@@ -244,9 +273,13 @@
                return;
            }
            var dlg = new SetHydroReservoirDlg();
            dlg.SetBindingData(_allBindingList.Select(x => x.Vmo).ToList());
            dlg.SetBindingData(_allBindingList.Select(x => x.Vmo).ToList(), _changeHelper, _propStatusHelper);
            dlg.ReloadDataEvent += (list) =>
            {
                if (list == null || list.Count < 1)
                {
                    return;
                }
                _allBindingList.ForEach(x => x.UpdateProperty());
                this.hydroReservoirViewModelBindingSource.ResetBindings(false);
                var allVisualViewModelList = _allBindingList.Select(x => x as HydroVisualViewModel).ToList();
@@ -255,6 +288,39 @@
                this.HydroChangedInfoEvent?.Invoke(allVisualInfoList);
            };
            dlg.ShowDialog();
        }

        //行单元格点击事件
        private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
        {
            var row = this.gridView1.GetRow(e.RowHandle) as HydroReservoirViewModel;
            if (row == null)
            {
                return;
            }

            if (e.Column == this.colSet)
            {
                var dlg = new SetHydroReservoirDlg();
                dlg.SetBindingData(row.Vmo, _changeHelper, _propStatusHelper);
                dlg.ReloadDataEvent += (list) =>
                {
                    if (list == null || list.Count < 1)
                    {
                        return;
                    }
                    row.UpdateProperty();
                    this.gridView1.RefreshRow(e.RowHandle);
                    this.HydroChangedViewEvent?.Invoke(new List<HydroVisualViewModel>() { row });
                    this.HydroChangedInfoEvent?.Invoke(new List<HydroVisualInfo>() { row.Vmo });
                };
                dlg.ShowDialog();
            }
            else
            {
                this.HydroClickViewEvent?.Invoke(row);
                this.HydroClickInfoEvent?.Invoke(row.Vmo);
            }
        }

        /// <summary>
@@ -362,36 +428,34 @@
            this.colSet.Visible = false;
        }

        //行单元格点击事件
        private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)

        /// <summary>
        /// 
        /// </summary>
        public GridView GetGridView()
        {
            var row = this.gridView1.GetRow(e.RowHandle) as HydroReservoirViewModel;
            if (row == null)
            return this.gridView1;
        }

        /// <summary>
        /// 
        /// </summary>
        public void ExportToXlsx()
        {
            var filePath = FileDialogHelper.SaveFile("导出Excel文件", "Excel文件|*.xlsx");
            if (string.IsNullOrEmpty(filePath))
            {
                return;
            }

            if (e.Column == this.colSet)
            var options = new XlsxExportOptions
            {
                var dlg = new SetHydroReservoirDlg();
                dlg.SetBindingData(row.Vmo);
                dlg.ReloadDataEvent += (list) =>
                {
                    row.UpdateProperty();
                    this.gridView1.RefreshRow(e.RowHandle);
                    this.HydroChangedViewEvent?.Invoke(new List<HydroVisualViewModel>() { row });
                    this.HydroChangedInfoEvent?.Invoke(new List<HydroVisualInfo>() { row.Vmo });
                };
                dlg.ShowDialog();
            }
            else
            {
                this.HydroClickViewEvent?.Invoke(row);
                this.HydroClickInfoEvent?.Invoke(row.Vmo);
            }
                ExportMode = XlsxExportMode.SingleFile, // 导出模式
                ShowGridLines = true, // 显示网格线
                TextExportMode = TextExportMode.Value, // 导出文本模式
                SheetName = "水库" // 工作表名称
            };
            this.gridView1.ExportToXlsx(filePath, options);
        }




    }