excel导入送货物料信息

yusijie

2025-10-30 81c6759dcee2dad7b63efdc87f660d4550d1572d

 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) {