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.WorkNoBean;

@Repository
public interface WorkNoDao {

	/**
	 * 添加
	 * @param workNo
	 * @return
	 */
	@Insert("insert into asr_wrk_lastno(wrk_mk,s_no,e_no,wrk_no,memo_m,modi_user,modi_time) "
			+ " values(#{wrk_mk},#{s_no},#{e_no},#{wrk_no},#{memo_m},#{modi_user},getdate())")
	public int insertWorkNo(WorkNoBean workNo);
	
	
	//分页查询所有信息
//	@Select("select * from tb_dept ORDER BY dept_id desc LIMIT #{spage},#{epage}")
	@Select("select top (#{epage}) * from asr_wrk_lastno where wrk_mk not in "
			+ " (select top (#{spage}) wrk_mk from asr_wrk_lastno order by wrk_mk asc) order by wrk_mk asc")
	public List<WorkNoBean> queryWorkNoList(@Param("spage")int spage,@Param("epage")int epage);
	
	//统计所有数据总数量
	@Select("select count(*) from asr_wrk_lastno")
	public int getWorkNoCount();
	
	/**
	 * 查询所有
	 * @return
	 */
	@Select("select * from asr_wrk_lastno order by wrk_mk asc")
	public List<WorkNoBean> getWorkNoList();
	
	/**
	 * 根据id查询信息
	 * @param id
	 * @return
	 */
	@Select("select * from asr_wrk_lastno where wrk_mk=#{id}")
	public WorkNoBean getWorkNoById(int id);
	
	//更新
	@Update("update asr_wrk_lastno set s_no=#{s_no},e_no=#{e_no},wrk_no=#{wrk_no},"
			+ " memo_m=#{memo_m},modi_user=#{modi_user},modi_time=getdate() "
			+ " where wrk_mk=#{wrk_mk}")
	public int upWorkNo(WorkNoBean workNo);
	
	//根据id删除工作信息
	@Delete("delete from asr_wrk_lastno where wrk_mk=#{id}")
	public int delWorkNoById(int id);
	
}