private void btnreg_Click(object sender, EventArgs e)
{
UserInfo userNew = new UserInfo();
userNew.UserName = txtName.Text;
userNew.UserPwd =Encryption(txtPsw.Text);
userNew.UserPhone = txtPho.Text;
userNew.Flag = 0;
userNew.UserDelFlag = 0;
//给UserAccount赋值 由于UserAccount不能设置为自动增长，随机数又的检测重复，所以我再次只获取用户的数量，根据用户数量给用户设置登录账号
UserInfoBLL userBLL = new UserInfoBLL();
int userCount = userBLL.GetUserCountByUserDelFlag(0);
userNew.UserAccount = GetUserAccountByUserCount(userCount);
int msg = userBLL.InsertUserInfo(userNew);//1成功 0失败
//查看是否注册成功 成功：给用户返回登录账号，关闭注册窗体 失败：显示直接停留在注册窗体
if (msg==1)
{
MessageBox.Show("注册成功，请牢记您的登录账号：" + userNew.UserAccount);
this.Close();
}
else
{
MessageBox.Show("注册失败，请重新注册");
txtName.Text = "";
txtPho.Text = "";
txtPsw.Text = "";
}
}
/// <summary>
/// 获取没有被删除的用户
/// </summary>
/// <param name="delFlag">删除标识</param>
/// <returns>UserInfo集合</returns>
public List<UserInfo> GetUserInfoByDelFlag(int delFlag)
{
string sql = "select UserId,UserName from UserInfo where UserDelFlag=@UserDelFlag";
OleDbDataReader odr = SqlHelper.ExecuteReader(sql, new OleDbParameter("@UserDelFlag", delFlag));
List<UserInfo> list = new List<UserInfo>();
if (odr.HasRows)
{
while (odr.Read())
{
UserInfo user = new UserInfo();
user.UserId = Convert.ToInt32(odr["UserId"]);
user.UserName = odr["UserName"].ToString();
list.Add(user);
}
}
return list;
}
//UserId,UserAccount,UserName,UserPwd,UserFlag,UserDelFlag,UserPhone
/// <summary>
/// 根据用户名跟用户标识从数据库中查询密码
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="flag">用户标识 0为普通用户 1管理员</param>
/// <returns>UserInfo对象</returns>
public UserInfo GetUserInfoByUserAccount(string UserAccount, int flag)
{
string sql = "select UserPwd,UserId,UserName from UserInfo where UserAccount=@UserAccount and UserFlag=@UserFlag and UserDelFlag=0";
OleDbParameter[] param = {
new OleDbParameter("@UserAccount",UserAccount),
new OleDbParameter ("@UserFlag",flag)
};
OleDbDataReader odr= SqlHelper.ExecuteReader(sql, param);
UserInfo user = new UserInfo();
if (odr.HasRows)
{
while (odr.Read())
{
user.UserId = Convert.ToInt32(odr["UserId"]);
user.UserPwd = odr["UserPwd"].ToString();
user.UserName = odr["UserName"].ToString();
}
}
return user;
}
/// <summary>
/// 注册用户事件
/// </summary>
/// <param name="user">要注册用户的信息</param>
/// <returns>注册结果 1成功 0失败</returns>
public int InsertUserInfo(UserInfo user)
{
return userDAL.InsertUserInfo(user);
}
/// <summary>
/// 注册用户事件
/// </summary>
/// <param name="user">要注册用户的信息</param>
/// <returns>受影响的行数</returns>
public int InsertUserInfo(UserInfo user)
{
string sql = "insert into userinfo (UserAccount,UserName,UserPwd,UserFlag,UserDelFlag,UserPhone) values (@UserAccount,@UserName,@UserPwd,@UserFlag,@UserDelFlag,@UserPhone)";
OleDbParameter[] param = {
new OleDbParameter("@UserAccount",user.UserAccount),
new OleDbParameter("@UserName",user.UserName),
new OleDbParameter("@UserPwd",user.UserPwd),
new OleDbParameter("@UserFlag",user.Flag),
new OleDbParameter("@UserDelFlag",user.UserDelFlag),
new OleDbParameter("@UserPhone",user.UserPhone)
};
return SqlHelper.ExecuteNonQuery(sql, param);
}