public void PrintSuperTaskToDistrict(SuperTaskToDistrict task) { var docDataManager = _dataManagersFactory.GetDataManager<SuperTaskToDistrict>(); var tos = _dataManagersFactory.GetDataManager<TechOperation>().GetListCollection(); var ors = _dataManagersFactory.GetDataManager<Order>().GetListCollection(); var doc = docDataManager.GetDocument(task.Id); _dataExport.CreateReportSuperTaskToDept(doc, ors, tos); _dataExport.SaveReport(); }
public void Delete(SuperTaskToDistrict doc) { _dataManager.Delete(doc); }
public void CreateReportSuperTaskToDept(SuperTaskToDistrict superTask, List<Order> orders, List<TechOperation> techOperations) { _pck = new ExcelPackage(); var workSheet = _pck.Workbook.Worksheets.Add("Задание на участок"); CreateHeaderTaskToDept(workSheet); var to = techOperations.FirstOrDefault(x => x.Id == superTask.TechOperationId); workSheet.Cells["A1:L1"].Value = to == null ? string.Empty : to.FullName; workSheet.Cells["A1:L1"].Value = $"Сводное задание № {superTask.Id} {(to == null ? string.Empty : to.FullName)}"; var countRowExcel = 3; foreach (var task in superTask.Tasks) { foreach (var positionTaskToDept in task.Positions) { var order = orders.FirstOrDefault(x => x.Id == task.OrderId); workSheet.Cells[countRowExcel, 1].Value = order != null ? (object)order.OrderNo : task.OrderId; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 1], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 2].Value = positionTaskToDept.DrawingId; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 2], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 3].Value = positionTaskToDept.Designation; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 3], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 4].Value = positionTaskToDept.Name; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 4], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 5].Value = $"{positionTaskToDept.Profile} {positionTaskToDept.StandartSize}"; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 5], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 6].Value = positionTaskToDept.Length; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 6], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 7].Value = positionTaskToDept.Width; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 7], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 8].Value = positionTaskToDept.MarkSteal; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 8], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 9].Value = positionTaskToDept.CountDetails; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 9], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 10].Value = positionTaskToDept.Weight; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 10], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 11].Value = string.Empty; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 11], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 12].Value = string.Empty; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 12], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 13].Value = positionTaskToDept.NextRoute; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 13], ExcelBorderStyle.Thin); workSheet.Cells[countRowExcel, 14].Value = positionTaskToDept.CountDetails * positionTaskToDept.Length; SetStyleToAllLinesSquare(workSheet.Cells[countRowExcel, 14], ExcelBorderStyle.Thin); countRowExcel++; } } workSheet.Cells[countRowExcel, 14].Formula = $"SUM(N3:N{countRowExcel - 1})"; workSheet.Cells[countRowExcel, 14].Calculate(); workSheet.Cells[countRowExcel + 2, 8, countRowExcel + 2, 9].Merge = true; workSheet.Cells[countRowExcel + 2, 8, countRowExcel + 2, 9].Value = "Задание выдал:"; workSheet.Cells[countRowExcel + 2, 10, countRowExcel + 2, 14].Merge = true; }
public void Save(SuperTaskToDistrict task) { _dataManager.InsertOrUpdate(task); }