/// <summary>
///
/// </summary>
/// <param name="model">数据</param>
/// <param name="header">工况名称</param>
public HistoryDetailsLine(HParaModel model, String header)
{
InitializeComponent();
Header.Text = header;
if (model.S_RotateSpeed > 0)
{
S_RotateSpeedTB.Text = model.S_RotateSpeed.ToString();
}
if (model.S_InjectionTime > 0)
{
S_InjectionTimeTB.Text = model.S_InjectionTime.ToString();
}
if (model.R_RackTravel > 0)
{
R_RackTravelTB.Text = Math.Round(model.R_RackTravel, PathStaticCollection.Round_Number).ToString();
}
if (model.R_InjectionQuantity > 0)
{
R_InjectionQuantityTB.Text = Math.Round(model.R_InjectionQuantity, PathStaticCollection.Round_Number).ToString();
}
if (model.R_Asymmetry > 0)
{
R_AsymmetryTB.Text = Math.Round(model.R_Asymmetry, PathStaticCollection.Round_Number).ToString();
}
}
//导出为excel 按钮点击
private void ETEButton_Click()
{
DialogBox.SaveFileDialog dialog = new DialogBox.SaveFileDialog();
string filePath;
dialog.Title = "选择导出文件保存路径";
dialog.Filter = "xlsx File(*.xlsx)|*.xlsx";
dialog.DefaultExt = "xlsx";
//如果用户没有添加则自动添加扩展
dialog.AddExtension = true;
if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
ExcelWorksheet workSheet;
//文件路径
filePath = dialog.FileName;
using (var p = new ExcelPackage())
{
workSheet = p.Workbook.Worksheets.Add("历史记录");
workSheet.Cells[1, 1].Value = "油泵编号";
workSheet.Cells[1, 2].Value = HModel.EquCode;
workSheet.Cells[1, 5].Value = "油泵型号";
workSheet.Cells[1, 6].Value = HModel.EquType;
workSheet.Cells[2, 1].Value = "油箱温度";
workSheet.Cells[2, 2].Value = HModel.Tem.GetDisplayString();
workSheet.Cells[2, 5].Value = "日期";
workSheet.Cells[2, 6].Value = HModel.HDate + " " + HModel.HTime;
workSheet.Cells[4, 1].Value = "工况名称";
workSheet.Cells[4, 2].Value = "转速rpm";
workSheet.Cells[4, 3].Value = "油量";
workSheet.Cells[4, 4].Value = "喷油次数";
workSheet.Cells[4, 5].Value = "行程";
workSheet.Cells[4, 6].Value = "不均匀";
List <HParaModel> datas = new List <HParaModel>();
datas.Add(HModel.StartWork);
datas.Add(HModel.IdlingWork);
datas.Add(HModel.IdlingBreak);
datas.Add(HModel.ReviseBegin);
datas.Add(HModel.ReviseWork);
datas.Add(HModel.ReviseEnd);
datas.Add(HModel.DemWork);
datas.Add(HModel.AdjWork);
datas.Add(HModel.HighBreak);
workSheet.Cells[5, 1].Value = "启动工况";
workSheet.Cells[6, 1].Value = "怠速工况";
workSheet.Cells[7, 1].Value = "怠速断油";
workSheet.Cells[8, 1].Value = "校正起作用";
workSheet.Cells[9, 1].Value = "校正工况";
workSheet.Cells[10, 1].Value = "校正结束";
workSheet.Cells[11, 1].Value = "标定工况";
workSheet.Cells[12, 1].Value = "调速工况";
workSheet.Cells[13, 1].Value = "高速断油";
if (HModel.IsPass)
{
workSheet.Cells[15, 1].Value = "合格";
}
else
{
workSheet.Cells[15, 1].Value = "不合格";
}
for (int cRow = 5; cRow <= 13; cRow++)
{
HParaModel data = datas[cRow - 5];
if (data.S_RotateSpeed > 0)
{
workSheet.Cells[cRow, 2].Value = data.S_RotateSpeed.ToString();
}
else
{
workSheet.Cells[cRow, 2].Value = "--";
}
if (data.R_InjectionQuantity > 0)
{
workSheet.Cells[cRow, 3].Value = Math.Round(data.R_InjectionQuantity, PathStaticCollection.Round_Number).ToString();
}
else
{
workSheet.Cells[cRow, 3].Value = "--";
}
if (data.S_InjectionTime > 0)
{
workSheet.Cells[cRow, 4].Value = data.S_InjectionTime.ToString();
}
else
{
workSheet.Cells[cRow, 4].Value = "--";
}
if (data.R_RackTravel > 0)
{
workSheet.Cells[cRow, 5].Value = Math.Round(data.R_RackTravel, PathStaticCollection.Round_Number).ToString();
}
else
{
workSheet.Cells[cRow, 5].Value = "--";
}
if (data.R_Asymmetry > 0)
{
workSheet.Cells[cRow, 6].Value = Math.Round(data.R_Asymmetry, PathStaticCollection.Round_Number).ToString();
}
else
{
workSheet.Cells[cRow, 6].Value = "--";
}
}
//保存数据
p.SaveAs(new FileInfo(filePath));
}
}
}
