// 导入数据时,获取人员(运动员/其他人员)名单 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; }