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();
}
