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 NewD33_UD() { EmptyDocument emptyD33_UD = emptyDocumentsFactory.GetD33_UDEmptyDocument(); emptyD33_UD.NewDocument(); emptyD33_UD.InitFormatCells(); emptyD33_UD.Format(); }
public void NewVP() { EmptyDocument emptyVP = emptyDocumentsFactory.GetVPEmptyDocument(); emptyVP.NewDocument(); emptyVP.InitFormatCells(); emptyVP.Format(); }
public void NewSpecification() { EmptyDocument emptySpec = emptyDocumentsFactory.GetSpecificationEmptyDocument(); emptySpec.NewDocument(); emptySpec.InitFormatCells(); emptySpec.Format(); }
public void NewPE3() { EmptyDocument emptyPE3 = emptyDocumentsFactory.GetPE3EmptyDocument(); emptyPE3.NewDocument(); emptyPE3.InitFormatCells(); emptyPE3.Format(); }
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(); }