Advertisement
Guest User

Untitled

a guest
Dec 28th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.84 KB | None | 0 0
  1. var role = _ew.Query<Function>().Where(m => m.Roles.Any(r => r.Title == "admin")).ToList();
  2.  
  3. public class Function
  4. {
  5. public int Id { get; set; }
  6. public string Title { get; set; }
  7. public string Action { get; set; }
  8. public string Controller { get; set; }
  9. public string Icon { get; set; }
  10. public virtual Function Parent { get; set; }
  11. public virtual ICollection<Function> Functions { get; set; }
  12. public int Depth { get; set; }
  13. public virtual ICollection<Role> Roles { get; set; }
  14. }
  15.  
  16. public class Role
  17. {
  18. public int Id { get; set; }
  19. public string Title { get; set; }
  20. public virtual ICollection<Member> Members { get; set; }
  21. public virtual ICollection<Function> Functions { get; set; }
  22. }
  23. public class Member
  24. {
  25. public int Id { get; set; }
  26. public string UserName { get; set; }
  27. public string Password { get; set; }
  28. public virtual Role Role { get; set; }
  29.  
  30. }
  31.  
  32. var roles = new List<Role>
  33. {
  34. new Role {Title = "admin"},
  35. new Role {Title = "wubo"}
  36. };
  37. context.Roles.AddOrUpdate(m => m.Title, roles.ToArray());
  38. context.SaveChanges();
  39.  
  40. var admin = context.Roles.FirstOrDefault(m => m.Title == "admin");
  41. var wubo = context.Roles.FirstOrDefault(m => m.Title == "wubo");
  42.  
  43. var funcs = new List<Function>
  44. {
  45. new Function
  46. {
  47. Title = "admin",
  48. Roles = new List<Role> {admin},
  49. Functions = new List<Function>
  50. {
  51. new Function
  52. {
  53. Title = "admin1",
  54. Roles = new List<Role> {admin},
  55. Functions = new List<Function>
  56. {
  57. new Function {Title = "admin", Roles = new List<Role> {admin}},
  58. new Function {Title = "admin", Roles = new List<Role> {admin}},
  59. new Function {Title = "wubo", Roles = new List<Role> {wubo}},
  60. new Function {Title = "admin", Roles = new List<Role> {admin}},
  61. new Function {Title = "wubo1", Roles = new List<Role> {wubo}},
  62. }
  63. },
  64. new Function {Title = "admin", Roles = new List<Role> {admin}},
  65. new Function {Title = "admin", Roles = new List<Role> {admin}},
  66. new Function {Title = "wubo6", Roles = new List<Role> {wubo}},
  67. new Function {Title = "admin", Roles = new List<Role> {admin}},
  68. new Function {Title = "admin", Roles = new List<Role> {admin}},
  69. }
  70. },
  71. new Function {Title = "admin", Roles = new List<Role> {admin}},
  72. new Function {Title = "admin", Roles = new List<Role> {admin}},
  73. new Function {Title = "admin", Roles = new List<Role> {admin}},
  74. new Function {Title = "wubo2", Roles = new List<Role> {wubo}},
  75. new Function {Title = "admin", Roles = new List<Role> {admin}},
  76. new Function {Title = "wubo3", Roles = new List<Role> {wubo}},
  77. new Function {Title = "wubo4", Roles = new List<Role> {wubo}},
  78. new Function {Title = "wubo5", Roles = new List<Role> {wubo}},
  79. new Function {Title = "admin", Roles = new List<Role> {admin}}
  80. };
  81. context.Functions.AddOrUpdate(m => m.Title, funcs.ToArray());
  82. context.SaveChanges();
  83.  
  84. var member = new List<Member>
  85. {
  86. new Member {UserName = "admin", Password = "000", Role = admin},
  87. new Member {UserName = "wubo", Password = "000", Role = wubo}
  88. };
  89. context.Members.AddOrUpdate(m => m.UserName, member.ToArray());
  90. context.SaveChanges();
  91.  
  92. var funcs = _ew.Query<Role>().Where(m => m.Title == "admin").Select(a => a.Functions).ToList();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement