OrganizationManagementMapper.java 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. package com.goafanti.common.dao;
  2. import java.util.List;
  3. import java.util.Map;
  4. import com.goafanti.organization.bo.OrganizationListOut;
  5. import com.goafanti.admin.bo.AdminListBo;
  6. import com.goafanti.common.model.OrganizationManagement;
  7. import com.goafanti.common.model.OrganizationManagementExample;
  8. import org.apache.ibatis.annotations.Param;
  9. public interface OrganizationManagementMapper {
  10. /**
  11. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  12. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  13. */
  14. long countByExample(OrganizationManagementExample example);
  15. /**
  16. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  17. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  18. */
  19. int deleteByExample(OrganizationManagementExample example);
  20. /**
  21. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  22. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  23. */
  24. int deleteByPrimaryKey(String id);
  25. /**
  26. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  27. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  28. */
  29. int insert(OrganizationManagement record);
  30. /**
  31. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  32. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  33. */
  34. int insertSelective(OrganizationManagement record);
  35. /**
  36. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  37. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  38. */
  39. List<OrganizationManagement> selectByExample(OrganizationManagementExample example);
  40. /**
  41. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  42. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  43. */
  44. OrganizationManagement selectByPrimaryKey(String id);
  45. /**
  46. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  47. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  48. */
  49. int updateByExampleSelective(@Param("record") OrganizationManagement record,
  50. @Param("example") OrganizationManagementExample example);
  51. /**
  52. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  53. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  54. */
  55. int updateByExample(@Param("record") OrganizationManagement record,
  56. @Param("example") OrganizationManagementExample example);
  57. /**
  58. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  59. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  60. */
  61. int updateByPrimaryKeySelective(OrganizationManagement record);
  62. /**
  63. * This method was generated by MyBatis Generator. This method corresponds to the database table organization_management
  64. * @mbg.generated Thu Nov 30 11:09:29 CST 2017
  65. */
  66. int updateByPrimaryKey(OrganizationManagement record);
  67. List<OrganizationListOut> selectSuperId(@Param("sort")int sort);
  68. /**
  69. * 根据组织名称查组织编号
  70. */
  71. String selectDepNoByName(String name);
  72. /**
  73. * 根据上级组织查组织编号
  74. */
  75. String selectDepNo(String id);
  76. /**
  77. /**
  78. * 查询相同上级下编号数量
  79. */
  80. int selectDepNoCount(String superId);
  81. /**
  82. * 模糊查询负责人名称
  83. */
  84. List<AdminListBo> selectName(String name);
  85. OrganizationListOut selectAllById(String id);
  86. int deleteById(String id);
  87. String selectAdminNameById(String name);
  88. String selectIdByDepNo(String depNo);
  89. /**
  90. * 查询有相同上级组织的信息
  91. * @param superId
  92. * @return
  93. */
  94. List<OrganizationListOut> selectIDNBySuperId(String superId);
  95. int updateByNumber(OrganizationListOut olo);
  96. int selectCountBySuperId(String superId);
  97. String selectIdByName(String name);
  98. String selectNameById(String id);
  99. String selectDepNoById(String id);
  100. int selectUserById(String id);
  101. /**
  102. * 查询下级集合
  103. * @param superIds
  104. * @return
  105. */
  106. List<OrganizationManagement> selectSubDeps(@Param("superIds")String superIds);
  107. /**
  108. * 查询当前集合
  109. * @param adminId
  110. * @return
  111. */
  112. List<OrganizationManagement> selectCurrentDeps(@Param("aid")String aid);
  113. /**
  114. * 查询所有部门
  115. * @return
  116. */
  117. List<OrganizationManagement> selectAllDeps();
  118. /**
  119. * 查询最大编号
  120. * @param abbreviation
  121. * @return
  122. */
  123. String getMaxAbbreviation(String abbreviation);
  124. }