private void 查看ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dgv_tutors.SelectedRows.Count > 0)
{
string tutors_num = dgv_tutors.SelectedRows[0].Cells[0].Value.ToString();
if (tutors_num != "")
{
string mysql = "SELECT 姓名 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string tutors_name = mydb.Returnafield(mysql);
mysql = "SELECT 学号 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string student_num = mydb.Returnafield(mysql);
mysql = "SELECT 院系专业 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string grade_subject = mydb.Returnafield(mysql);
mysql = "SELECT 在读学位 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string tutors_degree = mydb.Returnafield(mysql);
mysql = "SELECT 性别 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string sex = mydb.Returnafield(mysql);
mysql = "SELECT 联系方式 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string phone = mydb.Returnafield(mysql);
mysql = "SELECT 生源地 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string place = mydb.Returnafield(mysql);
mysql = "SELECT 是否黑名单 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string blacklist = mydb.Returnafield(mysql);
mysql = "SELECT 相关说明及监禁期 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string imprisonment = mydb.Returnafield(mysql);
mysql = "SELECT 重要备注 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'";
string remarks = mydb.Returnafield(mysql);
Students_check myform = new Students_check(tutors_num, tutors_name, student_num, grade_subject,
tutors_degree, sex, phone, place, blacklist, imprisonment, remarks);
myform.Owner = this;
myform.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
myform.Show();
}
}
}
private void 查看ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dgv_blacklist.SelectedRows.Count > 0)
{
string tutors_num = dgv_blacklist.SelectedRows[0].Cells[1].Value.ToString();
string tutors_name = dgv_blacklist.SelectedRows[0].Cells[2].Value.ToString();
string student_num = dgv_blacklist.SelectedRows[0].Cells[3].Value.ToString();
string grade_subject = dgv_blacklist.SelectedRows[0].Cells[4].Value.ToString();
string tutors_degree = dgv_blacklist.SelectedRows[0].Cells[5].Value.ToString();
string sex = dgv_blacklist.SelectedRows[0].Cells[6].Value.ToString();
string phone = dgv_blacklist.SelectedRows[0].Cells[7].Value.ToString();
string place = dgv_blacklist.SelectedRows[0].Cells[8].Value.ToString();
string blacklist = dgv_blacklist.SelectedRows[0].Cells[9].Value.ToString();
string imprisonment = dgv_blacklist.SelectedRows[0].Cells[10].Value.ToString();
string remarks = dgv_blacklist.SelectedRows[0].Cells[11].Value.ToString();
Students_check myform = new Students_check(tutors_num, tutors_name, student_num, grade_subject,
tutors_degree, sex, phone, place, blacklist, imprisonment, remarks);
myform.Owner = this;
myform.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
myform.Show();
}
}
