Guest User

Untitled

a guest
Dec 15th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. Public Class clsMaquinario
  2.  
  3. Private _container As String
  4. Private _statusMaq As String
  5. Private _usuario As String
  6. Private _data As String
  7.  
  8. Public Property Container() As String
  9. Get
  10. Return _container
  11. End Get
  12. Set(ByVal value As String)
  13. _container = value
  14. End Set
  15. End Property
  16.  
  17. Public Property StatusMaq() As String
  18. Get
  19. Return _statusMaq
  20. End Get
  21. Set(ByVal value As String)
  22. _statusMaq = value
  23. End Set
  24. End Property
  25.  
  26. Public Property Usario() As String
  27. Get
  28. Return _usuario
  29. End Get
  30. Set(ByVal value As String)
  31. _usuario = value
  32. End Set
  33. End Property
  34.  
  35. Public Property Data() As String
  36. Get
  37. Return _data
  38. End Get
  39. Set(ByVal value As String)
  40. _data = value
  41. End Set
  42. End Property
  43.  
  44.  
  45. End Class
  46.  
  47. Function LIB_VAZIO_EXPORTACAO_INTERNO(ByVal Container As String) As clsLibVazioExportacao
  48.  
  49. Dim StrSql As String
  50. Dim libVazio As New clsLibVazioExportacao
  51. Dim rscmdAux As SqlClient.SqlDataReader
  52. Dim acessa As New AcessoDAO.Banco
  53.  
  54. Try
  55. StrSql = ""
  56. StrSql = StrSql & "Select Cod_Armador, Nome_Armador, Conteiner, Tipo_Iso, "
  57. StrSql = StrSql & "Tipo, Tara, Mgw, N_Booking, N_Lacre, Cod_Porto, "
  58. StrSql = StrSql & "Nome_Porto, Dt_Saida, Nome_Exportador, Num_Intercambio "
  59. StrSql = StrSql & "from v_lib_exportacao_interno "
  60. StrSql = StrSql & "where Conteiner = '" & Container & "'"
  61.  
  62. rscmdAux = acessa.RetornaDataReader(StrSql)
  63.  
  64. ............
  65.  
  66. Return libVazio
  67.  
  68. End Function
Add Comment
Please, Sign In to add comment