private void btn_yes_Click(object sender, EventArgs e)
{
string dt = dt_payment_time.Value.ToString("yyyy/MM/dd HH:mm");
if (cbo_principal.Text == "")
{
MessageBox.Show("请选择经办人！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
string reception = cbo_principal.Text;
string mysql;
mysql = string.Format("UPDATE [Parents] SET 缴费状态='已缴',缴费时间='{0}',经办时间='{1}',经办人='{2}' " +
"WHERE 家长编号='{3}'",
dt, dt_time.Value, reception, txt_parent_num.Text.Trim());
try
{
mydb.ExecuteNonQuery(mysql);
MessageBox.Show("缴费成功", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
mysql = string.Format("INSERT INTO [Responsibility] (家长编号,打印编号,经办状态,经办时间,经办人) VALUES " +
"('{0}','{1}','{2}','{3}','{4}')", parent_num1, print_num1, "缴费", dt_time.Value, cbo_principal.Text);
mydb.ExecuteNonQuery(mysql);
string state = "已缴";
UpDate(dt_payment_time.Value.ToString("yyyy/MM/dd"), state);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult result = DialogResult.No;
try
{
if (dgv_users.SelectedRows.Count > 0)
{
result = MessageBox.Show("是否删除选中项？", "操作提示",
MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk);
if (result == DialogResult.Yes)
{
CommDB mydb = new CommDB();
string mysql = "DELETE FROM [User] WHERE Username = '******'";
mydb.ExecuteNonQuery(mysql);
MessageBox.Show("删除成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
cmbd.bind(dgv_users, "SELECT * FROM [User]", "User");
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult result = DialogResult.No;
try
{
if (dgv_inquire.SelectedRows.Count > 0)
{
result = MessageBox.Show("是否删除选中项？", "操作提示",
MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk);
if (result == DialogResult.Yes)
{
CommDB mydb = new CommDB();
string mysql = "DELETE FROM [Parents] WHERE ID = '" +
dgv_inquire.SelectedRows[0].Cells[1].Value.ToString() + "'";
mydb.ExecuteNonQuery(mysql);
MessageBox.Show("删除成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
CmbDataGridview cmbd = new CmbDataGridview();
cmbd.bind(dgv_inquire, mystr, "Parents");
}
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 btn_delete_Click(object sender, EventArgs e)
{
CmbDataGridview cmbd = new CmbDataGridview();
DialogResult result = DialogResult.No;
int n = 0;
try
{
for (int i = 0; i < dgv_inquire.Rows.Count; i++)
{
if ((bool)dgv_inquire.Rows[i].Cells[0].EditedFormattedValue == true) //判断该复选框是否被选中
{
n++;
if (n == 1)
{
result = MessageBox.Show("是否删除勾选项？", "操作提示",
MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk);
}
if (result == DialogResult.Yes)
{
string mysql = "DELETE FROM [Parents] WHERE ID = '" +
dgv_inquire.Rows[i].Cells[1].Value.ToString() + "'";
mydb.ExecuteNonQuery(mysql);
}
}
}
if (n != 0)
{
MessageBox.Show("删除成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
cmbd.bind(dgv_inquire, mystr, "Parents");
}
if (dgv_inquire.SelectedRows.Count > 0 && n == 0)
{
result = MessageBox.Show("是否删除选中项？", "操作提示",
MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk);
if (result == DialogResult.Yes)
{
CommDB mydb = new CommDB();
string mysql = "DELETE FROM [Parents] WHERE ID = '" +
dgv_inquire.SelectedRows[0].Cells[1].Value.ToString() + "'";
mydb.ExecuteNonQuery(mysql);
MessageBox.Show("删除成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
cmbd.bind(dgv_inquire, mystr, "Parents");
}
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 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_yes_Click(object sender, EventArgs e)
{
if (cbo_principal.Text == "")
{
MessageBox.Show("请选择经办人！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (cbo_tutors_state.SelectedItem == null)
{
MessageBox.Show("请选择家教状态！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
remarks1 = txt_remark.Text.Trim();
DialogResult result = MessageBox.Show("确认办理？", "操作提示",
MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
if (result == DialogResult.OK)
{
state1 += " " + cbo_state.Text;
principal1 += " " + cbo_principal.Text;
time1 += " " + dt_time.Value.ToString("yyyy/MM/dd");
string mysql = string.Format("UPDATE [Parents] SET 家教状态='{0}',经办时间='{1}' WHERE " +
"ID='{2}'", cbo_tutors_state.Text, dt_time.Value.ToString("yyyy/MM/dd"), ID);
try
{
mydb.ExecuteNonQuery(mysql);
MessageBox.Show("办理成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
mysql = string.Format("INSERT INTO [Responsibility] (家长编号,打印编号,经办状态,经办时间,经办人,处理备注) " +
"VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')",
parent_num1, print_num1, cbo_state.Text, dt_time.Value.ToString("yyyy/MM/dd"), cbo_principal.Text,
txt_remark.Text.Trim());
mydb.ExecuteNonQuery(mysql);
// mysql = "SELECT * FROM [Parents-Tutors] WHERE ID= '" + ID + "'";
// int i = mydb.Rownum(mysql);
// if (i > 0)
// {
Integral itg = new Integral();
itg.Add(cbo_principal.Text, cbo_state.Text);
if (((tempstate == "接入" || tempstate == "换人" || tempstate == "不请" || tempstate == "重请") &&
(cbo_state.Text == "已接" || cbo_state.Text == "待接")) || flag == false)
{
state1 = cbo_state.Text;
time1 = dt_time.Value.ToString("yyyy/MM/dd");
principal1 = cbo_principal.Text;
mysql = string.Format("INSERT INTO [Parents-Tutors] (家长编号,打印编号,经办状态,经办时间,经办人," +
"处理备注,教员编号,教员姓名) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", parent_num1, print_num1, state1,
time1, principal1, txt_remark.Text.Trim(), cbo_tutors_num.Text.Trim(), txt_tutors_name.Text.Trim());
}
else if (flag == true)
{
mysql = string.Format("UPDATE [Parents-Tutors] SET 经办状态='{0}',经办时间='{1}',经办人='{2}',处理备注='{3}'" +
"WHERE ID='{4}'", state1, time1, principal1, txt_remark.Text.Trim(), ID);////////这里更新要根据选择的教员编号的最新条！！！！！！
}
else
{
}
mydb.ExecuteNonQuery(mysql);
// }
/* else
* {
* mysql = string.Format("INSERT INTO [Relationship] (家长编号,打印编号,经办状态,经办时间,经办人," +
* "处理备注,教员编号) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", parent_num1, print_num1, state1,
* time1, principal1, txt_remark.·Text.Trim(), txt_tutors_num.Text.Trim());
* }*/
mysql = string.Format("SELECT ID FROM [Tutors-Parents] WHERE 教员编号='{0}' AND 打印编号='{1}' "
, cbo_tutors_num.Text.Trim(), print_num1);
int i = mydb.Rownum(mysql);
if (i > 0)
{
mysql = string.Format("SELECT ID FROM [Tutors-Parents] WHERE ID= " +
"(SELECT MAX(ID) FROM [Tutors-Parents] WHERE 教员编号='{0}' AND 打印编号='{1}') "
, cbo_tutors_num.Text.Trim(), print_num1);
ID2 = mydb.Returnafield(mysql);
mysql = string.Format("UPDATE [Tutors-Parents] SET 家长编号='{0}',打印编号='{1}',经办状态='{2}',经办时间='{3}',经办人='{4}',处理备注='{5}'" +
"WHERE ID='{6}'", parent_num1, print_num1, state1, time1, principal1, txt_remark.Text.Trim(), ID2);////这里有问题！！！！！数据溢出！！！！！
}
else
{
mysql = string.Format("INSERT INTO [Tutors-Parents] (家长编号,打印编号,经办状态,经办时间,经办人," +
"处理备注,教员编号) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", parent_num1, print_num1, state1,
time1, principal1, txt_remark.Text.Trim(), cbo_tutors_num.Text.Trim());
}
mydb.ExecuteNonQuery(mysql);
this.Close();
// UpDate2(cbo_state.Text,state1,time1);
UpDate2(cbo_tutors_state.SelectedItem.ToString(), dt_time.Value.ToString("yyyy/MM/dd"));
}
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);
}
}
