/// <summary> /// 批量保存角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="roleEntites">角色列表</param> /// <returns>影响行数</returns> public int BatchSave(BaseUserInfo userInfo, List <BaseRoleEntity> roleEntites) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { string tableName = userInfo.SystemCode + "Role"; var manager = new BaseRoleManager(dbHelper, userInfo, tableName); result = manager.BatchSave(roleEntites); // clude:380405622 如果Enable=0,则BaseRoleUser中的用户角色对应关系 enable=0;如果Enable=1,则BaseRoleUser中的用户角色对应关系 enable=1 tableName = BaseSystemInfo.SystemCode + "UserRole"; List <KeyValuePair <string, object> > keyValuePairs = new List <KeyValuePair <string, object> >(); foreach (BaseRoleEntity roleEntity in roleEntites) { keyValuePairs.Clear(); keyValuePairs.Add(new KeyValuePair <string, object>(BaseUserRoleEntity.FieldRoleId, roleEntity.Id)); if (roleEntity.Enabled == 0) { new BaseUserRoleManager(dbHelper, userInfo, tableName).SetProperty(keyValuePairs, new KeyValuePair <string, object>(BaseUserRoleEntity.FieldEnabled, "0")); } else { new BaseUserRoleManager(dbHelper, userInfo, tableName).SetProperty(keyValuePairs, new KeyValuePair <string, object>(BaseUserRoleEntity.FieldEnabled, "1")); } } }); return(result); }
/// <summary> /// 添加角色(同时添加用户,一个数据库事务里进行处理) /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="userIds">用户主键数组</param> /// <param name="status">状态</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>主键</returns> public string AddWithUser(BaseUserInfo userInfo, BaseRoleEntity entity, string[] userIds, out Status status, out string statusMessage) { var result = string.Empty; var returnCode = Status.Ok; var returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { // 这里是判断已经登录的用户是否有调用当前函数的权限,加强服务层被远程调用的安全性的 var tableName = userInfo.SystemCode + "Role"; var manager = new BaseRoleManager(dbHelper, userInfo, tableName); result = manager.Add(entity, out returnCode); if (!string.IsNullOrEmpty(result) && userIds != null && userIds.Length > 0) { tableName = userInfo.SystemCode + "UserRole"; var userManager = new BaseUserManager(dbHelper, userInfo, tableName); // 小心异常,检查一下参数的有效性 if (userIds != null) { userManager.AddToRole(userInfo.SystemCode, userIds, new string[] { result }); } } returnMessage = manager.GetStateMessage(returnCode); }); status = returnCode; statusMessage = returnMessage; return(result); }
/// <summary> /// 批量删除角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int BatchDelete(BaseUserInfo userInfo, string[] ids) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { string tableName = userInfo.SystemCode + "Role"; var manager = new BaseRoleManager(dbHelper, userInfo, tableName); // 这里是直接删除功能的实现 // result = roleManager.BatchDelete(ids); BaseRoleEntity roleEntity = null; // 把删除的记录放到被删除的表里(表名后面加了后缀Deleted,也可以放在另外一个数据库里也可以的) var roleDeletedManager = new BaseRoleManager(dbHelper, userInfo, tableName + "Deleted"); foreach (var id in ids) { // 逐个删除,逐个备份 roleEntity = manager.GetObject(id); // 先添加到被删除的表里,这时候原先数据的主键需要保留的,否则恢复数据时可能会乱套 roleDeletedManager.Add(roleEntity); // 数据备份好后再进行删除处理 result += manager.Delete(id); } }); return(result); }
/// <summary> /// 添加角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>主键</returns> public string Add(BaseUserInfo userInfo, BaseRoleEntity entity, out string statusCode, out string statusMessage) { string result = string.Empty; string returnCode = string.Empty; string returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { // 这里是判断已经登录的用户是否有调用当前函数的权限,加强服务层被远程调用的安全性的,会损失服务器的性能 // var permissionManager = new BasePermissionManager(result); // if (permissionManager.CheckPermissionByUser(result.Id, "RoleAdmin.Add", "添加角色")) // { string tableName = userInfo.SystemCode + "Role"; var manager = new BaseRoleManager(dbHelper, userInfo, tableName); result = manager.Add(entity, out returnCode); returnMessage = manager.GetStateMessage(returnCode); // } //else //{ // StatusCode = Status.AccessDeny.ToString(); // permissionManager.GetStateMessage(StatusCode); //} }); statusCode = returnCode; statusMessage = returnMessage; return(result); }
/// <summary> /// 批量保存 /// </summary> /// <param name="userInfo">用户</param> /// <param name="roleEntites">角色列表</param> /// <returns>影响行数</returns> public int BatchSave(BaseUserInfo userInfo, List <BaseLanguageEntity> roleEntites) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { var manager = new BaseLanguageManager(dbHelper, userInfo); result = manager.BatchSave(roleEntites); }); return(result); }
/// <summary> /// 添加实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <returns>主键</returns> public string Add(BaseUserInfo userInfo, BaseServicesLicenseEntity entity) { string result = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { var manager = new BaseServicesLicenseManager(dbHelper, userInfo); result = manager.AddObject(entity); }); return(result); }
/// <summary> /// 添加实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableName">表名</param> /// <param name="entity">实体</param> /// <returns>主键</returns> public string Add(BaseUserInfo userInfo, string tableName, BaseParameterEntity entity) { var result = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { var manager = new BaseParameterManager(dbHelper, userInfo, tableName); result = manager.Add(entity); }); return(result); }
/// <summary> /// 重置用户访问情况 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">用户主键</param> /// <returns>影响行数</returns> public int ResetVisitInfo(BaseUserInfo userInfo, string[] ids) { var result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { var manager = new BaseUserLogonManager(dbHelper, userInfo); // 重置访问情况 result = manager.ResetVisitInfo(ids); }); return(result); }
/// <summary> /// 将用户从角色中移除 /// </summary> /// <param name="userInfo">用户</param> /// <param name="roleId">角色主键</param> /// <param name="userIds">用户主键</param> /// <returns>影响行数</returns> public int RemoveUserFromRole(BaseUserInfo userInfo, string roleId, string[] userIds) { var result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { var manager = new BaseUserManager(dbHelper, userInfo); if (userIds != null) { result += manager.RemoveFromRole(userInfo.SystemCode, userIds, new string[] { roleId }); } }); return(result); }
/// <summary> /// 更新实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>影响行数</returns> public int Update(BaseUserInfo userInfo, BaseLanguageEntity entity, out string statusCode, out string statusMessage) { int result = 0; string returnCode = string.Empty; string returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { var manager = new BaseLanguageManager(dbHelper, userInfo); result = manager.Update(entity, out returnCode); returnMessage = manager.GetStateMessage(returnCode); }); statusCode = returnCode; statusMessage = returnMessage; return(result); }
/// <summary> /// 更新实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="status">状态</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>影响行数</returns> public int Update(BaseUserInfo userInfo, BaseRoleEntity entity, out Status status, out string statusMessage) { var result = 0; var returnCode = Status.Ok; var returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { var tableName = userInfo.SystemCode + "Role"; var manager = new BaseRoleManager(dbHelper, userInfo, tableName); result = manager.UniqueUpdate(entity, out returnCode); returnMessage = manager.GetStateMessage(returnCode); }); status = returnCode; statusMessage = returnMessage; return(result); }