/// <summary>
/// 编辑信息
/// </summary>
public async Task EditModel(ClientsDto input)
{
try
{
_dbContext.Ado.BeginTran();
var model = _mapper.Map <ClientsDto, Clients>(input);
if (model.Id > 0)
{
await _dbContext.Updateable(model).ExecuteCommandAsync();
await SaveClientGrantTypes(input.AllowedGrantTypes, model.Id, true);
await SaveClientScope(input.AllowedScopes, model.Id, true);
await SaveClientSecret(input.ClientSecrets, model.Id, true);
_dbContext.Ado.CommitTran();
return;
}
var mid = await _dbContext.Insertable(model).ExecuteReturnIdentityAsync();
await SaveClientGrantTypes(input.AllowedGrantTypes, mid);
await SaveClientScope(input.AllowedScopes, mid);
await SaveClientSecret(input.ClientSecrets, mid);
_dbContext.Ado.CommitTran();
}
catch (Exception ex)
{
_dbContext.Ado.RollbackTran();
throw ex;
}
}
/// <summary>
/// 用户授权角色
/// </summary>
public async Task <bool> ToRole(ToRoleInput input)
{
if (input.Status)
{
await _dbContext.Insertable(new Permissions
{
RoleId = input.RoleId,
UserId = input.UserId,
MenuId = input.MenuId,
BtnFunId = input.BtnFunId,
Types = input.Types,
CreateTime = DateTime.Now
}).ExecuteCommandAsync();
}
else
{
switch (input.Types)
{
case 2:
await _dbContext.Deleteable <Permissions>()
.Where(m => m.UserId == input.UserId && m.RoleId == input.RoleId && m.Types == 2)
.ExecuteCommandAsync();
break;
case 3:
await _dbContext.Deleteable <Permissions>()
.Where(m => m.BtnFunId == input.BtnFunId && m.RoleId == input.RoleId && m.MenuId == input.MenuId && m.Types == 3)
.ExecuteCommandAsync();
break;
}
}
return(true);
}
/// <summary>
/// 分配路由
/// </summary>
public async Task <bool> ToAccReRouteAsync(ToAccReRouteInput input)
{
if (input.Type == 0)
{
await _dbContext.Deleteable <ConfigReRoutes>()
.Where(f => f.KeyId == input.KeyId && f.ReRouteId == input.ReRouteId)
.ExecuteCommandAsync();
}
else
{
await _dbContext.Insertable(new ConfigReRoutes { KeyId = input.KeyId, ReRouteId = input.ReRouteId })
.ExecuteCommandAsync();
}
return(true);
}
/// <summary>
/// 分配客户端
/// </summary>
public async Task <bool> ToAccReRouteAsync(ToAccGroupInput input)
{
if (input.Type == 0)
{
await _dbContext.Deleteable <ClientGroup>()
.Where(f => f.GroupId == input.GroupId && f.Id == input.KeyId)
.ExecuteCommandAsync();
}
else
{
await _dbContext.Insertable(new ClientGroup { GroupId = input.GroupId, Id = input.KeyId })
.ExecuteCommandAsync();
}
return(true);
}
/// <summary>
/// 编辑信息
/// </summary>
public async Task EditModel(UserDto input)
{
input.KeyId = input.KeyId ?? Guid.Empty;
var model = _mapper.Map <UserDto, User>(input);
if (model.KeyId != Guid.Empty)
{
model.UpdateTime = DateTime.Now;
if (model.Password.IsNotNullAndWhiteSpace())
{
model.Salt = Randoms.CreateRandomValue(8, false);
model.Password = $"{model.Password}+_(QVQ)_+{model.Salt}".ToMd5();
await _dbContext.Updateable(model)
.IgnoreColumns(it => new { it.Account, it.CreateTime })
.ExecuteCommandAsync();
}
else
{
await _dbContext.Updateable(model)
.IgnoreColumns(it => new { it.Account, it.Password, it.Salt, it.CreateTime })
.ExecuteCommandAsync();
}
}
else
{
model.CreateTime = DateTime.Now;
model.UpdateTime = DateTime.Now;
model.Salt = Randoms.CreateRandomValue(8, false);
model.Password = $"{model.Password}+_(QVQ)_+{model.Salt}".ToMd5();
await _dbContext.Insertable(model).ExecuteCommandAsync();
}
}
/// <summary>
/// 编辑信息
/// </summary>
public async Task EditModel(ApiResource input)
{
try
{
_dbContext.Ado.BeginTran();
if (input.Id > 0)
{
var scope = await _dbContext.Queryable <ApiScope>().FirstAsync(o => o.ApiResourceId == input.Id);
input.Updated = DateTime.Now;
await _dbContext.Updateable(input).IgnoreColumns(it => new { it.Created })
.ExecuteCommandAsync();
if (scope != null)
{
scope.Name = input.Name;
scope.DisplayName = input.DisplayName;
scope.Description = input.Description;
await _dbContext.Updateable(scope).IgnoreColumns(it => new { it.ApiResourceId })
.ExecuteCommandAsync();
}
_dbContext.Ado.CommitTran();
return;
}
input.Created = DateTime.Now;
input.NonEditable = 0;
var rid = await _dbContext.Insertable(input).ExecuteReturnIdentityAsync();
await _dbContext.Insertable(new ApiScope
{
ApiResourceId = rid,
Description = input.Description,
DisplayName = input.DisplayName,
Emphasize = false,
Name = input.Name,
Required = false,
ShowInDiscoveryDocument = true
}).ExecuteCommandAsync();
_dbContext.Ado.CommitTran();
}
catch (Exception ex)
{
_dbContext.Ado.RollbackTran();
throw ex;
}
}
/// <summary>
/// 编辑信息
/// </summary>
public async Task EditModel(ReRoute input)
{
if (input.ReRouteId > 0)
{
await _dbContext.Updateable(input).ExecuteCommandAsync();
return;
}
await _dbContext.Insertable(input).ExecuteCommandAsync();
}
/// <summary>
/// 编辑信息
/// </summary>
public async Task EditModel(AuthGroup input)
{
if (input.GroupId > 0)
{
await _dbContext.Updateable(input).ExecuteCommandAsync();
return;
}
await _dbContext.Insertable(input).ExecuteCommandAsync();
}
/// <summary>
/// 编辑信息
/// </summary>
public async Task EditModel(GlobalConfiguration input)
{
if (input.KeyId > 0)
{
await _dbContext.Updateable(input).ExecuteCommandAsync();
return;
}
await _dbContext.Insertable(input).ExecuteCommandAsync();
}
/// <summary>
/// 编辑信息
/// </summary>
public async Task EditModel(RoleDto input)
{
input.KeyId = input.KeyId ?? Guid.Empty;
var model = _mapper.Map <RoleDto, Role>(input);
if (model.KeyId != Guid.Empty)
{
await _dbContext.Updateable(model)
.IgnoreColumns(it => new { it.CreateTime })
.ExecuteCommandAsync();
}
else
{
model.CreateTime = DateTime.Now;
await _dbContext.Insertable(model).ExecuteCommandAsync();
}
}
