Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.35 KB | None | 0 0
  1. vTable.AddCell(AddNewTextCell(True, "REVENUE", 15, ReportFontSize, False))
  2. vTable.AddCell(Spacer_Cell(10, 15))
  3.  
  4. For Each Row As DataRow In RevenueData
  5. Dim vInnerTable As New PdfPTable(15)
  6. vInnerTable.KeepTogether = True
  7.  
  8. Dim vCatID As Integer = Row("ID")
  9. vInnerTable.AddCell(AddNewTextCell(True, Row("Name"), 15, ReportFontSize, False))
  10. Dim vSelected() As DataRow = RevenueNomDT.Select("CatID = " & vCatID, "Position")
  11.  
  12.  
  13.  
  14. For Each SubRow As DataRow In vSelected
  15. SetLeftPadding = 10
  16. vInnerTable.AddCell(AddNewTextCell(False, SubRow("NomCode") & " " & SubRow("NomName"), 2, ReportFontSize))
  17. Dim NomCode As Integer = SubRow("NomCode")
  18. Dim NegValue As Integer = SubRow("NegValue")
  19. Dim vNeg As Boolean = False
  20. If NegValue = 1 Then
  21. vNeg = True
  22. End If
  23. Dim vNomType As Integer = 0
  24. Dim vTypes() As DataRow = NLCodes.Select("NL_Code = '" & NomCode & "'", Nothing)
  25. For Each NominalRow As DataRow In vTypes
  26. vNomType = NominalRow("Account_Type")
  27. Next
  28.  
  29. SetLeftPadding = 0
  30. '12 Columns of data
  31. For i As Integer = 0 To 11
  32. Dim vNomValue As Decimal = 0
  33. Dim ReportMonth As Integer = DateDiff(DateInterval.Month, ReportStartDate, ReportDate) + 1
  34. If ReportMonth > i Then
  35. If vNomType = 2 Then
  36. vNomValue = ReturnMonthlyAmount(i, NomCode, True, ReportStartDate, ReportEndDate, Current_HOA_ID, vNeg)
  37. Else
  38. vNomValue = ReturnMonthlyAmount(i, NomCode, False, ReportStartDate, ReportEndDate, Current_HOA_ID, vNeg)
  39. End If
  40.  
  41. RT += vNomValue
  42. GT = DicRevenue.Item(i)
  43. DicRevenue.Item(i) = GT + vNomValue
  44. Dim vAmt As Decimal = DicSubs.Item(i)
  45. DicSubs.Item(i) = vNomValue + vAmt
  46.  
  47. vInnerTable.AddCell(AddNewCurrencyCell(vNomValue, False, False, ReportFontSize))
  48. Else
  49. vInnerTable.AddCell(AddNewCurrencyCell(vNomValue, False, False, ReportFontSize))
  50. End If
  51. Next
  52. vInnerTable.AddCell(AddNewCurrencyCell(RT, False, False, ReportFontSize))
  53. GT = DicRevenue(12)
  54. DicRevenue(12) = GT + RT
  55. DicSubs.Item(12) = RT
  56. RT = 0
  57. Next
  58.  
  59. SetLeftPadding = 5
  60.  
  61. 'Add the total of each revenue sub header
  62. vInnerTable.AddCell(AddNewTextCell(True, "Total " & Row("Name"), 2, ReportFontSize, False))
  63. For i As Integer = 0 To 11
  64. vInnerTable.AddCell(AddNewCurrencyCell(DicSubs.Item(i), True, True, ReportFontSize, False))
  65. RT += DicSubs.Item(i)
  66. Next
  67.  
  68. vInnerTable.AddCell(AddNewCurrencyCell(RT, True, True, ReportFontSize, False))
  69. vTable.AddCell(NoSplitTable(vInnerTable, 15))
  70.  
  71. 'Remove the DictionaryValues
  72. For i As Integer = 0 To 12
  73. DicSubs(i) = 0
  74. Next
  75. RT = 0
  76. Next
  77.  
  78. vTable.AddCell(Spacer_Cell(10, 15))
  79. 'Add in the Totals For Revenue
  80. vTable.AddCell(AddNewTextCell(True, "TOTAL REVENUE", 2, ReportFontSize, False))
  81. For i As Integer = 0 To 12
  82. vTable.AddCell(AddNewCurrencyCell(DicRevenue.Item(i), True, True, ReportFontSize, False))
  83. Next
  84. GT = 0
  85. RT = 0
  86. vTable.AddCell(Spacer_Cell(20, 15))
  87.  
  88. '============================================START OF EXPENSES ==============================================
  89. vTable.AddCell(AddNewTextCell(True, "EXPENSES", 15, ReportFontSize, False))
  90. vTable.AddCell(Spacer_Cell(10, 15))
  91.  
  92.  
  93. Private Function NoSplitTable(TableName As PdfPTable, DataColumns As Integer) As PdfPCell
  94. Dim vCell As New iTextSharp.text.pdf.PdfPCell(TableName)
  95. Try
  96. With vCell
  97. .Border = 0
  98. .Colspan = DataColumns
  99. End With
  100. Return vCell
  101. Catch ex As Exception
  102. EmailError(ex)
  103. Return vCell
  104. End Try
  105.  
  106. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement