Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. Detalhes = new List<DetalhesExcel>() {
  2. new DetalhesExcel()
  3. {
  4. NumColunaInicial = 23,
  5. Coluna1 = "Representante",
  6. Coluna2 = "ValorRepasse",
  7. Coluna3 = "KmRepasse"
  8. }
  9. }.AddRange(ocorrencias.Where(x => x.Conclusao != "PRÓPRIO")
  10. .GroupBy(x => x.Representante)
  11. .Select(x => new DetalhesExcel
  12. {
  13. NumColunaInicial = 23,
  14. Coluna1 = x.First().Representante,
  15. Coluna2 = x.Sum(y => y.ValorRepasse).ToString(),
  16. Coluna3 = x.Sum(y => y.KmRepasse).ToString()
  17. }).ToList())
  18.  
  19. public class DetalhesExcel
  20. {
  21. public int NumColunaInicial { get; set; }
  22. public string Coluna1 { get; set; }
  23. public string Coluna2 { get; set; }
  24. public string Coluna3 { get; set; }
  25. public string Coluna4 { get; set; }
  26. public string Coluna5 { get; set; }
  27. }
  28.  
  29. Detalhes = new List<DetalhesExcel>() {
  30. new DetalhesExcel()
  31. {
  32. NumColunaInicial = 23,
  33. Coluna1 = "Representante",
  34. Coluna2 = "ValorRepasse",
  35. Coluna3 = "KmRepasse"
  36. }
  37. };
  38.  
  39. Detalhes.AddRange(ocorrencias.Where(x => x.Conclusao != "PRÓPRIO")
  40. .GroupBy(x => x.Representante)
  41. .Select(x => new DetalhesExcel
  42. {
  43. NumColunaInicial = 23,
  44. Coluna1 = x.First().Representante,
  45. Coluna2 = x.Sum(y => y.ValorRepasse).ToString(),
  46. Coluna3 = x.Sum(y => y.KmRepasse).ToString()
  47. }).ToList())
  48.  
  49. Detalhes = new List<DetalhesExcel>() {
  50. new DetalhesExcel()
  51. {
  52. NumColunaInicial = 23,
  53. Coluna1 = "Representante",
  54. Coluna2 = "ValorRepasse",
  55. Coluna3 = "KmRepasse"
  56. }
  57. };
  58. Detalhes.AddRange(ocorrencias.Where(x => x.Conclusao != "PRÓPRIO")
  59. .GroupBy(x => x.Representante)
  60. .Select(x => new DetalhesExcel
  61. {
  62. NumColunaInicial = 23,
  63. Coluna1 = x.First().Representante,
  64. Coluna2 = x.Sum(y => y.ValorRepasse).ToString(),
  65. Coluna3 = x.Sum(y => y.KmRepasse).ToString()
  66. }).ToList())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement