package com.slcf.dao;
|
|
import java.util.List;
|
import java.util.Map;
|
|
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.DeptBean;
|
import com.slcf.pojo.DeptOpt;
|
|
@Repository
|
public interface DeptDao {
|
|
/**
|
*根据部门名称或部门id验证部门名称是否唯一
|
* @param map
|
* @return
|
*/
|
public List<DeptBean> getDeptByCon(Map<String,Object>map);
|
|
/**
|
* 添加部门
|
* @param dept
|
* @return
|
*/
|
@Insert("insert into tb_dept(dept_name,dept_desc) values(#{dept_name},#{dept_desc})")
|
public int insertDept(DeptBean dept);
|
|
|
//分页查询所以部门
|
// @Select("select * from tb_dept ORDER BY dept_id desc LIMIT #{spage},#{epage}")
|
@Select("select top (#{epage}) * from tb_dept where dept_id not in "
|
+ "(select top (#{spage}) dept_id from tb_dept order by dept_id desc) order by dept_id desc")
|
public List<DeptBean> queryDeptList(@Param("spage")int spage,@Param("epage")int epage);
|
|
//统计所以部门数量
|
@Select("select count(*) from tb_dept")
|
public int getDeptCount();
|
|
/**
|
* 查询所有部门
|
* @return
|
*/
|
@Select("select * from tb_dept order by dept_id")
|
public List<DeptBean> getDeptList();
|
|
/**
|
* 根据部门id查询部门信息
|
* @param id
|
* @return
|
*/
|
@Select("select * from tb_dept where dept_id=#{id}")
|
public DeptBean getDeptById(int id);
|
|
//更新
|
@Update("update tb_dept set dept_name=#{dept_name},dept_desc=#{dept_desc} where dept_id=#{dept_id}")
|
public int upDept(DeptBean dept);
|
|
//根据部门id删除部门表的信息
|
@Delete("delete from tb_dept where dept_id=#{id}")
|
public int delDeptById(int id);
|
|
/**
|
* 添加部门操作记录表的信息
|
* @param did 部门id
|
* @param dname 操作人名字
|
* @param dtype 操作类型
|
* @return
|
*/
|
@Insert("insert into tb_dept_opt(d_id,dopt_name,dopt_type,dopt_time) values(#{did},#{dname},#{dtype},getdate())")
|
public int insertDeptOpt(@Param("did")int did,@Param("dname")String dname,@Param("dtype")String dtype);
|
|
//根据部门id删除部门操作记录表信息
|
@Delete("delete from tb_dept_opt where d_id=#{id}")
|
public int delDeptOpt(int id);
|
|
/**
|
* 根据部门id查询部门操作表
|
* @param id
|
* @return
|
*/
|
@Select("select * from tb_dept_opt where d_id=#{id}")
|
public List<DeptOpt> getOptList(int id);
|
}
|
