private void button3_Click(object sender, RoutedEventArgs e) { Team team = this.grd_TeamMgt.SelectedItem as Team; if (team != null) { RanceEntities entites = new RanceEntities(); team = (from r in entites.Team where r.ID == team.ID select r).SingleOrDefault(); foreach (var item in team.TeamRole.ToArray()) entites.DeleteObject(item); entites.DeleteObject(team); entites.SaveChanges(); fresh(); } }
private void save(RanceEntities entites, Team team) { foreach (var item in team.TeamRole.ToArray()) entites.DeleteObject(item); if (team.第一排前列 != null && team.第一排前列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第一排前列.ID, 列 = 1, 排 = 1, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } if (team.第一排中列 != null && team.第一排中列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第一排中列.ID, 列 = 2, 排 = 1, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } if (team.第一排后列 != null && team.第一排后列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第一排后列.ID, 列 = 3, 排 = 1, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } if (team.第二排前列 != null && team.第二排前列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第二排前列.ID, 列 = 1, 排 = 2, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } if (team.第二排中列 != null && team.第二排中列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第二排中列.ID, 列 = 2, 排 = 2, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } if (team.第二排后列 != null && team.第二排后列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第二排后列.ID, 列 = 3, 排 = 2, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } if (team.第三排前列 != null && team.第三排前列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第三排前列.ID, 列 = 1, 排 = 3, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } if (team.第三排中列 != null && team.第三排中列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第三排中列.ID, 列 = 2, 排 = 3, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } if (team.第三排后列 != null && team.第三排后列.ID != Guid.Empty) { TeamRole teamRole = new TeamRole() { ID = Guid.NewGuid(), RoleID = team.第三排后列.ID, 列 = 3, 排 = 3, TeamID = team.ID, }; entites.TeamRole.AddObject(teamRole); } entites.SaveChanges(); }