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 int SetEveyTeamMemberProjectInfoMenWomen(IWorkbook workbook, ISheet sheet, int startRow, TeamMemberProjectModel model)
{
var row = startRow;
var nameRow = sheet.CreateRow(row);
var cell = nameRow.CreateCell(0);
cell.SetCellValue("混双");
sheet.AddMergedRegion(new CellRangeAddress(row, row, 0, 2));
cell.CellStyle = SetCellStyle(workbook, sheet, row, true, 250);
cell.CellStyle.Alignment = HorizontalAlignment.Left;
row++;
foreach (var info in model.MemberProjectList.Where(x => x.Sex == "男女"))
{
var infoRow = sheet.CreateRow(row);
var nameCell = infoRow.CreateCell(1);
nameCell.SetCellValue($"{info.Name}");
nameCell.CellStyle = SetCellStyle(workbook, sheet, row);
var barStatus = "";
if (info.BarIndividualGamesStatus == "参加")
{
barStatus += "混双杆数赛";
}
var barsStatusCell = infoRow.CreateCell(2);
barsStatusCell.SetCellValue($"{barStatus}");
barsStatusCell.CellStyle = SetCellStyle(workbook, sheet, row);
var wayStatus = "";
if (info.WayIndividualGamesStatus == "参加")
{
wayStatus += "混双球道赛";
}
var wayStatusCell = infoRow.CreateCell(3);
wayStatusCell.SetCellValue($"{wayStatus}");
wayStatusCell.CellStyle = SetCellStyle(workbook, sheet, row);
row++;
}
return(row);
}
private static int SetEveyTeamMemberProjectInfo(IWorkbook workbook, ISheet sheet, int startRow, TeamMemberProjectModel model)
{
var row = startRow;
row = SetEveyTeamMemberProjectInfoHeader(workbook, sheet, startRow, model.TeamName, model.GroupName, model.TitleNames);
if (model.MemberProjectList.Where(x => x.Sex == "男").Count() > 0)
{
row = SetEveyTeamMemberProjectInfoMen(workbook, sheet, row, model);
}
if (model.MemberProjectList.Where(x => x.Sex == "女").Count() > 0)
{
row = SetEveyTeamMemberProjectInfoWomen(workbook, sheet, row, model);
}
if (model.MemberProjectList.Where(x => x.Sex == "男男").Count() > 0)
{
row = SetEveyTeamMemberProjectInfoMenMen(workbook, sheet, row, model);
}
if (model.MemberProjectList.Where(x => x.Sex == "女女").Count() > 0)
{
row = SetEveyTeamMemberProjectInfoWomenWomen(workbook, sheet, row, model);
}
if (model.MemberProjectList.Where(x => x.Sex == "男女").Count() > 0)
{
row = SetEveyTeamMemberProjectInfoMenWomen(workbook, sheet, row, model);
}
row++;
return(row);
}
private static int SetEveyTeamMemberProjectInfoWomen(IWorkbook workbook, ISheet sheet, int startRow, TeamMemberProjectModel model)
{
var row = startRow;
var nameRow = sheet.CreateRow(row);
var cell = nameRow.CreateCell(0);
cell.SetCellValue("女运动员");
cell.CellStyle = SetCellStyle(workbook, sheet, row, true, 250);
row++;
foreach (var info in model.MemberProjectList.Where(x => x.Sex == "女"))
{
var infoRow = sheet.CreateRow(row);
var nameCell = infoRow.CreateCell(1);
nameCell.SetCellValue($"{info.Name}");
nameCell.CellStyle = SetCellStyle(workbook, sheet, row);
var barSattus = "";
if (info.BarIndividualGamesStatus == "参加" && info.BarGroupGamesStatus != "参加")
{
barSattus += "女子个人杆数赛";
}
else if (info.BarIndividualGamesStatus == "参加" && info.BarGroupGamesStatus == "参加")
{
barSattus += "女子个人、团体杆数赛";
}
else if (info.BarIndividualGamesStatus != "参加" && info.BarGroupGamesStatus == "参加")
{
barSattus += "女子团体杆数赛";
}
var barsStatusCell = infoRow.CreateCell(2);
barsStatusCell.SetCellValue($"{barSattus}");
barsStatusCell.CellStyle = SetCellStyle(workbook, sheet, row);
var wayStatus = "";
if (info.WayIndividualGamesStatus == "参加" && info.WayGroupGamesStatus != "参加")
{
wayStatus += "女子个人球道赛";
}
else if (info.WayIndividualGamesStatus == "参加" && info.WayGroupGamesStatus == "参加")
{
wayStatus += "女子个人、团体球道赛";
}
else if (info.WayIndividualGamesStatus != "参加" && info.WayGroupGamesStatus == "参加")
{
wayStatus += "女子团体球道赛";
}
var wayStatusCell = infoRow.CreateCell(3);
wayStatusCell.SetCellValue($"{wayStatus}");
wayStatusCell.CellStyle = SetCellStyle(workbook, sheet, row);
row++;
}
return(row);
}
