private void 查看ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dgv_tutors_all.SelectedRows.Count > 0)
{
string ID = dgv_tutors_all.SelectedRows[0].Cells[0].Value.ToString();
string parent_num = dgv_tutors_all.SelectedRows[0].Cells[1].Value.ToString();
string print_num = dgv_tutors_all.SelectedRows[0].Cells[2].Value.ToString();
string parent_name = dgv_tutors_all.SelectedRows[0].Cells[3].Value.ToString();
string phone = dgv_tutors_all.SelectedRows[0].Cells[4].Value.ToString();
string grade_subject = dgv_tutors_all.SelectedRows[0].Cells[5].Value.ToString();
string student_sex = dgv_tutors_all.SelectedRows[0].Cells[6].Value.ToString();
string tutors_state = dgv_tutors_all.SelectedRows[0].Cells[7].Value.ToString();
string time = dgv_tutors_all.SelectedRows[0].Cells[8].Value.ToString();
string tutors_price = dgv_tutors_all.SelectedRows[0].Cells[9].Value.ToString();
string tutors_time = dgv_tutors_all.SelectedRows[0].Cells[10].Value.ToString();
string dadd = dgv_tutors_all.SelectedRows[0].Cells[11].Value.ToString();
string important_mark = dgv_tutors_all.SelectedRows[0].Cells[12].Value.ToString();
string payment_state = dgv_tutors_all.SelectedRows[0].Cells[13].Value.ToString();
string payment_time = dgv_tutors_all.SelectedRows[0].Cells[14].Value.ToString();
Tutors_check myform = new Tutors_check(ID, parent_num, print_num, parent_name, phone, grade_subject, student_sex,
tutors_state, time, tutors_price, tutors_time, dadd, important_mark, payment_state, payment_time);
myform.Owner = this;
myform.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
myform.Show();
}
}
private void 查看家教信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dgv_responsibility.SelectedRows.Count > 0)
{
string parents_num = dgv_responsibility.SelectedRows[0].Cells[0].Value.ToString();
string print_num = dgv_responsibility.SelectedRows[0].Cells[1].Value.ToString();
string mysql = "SELECT 接待人 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string reception = mydb.Returnafield(mysql);
mysql = "SELECT ID FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string ID = mydb.Returnafield(mysql);
mysql = "SELECT 接入时间 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string reception_time = mydb.Returnafield(mysql);
mysql = "SELECT 家长称呼 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string parents_name = mydb.Returnafield(mysql);
mysql = "SELECT 联系方式 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string phone = mydb.Returnafield(mysql);
mysql = "SELECT 家教地址简单 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string sadd = mydb.Returnafield(mysql);
mysql = "SELECT 家教地址详细 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string dadd = mydb.Returnafield(mysql);
mysql = "SELECT 年级科目 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string grade_subject = mydb.Returnafield(mysql);
mysql = "SELECT 学员性别 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string student_sex = mydb.Returnafield(mysql);
mysql = "SELECT 家教价格 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string tutors_price = mydb.Returnafield(mysql);
mysql = "SELECT 家教时间 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string tutors_time = mydb.Returnafield(mysql);
mysql = "SELECT 教员要求性别 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string sex = mydb.Returnafield(mysql);
mysql = "SELECT 教员要求地域 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string place = mydb.Returnafield(mysql);
mysql = "SELECT 教员要求年级 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string grade = mydb.Returnafield(mysql);
mysql = "SELECT 教员要求专业 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string subject = mydb.Returnafield(mysql);
mysql = "SELECT 教员要求其他 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string others = mydb.Returnafield(mysql);
mysql = "SELECT 家教状态 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string tutors_state = mydb.Returnafield(mysql);
mysql = "SELECT 经办时间 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string time = mydb.Returnafield(mysql);
mysql = "SELECT 重要备注 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string remarks = mydb.Returnafield(mysql);
mysql = "SELECT 缴费状态 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string payment_state = mydb.Returnafield(mysql);
mysql = "SELECT 缴费时间 FROM [Parents] WHERE 家长编号='" + parents_num + "'";
string payment_time = mydb.Returnafield(mysql);
Tutors_check myform = new Tutors_check(ID, parents_num, print_num, parents_name, phone, grade_subject, student_sex,
tutors_state, time, tutors_price, tutors_time, dadd, remarks, payment_state, payment_time);
myform.Owner = this;
myform.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
myform.Show();
}
}