ServiceBaseUtil.java 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. package jnpf.base.util;
  2. import com.baomidou.dynamic.datasource.annotation.DS;
  3. import jnpf.base.service.BillRuleService;
  4. import jnpf.base.service.DataInterfaceService;
  5. import jnpf.base.service.DbLinkService;
  6. import jnpf.base.service.DbTableService;
  7. import jnpf.database.model.dbfield.DbFieldModel;
  8. import jnpf.database.model.dbtable.DbTableFieldModel;
  9. import jnpf.database.model.entity.DbLinkEntity;
  10. import jnpf.permission.entity.OrganizeEntity;
  11. import jnpf.permission.entity.UserEntity;
  12. import jnpf.permission.service.OrganizeService;
  13. import jnpf.permission.service.PositionService;
  14. import jnpf.permission.service.UserService;
  15. import jnpf.util.StringUtil;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17. import org.springframework.stereotype.Component;
  18. import java.util.ArrayList;
  19. import java.util.Collections;
  20. import java.util.List;
  21. import java.util.Map;
  22. import static jnpf.util.Constants.ADMIN_KEY;
  23. /**
  24. * @author :JNPF开发平台组
  25. * @version: V3.1.0
  26. * @copyright 引迈信息技术有限公司
  27. * @date :2022/4/9 13:28
  28. */
  29. @Component
  30. @DS("")
  31. public class ServiceBaseUtil {
  32. @Autowired
  33. private DbLinkService dblinkService;
  34. @Autowired
  35. private DbTableService dbTableService;
  36. @Autowired
  37. private UserService userService;
  38. @Autowired
  39. private OrganizeService organizeService;
  40. @Autowired
  41. private PositionService positionService;
  42. @Autowired
  43. private BillRuleService billRuleService;
  44. @Autowired
  45. private DataInterfaceService dataInterfaceService;
  46. //--------------------------------数据连接------------------------------
  47. public DbLinkEntity getDbLink(String dbLink) {
  48. DbLinkEntity link = StringUtil.isNotEmpty(dbLink) ? dblinkService.getInfo(dbLink) : null;
  49. return link;
  50. }
  51. public boolean isExistTable(String dbLinkId, String table) throws Exception {
  52. return dbTableService.isExistTable(dbLinkId, table);
  53. }
  54. public void createTable(List<DbTableFieldModel> dbTable) throws Exception {
  55. for (DbTableFieldModel dbTableFieldModel : dbTable) {
  56. dbTableService.createTable(dbTableFieldModel);
  57. }
  58. }
  59. public void addField(DbTableFieldModel dbTable) throws Exception {
  60. dbTableService.addField(dbTable);
  61. }
  62. /**
  63. * 获取所有字段
  64. *
  65. * @param linkId 链接名
  66. * @param table 表名
  67. * @return
  68. * @throws Exception
  69. */
  70. public List<DbFieldModel> getFieldList(String linkId, String table) throws Exception {
  71. return dbTableService.getFieldList(linkId, table);
  72. }
  73. //--------------------------------用户------------------------------
  74. public UserEntity getUserInfo(String id) {
  75. UserEntity entity = null;
  76. if (StringUtil.isNotEmpty(id)) {
  77. entity = id.equalsIgnoreCase(ADMIN_KEY) ? userService.getUserByAccount(id) : userService.getInfo(id);
  78. }
  79. return entity;
  80. }
  81. //--------------------------------单据规则------------------------------
  82. public String getBillNumber(String enCode) {
  83. String billNo = "";
  84. try {
  85. billNo = billRuleService.getBillNumber(enCode, false);
  86. } catch (Exception e) {
  87. }
  88. return billNo;
  89. }
  90. //--------------------------------组织------------------------------
  91. public String getOrganizeName(String idStr) {
  92. return organizeService.getNameByIdStr(idStr);
  93. }
  94. public OrganizeEntity getOrganizeInfo(String id) {
  95. OrganizeEntity entity = StringUtil.isNotEmpty(id) ? organizeService.getInfo(id) : null;
  96. return entity;
  97. }
  98. public List<OrganizeEntity> getOrganizeId(String organizeId) {
  99. List<OrganizeEntity> organizeList = new ArrayList<>();
  100. organizeService.getOrganizeId(organizeId, organizeList);
  101. Collections.reverse(organizeList);
  102. return organizeList;
  103. }
  104. //--------------------------------岗位------------------------------
  105. public String getPositionName(String idStr) {
  106. return positionService.getNameByIdStr(idStr);
  107. }
  108. //--------------------------------远端------------------------------
  109. public void infoToId(String interId, Map<String, String> parameterMap) {
  110. dataInterfaceService.infoToId(interId, null, parameterMap);
  111. }
  112. }