1. C# / Говнокод #5855

    +116

    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    6. 06
    7. 07
    8. 08
    9. 09
    10. 10
    11. 11
    12. 12
    13. 13
    14. 14
    15. 15
    16. 16
    17. 17
    18. 18
    19. 19
    20. 20
    21. 21
    22. 22
    23. 23
    24. 24
    25. 25
    26. 26
    27. 27
    28. 28
    29. 29
    30. 30
    31. 31
    32. 32
    33. 33
    34. 34
    35. 35
    36. 36
    37. 37
    38. 38
    39. 39
    40. 40
    41. 41
    42. 42
    43. 43
    44. 44
    45. 45
    46. 46
    47. 47
    48. 48
    49. 49
    50. 50
    51. 51
    52. 52
    53. 53
    54. 54
    55. 55
    56. 56
    57. 57
    58. 58
    59. 59
    60. 60
    if (rbNewPackage.Checked)
                {
                    var ls = from ent in Program.DB.UserInfos
                             where
                             (from rp in Program.DB.ReceivedPackages
                              join r in Program.DB.RecordBooks on rp.id equals r.id_package
                              where rp.id_user == ent.id &&
                              r.date == (from recb in Program.DB.RecordBooks
                                         join recp in Program.DB.ReceivedPackages on recb.id_package equals recp.id
                                         where recp.id_user == ent.id
                                         select recb.date).Max() && r.id_status == 1
                              select rp).Count() != 0
                             select ent;
                    grdEntrantList.DataSource = Program.DB.UserInfos.Where(t => ls.ToList().Contains(t));
                }
                else if (rbCancelled.Checked)
                {
                    var ls = from ent in Program.DB.UserInfos
                             where
                             (from rp in Program.DB.ReceivedPackages
                              join r in Program.DB.RecordBooks on rp.id equals r.id_package
                              where rp.id_user == ent.id &&
                              r.date == (from recb in Program.DB.RecordBooks
                                         join recp in Program.DB.ReceivedPackages on recb.id_package equals recp.id
                                         where recp.id_user == ent.id
                                         select recb.date).Max() && r.id_status == 5
                              select rp).Count() != 0
                             select ent;
                    grdEntrantList.DataSource = Program.DB.UserInfos.Where(t => ls.ToList().Contains(t));
                }
                else if (rbConditional.Checked)
                {
                    var ls = from ent in Program.DB.UserInfos
                             where
                             (from rp in Program.DB.ReceivedPackages
                              join r in Program.DB.RecordBooks on rp.id equals r.id_package
                              where rp.id_user == ent.id &&
                              r.date == (from recb in Program.DB.RecordBooks
                                         join recp in Program.DB.ReceivedPackages on recb.id_package equals recp.id
                                         where recp.id == rp.id
                                         select recb.date).Max() && r.id_status == 3
                              select rp).Count() != 0
                             select ent;
                    grdEntrantList.DataSource = Program.DB.UserInfos.Where(t => ls.ToList().Contains(t));
                }
                else if (rbOfficial.Checked)
                {
                    var ls = from ent in Program.DB.UserInfos
                             where
                             (from rp in Program.DB.ReceivedPackages
                              join r in Program.DB.RecordBooks on rp.id equals r.id_package
                              where rp.id_user == ent.id &&
                              r.date == (from recb in Program.DB.RecordBooks
                                         join recp in Program.DB.ReceivedPackages on recb.id_package equals recp.id
                                         where recp.id == rp.id
                                         select recb.date).Max() && r.id_status == 4
                              select rp).Count() != 0
                             select ent;
                    grdEntrantList.DataSource = Program.DB.UserInfos.Where(t => ls.ToList().Contains(t));
                }

    говногод моего бывшего коллеги по работе))

    Запостил: slavenin, 02 Марта 2011

    Комментарии (14) RSS

    Добавить комментарий