frmPrincipalInicio.vb 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. Public Class frmPrincipalInicio
  2. Private Sub frmPrincipalInicio_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  3. Listas()
  4. End Sub
  5. Sub Fuente()
  6. lblTitulo.ForeColor = Drawing.Color.FromArgb(15, 151, 208)
  7. lblRendimiento.ForeColor = Drawing.Color.FromArgb(15, 151, 208)
  8. lblIngreso.ForeColor = Drawing.Color.FromArgb(15, 151, 208)
  9. lblPortafolio.ForeColor = Drawing.Color.FromArgb(15, 151, 208)
  10. lblMontoIngresos.ForeColor = Drawing.Color.FromArgb(237, 51, 50)
  11. lblIngresostexto.ForeColor = Drawing.Color.FromArgb(15, 151, 208)
  12. lblMontoRendimiento.ForeColor = Drawing.Color.FromArgb(237, 51, 50)
  13. lblRendimientotexto.ForeColor = Drawing.Color.FromArgb(15, 151, 208)
  14. End Sub
  15. Sub RendimientoMonto()
  16. Dim general As New DAOGeneral
  17. Dim Monto As String = "0.00"
  18. Dim Cantidad As Integer = 0
  19. Dim Rendimiento As String = "0.00 "
  20. Dim dt As DataTable = general.RendimientoMontoGraficas
  21. For Each rows As DataRow In dt.Rows
  22. If Not String.IsNullOrEmpty(rows("Rendimiento").ToString) Then
  23. Rendimiento = rows("Rendimiento").ToString
  24. End If
  25. If Not String.IsNullOrEmpty(rows("Monto").ToString) Then
  26. Monto = rows("Monto").ToString
  27. End If
  28. If Not String.IsNullOrEmpty(rows("Cantidad").ToString) Then
  29. Cantidad = rows("Cantidad")
  30. End If
  31. Next
  32. lblMontoIngresos.Text = "$ " + Monto
  33. If Cantidad = 0 Then
  34. lblMontoRendimiento.Text = "0 %"
  35. Else
  36. lblMontoRendimiento.Text = FormatNumber((((CDec(Rendimiento) / Cantidad)) * 100), 6).ToString + " %"
  37. End If
  38. End Sub
  39. Sub GraficaInstrumentos()
  40. Dim general As New DAOGeneral
  41. Dim dt As DataTable = general.InstrumentosGrafica
  42. charPastel.Series(0).Points.Clear()
  43. charPastel.Series(0).IsValueShownAsLabel = False
  44. charPastel.Series(0).LabelForeColor = Color.Transparent
  45. 'charPastel.Series(0).LabelAngle = -45
  46. 'charPastel.Series(0).Font = New Font(charPastel.Series(0).Font.Name, 5)
  47. 'charPastel.ChartAreas(0).Area3DStyle.Enable3D = True
  48. charPastel.Series(0).XValueMember = "Instrumento"
  49. charPastel.Series(0).YValueMembers = "Cantidad"
  50. charPastel.DataSource = dt
  51. End Sub
  52. Sub GraficaMontoInstrumentos()
  53. Dim general As New DAOGeneral
  54. Dim dt As DataTable = general.MontosInstrumentosGrafica
  55. charbarras.Series(0).Points.Clear()
  56. 'charbarras.ChartAreas(0).Area3DStyle.Enable3D = True
  57. charbarras.Series(0).XValueMember = "Instrumento"
  58. charbarras.Series(0).YValueMembers = "Suma"
  59. charbarras.DataSource = dt
  60. End Sub
  61. Sub GraficaRendimientoInstrumentos()
  62. Dim general As New DAOGeneral
  63. Dim dt As DataTable = general.RendimientosInstrumentoGrafica
  64. charlineal.Series(0).Points.Clear()
  65. charlineal.Series(0).XValueMember = "Instrumento"
  66. charlineal.Series(0).YValueMembers = "Suma"
  67. charlineal.DataSource = dt
  68. End Sub
  69. Sub Listas()
  70. Fuente()
  71. GraficaInstrumentos()
  72. GraficaMontoInstrumentos()
  73. GraficaRendimientoInstrumentos()
  74. RendimientoMonto()
  75. End Sub
  76. Private Sub charlineal_Click(sender As Object, e As EventArgs) Handles charlineal.Click
  77. End Sub
  78. Private Sub pnlRendimientoTotal_Paint(sender As Object, e As PaintEventArgs) Handles pnlRendimientoTotal.Paint
  79. End Sub
  80. Private Sub TableLayoutPanel2_Paint(sender As Object, e As PaintEventArgs) Handles TableLayoutPanel2.Paint
  81. End Sub
  82. End Class