package com.northglass.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.northglass.entity.MachineDispose;
import com.northglass.entity.MachineFont;

public interface MachineFontDao extends JpaRepository<MachineFont, Long>{
	/*//查询对应机器的   对应字
    @Query("select t from MachineFont t where t.machine.id = ?1 and t.message = ?2")
    public MachineFont findMachineFont(Long Machineid,String message);
    
  //查询对应机器的   对应字
    @Query("select t from MachineFont t where t.machine.id = ?1")
    public List<MachineFont> findMachineFontid(Long Machineid );*/
	
	//查询对应机器的   对应字
    @Query("select t from MachineFont t where t.machineType.id = 3 and t.flag = '0' and t.fontName = '请求字' ")
    public List<MachineFont> findMachineDispose();
}