public IList <RoleSpecialPermissionsInfo> GetSpecialPermissionsBySpecialId(int specialId) { IList <RoleSpecialPermissionsInfo> list = new List <RoleSpecialPermissionsInfo>(); Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("@SpecialID", DbType.Int32, specialId); string strCommand = "SELECT * FROM PE_Role_Special_Permissions WHERE SpecialID = @SpecialID"; using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams)) { while (reader.Read()) { RoleSpecialPermissionsInfo item = new RoleSpecialPermissionsInfo(); item.GroupId = reader.GetInt32("RoleID"); item.OperateCode = (OperateCode)reader.GetInt32("OperateCode"); item.SpecialId = reader.GetInt32("SpecialID"); list.Add(item); } } return(list); }
public IList <RoleSpecialPermissionsInfo> GetSpecialPermissionsList(int id, int specialId, OperateCode operateCode, int idType) { IList <RoleSpecialPermissionsInfo> list = new List <RoleSpecialPermissionsInfo>(); Parameters cmdParams = new Parameters(); string strCommand = "SELECT * FROM PE_GroupSpecialPermissions WHERE 1 = 1"; if ((id > 0) || (id == -2)) { strCommand = strCommand + " AND GroupID = @GroupID "; cmdParams.AddInParameter("@GroupID", DbType.Int32, id); } if ((specialId > 0) || (specialId == -1)) { strCommand = strCommand + " AND SpecialID = @SpecialID "; cmdParams.AddInParameter("@SpecialID", DbType.Int32, specialId); } if (operateCode != OperateCode.None) { strCommand = strCommand + " AND OperateCode = @OperateCode "; cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode); } if (idType >= 0) { strCommand = strCommand + " AND IdType = @IdType "; cmdParams.AddInParameter("@IdType", DbType.Int32, idType); } using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams)) { while (reader.Read()) { RoleSpecialPermissionsInfo item = new RoleSpecialPermissionsInfo(); item.GroupId = reader.GetInt32("GroupID"); item.OperateCode = (OperateCode)reader.GetInt32("OperateCode"); item.SpecialId = reader.GetInt32("SpecialID"); list.Add(item); } } return(list); }