From 81c6759dcee2dad7b63efdc87f660d4550d1572d Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期四, 30 十月 2025 09:49:58 +0800
Subject: [PATCH] excel导入送货物料信息
---
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html | 21 ++++++++++++++++++---
1 files changed, 18 insertions(+), 3 deletions(-)
diff --git a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html
index ad73dc5..332f65c 100644
--- a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html
+++ b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html
@@ -95,6 +95,7 @@
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-logout"></i>鍒犻櫎</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_MaterPackQtyExcel" id="btn_MaterPackQtyExcel"><i class="layui-icon layui-icon-file-b"></i>Excel瀵煎叆</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
</div>
</script>
@@ -162,6 +163,9 @@
//鍒楄缃�
case 'set_HideColumn':
get_HideColumn();
+ break;
+ //瀵煎叆
+ case 'btn_MaterPackQtyExcel': set_MaterPackQtyExcel();
break;
};
});
@@ -296,13 +300,13 @@
if (HMaterNumber) {
- sWhere += " and 鐗╂枡浠ｇ爜 = '" + HMaterNumber + "'";
+ sWhere += " and 鐗╂枡浠ｇ爜 like '%" + HMaterNumber + "%'";
}
if (HMaterName) {
- sWhere += " and 鐗╂枡鍚嶇О = '" + HMaterName + "'";
+ sWhere += " and 鐗╂枡鍚嶇О like '%" + HMaterName + "%'";
}
if (HModel) {
- sWhere += " and 瑙勬牸鍨嬪彿 = '" + HModel + "'";
+ sWhere += " and 瑙勬牸鍨嬪彿 like '%" + HModel + "%'";
}
if (IsUse!=0) {
sWhere += " and 鏄惁鍚敤 = '" + IsUse + "'";
@@ -420,6 +424,17 @@
get_Display(sWhere);
}
+ //瀵煎叆
+ function set_MaterPackQtyExcel() {
+ layer.open({
+ type: 2
+ , area: ['100%', '100%']
+ , title: '閫佽揣鐗╂枡淇℃伅瀵煎叆'
+ , shift: 0//寮瑰嚭鍔ㄧ敾
+ , content: './SRM_SupMaterPackBill_Excel.html?OperationType=dao&HSouceBillType='
+ })
+ }
+
function Format(datetime, fmt) {
if (parseInt(datetime) == datetime) {
if (datetime.length == 10) {
--
Gitblit v1.9.1