using NPOI.HSSF.UserModel; using System; using System.IO; using System.Linq; namespace TProduct.DataFile.PumpReport { /// /// TPump里面的V2模版(来源湖南) /// public class TestReportFileT2 : TestReportFileExcelBase { public TestReportFileT2() { } protected string _strExcelFile = null; public override string Create(string strFilePath, TProduct.Model.DispStautInfo infoDelegete) { //初始化文件 var message = InitialFile(strFilePath); if (!string.IsNullOrEmpty(message)) { infoDelegete("泵数据表V1 生成失败，Error:" + message, 1); return message; } this._strExcelFile = strFilePath; try { using (FileStream fileStream = new FileStream(_strExcelFile, FileMode.Open, FileAccess.ReadWrite)) { _theBookHander = new HSSFWorkbook(fileStream); } if (_theBookHander == null) { infoDelegete("泵数据表V1 生成失败，Error:未能打开模版Excel文件", 1); return "未能打开模版Excel文件"; } WritePage封面(infoDelegete); WritePage1_检查报告(infoDelegete); WritePage2_分析报告(infoDelegete); WritePage3_试验报告(infoDelegete); WritePage4_性能测试(infoDelegete); using (var fileStream = new FileStream(_strExcelFile, FileMode.Create)) { _theBookHander.Write(fileStream); } } catch (Exception ex) { infoDelegete("泵数据表V1 生成失败，Error:" + ex.Message, 1); return ex.Message; } finally { //workSheet.Save(); //workSheet.Close(); //workSheet = null; } return null; } public override string GetTemplateFilePath() { return System.IO.Path.Combine( TProduct.DataFolderParas.FullPath, "PumpFeatReportTemplate", "P_CN_T2_V1.xls"); } //初始化文件 private string InitialFile(string strFilePath) { string strTemplateFile = GetTemplateFilePath(); if (!File.Exists(strTemplateFile)) { return strTemplateFile + ": 模板文件被非法删除"; } if (File.Exists(strFilePath)) { File.Delete(strFilePath); } File.Copy(strTemplateFile, strFilePath, true); return null; } private bool WritePage封面(TProduct.Model.DispStautInfo infoDelegete) { NPOI.SS.UserModel.ISheet sheet封面 = _theBookHander.GetSheetAt(0); if (sheet封面 == null) { infoDelegete(" 生成失败，Error:未发现模版封面页", 1); return false; } //产品名称 SetCellValue(sheet封面, 1, "F", this._testProject.ReportFileNO); //产品名称 SetCellValue(sheet封面, 10, "B", this._currentPart.Name); //型号 SetCellValue(sheet封面, 11, "B", this._currentPump.Name); //生产单位 / 受检单位 var manufacture_name = new BLL.ManufacturerBase().GetNameByID(this._currentPart.ManufacturerID); SetCellValue(sheet封面, 13, "B", manufacture_name); //送检单位 / 委托单位 var sender_name = new BLL.Senderbase().GetNameByID(this._currentPart.SenderID); SetCellValue(sheet封面, 14, "B", sender_name); sheet封面.ForceFormulaRecalculation = true; return true; } private bool WritePage1_检查报告(TProduct.Model.DispStautInfo infoDelegete) { NPOI.SS.UserModel.ISheet sheet检查报告 = _theBookHander.GetSheetAt(1); if (sheet检查报告 == null) { infoDelegete(" 生成失败，Error:未发现模版封面页", 1); return false; } //文件编号 SetCellValue(sheet检查报告, 3, "B", this._testProject.ReportFileNO); //产品名称 SetCellValue(sheet检查报告, 4, "B", this._currentPart.Name); //型号 SetCellValue(sheet检查报告, 4, "D", this._currentPump.Name); //型号 SetCellValue(sheet检查报告, 5, "B", this._currentPart.Code); //收样日期 SetCellValue(sheet检查报告, 4, "D", this._currentPart.SendTime); var manufacture = new BLL.ManufacturerBase().GetByID(this._currentPart.ManufacturerID); var sender = new BLL.Senderbase().GetByID(this._currentPart.SenderID); var senderuser = new BLL.LoginUser().GetByID(_currentPart.SenderID); //生产单位 / 受检单位 SetCellValue(sheet检查报告, 8, "B", manufacture?.FullName == null ? manufacture?.ShortName : manufacture?.FullName); //生产单位地址 SetCellValue(sheet检查报告, 9, "B", manufacture?.Address); //送检单位 / 委托单位 SetCellValue(sheet检查报告, 10, "B", sender?.FullName == null ? sender?.ShortName : sender?.FullName); //送检人 SetCellValue(sheet检查报告, 10, "D", senderuser?.RealName); //送检单位地址 / 委托单位地址 SetCellValue(sheet检查报告, 11, "B", sender?.Address); //送检日期 SetCellValue(sheet检查报告, 11, "D", this._testProject.CreateTime.ToString("yyyy-MM-dd")); //送检日期 SetCellValue(sheet检查报告, 22, "A", this._testProject.JudgeResult.ToString()); sheet检查报告.ForceFormulaRecalculation = true; return true; } private bool WritePage2_分析报告(TProduct.Model.DispStautInfo infoDelegete) { NPOI.SS.UserModel.ISheet sheet分析报告 = _theBookHander.GetSheetAt(2); if (sheet分析报告 == null) { infoDelegete(" 生成失败，Error:未发现模版封面页", 1); return false; } var flow = TProduct.Common.PumpTestJudgeHelper.ConnectFlow(_testJudgeResults); var head = TProduct.Common.PumpTestJudgeHelper.ConnectHead(_testJudgeResults); //产品名称 SetCellValue(sheet分析报告, 1, "B", this._testProject.ReportFileNO); SetCellValue(sheet分析报告, 4, "B", "m³/h"); SetCellValue(sheet分析报告, 5, "B", "m"); SetCellValue(sheet分析报告, 4, "C", flow.RequestPercent); SetCellValue(sheet分析报告, 5, "C", head.RequestPercent); SetCellValue(sheet分析报告, 4, "D", flow.ItemJudgResultName); SetCellValue(sheet分析报告, 5, "D", head.ItemJudgResultName); if (flow.IsQualified || head.IsQualified) SetCellValue(sheet分析报告, 4, "E", "合格"); else SetCellValue(sheet分析报告, 4, "E", "不合格"); var eta = _testJudgeResults.Find(x => x.TargeType == Model.eTestJudgeTargetType.泵效率); if (eta != null) { SetCellValue(sheet分析报告, 6, "C", eta.RequestPercent); SetCellValue(sheet分析报告, 6, "D", eta.ItemJudgResultName); if (eta.IsQualified) SetCellValue(sheet分析报告, 6, "E", "合格"); else SetCellValue(sheet分析报告, 6, "E", "不合格"); } sheet分析报告.ForceFormulaRecalculation = true; return true; } private bool WritePage3_试验报告(TProduct.Model.DispStautInfo infoDelegete) { NPOI.SS.UserModel.ISheet sheet试验报告 = _theBookHander.GetSheetAt(3); if (sheet试验报告 == null) { infoDelegete(" 生成失败，Error:未发现模版封面页", 1); return false; } //产品名称 SetCellValue(sheet试验报告, 2, "C", this._testProject.ReportFileNO); //产品型号 SetCellValue(sheet试验报告, 3, "C", this._currentPump.Name); //产品编号 SetCellValue(sheet试验报告, 3, "J", this._currentPart.Code); //产品名称 SetCellValue(sheet试验报告, 4, "C", this._currentPumpSeries.Name); //检验日期 SetCellValue(sheet试验报告, 4, "J", this._testProject.CreateTime.ToString("yyyy-MM-dd")); //制造单位 var mfName = new BLL.ManufacturerBase().GetNameByID(_currentPart.ManufacturerID); SetCellValue(sheet试验报告, 5, "J", mfName); if (this._ratedParas != null) { SetCellValue(sheet试验报告, 8, "A", _ratedParas.Q); SetCellValue(sheet试验报告, 8, "C", _ratedParas.H); if (this._currentPump.Ratedn.HasValue) SetCellValue(sheet试验报告, 8, "E", this._currentPump.Ratedn.Value); SetCellValue(sheet试验报告, 8, "I", _ratedParas.E); SetCellValue(sheet试验报告, 8, "G", _ratedParas.P); if (_ratedParas.NPSHr.HasValue && _ratedParas.NPSHr > 0) SetCellValue(sheet试验报告, 8, "L", _ratedParas.NPSHr.Value); } if (_testJudgeResults != null && _testJudgeResults.Count > 0) { var judge_flow = TProduct.Common.PumpTestJudgeHelper.ConnectFlow(_testJudgeResults); var judge_head = TProduct.Common.PumpTestJudgeHelper.ConnectHead(_testJudgeResults); var eta_result = _testJudgeResults.Find(x => x.TargeType == Model.eTestJudgeTargetType.泵效率); SetCellValue(sheet试验报告, 13, "A", Math.Round(judge_flow.JudgeValue, 2)); SetCellValue(sheet试验报告, 13, "C", Math.Round(judge_head.JudgeValue, 2)); if (this._currentPump.Ratedn.HasValue) SetCellValue(sheet试验报告, 13, "E", this._currentPump.Ratedn.Value); if (eta_result != null) { SetCellValue(sheet试验报告, 13, "I", Math.Round(eta_result.JudgeValue, 2)); var power = Eventech.Common.PumpParaHelper.CalculateP(Math.Round(judge_flow.JudgeValue, 2), Math.Round(judge_head.JudgeValue, 2), Math.Round(eta_result.JudgeValue, 2)); SetCellValue(sheet试验报告, 13, "G", Math.Round(power, 2)); } SetCellValue(sheet试验报告, 17, "D", Math.Round(Math.Abs(_ratedParas.Q - judge_flow.JudgeValue), 2)); SetCellValue(sheet试验报告, 17, "F", "m³/h"); SetCellValue(sheet试验报告, 17, "K", Math.Round(Math.Abs(_ratedParas.H - judge_head.JudgeValue), 2)); bool isQualifyAll = true; if (judge_flow.IsQualified || judge_head.IsQualified) SetCellValue(sheet试验报告, 20, "D", "合格"); else { SetCellValue(sheet试验报告, 20, "D", "不合格"); isQualifyAll = false; } if (eta_result != null) { SetCellValue(sheet试验报告, 18, "D", Math.Round(eta_result.JudgeValue, 2)); if (eta_result.IsQualified) SetCellValue(sheet试验报告, 20, "K", "合格"); else { SetCellValue(sheet试验报告, 20, "K", "不合格"); isQualifyAll = false; } } if (isQualifyAll) SetCellValue(sheet试验报告, 26, "A", "合格"); else { SetCellValue(sheet试验报告, 26, "A", "不合格"); isQualifyAll = false; } //曲线分析 if (_curveExpressQH != null) { var min_flow = (from x in this._allRecords select x.CorrectPtQ).Min(); //最小流量点流量 SetCellValue(sheet试验报告, 18, "K", Math.Round(min_flow, 2)); var min_flow_head = Eventech.Common.FitCurveHelper.GetFitPointY(_curveExpressQH, Math.Round(min_flow, 2)); //最小流量点流量 SetCellValue(sheet试验报告, 19, "D", Math.Round(min_flow_head, 2)); //最高扬程（m） var max_head_pt = Eventech.Common.FitCurveHelper.GetMaxPoint(_curveExpressQH, 200); SetCellValue(sheet试验报告, 19, "K", Math.Round(max_head_pt.Y, 2)); } } sheet试验报告.ForceFormulaRecalculation = true; return true; } private bool WritePage4_性能测试(TProduct.Model.DispStautInfo infoDelegete) { NPOI.SS.UserModel.ISheet sheet性能测试 = _theBookHander.GetSheetAt(4); if (sheet性能测试 == null) { infoDelegete(" 生成失败，Error:未发现模版封面页", 1); return false; } var sdName = new BLL.Senderbase().GetNameByID(_currentPart.SenderID); //产品名称 SetCellValue(sheet性能测试, 1, "B", this._testProject.ReportFileNO); //产品名称 SetCellValue(sheet性能测试, 2, "B", sdName); //产品名称 SetCellValue(sheet性能测试, 3, "B", _currentPump.Name); //送检日期 SetCellValue(sheet性能测试, 3, "H", this._testProject.CreateTime.ToString("yyyy-MM-dd")); if (this._allMonitorPoints == null || this._allMonitorPoints.Count() == 0) return false; if (this._allRecords == null || this._allRecords.Count() == 0) return false; if (_featChartImage != null) { _featChartImage.SetDockType(PumpGraph.Picture.FeatChart.eDockType.测试报告, 769, 850); var image1 = _featChartImage.CreateImage(); //System.Drawing.Image img = SPump.DataFile.BASE.NPIOExcelHelper.CreateNewLargeImage(image1, width, height); AddImage1(sheet性能测试, 3, "A", 5, "K", image1);//添加图片 } if (this._allMonitorPoints == null || this._allMonitorPoints.Count() == 0) return false; if (this._allRecords == null || this._allRecords.Count() == 0) return false; var sort_allRecords = (from x in this._allRecords orderby x.CorrectPtQ select x).ToList(); SetCellValue(sheet性能测试, 8, "A", "m³/h"); SetCellValue(sheet性能测试, 8, "G", "m³/h"); //流量 var mp_flow = this._allMonitorPoints.Find(x => x.MonitorType == Model.eMonitorType.流量); if (mp_flow != null) { for (var index = 0; index < sort_allRecords.Count(); index++) { var rs = sort_allRecords[index].MonitorRecordList.Find(x => x.ID == mp_flow.ID); if (rs != null) SetCellValue(sheet性能测试, 9 + index, "A", rs.Value); } } //入口压力 var mp_inlet = this._allMonitorPoints.Find(x => x.MonitorType == Model.eMonitorType.压力 && x.Property == TProduct.Model.MonitorTypeProperty.进口); if (mp_inlet != null) { for (var index = 0; index < sort_allRecords.Count(); index++) { var rs = sort_allRecords[index].MonitorRecordList.Find(x => x.ID == mp_inlet.ID); if (rs != null) SetCellValue(sheet性能测试, 9 + index, "B", rs.Value); } } //出口压力 var mp_outlet = this._allMonitorPoints.Find(x => x.MonitorType == Model.eMonitorType.压力 && x.Property == TProduct.Model.MonitorTypeProperty.出口); if (mp_outlet != null) { for (var index = 0; index < sort_allRecords.Count(); index++) { var rs = sort_allRecords[index].MonitorRecordList.Find(x => x.ID == mp_outlet.ID); if (rs != null) SetCellValue(sheet性能测试, 9 + index, "C", rs.Value); } } //电流 var mp_功率 = this._allMonitorPoints.Find(x => x.MonitorType == Model.eMonitorType.功率); if (mp_功率 != null) { for (var index = 0; index < sort_allRecords.Count(); index++) { var rs = sort_allRecords[index].MonitorRecordList.Find(x => x.ID == mp_功率.ID); if (rs != null) SetCellValue(sheet性能测试, 9 + index, "E", rs.Value); } } //转速 var mp_speed = this._allMonitorPoints.Find(x => x.MonitorType == Model.eMonitorType.转速); if (mp_speed != null) { for (var index = 0; index < sort_allRecords.Count(); index++) { var rs = sort_allRecords[index].MonitorRecordList.Find(x => x.ID == mp_speed.ID); if (rs != null) SetCellValue(sheet性能测试, 9 + index, "F", rs.Value); } } for (var index = 0; index < sort_allRecords.Count(); index++) { SetCellValue(sheet性能测试, 9 + index, "G", sort_allRecords[index].CorrectPtQ); SetCellValue(sheet性能测试, 9 + index, "D", sort_allRecords[index].TestPtH); SetCellValue(sheet性能测试, 9 + index, "H", sort_allRecords[index].CorrectPtH); SetCellValue(sheet性能测试, 9 + index, "I", sort_allRecords[index].CorrectPtP.ToString()); SetCellValue(sheet性能测试, 9 + index, "J", sort_allRecords[index].CorrectPtE.ToString()); } sheet性能测试.ForceFormulaRecalculation = true; return true; } } }