// 导入数据时，获取人员(运动员/其他人员)名单
public static ListAthAndOtherModel GetFileInfo(FileInfo fileInfo, string matchId)
{
var result = new ListAthAndOtherModel();
IWorkbook workbook = ExcelHelper.InitialWorkbook(fileInfo);
var sheet = workbook.GetSheetAt(0); //获取第一个工作表
var helper = new ExcelHelperImport();
var teamName = helper.GetTeamName(fileInfo, sheet);
var teamShortName = helper.GetTeamShortName(fileInfo, sheet);
var groupName = helper.GetGroupName(fileInfo, sheet);
List <AthleteModel> athletes = new List <AthleteModel>();
List <OthersModel> others = new List <OthersModel>();
helper.GetOthersInfo(fileInfo, sheet, others);
helper.GetRegularAthletes(sheet, athletes); // 获取常规运动员
helper.GetDoubleBarAthletes(sheet, athletes); // 获取杆数赛双打人员
helper.GetDoubleWayAthletes(sheet, athletes); // 获取球道赛双打人员
helper.AppendBasicInfo(result, athletes, others, matchId, teamName, teamShortName, groupName);
return(result);
}
private void AppendBasicInfo(ListAthAndOtherModel result, List <AthleteModel> athletes, List <OthersModel> others, string matchId,
string teamName, string teamShortName, string groupName)
{
foreach (var ath in athletes)
{
ath.Id = Guid.NewGuid().ToString();
ath.MatchId = matchId;
ath.TeamName = teamName;
ath.TeamShortName = teamShortName;
ath.GroupName = groupName;
}
foreach (var oth in others)
{
oth.Id = Guid.NewGuid().ToString();
oth.MatchId = matchId;
oth.TeamName = teamName;
oth.TeamShortName = teamShortName;
oth.GroupName = groupName;
}
result.Athletes = athletes;
result.Others = others;
}
