From 60e3a34a20fcb8dc46ec8a1122e61858b6b7b3a0 Mon Sep 17 00:00:00 2001 From: whycq <123456> Date: 星期四, 27 十月 2022 00:00:37 +0800 Subject: [PATCH] # --- src/main/webapp/views/locDetl/locDetl.html | 8 +++++++- src/main/resources/mapper/LocDetlMapper.xml | 3 +++ src/main/webapp/views/pakStore/locDetlQuery.html | 5 +++++ src/main/resources/application.yml | 2 +- 4 files changed, 16 insertions(+), 2 deletions(-) diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml index 43082fc..d5ed12f 100644 --- a/src/main/resources/application.yml +++ b/src/main/resources/application.yml @@ -10,7 +10,7 @@ enabled: false datasource: driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver - url: jdbc:sqlserver://localhost:1433;databasename=hylyasrs + url: jdbc:sqlserver://10.10.10.210:1433;databasename=hylyasrs username: sa password: sa@123 mvc: diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index 3d1dedc..feaf239 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -97,6 +97,9 @@ <if test="anfme!=null and anfme!='' "> and a.anfme like '%' + #{anfme} + '%' </if> + <if test="batch!=null and batch!='' "> + and a.batch like #{batch} + </if> <if test="startTime!=null and endTime!=null"> and a.modi_time between #{startTime} and #{endTime} </if> diff --git a/src/main/webapp/views/locDetl/locDetl.html b/src/main/webapp/views/locDetl/locDetl.html index 6248d71..cc00531 100644 --- a/src/main/webapp/views/locDetl/locDetl.html +++ b/src/main/webapp/views/locDetl/locDetl.html @@ -36,7 +36,13 @@ <!-- </div>--> <div class="layui-inline"> <div class="layui-input-inline"> - <input class="layui-input" type="text" name="condition" placeholder="璇疯緭鍏�" autocomplete="off"> + <input class="layui-input" type="text" name="condition" placeholder="鍟嗗搧鍚嶇О" autocomplete="off"> + </div> + + </div> + <div class="layui-inline"> + <div class="layui-input-inline"> + <input class="layui-input" type="text" name="batch" placeholder="鎵瑰彿" autocomplete="off"> </div> </div> diff --git a/src/main/webapp/views/pakStore/locDetlQuery.html b/src/main/webapp/views/pakStore/locDetlQuery.html index 35b9f09..16654fe 100644 --- a/src/main/webapp/views/pakStore/locDetlQuery.html +++ b/src/main/webapp/views/pakStore/locDetlQuery.html @@ -72,6 +72,11 @@ <input class="layui-input" type="text" name="maktx" placeholder="鐗╂枡鎻忚堪" autocomplete="off"> </div> </div> + <div class="layui-inline"> + <div class="layui-input-inline"> + <input class="layui-input" type="text" name="batch" placeholder="鎵瑰彿" autocomplete="off"> + </div> + </div> <!-- 鏃ユ湡鑼冨洿 --> <div class="layui-inline" style="width: 300px"> <div class="layui-input-inline"> -- Gitblit v1.9.1