public IActionResult Add(AddUserRequest model)
{
if (model == null)
{
return this.BadRequest();
}
var result = this.UserService.Add(model);
return this.ApiResponse(result);
}
public OperationResult<int?> Add(AddUserRequest model)
{
using (var conn = this.OpenConnection())
{
string sql = @"
IF EXISTS(SELECT 1 FROM [User] WHERE UserName=@UserName)
BEGIN
SELECT CONVERT(BIT, 1)
END
ELSE
BEGIN
SELECT CONVERT(BIT, 0)
END
";
var b = conn.ExecuteScalar<bool>(sql, new
{
UserName = model.UserName
});
if (b)
{
return OperationResult<int?>.ErrorResult("用户名已存在");
}
string password = Utility.MD5(model.Password);
sql = @"
INSERT INTO [User] ( UserName, Password, Nickname, Email, CreateDate )
VALUES ( @UserName, @Password, @Nickname, @Email, GETDATE() );
SELECT @@IDENTITY;
";
var para = new
{
Email = model.Email,
UserName = model.UserName,
Password = password,
Nickname = model.Nickname
};
var id = conn.ExecuteScalar<int>(sql, para);
return OperationResult<int?>.SuccessResult(id);
}
}