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