public bool AddAchievement(AchievementDto dto)
{
SQLExecuteParam param = new SQLExecuteParam();
param.obj = dto;
param.sql = @"
INSERT INTO tb_achievement (
title,
content,
`status`,
is_deleted,
creator,
create_time
)
VALUES
(
@title,
@content,
1,
0,
@creator,
now()
)
";
if (DBAgent.SQLExecuteReturnRows(param) == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改用户昵称
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool ModifyUserInfo(UserDto user)
{
SQLExecuteParam param = new SQLExecuteParam();
param.obj = user;
param.sql = "update tb_user set nick_name = @nick_name where id = @id ";
if (DBAgent.SQLExecuteReturnRows(param) == 1)
{
return(true);
}
return(false);
}
/// <summary>
/// 注册
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public bool Register(string username, string password)
{
SQLExecuteParam param = new SQLExecuteParam();
param.obj = new
{
username = username,
password = password
};
param.sql = @"INSERT INTO tb_user (user_name, `password`)
VALUES
(@username, MD5(@PASSWORD))" ;
if (DBAgent.SQLExecuteReturnRows(param) == 1)
{
return(true);
}
return(false);
}
public int SaveRole(RoleDto role)
{
SQLExecuteParam param = new SQLExecuteParam();
param.obj = role;
if (role.id == 0)
{
//新增
param.sql = "INSERT INTO tbRole (roleName, remarks) VALUES (@roleName, @remarks)";
}
else
{
//更新
param.sql = "update tbRole set roleName=@roleName, remarks=@remarks where id=@id";
}
return(DBAgent.SQLExecuteReturnRows(param));
}
public int SaveUser(UserDto user)
{
SQLExecuteParam param = new SQLExecuteParam();
user.password = MD5Helper.MD5Encrypt(user.password);
param.obj = user;
if (user.id == 0)
{
//新增
param.sql = "insert into tbUser (name,nickName,password,roleId) values (@name,@nickName,@password,@roleId)";
}
else
{
//更新
param.sql = "update tbUser set name=@name,nickName=@nickName,password=@password,roleId=@roleId where id=@id";
}
return(DBAgent.SQLExecuteReturnRows(param));
}
