public IList <RoleFieldPermissionsInfo> GetFieldPermissionsById(int roleId, int modelId, string fieldName, OperateCode operateCode) { IList <RoleFieldPermissionsInfo> list = new List <RoleFieldPermissionsInfo>(); Parameters cmdParams = new Parameters(); string strCommand = "SELECT * FROM PE_Role_Field_Permissions WHERE 1 = 1"; if (roleId >= 0) { strCommand = strCommand + " AND RoleId = @RoleId "; cmdParams.AddInParameter("@RoleId", DbType.Int32, roleId); } if (modelId > 0) { strCommand = strCommand + " AND ModelId = @ModelId "; cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId); } if (!string.IsNullOrEmpty(fieldName)) { strCommand = strCommand + " AND FieldName = @FieldName "; cmdParams.AddInParameter("@FieldName", DbType.String, fieldName); } if (operateCode != OperateCode.None) { strCommand = strCommand + " AND OperateCode = @OperateCode "; cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode); } using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams)) { while (reader.Read()) { RoleFieldPermissionsInfo item = new RoleFieldPermissionsInfo(); item.RoleId = reader.GetInt32("RoleID"); item.OperateCode = (OperateCode)reader.GetInt32("OperateCode"); item.ModelId = reader.GetInt32("ModelID"); item.FieldName = reader.GetString("FieldName"); list.Add(item); } } return(list); }
public IList <RoleFieldPermissionsInfo> GetFieldPermissionsById(int id, int modelId, string fieldName, int idType) { IList <RoleFieldPermissionsInfo> list = new List <RoleFieldPermissionsInfo>(); Parameters cmdParams = new Parameters(); string strCommand = "SELECT * FROM PE_GroupFieldPermissions WHERE 1 = 1 "; if ((id > 0) || (id == -2)) { strCommand = strCommand + " AND GroupID = @GroupID "; cmdParams.AddInParameter("@GroupID", DbType.Int32, id); } if (modelId > 0) { strCommand = strCommand + " AND ModelId = @ModelId"; cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId); } if (!string.IsNullOrEmpty(fieldName)) { strCommand = strCommand + " AND FieldName = @FieldName"; cmdParams.AddInParameter("@FieldName", DbType.String, fieldName); } 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()) { RoleFieldPermissionsInfo item = new RoleFieldPermissionsInfo(); item.RoleId = reader.GetInt32("GroupID"); item.OperateCode = (OperateCode)reader.GetInt32("OperateCode"); item.ModelId = reader.GetInt32("ModelID"); item.FieldName = reader.GetString("FieldName"); list.Add(item); } } return(list); }