private void btnConfirmClick(object sender, EventArgs e) { BLL.tb_user dal = new BLL.tb_user(); Model.tb_user model = new Model.tb_user(); if (this.txtpwd.Text.Trim() == "") { MessageBox.Show("请输入旧密码", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.txtpwd.Focus(); return; } if (this.txtpassword.Text.Trim() == "") { MessageBox.Show("请输入新密码", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.txtpassword.Focus(); return; } if (this.txtpasswordok.Text.Trim() == "") { MessageBox.Show("请再次输入新密码", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.txtpasswordok.Focus(); return; } if (!String.IsNullOrEmpty(m_id)) { DataRow[] dr = dal.GetList(" ").Tables[0].Select(" u_id=" + m_id); if (dr.Length > 0) { if (dr[0]["u_pwd"].ToString() != txtpwd.Text.Trim().ToString()) { MessageBox.Show("旧密码错误", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.txtpwd.Focus(); this.txtpwd.Text = ""; this.txtpassword.Text = ""; this.txtpasswordok.Text = ""; } else { if (this.txtpassword.Text != this.txtpasswordok.Text) { MessageBox.Show("两次新密码不一致", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { model = dal.GetModel(int.Parse(m_id)); model.u_pwd = this.txtpasswordok.Text; dal.Update(model); // DialogResult result= MessageBox.Show("","",MessageBo) MessageBox.Show("修改密码成功", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtpwd.Text = ""; this.txtpassword.Text = ""; this.txtpasswordok.Text = ""; this.Close(); } } } } }
private void dgvCellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } optrowid = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); if (!String.IsNullOrEmpty(optrowid)) { model = dal.GetModel(Int32.Parse(optrowid)); if (model != null) { txtname.Text = model.u_name; txtlogname.Text = model.u_log; txttel.Text = model.u_tel; txtemail.Text = model.u_email; } } }
private void tbBtnClick(object sender, ToolBarButtonClickEventArgs e) { if (e.Button.ToolTipText == "新增") { rstValue(); setModifyMode(true); optrowid = null; } if (e.Button.ToolTipText == "修改") { if (!String.IsNullOrEmpty(optrowid)) { setModifyMode(true); } else { MessageBox.Show("请选择所要修改的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "删除") { if (!String.IsNullOrEmpty(optrowid)) { DialogResult result = MessageBox.Show("确认删除?", "删除数据", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { dal.Delete(int.Parse(optrowid)); rstValue(); MessageBox.Show("恭喜你,删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); bindData(" u_type=1 "); setModifyMode(false); optrowid = null; } } else { MessageBox.Show("请选择所要删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "提交") { if (validateInput()) { model = new Model.tb_user(); if (!String.IsNullOrEmpty(optrowid)) { model = dal.GetModel(int.Parse(optrowid)); } model.u_name = this.txtname.Text; model.u_log = this.txtlogname.Text; model.u_tel = this.txttel.Text; model.u_email = this.txtemail.Text; if (String.IsNullOrEmpty(optrowid)) { model.u_type = 1; model.u_adddate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm"); model.u_pwd = "000000"; int i = dal.Add(model); if (i > 0) { MessageBox.Show("恭喜你,新增成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData(" u_type=1 "); setModifyMode(false); optrowid = null; } } else { if (dal.Update(model)) { MessageBox.Show("恭喜你,修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData(" u_type=1 "); setModifyMode(false); optrowid = null; } } } } if (e.Button.ToolTipText == "取消") { bindData(" u_type=1 "); rstValue(); setModifyMode(false); optrowid = null; } if (e.Button.ToolTipText == "退出") { this.Close(); } }
private void btnConfirmClick(object sender, EventArgs e) { //string pgname = txtUser.Text.ToString().Trim(); //string pgpwd = txtPwd.Text.ToString().Trim(); string pgname = "admin"; string pgpwd = "admin"; if (pgname == "" || pgpwd == "") { MessageBox.Show("用户名或密码不能为空"); txtUser.Focus(); return; } user = dal.GetModel(pgname, pgpwd); if (user != null) { switch (user.u_type) { case 0: if (cbAccountType.Text != "管理员") { MessageBox.Show("登录权限错误"); } else { Views.Main f5 = new Views.Main(); f5.m_username = user.u_name; f5.m_id = user.u_id.ToString(); f5.m_ty = user.u_type.ToString(); f5.Show(); this.Hide(); } break; case 1: if (cbAccountType.Text != "普通用户") { MessageBox.Show("登录权限错误"); } else { Views.Main main = new Views.Main(); main.m_username = user.u_name; main.m_id = user.u_id.ToString(); main.m_ty = user.u_type.ToString(); main.Show(); this.Hide(); } break; default: MessageBox.Show("数据错误"); break; } } else { MessageBox.Show("用户名或密码不正确"); return; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.tb_user model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.u_log != null) { strSql1.Append("u_log,"); strSql2.Append("'" + model.u_log + "',"); } if (model.u_pwd != null) { strSql1.Append("u_pwd,"); strSql2.Append("'" + model.u_pwd + "',"); } if (model.u_no != null) { strSql1.Append("u_no,"); strSql2.Append("'" + model.u_no + "',"); } if (model.u_name != null) { strSql1.Append("u_name,"); strSql2.Append("'" + model.u_name + "',"); } if (model.u_tel != null) { strSql1.Append("u_tel,"); strSql2.Append("'" + model.u_tel + "',"); } if (model.u_email != null) { strSql1.Append("u_email,"); strSql2.Append("'" + model.u_email + "',"); } if (model.u_type != null) { strSql1.Append("u_type,"); strSql2.Append("" + model.u_type + ","); } if (model.u_sex != null) { strSql1.Append("u_sex,"); strSql2.Append("'" + model.u_sex + "',"); } if (model.u_address != null) { strSql1.Append("u_address,"); strSql2.Append("'" + model.u_address + "',"); } if (model.u_adddate != null) { strSql1.Append("u_adddate,"); strSql2.Append("'" + model.u_adddate + "',"); } strSql.Append("insert into tb_user("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbSQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public Model.tb_user GetModel(string log, string pwd) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" u_id,u_log,u_pwd,u_no,u_name,u_tel,u_email,u_type,u_sex,u_address,u_adddate "); strSql.Append(" from tb_user "); strSql.Append(" where u_log='" + log + "' and u_pwd='" + pwd + "' "); Model.tb_user model = new Model.tb_user(); DataSet ds = DbSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["u_id"] != null && ds.Tables[0].Rows[0]["u_id"].ToString() != "") { model.u_id = int.Parse(ds.Tables[0].Rows[0]["u_id"].ToString()); } if (ds.Tables[0].Rows[0]["u_log"] != null && ds.Tables[0].Rows[0]["u_log"].ToString() != "") { model.u_log = ds.Tables[0].Rows[0]["u_log"].ToString(); } if (ds.Tables[0].Rows[0]["u_pwd"] != null && ds.Tables[0].Rows[0]["u_pwd"].ToString() != "") { model.u_pwd = ds.Tables[0].Rows[0]["u_pwd"].ToString(); } if (ds.Tables[0].Rows[0]["u_no"] != null && ds.Tables[0].Rows[0]["u_no"].ToString() != "") { model.u_no = ds.Tables[0].Rows[0]["u_no"].ToString(); } if (ds.Tables[0].Rows[0]["u_name"] != null && ds.Tables[0].Rows[0]["u_name"].ToString() != "") { model.u_name = ds.Tables[0].Rows[0]["u_name"].ToString(); } if (ds.Tables[0].Rows[0]["u_tel"] != null && ds.Tables[0].Rows[0]["u_tel"].ToString() != "") { model.u_tel = ds.Tables[0].Rows[0]["u_tel"].ToString(); } if (ds.Tables[0].Rows[0]["u_email"] != null && ds.Tables[0].Rows[0]["u_email"].ToString() != "") { model.u_email = ds.Tables[0].Rows[0]["u_email"].ToString(); } if (ds.Tables[0].Rows[0]["u_type"] != null && ds.Tables[0].Rows[0]["u_type"].ToString() != "") { model.u_type = int.Parse(ds.Tables[0].Rows[0]["u_type"].ToString()); } if (ds.Tables[0].Rows[0]["u_sex"] != null && ds.Tables[0].Rows[0]["u_sex"].ToString() != "") { model.u_sex = ds.Tables[0].Rows[0]["u_sex"].ToString(); } if (ds.Tables[0].Rows[0]["u_address"] != null && ds.Tables[0].Rows[0]["u_address"].ToString() != "") { model.u_address = ds.Tables[0].Rows[0]["u_address"].ToString(); } if (ds.Tables[0].Rows[0]["u_adddate"] != null && ds.Tables[0].Rows[0]["u_adddate"].ToString() != "") { model.u_adddate = ds.Tables[0].Rows[0]["u_adddate"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.tb_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_user set "); if (model.u_log != null) { strSql.Append("u_log='" + model.u_log + "',"); } else { strSql.Append("u_log= null ,"); } if (model.u_pwd != null) { strSql.Append("u_pwd='" + model.u_pwd + "',"); } else { strSql.Append("u_pwd= null ,"); } if (model.u_no != null) { strSql.Append("u_no='" + model.u_no + "',"); } else { strSql.Append("u_no= null ,"); } if (model.u_name != null) { strSql.Append("u_name='" + model.u_name + "',"); } else { strSql.Append("u_name= null ,"); } if (model.u_tel != null) { strSql.Append("u_tel='" + model.u_tel + "',"); } else { strSql.Append("u_tel= null ,"); } if (model.u_email != null) { strSql.Append("u_email='" + model.u_email + "',"); } else { strSql.Append("u_email= null ,"); } if (model.u_type != null) { strSql.Append("u_type=" + model.u_type + ","); } else { strSql.Append("u_type= null ,"); } if (model.u_sex != null) { strSql.Append("u_sex='" + model.u_sex + "',"); } else { strSql.Append("u_sex= null ,"); } if (model.u_address != null) { strSql.Append("u_address='" + model.u_address + "',"); } else { strSql.Append("u_address= null ,"); } if (model.u_adddate != null) { strSql.Append("u_adddate='" + model.u_adddate + "',"); } else { strSql.Append("u_adddate= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where u_id=" + model.u_id + ""); int rowsAffected = DbSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }