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