//用户注册 public int AddUser(UserInfo user) { try { if (connection.State == ConnectionState.Closed) { connection.Open(); } var bus = UserInfoLogin.GenerateSalt(); string sql = $@"insert into UserInfo(NickName,Img,PhoneNumber,Password,Salt,Email,RealName,CreateTime,UpdateTime,CreaterId,UpdaterId) values('{user.NickName}','','{user.PhoneNumber}','{MD5Encrypt32(user.PassWord + bus)}','{bus}','{user.Email}','{user.RealName}','{DateTime.Now}','{DateTime.Now}','{user.CreaterId}','{user.UpdaterId}')"; SqlCommand command = new SqlCommand(sql, connection); var res = command.ExecuteNonQuery(); if (connection.State == ConnectionState.Open) { connection.Close(); } return(res); } catch (Exception) { throw; } }
//用户注册 public int AddUser(UserInfo user) { connection.Open(); var bus = UserInfoLogin.GenerateSalt(); string sql = $@"insert into UserInfo(NickName,Img,PhoneNumber,Password,Salt,Email,RealName,CreateTime,UpdateTime,CreaterId,UpdaterId) values('{user.NickName}','{user.PhoneNumber}','{MD5Encrypt32(user.PassWord + "{"+bus+"}")}','{bus}','{user.Email}','{user.RealName},'{user.CreateTime}','{user.UpdateTime}','{user.CreaterId}','{user.UpdaterId}'')"; SqlCommand command = new SqlCommand(sql, connection); var res = command.ExecuteNonQuery(); return(res); }
///修改密码 public int EditUserPwd(string pwd, string PhoneNumber) { try { var bus = UserInfoLogin.GenerateSalt(); int res = 0; string sql = "update UserInfo set Password='******' , Salt='" + bus + "' where PhoneNumber='" + PhoneNumber + "'"; res = OrmDBHelper.ExecuteNonQuery(sql); return(res); } catch (Exception ex) { string res = ex.Message; throw; } }