package com.slcf.dao;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import com.slcf.pojo.MeetingRoomBean;
import com.slcf.pojo.ReaderBean;

/**
 * 会议室Dao映射层
 * @author Administrator
 * @date 2018年8月10日
 */
@Repository
public interface MeetingRoomDao {
    /**
	 * 根据会议室名称验证是否唯一
	 * @param roomName
	 * @return
	 */
	@Select("select * from tb_meeting_room where f_RoomName=#{roomName}")
	public MeetingRoomBean getMeetingRoomByName(String roomName);
	
	/**
	 * 分页查询所有会议室
	 * @param spage
	 * @param epage
	 * @return
	 */
	@Select("select top (#{epage}) * from tb_meeting_room where f_RoomId not in "
			+ "(select top (#{spage}) f_RoomId from tb_meeting_room order by f_RoomId desc) order by f_RoomId desc")	
	public List<MeetingRoomBean> getMeetingRoomList(@Param("spage")int spage,@Param("epage")int epage);
	
	/**
	 * 统计会议室数量
	 * @return
	 */
	@Select("select count(*) from tb_meeting_room")
	public int getCount();
	
	/**
	 * 添加会议室
	 * @param meetingRoomBean
	 * @return
	 */
	@Insert("insert into tb_meeting_room(f_RoomNo,f_RoomName,f_ReaderID,f_Notes) "
			+ " values(#{f_RoomNo},#{f_RoomName},#{f_ReaderID},#{f_Notes})")
	public int saveMeetingRoom(MeetingRoomBean meetingRoomBean);
	
	/**
	 * 根据ID删除
	 * @param roomId
	 * @return
	 */
	@Delete("delete from tb_meeting_room where f_RoomId=#{roomId}")
	public int delMeetingRoomById(int roomId);
	
	/**
	 * 根据名称查找
	 * @param roomName
	 * @return
	 */
	@Select("select * from tb_meeting_room where f_RoomId=#{roomId}")
	public MeetingRoomBean quertMeetingRoomByName(int roomId);
	
	/**
	 * 更新会议室
	 * @param meetingRoomBean
	 * @return
	 */
	@Update("update tb_meeting_room set f_RoomNo=#{f_RoomNo},f_RoomName=#{f_RoomName},"
			+ " f_ReaderID=#{f_ReaderID},f_Notes=#{f_Notes} where f_RoomId=#{f_RoomId}")
	public int upMeetingRoom(MeetingRoomBean meetingRoomBean);
	
	/**
	 * 查询所有读卡器
	 * @return
	 */
	@Select("select * from t_b_Reader")	
	public List<ReaderBean> getReaderList();
	
	/**
	 * 查询所有读卡器
	 * @return
	 */
//	@Select("select * from t_b_Reader where (f_ReaderID in (${ids}))")	
//	public List<ReaderBean> getReaderListById(String ids);
	@Select("<script>"
            + "SELECT * FROM t_b_Reader WHERE f_ReaderID IN "
            + "<foreach item='item' index='index' collection='list'      open='(' separator=',' close=')'>"
            + "#{item}"
            + "</foreach>"
            + "</script>")
	public List<ReaderBean> getReaderListById(@Param("list") List<String> list);
}