采购入库单收料通知单,进行选单号,可以多选,保存前反写关联数量的存储过程

zrg

2024-01-16 af9a73e6de3c076e55858704fe2a85167ecacdbc

采购入库单收料通知单,进行选单号,可以多选,保存前反写关联数量的存储过程

 WebTM/views/²É¹º¹ÜÀí/ÊÕÁÏ֪ͨµ¥/Add_Edit_Cg_POInStockBillList.html

@@ -157,8 +157,16 @@
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">选单号</label>
                                            <div class="layui-input-inline">
                                                <input class="layui-input" name="Box2" id="Box2" autocomplete="off">
                                                <input type="text" name="" id="" class="layui-input" value="" style="float:left;width:150px;">
                                                
                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="XDHList" id="XDHList" style="width:40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                            </div>
                                            <!--<label class="layui-form-label">选单号</label>
                                            <div class="layui-input-inline">
                                                <input class="layui-input" name="Box2" id="Box2" autocomplete="off">
                                            </div>-->
                                        </div>

                                    </div>
@@ -356,7 +364,8 @@
            var rowdata = [{
                "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HWHID": 0, "收料仓库": "",
                "HSPID": 0, "收料仓位": "", "HSecUnitID": 0, "辅助单位": "", "HQty": "0", "HRemark": ""
                , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "0", "HTaxRate": "0", "HTaxMoney": "0"
                , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "0", "HTaxRate": "0", "HTaxMoney": "0",
                "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0
            }];

            // åˆå§‹åŒ–ç•Œ
@@ -369,8 +378,9 @@
                //新增行表格数据
                var NewRow = {
                    "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HWHID": 0, "收料仓库": "",
                    "HSPID": 0, "收料仓位": "", "HSecUnitID": data.HSecUnitID, "辅助单位":data.辅助单位, "HQty": "0", "HRemark": ""
                    , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "0", "HTaxRate": "0", "HTaxMoney": "0"
                    "HSPID": 0, "收料仓位": "", "HSecUnitID": data.HSecUnitID, "辅助单位": data.辅助单位, "HQty": "0", "HRemark": ""
                    , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "0", "HTaxRate": "0", "HTaxMoney": "0",
                    "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
                };
                switch (obj.event) {
                    case 'btn-AddLine':
@@ -495,7 +505,7 @@
                            , HPrice: HPrice
                            , HMoney: HMoney
                        });
                       /* table.render(option);*/
                        /* table.render(option);*/
                        break;
                    case "HPrice":                                         //单价
                        //数据格式校验
@@ -505,7 +515,7 @@
                            obj.update({
                                HPrice: oldText
                            });
                           /* table.render(option);*/
                            /* table.render(option);*/

                            layer.msg("单价请输入大于0的数字!");
                            return;
@@ -514,7 +524,7 @@

                        //数据校验合格，重算记录
                        var HQty = obj.data.HQty * 1;                   //数量
                        var HPrice = value * 1;               
                        var HPrice = value * 1;
                        var HMoney = HQty * HPrice;                     //金额=数量*单价


@@ -584,6 +594,10 @@
                    , cols: [[ //子表
                        { type: 'checkbox', totalRowText: '合计行' }
                        , { type: 'numbers', title: '序号', width: 100, totalRow: true }
                        , { type: 'HSourceBillNo', title: '源单号', width: 100, hide: true }//源单号
                        , { field: 'HSourceBillType', title: '源单类型', width: 100, hide: true }//源单类型
                        , { type: 'HSourceInterID', title: '源单主内码', width: 100, hide: true }//源单主内码
                        , { field: 'HSourceEntryID', title: '源单子内码', width: 100, hide: true }//源单子内码
                        , { field: 'HMaterID', title: 'HMaterID', width: 100, hide: true }
                        , { field: '物料代码', title: '物料代码', width: 150, edit: 'text', event: "HMaterID" }//f7
                        , { field: '物料名称', title: '物料名称', width: 150, }
@@ -608,7 +622,7 @@
                    ]]
                }

                option.data = rowdata;
                option.data = [];
                table.render(option);
            }

@@ -666,7 +680,11 @@
                                    {
                                        "HMaterID": data.HMaterID, "物料代码": data.物料代码, "物料名称": data.物料名称, "规格型号": data.规格型号, "HUnitID": data.HUnitID, "计量单位": data.计量单位, "HWHID": data.HWHID, "收料仓库": data.收料仓库,
                                        "HSPID": data.HSPID, "收料仓位": data.仓位名称, "HSecUnitID": data.HSecUnitID, "辅助单位": data.辅助单位, "HQty": data.数量, "HRemark": data.表体备注
                                        , "HPrice": data.单价, "HTaxPrice": data.含税单价, "HMoney": data.金额, "HDiscountRate": data.折扣率, "HTaxRate": data.税率, "HTaxMoney": data.税额
                                        , "HPrice": data.单价, "HTaxPrice": data.含税单价, "HMoney": data.金额, "HDiscountRate": data.折扣率, "HTaxRate": data.税率, "HTaxMoney": data.税额,
                                        "HSourceBillNo": data.源单单号,    //源单号
                                        "HSourceBillType": data.源单类型,   //源单类型
                                        "HSourceInterID": data.源单主内码,   //源单主内码
                                        "HSourceEntryID": data.源单子内码     //源单子内码
                                    }
                                )
                            }
@@ -746,6 +764,24 @@
                        table.cache["mainTable"][i].LAY_TABLE_INDEX = i;
                        num.push(table.cache["mainTable"][i])
                    }
                }

                checkDuplicateData(num);
                const duplicateRows = checkDuplicateData(num);
                if (duplicateRows.length > 0) {
                    let message = '表格中存在重复数据，重复行数为：';

                    for (let i = 0; i < duplicateRows.length; i++) {
                        const { row1, row2 } = duplicateRows[i];
                        message += `第${row1}行与第${row2}行相同`;

                        if (i !== duplicateRows.length - 1) {
                            message += '，';
                        }
                    }

                    message += '，请删除其中一行';
                    layer.alert(message);
                }

                var sMainStr = JSON.stringify(data.field);
@@ -1112,6 +1148,80 @@
                })
            }

            //表头信息选择单据弹窗
            form.on('submit(XDHList)', function () {

                //页面层-自定义
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "采购入库单列表"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["90%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ["../../采购管理/采购订单/Cg_POOrderBillList.html", "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //按钮一  çš„回调
                        var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
                        var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//获取选中的数据

                        if (checkStatus.data.length == 0) {
                            return layer.msg("请至少选择一条数据!");
                        }
                        layer.alert("你已选择" + checkStatus.data.length + "条数据");
                        //获取收料通知单代码
                        var ProcessNumber = [];
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            ProcessNumber.push(checkStatus.data[i]);
                        }

                        //获取当前位置所在行数
                        var NowNum = 0;
                        NowNum = option.data.length;

                        var j = 0;
                        for (var i = 0; i < ProcessNumber.length; i++) {
                            option.data.push({
                                "HMaterID": checkStatus.data[j].HMaterID, "物料代码": checkStatus.data[j].物料代码, "物料名称": checkStatus.data[j].物料名称, "规格型号": checkStatus.data[j].规格型号,
                                "HUnitID": checkStatus.data[j].HUnitID, "计量单位": checkStatus.data[j].计量单位, 
                                "HQty": checkStatus.data[j].数量, "HPrice": checkStatus.data[j].单价,
                                "HMoney": checkStatus.data[j].金额, "HTaxPrice": checkStatus.data[j].含税单价,  "HTaxRate": checkStatus.data[j].税率, "HTaxMoney": checkStatus.data[j].税额,
                                "HSourceBillNo": checkStatus.data[j].单据号, "HSourceBillType": checkStatus.data[j].HBillType, "HSourceInterID": checkStatus.data[j].hmainid, "HSourceEntryID": checkStatus.data[j].hsubid,
                            })
                            j++;
                        }
                        table.render(option);
                        layer.close(index);//关闭弹窗
                    }

                });
            });

             //判断所选着与表格是否有重复数据
            function checkDuplicateData(data) {
                const duplicates = [];

                for (let i = 0; i < data.length; i++) {
                    const currentItem = data[i];
                    let isDuplicate = false;

                    for (let j = i + 1; j < data.length; j++) {
                        const compareItem = data[j];
                        //主子id
                        if (currentItem.HSourceInterID === compareItem.HSourceInterID && currentItem.HSourceEntryID === compareItem.HSourceEntryID) {
                            isDuplicate = true;
                            duplicates.push({ row1: i + 1, row2: j + 1 }); // è®°å½•é‡å¤æ•°æ®æ‰€åœ¨è¡Œæ•°
                        }
                    }
                    if (isDuplicate && !duplicates.some(item => item.row1 === i + 1)) {
                        duplicates.push({ row1: i + 1, row2: -1 }); // è®°å½•é‡å¤æ•°æ®æ‰€åœ¨è¡Œæ•°ï¼Œ-1 è¡¨ç¤ºæœªæ‰¾åˆ°ä¸Žå½“前行重复的行
                    }
                }
                return duplicates;
            }


            //#region æ ¹æ®ç‰©æ–™ID获取物料详细信息
            function getMaterialByMaterID(HMaterID) {

 WebTM/views/²É¹º¹ÜÀí/ÊÕÁÏ֪ͨµ¥/Cg_POInStockBillList.html

@@ -213,7 +213,7 @@
                //直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
                get_FastQuery(1)
                //查询
                get_Display(sWhere);
               //get_Display(sWhere);
                //隐藏勾选字段
                DisPlay_HideColumn();

@@ -385,13 +385,17 @@
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        if (checkStatus.data.length === 1) {
                            var InterID = data[0].hmainid.toString();
                            var HInterID = data[0].hmainid.toString();
                            var HsupId = data[0].hsubid;
                            var HQty = data[0].数量;
                            var HSourceInterID = data[0].源单主内码;
                            var HSourceEntryID = data[0].源单子内码;
                            //逻辑删除方法
                            layer.confirm("确认要删除吗，删除后不能恢复", { title: "删除确认" }, function (index) {
                                $.ajax({
                                    type: "GET",
                                    url: GetWEBURL() + "Cg_POInStockBill/DeltetPOInStockBill", //方法所在页面和方法名
                                    data: { "HInterID": InterID, "user": sessionStorage["HUserName"] },
                                    data: { "HInterID": HInterID, "HsupId": HsupId, "HQty": HQty, "HSourceInterID": HSourceInterID, "HSourceEntryID": HSourceEntryID, "user": sessionStorage["HUserName"] },
                                    success: function (result) {
                                        if (result.count == 1) {
                                            layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
@@ -654,6 +658,7 @@
                if (HMangerID) {
                    sWhere += " and ä¸»ç®¡ like '%" + HMangerID + "%'";
                }
                sWhere += " and å…³é—­äºº =''";
                get_Display(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            }

 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/Add_Edit_Kf_POStockInBillList.html

@@ -162,8 +162,16 @@
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">选单号</label>
                                            <div class="layui-input-inline">
                                                <input class="layui-input" name="Box2" id="Box2" autocomplete="off">
                                                <input type="text" name="" id="" class="layui-input" value="" style="float:left;width:150px;">
                                                
                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="XDHList" id="XDHList" style="width:40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                            </div>
                                            <!--<label class="layui-form-label">选单号</label>
                                            <div class="layui-input-inline">
                                                <input class="layui-input" name="Box2" id="Box2" autocomplete="off">
                                            </div>-->
                                        </div>
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">负责人</label>
@@ -249,7 +257,7 @@
                                                <input type="text" class="layui-input" name="HCheckDate" id="HCheckDate" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                        <div class="layui-inline" >
                                            <label class="layui-form-label" style="width: 85px;">关闭日期</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HCloseDate" id="HCloseDate" style="background-color:#efefef4d;" readonly>
@@ -394,7 +402,8 @@
                "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HAuxPropID": 0, "物料辅助属性": "", "HUnitID": 0, "计量单位": "", "HQtyMust": "", "HQty": "", "HRemark": "",
                "HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "收料仓库": "",
                "HSPID": 0, "仓位名称": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
                "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": ""
                "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
                "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0, 
            }];
            // åˆå§‹åŒ–ç•Œ
            set_InitGrid();
@@ -408,7 +417,8 @@
                    "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HAuxPropID": 0, "物料辅助属性": "", "HUnitID": 0, "计量单位": "", "HQtyMust": "", "HQty": "", "HRemark": "",
                    "HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "收料仓库": "",
                    "HSPID": 0, "仓位名称": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
                    "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": ""
                    "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
                    "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
                };
                switch (obj.event) {
                    case 'btn-AddLine':
@@ -670,7 +680,7 @@
            }



            //子表

            function set_InitGrid() {
                option = {
@@ -682,6 +692,10 @@
                    , cols: [[ //子表
                        { type: 'checkbox', totalRowText: '合计行' }
                        , { type: 'numbers', title: '序号', width: 100, totalRow: true }
                        , { type: 'HSourceBillNo', title: '源单号', width: 100, hide: true }//源单号
                        , { field: 'HSourceBillType', title: '源单类型', width: 100, hide: true }//源单类型
                        , { type: 'HSourceInterID', title: '源单主内码', width: 100, hide: true }//源单主内码
                        , { field: 'HSourceEntryID', title: '源单子内码', width: 100, hide: true }//源单子内码
                        , { field: 'HMaterID', title: 'HMaterID', width: 100, hide: true }
                        , { field: '物料代码', title: '物料代码', width: 150, edit: 'text', event: "HMaterID" }//f7
                        , { field: '物料名称', title: '物料名称', width: 150, }
@@ -705,7 +719,7 @@
                    ]]
                }

                option.data = rowdata;
                option.data = [];
                table.render(option);
            }

@@ -743,7 +757,7 @@
                                , "HManagerID": data.HManagerID
                                , "HManagerName": data.负责人
                                , "HExRate": data.汇率
                                , "Box2": ""
                                //, "Box2": ""
                                , "HRemark": data.表头备注
                                , "HMaker": data.制单人
                                , "HChecker": data.审核人
@@ -763,7 +777,11 @@
                                    {
                                        "HMaterID": subdata[i].HMaterID, "物料代码": subdata[i].物料代码, "物料名称": subdata[i].物料名称, "规格型号": subdata[i].规格型号, "HAuxPropID": subdata[i].HAuxPropID, "物料辅助属性": subdata[i].物料辅助属性, "HUnitID": subdata[i].HUnitID, "计量单位": subdata[i].计量单位,
                                        "HQtyMust": subdata[i].应收数量, "HQty": subdata[i].实收数量, "HRemark": subdata[i].表体备注, "HPrice": subdata[i].单价, "HMoney": subdata[i].金额, "HOrderPrice": subdata[i].采购金额, "HWHID": subdata[i].HWHID, "收料仓库": subdata[i].收料仓库, "HSPID": subdata[i].HSPID, "仓位名称": subdata[i].仓位名称,
                                        "HBatchNo": subdata[i].批次
                                        "HBatchNo": subdata[i].批次,
                                        "HSourceBillNo": subdata[i].源单单号,    //源单号
                                        "HSourceBillType": subdata[i].源单类型,   //源单类型
                                        "HSourceInterID": subdata[i].源单主内码,   //源单主内码
                                        "HSourceEntryID": subdata[i].源单子内码     //源单子内码
                                    }
                                )
                            }
@@ -826,6 +844,7 @@
                    return;
                }


                var num = [];
                for (var i = 0; i < table.cache["mainTable"].length; i++) {
                    if (table.cache["mainTable"][i] != "") {
@@ -833,6 +852,25 @@
                        num.push(table.cache["mainTable"][i])
                    }
                }

                checkDuplicateData(num);
                const duplicateRows = checkDuplicateData(num);
                if (duplicateRows.length > 0) {
                    let message = '表格中存在重复数据，重复行数为：';

                    for (let i = 0; i < duplicateRows.length; i++) {
                        const { row1, row2 } = duplicateRows[i];
                        message += `第${row1}行与第${row2}行相同`;

                        if (i !== duplicateRows.length - 1) {
                            message += '，';
                        }
                    }

                    message += '，请删除其中一行';
                    layer.alert(message);
                } 
                

                var sMainStr = JSON.stringify(data.field);
                var sSubStr = JSON.stringify(num);
@@ -1059,7 +1097,8 @@
                                                "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HAuxPropID": 0, "物料辅助属性": "", "HUnitID": 0, "计量单位": "", "HQtyMust": "", "HQty": "", "HRemark": "",
                                                "HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "收料仓库": "",
                                                "HSPID": 0, "仓位名称": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
                                                "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": ""
                                                "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
                                                "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
                                            };

                                            table.cache["mainTable"].push(NewRow);
@@ -1191,8 +1230,87 @@
                    }
                })
            }
                 

            //行内事件
            table.on('tool(mainTable)', function (obj) {
                set_GridDelete(obj);   //行内删除
                set_GridCellCheck(obj); //行内快捷键筛选

            });
            //表头信息选择单据弹窗
            form.on('submit(XDHList)', function () {

                //页面层-自定义
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "收料通知单列表"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["90%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ["../../采购管理/收料通知单/Cg_POInStockBillList.html", "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //按钮一  çš„回调
                        var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
                        var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//获取选中的数据

                        if (checkStatus.data.length == 0) {
                            return layer.msg("请至少选择一条数据!");
                        }
                        layer.alert("你已选择" + checkStatus.data.length + "条数据");
                        //获取收料通知单代码
                        var ProcessNumber = [];
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            ProcessNumber.push(checkStatus.data[i]);
                        }

                        //获取当前位置所在行数
                        var NowNum = 0;
                        NowNum = option.data.length;

                        
                        var j = 0;
                        for (var i = 0; i < ProcessNumber.length; i++) {
                            option.data.push({
                                "HMaterID": checkStatus.data[j].HMaterID, "物料代码": checkStatus.data[j].物料代码, "物料名称": checkStatus.data[j].物料名称, "规格型号": checkStatus.data[j].规格型号,
                                "HAuxPropID": 0, "物料辅助属性": "", "HUnitID": checkStatus.data[j].HUnitID, "计量单位": checkStatus.data[j].计量单位, "HQtyMust": "", "HQty": checkStatus.data[j].数量, "HRemark": "",
                                "HPrice": checkStatus.data[j].单价, "HMoney": checkStatus.data[j].金额, "HOrderPrice": "0", "HWHID": checkStatus.data[j].HWHID, "收料仓库": checkStatus.data[j].收料仓库,
                                "HSPID": checkStatus.data[j].HSPID, "仓位名称": checkStatus.data[j].仓位名称, "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
                                "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
                                "HSourceBillNo": checkStatus.data[j].单据号, "HSourceBillType": checkStatus.data[j].HBillType, "HSourceInterID": checkStatus.data[j].hmainid, "HSourceEntryID": checkStatus.data[j].hsubid,
                            })
                            j++;
                        }
                        table.render(option);
                        layer.close(index);//关闭弹窗
                    }
                       
                });
            });
            //判断所选着与表格是否有重复数据
            function checkDuplicateData(data) {
                const duplicates = [];

                for (let i = 0; i < data.length; i++) {
                    const currentItem = data[i];
                    let isDuplicate = false;

                    for (let j = i + 1; j < data.length; j++) {
                        const compareItem = data[j];

                        if (currentItem.HSourceInterID === compareItem.HSourceInterID && currentItem.HSourceEntryID === compareItem.HSourceEntryID) {
                            isDuplicate = true;
                            duplicates.push({ row1: i + 1, row2: j + 1 }); // è®°å½•é‡å¤æ•°æ®æ‰€åœ¨è¡Œæ•°
                        }
                    }
                    if (isDuplicate && !duplicates.some(item => item.row1 === i + 1)) {
                        duplicates.push({ row1: i + 1, row2: -1 }); // è®°å½•é‡å¤æ•°æ®æ‰€åœ¨è¡Œæ•°ï¼Œ-1 è¡¨ç¤ºæœªæ‰¾åˆ°ä¸Žå½“前行重复的行
                    }
                }
                return duplicates;
            }
            //行内删除
            function set_GridDelete(obj) {
                var data = obj.data;

 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/Kf_POStockInBackBillList.html

@@ -559,7 +559,7 @@
                    layer.msg('请选择一行数据审核！');
                }
            }
            //#endregion
            //#endregionz

            //#region æ¡ç æ˜Žç»†
            function get_BarCodeDetail() {

 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/Kf_POStockInBillList.html

@@ -490,6 +490,7 @@
                //if (HOrgID) {
                //    sWhere += " and HUSEORGID = '" + HOrgID + "'";
                //}
                sWhere += " and å…³é—­äºº =''";
                get_Display(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            }
@@ -518,20 +519,23 @@
                get_Display(sWhere);
            }
            //#endregion

            //删除
            function set_DeleteBill() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var InterID = data[0].hmainid.toString();
                    var Hmainid = data[0].hmainid.toString();
                    var HsupId = data[0].hsubid;
                    var HQty = data[0].实收数量;
                    var HSourceInterID = data[0].源单主内码;
                    var HSourceEntryID = data[0].源单子内码;
                    //逻辑删除方法
                    layer.confirm("确认要删除吗，删除后不能恢复", { title: "删除确认" }, function (index) {
                        var wait = layer.load();
                        $.ajax({
                            type: "GET",
                            url: GetWEBURL() + "/Kf_POStockInBill/DeltetKf_POStockInBill", //方法所在页面和方法名
                            data: { "HInterID": InterID },
                            data: { "Hmainid": Hmainid, "HsupId": HsupId, "HQty": HQty, "HSourceInterID": HSourceInterID, "HSourceEntryID": HSourceEntryID, "user": sessionStorage["HUserName"] },
                            success: function (result) {
                                if (result.count == 1) {
                                    layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {