private static TeamMemberProjectModel GetTeamMemberProjectByTeamGroupName(string matchId, string teamNameAndGroupName) { var teamName = teamNameAndGroupName.Split(';')[0]; var groupName = teamNameAndGroupName.Split(';')[1]; var shortName = teamNameAndGroupName.Split(';')[1]; var result = new TeamMemberProjectModel(); result.TeamName = teamName; result.TeamShortName = shortName; result.GroupName = groupName; result.TitleNames = OthersDAL.GetTitleNames(matchId, teamName, groupName); var sql = $"select name,sex,bar_INDIVIDUAL_GAMES_STATUS,bar_GROUP_GAMES_STATUS,way_INDIVIDUAL_GAMES_STATUS,way_GROUP_GAMES_STATUS" + $" from athletes where " + $"match_id = '{matchId}' and group_name = '{groupName}' and team_name='{teamName}';"; var dataSet = SQLiteHelper.ExecuteDataSet(SQLiteHelper.LocalDbConnectionString, sql, CommandType.Text); var rows = dataSet.Tables[0].Rows; for (var i = 0; i < rows.Count; i++) { var info = new TeamMemberProject(); info.Name = DBHelper.GetTableItemStringValue(rows, i, 0); info.Sex = DBHelper.GetTableItemStringValue(rows, i, 1); info.BarIndividualGamesStatus = DBHelper.GetTableItemStringValue(rows, i, 2); info.BarGroupGamesStatus = DBHelper.GetTableItemStringValue(rows, i, 3); info.WayIndividualGamesStatus = DBHelper.GetTableItemStringValue(rows, i, 4); info.WayGroupGamesStatus = DBHelper.GetTableItemStringValue(rows, i, 5); result.MemberProjectList.Add(info); } return(result); }
private static TeamModel GetTeamInfoByTeamNameAndMatchId(string matchId, string teamNameGroupName) { var teamName = teamNameGroupName.Split(';')[0]; var groupName = teamNameGroupName.Split(';')[1]; var teamShortName = teamNameGroupName.Split(';')[2]; var result = new TeamModel(); result.TeamName = teamName; result.GroupName = groupName; result.TeamShortName = teamShortName; result.TitleNames = OthersDAL.GetTitleNames(matchId, teamName, groupName); var sql = $"select name,sex from athletes where match_id = '{matchId}' and team_name = '{teamName}' and group_name='{groupName}' and (sex = '男' or sex='女');"; var dataSet = SQLiteHelper.ExecuteDataSet(SQLiteHelper.LocalDbConnectionString, sql, CommandType.Text); var rows = dataSet.Tables[0].Rows; for (var i = 0; i < rows.Count; i++) { var name = DBHelper.GetTableItemStringValue(rows, i, 0); var sex = DBHelper.GetTableItemStringValue(rows, i, 1); if (sex == "男") { result.MenAthletes.Add(name); } if (sex == "女") { result.WomenAthletes.Add(name); } } return(result); }