private void Button_SignUser_Click(object sender, EventArgs e) { var orgSelect = (DataRowView)ComboBox_OrgList.SelectedItem; var selectExam = (DataRowView)ComboBox_ExamList.SelectedItem; if (selectExam == null) { MessageBox.Show("请选择考试!"); return; } Guid?orgId = null; if (checkBox_OrgUser.Checked) { if (orgSelect == null) { MessageBox.Show("请选择机构!"); return; } orgId = (Guid)orgSelect[0]; } toolStripStatusLabel_Default.Text = "开始报名"; var rst = ExamDataHelper.SignOrgUser((Guid)selectExam[0], orgId); toolStripStatusLabel_Default.Text = "报名结束"; MessageBox.Show(rst); }
private void Button_ExcelSign_Click(object sender, EventArgs e) { var selectExam = (DataRowView)ComboBox_ExamList.SelectedItem; if (selectExam == null) { MessageBox.Show("请选择考试!"); return; } toolStripStatusLabel_Default.Text = "选择报名文件"; OpenFileDialog excelFileDialog = new OpenFileDialog { Title = "请选择报名文件", Filter = "Excel文件|*.xls;*.xlsx" //设置要选择的文件的类型 }; if (excelFileDialog.ShowDialog() == DialogResult.OK) { toolStripStatusLabel_Default.Text = "开始报名"; var rst = ExamDataHelper.SignExcelUser((Guid)selectExam[0], excelFileDialog.FileName); MessageBox.Show(rst); } toolStripStatusLabel_Default.Text = "报名结束"; }
private void Button_Create_Click(object sender, EventArgs e) { var userIds = ExamDataHelper.GetUserIds().ToArray(); var rst = ExamDataHelper.SignUserToExam(new Guid("A36C9AF2-F522-4EB7-BB98-945BEBD51C21"), userIds); MessageBox.Show(rst); }
private void Button_SearchOrg_Click(object sender, EventArgs e) { toolStripStatusLabel_Default.Text = "加载机构数据"; var orgs = ExamDataHelper.GetOrgIdNamesTable(TextBox_OrgSearch.Text); ComboBox_OrgList.DisplayMember = "FullName"; ComboBox_OrgList.ValueMember = "OrganizeId"; ComboBox_OrgList.DataSource = orgs; toolStripStatusLabel_Default.Text = "机构数据加载完成"; }
private void Button_SearchExam_Click(object sender, EventArgs e) { toolStripStatusLabel_Default.Text = "加载考试数据"; var orgSelect = (DataRowView)ComboBox_OrgList.SelectedItem; var exams = ExamDataHelper.GetExamTable((Guid?)orgSelect?[0], TextBox_SearchExam.Text); ComboBox_ExamList.DisplayMember = "ExamName"; ComboBox_ExamList.ValueMember = "ExamId"; ComboBox_ExamList.DataSource = exams; toolStripStatusLabel_Default.Text = "考试数据加载完成"; }
public void SignExcelUser(Guid examId, string fileName) { var userAccounts = ExcelHelper.GetWorkBookFromFile(fileName).GetUserAccounts().ToArray(); var userIds = ExamDataHelper.GetUserIdsByAccount(userAccounts).ToArray(); var rst = Parallel.For(0, userIds.Length / 5000, d => { ExamDataHelper.SignUserToExam(examId, userIds.Skip(d * 5000).Take(5000).ToArray()); }); while (!rst.IsCompleted) { } }
/// <summary> /// 更新缓存数据到数据库 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button_UpdateToDataBase_Click(object sender, EventArgs e) { var details = ExamDataHelper.GetStudentPaperDetails(new Guid("7AA8CA7E-194D-4A96-859D-33FB19822C3F"), new Guid("B5798D23-4681-4053-BAB6-AAF57A1F2D0B"), new Guid("D68545F7-73E6-4BE3-9E2D-06C6166C4445")).ToArray(); var datatale = ExamDataHelper.PaperDetailToDataTable(details); }