销售出库单：子表公式重算、退出监听、子表末尾增加一行失效问题修复

duhe

2023-10-30 2beaf08afd02ef36b4b03e12f2294a5000447f32

销售出库单：子表公式重算、退出监听、子表末尾增加一行失效问题修复

 WebTM/Properties/PublishProfiles/JFTM.pubxml.user

@@ -4794,10 +4794,10 @@
      <publishTime>04/11/2023 16:34:43</publishTime>
    </File>
    <File Include="views/领料发货/销售出库/Kf_SellOutBill.html">
      <publishTime>10/25/2023 19:08:25</publishTime>
      <publishTime>10/30/2023 18:55:43</publishTime>
    </File>
    <File Include="views/领料发货/销售出库/Kf_SellOutBill.html">
      <publishTime>10/25/2023 19:08:25</publishTime>
      <publishTime>10/30/2023 18:55:43</publishTime>
    </File>
    <File Include="views/领料发货/销售出库/Kf_SellOutBillList.html">
      <publishTime>10/24/2023 20:14:55</publishTime>

 WebTM/views/ÁìÁÏ·¢»õ/ÏúÊÛ³ö¿â/Kf_SellOutBill.html

@@ -451,12 +451,6 @@
            //设置组织
            $("#HUSEORGID").val(sessionStorage["OrganizationID"]);

            var rowdata = [{
                "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HWHID": "0", "发货仓库": "", "HQtyMust": "0",
                "HQty": "0", "HQty_Full": "0", "HQty_Empty": "0", "HQty_Back": "0", "HPrice": "0", "HMoney": "0", "HCostPrice": "0", "HCostMoney": "0",
                "HSalePrice": "0", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "", "HRemark": ""
            }];

            DisPlay_HideColumn();

            //初始化组织
@@ -468,7 +462,11 @@
            //#region è¡¨å¤´æ“ä½œæŒ‰é’®
            //#region é€€å‡ºæŒ‰é’®
            form.on('submit(Exit)', function () {
                Pub_Close(1);
                if (params[1] != null) {
                    Pub_Close(1);
                } else if (params[1] == null) {
                    Pub_Close(2);
                }
            })
            //#endregion

@@ -615,12 +613,86 @@
                        }
                    });
                }
                else if (obj.event == 'HQtyMust' || obj.event == 'HQty' || obj.event == 'HQty_Full' || obj.event == 'HQty_Empty' || obj.event == 'HQty_Back' || obj.event == 'HPrice' || obj.event == 'HMoney' || obj.event == 'HCostPrice' || obj.event == 'HCostMoney' || obj.event == 'HSalePrice') {
                    $(obj.tr).find(".layui-table-edit").keyup(function () {
                        var $input = $(this), val = $input.val();
                        if (!val) val = "0";
                        $input.val(parseInt(val.replace(/[^\d*\.?\d*]/g, '')));
                    });
                //else if (obj.event == 'HQtyMust' || obj.event == 'HQty' || obj.event == 'HQty_Full' || obj.event == 'HQty_Empty' || obj.event == 'HQty_Back' || obj.event == 'HPrice' || obj.event == 'HMoney' || obj.event == 'HCostPrice' || obj.event == 'HCostMoney' || obj.event == 'HSalePrice') {
                //    $(obj.tr).find(".layui-table-edit").keyup(function () {
                //        var $input = $(this), val = $input.val();
                //        if (!val) val = "0";
                //        $input.val(parseInt(val.replace(/[^\d*\.?\d*]/g, '')));
                //    });
                //}
            });
            //#endregion

            //#region ç›‘听单元格编辑  å•å…ƒæ ¼ç¼–辑后 å˜æ›´
            table.on('edit(mainTable)', function (obj) {
                //数值格式校验工具
                var ref = /^\d+(\.\d+)?$/;          //非负数正则表达式
                var temp = "";

                // å•å…ƒæ ¼ç¼–辑之前的值
                var oldText = $(this).prev().text();
                var value = obj.value //得到修改后的值
                    , data = obj.data //得到所在行所有键值
                    , field = obj.field; //得到字段
                //layer.msg('[ID: ' + data.id + '] ' + field + ' å­—段更改为：' + value);

                switch (field) {
                    case "HQty":                                                       //实发数量
                        //数据格式校验
                        temp = value + "";
                        if (!ref.test(temp) || temp == 0) {
                            //恢复数据到编辑前
                            obj.update({
                                HQty: oldText
                            });
                            table.render(option);

                            layer.msg("实发数量请输入大于0的数字!");
                            return;
                        }


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

                        //同步更新表格和缓存对应的值
                        obj.update({
                            HQty: HQty
                            , HPrice: HPrice
                            , HMoney: HMoney
                        });
                        table.render(option);
                        break;
                    case "HPrice":                                                       //单价
                        //数据格式校验
                        temp = value + "";
                        if (!ref.test(temp) || temp == 0) {
                            //恢复数据到编辑前
                            obj.update({
                                HPrice: oldText
                            });
                            table.render(option);

                            layer.msg("单价请输入大于0的数字!");
                            return;
                        }

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

                        //同步更新表格和缓存对应的值
                        obj.update({
                            HQty: HQty
                            , HPrice: HPrice
                            , HMoney: HMoney
                        });
                        table.render(option);
                        break;
                    default:
                }
            });
            //#endregion
@@ -920,7 +992,7 @@
                        , { field: '计量单位', title: '计量单位', width: 100, edit: 'text', event: "HUnitID" }//f7
                        , { field: 'HQty', title: '实发数量', width: 100, edit: 'text', event: "HQty" }
                        , { field: 'HPrice', title: '单价', width: 100, edit: 'text', event: "HPrice" }
                        , { field: 'HMoney', title: '金额', width: 100, edit: 'text', event: "HMoney" }
                        , { field: 'HMoney', title: '金额', width: 100 }
                        , { field: 'HWHID', title: 'HWHID', width: 100, edit: 'text', hide: true }
                        , { field: '发货仓库', title: '发货仓库', width: 100, edit: 'text', event: "HWHID" }
                        , { field: 'HRemark', title: '备注', width: 100, edit: 'text' }
@@ -941,6 +1013,12 @@
                    ]]
                }

                var rowdata = [{
                    "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HWHID": "0", "发货仓库": "", "HQtyMust": "0",
                    "HQty": "0", "HQty_Full": "0", "HQty_Empty": "0", "HQty_Back": "0", "HPrice": "0", "HMoney": "0", "HCostPrice": "0", "HCostMoney": "0",
                    "HSalePrice": "0", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "", "HRemark": ""
                }];

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