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


@Repository
public interface WorkStatusDao {

//	/**
//	 *根据名称或id验证是否唯一 
//	 * @param map
//	 * @return
//	 */
//	public List<WorkStatusBean> getWorkStatusByCon(Map<String,Object>map);
	
	/**
	 * 添加工作状态
	 * @param WorkStatus
	 * @return
	 */
	@Insert("insert into asr_bas_wrk_status(wrk_sts,wrk_desc,modi_user,modi_time) values(#{wrk_sts},#{wrk_desc},#{modi_user},getdate())")
	public int insertWorkStatus(WorkStatusBean workStatus);
	
	
	//分页查询所有工作状态信息
//	@Select("select * from tb_dept ORDER BY dept_id desc LIMIT #{spage},#{epage}")
	@Select("select top (#{epage}) * from asr_bas_wrk_status where wrk_sts not in "
			+ "(select top (#{spage}) wrk_sts from asr_bas_wrk_status order by wrk_sts asc) order by wrk_sts asc")
	public List<WorkStatusBean> queryWorkStatusList(@Param("spage")int spage,@Param("epage")int epage);
	
	//统计所有数据总数量
	@Select("select count(*) from asr_bas_wrk_status")
	public int getWorkStatusCount();
	
	/**
	 * 查询所有
	 * @return
	 */
	@Select("select * from asr_bas_wrk_status order by wrk_sts asc")
	public List<WorkStatusBean> getWorkStatusList();
	
	/**
	 * 根据id查询信息
	 * @param id
	 * @return
	 */
	@Select("select * from asr_bas_wrk_status where wrk_sts=#{id}")
	public WorkStatusBean getWorkStatusById(int id);
	
	//更新
	@Update("update asr_bas_wrk_status set wrk_desc=#{wrk_desc},modi_user=#{modi_user},modi_time=getdate() where wrk_sts=#{wrk_sts}")
	public int upWorkStatus(WorkStatusBean workStatus);
	
	//根据id删除工作信息
	@Delete("delete from asr_bas_wrk_status where wrk_sts=#{id}")
	public int delWorkStatusById(int id);
	
}