SameleveltransferMinidaoDao.java 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. package cn.com.lzt.sameleveltransfer.dao;
  2. import java.util.Date;
  3. import java.util.List;
  4. import org.jeecgframework.minidao.annotation.Arguments;
  5. import org.jeecgframework.minidao.annotation.MiniDao;
  6. import org.jeecgframework.minidao.annotation.Param;
  7. import org.jeecgframework.minidao.annotation.ResultType;
  8. import org.jeecgframework.minidao.annotation.Sql;
  9. import org.jeecgframework.minidao.pojo.MiniDaoPage;
  10. import cn.com.lzt.sameleveltransfer.entity.SamelevelTransferDaoEntity;
  11. /**
  12. * Minidao例子
  13. *
  14. */
  15. @MiniDao
  16. public interface SameleveltransferMinidaoDao {
  17. @Arguments({"samelevelTransferDao","useridList","useridList1","orgidList", "page", "rows","authSql"})
  18. @ResultType(SamelevelTransferDaoEntity.class)
  19. public MiniDaoPage<SamelevelTransferDaoEntity> getAllEntities(SamelevelTransferDaoEntity samelevelTransferDao,List<String> useridList,List<String> useridList1,List<String> orgidList, int page, int rows,String authSql);
  20. @Arguments({"samelevelTransferDao","useridList","useridList1","orgidList", "page", "rows","authSql"})
  21. @ResultType(SamelevelTransferDaoEntity.class)
  22. public MiniDaoPage<SamelevelTransferDaoEntity> getAllActivitiEntities(SamelevelTransferDaoEntity samelevelTransferDao,List<String> useridList,List<String> useridList1,List<String> orgidList, int page, int rows,String authSql);
  23. /**
  24. * 通过时间查询工作流已完成的数据
  25. * @param userid 用户id
  26. * @param inTime 调入日期
  27. */
  28. @Sql("select * from t_bus_samelevel_transfer where bpm_status = 3 and to_days(in_time) = to_days(:inTime) and delete_flag = 0")
  29. public List<SamelevelTransferDaoEntity> getByDate(@Param("inTime")Date inTime);
  30. //获得部门下某岗位的人数
  31. @Arguments({"departId","postId"})
  32. public Integer getDepartPostUserCount(String departId,String postId);
  33. //获得父部门下某岗位的人数
  34. @Arguments({"departId","postId"})
  35. public Integer getParentDepartPostUserCount(String departId,String postId);
  36. }