using DevExpress.XtraEditors;
|
using DevExpress.XtraPrinting;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Diagnostics;
|
using System.Drawing;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Windows.Forms;
|
|
namespace Yw.WinFrmUI
|
{
|
public partial class HydroEnergyAnalyListCtrl : DevExpress.XtraEditors.XtraUserControl
|
{
|
public HydroEnergyAnalyListCtrl()
|
{
|
InitializeComponent();
|
this.gridView1.SetNormalView();
|
this.gridView1.OptionsView.AllowCellMerge = true;
|
this.colBeginGroup.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
|
}
|
|
private List<HydroEnergyAnalyListItemViewModel> _allList = null;//所有列表
|
|
/// <summary>
|
/// 绑定数据
|
/// </summary>
|
public void SetBindingData(List<HydroEnergyAnalyItemViewModel> allList)
|
{
|
var vmList = allList?.Select(x => new HydroEnergyAnalyListItemViewModel(x)).ToList();
|
SetBindingData(vmList);
|
}
|
|
/// <summary>
|
/// 绑定数据
|
/// </summary>
|
public void SetBindingData(List<HydroEnergyAnalyListItemViewModel> allList)
|
{
|
_allList = allList;
|
this.hydroEnergyAnalyListItemViewModelBindingSource.DataSource = _allList;
|
this.hydroEnergyAnalyListItemViewModelBindingSource.ResetBindings(false);
|
}
|
|
/// <summary>
|
/// 导出 Xlsx
|
/// </summary>
|
public void ExportToXlsx()
|
{
|
var filePath = FileDialogHelper.SaveFile("导出Excel文件", "Excel文件|*.xlsx");
|
if (string.IsNullOrEmpty(filePath))
|
{
|
return;
|
}
|
var options = new XlsxExportOptions
|
{
|
ExportMode = XlsxExportMode.SingleFile, // 导出模式
|
ShowGridLines = true, // 显示网格线
|
TextExportMode = TextExportMode.Value, // 导出文本模式
|
SheetName = "Sheet1" // 工作表名称
|
};
|
this.gridView1.ExportToXlsx(filePath, options);
|
if (XtraMessageBox.Show("导出成功,是否打开文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
|
{
|
Process.Start(new ProcessStartInfo(filePath) { UseShellExecute = true });
|
}
|
}
|
|
//合并条件
|
private void gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
|
{
|
if (e.Column == this.colBeginGroup)
|
{
|
//e.Handled=true;//取消合并
|
}
|
}
|
|
|
}
|
}
|