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 btn_yes_Click(object sender, EventArgs e) { string mysql = ""; if (txt_user.Text == "") { MessageBox.Show("请输入用户名!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (num1 == 1) { mysql = "SELECT * FROM [User] WHERE Username='******'"; int i = mydb.Rownum(mysql); if (i > 0) { MessageBox.Show("该用户名已存在!请重新输入!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } if (txt_password.Text == "") { MessageBox.Show("请输入密码!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (num1 == 1) { mysql = string.Format("INSERT INTO [User] (Username,Password,Level) VALUES ('{0}','{1}','{2}')", txt_user.Text.Trim(), txt_password.Text.Trim(), cbo_level.Text); } if (num1 == 2) { mysql = string.Format("UPDATE [User] SET Password='******',level='{1}' WHERE Username='******'", txt_password.Text.Trim(), cbo_level.Text, txt_user.Text.Trim()); } try { mydb.ExecuteNonQuery(mysql); if (num1 == 1) { MessageBox.Show("添加成功!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); txt_password.Text = ""; txt_user.Text = ""; this.Close(); } if (num1 == 2) { MessageBox.Show("修改成功!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
/* 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 btn_check_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("您确定要修改信息?", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.Cancel) { return; } if (result == DialogResult.OK) { if (txt_name.Text == "") { MessageBox.Show("请输入工作人员姓名!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (!rdo_man.Checked && !rdo_woman.Checked) { MessageBox.Show("请选择性别!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (txt_student_num.Text == "") { MessageBox.Show("请输入学号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } int i = mydb.Rownum("SELECT * FROM [Workers] WHERE 学号='" + txt_student_num.Text.Trim() + "'"); if (i > 0 && txt_student_num.Text.Trim() != student_num1) { MessageBox.Show("该学号已存在,请重新输入学号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txt_student_num.Text = ""; return; } if (cbo_subject.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); txt_phone.Text = ""; return; } i = mydb.Rownum("SELECT * FROM [Workers] WHERE 联系方式='" + txt_phone.Text.Trim() + "'"); if (i > 0 && txt_phone.Text.Trim() != phone1) { MessageBox.Show("该联系方式已存在,请重新输入联系方式!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txt_phone.Text = ""; return; } if (txt_month.Text == "") { MessageBox.Show("请输入本月业务积分!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (txt_sum.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 = string.Format("UPDATE [Workers] SET 姓名='{0}',性别='{1}',学号='{2}',院系专业='{3}'," + "联系方式='{4}'," + "职位='{5}',本月业务积分='{6}',累计业务积分='{7}' WHERE ID='{8}'", txt_name.Text.Trim(), sex, txt_student_num.Text.Trim(), cbo_subject.Text.Trim(), txt_phone.Text.Trim(), txt_position.Text.Trim(), txt_month.Text.Trim(), txt_sum.Text.Trim(), ID1); try { mydb.ExecuteNonQuery(mysql); MessageBox.Show("修改信息成功", "修改成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); SetTop(); } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
private void btnyes_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("您确定要修改信息?", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.Cancel) { return; } if (result == DialogResult.OK) { 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() + "'"); * if (i > 0&&txt_parent_num.Text.Trim()!=parent_num1) * { * MessageBox.Show("该家长编号已存在,请重新输入家长编号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); * txt_parent_num.Text = ""; * return; * }*/ if (txt_print_num.Text == "") { MessageBox.Show("请输入打印编号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } int i = mydb.Rownum("SELECT * FROM [Parents] WHERE 打印编号='" + txt_print_num.Text.Trim() + "'"); if (i > 0 && txt_print_num.Text.Trim() != print_num1) { 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); txt_phone.Text = ""; 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 = cbo_sex.Text; string payment_state = cbo_payment_state.Text; /* if (dt_payment_time.Enabled == true) * { * payment_time = dt_payment_time.Value.ToString(); * mysql = string.Format("UPDATE [Parents] SET 打印编号='{0}',接待人='{1}',接入时间='{2}',家长称呼='{3}'," + * "联系方式='{4}'," + "家教地址简单='{5}',家教地址详细='{6}',年级科目='{7}',学员性别='{8}'," + * "家教价格='{9}'," + "家教时间='{10}'," + "教员要求性别='{11}',教员要求地域='{12}',教员要求年级='{13}'," + * "教员要求专业='{14}',教员要求其他='{15}'," + "家教状态='{16}',重要备注='{17}',缴费状态='{18}'," + * "缴费时间='{19}',家长编号='{20}',经办时间='{21}' WHERE ID='{22}'", 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(), * tutors_state1, txt_important_remarks.Text.Trim(), payment_state, payment_time, * txt_parent_num.Text.Trim(),time1, ID1); * } * else * { * mysql = string.Format("UPDATE [Parents] SET 打印编号='{0}',接待人='{1}',接入时间='{2}',家长称呼='{3}'," + * "联系方式='{4}'," + "家教地址简单='{5}',家教地址详细='{6}',年级科目='{7}',学员性别='{8}'," + * "家教价格='{9}'," + "家教时间='{10}'," + "教员要求性别='{11}',教员要求地域='{12}',教员要求年级='{13}'," + * "教员要求专业='{14}',教员要求其他='{15}'," + "家教状态='{16}',重要备注='{17}',缴费状态='{18}'," + * "家长编号='{19}',经办时间='{20}' WHERE ID='{21}'", 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(), * tutors_state1, txt_important_remarks.Text.Trim(), payment_state, * txt_parent_num.Text.Trim(),time1, ID1); * }*/ mysql = string.Format("UPDATE [Parents] SET 打印编号='{0}',接待人='{1}',接入时间='{2}',家长称呼='{3}'," + "联系方式='{4}'," + "家教地址简单='{5}',家教地址详细='{6}',年级科目='{7}',学员性别='{8}'," + "家教价格='{9}'," + "家教时间='{10}'," + "教员要求性别='{11}',教员要求地域='{12}',教员要求年级='{13}'," + "教员要求专业='{14}',教员要求其他='{15}'," + "家教状态='{16}',重要备注='{17}',缴费状态='{18}'," + "家长编号='{19}',经办时间='{20}' WHERE ID='{21}'", 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(), tutors_state1, txt_important_remarks.Text.Trim(), payment_state, txt_parent_num.Text.Trim(), time1, ID1); try { mydb.ExecuteNonQuery(mysql); MessageBox.Show("修改家教信息成功", "修改成功", MessageBoxButtons.OK, MessageBoxIcon.Information); // this.Close(); SetTop(); } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
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); } }
private void btn_check_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("您确定要修改信息?", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.Cancel) { return; } if (result == DialogResult.OK) { 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 && txt_num.Text.Trim() != tutors_num1) { 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 && txt_student_num.Text.Trim() != student_num1) { MessageBox.Show("该学号已存在,请重新输入学号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txt_student_num.Text = ""; return; } if (cbo_subject.Text == "") { 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 && txt_phone.Text.Trim() != phone1) { MessageBox.Show("该联系方式已存在,请重新输入联系方式!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txt_phone.Text = ""; return; } if (txt_place.Text == "") { MessageBox.Show("请输入生源地!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (!rdo_man.Checked && !rdo_woman.Checked) { MessageBox.Show("请选择性别!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } string sex = ""; if (rdo_man.Checked) { sex = rdo_man.Text; } else { sex = rdo_woman.Text; } string black = cbo_yesno.Text; string mysql = string.Format("UPDATE [Tutors] SET 姓名='{0}',学号='{1}',院系专业='{2}',在读学位='{3}'," + "性别='{4}'," + "联系方式='{5}',生源地='{6}',是否黑名单='{7}',相关说明及监禁期='{8}'," + "重要备注='{9}',教员编号='{10}' WHERE ID='{11}'" , 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(), black, txt_imprisonment.Text.Trim(), txt_important_remarks.Text.Trim(), txt_num.Text.Trim(), ID1); try { mydb.ExecuteNonQuery(mysql); MessageBox.Show("修改信息成功", "修改成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); SetTop(); } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
private void btn_check_Click(object sender, EventArgs e) { if (txt_name.Text == "") { MessageBox.Show("请输入工作人员姓名!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (!rdo_man.Checked && !rdo_woman.Checked) { MessageBox.Show("请选择性别!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (txt_student_num.Text == "") { MessageBox.Show("请输入学号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } int i = mydb.Rownum("SELECT * FROM [Workers] 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 (txt_phone.Text == "") { MessageBox.Show("请输入联系方式!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } i = mydb.Rownum("SELECT * FROM [Tutors] WHERE 联系方式='" + txt_phone.Text.Trim() + "'"); if (txt_phone.TextLength > 11) { MessageBox.Show("联系方式不得超过11位!请重新输入!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txt_phone.Text = ""; return; } if (i > 0) { MessageBox.Show("该联系方式已存在,请重新输入!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txt_phone.Text = ""; return; } string sex; if (rdo_man.Checked) { sex = rdo_man.Text; } else { sex = rdo_woman.Text; } string mysql; mysql = string.Format("INSERT INTO [Workers] (姓名,性别,学号,院系专业,联系方式,职位) VALUES " + "('{0}','{1}','{2}','{3}','{4}','{5}')", txt_name.Text.Trim(), sex, txt_student_num.Text.Trim(), cbo_subject.Text.Trim(), txt_phone.Text.Trim(), txt_position.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); } cmbc.cboDataBind(cbo_subject, "SELECT distinct 院系专业 FROM [Workers]", "Workers", "院系专业"); txt_name.Text = ""; rdo_man.Checked = false; rdo_woman.Checked = false; txt_student_num.Text = ""; cbo_subject.Text = ""; txt_phone.Text = ""; txt_position.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }