From de971add14a7479aa9b18eadf8d6fad5be381d38 Mon Sep 17 00:00:00 2001
From: gao <gaoleox@163>
Date: Tue, 16 Jun 2020 16:08:47 +0800
Subject: [PATCH] 后台更新
---
src/main/resources/mapper/modules/contract/ContractHoldOrderDao.xml | 58 +++++++---------------------
src/main/java/com/xcong/excoin/modules/trademanage/mapper/ContractHoldOrderEntityMapper.java | 4 +
2 files changed, 18 insertions(+), 44 deletions(-)
diff --git a/src/main/java/com/xcong/excoin/modules/trademanage/mapper/ContractHoldOrderEntityMapper.java b/src/main/java/com/xcong/excoin/modules/trademanage/mapper/ContractHoldOrderEntityMapper.java
index 9e1120f..9dcfc86 100644
--- a/src/main/java/com/xcong/excoin/modules/trademanage/mapper/ContractHoldOrderEntityMapper.java
+++ b/src/main/java/com/xcong/excoin/modules/trademanage/mapper/ContractHoldOrderEntityMapper.java
@@ -16,5 +16,7 @@
public interface ContractHoldOrderEntityMapper extends BaseMapper<ContractHoldOrderEntity> {
IPage<ContractHoldOrderEntity> selectContractHoldOrderListInPage(Page<ContractHoldOrderEntity> page,
- @Param("record") ContractHoldOrderEntity contractHoldOrderEntity);
+ @Param("contractHoldOrderEntity") ContractHoldOrderEntity contractHoldOrderEntity);
+
+ long countContractHoldOrderSql(@Param("contractHoldOrderEntity") ContractHoldOrderEntity contractHoldOrderEntity);
}
diff --git a/src/main/resources/mapper/modules/contract/ContractHoldOrderDao.xml b/src/main/resources/mapper/modules/contract/ContractHoldOrderDao.xml
index 3572e89..e9797fe 100644
--- a/src/main/resources/mapper/modules/contract/ContractHoldOrderDao.xml
+++ b/src/main/resources/mapper/modules/contract/ContractHoldOrderDao.xml
@@ -1,48 +1,20 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.xcong.excoin.modules.contract.dao.ContractHoldOrderDao">
+<mapper
+ namespace="com.xcong.excoin.modules.trademanage.mapper.ContractHoldOrderEntityMapper">
+ <sql id="countContractHoldOrderSql">
+ SELECT
+ COUNT(1)
+ FROM
+ contract_hold_order
+ </sql>
- <update id="updateContractHoldOrderCanNotClosingByIds" parameterType="map">
- UPDATE contract_hold_order set is_can_closing = 0,batch_no=#{batchNo}
- where is_can_closing=1
- and id in
- <foreach collection="list" close=")" item="item" open="(" separator=",">
- #{item.orderId}
- </foreach>
- </update>
+ <sql id="findContractHoldOrderSql">
+ SELECT a.* FROM contract_hold_order a
+ </sql>
- <select id="selectContractHoldOrderByBatchNo" parameterType="string" resultType="com.xcong.excoin.modules.contract.entity.ContractHoldOrderEntity">
- select * from contract_hold_order where batch_no=#{batchNo}
- </select>
-
- <update id="updateOrderIsCanClosingAndBatchNoById" parameterType="long">
- update contract_hold_order set is_can_closing = 1 ,batch_no=null
- where id=#{id}
- </update>
-
- <select id="selectHoldOrderListByMemberId" resultType="com.xcong.excoin.modules.contract.entity.ContractHoldOrderEntity">
- select * from contract_hold_order where member_id=#{memberId} and is_can_closing=1 order by create_time desc
- </select>
-
- <select id="selectHoldOrderListByMemberIdAndSymbol" resultType="com.xcong.excoin.modules.contract.entity.ContractHoldOrderEntity">
- select * from contract_hold_order where member_id=#{memberId}
- <if test="symbol!=null and symbol!=''">
- and symbol=#{symbol}
- </if>
- and is_can_closing=1
- order by create_time desc
- </select>
-
- <select id="selectHoldOrderByMemberIdAndId" resultType="com.xcong.excoin.modules.contract.entity.ContractHoldOrderEntity">
- select * from contract_hold_order where member_id=#{memberId} and id=#{id}
- </select>
-
- <update id="updateHoldOrderIsCanClosingById">
- update contract_hold_order set is_can_closing=#{isCanClosing}
- where id=#{id}
- </update>
-
- <select id="selectAllHoldOrder" resultType="com.xcong.excoin.modules.contract.entity.ContractHoldOrderEntity">
- select * from contract_hold_order
- </select>
+ <select id="selectContractHoldOrderListInPage"
+ parameterType="contractHoldOrderEntity" resultType="contractHoldOrderEntity">
+ <include refid="findContractHoldOrderSql" />
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.1