public async Task <TData <User> > EditUser(User user)
{
var op = await EFDB.Create().BeginTransAsync();
TData <User> obj = new TData <User>();
try
{
await op.UpdateAsync(user);
await op.CommitTransAsync();
obj.Message = "修改成功";
obj.Status = Status.Success;
}
catch (Exception ex)
{
await op.RollbackTransAsync();
obj.Message = ex.GetBaseException().Message;
obj.Status = Status.Error;
return(obj);
}
obj.Data = await EFDB.Create().FindAsync <User>(user.UserId);
return(obj);
}
public async Task <TData <string> > SignUp(User user)
{
var op = await EFDB.Create().BeginTransAsync();
TData <string> obj = new TData <string>();
try
{
User existUser = await op.FindAsync <User>(x => x.UserName == user.UserName);
if (existUser != null)
{
obj.Message = $"注册失败,已经存在用户{user.UserName}";
return(obj);
}
user.Password = SecurityHelper.MD5Encrypt(user.Password);
await op.AddAsync(user);
await op.CommitTransAsync();
obj.Message = "注册成功";
obj.Status = Status.Success;
return(obj);
}
catch (Exception ex)
{
await op.RollbackTransAsync();
obj.Message = ex.GetBaseException().Message;
obj.Status = Status.Error;
return(obj);
}
}
public async Task <string> RefreshToken()
{
string userName = await Operator.Instance.GetCurrent();
User user = await EFDB.Create().FindAsync <User>(x => x.UserName == userName);
return(JwtHelper.GenerateToken(user, GlobalInvariant.SystemConfig.JwtConfig));
}
public async Task CreateDataBase()
{
var op = EFDB.Create("MySql", "data source=localhost;database=MyBlog; uid=root;pwd=Sa123456!;")
.GetIDataBaseOperation();
await op.EnsureDeletedAsync();
await op.EnsureCreatedAsync();
await GetInterface().EnsureDeletedAsync();
await GetInterface().EnsureCreatedAsync();
}
public async Task <string> StopJob(int id)
{
try
{
await EFDB.Create().UpdateAsync(new List <Expression <Func <AutoJobTask, bool> > >()
{
x => x.JobStatus == 0
}, x => x.AutoJobTaskId == id);
await JobCenter.StopJob(id);
return("任务停止成功");
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public static IDataBaseOperation GetInterface()
{
return(EFDB.Create("SqlServer", "Data Source=.;DataBase=MyBlog;Trusted_Connection=True;")
.GetIDataBaseOperation());
}
/// <summary>
/// 获取活动任务
/// </summary>
/// <returns><see cref="Task{IEnumerable{AutoJobTask}}"/></returns>
public static async Task <IEnumerable <AutoJobTask> > GetActiveJobListAsync()
{
return(await EFDB.Create().FindListAsync <AutoJobTask>(x => x.JobStatus == 1));
}
/// <summary>
/// 获取匹配的任务数据
/// </summary>
/// <param name="id">任务id</param>
/// <returns><see cref="Task{AutoJobTask}"/></returns>
public static async Task <AutoJobTask> GetAutoJobAsync(int id)
{
return(await EFDB.Create().FindAsync <AutoJobTask>(id));
}
