private void button1_Click(object sender, EventArgs e) { PublicMethods.title = textBoxTitle.Text.ToString(); if (int.TryParse(textBoxStudentNum.Text.ToString(), out PublicMethods.stuCount) == false) { MessageBox.Show("学生人数不正确"); return; } if (int.TryParse(textBoxTeacherNum.Text.ToString(), out PublicMethods.teacherCount) == false) { MessageBox.Show("老师人数不正确"); return; } //PublicSettings.ifShowInTheSecdisplay = checkBox.Checked; PublicMethods.StoreSettings(); Thread.Sleep(200); this.Close(); }
private void ClearData() { currTeacherName.Text = ""; foreach (Control obj in panelTeacher.Controls) { if (obj is TextBox) { ((TextBox)obj).Text = ""; } } foreach (Control obj in panelStudent.Controls) { if (obj is TextBox) { ((TextBox)obj).Text = ""; } } PublicMethods.Init(); }
private void MainForm_Load(object sender, EventArgs e) { if (PublicMethods.LoadSettings() == false) { Settings settings = new Settings(); settings.ShowDialog(this); } labelTitle.Text = PublicMethods.title; labelTitle.Left = (this.Width - labelTitle.Width) / 2; PaintForm(); string path = Application.StartupPath + "\\image\\"; if (Directory.Exists(path) == false) { Directory.CreateDirectory(path); } try { DataSet ds = PublicMethods.ExcelToDataSet(path + "Rank.xls"); if (ds.Tables.Count < 1) { return; } for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++) { dataGridView1.Rows.Add(int.Parse(ds.Tables[0].Rows[i][0].ToString()), ds.Tables[0].Rows[i][1].ToString(), double.Parse(ds.Tables[0].Rows[i][2].ToString())); } dataGridView1.Sort(dataGridView1.Columns[2], ListSortDirection.Descending); for (int i = 0; i < dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].Cells[0].Value = (i + 1).ToString(); } //为了在由排名刷新的时候重新保存xls PublicMethods.ExportToExcel(path + "Rank.xls", dataGridView1); //MessageBox.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void submit_Click(object sender, EventArgs e) { ShowDetail showDetail = new ShowDetail(); double sumTeacher = 0, sumStudent = 0; if (currTeacherName.Text.ToString().Length < 1) { MessageBox.Show("请输入选手姓名"); return; } int cnt = 0; foreach (Control obj in panelTeacher.Controls) { if (obj is TextBox) { TextBox textBox = (TextBox)obj; double temp = 0; if (double.TryParse(textBox.Text.ToString(), out temp) == false) { MessageBox.Show(textBox.Name + " 输入有误"); return; } if (temp > 30) { MessageBox.Show(textBox.Name + " 输入有误"); return; } PublicMethods.maxTeacherScore = Math.Max(PublicMethods.maxTeacherScore, temp); PublicMethods.minTeacherScore = Math.Min(PublicMethods.minTeacherScore, temp); sumTeacher += temp; Label label = new Label(); label.Name = "teac" + cnt.ToString(); label.Font = new Font("隶书", 20, FontStyle.Bold); label.AutoSize = true; label.Location = new Point(10 + (cnt % 5) * (showDetail.panelTeacher.Size.Width / 5), 10 + (cnt / 5) * 30); label.Text = temp.ToString().ToString().Substring(0, Math.Min(6, temp.ToString().Length)); showDetail.panelTeacher.Controls.Add(label); cnt++; } } cnt = 0; foreach (Control obj in panelStudent.Controls) { if (obj is TextBox) { TextBox textBox = (TextBox)obj; double temp = 0; if (double.TryParse(textBox.Text.ToString(), out temp) == false) { MessageBox.Show(textBox.Name + " 输入有误"); return; } if (temp > 30) { MessageBox.Show(textBox.Name + " 输入有误"); return; } PublicMethods.maxStudentScore = Math.Max(PublicMethods.maxStudentScore, temp); PublicMethods.minStudentScore = Math.Min(PublicMethods.minStudentScore, temp); sumStudent += temp; Label label = new Label(); label.Name = "teac" + cnt.ToString(); label.Font = new Font("隶书", 20, FontStyle.Bold); label.AutoSize = true; label.Location = new Point(10 + (cnt % 5) * (showDetail.panelTeacher.Size.Width / 5), 10 + (cnt / 5) * 30); label.Text = temp.ToString().ToString().Substring(0, Math.Min(6, temp.ToString().Length)); showDetail.panelStudent.Controls.Add(label); cnt++; } } sumTeacher -= PublicMethods.maxTeacherScore + PublicMethods.minTeacherScore; sumTeacher /= PublicMethods.teacherCount - 2; sumStudent -= PublicMethods.maxStudentScore + PublicMethods.minStudentScore; sumStudent /= PublicMethods.stuCount - 2; PublicMethods.argvStud = sumStudent; PublicMethods.argvTeac = sumTeacher; showDetail.teacMaxScore.Text = PublicMethods.maxTeacherScore.ToString(); showDetail.teacMinScore.Text = PublicMethods.minTeacherScore.ToString(); showDetail.studMaxScore.Text = PublicMethods.maxStudentScore.ToString(); showDetail.studMinScore.Text = PublicMethods.minStudentScore.ToString(); showDetail.teacArgv.Text = Math.Round(PublicMethods.argvTeac, 2).ToString(); showDetail.studArgv.Text = Math.Round(PublicMethods.argvStud, 2).ToString(); double score = sumTeacher * 0.7 + sumStudent * 0.3; // MessageBox.Show(score.ToString()); object[] para = new object[3]; para[0] = dataGridView1.Rows.Count; para[1] = currTeacherName.Text.ToString(); para[2] = Math.Round(score, 2); dataGridView1.Rows.Add(para); dataGridView1.Sort(dataGridView1.Columns[2], ListSortDirection.Descending); for (int i = 0; i < dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].Cells[0].Value = (i + 1).ToString(); } //ShowInSecDisplay(); showDetail.label1.Text = currTeacherName.Text; showDetail.finalScore.Text = para[2].ToString(); showDetail.Show(); string path = Application.StartupPath + "\\image\\"; if (Directory.Exists(path) == false) { Directory.CreateDirectory(path); } PublicMethods.ExportToExcel(path + "Rank.xls", dataGridView1); ClearData(); }