Advertisement
Guest User

Untitled

a guest
Oct 7th, 2015
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.60 KB | None | 0 0
  1. public class WorkOrder1
  2. {
  3. public int Id { get; set; }
  4. public string Accepter { get; set; }
  5. public string Foreman { get; set; }
  6. public string myDate { get; set; }
  7. public ICollection<GuideWorkTypeStandardHour1> GuideWorkTypeStandardHour1s { get; set; }
  8. public WorkOrder1()
  9. {
  10. GuideWorkTypeStandardHour1s = new List<GuideWorkTypeStandardHour1>();
  11. }
  12. }
  13.  
  14. public class GuideWorkTypeStandardHour1
  15. {
  16. public int Id { get; set; }
  17. public string CodeWork { get; set; }
  18. public ICollection<WorkOrder1> WorkOrder1s { get; set; }
  19. public GuideWorkTypeStandardHour1()
  20. {
  21. WorkOrder1s = new List<WorkOrder1>();
  22. }
  23.  
  24. }
  25.  
  26. private void button1_Click_1(object sender, EventArgs e)
  27. {
  28. WorkOrder1 wo = new WorkOrder1();
  29. wo.myDate = maskedTextBoxData.Text;
  30. wo.Accepter = textBoxAccepter.Text;
  31. wo.Foreman = textBoxForeman.Text;
  32. wo.BestPractice = textBox4Recommendation.Text;
  33.  
  34. db.WorkOrders.Add(wo);
  35. db.SaveChanges();
  36.  
  37. }
  38.  
  39. List<GuideWorkTypeStandardHour1> guideWorkTypeStandardHour1;
  40. WorkOrder1 workOrder1 = db.WorkOrders.Find(ListWorkOrders.workorderselectedId);
  41.  
  42. var works = db.GuideWorkTypeStandardHour1s;
  43.  
  44. foreach(var w in works)
  45. {
  46. if(workOrder1.GuideWorkTypeStandardHour1s.Contains(w))
  47. {
  48. guideWorkTypeStandardHour1.Add(w);
  49. }
  50. }
  51.  
  52. public class WorkOrder1
  53. {
  54. public int Id { get; set; }
  55. public string Accepter { get; set; }
  56. public string Foreman { get; set; }
  57. public string myDate { get; set; }
  58.  
  59. [ForeignKey("Id")]
  60. public virtual ICollection<GuideWorkTypeStandardHour1> GuideWorkTypeStandardHour1s { get; set; }
  61. public WorkOrder1()
  62. {
  63. GuideWorkTypeStandardHour1s = new List<GuideWorkTypeStandardHour1>();
  64. }
  65. }
  66.  
  67. public class GuideWorkTypeStandardHour1
  68. {
  69. public int Id { get; set; }
  70. public string CodeWork { get; set; }
  71.  
  72. [ForeignKey("Id")]
  73. public virtual ICollection<WorkOrder1> WorkOrder1s { get; set; }
  74. public GuideWorkTypeStandardHour1()
  75. {
  76. WorkOrder1s = new List<WorkOrder1>();
  77. }
  78. }
  79.  
  80. public virtual ICollection<GuideWorkTypeStandardHour1> GuideWorkTypeStandardHour1s { get; set; }
  81.  
  82. var order = db.WorkOrder
  83. .Where(x=>x.Id==512)
  84. .Include(x=>x.GuideWorkTypeStandardHour1s);
  85.  
  86. var order = db.WorkOrder
  87. .Where(x=>x.Id==512)
  88. .Include("GuideWorkTypeStandardHour1s");
  89.  
  90. [ForeignKey("Id")]
  91. public virtual ICollection<GuideWorkTypeStandardHour1> GuideWorkTypeStandardHour1s { get; set; }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement