From 07e2186c8e79045a578d13e9be169dac79df671a Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期三, 25 二月 2026 15:49:45 +0800
Subject: [PATCH] 1
---
WebTM/views/PublicPage/MaterialInfo.html | 64 ++++++++++++++++++++-----------
1 files changed, 41 insertions(+), 23 deletions(-)
diff --git a/WebTM/views/PublicPage/MaterialInfo.html b/WebTM/views/PublicPage/MaterialInfo.html
index 4fc18a9..5996537 100644
--- a/WebTM/views/PublicPage/MaterialInfo.html
+++ b/WebTM/views/PublicPage/MaterialInfo.html
@@ -8,6 +8,7 @@
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
<link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
+ <link rel="stylesheet" href="../../layuiadmin/ext/soulTable.css" media="all">
<script src="../../layuiadmin/layui/layui.js"></script>
<script src="../../layuiadmin/treeTable.js"></script>
<script src="../../layuiadmin/Scripts/json2.js"></script>
@@ -59,6 +60,12 @@
<input type="text" class="layui-input" name="HWHName" id="HWHName">
</div>
</div>
+ <div class="layui-inline">
+ <label class="layui-form-label">鍒嗙粍</label>
+ <div class="layui-input-block">
+ <input type="text" class="layui-input" name="HGroup" id="HGroup">
+ </div>
+ </div>
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
</button>
@@ -88,7 +95,7 @@
base: '../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
}).extend({
index: 'lib/index', //涓诲叆鍙ｆā鍧�
- }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {
+ }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable', 'tableFilter'], function () {
var $ = layui.$
, admin = layui.admin
, layer = layui.layer
@@ -99,6 +106,8 @@
, laydate = layui.laydate
, util = layui.util
, tree = layui.tree
+ , soulTable = layui.soulTable
+ , tableFilter = layui.tableFilter
//var sWhere = " where HStopFlag=0 and HEndFlag<>'1' and HUSEORGID = " + sessionStorage["OrganizationID"] + " "; //鏍戝瀷
//var sWhere1 = " where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + sessionStorage["OrganizationID"] + " "; //鍒楄〃
var sWhere = " where 1 = 1" + " ";
@@ -112,26 +121,31 @@
, cellMinWidth: 90
, cols: [[
{ type: 'checkbox', fixed: 'left' }
- , { field: '鐗╂枡浠撳簱璧勬枡浠ｇ爜', title: '鐗╂枡浠撳簱璧勬枡浠ｇ爜', sort: true }
- , { field: '鐗╂枡浠ｇ爜', title: '鐗╂枡浠ｇ爜', sort: true }
- , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О' }
- , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿' }
- , { field: '杈呭姪灞炴�т唬鐮�', title: '杈呭姪灞炴�т唬鐮�' }
- , { field: '杈呭姪灞炴�у悕绉�', title: '杈呭姪灞炴�у悕绉�' }
- , { field: '璁￠噺鍗曚綅浠ｇ爜', title: '璁￠噺鍗曚綅浠ｇ爜' }
- , { field: '璁￠噺鍗曚綅', title: '璁￠噺鍗曚綅' }
- , { field: '鎵规', title: '鎵规' }
- , { field: '鏁伴噺', title: '鏁伴噺' }
- , { field: '浠撳簱浠ｇ爜', title: '浠撳簱浠ｇ爜' }
- , { field: '浠撳簱', title: '浠撳簱' }
- , { field: '浠撲綅浠ｇ爜', title: '浠撲綅浠ｇ爜' }
- , { field: '浠撲綅', title: '浠撲綅' }
- , { field: '渚涘簲鍟嗕唬鐮�', title: '渚涘簲鍟嗕唬鐮�' }
- , { field: '渚涘簲鍟�', title: '渚涘簲鍟�' }
- , { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�' }
- , { field: '鎵�灞炵粍缁�', title: '鎵�灞炵粍缁�' }
+ , { field: '鐗╂枡浠撳簱璧勬枡浠ｇ爜', title: '鐗╂枡浠撳簱璧勬枡浠ｇ爜', sort: true, filter: true }
+ , { field: '鐗╂枡浠ｇ爜', title: '鐗╂枡浠ｇ爜', sort: true, filter: true}
+ , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', filter: true }
+ , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', filter: true }
+ , { field: '鍒嗙粍', title: '鍒嗙粍', filter: true }
+ , { field: '杈呭姪灞炴�т唬鐮�', title: '杈呭姪灞炴�т唬鐮�', filter: true }
+ , { field: '杈呭姪灞炴�у悕绉�', title: '杈呭姪灞炴�у悕绉�', filter: true }
+ , { field: '璁￠噺鍗曚綅浠ｇ爜', title: '璁￠噺鍗曚綅浠ｇ爜', filter: true }
+ , { field: '璁￠噺鍗曚綅', title: '璁￠噺鍗曚綅', filter: true}
+ , { field: '鎵规', title: '鎵规', filter: true }
+ , { field: '鏁伴噺', title: '鏁伴噺', filter: true }
+ , { field: '浠撳簱浠ｇ爜', title: '浠撳簱浠ｇ爜', filter: true}
+ , { field: '浠撳簱', title: '浠撳簱', filter: true }
+ , { field: '浠撲綅浠ｇ爜', title: '浠撲綅浠ｇ爜', filter: true }
+ , { field: '浠撲綅', title: '浠撲綅', filter: true }
+ , { field: '渚涘簲鍟嗕唬鐮�', title: '渚涘簲鍟嗕唬鐮�', filter: true }
+ , { field: '渚涘簲鍟�', title: '渚涘簲鍟�', filter: true }
+ , { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�', filter: true}
+ , { field: '鎵�灞炵粍缁�', title: '鎵�灞炵粍缁�', filter: true }
]]
+ , done: function (res, curr, count) {
+ soulTable.render(this);
+
+ }
};
//#region 鐐瑰嚮琛岄�変腑楂樹寒
@@ -183,17 +197,21 @@
var HName = $("#HName").val();
var HWHNumber = $("#HWHNumber").val();
var HWHName = $("#HWHName").val()
+ var HGroup = $("#HGroup").val()
if (HNumber) {
- sWhere += " and 鐗╂枡浠ｇ爜 = '" + HNumber + "'";
+ sWhere += " and 鐗╂枡浠ｇ爜 like '%" + HNumber + "%'";
}
if (HName) {
- sWhere += " and 鐗╂枡鍚嶇О = '" + HName + "'";
+ sWhere += " and 鐗╂枡鍚嶇О like '%" + HName + "%'";
}
if (HWHNumber) {
- sWhere += " and 浠撳簱浠ｇ爜 = '" + HWHNumber + "'";
+ sWhere += " and 浠撳簱浠ｇ爜 like '%" + HWHNumber + "%'";
}
if (HWHName) {
- sWhere += " and 浠撳簱 = '" + HWHName + "'";
+ sWhere += " and 浠撳簱 like '%" + HWHName + "%'";
+ }
+ if (HGroup) {
+ sWhere += " and 鍒嗙粍 like '%" + HGroup + "%'";
}
$.ajax({
url: GetWEBURL() + '/PublicPageMethod/MaterialList',
--
Gitblit v1.9.1