public void Add(string reception, string state)
{
CommDB mydb = new CommDB();
string mysql = "SELECT 本月业务积分 FROM [Workers] WHERE 姓名='" + reception + "'";
float month = float.Parse(mydb.Returnafield(mysql));
month += standard(state);
mysql = "SELECT 累计业务积分 FROM [Workers] WHERE 姓名='" + reception + "'";
float sum = float.Parse(mydb.Returnafield(mysql));
sum += standard(state);
mysql = string.Format("UPDATE [Workers] SET 本月业务积分='{0}',累计业务积分='{1}' WHERE 姓名='{2}'", month, sum, reception);
mydb.ExecuteNonQuery(mysql);
}
private void btnyes_Click(object sender, EventArgs e)
{
string userName = txtName.Text;
string password = txtPwd.Text;
CommDB mydb = new CommDB();
string mystr;
mystr = string.Format("select * from [User] where Username='******' and Password='******'", userName, password);
try
{
int i = mydb.Rownum(mystr);
if (i == 0)
{
MessageBox.Show("您输入的用户名或密码错误！请重试", "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtPwd.Text = "";
return;
}
else
{
string mysql = string.Format("SELECT Level FROM [User] WHERE Username='******' AND Password='******'",
userName, password);
string level = mydb.Returnafield(mysql);
this.Hide();
Form myform = new Main(level);
myform.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
myform.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
private void 择此家教ToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
num1 = dgv_inquire.SelectedRows[0].Cells[2].Value.ToString();
string mysql = "SELECT 是否黑名单 FROM [Tutors] WHERE 教员编号='" + num1 + "'";
CommDB mydb = new CommDB();
string flag = mydb.Returnafield(mysql);
if (flag == "是")
{
MessageBox.Show("此教员已被列入黑名单！请重新选择！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
else
{
name1 = dgv_inquire.SelectedRows[0].Cells[3].Value.ToString();
UpDate3(num1, name1);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
CmbDataGridview cmbd = new CmbDataGridview();
}
/* private void cbo_state_SelectedIndexChanged(object sender, EventArgs e)
* {
* cbo_tutors_state.SelectedItem = cbo_state.SelectedItem;
*
* }*/
private void cbo_tutors_num_SelectedIndexChanged(object sender, EventArgs e)
{
if (flag2 == true)
{
tutors_num1 = cbo_tutors_num.Text.Trim();
if (tutors_num1 == "")
{
txt_tutors_name.Text = "";
return;
}
else
{
string mysql = "SELECT 姓名 FROM [Tutors] WHERE 教员编号 = '" + tutors_num1 + "'";
tutors_name1 = mydb.Returnafield(mysql);
mysql = string.Format("SELECT * FROM [Parents-Tutors] WHERE 打印编号='{0}' AND 教员编号='{1}'", print_num1, tutors_num1);
int i = mydb.Rownum(mysql);
if (i > 0)
{
mysql = string.Format("SELECT ID FROM [Parents-Tutors] WHERE ID="
+ "(SELECT MAX(ID) FROM [Parents-Tutors] WHERE 打印编号='{0}' AND 教员编号='{1}')", print_num1, tutors_num1);
ID = mydb.Returnafield(mysql);
txt_tutors_name.Text = tutors_name1;
mysql = "SELECT 经办状态 FROM [Parents-Tutors] WHERE ID= '" + ID + "'";
state1 = mydb.Returnafield(mysql);
string[] state = state1.Split(' ');
cbo_state.SelectedItem = state.Last();
tempstate = state.Last();
mysql = "SELECT 经办人 FROM [Parents-Tutors] WHERE ID= '" + ID + "'";
principal1 = mydb.Returnafield(mysql);
mysql = "SELECT 经办时间 FROM [Parents-Tutors] WHERE ID= '" + ID + "'";
time1 = mydb.Returnafield(mysql);
mysql = "SELECT 处理备注 FROM [Parents-Tutors] WHERE ID= '" + ID + "'";
remarks1 = mydb.Returnafield(mysql);
txt_remark.Text = remarks1;
flag = true;//记录存在
}
}
}
}
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();
}
}
private void Tutors_revise_Load(object sender, EventArgs e)
{
CmbClass cmbc = new CmbClass();
cmbc.cboDataBind(cbo_reception, "SELECT distinct 姓名 FROM [Workers]", "Workers", "姓名");
CmbDataGridview cmbd = new CmbDataGridview();
CCTRS ctr = new CCTRS();
ctr.ColorDataGridView(dgv_tutors);
string mystr = "SELECT 教员编号,教员姓名,经办状态,经办时间,经办人,处理备注 FROM [Parents-Tutors] WHERE " +
"打印编号='" + print_num1 + "' ORDER BY (SELECT right(经办时间,10)) DESC";
cmbd.bind(dgv_tutors, mystr, "Parents-Tutors");
dgv_tutors.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.ColumnHeader;
dgv_tutors.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
txt_parent_num.Text = parent_num1;
txt_print_num.Text = print_num1;
mystr = "SELECT 接入时间 FROM [Parents] WHERE ID='" + ID1 + "'";
dt_recepiton_time.Text = mydb.Returnafield(mystr);
txt_parent_name.Text = parent_name1;
txt_phone.Text = phone1;
mystr = "SELECT 家教地址简单 FROM [Parents] WHERE ID='" + ID1 + "'";
txt_sadd.Text = mydb.Returnafield(mystr);
txt_dadd.Text = dadd1;
txt_grade_subject.Text = grade_subject1;
if (student_sex1 == "男")
{
rdo_man.Checked = true;
}
if (student_sex1 == "女")
{
rdo_woman.Checked = true;
}
txt_tutor_price.Text = tutors_price1;
txt_tutor_time.Text = tutors_time1;
mystr = "SELECT 接待人 FROM [Parents] WHERE ID='" + ID1 + "'";
cbo_reception.Text = mydb.Returnafield(mystr);
mystr = "SELECT 教员要求性别 FROM [Parents] WHERE ID='" + ID1 + "'";
cbo_sex.SelectedItem = mydb.Returnafield(mystr);
mystr = "SELECT 教员要求地域 FROM [Parents] WHERE ID='" + ID1 + "'";
txt_place.Text = mydb.Returnafield(mystr);
mystr = "SELECT 教员要求年级 FROM [Parents] WHERE ID='" + ID1 + "'";
txt_grade.Text = mydb.Returnafield(mystr);
mystr = "SELECT 教员要求专业 FROM [Parents] WHERE ID='" + ID1 + "'";
txt_subject.Text = mydb.Returnafield(mystr);
mystr = "SELECT 教员要求其他 FROM [Parents] WHERE ID='" + ID1 + "'";
txt_other_requests.Text = mydb.Returnafield(mystr);
// string[] tutors_state = tutors_state1.Split(' ');
// cbo_tutor_state.SelectedItem = tutors_state.Last();
cbo_tutor_state.SelectedItem = tutors_state1;
txt_important_remarks.Text = important_mark1;
cbo_payment_state.SelectedItem = payment_state1;
dt_payment_time.Text = payment_time1;
if (cbo_payment_state.SelectedItem.ToString() == "待缴" || cbo_payment_state.SelectedItem.ToString() == "无需缴纳")
{
dt_payment_time.Enabled = false;
}
if (cbo_payment_state.SelectedItem.ToString() == "已缴")
{
dt_payment_time.Enabled = true;
}
flag = true;
}
private void btn_check_Click(object sender, EventArgs e)
{
if (txt_num.Text == "")
{
MessageBox.Show("请输入教员编号！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
int i = mydb.Rownum("SELECT * FROM [Tutors] WHERE 教员编号='" + txt_num.Text.Trim() + "'");
if (i > 0)
{
MessageBox.Show("该教员编号已存在，请重新输入教员编号！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_num.Text = "";
return;
}
if (txt_student_name.Text == "")
{
MessageBox.Show("请输入姓名！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_student_num.Text == "")
{
MessageBox.Show("请输入学号！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
i = mydb.Rownum("SELECT * FROM [Tutors] WHERE 学号='" + txt_student_num.Text.Trim() + "'");
if (i > 0)
{
MessageBox.Show("该学号已存在，请重新输入学号！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_student_num.Text = "";
return;
}
if (cbo_subject.Text == "")
{
MessageBox.Show("请输入院系专业！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (!rdo_man.Checked && !rdo_woman.Checked)
{
MessageBox.Show("请选择性别！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (cbo_degree.SelectedItem == null)
{
MessageBox.Show("请选择在读学位！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_phone.Text == "")
{
MessageBox.Show("请输入联系方式！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_phone.TextLength > 11)
{
MessageBox.Show("联系方式不得超过11位！请重新输入！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_phone.Text = "";
return;
}
i = mydb.Rownum("SELECT * FROM [Tutors] WHERE 联系方式='" + txt_phone.Text.Trim() + "'");
if (i > 0)
{
MessageBox.Show("该联系方式已存在，请重新输入！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_phone.Text = "";
return;
}
if (txt_place.Text == "")
{
MessageBox.Show("请输入生源地！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
string sex;
if (rdo_man.Checked)
{
sex = rdo_man.Text;
}
else
{
sex = rdo_woman.Text;
}
string mysql;
mysql = string.Format("INSERT INTO [Tutors] (教员编号,姓名,学号,院系专业,在读学位,性别,联系方式,生源地," +
"重要备注,是否黑名单) VALUES " + "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')",
txt_num.Text.Trim(), txt_student_name.Text.Trim(), txt_student_num.Text.Trim(), cbo_subject.Text.Trim(),
cbo_degree.Text, sex, txt_phone.Text.Trim(), txt_place.Text.Trim(), txt_important_remarks.Text.Trim(),
"否");
try
{
mydb.ExecuteNonQuery(mysql);
MessageBox.Show("添加信息成功", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
i = mydb.Rownum("SELECT * FROM [Subject] WHERE 专业='" + cbo_subject.Text.Trim() + "'");
if (i == 0)
{
mysql = "INSERT INTO [Subject] (专业) VALUES ('" + cbo_subject.Text.Trim() + "')";
mydb.ExecuteNonQuery(mysql);
}
SetTop();
txt_student_name.Text = "";
txt_student_num.Text = "";
cbo_degree.SelectedItem = null;
rdo_man.Checked = false;
rdo_woman.Checked = false;
txt_phone.Text = "";
txt_place.Text = "";
txt_important_remarks.Text = "";
cmbc.cboDataBind(cbo_subject, "SELECT distinct 院系专业 FROM [Tutors]", "Tutors", "院系专业");
cbo_subject.Text = "";
mysql = "SELECT MAX(教员编号) FROM [Tutors]";
int tutors_num = int.Parse(mydb.Returnafield(mysql));
tutors_num++;
txt_num.Text = tutors_num.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btnyes_Click(object sender, EventArgs e)
{
if (txt_parent_num.Text == "")
{
MessageBox.Show("请输入家长编号！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
int i = mydb.Rownum("SELECT * FROM [Parents] WHERE 家长编号='" + txt_parent_num.Text.Trim() + "'AND 打印编号='" + txt_print_num.Text.Trim() + "'");
if (i > 0)
{
MessageBox.Show("该家长编号已存在，请重新输入家长编号！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_parent_num.Text = "";
return;
}
if (txt_print_num.Text == "")
{
MessageBox.Show("请输入打印编号！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
i = mydb.Rownum("SELECT * FROM [Parents] WHERE 打印编号='" + txt_print_num.Text.Trim() + "'");
if (i > 0)
{
MessageBox.Show("该打印编号已存在，请重新输入打印编号！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_print_num.Text = "";
return;
}
if (cbo_reception.SelectedItem == null)
{
MessageBox.Show("请选择接待人！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_parent_name.Text == "")
{
MessageBox.Show("请输入家长称呼！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_phone.Text == "")
{
MessageBox.Show("请输入联系方式！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_phone.TextLength > 11)
{
MessageBox.Show("联系方式不得超过11位！请重新输入！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_sadd.Text == "")
{
MessageBox.Show("请输入家教地址（简单）！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_dadd.Text == "")
{
MessageBox.Show("请输入家教地址（详细）！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_grade_subject.Text == "")
{
MessageBox.Show("请输入年级科目！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (!rdo_man.Checked && !rdo_woman.Checked)
{
MessageBox.Show("请选择学员性别！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_tutor_price.Text == "")
{
MessageBox.Show("请输入家教价格！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txt_tutor_time.Text == "")
{
MessageBox.Show("请输入家教时间！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (cbo_tutor_state.SelectedItem == null)
{
MessageBox.Show("请选择家教状态！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (cbo_payment_state.SelectedItem == null)
{
MessageBox.Show("请选择缴费状态！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
string mysql;
string reception = cbo_reception.Text;
string student_sex = "";
string payment_time = "";
if (rdo_man.Checked)
{
student_sex = rdo_man.Text;
}
else
{
student_sex = rdo_woman.Text;
}
string sex;
if (cbo_sex.SelectedItem == null)
{
sex = "";
}
else
{
sex = cbo_sex.SelectedItem.ToString();
}
string tutor_state = cbo_tutor_state.SelectedItem.ToString();
string payment_state = cbo_payment_state.SelectedItem.ToString();
string temptime = dt_recepiton_time.Value.ToString("yyyy/MM/dd");
if (dt_payment_time.Enabled == true)
{
payment_time = dt_payment_time.Value.ToString();
mysql = string.Format("INSERT INTO [Parents] (家长编号,打印编号,接待人,接入时间,家长称呼,联系方式," +
"家教地址简单,家教地址详细,年级科目,学员性别,家教价格,家教时间," +
"教员要求性别,教员要求地域,教员要求年级,教员要求专业,教员要求其他," +
"家教状态,重要备注,缴费状态,缴费时间,经办时间,进行状态) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}'," +
"'{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}')",
txt_parent_num.Text.Trim(), txt_print_num.Text.Trim(), reception, dt_recepiton_time.Value,
txt_parent_name.Text.Trim(), txt_phone.Text.Trim(), txt_sadd.Text.Trim(), txt_dadd.Text.Trim(),
txt_grade_subject.Text.Trim(), student_sex, txt_tutor_price.Text.Trim(), txt_tutor_time.Text.Trim(),
sex, txt_place.Text.Trim(), txt_grade.Text.Trim(), txt_subject.Text.Trim(), txt_other_requests.Text.Trim(),
tutor_state, txt_important_remarks.Text.Trim(), payment_state, payment_time, temptime, "接入");
}
else
{
mysql = string.Format("INSERT INTO [Parents] (家长编号,打印编号,接待人,接入时间,家长称呼,联系方式," +
"家教地址简单,家教地址详细,年级科目,学员性别,家教价格,家教时间," +
"教员要求性别,教员要求地域,教员要求年级,教员要求专业,教员要求其他," +
"家教状态,重要备注,缴费状态,经办时间,进行状态) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}'," +
"'{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}')",
txt_parent_num.Text.Trim(), txt_print_num.Text.Trim(), reception, dt_recepiton_time.Value,
txt_parent_name.Text.Trim(), txt_phone.Text.Trim(), txt_sadd.Text.Trim(), txt_dadd.Text.Trim(),
txt_grade_subject.Text.Trim(), student_sex, txt_tutor_price.Text.Trim(), txt_tutor_time.Text.Trim(),
sex, txt_place.Text.Trim(), txt_grade.Text.Trim(), txt_subject.Text.Trim(), txt_other_requests.Text.Trim(),
tutor_state, txt_important_remarks.Text.Trim(), payment_state, temptime, "接入");
}
try
{
mydb.ExecuteNonQuery(mysql);
MessageBox.Show("添加家教信息成功", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
mysql = string.Format("INSERT INTO [Responsibility] (家长编号,打印编号,经办状态,经办时间,经办人) VALUES ('{0}'," +
"'{1}','{2}','{3}','{4}')", txt_parent_num.Text.Trim(), txt_print_num.Text.Trim(),
tutor_state, temptime, reception);
mydb.ExecuteNonQuery(mysql);
Integral itg = new Integral();
itg.Add(reception, tutor_state);
mysql = string.Format("INSERT INTO [Parents-Tutors] (家长编号,打印编号,教员编号,教员姓名,经办状态,经办时间,经办人) VALUES ('{0}'," +
"'{1}','{2}','{3}','{4}','{5}','{6}')", txt_parent_num.Text.Trim(), txt_print_num.Text.Trim(), "", "",
tutor_state, temptime, reception);
mydb.ExecuteNonQuery(mysql);
txt_parent_name.Text = "";
cbo_reception.SelectedItem = null;
txt_phone.Text = "";
txt_sadd.Text = "";
txt_dadd.Text = "";
txt_grade_subject.Text = "";
txt_grade.Text = "";
cbo_sex.SelectedItem = null;
txt_other_requests.Text = "";
rdo_man.Checked = false;
rdo_woman.Checked = false;
txt_tutor_price.Text = "";
txt_tutor_time.Text = "";
cbo_sex.Text = "";
txt_place.Text = "";
txt_grade.Text = "";
txt_subject.Text = "";
txt_important_remarks.Text = "";
mysql = "SELECT MAX(家长编号) FROM [parents]";
int parents_num = int.Parse(mydb.Returnafield(mysql));
parents_num++;
txt_parent_num.Text = parents_num.ToString();
mysql = "SELECT MAX(打印编号) FROM [parents]";
int print_num = int.Parse(mydb.Returnafield(mysql));
print_num++;
txt_print_num.Text = print_num.ToString();
SetTop();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
