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