WODispatchCmdPatchItemMapper.java 3.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. package com.shkpr.service.aimodelpower.dbdao.mapper;
  2. import com.shkpr.service.aimodelpower.dbdao.providers.WODispatchCmdBatchDisposalSqlProvider;
  3. import com.shkpr.service.aimodelpower.dbdao.providers.WODispatchCmdBatchItemSqlProvider;
  4. import org.apache.ibatis.annotations.InsertProvider;
  5. import org.apache.ibatis.annotations.Param;
  6. import org.apache.ibatis.annotations.SelectProvider;
  7. import org.apache.ibatis.annotations.UpdateProvider;
  8. import java.util.List;
  9. import java.util.Map;
  10. public interface WODispatchCmdPatchItemMapper {
  11. @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "totalCounts")
  12. int totalCounts(@Param("table") String table
  13. , @Param("andWheres") Map<String, Object> andWheres
  14. , @Param("orWheres") Map<String, Object> orWheres
  15. , @Param("extend") String extend);
  16. @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "listAllWiths")
  17. List<Map<String, Object>> listAllWiths(@Param("table") String table, @Param("filed") String file
  18. , @Param("limit") int limit
  19. , @Param("offset") int offset
  20. , @Param("andWheres") Map<String, Object> andWheres
  21. , @Param("orWheres") Map<String, Object> orWheres
  22. , @Param("order") String order
  23. , @Param("extend") String extend);
  24. @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "getByUniqueId")
  25. Map<String, Object> getOne(@Param("table") String table, @Param("filed") String filed, @Param("id") Object id);
  26. @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "batchQueryIn")
  27. List<Map<String, Object>> batchQueryIn(@Param("table") String table, @Param("filed") String file
  28. , @Param("ids") List<? extends Object> ids
  29. , @Param("order") String order
  30. , @Param("extend") String extend);
  31. @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "batchQueryWiths")
  32. List<Map<String, Object>> batchQueryWiths(@Param("table") String table, @Param("filed") String filed
  33. , @Param("andWheres") Map<String, Object> andWheres
  34. , @Param("orWheres") Map<String, Object> orWheres
  35. , @Param("order") String order
  36. , @Param("extend") String extend);
  37. @InsertProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "inserts")
  38. int inserts(@Param("inserts") Map<String, Object> inserts);
  39. /**
  40. * update和delete返回受影响条数需要配合useAffectedRows=true
  41. * @param datas
  42. * @param andWheres
  43. * @return
  44. */
  45. @UpdateProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "updateWiths")
  46. int updateWiths(@Param("datas") Map<String, Object> datas
  47. , @Param("andWheres") Map<String, Object> andWheres
  48. , @Param("orWheres") Map<String, Object> orWheres
  49. , @Param("extend") String extend);
  50. @SelectProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "existsLine")
  51. boolean existLine(@Param("table") String table
  52. , @Param("andWheres") Map<String, Object> andWheres
  53. , @Param("orWheres") Map<String, Object> orWheres
  54. , @Param("extend") String extend);
  55. @UpdateProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "batchUpdateWiths")
  56. int batchUpdateWiths(@Param("andWheres") List<Map<String, Object>> andWheres
  57. , @Param("datas") List<Map<String, Object>> datas);
  58. @InsertProvider(type = WODispatchCmdBatchItemSqlProvider.class, method = "insertsThisData")
  59. int insertsThisData(@Param("inserts") Map<String, Object> inserts);
  60. }