private int createInvoiceTotals(InvoiceDS.InvoiceTotalTableRow total, int row0)
{
//Get worksheet
int _rows = 0;
Invoice invoice = global::Argix.Finance.Globals.Invoice;
//Header
_rows += 4;
Excel.Range r = invoice.get_Range(invoice.Cells[row0 + 1, 1], invoice.Cells[row0 + 1, 12]);
r.Borders[Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeTop].Color = Color.Black.ToArgb();
invoice.get_Range(invoice.Cells[row0 + 1, 2], invoice.Cells[row0 + 1, 12]).Value2 = new object[1, 11] {
{ "Invoice Total", "", "", "", "", "", "", "", "", "", "" }
};
invoice.get_Range(invoice.Cells[row0 + 1, 2], invoice.Cells[row0 + 1, 2]).Font.Bold = true;
invoice.get_Range(invoice.Cells[row0 + 2, 2], invoice.Cells[row0 + 2, 12]).Value2 = new object[1, 11] {
{ "", "", "", "", "", "", "", "", "", "", "" }
};
invoice.get_Range(invoice.Cells[row0 + 3, 2], invoice.Cells[row0 + 3, 12]).Value2 = new object[1, 11] {
{ "", "", "", "Inland", "Distribution", "Total", "", "", "", "", "" }
};
r = invoice.get_Range(invoice.Cells[row0 + 4, 2], invoice.Cells[row0 + 4, 12]);
r.Value2 = new object[1, 11] {
{ "Cartons", "Weight(kg)", "Weight(lbs)", "Charges", "Charges", "Charges", "", "", "", "", "" }
};
r.Borders[Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeBottom].Color = Color.Black.ToArgb();
//Set named range summary values
_rows += 1;
object[,] totals = new object[1, 6];
totals[0, 0] = total.Cartons;
totals[0, 1] = total.WeightKg;
totals[0, 2] = total.Weight;
totals[0, 3] = total.InlandCharges;
totals[0, 4] = total.DistributionCharges;
totals[0, 5] = total.TotalCharges;
invoice.get_Range(invoice.Cells[row0 + 5, 2], invoice.Cells[row0 + 5, 7]).Value2 = totals;
invoice.get_Range(invoice.Cells[row0 + 5, 2], invoice.Cells[row0 + 5, 2]).NumberFormat = "#,##0";
invoice.get_Range(invoice.Cells[row0 + 5, 3], invoice.Cells[row0 + 5, 3]).NumberFormat = "#,##0.00";
invoice.get_Range(invoice.Cells[row0 + 5, 4], invoice.Cells[row0 + 5, 4]).NumberFormat = "#,##0";
invoice.get_Range(invoice.Cells[row0 + 5, 5], invoice.Cells[row0 + 5, 5]).NumberFormat = "$#,##0.00_);($#,##0.00)";
invoice.get_Range(invoice.Cells[row0 + 5, 6], invoice.Cells[row0 + 5, 6]).NumberFormat = "$#,##0.00_);($#,##0.00)";
invoice.get_Range(invoice.Cells[row0 + 5, 7], invoice.Cells[row0 + 5, 7]).NumberFormat = "$#,##0.00_);($#,##0.00)";
return(_rows);
}
private void createInvoiceHeader(string invoiceNumber, InvoiceDS.InvoiceTotalTableRow total)
{
Invoice invoice = global::Argix.Finance.Globals.Invoice;
//Remit To
invoice.RemitToName.Value = total.RemitToName.Trim();
invoice.RemitToAddressLine1.Value = total.RemitToAddressLine1.Trim();
invoice.RemitToAddressLine2.Value = total.IsRemitToAddressLine2Null() ? "" : total.RemitToAddressLine2.Trim();
invoice.RemitToCityStateZip.Value = total.RemitToCity.Trim() + ", " + total.RemitToState.Trim() + " " + total.RemitToZip.Trim() + "-" + total.RemitToZip4;
invoice.Telephone.Value = (total.IsTelephoneNull() ? "" : total.Telephone.ToString());
//Bill To
invoice.BillToName.Value = "Benetton";
invoice.BillToAddressLine1.Value = invoice.BillToAddressLine2.Value = invoice.BillToCityStateZip.Value = "";
//Account
invoice.InvoiceNumber.Value = invoiceNumber;
invoice.InvoiceDate.Value = total.InvoiceDate;
}
