From 9d29d13a01ec9bcb842f1e15e8dc566a2e50a127 Mon Sep 17 00:00:00 2001 From: whycq <123456> Date: 星期二, 10 九月 2024 19:07:32 +0800 Subject: [PATCH] # --- src/main/resources/mapper/WrkMastMapper.xml | 2 +- src/main/resources/application.yml | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml index e58b569..c1bff08 100644 --- a/src/main/resources/application.yml +++ b/src/main/resources/application.yml @@ -8,7 +8,7 @@ name: @pom.build.finalName@ datasource: driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver - url: jdbc:sqlserver://127.0.0.1:1433;databasename=phpsasrs + url: jdbc:sqlserver://10.10.10.233:1433;databasename=phpsasrs # url: jdbc:sqlserver://192.168.4.15:1433;databasename=phpsasrs username: sa password: sa@123 diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml index 411f5ef..e4c5085 100644 --- a/src/main/resources/mapper/WrkMastMapper.xml +++ b/src/main/resources/mapper/WrkMastMapper.xml @@ -201,7 +201,7 @@ <select id="selectWrkIoType" resultMap="BaseResultMap"> select * from asr_wrk_mast where crn_no=#{crnNo} and wrk_sts=11 and io_type>100 - order by io_pri desc,io_time desc,wrk_no ASC + order by io_pri desc,io_time ASC,wrk_no ASC </select> <select id="selectpj" resultMap="BaseResultMap"> -- Gitblit v1.9.1