public void CreatePassportProjectToFileWithToTest()
{
var pathFileSave = Path.Combine(Path.GetTempPath(), "UPPY" + Environment.TickCount + ".tmp");
var list = new List<HierarchyNumberDrawing>();
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "1.", TechRouteId = 2 });
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "1.1.", TechRouteId = 4 });
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "2.", });// TechRouteId = 1
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "3.", TechRouteId = 3 });
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "4.", TechRouteId = 5 });
var listTo = new List<TechOperation>();
listTo.Add(new TechOperation() { Id = 1, ShortName = "A" });
listTo.Add(new TechOperation() { Id = 2, ShortName = "B" });
listTo.Add(new TechOperation() { Id = 3, ShortName = "C" });
listTo.Add(new TechOperation() { Id = 4, ShortName = "D" });
listTo.Add(new TechOperation() { Id = 5, ShortName = "E" });
var listTr = new List<TechRoute>();
listTr.Add(new TechRoute() { Id = 1, TechOperations = new List<TechOperation>() { new TechOperation() { Id = 1 }, new TechOperation() { Id = 2 } } });
listTr.Add(new TechRoute() { Id = 2, TechOperations = new List<TechOperation>() { new TechOperation() { Id = 2 }, new TechOperation() { Id = 3 } } });
listTr.Add(new TechRoute() { Id = 3, TechOperations = new List<TechOperation>() { new TechOperation() { Id = 3 }, new TechOperation() { Id = 5 } } });
listTr.Add(new TechRoute() { Id = 4, TechOperations = new List<TechOperation>() { new TechOperation() { Id = 1 }, new TechOperation() { Id = 2 }, new TechOperation() { Id = 4 } } });
listTr.Add(new TechRoute() { Id = 5, TechOperations = new List<TechOperation>() { new TechOperation() { Id = 5 } } });
var header = new Order();
ExportExcelFile excelFile = new ExportExcelFile();
Debug.WriteLine(pathFileSave);
Assert.DoesNotThrow(() =>
{
excelFile.CreatePassportProjectToFile(header, list, listTo, listTr, pathFileSave);
});
}
public void Save(Order order)
{
if (order.DrawingId == null)
{
var drawing = new Drawing();
_drawingDataManager.Insert(drawing);
order.DrawingId = drawing.Id;
}
_orderDataManager.InsertOrUpdate(order);
}
public void CreatePassportProjectToFile(Order order, List<HierarchyNumberDrawing> list,
string fileName)
{
var pck = new ExcelPackage();
var ws = pck.Workbook.Worksheets.Add("Паспорт");
CreateHeaderPassport(ws);
for (var i = 0; i < list.Count; i++)
{
AppendProjectToSheetWithoutTechOper(list[i], ws, i + 4);
}
pck.SaveAs(new FileInfo(fileName));
}
public void EditDocument(Order order)
{
if (order != null)
{
var docOrderController = _factory.GetDocumentController<Order>();
docOrderController.Document = order;
if (docOrderController.ShowViewDialog())
{
Save(docOrderController.Document);
DataRefreshed?.Invoke(this, EventArgs.Empty);
}
}
}
public void CreatePassportProjectToFile(Order order, List<HierarchyNumberDrawing> list,
List<TechOperation> techOperations, List<TechRoute> techRoutes, string fileName)
{
var pck = new ExcelPackage();
var ws = pck.Workbook.Worksheets.Add("Паспорт");
CreateHeaderPassport(ws, techOperations);
for (var i = 0; i < list.Count; i++)
{
AppendProjectToSheetWithoutTechOper(list[i], ws, i + 4);
AppendTechOperToSheet(techRoutes.FirstOrDefault(x => x.Id == list[i].TechRouteId), techOperations, ws,
i + 4);
}
pck.SaveAs(new FileInfo(fileName));
}
public void CreatePassportProjectToFileTest()
{
var pathFileSave = Path.Combine(Path.GetTempPath(), "UPPY" + Environment.TickCount + ".tmp");
var list = new List<HierarchyNumberDrawing>();
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "1." });
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "1.1." });
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "2." });
list.Add(new HierarchyNumberDrawing() { HierarchyNumber = "3." });
var header = new Order();
ExportExcelFile excelFile = new ExportExcelFile();
Debug.WriteLine(pathFileSave);
Assert.DoesNotThrow(() =>
{
excelFile.CreatePassportProjectToFile(header, list, pathFileSave);
});
}
public void Delete(Order order)
{
_orderDataManager.Delete(order);
}
