Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Detalhes = new List<DetalhesExcel>() {
- new DetalhesExcel()
- {
- NumColunaInicial = 23,
- Coluna1 = "Representante",
- Coluna2 = "ValorRepasse",
- Coluna3 = "KmRepasse"
- }
- }.AddRange(ocorrencias.Where(x => x.Conclusao != "PRÓPRIO")
- .GroupBy(x => x.Representante)
- .Select(x => new DetalhesExcel
- {
- NumColunaInicial = 23,
- Coluna1 = x.First().Representante,
- Coluna2 = x.Sum(y => y.ValorRepasse).ToString(),
- Coluna3 = x.Sum(y => y.KmRepasse).ToString()
- }).ToList())
- public class DetalhesExcel
- {
- public int NumColunaInicial { get; set; }
- public string Coluna1 { get; set; }
- public string Coluna2 { get; set; }
- public string Coluna3 { get; set; }
- public string Coluna4 { get; set; }
- public string Coluna5 { get; set; }
- }
- Detalhes = new List<DetalhesExcel>() {
- new DetalhesExcel()
- {
- NumColunaInicial = 23,
- Coluna1 = "Representante",
- Coluna2 = "ValorRepasse",
- Coluna3 = "KmRepasse"
- }
- };
- Detalhes.AddRange(ocorrencias.Where(x => x.Conclusao != "PRÓPRIO")
- .GroupBy(x => x.Representante)
- .Select(x => new DetalhesExcel
- {
- NumColunaInicial = 23,
- Coluna1 = x.First().Representante,
- Coluna2 = x.Sum(y => y.ValorRepasse).ToString(),
- Coluna3 = x.Sum(y => y.KmRepasse).ToString()
- }).ToList())
- Detalhes = new List<DetalhesExcel>() {
- new DetalhesExcel()
- {
- NumColunaInicial = 23,
- Coluna1 = "Representante",
- Coluna2 = "ValorRepasse",
- Coluna3 = "KmRepasse"
- }
- };
- Detalhes.AddRange(ocorrencias.Where(x => x.Conclusao != "PRÓPRIO")
- .GroupBy(x => x.Representante)
- .Select(x => new DetalhesExcel
- {
- NumColunaInicial = 23,
- Coluna1 = x.First().Representante,
- Coluna2 = x.Sum(y => y.ValorRepasse).ToString(),
- Coluna3 = x.Sum(y => y.KmRepasse).ToString()
- }).ToList())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement