public static object[] GetPriceSheetMeterLineItemFields(PriceSheetMeter lineItem) { List <object> fields = new List <object>(); fields.Add(lineItem.id); fields.Add(lineItem.billingPeriodId); fields.Add(lineItem.meterId); fields.Add(lineItem.meterName); fields.Add(lineItem.meterRegion); fields.Add(lineItem.unitOfMeasure); fields.Add(lineItem.includedQuantity); fields.Add(lineItem.partNumber); fields.Add(lineItem.unitPrice); fields.Add(lineItem.currencyCode); return(fields.ToArray()); }
public static void WritePriceSheetMeterLineItem(int startColumnNumber, int rowNumber, PriceSheetMeter meterItem, int numberOfColumns, Microsoft.Office.Interop.Excel.Worksheet activeWorksheet) { Microsoft.Office.Interop.Excel.Range c1 = (Microsoft.Office.Interop.Excel.Range)activeWorksheet.Cells[rowNumber, startColumnNumber]; Microsoft.Office.Interop.Excel.Range c2 = (Microsoft.Office.Interop.Excel.Range)activeWorksheet.Cells[rowNumber, startColumnNumber + numberOfColumns - 1]; Microsoft.Office.Interop.Excel.Range currentRow = activeWorksheet.get_Range(c1, c2); currentRow.Value2 = BillingUtils.GetPriceSheetMeterLineItemFields(meterItem); }