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.LocStatusBean;
|
|
@Repository
|
public interface LocStatusDao {
|
|
// /**
|
// *根据名称或id验证是否唯一
|
// * @param map
|
// * @return
|
// */
|
// public List<LocStatusBean> getLocStatusByCon(Map<String,Object>map);
|
|
/**
|
* 添加工作状态
|
* @param locStatus
|
* @return
|
*/
|
@Insert("insert into asr_bas_loc_type(loc_sts,loc_desc,modi_user,modi_time) values(#{loc_sts},#{loc_desc},#{modi_user},getdate())")
|
public int insertLocStatus(LocStatusBean locStatus);
|
|
|
//分页查询所有工作状态信息
|
// @Select("select * from tb_dept ORDER BY dept_id desc LIMIT #{spage},#{epage}")
|
@Select("select top (#{epage}) * from asr_bas_loc_type where loc_sts not in "
|
+ "(select top (#{spage}) loc_sts from asr_bas_loc_type order by loc_sts asc) order by loc_sts asc")
|
public List<LocStatusBean> queryLocStatusList(@Param("spage")int spage,@Param("epage")int epage);
|
|
//统计所有数据总数量
|
@Select("select count(*) from asr_bas_loc_type")
|
public int getLocStatusCount();
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from asr_bas_loc_type order by loc_sts asc")
|
public List<LocStatusBean> getLocStatusList();
|
|
/**
|
* 根据id查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select * from asr_bas_loc_type where loc_sts=#{locSts}")
|
public LocStatusBean getLocStatusById(String locSts);
|
|
//更新
|
@Update("update asr_bas_loc_type set loc_desc=#{loc_desc},modi_user=#{modi_user},modi_time=getdate() where loc_sts=#{loc_sts}")
|
public int upLocStatus(LocStatusBean locStatus);
|
|
//根据id删除工作信息
|
@Delete("delete from asr_bas_loc_type where loc_sts=#{locSts}")
|
public int delLocStatusById(String locSts);
|
|
}
|
