using DevExpress.XtraEditors;
|
using NPOI.HSSF.UserModel;
|
using NPOI.SS.UserModel;
|
using System.IO;
|
using Yw.Geometry;
|
|
namespace Yw.WinFrmUI.Phart
|
{
|
public class Perform2dExportHelper
|
{
|
|
/// <summary>
|
/// 导出
|
/// </summary>
|
public static void ExportXLS(Yw.Geometry.CubicSpline2d cubic_spline_qh, Yw.Geometry.CubicSpline2d cubic_spline_qe, Yw.Geometry.CubicSpline2d cubic_spline_qp, int fitPointNum = 15)
|
{
|
try
|
{
|
if (cubic_spline_qh == null)
|
return;
|
|
var dlg = new SaveFileDialog();
|
dlg.Filter = "EXCEL 文件(*.xls)|*.xls";
|
if (dlg.ShowDialog() != DialogResult.OK)
|
return;
|
|
HSSFWorkbook theBook = new HSSFWorkbook();
|
var theSheet1 = theBook.CreateSheet("Sheet1");
|
|
IRow rowTile = theSheet1.CreateRow(0);
|
rowTile.CreateCell(0).SetCellValue("流量");
|
rowTile.CreateCell(1).SetCellValue("扬程");
|
rowTile.CreateCell(2).SetCellValue("效率");
|
rowTile.CreateCell(3).SetCellValue("功率");
|
|
|
//均匀插值点,计算点坐标
|
double minQ = cubic_spline_qh.MinX;
|
double maxQ = cubic_spline_qh.MaxX;
|
double space = (maxQ - minQ) / (fitPointNum - 1);
|
double Q = minQ;
|
double H, E, P;
|
for (int rowIndex = 1; rowIndex <= fitPointNum; rowIndex++)
|
{
|
int col = 0;
|
IRow row = theSheet1.CreateRow(rowIndex);
|
|
row.CreateCell(col).SetCellValue(Trans(Q));
|
col++;
|
|
H = cubic_spline_qh.GetPointY(Q);
|
row.CreateCell(col).SetCellValue(Trans(H));
|
col++;
|
|
if (cubic_spline_qe != null && Q <= cubic_spline_qe.MaxX && Q >= cubic_spline_qe.MinX)
|
{
|
if (Q < 0.1)
|
E = 0;
|
else
|
E = cubic_spline_qe.GetPointY(Q);
|
row.CreateCell(col).SetCellValue(Trans(E));
|
col++;
|
}
|
|
|
if (cubic_spline_qp != null && Q <= cubic_spline_qp.MaxX && Q >= cubic_spline_qp.MinX)
|
{
|
P = cubic_spline_qp.GetPointY(Q);
|
row.CreateCell(col).SetCellValue(Trans(P));
|
col++;
|
}
|
|
|
Q = Q + space;
|
if (Q > cubic_spline_qh.MaxX * 0.9999)
|
Q = cubic_spline_qh.MaxX * 0.9999;
|
}
|
|
//强制Excel在打开时重新计算所有公式
|
theSheet1.ForceFormulaRecalculation = true;
|
using (FileStream fs = File.OpenWrite(dlg.FileName))
|
{
|
theBook.Write(fs);
|
}
|
|
}
|
catch (Exception ex)
|
{
|
XtraMessageBox.Show(ex.ToString());
|
}
|
XtraMessageBox.Show("导出成功");
|
}
|
|
/// <summary>
|
/// 导出定义点
|
/// </summary>
|
public static void ExportDefinePoints(List<Yw.Geometry.Point2d> cubic_spline_qh, List<Yw.Geometry.Point2d> cubic_spline_qe, List<Yw.Geometry.Point2d> cubic_spline_qp, int fitPointNum = 15)
|
{
|
try
|
{
|
if (cubic_spline_qh == null)
|
return;
|
|
var dlg = new SaveFileDialog();
|
dlg.Filter = "EXCEL 文件(*.xls)|*.xls";
|
if (dlg.ShowDialog() != DialogResult.OK)
|
return;
|
|
|
HSSFWorkbook theBook = new HSSFWorkbook();
|
var theSheet1 = theBook.CreateSheet("Sheet1");
|
|
IRow rowTile = theSheet1.CreateRow(0);
|
rowTile.CreateCell(0).SetCellValue("流量");
|
rowTile.CreateCell(1).SetCellValue("扬程");
|
rowTile.CreateCell(2).SetCellValue("效率");
|
rowTile.CreateCell(3).SetCellValue("功率");
|
|
List<Yw.Geometry.Point2d> pt_qh_list = null, pt_qe_list = null, pt_qp_list = null;
|
|
|
pt_qh_list = cubic_spline_qh;
|
|
if (pt_qh_list == null || pt_qh_list.Count < 4)
|
return;
|
|
pt_qe_list = cubic_spline_qe;
|
pt_qp_list = cubic_spline_qp;
|
|
//均匀插值点,计算点坐标
|
double minQ = cubic_spline_qh.Min()?.X ?? 0;
|
double maxQ = cubic_spline_qh.Max()?.X ?? 0;
|
double space = (maxQ - minQ) / (fitPointNum - 1);
|
double Q = 0;
|
double H, E = 0, P = 0;
|
|
int rowIndex = 1;
|
foreach (var pointQH in pt_qh_list)
|
{
|
Q = pointQH.X;
|
H = pointQH.Y;
|
|
if (pt_qe_list != null && pt_qe_list.Count > 0)
|
{
|
var pointQE = pt_qe_list.Find(x => x.X == Q);
|
if (pointQE != null)
|
{
|
E = pointQE.Y;
|
}
|
else
|
{
|
E = pt_qe_list.GetPointIndexByX(Q);
|
}
|
}
|
|
if (pt_qp_list != null && pt_qp_list.Count > 0)
|
{
|
var pointQP = pt_qp_list.Find(x => x.X == Q);
|
if (pointQP != null)
|
{
|
P = pointQP.Y;
|
}
|
else
|
{
|
P = cubic_spline_qp.GetPointIndexByX(Q);
|
}
|
}
|
|
|
var row = theSheet1.CreateRow(rowIndex);
|
rowIndex++;
|
|
int col = 0;
|
row.CreateCell(col).SetCellValue(Trans(Q));
|
col++;
|
|
row.CreateCell(col).SetCellValue(Trans(H));
|
col++;
|
|
row.CreateCell(col).SetCellValue(Trans(E));
|
col++;
|
|
row.CreateCell(col).SetCellValue(Trans(P));
|
col++;
|
}
|
|
|
//强制Excel在打开时重新计算所有公式
|
theSheet1.ForceFormulaRecalculation = true;
|
using (FileStream fs = File.OpenWrite(dlg.FileName))
|
{
|
theBook.Write(fs);
|
}
|
}
|
catch (Exception ex)
|
{
|
XtraMessageBox.Show(ex.ToString());
|
return;
|
}
|
XtraMessageBox.Show("导出成功");
|
}
|
|
/// <summary>
|
/// 转换
|
/// </summary>
|
private static string DoubleTrans(double doubleValue)
|
{
|
if (doubleValue < 1)
|
return doubleValue.ToString("0.0000");
|
else if (doubleValue < 10)
|
return doubleValue.ToString("0.000");
|
else if (doubleValue < 100)
|
return doubleValue.ToString("0.00");
|
else
|
return doubleValue.ToString("0.0");
|
}
|
|
/// <summary>
|
/// 转换
|
/// </summary>
|
private static double Trans(double doubleValue)
|
{
|
if (doubleValue < 1)
|
return Math.Round(doubleValue, 4);
|
else if (doubleValue < 10)
|
return Math.Round(doubleValue, 3);
|
else if (doubleValue < 100)
|
return Math.Round(doubleValue, 2);
|
else
|
return Math.Round(doubleValue, 1);
|
}
|
|
}
|
}
|
