public async Task <ApiResult <string> > Post(EditSysUserDto Params)
{
ApiResult <string> res = new ApiResult <string>();
TokenModelBeta token = JwtToken.ParsingJwtToken(HttpContext);
//开启事务
try {
SysUser userInfo = _mapper.Map <SysUser>(Params);
userInfo.Id = Guid.NewGuid().ToString();
userInfo.CreatorTime = DateTime.Now;
userInfo.CreatorId = token.Id;
await _userService.AddAsync(userInfo);
SysUserLogon userLogonInfo = _mapper.Map <SysUserLogon>(Params);
userLogonInfo.Id = Guid.NewGuid().ToString();
userLogonInfo.UserId = userInfo.Id;
userLogonInfo.LogOnCount = 0;
userLogonInfo.UserSecretkey = Md5Crypt.Encrypt(Guid.NewGuid().ToString());
userLogonInfo.UserPassword = Md5Crypt.Encrypt(DES3Encrypt.EncryptString(userLogonInfo.UserPassword.ToLower(), userLogonInfo.UserSecretkey).ToLower(), false).ToLower();
userLogonInfo.PasswordSecurity = UniversalTool.PassSecurityValidation(userLogonInfo.UserPassword);
await _userLogonService.AddAsync(userLogonInfo);
}
catch (Exception ex) {
res.code = (int)ApiEnum.Error;
res.message = "异常：" + ex.Message;
}
//事务结束
return(await Task.Run(() => res));
}
public async Task <ApiResult <string> > Put(string Id, EditSysUserDto Params)
{
ApiResult <string> res = new ApiResult <string>();
//开启事务
try
{
SysUser userInfo = _mapper.Map <SysUser>(Params);
if (!UniversalTool.ModuleIsNull(userInfo))
{
userInfo.Id = Id;
await _userService.UpdateAsync(userInfo);
}
if (string.IsNullOrEmpty(Params.UserPassword) || Params.UserPassword == "********")
{
Params.UserPassword = null;
Params.PasswordSecurity = null;
}
SysUserLogon userLogonInfo = _mapper.Map <SysUserLogon>(Params);
if (!UniversalTool.ModuleIsNull(userLogonInfo))
{
SysUserLogon sysUserLogon = await _userLogonService.QueryFirstAsync(s => s.UserId == Id);
if (!string.IsNullOrEmpty(Params.UserPassword) && Params.UserPassword != "********")
{
userLogonInfo.PasswordSecurity = UniversalTool.PassSecurityValidation(userLogonInfo.UserPassword);
userLogonInfo.UserSecretkey = Md5Crypt.Encrypt(Guid.NewGuid().ToString());
userLogonInfo.UserPassword = Md5Crypt.Encrypt(DES3Encrypt.EncryptString(userLogonInfo.UserPassword.ToLower(), userLogonInfo.UserSecretkey).ToLower(), false).ToLower();
}
userLogonInfo.Id = sysUserLogon.Id;
await _userLogonService.UpdateAsync(userLogonInfo);
}
}
catch (Exception ex)
{
res.code = (int)ApiEnum.Error;
res.message = "异常：" + ex.Message;
}
//事务结束
return(await Task.Run(() => res));
}
/// <summary>
/// 异步添加种子数据
/// </summary>
/// <param name="DbContext"></param>
/// <returns></returns>
public static async Task SeedAsync(BaseDbContext DbContext)
{
try
{
// 注意！一定要先手动创建一个空的数据库
// 会覆盖，可以设置为true，来备份数据
// 如果生成过了，第二次，就不用再执行一遍了,注释掉该方法即可
DbContext.CreateTableByEntity(false, typeof(SysLog),
typeof(SysUser),
typeof(SysUserLogon),
typeof(SysOrganize),
typeof(SysRole),
typeof(SysModule),
typeof(SysModuleAction),
typeof(SysRoleAuthorize),
typeof(SysRoleAuthorizeAction),
typeof(SysMessage));
#region 追加种子数据
string UserId = Guid.NewGuid().ToString();
string RoleId = Guid.NewGuid().ToString();
string OrganizeId = Guid.NewGuid().ToString();
string ModuleId = Guid.NewGuid().ToString();
string UserSecretkey = Guid.NewGuid().ToString();
if (!await DbContext.Db.Queryable <SysUser>().AnyAsync())
{
DbContext.Db.Insertable(new SysOrganize()
{
Id = OrganizeId,
ParentId = "00000000-0000-0000-0000-000000000000",
Category = "GROUP",
FullName = "仓单系统总管理",
FullNameEn = "",
ShortName = "仓单系统总管理",
DeleteMark = false,
DeleteUserId = "",
DeleteTime = null,
Description = "",
IsExpand = true,
EnabledMark = true,
SortCode = 1,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable(new SysRole()
{
Id = RoleId,
OrganizeId = OrganizeId,
ParentId = "00000000-0000-0000-0000-000000000000",
Category = "FATHER",
FullName = "系统管理员",
FullNameEn = "",
DeleteMark = false,
DeleteUserId = "",
DeleteTime = null,
Description = "",
IsExpand = true,
EnabledMark = true,
SortCode = 1,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable(new SysUser()
{
Id = UserId,
RoleId = RoleId,
OrganizeId = OrganizeId,
Account = "admin",
HeadIcon = "https://b-ssl.duitang.com/uploads/item/201508/12/20150812204143_KHCAQ.thumb.700_0.jpeg",
WeChat = "",
Tel = "",
Birthday = null,
RealName = "管理员",
Email = "*****@*****.**",
Token = "",
IsAdministrator = true,
Description = "",
EnabledMark = true,
SortCode = 1,
CreatorTime = DateTime.Now,
CreatorId = "00000000-0000-0000-0000-000000000000"
}).ExecuteCommand();
DbContext.Db.Insertable(new SysUserLogon()
{
Id = Guid.NewGuid().ToString(),
UserId = UserId,
Theme = "",
Language = "",
MultiUserLogin = false,
LogOnCount = 0,
UserSecretkey = UserSecretkey,
PasswordSecurity = UniversalTool.PassSecurityValidation("123456"),
UserPassword = Md5Crypt.Encrypt(DES3Encrypt.EncryptString("123456".ToLower(), UserSecretkey).ToLower(), false).ToLower(),
}).ExecuteCommand();
DbContext.Db.Insertable(new SysLog()
{
Id = Guid.NewGuid().ToString(),
Account = "系统",
NickName = "DbInit",
ModuleName = "SeedInitAsync",
Result = "OK",
ResultData = "初始化数据库所有基础表 和 数据",
CreatorUserId = UserId,
CreatorTime = DateTime.Now,
}).ExecuteCommand();
//主菜单
DbContext.Db.Insertable <SysModule>(new SysModule()
{
Id = ModuleId,
ParentId = "00000000-0000-0000-0000-000000000000",
FullName = "系统",
FullNameEn = "",
Icon = "",
UrlAddress = "",
ApiUrl = "",
IsMenu = true,
IsExpand = true,
Description = "系统",
SortCode = 99,
EnabledMark = true,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
DeleteMark = false,
DeleteTime = null,
DeleteUserId = null,
}).ExecuteCommand();
//子菜单 用户
string userModuleId = Guid.NewGuid().ToString();
DbContext.Db.Insertable <SysModule>(new SysModule()
{
Id = userModuleId,
ParentId = ModuleId,
FullName = "用户管理",
FullNameEn = "SysUser",
Icon = "",
UrlAddress = "/SysAdmin/user",
ApiUrl = "/Api/SysUser",
IsMenu = false,
IsExpand = false,
Description = "用户管理",
SortCode = 4,
EnabledMark = true,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
DeleteMark = false,
DeleteTime = null,
DeleteUserId = null,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = userModuleId,
ActionName = "",
RequestMethod = "POST",
ACL = "POST",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = userModuleId,
ActionName = "",
RequestMethod = "PUT",
ACL = "PUT",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = userModuleId,
ActionName = "",
RequestMethod = "GET",
ACL = "GET",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = userModuleId,
ActionName = "",
RequestMethod = "DELETE",
ACL = "DELETE",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = userModuleId,
ActionName = "GetUserDetails",
RequestMethod = "GET",
ACL = "GetUserDetails",
EnabledMark = true,
Description = "获取用户详情 个人中心信息编辑",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = userModuleId,
ActionName = "GetTokenUserDetails",
RequestMethod = "GET",
ACL = "GetTokenUserDetails",
EnabledMark = true,
Description = "获取用户详情根据Token",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
//子菜单 角色
string roleModuleId = Guid.NewGuid().ToString();
DbContext.Db.Insertable <SysModule>(new SysModule()
{
Id = roleModuleId,
ParentId = ModuleId,
FullName = "角色管理",
FullNameEn = "SysUser",
Icon = "",
UrlAddress = "/SysAdmin/role",
ApiUrl = "/Api/SysRole",
IsMenu = false,
IsExpand = false,
Description = "角色管理",
SortCode = 3,
EnabledMark = true,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
DeleteMark = false,
DeleteTime = null,
DeleteUserId = null,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = roleModuleId,
ActionName = "",
RequestMethod = "POST",
ACL = "POST",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = roleModuleId,
ActionName = "",
RequestMethod = "PUT",
ACL = "PUT",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = roleModuleId,
ActionName = "",
RequestMethod = "GET",
ACL = "GET",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = roleModuleId,
ActionName = "",
RequestMethod = "DELETE",
ACL = "DELETE",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = roleModuleId,
ActionName = "GetRoleTreeList",
RequestMethod = "GET",
ACL = "GetRoleTreeList",
EnabledMark = true,
Description = "获取角色树",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
//子菜单 组织
string organizeModuleId = Guid.NewGuid().ToString();
DbContext.Db.Insertable <SysModule>(new SysModule()
{
Id = organizeModuleId,
ParentId = ModuleId,
FullName = "组织管理",
FullNameEn = "SysUser",
Icon = "",
UrlAddress = "/SysAdmin/organize",
ApiUrl = "/Api/SysOrganize",
IsMenu = false,
IsExpand = false,
Description = "组织管理",
SortCode = 2,
EnabledMark = true,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
DeleteMark = false,
DeleteTime = null,
DeleteUserId = null,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = organizeModuleId,
ActionName = "",
RequestMethod = "POST",
ACL = "POST",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = organizeModuleId,
ActionName = "",
RequestMethod = "PUT",
ACL = "PUT",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = organizeModuleId,
ActionName = "",
RequestMethod = "GET",
ACL = "GET",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = organizeModuleId,
ActionName = "",
RequestMethod = "DELETE",
ACL = "DELETE",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = organizeModuleId,
ActionName = "GetOrganizeTreeList",
RequestMethod = "GET",
ACL = "GetOrganizeTreeList",
EnabledMark = true,
Description = "获取组织树",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
//子菜单 模块
string moduleModuleId = Guid.NewGuid().ToString();
DbContext.Db.Insertable <SysModule>(new SysModule()
{
Id = moduleModuleId,
ParentId = ModuleId,
FullName = "模块管理",
FullNameEn = "SysUser",
Icon = "",
UrlAddress = "/SysAdmin/module",
ApiUrl = "/Api/SysModule",
IsMenu = false,
IsExpand = false,
Description = "模块管理",
SortCode = 1,
EnabledMark = true,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
DeleteMark = false,
DeleteTime = null,
DeleteUserId = null,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = moduleModuleId,
ActionName = "",
RequestMethod = "POST",
ACL = "POST",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = moduleModuleId,
ActionName = "",
RequestMethod = "PUT",
ACL = "PUT",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = moduleModuleId,
ActionName = "",
RequestMethod = "GET",
ACL = "GET",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = moduleModuleId,
ActionName = "",
RequestMethod = "DELETE",
ACL = "DELETE",
EnabledMark = true,
Description = "",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = moduleModuleId,
ActionName = "GetModuleTreeList",
RequestMethod = "GET",
ACL = "GetModuleTreeList",
EnabledMark = true,
Description = "获取模块树",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
{
Id = Guid.NewGuid().ToString(),
ModuleId = moduleModuleId,
ActionName = "GetModuleTreeAuthList",
RequestMethod = "GET",
ACL = "GetModuleTreeAuthList",
EnabledMark = true,
Description = "获取权限模块树",
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
//角色模块权限
foreach (var item in await DbContext.Db.Queryable <SysModule>().ToListAsync())
{
//角色权限
DbContext.Db.Insertable <SysRoleAuthorize>(new SysRoleAuthorize()
{
Id = Guid.NewGuid().ToString(),
RoleId = RoleId,
ModuleId = item.Id,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
}
//角色模块按钮权限
foreach (var item in await DbContext.Db.Queryable <SysRoleAuthorize, SysModule, SysModuleAction>((sr, sm, sma) => new object[] {
JoinType.Left, sr.ModuleId == sm.Id,
JoinType.Left, sm.Id == sma.ModuleId,
})
.Where((sr, sm, sma) => sma.Id != null)
.Select((sr, sm, sma) => new {
id = sr.Id,
actionid = sma.Id
}).ToListAsync())
{
//角色权限
DbContext.Db.Insertable <SysRoleAuthorizeAction>(new SysRoleAuthorizeAction()
{
Id = Guid.NewGuid().ToString(),
RoleAuthId = item.id,
ModuleActionId = item.actionid,
CreatorTime = DateTime.Now,
CreatorUserId = UserId,
}).ExecuteCommand();
}
}
#endregion
}
catch (Exception ex)
{
}
}