package com.web.generalKanBanPage.dao;

import com.web.generalKanBanPage.entity.GeneralKanBanPage;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import javax.transaction.Transactional;


public interface GeneralKanBanPageDao extends CrudRepository<GeneralKanBanPage, Long>, JpaSpecificationExecutor<GeneralKanBanPage> {

    	int countByBsMac(String bsMac);

		GeneralKanBanPage findByBsMac(String bsMac);

		@Modifying//增删改操作必须要有这个注解
		@Transactional // 事务的注解
		@Query(value = "update MES_CONFIG set BS_IP=?1,BS_PORT=?2,BS_PATH_1=?3,BS_NICK=?4 where BS_MAC=?5", nativeQuery = true)
		int update(String bsIp,String bsPort,String bsPath,String bsNick,String bsMac);

		@Modifying//增删改操作必须要有这个注解
		@Transactional // 事务的注解
		@Query(value = "update MES_CONFIG set BS_IP=?1,BS_PORT=?2 where BS_MAC=?3", nativeQuery = true)
		int autoUpdate(String bsIp,String bsPort,String bsMac);

		@Transactional
		@Modifying//增删改操作必须要有这个注解
		@Query(value = "update MES_CONFIG set BS_MSG=?1 where BS_MAC=?2",nativeQuery = true)
		int updataByBsMsg(String bsMsg,String bsMac);


}