using System.IO;
|
using Yw.WinFrmUI.Phart;
|
|
namespace HStation.WinFrmUI.Assets
|
{
|
public class ExcelConvertHelper
|
{
|
public static Yw.Vmo.PhartDiagramExGraphListVmo ParsePumpExcel(string fileName)
|
{
|
var qh = new List<Yw.Geometry.Point2d>();
|
var qe = new List<Yw.Geometry.Point2d>();
|
var qp = new List<Yw.Geometry.Point2d>();
|
try
|
{
|
if (!File.Exists(fileName))
|
throw new Exception("文件不存在");
|
int line = 0;
|
|
//初始化文件
|
NPOI.HSSF.UserModel.HSSFWorkbook theBook = null;
|
using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.ReadWrite))
|
{
|
theBook = new NPOI.HSSF.UserModel.HSSFWorkbook(file);
|
}
|
|
//检查表格是否符合
|
NPOI.SS.UserModel.ISheet sheet1 = theBook.GetSheet("Sheet1");
|
if (sheet1 == null)
|
{
|
sheet1 = theBook.GetSheetAt(0);
|
if (sheet1 == null)
|
throw new Exception("无Sheet数据");
|
}
|
|
//标题行
|
int title_line_index = 0;
|
//流量列
|
int col_index_q = 1;
|
//扬程列
|
int col_index_h = 2;
|
//效率列
|
int col_index_e = 3;
|
//功率列
|
int col_index_p = 4;
|
|
var row_title = sheet1.GetRow(title_line_index);
|
if (row_title == null)
|
{
|
throw new Exception("第一行第一列不能空");
|
}
|
|
//开始读取的行
|
int start_line = title_line_index + 1;
|
var cell_0 = row_title.GetCell(0);
|
if (cell_0 == null)
|
{
|
throw new Exception("无法读取表头文件");
|
}
|
else if (cell_0.StringCellValue.Contains("序号"))
|
{
|
col_index_q = 1;
|
col_index_h = 2;
|
col_index_e = 3;
|
col_index_p = 4;
|
}
|
else if (cell_0.StringCellValue.Contains("流量"))
|
{
|
col_index_q = 0;
|
col_index_h = 1;
|
col_index_e = 2;
|
col_index_p = 3;
|
}
|
|
NPOI.SS.UserModel.IRow row_temp = null;
|
NPOI.SS.UserModel.ICell cell;
|
|
var list = new List<(double Q, double H, double P, double E)>();
|
for (line = start_line; line < 13; line++)
|
{
|
row_temp = sheet1.GetRow(line);
|
if (row_temp == null)
|
break;
|
|
cell = row_temp.GetCell(col_index_q);
|
if (cell == null)
|
break;
|
if (!ParseCellValue(cell, out double flow))
|
break;
|
if (flow < 0)
|
break;
|
|
cell = row_temp.GetCell(col_index_h);
|
if (cell == null)
|
break;
|
if (!ParseCellValue(cell, out double head))
|
break;
|
if (head < 0)
|
break;
|
|
cell = row_temp.GetCell(col_index_e);
|
if (cell == null)
|
break;
|
if (!ParseCellValue(cell, out double eff))
|
{
|
eff = -1;
|
}
|
|
cell = row_temp.GetCell(col_index_p);
|
if (cell == null)
|
break;
|
if (!ParseCellValue(cell, out double power))
|
{
|
power = -1;
|
}
|
|
if (eff > 0)
|
{
|
power = Yw.Pump.CalculationHelper.CalcuP(flow, head, eff);
|
}
|
else
|
{
|
eff = Yw.Pump.CalculationHelper.CalcuE(flow, head, power);
|
}
|
|
if (eff > 99)
|
{
|
throw new Exception("效率大于100%");
|
}
|
|
qh.Add(new Yw.Geometry.Point2d(flow, head));
|
qe.Add(new Yw.Geometry.Point2d(flow, eff));
|
qp.Add(new Yw.Geometry.Point2d(flow, power));
|
}
|
|
if (qh == null || qh.Count < 4)
|
{
|
return null;
|
}
|
|
var feat_type = Yw.Ahart.eFeatType.Cubic;
|
|
var vmo = new Yw.Vmo.PhartDiagramExGraphListVmo();
|
vmo.DiagramType = (int)HStation.PhartRelation.eDiagramType.Feat;
|
vmo.GraphList = new List<Yw.Vmo.PhartGraphVmo>();
|
|
var graph_qh = new Yw.Vmo.PhartGraphVmo()
|
{
|
Name = "扬程线",
|
GraphType = (int)Yw.Ahart.eCurveType.QH,
|
GraphParas = new QHGraphParasViewModel()
|
{
|
Hz = 50,
|
}.ToJson(),
|
GeometryParas = new Yw.WinFrmUI.Phart.CurveGeometryParasViewModel
|
{
|
DefinePoints = qh
|
}.ToJson(),
|
GeometryStyle = (int)HStation.PhartRelation.eGeometryStyle.FeatCurve,
|
GeometryInfo = qh.ToDbString(Yw.Ahart.eCurveType.QH, feat_type)
|
};
|
vmo.GraphList.Add(graph_qh);
|
|
if (qe != null && qe.Count > 3)
|
{
|
var graph_qe = new Yw.Vmo.PhartGraphVmo()
|
{
|
Name = "效率线",
|
GraphType = (int)Yw.Ahart.eCurveType.QE,
|
GraphParas = new QEGraphParasViewModel()
|
{
|
Hz = 50,
|
}.ToJson(),
|
GeometryParas = new Yw.WinFrmUI.Phart.CurveGeometryParasViewModel
|
{
|
DefinePoints = qe
|
}.ToJson(),
|
GeometryStyle = (int)HStation.PhartRelation.eGeometryStyle.FeatCurve,
|
GeometryInfo = qe.ToDbString(Yw.Ahart.eCurveType.QE, feat_type)
|
};
|
|
vmo.GraphList.Add(graph_qe);
|
}
|
|
if (qp != null && qp.Count > 3)
|
{
|
var graph_qp = new Yw.Vmo.PhartGraphVmo()
|
{
|
Name = "功率线",
|
GraphType = (int)Yw.Ahart.eCurveType.QP,
|
GraphParas = new QPGraphParasViewModel()
|
{
|
Hz = 50,
|
}.ToJson(),
|
GeometryParas = new Yw.WinFrmUI.Phart.CurveGeometryParasViewModel
|
{
|
DefinePoints = qp
|
}.ToJson(),
|
GeometryStyle = (int)HStation.PhartRelation.eGeometryStyle.FeatCurve,
|
GeometryInfo = qp.ToDbString(Yw.Ahart.eCurveType.QP, feat_type)
|
};
|
|
vmo.GraphList.Add(graph_qp);
|
}
|
|
return vmo;
|
}
|
catch (Exception ex)
|
{
|
throw;
|
}
|
}
|
|
private static bool ParseCellValue(NPOI.SS.UserModel.ICell cell, out double cell_value)
|
{
|
cell_value = 0;
|
if (cell.CellType == NPOI.SS.UserModel.CellType.Numeric)
|
{
|
cell_value = cell.NumericCellValue;
|
return true;
|
}
|
|
if (cell.CellType == NPOI.SS.UserModel.CellType.String)
|
{
|
if (double.TryParse(cell.StringCellValue, out double value))
|
{
|
cell_value = value;
|
return true;
|
}
|
}
|
|
return false;
|
}
|
}
|
}
|
