/// <summary>
/// 用户是否具备权限
/// </summary>
/// <param name="userWrapper"></param>
/// <param name="permissionCode"></param>
/// <returns></returns>
public static bool UserHasPermission(SystemUserWrapper userWrapper, string permissionCode)
{
if (userWrapper == null)
{
throw new ArgumentNullException("userWrapper");
}
if (string.IsNullOrEmpty(permissionCode))
{
throw new ArgumentNullException("permissionCode");
}
if (businessProxy.CheckUserIfDeveloperAdminOrSystemAdmin(userWrapper))
{
return(true);
}
SystemPrivilegeEntity permission = systemPrivilegeParameterServiceProxy.FindByPermissionCode(permissionCode);
if (permission == null)
{
throw new ArgumentNullException(string.Format("Permission '{0}' not existed!", permissionCode), "permissionCode");
}
return(businessProxy.UserHasPermission(userWrapper.entity, permission));
}
/// <summary>
/// 全构造函数
/// </summary>
public SystemPrivilegeParameterEntity( int privilegeParameterID, SystemRoleEntity roleID, SystemPrivilegeEntity privilegeID, string bizParameter)
{
_privilegeParameterID = privilegeParameterID;
_roleID = roleID;
_privilegeID = privilegeID;
_bizParameter = bizParameter;
}
/// <summary>
/// 根据objectId和objectType获取SystemPrivilege
/// </summary>
/// <param name="objectId"></param>
/// <param name="objectType"></param>
/// <returns></returns>
public static IList <SystemPrivilegeEntity> GetByObjectId(string objectId, int objectType = -1)
{
var sql = string.Format(@"SELECT {0} FROM system_privilege WHERE object_id = @p_object_id", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
if (objectType != -1)
{
sql += " AND ObjectType=@ObjectType ";
}
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_object_id", DbType.String, objectId);
if (objectType != -1)
{
db.AddInParameter(dc, "ObjectType", DbType.Int32, objectType);
}
var list = new List <SystemPrivilegeEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new SystemPrivilegeEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
/// <summary>
/// 默认构造函数
/// </summary>
public SystemPrivilegeParameterEntity()
{
_privilegeParameterID = 0;
_roleID = null;
_privilegeID = null;
_bizParameter = String.Empty;
}
public bool UserHasPermission(SystemUserEntity userWrapper, SystemPrivilegeEntity permission)
{
//获取用户分配的所有的角色
List <SystemRoleEntity> assignedroles =
this.DataObjectsContainerIocID.SystemUserRoleRelationDataObjectInstance.GetUserAssignedRoles(userWrapper);
return
(this.DataObjectsContainerIocID.SystemPrivilegeInRolesDataObjectInstance.RolesHasPermission(
assignedroles, permission));
}
public bool RolesHasPermission(List <SystemRoleEntity> roleEntities, SystemPrivilegeEntity permission)
{
NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_ROLEID.In(roleEntities));
dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEID.Eq(permission));
List <SystemPrivilegeInRolesEntity> list = FindListByQueryBuilder(dynamicQueryGenerator);
return(list != null && list.Count > 0);
}
internal static SystemPrivilegeWrapper ConvertEntityToWrapper(SystemPrivilegeEntity entity)
{
if (entity == null)
{
return(null);
}
if (entity.PrivilegeID == 0)
{
return(null);
}
return(new SystemPrivilegeWrapper(entity));
}
private static void Add(SystemPrivilegeEntity entity, Database db, DbTransaction trans)
{
var sql = string.Format(@"INSERT INTO system_privilege({0})
VALUES(@p_id, @p_object_id, @p_object_type, @p_fun_key, @p_query, @p_operate,
@p_created_id, @p_created_time, @p_updated_id, @p_updated_time)", COLUMN_SQL);
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, entity.Id);
db.AddInParameter(dc, "p_object_id", DbType.String, entity.ObjectId);
db.AddInParameter(dc, "p_object_type", DbType.Int32, entity.ObjectType);
db.AddInParameter(dc, "p_fun_key", DbType.String, entity.FunKey);
db.AddInParameter(dc, "p_query", DbType.Boolean, entity.Query);
db.AddInParameter(dc, "p_operate", DbType.Boolean, entity.Operate);
db.AddInParameter(dc, "p_created_id", DbType.String, entity.CreatedId);
db.AddInParameter(dc, "p_created_time", DbType.DateTime, entity.CreatedTime);
db.AddInParameter(dc, "p_updated_id", DbType.String, entity.UpdatedId);
db.AddInParameter(dc, "p_updated_time", DbType.DateTime, entity.UpdatedTime);
db.ExecuteNonQuery(dc, trans);
}
public List <SystemPrivilegeParameterEntity> GetPageList_By_PrivilegeID_SystemPrivilegeEntity(string orderByColumnName, bool isDesc, SystemPrivilegeEntity fkentity, PageQueryParams pageQueryParams)
{
NHibernateDynamicQueryGenerator <SystemPrivilegeParameterEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEID.Eq(fkentity));
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, dynamicQueryGenerator);
return(FindListByPageByQueryBuilder(dynamicQueryGenerator, pageQueryParams));
}
public List <SystemPrivilegeParameterEntity> GetList_By_PrivilegeID_SystemPrivilegeEntity(SystemPrivilegeEntity fkentity)
{
NHibernateDynamicQueryGenerator <SystemPrivilegeParameterEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEID.Eq(fkentity));
return(this.FindListByQueryBuilder(dynamicQueryGenerator));
}
internal SystemPrivilegeWrapper(SystemPrivilegeEntity entityObj)
{
entity = entityObj;
}
internal static SystemPrivilegeWrapper ConvertEntityToWrapper(SystemPrivilegeEntity entity)
{
if (entity == null)
return null;
if (entity.PrivilegeID == 0)
return null;
return new SystemPrivilegeWrapper(entity);
}
internal SystemPrivilegeWrapper(SystemPrivilegeEntity entityObj)
: base(entityObj)
{
}
public SystemPrivilegeInRolesEntity GetRelationByRoleAndPrivilege(SystemRoleEntity roleEntity, SystemPrivilegeEntity privilegeEntity)
{
return this.SelfDataObj.GetRelationByRoleAndPrivilege(roleEntity, privilegeEntity);
}
/// <summary>
/// 获取角色权限对应关系
/// </summary>
/// <param name="roleEntity"></param>
/// <param name="privilegEntity"></param>
/// <returns></returns>
public SystemPrivilegeInRolesEntity GetRelationByRoleAndPrivilege(SystemRoleEntity roleEntity, SystemPrivilegeEntity privilegEntity)
{
NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_ROLEID.Eq(roleEntity));
dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEID.Eq(privilegEntity));
return(FindSingleEntityByQueryBuilder(dynamicQueryGenerator));
}
public List <SystemPrivilegeInRolesEntity> FindAllByOrderByAndFilterAndPrivilegeID(string orderByColumnName, bool isDesc, SystemPrivilegeEntity _privilegeID, PageQueryParams pageQueryParams)
{
return(this.SelfDataObj.GetPageList_By_PrivilegeID_SystemPrivilegeEntity(orderByColumnName, isDesc, _privilegeID, pageQueryParams));
}
public List <SystemPrivilegeInRolesEntity> FindAllByPrivilegeID(SystemPrivilegeEntity _privilegeID)
{
return(this.SelfDataObj.GetList_By_PrivilegeID_SystemPrivilegeEntity(_privilegeID));
}
internal SystemPrivilegeWrapper(SystemPrivilegeEntity entityObj)
{
entity = entityObj;
}
