private void Tools_Clicked(object tag) { if (tag != null) { switch (tag.ToString()) { case "1": #region 添加学生 using (frmAddStudent frm = new frmAddStudent(null)) { if (frm.ShowDialog() == DialogResult.OK) { string sql = "INSERT INTO [Students] " + "([XH], [XM], [MM], [XB], [NJ], [DH], [DZ], [CSRQ], [Email]) VALUES " + "('{0}', '{1}', '{2}', {3}, {4}, '{5}', '{6}', '{7}', '{8}')"; sql = string.Format(sql, frm.XH, frm.XM, frm.MM, frm.XB, frm.NJ, frm.DH, frm.DZ, frm.CSRQ, frm.Email); using (SqlServerHelper ssh = new SqlServerHelper( DataConst.dataBase, DataConst.userName, DataConst.password)) { object o = ssh.ExecuteScalar(string.Format("Select count(*) from Students where xh = '{0}'", frm.XH)); if ((int)o != 0) { MessageBox.Show(string.Format("学号为 {0} 的学生已经存在,请重新分配学号!", frm.XH), "添加学生出错提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (ssh.ExecuteNonQuery(sql) > 0) { this.DialogResult = DialogResult.OK; } } } } } #endregion break; case "2": #region 修改学生 if (lvStudents.SelectedItems.Count > 0) { ListViewItem lvi = lvStudents.SelectedItems[0]; if (lvi != null && lvi.Tag is DataRow) { using (frmAddStudent frm = new frmAddStudent(lvi.Tag as DataRow, true)) { if (frm.ShowDialog() == DialogResult.OK) { } } } else { MessageBox.Show("选中的学生信息不正确!"); } } else { MessageBox.Show("请先选中需要修改的学生!"); } #endregion break; case "3": #region 修改密码 using (frmAlterPwd frm = new frmAlterPwd(m_UserName)) { if (frm.ShowDialog() == DialogResult.OK) { } } #endregion break; case "4": #region 查询学生 using (frmEnquiry frm = new frmEnquiry("Students")) { if (frm.ShowDialog() == DialogResult.OK) { } } #endregion break; case "9": this.Close(); break; } } }
private void Tools_Clicked(object tag) { if (tag != null) { switch (tag.ToString()) { case "1": #region 添加学生 using (frmAddStudent frm = new frmAddStudent(null)) { if (frm.ShowDialog() == DialogResult.OK) { string sql = "INSERT INTO [Students] " + "([XH], [XM], [MM], [XB], [NJ], [DH], [DZ], [CSRQ], [Email]) VALUES " + "('{0}', '{1}', '{2}', {3}, {4}, '{5}', '{6}', '{7}', '{8}')"; sql = string.Format(sql, frm.XH, frm.XM, frm.MM, frm.XB, frm.NJ, frm.DH, frm.DZ, frm.CSRQ, frm.Email); using (SqlServerHelper ssh = new SqlServerHelper( DataConst.dataBase, DataConst.userName, DataConst.password)) { object o = ssh.ExecuteScalar(string.Format("Select count(*) from Students where xh = '{0}'", frm.XH)); if ((int)o != 0) { MessageBox.Show(string.Format("学号为 {0} 的学生已经存在,请重新分配学号!", frm.XH), "添加学生出错提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (ssh.ExecuteNonQuery(sql) > 0) { this.DialogResult = DialogResult.OK; } } } } } #endregion break; case "2": #region 修改学生 if (lvStudents.SelectedItems.Count > 0) { ListViewItem lvi = lvStudents.SelectedItems[0]; if (lvi != null && lvi.Tag is DataRow) { using (frmAddStudent frm = new frmAddStudent(lvi.Tag as DataRow, true)) { if (frm.ShowDialog() == DialogResult.OK) { } } } else MessageBox.Show("选中的学生信息不正确!"); } else MessageBox.Show("请先选中需要修改的学生!"); #endregion break; case "3": #region 修改密码 using (frmAlterPwd frm = new frmAlterPwd(m_UserName)) { if (frm.ShowDialog() == DialogResult.OK) { } } #endregion break; case "4": #region 查询学生 using (frmEnquiry frm = new frmEnquiry("Students")) { if (frm.ShowDialog() == DialogResult.OK) { } } #endregion break; case "9": this.Close(); break; } } }