/// <summary> /// 获取数据权限目标主键 /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源类别</param> /// <param name="targetId">目标资源主键</param> /// <param name="targetResourceCategory">目标资源类别</param> /// <param name="permissionItemCode">操作权限编号</param> /// <returns>资源主键数组</returns> public string[] GetPermissionScopeResourceIds(UserInfo userInfo, string resourceCategory, string targetId, string targetResourceCategory, string permissionItemCode) { string[] returnValue = null; var parameter = ParameterUtil.CreateWithLog(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var permissionItemManager = new PiPermissionItemManager(dbProvider, userInfo); var permissionItemId = permissionItemManager.GetId(PiPermissionItemTable.FieldCode, permissionItemCode); var names = new string[6]; var values = new object[6]; names[0] = PiPermissionScopeTable.FieldResourceCategory; values[0] = resourceCategory; names[1] = PiPermissionScopeTable.FieldTargetId; values[1] = targetId; names[2] = PiPermissionScopeTable.FieldPermissionId; values[2] = permissionItemId; names[3] = PiPermissionScopeTable.FieldTargetCategory; values[3] = targetResourceCategory; names[4] = PiPermissionScopeTable.FieldDeleteMark; values[4] = 0; names[5] = PiPermissionScopeTable.FieldEnabled; values[5] = 1; returnValue = DbCommonLibary.GetIds(dbProvider, PiPermissionScopeTable.TableName, names, values, PiPermissionScopeTable.FieldResourceId); }); return(returnValue); }
/// <summary> /// 获得主键列表 /// </summary> /// <param name="topLimit">取前面多少条数据</param> /// <param name="targetField">主键名</param> /// <returns>主键列表</returns> public virtual string[] GetIds(int topLimit, string targetField) { return(DbCommonLibary.GetIds(DBProvider, this.CurrentTableName, topLimit, targetField)); }
/// <summary> /// 获得主键列表 /// </summary> /// <returns>主键列表</returns> public virtual string[] GetIds() { return(DbCommonLibary.GetIds(DBProvider, this.CurrentTableName)); }
/// <summary> /// 获得主键列表 /// </summary> /// <param name="names">字段名数组</param> /// <param name="values">字段值数组</param> /// <param name="topLimit">取前面多少条数据</param> /// <param name="targetField">主键名</param> /// <returns>主键列表</returns> public virtual string[] GetIds(string[] names, Object[] values, int topLimit, string targetField) { return(DbCommonLibary.GetIds(DBProvider, this.CurrentTableName, names, values, topLimit, targetField)); }
/// <summary> /// 获得主键列表 /// </summary> /// <param name="names">字段名数组</param> /// <param name="values">字段值数组</param> /// <returns>主键列表</returns> public virtual string[] GetIds(string[] names, Object[] values) { return(DbCommonLibary.GetIds(DBProvider, this.CurrentTableName, names, values)); }
/// <summary> /// 获得主键列表 /// </summary> /// <param name="name1">字段名1</param> /// <param name="value1">字段值1</param> /// <param name="name2">字段名2</param> /// <param name="value2">字段值2</param> /// <param name="topLimit">取前面多少条数据</param> /// <param name="targetField">主键名</param> /// <returns>主键列表</returns> public virtual string[] GetIds(string name1, object value1, string name2, object value2, int topLimit, string targetField) { return(DbCommonLibary.GetIds(DBProvider, this.CurrentTableName, name1, value1, name2, value2, topLimit, targetField)); }
/// <summary> /// 获得主键列表 /// </summary> /// <param name="name1">字段名1</param> /// <param name="value1">字段值1</param> /// <param name="name2">字段名2</param> /// <param name="value2">字段值2</param> /// <returns>主键列表</returns> public virtual string[] GetIds(string name1, object value1, string name2, object value2) { return(DbCommonLibary.GetIds(DBProvider, this.CurrentTableName, name1, value1, name2, value2)); }
/// <summary> /// 获得主键列表 /// </summary> /// <param name="name">字段名</param> /// <param name="value">字段值</param> /// <param name="targetField">主键名</param> /// <returns>主键列表</returns> public virtual string[] GetIds(string name, object value, string targetField) { return(DbCommonLibary.GetIds(DBProvider, this.CurrentTableName, name, value, targetField)); }