/// <summary> /// 新增家教信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_add_Click(object sender, EventArgs e) { string mysql = ""; int tempnum = 0; if (dgv_search.SelectedRows.Count > 0) { dgv_search.SelectedRows[0].Selected = false; } //重置tutoring1 tutoring1.reset(); insertstate = true; //数据准备,初始化家长编号和打印编号 //家长编号+1 mysql = "select max(parent_num) from tutoring"; try { tempnum = int.Parse(mydb.Returnafield(mysql)) + 1; } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } tutoring1.parent_num = tempnum.ToString(); //打印编号+1 mysql = "select max(print_num) from tutoring"; try { tempnum = int.Parse(mydb.Returnafield(mysql)) + 1; } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } tutoring1.print_num = tempnum.ToString(); //初始化缴费、家教状态和性别 cbo_payment_state.SelectedItem = "无需缴纳"; tutoring1.payment_state = "无需缴纳"; cbo_tutor_state.SelectedItem = "接入"; tutoring1.tutor_state = "接入"; rdo_man.Checked = false; rdo_woman.Checked = false; tutoring1.grade = "不限"; cbo_reception.SelectedItem = null; //判断数组非空 btn_buss.Enabled = false; btn_tutor_info.Enabled = false; showtutoring(); }
/// <summary> /// 新增教员信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_add_Click(object sender, EventArgs e) { string mysql = ""; int tempnum = 0; if (dgv_search.SelectedRows.Count > 0) { dgv_search.SelectedRows[0].Selected = false; } //重置tutor1 tutor1.reset(); insertstate = true; //数据准备,初始化教员编号 //教员编号+1 mysql = "select max(tutor_num) from tutor"; try { tempnum = int.Parse(mydb.Returnafield(mysql)) + 1; } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } tutor1.tutor_num = tempnum.ToString(); //初始化学位和性别和是否黑名单 cbo_degree.SelectedItem = null; rdo_man.Checked = false; rdo_woman.Checked = false; cbo_yesno.SelectedItem = "否"; //判断数组非空 showtutor(); }
private void btn_login_Click(object sender, EventArgs e) { objectclass.userinfo.username = txt_user.Text; objectclass.userinfo.password = txt_pwd.Text; string mysql = ""; mysql = string.Format("select * from user where username='******' and password='******'", objectclass.userinfo.username, objectclass.userinfo.password); try { int i = mydb.Rownum(mysql); if (i == 0) { MessageBox.Show("您输入的用户名或密码错误!请重试", "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txt_pwd.Text = ""; return; } else { mysql = "select degree from user where username='******'"; objectclass.userinfo.degree = mydb.Returnafield(mysql); this.Hide(); Form myform = new mainform(); myform.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } }
private void mainform_Load(object sender, EventArgs e) { commondb mydb = new commondb(); string mysql = ""; string name = ""; mysql = "select name from worker where worker_num='" + username + "'"; int count = 0; try { count = mydb.Rownum(mysql); if (count > 0) { name = mydb.Returnafield(mysql); lbl_user_num.Text = username; lbl_user_name.Text = name; lbl_admin.Visible = false; } if (degree == "管理员") { lbl_user_num.Text = username; lbl_user_name.Text = ""; lbl_admin.Visible = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } }
private void btn_yes_Click(object sender, EventArgs e) { string inputpwd = txt_pwd.Text.ToString(); string mysql = ""; mysql = "select password from user where username='******'"; string password = mydb.Returnafield(mysql); if (password == inputpwd) { admincheck(true); this.Close(); } else { admincheck(false); } }