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)); }