#

mrzhssss

2022-05-21 562984eb58d5b546203771ba956711fbccc5e773

#

 src/main/resources/application.yml

@@ -10,8 +10,8 @@
    enabled: false
  datasource:
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
#    url: jdbc:sqlserver://localhost:1433;databasename=jkasrs
    url: jdbc:sqlserver://10.20.192.200:1433;databasename=jkasrs
    url: jdbc:sqlserver://localhost:1433;databasename=jkasrs
#    url: jdbc:sqlserver://10.20.192.200:1433;databasename=jkasrs
    username: sa
    password: sa@123
  mvc:

 src/main/resources/mapper/ViewWorkInMapper.xml

@@ -99,11 +99,13 @@

<!-- 不分页查询所有信息，用于excel导出 -->
<select id="getViewWorkInAll" parameterType="com.zy.asrs.entity.ViewWorkInBean" resultType="com.zy.asrs.entity.ViewWorkInBean">
    select count(1)
    from asr_wrkin_view a
<!--    select count(1)-->
<!--    from asr_wrkin_view a-->
<!--    where 1=1-->
<!--    <include refid="viewWorkInConditionSql"></include>-->
    select * from asr_wrkin_view
    where 1=1
    <include refid="viewWorkInConditionSql"></include>
    order by io_time desc
</select>

<!-- 出库统计 -->