public void Export(IDocument spec)
{
ExcelHelper.DisableUpdating();
EmptyDocumentsFactory factory = new EmptyDocumentsFactory();
EmptyDocument specEmpty = factory.GetSpecificationEmptyDocument();
specEmpty.NewDocument();
specEmpty.InitFormatCells();
specEmpty.Format();
Excel.Worksheet sheet = specEmpty.getSheet();
int rowNumber = 3;
List <IRow> rows = spec.CombineRows();
foreach (RowSpec row in rows)
{
sheet.Cells[rowNumber, 1] = row.Format;
sheet.Cells[rowNumber, 2] = row.Zone;
sheet.Cells[rowNumber, 3] = row.Position;
sheet.Cells[rowNumber, 4] = row.Designation;
sheet.Cells[rowNumber, 5] = row.Name;
if (row.Quantity != 0)
{
sheet.Cells[rowNumber, 6] = row.Quantity;
}
sheet.Cells[rowNumber, 7] = row.Note;
rowNumber++;
}
ExcelHelper.EnableUpdating();
}
virtual protected void FormatEmptyDocument()
{
EmptyDocumentsFactory factory = new EmptyDocumentsFactory();
EmptyDocument emptyDocument = factory.GetEmptyDocument(sheet);
if (emptyDocument != null)
{
emptyDocument.Format();
}
}
public RibbonController()
{
this.documentsfactory = new DocumentsFactory();
this.emptyDocumentsFactory = new EmptyDocumentsFactory();
this.unformattersFactory = new UnformattersFactory();
this.formattersFactory = new FormattersFactory();
this.drawer = new SheetBordersDrawer();
this.pe3Exporter = new PE3Exporter();
this.specExporter = new SpecificationExporter();
this.vpExporter = new VPExporter();
Globals.ThisAddIn.Application.SheetActivate += Application_SheetActivate;
}
public void Export(IDocument vp)
{
ExcelHelper.DisableUpdating();
EmptyDocumentsFactory factory = new EmptyDocumentsFactory();
EmptyDocument vpEmpty = factory.GetVPEmptyDocument();
vpEmpty.NewDocument();
vpEmpty.InitFormatCells();
vpEmpty.Format();
Excel.Worksheet sheet = vpEmpty.getSheet();
int rowNumber = 4;
List <IRow> rows = vp.CombineRows();
foreach (RowVP row in rows)
{
if (row.RowNumber != 0)
{
sheet.Cells[rowNumber, 1] = row.RowNumber;
}
sheet.Cells[rowNumber, 2] = row.Name;
sheet.Cells[rowNumber, 3] = row.ProductCode;
sheet.Cells[rowNumber, 4] = row.Designation;
sheet.Cells[rowNumber, 5] = row.Supplier;
sheet.Cells[rowNumber, 6] = row.WhereItUsed;
if (row.QuantityProduct != 0)
{
sheet.Cells[rowNumber, 7] = row.QuantityProduct;
}
if (row.QuantitySet != 0)
{
sheet.Cells[rowNumber, 8] = row.QuantitySet;
}
if (row.QuantityAdjustment != 0)
{
sheet.Cells[rowNumber, 9] = row.QuantityAdjustment;
}
if (row.QuantityTotal != 0)
{
sheet.Cells[rowNumber, 10] = row.QuantityTotal;
}
sheet.Cells[rowNumber, 11] = row.Note;
rowNumber++;
}
ExcelHelper.EnableUpdating();
}
