//管理员创建用户 public int registUser(UserBean bean) { try { string selectSql = "select * from users as u where u.ACCOUNT='" + @bean.Account + "'"; reade = MySqlHelper.ExecuteReader(MySqlHelper.Conn, CommandType.Text,selectSql, new MySqlParameter("@bean.Account", bean.Account)); if (reade.Read()) return HAS; string pawMd = Session.MD5Encrypt(bean.Password); string sql = "insert into users(ACCOUNT,USER_NAME,TYPE,PASSWORD,STATUS,CREATE_ID,CREATE_TIME,PHONE) values('" + @bean.Account + "','" + @bean.UserName + "'," + @bean.Type + ",'" + @pawMd + "'," + @bean.Status + "," + @bean.CreateId + ",'" + @bean.CreateTime + "','"[email protected]+"')"; MySqlParameter[] parameter = { new MySqlParameter("@bean.Account",bean.Account), new MySqlParameter("@bean.UserName",bean.UserName), new MySqlParameter("@bean.Type",bean.Type), new MySqlParameter("@pawMd",pawMd), new MySqlParameter("@bean.Status",bean.Status), new MySqlParameter("@bean.CreateId",bean.CreateId), new MySqlParameter("@bean.CreateTime",bean.CreateTime.ToString("yyyy-MM-dd hh:mm:ss")), new MySqlParameter("@bean.Phone",bean.Phone), }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text,sql, parameter); } catch (Exception e) { e.GetBaseException(); return SYSTEM_EXCEPTION; } return SUCCESS; }
private void Save_Edit(object sender, RoutedEventArgs e) { ComboBoxItem status = (ComboBoxItem)this.status.SelectedItem; UserBean bean = new UserBean(); QueryUser query = new QueryUser(); query.Account = UserManagerBean.AddUser.queryAccount.Text; query.UserName = UserManagerBean.AddUser.queryName.Text; bean.Id = int.Parse(this.userId.Content.ToString()); bean.UserName = this.userName.Text; bean.Phone = this.userPhone.Text; bean.Status = int.Parse(status.Tag.ToString()); bean.Type = this.userType.SelectedIndex; Users user = new Users(); int state = user.saveUserEdit(bean); if (state == BaseRequest.SUCCESS) { JXMessageBox.Show(Window.GetWindow(this), "编辑用信息保存成功!", MsgImage.Success); this.Close(); UserManagerBean.AddUser.page.ShowPages(UserManagerBean.AddUser.userData, user.getUsersList(query), BaseRequest.PAGE_SIZE); } else if (state == BaseRequest.SYSTEM_EXCEPTION) { JXMessageBox.Show(Window.GetWindow(this), "系统异常,请联系管理员!", MsgImage.Error); } else { JXMessageBox.Show(Window.GetWindow(this), "未知错误", MsgImage.Error); } }
//管理员创建用户 public int registUser(UserBean bean) { try { string selectSql = "select * from users as u where u.ACCOUNT='" + @bean.Account + "'"; reade = MySqlHelper.ExecuteReader(MySqlHelper.Conn, CommandType.Text, selectSql, new MySqlParameter("@bean.Account", bean.Account)); if (reade.Read()) { return(HAS); } string pawMd = Session.MD5Encrypt(bean.Password); string sql = "insert into users(ACCOUNT,USER_NAME,TYPE,PASSWORD,STATUS,CREATE_ID,CREATE_TIME,PHONE) values('" + @bean.Account + "','" + @bean.UserName + "'," + @bean.Type + ",'" + @pawMd + "'," + @bean.Status + "," + @bean.CreateId + ",'" + @bean.CreateTime + "','" + @bean.Phone + "')"; MySqlParameter[] parameter = { new MySqlParameter("@bean.Account", bean.Account), new MySqlParameter("@bean.UserName", bean.UserName), new MySqlParameter("@bean.Type", bean.Type), new MySqlParameter("@pawMd", pawMd), new MySqlParameter("@bean.Status", bean.Status), new MySqlParameter("@bean.CreateId", bean.CreateId), new MySqlParameter("@bean.CreateTime", bean.CreateTime.ToString("yyyy-MM-dd hh:mm:ss")), new MySqlParameter("@bean.Phone", bean.Phone), }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, parameter); } catch (Exception e) { e.GetBaseException(); return(SYSTEM_EXCEPTION); } return(SUCCESS); }
public int saveUserEdit(UserBean bean) { try { string date = Convert.ToDateTime(DateTime.Now).ToString(BaseRequest.DATE_TIME_FORMAT); string sql = "UPDATE users AS u SET u.USER_NAME='" + @bean.UserName + "',u.TYPE=" + @bean.Type + ",u.PHONE='" + @bean.Phone + "', STATUS=" + @bean.Status + ",UPDATE_USER_ID=" + @Session.UserId + ",UPDATE_TIME='" + @date + "' where u.ID=" + @bean.Id; MySqlParameter[] parameters = { new MySqlParameter("@bean.UserName", bean.UserName), new MySqlParameter("@bean.Type", bean.Type), new MySqlParameter("@bean.Phone", bean.Phone), new MySqlParameter("@bean.Status", bean.Status), new MySqlParameter("@Session.UserId", Session.UserId), new MySqlParameter("@date", date), new MySqlParameter("@bean.Id", bean.Id), }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, parameters); return(SUCCESS); }catch (Exception e) { e.GetBaseException(); return(SYSTEM_EXCEPTION); } }
private void Submit_AddUser(object sender, RoutedEventArgs e) { if (ValidateUtil.CheckFolderName(this.account.Text) == false) { JXMessageBox.Show(Window.GetWindow(this), "请填写帐号!", MsgImage.Error); return; } if (ValidateUtil.CheckFolderName(this.userName.Text) == false) { JXMessageBox.Show(Window.GetWindow(this), "请填写用户姓名!", MsgImage.Error); return; } if (ValidateUtil.CheckPasswordStrength(this.password.Password) == false) { JXMessageBox.Show(Window.GetWindow(this), "请输入6位以上的密码长度!", MsgImage.Error); return; } if (!this.password.Password.Equals(this.password2.Password)) { JXMessageBox.Show(Window.GetWindow(this), "输入密码不一致,请重新输入!", MsgImage.Error); return; } Users u = new Users(); UserBean bean = new UserBean(); QueryUser query = new QueryUser(); query.Account = UserManagerBean.AddUser.queryAccount.Text; query.UserName = UserManagerBean.AddUser.queryName.Text; bean.Account = this.account.Text; bean.UserName = this.userName.Text; bean.Password = this.password.Password; bean.Status = 0; bean.CreateId = Session.UserId; bean.CreateTime = Convert.ToDateTime(DateTime.Now); bean.Phone = this.phone.Text; ComboBoxItem type = (ComboBoxItem)this.userType.SelectedItem; bean.Type = int.Parse(type.Tag.ToString()); int state = u.registUser(bean); Window targe = Window.GetWindow(this); if (state == BaseRequest.HAS) { JXMessageBox.Show(Window.GetWindow(this), "该账号已被使用!", MsgImage.Error); } else if (state==BaseRequest.SUCCESS) { JXMessageBox.Show(Window.GetWindow(this), "新增用户成功!", MsgImage.Error); UserManagerBean.AddUser.page.ShowPages(UserManagerBean.AddUser.userData, u.getUsersList(query), BaseRequest.PAGE_SIZE); this.Close(); } else { JXMessageBox.Show(Window.GetWindow(this), "系统异常,请联系管理员!", MsgImage.Error); } }
public int saveUserEdit(UserBean bean) { try { string date = Convert.ToDateTime(DateTime.Now).ToString(BaseRequest.DATE_TIME_FORMAT); string sql = "UPDATE users AS u SET u.USER_NAME='" + @bean.UserName + "',u.TYPE=" + @bean.Type + ",u.PHONE='" + @bean.Phone + "', STATUS=" + @bean.Status+ ",UPDATE_USER_ID=" + @Session.UserId + ",UPDATE_TIME='" + @date + "' where u.ID=" + @bean.Id; MySqlParameter[] parameters ={ new MySqlParameter("@bean.UserName",bean.UserName), new MySqlParameter("@bean.Type",bean.Type), new MySqlParameter("@bean.Phone",bean.Phone), new MySqlParameter("@bean.Status",bean.Status), new MySqlParameter("@Session.UserId",Session.UserId), new MySqlParameter("@date",date), new MySqlParameter("@bean.Id",bean.Id), }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, parameters); return SUCCESS; }catch(Exception e) { e.GetBaseException(); return SYSTEM_EXCEPTION; } }