From c8aee7b9bfd79cfd741d7e5692520f4f51a31a86 Mon Sep 17 00:00:00 2001
From: kimi <kimi42345@gmail.com>
Date: 星期一, 18 五月 2020 18:30:01 +0800
Subject: [PATCH] bak 修改 获取版本数据前
---
src/main/java/com/highdatas/mdm/mapper/TableInfoMapper.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/highdatas/mdm/mapper/TableInfoMapper.java b/src/main/java/com/highdatas/mdm/mapper/TableInfoMapper.java
index 782d7a0..7cfa399 100644
--- a/src/main/java/com/highdatas/mdm/mapper/TableInfoMapper.java
+++ b/src/main/java/com/highdatas/mdm/mapper/TableInfoMapper.java
@@ -18,11 +18,17 @@
String selectTableByName(@Param("tableName")String tableName);
+ List<Map<String,Object>> selectIdxByTableName(@Param("tableName")String tableName);
+
+ void insertOneSelect(@Param("tableName")String tableName, @Param("fields")String fields, @Param("selectFields")String selectFields, @Param("selectSql")String selectSql);
+
List<TableSchemaResult> getTableField(@Param("tableName")String tableName);
List<TableSchemaResult> getTableFieldFromDb(@Param("tableName")String tableName, @Param("dbName")String dbName);
List<Map<String,Object>> selectByPage(@Param("tableName") String tableName, @Param("fields") String fields, @Param("where") String where, @Param("limit") String limit);
+
+ List<Map<String,Object>> selectDistinct(@Param("tableName") String tableName, @Param("fields") String fields, @Param("where") String where);
List<Map<String,Object>> selectByPageByVersion(@Param("tableName") String tableName,@Param("tableTempName") String tableTempName, @Param("fields") String fields, @Param("tempFields") String tempFields,@Param("Hfields") String Hfields, @Param("A1fields") String A1fields, @Param("A2fields") String A2fields, @Param("tempHFields") String tempHFields, @Param("fromOrderNo") Integer fromOrderNo, @Param("toOrderNo") Integer toOrderNo, @Param("maintainId") String maintainId, @Param("where") String where, @Param("limit") String limit);
@@ -40,6 +46,8 @@
void insert(@Param("tableName") String tableName, @Param("fields") String fields, @Param("values") String values);
void update(@Param("tableName") String tableName, @Param("updateSegment") String updateSegment, @Param("where") String where);
+
+ void updateJoin(@Param("tableName") String tableName, @Param("joinTableSegment") String joinTableSegment, @Param("updateSegment") String updateSegment, @Param("where") String where);
void delete(@Param("tableName") String tableName, @Param("where") String where);
@@ -66,7 +74,13 @@
Map<String,String> selectActMemberShip(@Param("userId")String userId, @Param("roleId")String roleId);
+ List<Map<String,Object>> selectActMemberShipByRole(@Param("roleId")String roleId);
+
+ List<Map<String,Object>> selectActMemberShipByUser(@Param("userId")String userId);
+
List<Map<String, Object>> getOneTempFieldDataByMaintainExtent(@Param("tableName")String tableName, @Param("tempTableName")String tempTableName,@Param("field")String field, @Param("fromOrderNo")Integer fromOrderNo, @Param("toOrderNo")Integer toOrderNo);
List<Map<String, Object>> getTempDataByMaintainExtent(@Param("tableName")String tableName, @Param("tempTableName")String tempTableName,@Param("fromOrderNo")Integer fromOrderNo, @Param("toOrderNo")Integer toOrderNo);
+
+ void createIdx(@Param("tableName")String recordTableName, @Param("idxName")String idxName, @Param("fields") String fields);
}
--
Gitblit v1.8.0