private void btn_save_Click(object sender, EventArgs e)
{
//封装数组
TextBox[] txt = { txt_num, txt_name, txt_student_num, txt_phone, txt_position };
string[] message = { "职工编号", "职工姓名", "学号", "联系方式", "职位" };
string mysql = "";
//操作提示
for (int i = 0; i < txt.Length; i++)
{
if (is_empty(txt[i].Text.Trim()))
{
MessageBox.Show("请输入" + message[i] + "！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
//初始化数据
worker1.worker_num = txt_num.Text.Trim();
worker1.name = txt_name.Text.Trim();
worker1.student_num = txt_student_num.Text.Trim();
worker1.subject = cbo_subject.Text.Trim();
worker1.phone = txt_phone.Text.Trim();
worker1.position = txt_position.Text.Trim();
if (rdo_man.Checked == true)
{
worker1.sex = "男";
}
rdo_man.Checked = true;
if (rdo_woman.Checked == true)
{
worker1.sex = "女";
}
worker1.isleave = cbo_yesno.SelectedItem.ToString();
worker1.month_score = txt_month.Text.Trim();
worker1.total_score = txt_total.Text.Trim();
//插入新家教信息
if (insertstate == true)
{
mysql = "insert into worker " + insert_worker_str + " values " + worker1.connectstr();
DialogResult result = MessageBox.Show("确认新增职工信息？", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
try
{
mydb.ExecuteNonQuery(mysql);
mysql = string.Format("insert into user (username,password,degree) values ('{0}','{1}','{2}')",
worker1.worker_num, worker1.student_num, "操作员");
mydb.ExecuteNonQuery(mysql);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
MessageBox.Show("新增成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
dgvfresh();
}
}
//更新保存现有家教信息
else
{
mysql = worker1.updatestr();
DialogResult result = MessageBox.Show("确认更新职工信息？", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
try
{
mydb.ExecuteNonQuery(mysql);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
MessageBox.Show("更新成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
dgvfresh();
}
}
}
/// <summary>
/// 新增或更新家教信息 标志位insertnum
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_save_Click(object sender, EventArgs e)
{
string history = "";
//封装数组
TextBox[] txt = { txt_parent_num, txt_print_num, txt_parent_name, txt_phone, txt_sadd, txt_dadd,
txt_grade_stu, txt_subject_stu, txt_tutor_price, txt_tutor_time };
string[] message = { "家长编号", "打印编号", "家长称呼", "联系电话", "家长地址（简单）", "家长地址（详细）", "年级", "科目",
"家教价格", "家教时间" };
string mysql = "";
//操作提示
for (int i = 0; i < txt.Length; i++)
{
if (is_empty(txt[i].Text.Trim()))
{
MessageBox.Show("请输入" + message[i] + "！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
if (is_empty(cbo_reception.SelectedItem.ToString()))
{
MessageBox.Show("请选择接待人！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (rdo_woman.Checked == false && rdo_man.Checked == false)
{
MessageBox.Show("请选择学员性别！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//初始化数据
//判断科目是否被更改
bool subject_changed = false;
if (tutoring1.subject_stu != txt_subject_stu.Text.Trim())
{
subject_changed = true;
}
updateinfo(ref history, ref tutoring1.parent_num, txt_parent_num.Text.Trim());
updateinfo(ref history, ref tutoring1.print_num, txt_print_num.Text.Trim());
updateinfo(ref history, ref tutoring1.parent_name, txt_parent_name.Text.Trim());
updateinfo(ref history, ref tutoring1.reception, cbo_reception.SelectedItem.ToString());
updateinfo(ref history, ref tutoring1.phone, txt_phone.Text.Trim());
updateinfo(ref history, ref tutoring1.simple_adr, txt_sadd.Text.Trim());
updateinfo(ref history, ref tutoring1.detail_adr, txt_dadd.Text.Trim());
updateinfo(ref history, ref tutoring1.grade_stu, txt_grade_stu.Text.Trim());
updateinfo(ref history, ref tutoring1.subject_stu, txt_subject_stu.Text.Trim());
tutoring1.reception_time = dt_recepiton_time.Value.ToString();
/*tutoring1.parent_num = txt_parent_num.Text.Trim();
* tutoring1.print_num = txt_print_num.Text.Trim();
* tutoring1.reception = cbo_reception.SelectedItem.ToString();
*
* tutoring1.parent_name = txt_parent_name.Text.Trim();
* tutoring1.phone = txt_phone.Text.Trim();
* tutoring1.simple_adr = txt_sadd.Text.Trim();
* tutoring1.detail_adr = txt_dadd.Text.Trim();
* tutoring1.grade_stu = txt_grade_stu.Text.Trim();
* tutoring1.subject_stu = txt_subject_stu.Text.Trim();*/
if (rdo_man.Checked == true)
{
tutoring1.student_sex = "男";
}
if (rdo_woman.Checked == true)
{
tutoring1.student_sex = "女";
}
updateinfo(ref history, ref tutoring1.tutors_price, txt_tutor_price.Text.Trim());
updateinfo(ref history, ref tutoring1.tutors_time, txt_tutor_time.Text.Trim());
updateinfo(ref history, ref tutoring1.sex, cbo_sex.SelectedItem.ToString());
updateinfo(ref history, ref tutoring1.place, txt_place.Text.Trim());
updateinfo(ref history, ref tutoring1.grade, txt_grade.Text.Trim());
updateinfo(ref history, ref tutoring1.subject, txt_subject.Text.Trim());
updateinfo(ref history, ref tutoring1.other_requests, txt_other_requests.Text.Trim());
/*tutoring1.tutors_price = txt_tutor_price.Text.Trim();
* tutoring1.tutors_time = txt_tutor_time.Text.Trim();
* tutoring1.sex = cbo_sex.SelectedItem.ToString();
* tutoring1.place = txt_place.Text.Trim();
* tutoring1.grade = txt_grade.Text.Trim();
* tutoring1.subject = txt_subject.Text.Trim();
* tutoring1.other_requests = txt_other_requests.Text.Trim();*/
bool payment_changed = false;
if (tutoring1.payment_state != "已缴" && cbo_payment_state.SelectedItem.ToString() == "已缴")
{
payment_changed = true;
}
updateinfo(ref history, ref tutoring1.payment_state, cbo_payment_state.SelectedItem.ToString());
//tutoring1.payment_state = cbo_payment_state.SelectedItem.ToString();
subject = tutoring1.subject_stu.Split('、');
if (tutoring1.payment_state != "已缴")
{
tutoring1.payment_time = null;
}
else
{
tutoring1.payment_time = dt_payment_time.Value.ToString();
}
tutoring1.latest_time = DateTime.Now.ToString();
//插入新家教信息
if (insertstate == true)
{
tutoring1.tutor_state = "接入";
tutoring1.remarks = "";
mysql = "insert into tutoring " + insert_tutoring_str + " values " + tutoring1.connectstr();
DialogResult result = MessageBox.Show("确认新增家教信息？", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
try
{
mydb.ExecuteNonQuery(mysql);
Console.WriteLine(history);
mysql = string.Format("insert into history (user,optype,num,time,content) values ('{0}', '{1}', '{2}', '{3}','{4}')",
user, "新增家教信息", tutoring1.print_num, DateTime.Now.ToString(), history);
Console.WriteLine(mysql);
mydb.ExecuteNonQuery(mysql);
if (tutoring1.payment_time != null)
{
mydb.update_payment_date(tutoring1.print_num, tutoring1.payment_time);
if (payment_changed == true)
{
mysql = string.Format("insert into history (user,optype,num,time) values ('{0}', '{1}', '{2}', '{3}')",
user, "缴费", tutoring1.print_num, DateTime.Now.ToString());
mydb.ExecuteNonQuery(mysql);
}
}
for (int i = 0; i < subject.Length; i++)
{
//string insert_business_str = "(print_num,tutor_num,subject,state,time,reception,remarks,now";
mysql = string.Format("insert into business (print_num,subject,time,reception) values ('{0}', '{1}', '{2}', '{3}')",
tutoring1.print_num, subject[i], DateTime.Now.ToString(), tutoring1.reception);
mydb.ExecuteNonQuery(mysql);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
MessageBox.Show("保存成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
dgvfresh();
}
}
//更新保存现有家教信息
else
{
mysql = tutoring1.updatestr();
DialogResult result = MessageBox.Show("确认更新家教信息？", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
try
{
mydb.ExecuteNonQuery(mysql);
mysql = string.Format("insert into history (user,optype,num,time,content) values ('{0}', '{1}', '{2}', '{3}','{4}')",
user, "更新家教信息", tutoring1.print_num, DateTime.Now.ToString(), history);
mydb.ExecuteNonQuery(mysql);
if (tutoring1.payment_time != null)
{
mydb.update_payment_date(tutoring1.print_num, tutoring1.payment_time);
if (payment_changed == true)
{
mysql = string.Format("insert into history (user,optype,num,time) values ('{0}', '{1}', '{2}', '{3}')",
user, "缴费", tutoring1.print_num, DateTime.Now.ToString());
mydb.ExecuteNonQuery(mysql);
}
}
///更新关于科目的更更改
///
if (subject_changed == true)
{
string temp = "";
for (int i = 0; i < subject.Length; i++)
{
mysql = string.Format("insert into business(print_num, subject, time) select '{0}','{1}','{2}' from dual " +
"where not exists(select 1 from business where print_num = '{3}' and subject ='{4}')", tutoring1.print_num,
subject[i], DateTime.Now.ToString(), tutoring1.print_num, subject[i]);
temp += "'" + subject[i] + "',";
mydb.ExecuteNonQuery(mysql);
}
temp = temp.Substring(0, temp.Length - 1);
mysql = "update business set now=0 where print_num='" + tutoring1.print_num +
"' and subject not in(" + temp + ")";
Console.WriteLine(mysql);
mydb.ExecuteNonQuery(mysql);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
MessageBox.Show("更新成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
dgvfresh();
}
}
}
/// <summary>
/// 新增或更新教员信息 标志位insertstate
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_save_Click(object sender, EventArgs e)
{
//封装数组
TextBox[] txt = { txt_num, txt_student_name, txt_student_num, txt_phone, txt_place };
string[] message = { "教员编号", "教员姓名", "学号", "联系方式", "生源地" };
string mysql = "";
//操作提示
for (int i = 0; i < txt.Length; i++)
{
if (is_empty(txt[i].Text.Trim()))
{
MessageBox.Show("请输入" + message[i] + "！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
//初始化数据
tutor1.tutor_num = txt_num.Text.Trim();
tutor1.name = txt_student_name.Text.Trim();
tutor1.student_num = txt_student_num.Text.Trim();
tutor1.subject = cbo_subject.Text.Trim();
tutor1.degree = cbo_degree.SelectedItem.ToString();
tutor1.phone = txt_phone.Text.Trim();
tutor1.place = txt_place.Text.Trim();
if (rdo_man.Checked == true)
{
tutor1.sex = "男";
}
rdo_man.Checked = true;
if (rdo_woman.Checked == true)
{
tutor1.sex = "女";
}
tutor1.remarks = txt_important_remarks.Text.Trim();
tutor1.blacklist = cbo_yesno.SelectedItem.ToString();
tutor1.explantion = txt_imprisonment.Text.Trim();
//插入新家教信息
if (insertstate == true)
{
mysql = "insert into tutor " + insert_tutor_str + " values " + tutor1.connectstr();
Console.WriteLine(mysql);
DialogResult result = MessageBox.Show("确认新增教员信息？", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
try
{
mydb.ExecuteNonQuery(mysql);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
MessageBox.Show("新增成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
dgvfresh();
}
}
//更新保存现有家教信息
else
{
mysql = tutor1.updatestr();
Console.WriteLine(mysql);
DialogResult result = MessageBox.Show("确认更新教员信息？", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
try
{
mydb.ExecuteNonQuery(mysql);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
MessageBox.Show("更新成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
dgvfresh();
}
}
}
private void btn_save_Click(object sender, EventArgs e)
{
//封装数组
TextBox[] txt = { txt_username, txt_password };
string[] message = { "用户名", "密码" };
string mysql = "";
//操作提示
for (int i = 0; i < txt.Length; i++)
{
if (is_empty(txt[i].Text.Trim()))
{
MessageBox.Show("请输入" + message[i] + "！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
//初始化数据
username = txt_username.Text.Trim();
password = txt_password.Text.Trim();
level = cbo_degree.SelectedItem.ToString();
//插入新信息
if (insertstate == true)
{
mysql = string.Format("insert into user (username,password,degree) values ('{0}','{1}','{2}')", username, password, level);
DialogResult result = MessageBox.Show("确认新增？", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
try
{
mydb.ExecuteNonQuery(mysql);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
MessageBox.Show("新增成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
dgvfresh();
}
}
//更新保存现有家教信息
else
{
mysql = "update user set password='******',degree='" + level + "' where username='******'";
DialogResult result = MessageBox.Show("确认更新？", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
try
{
mydb.ExecuteNonQuery(mysql);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
MessageBox.Show("更新成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
dgvfresh();
}
}
}