Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.96 KB | None | 0 0
  1. cvMesFicFin cvAnoFicFin cvVlrBasFicFin
  2. 08 1998 30
  3. 09 1998 30
  4. 10 1998 30
  5. 11 1998 30
  6. 12 1998 30
  7. 01 1999 30
  8. 02 1999 30
  9. 03 1999 30
  10. 04 1999 30
  11. 05 1999 30
  12. 06 1999 30
  13.  
  14. Year 01 02 03 04 05 06 07 08 09 10 11 12
  15. 1998 NULL NULL NULL NULL NULL NULL NULL 30 30 30 30 30
  16. 1999 30 30 30 30 30 30 NULL NULL NULL NULL NULL NULL
  17.  
  18. var r = a.GroupBy(e => e.cvAnoFicFin).Select(g => new
  19. {
  20. Year = g.Key,
  21. Jan = g.Where(e => e.cvMesFicFin == 1)
  22. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  23. Feb = g.Where(e => e.cvMesFicFin == 2)
  24. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  25. Mar = g.Where(e => e.cvMesFicFin == 3)
  26. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  27. Apr = g.Where(e => e.cvMesFicFin == 4)
  28. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  29. May = g.Where(e => e.cvMesFicFin == 5)
  30. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  31. Jun = g.Where(e => e.cvMesFicFin == 6)
  32. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  33. Jul = g.Where(e => e.cvMesFicFin == 7)
  34. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  35. Aug = g.Where(e => e.cvMesFicFin == 8)
  36. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  37. Sep = g.Where(e => e.cvMesFicFin == 9)
  38. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  39. Oct = g.Where(e => e.cvMesFicFin == 10)
  40. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  41. Nov = g.Where(e => e.cvMesFicFin == 11)
  42. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault(),
  43. Dec = g.Where(e => e.cvMesFicFin == 12)
  44. .Select(c => (int?)c.cvVlrBasFicFin).SingleOrDefault()
  45. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement