Guest User

Untitled

a guest
Jan 17th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.81 KB | None | 0 0
  1. public IList<Abastecimento> Resumo(DateTime dataInicio, DateTime dataFinal)
  2. {
  3. string hql = "SELECT NumCarroId, DtAbastecido FROM Abastecimento a WHERE a.DtAbastecido Between :dataInicial AND :dataFinal GROUP BY a.NumCarroId";
  4. IQuery query = session.CreateQuery(hql)
  5. .SetParameter("dataInicial", dataInicio)
  6. .SetParameter("dataFinal", dataFinal);
  7. return query.List<Abastecimento>();
  8. }
  9.  
  10. CREATE TABLE [dbo].[Abastecimento] (
  11. [Id] INT IDENTITY (1, 1) NOT NULL,
  12. [DtAbastecido] DATETIME NULL,
  13. [Litro] INT NULL,
  14. [VlrUnit] DECIMAL (18, 2) NULL,
  15. [TotalGasto] DECIMAL (18, 2) NULL,
  16. [AutorId] INT NULL,
  17. [NumCarroId] INT NULL,
  18. [Km] INT NULL,
  19. [NomeProdutoId] INT NULL,
  20. [Km_Andado] INT NULL,
  21. PRIMARY KEY CLUSTERED ([Id] ASC),
  22. CONSTRAINT [FK84286500787E6DCB] FOREIGN KEY ([AutorId]) REFERENCES [dbo].[Usuario] ([Id]),
  23. CONSTRAINT [FK842865002F58EAD8] FOREIGN KEY ([NumCarroId]) REFERENCES [dbo].[Veiculo] ([Id]),
  24. CONSTRAINT [FK8428650023D2F9D9] FOREIGN KEY ([NomeProdutoId]) REFERENCES [dbo].[Compra] ([Id])
  25. );
  26.  
  27. public class Abastecimento {
  28. public virtual int Id {
  29. get;
  30. set;
  31. }
  32. [Required]
  33. public virtual int Litro {
  34. get;
  35. set;
  36. }
  37. public virtual DateTime ? DtAbastecido {
  38. get;
  39. set;
  40. }
  41. public virtual decimal VlrUnit {
  42. get;
  43. set;
  44. }
  45. public virtual int Km {
  46. get;
  47. set;
  48. }
  49. public virtual decimal TotalGasto {
  50. get;
  51. set;
  52. }
  53. public virtual int Km_Andado {
  54. get;
  55. set;
  56. }
  57. public virtual Usuario Autor {
  58. get;
  59. set;
  60. }
  61. public virtual Compra NomeProduto {
  62. get;
  63. set;
  64. }
  65. public virtual Veiculo NumCarro {
  66. get;
  67. set;
  68. }
  69. }
  70. }
  71.  
  72. select numCarroId, sum(valorGasto) gastos from Abastecimento
  73. where dataAbastecimento between '2017-05-21' and '2017-11-13'
  74. group by numCarroId
  75.  
  76. public class Abastecimento {
  77. public virtual int Id {
  78. get;
  79. set;
  80. }
  81. [Required]
  82. public virtual int Litro {
  83. get;
  84. set;
  85. }
  86. public virtual DateTime ? DtAbastecido {
  87. get;
  88. set;
  89. }
  90. public virtual decimal VlrUnit {
  91. get;
  92. set;
  93. }
  94. public virtual int Km {
  95. get;
  96. set;
  97. }
  98. public virtual decimal TotalGasto {
  99. get;
  100. set;
  101. }
  102. public virtual int Km_Andado {
  103. get;
  104. set;
  105. }
  106. public virtual Usuario Autor {
  107. get;
  108. set;
  109. }
  110. public virtual Compra NomeProduto {
  111. get;
  112. set;
  113. }
  114. public virtual Veiculo NumCarro {
  115. get;
  116. set;
  117. }
  118. }
  119. }
  120.  
  121. public IList < Abastecimento > Resumo(DateTime dataInicio, DateTime dataFinal) {
  122. string hql = "select a.NumCarro, sum(a.TotalGasto) gastos from Abastecimento a WHERE a.DtAbastecido Between :dataInicial AND :dataFinal GROUP BY a.NumCarro";
  123. IQuery query = session.CreateQuery(hql)
  124. .SetParameter("dataInicial", dataInicio)
  125. .SetParameter("dataFinal", dataFinal);
  126. return query.List < Abastecimento > ();
  127. }
Add Comment
Please, Sign In to add comment