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>
@@ -163,6 +164,9 @@
                case 'set_HideColumn':
                    get_HideColumn();
                    break;
                //导入
                case 'btn_MaterPackQtyExcel': set_MaterPackQtyExcel();
                    break;
            };
        });

@@ -193,6 +197,9 @@
        // 查询
        function get_Display(sWhere) {
            var ajaxLoad = layer.load();
            if (sessionStorage["HSupIDs"].length < 1000) {
                sWhere += " and HSupID in (" + sessionStorage["HSupIDs"] + ")";
            }
            $.ajax({
                url: GetWEBURL() + '/MaterialHandingController/GetMaterialHandingList',
                type: "GET",
@@ -293,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 + "'";
@@ -415,6 +422,17 @@
        function get_Refresh() {
            set_ClearQuery();
            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) {
@@ -619,27 +637,42 @@
                , data = checkStatus.data;
            if (checkStatus.data.length === 1) {
                var InterID = data[0].HItemID.toString();
                //逻辑审核方法
                var HMaterID = data[0].物料ID.toString();
                var FirstID = sessionStorage["HSupIDs"];
                var HSupID = FirstID.split(",")[0];
                /*                var HSupID = "672189";*/

                // 先检查是否存在多条记录
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/MaterialHandingController/OpenMaterial", //方法所在页面和方法名
                    data: { "HInterID": InterID, "IsUse": num, "CurUserName": sessionStorage["HUserName"] },
                    url: GetWEBURL() + "/MaterialHandingController/CheckMaterialCount",
                    data: {
                        "HMaterID": HMaterID,
                        "HSupID": HSupID,
                        "HInterID": InterID
                    },
                    success: function (result) {
                        if (result.count == 1) {
                            layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                //// 得到frame索引
                                var index = layer.getFrameIndex(window.name);
                                ////关闭当前frame
                        if (result.count > 0) {
                            // 存在多条记录，弹出确认框
                            layer.confirm('同一供应商下的该物料存在多条记录，是否将其余记录设置为未启用？', {
                                btn: ['确定', '取消'],
                                title: "启用确认"
                            }, function (index) {
                                //传1，使用update
                                layer.close(index);
                                //修改为功后刷新界面
                                $("#btnSearch").trigger('click');
                                callForEnable(InterID, HMaterID, HSupID, 1, num);
                            }, function (index) {
                                //传0，直接启用
                                layer.close(index);
                                //callForEnable(InterID, HMaterID, HSupID, 0, num);
                            });

                        } else {
                            layer.alert(result.code + result.Message, { icon: 5 });
                            // 没有多条记录，直接启用
                            callForEnable(InterID, HMaterID, HSupID, 0, num);
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    },
                    error: function () {
                        layer.alert("检查记录数量失败!", { icon: 5 });
                    }
                });
            }
@@ -648,11 +681,47 @@
            }
        }

        function callForEnable(InterID, HMaterID, HSupID, disableOthers, num) {
            $.ajax({
                type: "GET",
                url: GetWEBURL() + "/MaterialHandingController/OpenMaterial",
                data: {
                    "HInterID": InterID,
                    "IsUse": num,
                    "CurUserName": sessionStorage["HUserName"],
                    "HMaterID": HMaterID,
                    "HSupID": HSupID,
                    "disableOthers": disableOthers
                },
                success: function (result) {
                    if (result.count == 1) {
                        layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                            // 得到frame索引
                            var index = layer.getFrameIndex(window.name);
                            // 关闭当前frame
                            layer.close(index);
                            // 修改成功后刷新界面
                            $("#btnSearch").trigger('click');
                        });
                    } else {
                        layer.alert(result.Message, { icon: 5 });
                    }
                },
                error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            });
        }
        //#endregion
       

        function get_createBarCode() {
            var checkStatus = table.checkStatus('mainTable')
                , data = checkStatus.data;
            if (data[0].是否启用 != 'Y') {
                layer.msg('请先启用再生成条码！');
                return;
            }
            if (checkStatus.data.length) {
                //var linterIDArray[0] = data[0].HItemID;
                var linterIDArray = []; var BarCodeArr = data[0].HItemID+',';
@@ -661,7 +730,8 @@
                    linterIDArray[i] = data[i].HItemID;
                    BarCodeArr = BarCodeArr + linterIDArray[i] + ',';
                }
                BarCodeArr = BarCodeArr.substring(0, BarCodeArr.length-1);
               
                BarCodeArr = BarCodeArr.substring(0, BarCodeArr.length - 1);
                layer.open({
                    type: 2
                    , skin: 'layui-layer-rim' //加上边框
@@ -679,6 +749,8 @@
                layer.msg('至少选择一行数据！');
            }
        }