public void Run()
{
_tool = CreateTool();
var partsData = new Dictionary <string, IParsedData>();
foreach (var partFile in _partsFiles)
{
//Определили тулкод инспекции
var toolCode = GetToolCode(partFile.Value.File);
//Защита от файлов, не являющихся файлами инспекций или файлами инспекций, для которых нет обработчиков
switch (GetFirstLettersOfToolCode(toolCode))
{
case "MSSB":
case "MDC":
case "ARC":
break;
default:
MessageBox.Show(
"A nonstandart name was received while reading the file. Perhaps there is no handler for the file, or the file is not an inspection file",
"Warining", MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
PdfProcessor processor = new SmartToolPdfProcessor {
File = partFile.Value.File
};
var parsedData = processor.GetPdfData();
partsData.Add(partFile.Key, parsedData);
}
IParsedData data;
partsData.TryGetValue("Top", out data);
_tool.Top = data;
if (_toolType == SmartToolType.Telescope || _toolType == SmartToolType.Gdis)
{
partsData.TryGetValue("Middle", out data);
_tool.Middle = data;
}
partsData.TryGetValue("Bottom", out data);
_tool.Bottom = data;
SmartToolExcelProcessor excel;
if (_toolType == SmartToolType.Arc)
{
excel = new ArcExcelProcessor();
}
else
{
excel = new SmartToolExcelProcessor();
}
excel.PassDataToExcel(_tool);
}
public virtual void PassDataToExcel(ISmartTool tool)
{
switch (tool.Type)
{
case SmartToolType.Telescope:
TemplateFileName = "TeleScope Diagram.xlsx";
break;
case SmartToolType.Gdis:
TemplateFileName = "GDIS Diagram.xlsx";
break;
}
var filePath = $@"{Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)}\misc\{TemplateFileName}";
try
{
using (
var file =
new FileStream(filePath,
FileMode.Open, FileAccess.Read))
{
Book = new XSSFWorkbook(file);
}
Sheet = Book.GetSheetAt(0);
Book.SetSheetName(Book.GetSheetIndex(Sheet), $"{tool.Top.Name}_{tool.Top.SerialNumber}");
//Номер ячейки (в контексте таблицы - столбца), в которую вставляются данные (нумерация ячеек в коде начинается с 0)
//Поэтому от номера строки и столбца нужно отнимать 1
var cellNum = 2;
//MDC SerialNumber
SetCellValue(7, cellNum, tool.Middle.SerialNumber);
//Top Sub SerialNumber
SetCellValue(9, cellNum, tool.Top.SerialNumber);
//Bottom Sub SerialNumber
SetCellValue(11, cellNum, tool.Bottom.SerialNumber);
cellNum = 4;
//Top Sub OD
SetCellValue(14, cellNum, tool.Top.ConnectionOne.Od);
//MDC OD
SetCellValue(20, cellNum, tool.Middle.ConnectionOne.Od);
//Bottom Sub OD
SetCellValue(64, cellNum, tool.Bottom.ConnectionOne.Od);
//Bottom Sub ID
SetCellValue(75, 7, tool.Bottom.ConnectionTwo.Id);
cellNum = 9;
//Top Sub Treadsize
SetCellValue(7, cellNum, tool.Top.ConnectionOne.TreadSize);
//Bottom Sub Treadsize
SetCellValue(75, cellNum, tool.Bottom.ConnectionTwo.TreadSize);
cellNum = 10;
//L
var lMdc = LengthConverter.InchesToMeters(InchesValueRetriever.GetInchesValue(tool.Middle.Length));
var lBotSub = LengthConverter.InchesToMeters(InchesValueRetriever.GetInchesValue(tool.Bottom.Length));
var lTopSub = LengthConverter.InchesToMeters(InchesValueRetriever.GetInchesValue(tool.Top.Length));
//L MDC + Bottom Sub
SetCellValue(17, cellNum, (lMdc + lBotSub).ToString("0.000"));
//L MDC + Bottom Sub
SetCellValue(61, cellNum, lBotSub.ToString("0.000"));
//L MDC + Bottom Sub + Top Sub
SetCellValue(40, 13, (lMdc + lBotSub + lTopSub).ToString("0.000"));
string fileName = $@"{Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)}\work\{
tool.Top.Name}_{tool.Top.SerialNumber}_FishingDiagram_{DateTime.Now.ToString("yy-MM-dd-HH-mm-ss")}.xlsx";
//Сохранение изменённого файла
using (
var file =
new FileStream(fileName, FileMode.CreateNew, FileAccess.Write))
{
Book.Write(file);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "I have a bad feeling about this", MessageBoxButton.OK,
MessageBoxImage.Error);
return;
}
}
public override void PassDataToExcel(ISmartTool tool)
{
TemplateFileName = "ARC Diagram.xlsx";
var filePath = $@"{Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)}\misc\{TemplateFileName}";
try
{
using (
var file =
new FileStream(filePath,
FileMode.Open, FileAccess.Read))
{
Book = new XSSFWorkbook(file);
}
Sheet = Book.GetSheetAt(0);
Book.SetSheetName(Book.GetSheetIndex(Sheet), $"{tool.Top.Name}_{tool.Top.SerialNumber}");
var arcData = new ArcData();
if (!arcData.Tools.ContainsKey(tool.Top.SerialNumber))
{
MessageBox.Show("No such ARC in library", "Information", MessageBoxButton.OK,
MessageBoxImage.Asterisk);
return;
}
var arcTool = arcData.Tools[tool.Top.SerialNumber];
var inspectionLength = LengthConverter.InchesToMeters(InchesValueRetriever.GetInchesValue(tool.Top.Length));
var arrayLength = Convert.ToSingle(arcTool.L, CultureInfo.InvariantCulture);
var difference = Math.Abs(inspectionLength - arrayLength);
if (difference > 0.025f)
{
MessageBox.Show($"Collar length {inspectionLength} doesn't match. Should be about {arrayLength}. Difference is {difference}. Prepare fishing diagram manually.", "Information", MessageBoxButton.OK,
MessageBoxImage.Asterisk);
return;
}
//Номер ячейки (в контексте таблицы - столбца), в которую вставляются данные (нумерация ячеек в коде начинается с 0)
//Поэтому от номера строки и столбца нужно отнимать 1
var cellNum = 2;
//ARC SerialNumber
SetCellValue(7, cellNum, tool.Top.SerialNumber);
//Bottom Sub SerialNumber
SetCellValue(11, cellNum, tool.Bottom.SerialNumber);
cellNum = 5;
//OD8 from ARC inspection
SetCellValue(13, cellNum, tool.Top.ConnectionOne.Od);
//OD7
SetCellValue(19, cellNum, arcTool.Od7);
//OD6
SetCellValue(22, cellNum, arcTool.Od6);
//OD5
SetCellValue(25, cellNum, arcTool.Od5);
//OD4
SetCellValue(36, cellNum, arcTool.Od4);
//OD3
SetCellValue(48, cellNum, arcTool.Od3);
//OD2
SetCellValue(60, cellNum, arcTool.Od2);
//OD1
SetCellValue(64, cellNum, arcTool.Od1);
//OD Saver Sub
SetCellValue(68, cellNum, tool.Bottom.ConnectionOne.Od);
//ID Saver Sub
SetCellValue(75, 7, tool.Bottom.ConnectionTwo.Id);
cellNum = 9;
//Top connection type
SetCellValue(7, cellNum, tool.Top.ConnectionOne.ConnectionType);
//Saver sub connection type
SetCellValue(75, cellNum, tool.Bottom.ConnectionTwo.ConnectionType);
cellNum = 10;
var saverSubLength = LengthConverter.InchesToMeters(InchesValueRetriever.GetInchesValue(tool.Bottom.Length));
//L10
SetCellValue(18, cellNum, (Convert.ToSingle(arcTool.L10, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L9
SetCellValue(21, cellNum, (Convert.ToSingle(arcTool.L9, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L8
SetCellValue(23, cellNum, (Convert.ToSingle(arcTool.L8, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L7
SetCellValue(25, cellNum, (Convert.ToSingle(arcTool.L7, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L6
SetCellValue(35, cellNum, (Convert.ToSingle(arcTool.L6, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L5
SetCellValue(38, cellNum, (Convert.ToSingle(arcTool.L5, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L4
SetCellValue(47, cellNum, (Convert.ToSingle(arcTool.L4, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L3
SetCellValue(50, cellNum, (Convert.ToSingle(arcTool.L3, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L2
SetCellValue(59, cellNum, (Convert.ToSingle(arcTool.L2, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L1
SetCellValue(62, cellNum, (Convert.ToSingle(arcTool.L1, CultureInfo.InvariantCulture) + saverSubLength).ToString("0.000"));
//L total
SetCellValue(40, 13, (inspectionLength + saverSubLength).ToString("0.000"));
string fileName = $@"{Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)}\work\{
tool.Top.Name}_{tool.Top.SerialNumber}_FishingDiagram_{DateTime.Now.ToString("yy-MM-dd-HH-mm-ss")}.xlsx";
//Сохранение изменённого файла
using (
var file =
new FileStream(fileName, FileMode.CreateNew, FileAccess.Write))
{
Book.Write(file);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "I have a bad feeling about this", MessageBoxButton.OK,
MessageBoxImage.Error);
return;
}
}
