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();
}
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();
}