private void ReloadTable()
{
var groupName = GroupName;
var matchId = MatchId;
LockControl();
var everyGroupNum = MatchGroupTableDAL.GetFinalColumnCountSelected(matchId, GroupName, SexName);
if (string.IsNullOrWhiteSpace(everyGroupNum))
{
// 初始化每组人数
this.cbEveryGroupNum.SelectedItem = "4";
this.menDataView.DataSource = null;
UnLockControl();
return;
}
var columnCount = 0;
columnCount = Convert.ToInt32(everyGroupNum);
// 获取选择组别、项目下的所有运动员信息
var allAthletes = Athletes.Select(x => new MatchGroupTableAthleteModel()
{
Name = x.Name, TeamName = x.TeamName, TeamShortName = x.TeamShortName
}).ToList();
// 设置分组，同单位的不同列，不同行，只参加个人赛的需要标注
var rowCount = (int)Math.Ceiling(allAthletes.Count / (decimal)columnCount); // 需要的组数
var table = MatchGroupTableDAL.GetFinalEveryGroupTable(matchId, groupName, SexName);
DisplayInScreen(rowCount, columnCount, table);
}
private void lbPrintMatchGroup_Click(object sender, EventArgs e)
{
// 生成报表
var fileName = $"{MatchName}-{GroupName}-{Project}-决赛竞赛分组表-{DateTime.Now.ToString("yyyyMMddHHmmss")}";
var table = MatchGroupTableDAL.GetFinalEveryGroupTable(MatchId, GroupName, SexName);
ExcelHelperMatchGroup.GenerateOneSexMatchGroup(fileName, MatchId, MatchName, GroupName, SexName, table);
}
private void lbGenerateRecordCard_Click(object sender, EventArgs e)
{
var groupName = GroupName;
var matchId = MatchId;
var matchName = MatchName;
var allSex = MatchGroupTableDAL.GetAllProjectsByGroup(matchId, groupName); // 男，女，男男，女女，男女
// 不同性别打印不同的记杆卡，同一性别打印在一个Excle中
var table = MatchGroupTableDAL.GetFinalEveryGroupTable(matchId, groupName, SexName);
var gName = SwitchSexName(SexName);
var fileName = $"{matchName}-{groupName}-{gName}-记杆卡-{DateTime.Now.ToString("yyyyMMddHHmmss")}";
ExcelHelperMatchGroup.GenerateRecoredCard(fileName, matchId, matchName, groupName, SexName, table);
}