BusinessProjectMapper.java 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  1. package com.goafanti.common.dao;
  2. import com.goafanti.app.bo.ProjectBo;
  3. import com.goafanti.app.bo.ProjectDetailBo;
  4. import com.goafanti.business.bo.BusinessProjectBo;
  5. import com.goafanti.common.model.BusinessCategory;
  6. import com.goafanti.common.model.BusinessProject;
  7. import org.apache.ibatis.annotations.Param;
  8. import org.springframework.data.domain.Pageable;
  9. import java.util.List;
  10. import java.util.Map;
  11. /**
  12. * (BusinessProject)表数据库访问层
  13. *
  14. * @author makejava
  15. * @since 2024-09-19 14:54:12
  16. */
  17. public interface BusinessProjectMapper {
  18. /**
  19. * 通过ID查询单条数据
  20. *
  21. * @param id 主键
  22. * @return 实例对象
  23. */
  24. BusinessProject selectById(String id);
  25. /**
  26. * 查询指定行数据
  27. *
  28. * @param businessProject 查询条件
  29. * @param pageable 分页对象
  30. * @return 对象列表
  31. */
  32. List<BusinessProject> findBusinessProjectList(BusinessProject businessProject, @Param("pageable") Pageable pageable);
  33. /**
  34. * 统计总行数
  35. *
  36. * @param businessProject 查询条件
  37. * @return 总行数
  38. */
  39. int findBusinessProjectCount(BusinessProject businessProject);
  40. /**
  41. * 新增数据
  42. *
  43. * @param businessProject 实例对象
  44. * @return 影响行数
  45. */
  46. int insert(BusinessProject businessProject);
  47. /**
  48. * 批量新增数据(MyBatis原生foreach方法)
  49. *
  50. * @param entities List<BusinessProject> 实例对象列表
  51. * @return 影响行数
  52. */
  53. int insertBatch(@Param("entities") List<BusinessProject> entities);
  54. /**
  55. * 批量新增或按主键更新数据(MyBatis原生foreach方法)
  56. *
  57. * @param entities List<BusinessProject> 实例对象列表
  58. * @return 影响行数
  59. * @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常,请自行校验入参
  60. */
  61. int insertOrUpdateBatch(@Param("entities") List<BusinessProject> entities);
  62. /**
  63. * 修改数据
  64. *
  65. * @param businessProject 实例对象
  66. * @return 影响行数
  67. */
  68. int update(BusinessProject businessProject);
  69. /**
  70. * 通过主键删除数据
  71. *
  72. * @param id 主键
  73. * @return 影响行数
  74. */
  75. int deleteById(String id);
  76. int insertSelective(BusinessProject record);
  77. int getBnamecount(String bname);
  78. String getCreateName(String id);
  79. BusinessProject selectByPrimaryBname(String bname);
  80. List<ProjectBo> getBusinessProject(String id);
  81. ProjectDetailBo selectAppProjectDetail(String id);
  82. int checkProject(String id);
  83. List<BusinessProjectBo> selectBusinessProjectByName(@Param("businessName")String businessName, @Param("cname")String cname);
  84. List<BusinessProjectBo> selectByFirstBName(@Param("businessName") String businessName, @Param("type") Integer type);
  85. List<BusinessCategory> selectBusinessProjectCatalog();
  86. /**
  87. * @return
  88. */
  89. List<Map> selectProjectAndTypeAll();
  90. BusinessProject selectByTid(Integer tid);
  91. }