diff --git a/EastLineServer/src/main/resources/mybatis/CodeMapper.xml b/EastLineServer/src/main/resources/mybatis/CodeMapper.xml index d9e6bdf..811a67d 100644 --- a/EastLineServer/src/main/resources/mybatis/CodeMapper.xml +++ b/EastLineServer/src/main/resources/mybatis/CodeMapper.xml @@ -16,12 +16,12 @@ shiYingLvT, shiJingLv, shiXiaoLv, - format(meiGuJZC, 2) meiGuJZC, - format(jingZCSYLv, 2) jingZCSYLv, - format(zongGuBen, 2) zongGuBen, - format(zongZhi, 2) zongZhi, - format(liuTongGu, 2) liuTongGu, - format(liuZhi, 2) liuZhi, + convert(meiGuJZC, DECIMAL(18, 2)) meiGuJZC, + convert(jingZCSYLv, DECIMAL(18, 2)) jingZCSYLv, + convert(zongGuBen, DECIMAL(18, 2)) zongGuBen, + convert(zongZhi, DECIMAL(18, 2)) zongZhi, + convert(liuTongGu, DECIMAL(18, 2)) liuTongGu, + convert(liuZhi, DECIMAL(18, 2)) liuZhi, heXinTiCai FROM t_code WHERE `code` = #{code};