package com.sincere.haikang.dao;

import com.sincere.haikang.bean.AttendanceBean;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;


@Repository
@Mapper
public interface DeviceDao {

    @Insert("INSERT INTO SZ_Attendance(clint_id, clint_type, intime, school_id, state,isConnection) values (#{clint_id},#{clint_type}" +
            ",#{intime},#{school_id},#{state},#{isConnection})")
    int addDevide(AttendanceBean attendanceBean);

    @Select("select * from SZ_Attendance where clint_id = #{clint_id}")
    AttendanceBean selectDevice(@Param("clint_id")String clint_id);

    @Update("update SZ_Attendance set isConnection = #{isConnection} where ip = #{ip} and port = #{port} and clint_id = #{clint_id}")
    int updateDeviceStatu(@Param("isConnection")int isConnection,@Param("ip")String ip,@Param("port")int port,@Param("clint_id")String clint_id);


}