public bool Delete(Stuinfo stu, out string msg) { int result = dal.Delete(stu, out msg); if (result > 0) { return(true); } return(false); }
public bool IsLoginSuccess(Stuinfo stu, out string msg) { int result = dal.Islogin(stu, out msg); if (result > 0) { return(true); } return(false); }
public bool IsUpdateSucces(Stuinfo stu, out string msg) { int result = dal.UpDateStuInfo(stu, out msg); if (result > 0) { return(true); } return(false); }
/// <summary> /// 提交按键功能 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSubmit_Click(object sender, EventArgs e) { Stuinfo stu = new Stuinfo(); #region 是否有修改 stu.SNO = txtSNO.Text; stu.Pwd = txtPwd.Text; stu.StuName = txtStuName.Text; if (Convert.ToInt32(txtAge.Text) <= 35 && Convert.ToInt32(txtAge.Text) > 1) { stu.Age = Convert.ToInt32(txtAge.Text); } else { MessageBox.Show("你输入的年龄不符合规则,请重新输入"); txtAge.Focus(); return; } if (rboMan.Checked == true) { stu.Sex = "男"; } else if (rboWoman.Checked == true) { stu.Sex = "女"; } stu.Address = txtAddress.Text; #endregion bool result = bll.IsUpdateSucces(stu, out msg); if (msg != "") { MessageBox.Show(msg); } if (result) { MessageBox.Show("编辑成功"); BindData(); frmStuinfoManage frm = new frmStuinfoManage(); frm.Show(); this.Close(); } else { MessageBox.Show("填入的数据有误,请核对过后重新输入"); } }
public Stuinfo GetStuInfo(Stuinfo stu, out string msg) { Stuinfo[] list = dal.GetStuInfoList(stu, false, out msg); if (list != null) { Stuinfo s = list[0]; return(s); } return(null); }
/// <summary> /// 删除按键功能 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDel_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("是否确认删除", "删除提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2); if (dr == System.Windows.Forms.DialogResult.Yes) { Stuinfo s = new Stuinfo(); s.SNO = dgvStuinfo.SelectedRows[0].Cells["SNO"].Value.ToString(); bool result = bll.Delete(s, out msg); MessageBox.Show("删除成功"); BindData(); } }
public ActionResult EditModel(Stuinfo stu) { string sql = "UPDATE STUINFO set Name=:Name,Sex=:Sex,Age=:Age,Email=:Email,CId=:CId,AddTime=:AddTime where ID=:ID"; using (OracleConnection conn = DapperFactory.CrateOracleConnection()) { if (conn.Execute(sql, stu) < 0) { ViewBag.Msg = "修改失败!"; } return(RedirectToAction("Index")); } }
public int Islogin(Stuinfo stu, out string msg) { StringBuilder sb = new StringBuilder(); sb.Append("select count(1) from stuInfo where 1=1"); SqlParameter sqsno = new SqlParameter("@sno", stu.SNO); SqlParameter sqpwd = new SqlParameter("@pwd", stu.Pwd); SqlParameter[] sqlist = { sqsno, sqpwd }; return(Convert.ToInt32(sh.ExecuteScalar(sb.ToString(), sqlist, out msg))); }
/// <summary> /// 删除一条选中信息 /// </summary> /// <param name="stu"></param> /// <param name="msg"></param> /// <returns></returns> public int Delete(Stuinfo stu, out string msg) { StringBuilder sb = new StringBuilder(); sb.Append("delete from stuinfo where "); if (!string.IsNullOrEmpty(stu.SNO)) { sb.AppendFormat(" sno = '{0}'", stu.SNO); } int result = sh.ExecuteNonquery(sb.ToString(), out msg); return(result); }
/// <summary> /// 获取学生信息 /// </summary> /// <param name="stu"></param> /// <param name="isLike"></param> /// <param name="msg"></param> /// <returns></returns> public Stuinfo[] GetStuInfoList(Stuinfo stu, bool isLike, out string msg) { StringBuilder sb = new StringBuilder(); sb.Append("select * from stuinfo where 1=1 "); if (isLike) { //不显示admin这一行的值 sb.Append(" and sno <> 'admin' "); if (!string.IsNullOrEmpty(stu.SNO)) { sb.AppendFormat(" and sno like '%{0}%'", stu.SNO); } } else { sb.AppendFormat("and sno = '{0}'", stu.SNO); } if (!string.IsNullOrEmpty(stu.StuName)) { sb.AppendFormat(" and stuname like '%{0}%'", stu.StuName); } DataTable dt = sh.ExecuteDataAdapter(sb.ToString(), out msg); if (dt != null && dt.Rows.Count > 0) { Stuinfo[] list = new Stuinfo[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { Stuinfo s = new Stuinfo(); s.SNO = dt.Rows[i]["SNO"].ToString(); s.Pwd = dt.Rows[i]["pwd"].ToString(); s.StuName = dt.Rows[i]["StuName"].ToString(); s.Sex = dt.Rows[i]["Sex"].ToString(); s.Age = dt.Rows[i]["Age"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[i]["Age"]); s.Address = dt.Rows[i]["Address"] == DBNull.Value ? "" : dt.Rows[i]["Address"].ToString(); s.Role = dt.Rows[i]["Role"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[i]["Role"]); s.BirthDay = dt.Rows[i]["BirthDay"] == DBNull.Value ? DateTime.Now.AddYears(-150) : Convert.ToDateTime(dt.Rows[i]["BirthDay"]); list[i] = s; } return(list); } return(null); }
/// <summary> /// 双击修改事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvStuinfo_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { //赋值 Stuinfo s = new Stuinfo(); s.SNO = dgvStuinfo.SelectedRows[0].Cells["SNO"].Value.ToString(); s.Pwd = dgvStuinfo.SelectedRows[0].Cells["Pwd"].Value.ToString(); s.StuName = dgvStuinfo.SelectedRows[0].Cells["StuName"].Value.ToString(); s.Sex = dgvStuinfo.SelectedRows[0].Cells["Sex"].Value.ToString(); s.Age = dgvStuinfo.SelectedRows[0].Cells["Age"].Value == DBNull.Value ? 0 : Convert.ToInt32(dgvStuinfo.SelectedRows[0].Cells["Age"].Value); s.Address = dgvStuinfo.SelectedRows[0].Cells["Address"].Value == DBNull.Value ? "" : dgvStuinfo.SelectedRows[0].Cells["Address"].Value.ToString(); frmStuEdit stu = new frmStuEdit(s); stu.Show(); }
/// <summary> /// 登录管理 /// </summary> /// <param name="stu"></param> /// <param name="msg"></param> public void IsLogin(Stuinfo stu, out string msg) { bool result = bll.IsLoginSuccess(stu, out msg); if (msg != "") { MessageBox.Show("msg"); } if (result) { //管理员登录 if (rboadminlogin.Checked) { if (frmMain == null) { frmMain = new frmAdminMain(this); } frmMain.CloseALLChildForm(); frmMain.Show(); } //学生登录 if (rboStuLogin.Checked) { if (stu.SNO != "admin") { frmStuMain frm = new frmStuMain(stu.SNO); frm.Show(); } else { MessageBox.Show("请输入学生账号!"); txtAccount.Text = ""; txtPwd.Text = ""; return; } } this.Hide(); } else { MessageBox.Show("您输入的账号或密码错误,请重新输入"); } }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { Stuinfo stu = new Stuinfo(); stu.SNO = txtSNO.Text; stu.StuName = txtStuname.Text; Stuinfo[] list = bll.GetStuInfoList(stu, out msg); //error message if (msg != "") { MessageBox.Show(msg); } if (list == null) { list = new Stuinfo[0]; } dgvStuinfo.DataSource = list; }
public int update_stuinfo(Stuinfo stu1) { conn.Open(); comm = new SqlCommand("stuinfo_update", conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.AddWithValue("@stu_id", stu1.Stu_id); comm.Parameters.AddWithValue("@stu_name", stu1.stu_name); comm.Parameters.AddWithValue("@stu_sex", stu1.stu_sex); comm.Parameters.AddWithValue("@stu_nation", stu1.stu_nation); comm.Parameters.AddWithValue("@stu_birrhday", stu1.stu_birrhday); comm.Parameters.AddWithValue("@stu_rutime", stu1.stu_rutime); comm.Parameters.AddWithValue("@stu_class", stu1.stu_class); comm.Parameters.AddWithValue("@stu_home", stu1.stu_home); comm.Parameters.AddWithValue("@stu_else", stu1.stu_else); int result = comm.ExecuteNonQuery(); conn.Close(); return(result); }
/// <summary> /// 提交已编辑学生信息 /// </summary> /// <param name="stu"></param> /// <param name="msg"></param> /// <returns></returns> public int UpDateStuInfo(Stuinfo stu, out string msg) { StringBuilder sb = new StringBuilder(); sb.Append("update stuinfo set "); #region 插入数据 if (!string.IsNullOrEmpty(stu.Pwd)) { sb.AppendFormat(" pwd = '{0}',", stu.Pwd); } if (!string.IsNullOrEmpty(stu.StuName)) { sb.AppendFormat(" StuName = '{0}',", stu.StuName); } if (!string.IsNullOrEmpty(stu.Age.ToString())) { sb.AppendFormat(" Age = '{0}',", stu.Age); } if (!string.IsNullOrEmpty(stu.Sex)) { sb.AppendFormat(" Sex = '{0}',", stu.Sex); } if (!string.IsNullOrEmpty(stu.Address)) { sb.AppendFormat(" Address = '{0}',", stu.Address); } if (!string.IsNullOrEmpty(stu.BirthDay.ToString())) { sb.AppendFormat(" BirthDay = '{0}',", stu.BirthDay); } sb.Remove(sb.Length - 1, 1); #endregion if (!string.IsNullOrEmpty(stu.SNO)) { sb.AppendFormat(" where sno = '{0}' ", stu.SNO); } int result = sh.ExecuteNonquery(sb.ToString(), out msg); return(result); }
/// <summary> /// 获取信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnGetStuInfo_Click(object sender, EventArgs e) { if (txtSNO.Text == "") { MessageBox.Show("请输入学号"); txtSNO.Focus(); return; } Stuinfo stu = new Stuinfo(); stu.SNO = txtSNO.Text; txtSNO.Enabled = false; Stuinfo s = bll.GetStuInfo(stu, out msg); if (s != null) // { txtSNO.Text = s.SNO; txtStuName.Text = s.StuName; txtPwd.Text = s.Pwd; txtAge.Text = s.Age.ToString(); if (s.Sex == "男") { rboMan.Checked = true; } else if (s.Sex == "女") { rboWoman.Checked = true; } txtAddress.Text = s.Address; } else { MessageBox.Show("该学号不存在"); Clear(); } }
public void Login() { if (!CheckTxTControl()) { return; } Stuinfo stu = new Stuinfo(); stu.SNO = txtAccount.Text; stu.Pwd = txtPwd.Text; //管理员登陆 if (rboadminlogin.Checked) { IsLogin(stu, out msg); } //学生登陆 if (rboStuLogin.Checked) { IsLogin(stu, out msg); } }
/// <summary> /// 添加操作 /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> public ActionResult AddStuinfo(Stuinfo stuinfo) { if (ModelState.IsValid) { string sql = "insert into Stuinfo(Name,Sex,Age,Email,CId,AddTime) VALUES(:Name,:Sex,:Age,:Email,:CId,:AddTime)"; using (OracleConnection conn = DapperFactory.CrateOracleConnection()) { stuinfo.AddTime = DateTime.Now; if (conn.Execute(sql, stuinfo) > 0) { return(RedirectToAction("Index")); } else { ViewBag.Msg = "添加失败!"; return(View(stuinfo)); } } } else { return(HttpNotFound()); } }
/// <summary> /// 提交执行增删改的数据 /// </summary> /// <param name="sc"></param> /// <param name="op">0-删除,1-添加,2-修改</param> /// <param name="msg"></param> /// <returns></returns> public int StuEdit(Stuinfo stu, int op, out string msg) { StringBuilder sb = new StringBuilder(); switch (op) { case 0: sb.AppendFormat("delete from Stuinfo where SNO={0}", stu.SNO); break; case 1: sb.AppendFormat("insert into Stuinfo values('{0}',", stu.SNO); sb.AppendFormat("{0},", stu.Age); sb.AppendFormat("{0},", stu.StuName); sb.AppendFormat("{0},", stu.Sex); sb.AppendFormat("{0},", stu.Address); sb.AppendFormat("{0},)", stu.BirthDay); break; case 2: sb.AppendFormat("update Stuinfo set Age = '{0}' ", stu.Age); sb.AppendFormat(" and StuName = '{0}'", stu.StuName); sb.AppendFormat("and Address = '{0}'", stu.Address); sb.AppendFormat("and BirthDay = '{0}'", stu.BirthDay); sb.AppendFormat(" where sno = '{0}'", stu.SNO); break; default: msg = "输入的操作无法识别"; return(0); } return(sh.ExecuteNonquery(sb.ToString(), out msg)); }
public Stuinfo[] GetStuInfoList(Stuinfo stu, out string msg) { Stuinfo[] list = dal.GetStuInfoList(stu, true, out msg); return(list); }
public frmStuEdit(Stuinfo stu) { InitializeComponent(); s = stu; }