public List <Doctor> QueryDoctorsByTeamAccount(string teamAccount) { using (var db = new GymCompetitionDB()) { return(db.Tb_doctor.Where(m => m.TeamAccount == teamAccount).ToList()); } }
public List <Athlete> QueryAthletesByTeamAccount(string teamAccount) { using (var db = new GymCompetitionDB()) { return(db.Tb_athlete.Where(m => m.TeamAccount == teamAccount).ToList()); } }
//通过 队账号 查找相应的成员 public List <Team> QueryAllTeams() { using (var db = new GymCompetitionDB()) { return(db.Team.ToList()); } }
public List <Leader> QueryLeadersByTeamAccout(string teamAccount) { using (var db = new GymCompetitionDB()) { return(db.Tb_leader.Where(m => m.TeamAccount == teamAccount).ToList()); } }
public List <RefereeScore> QueryRefereeScore() { using (var db = new GymCompetitionDB()) { return(db.Tb_refereeScore.ToList()); } }
public List <GameInformation> SearchGameInfosByItemIdAndGroupNum(string itemId, int groupNum) { using (var db = new GymCompetitionDB()) { return(db.Tb_gameInformation.Where(m => (m.ItemId == itemId) && (m.GroupNumber == groupNum)).ToList()); } }
public List <Item> SearchItemById(string temp) { using (var db = new GymCompetitionDB()) { return(db.Tb_item.Where(m => m.Id == temp).ToList()); } }
public List <GameInformation> QueryGameInformationById() { using (var db = new GymCompetitionDB()) { return(db.Tb_gameInformation.ToList()); } }
public List <Referee> SearchRefereeByIdCard(string temp) { using (var db = new GymCompetitionDB()) { return(db.Tb_referee.Where(m => m.Idcard == temp).ToList()); } }
public List <GameInformation> SearchGameInfoById(string temp) { using (var db = new GymCompetitionDB()) { return(db.Tb_gameInformation.Where(m => m.Id == temp).ToList()); } }
public List <Coach> SearchCoachByIdCard(string temp) { using (var db = new GymCompetitionDB()) { return(db.Tb_coach.Where(m => m.Idcard == temp).ToList()); } }
public List <Athlete> SearchAthleteByAthleteNum(string temp) { using (var db = new GymCompetitionDB()) { return(db.Tb_athlete.Where(m => m.Athnum == temp).ToList()); } }
public List <Doctor> SearchDoctorByIdCard(string temp) { using (var db = new GymCompetitionDB()) { return(db.Tb_doctor.Where(m => m.Idcard == temp).ToList()); } }
public List <Leader> SearchLeaderByIdCard(string temp) { using (var db = new GymCompetitionDB()) { return(db.Tb_leader.Where(m => m.Idcard == temp).ToList()); } }
public List <RefereeScore> SearchRefereeScoreByGameInfoId(string temp) { using (var db = new GymCompetitionDB()) { return(db.Tb_refereeScore.Where(item => item.GameInfoId == temp).ToList()); } }
public List <Referee> QueryRefereeByTeamAccount(string teamAccount) { using (var db = new GymCompetitionDB()) { return(db.Tb_referee.Where(m => m.TeamAccount == teamAccount).ToList()); } }
public List <RefereeScore> SearchRefereeScoreByRefereeIdAndGameInfo(string gameInfo, string refereeId) { using (var db = new GymCompetitionDB()) { return(db.Tb_refereeScore.Where(m => m.RefereeId == refereeId && m.GameInfoId == gameInfo).ToList()); } }
public List <Item> QueryItems() { using (var db = new GymCompetitionDB()) { return(db.Tb_item.ToList()); } }
public List <Coach> QueryCoachByTeamAccount(string teamAccount) { using (var db = new GymCompetitionDB()) { return(db.Tb_coach.Where(m => m.TeamAccount == teamAccount).ToList()); } }
//通过 成员账号/身份证号查找特定成员 public List <Team> SearchTeamByAccount(string account) { using (var db = new GymCompetitionDB()) { return(db.Team.Where(m => m.Account == account).ToList()); } }
//得到决赛名单 public void GetFinalGameAthletes() { using (var db = new GymCompetitionDB()) { IEnumerable <IGrouping <string, PersonalItemFinalScore> > finalScores = db.Tb_PersonalItemFinalScore .OrderBy(n => n.FinalScore) .GroupBy(m => m.ItemId) .ToList(); foreach (IGrouping <string, PersonalItemFinalScore> item in finalScores) { int count = 0; foreach (PersonalItemFinalScore finalScore in item) { if (count++ < 8) { db.Tb_gameInformation.Where( info => info.ItemId == item.ToString() && info.AthleteNum == finalScore.AthleteNum) .ToList()[0].FinalGame = true; } } } } }
//设置 组号 出场顺序 public void ArrangeGroups() { using (var db = new GymCompetitionDB()) { int count = 0; int tag = 1; foreach (GameInformation gameInformation in db.Tb_gameInformation) { tag = 1; while (true) { count = GetItemGroupCount(gameInformation.ItemId, tag); if (count < 8) { gameInformation.GroupNumber = tag; gameInformation.PlayOrder = count + 1; UpdateGameInfo(gameInformation); break; } else { tag++; } } } } }
//查找 同一项目同一组号内的人数 public int GetItemGroupCount(string itemId, int n) { using (var db = new GymCompetitionDB()) { return(db.Tb_gameInformation.Where(m => m.ItemId == itemId && m.GroupNumber == n).ToList().Count); } }
public void AddGameInformation(GameInformation gameInformation) { using (var db = new GymCompetitionDB()) { db.Tb_gameInformation.Add(gameInformation); db.SaveChanges(); } }
public void AddItem(Item item) { using (var db = new GymCompetitionDB()) { db.Tb_item.Add(item); db.SaveChanges(); } }
public void AddAthlete(Athlete athlete) { using (var db = new GymCompetitionDB()) { db.Tb_athlete.Add(athlete); db.SaveChanges(); } }
public void AddReferee(Referee referee) { using (var db = new GymCompetitionDB()) { db.Tb_referee.Add(referee); db.SaveChanges(); } }
public void AddCoach(Coach coach) { using (var db = new GymCompetitionDB()) { db.Tb_coach.Add(coach); db.SaveChanges(); } }
public void AddDoctor(Doctor doctor) { using (var db = new GymCompetitionDB()) { db.Tb_doctor.Add(doctor); db.SaveChanges(); } }
public void AddLeader(Leader leader) { using (var db = new GymCompetitionDB()) { db.Tb_leader.Add(leader); db.SaveChanges(); } }