采购模块自动计算，过滤功能测试修改

wtt

2024-09-02 94daa18047880219aaafba8228d242d8a2a5e5ac

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

@@ -647,7 +647,7 @@
                            obj.update({
                                HPrice: oldText
                            });

                            table.render(option)
                            layer.msg("单价请输入大于0的数字!");
                            return;
                        }
@@ -676,7 +676,7 @@
                        });
                        table.render(option)
                        break;
                    case "HTaxRate":                                                       //数量
                    case "HTaxRate":                                                       //税率
                        //数据格式校验
                        temp = value + "";
                        if (!ref.test(temp)) {
@@ -684,7 +684,7 @@
                            obj.update({
                                HTaxRate: oldText
                            });

                            table.render(option)
                            layer.msg("税率请输入不小于0的数字!");
                            return;
                        }
@@ -724,7 +724,7 @@
                            obj.update({
                                HDiscountRate: oldText
                            });

                            table.render(option)
                            layer.msg("折扣率请输入不小于0的数字!");
                            return;
                        }
@@ -757,7 +757,7 @@
                        });
                        table.render(option);
                        break;       
                    case "HTaxPrice":                                         //单价
                    case "HTaxPrice":                                         //含税单价
                        //数据格式校验  
                        temp = value + "";     //修改后的值 è½¬ä¸ºå­—符串 èµ‹å€¼ç»™  å˜é‡temp
                        // ref很可能是一个正则表达式对象，用于匹配特定的字符串模式。ref.test(temp)会检查变量temp（即转换后的单价字符串）是否符合ref定义的模式。如果test方法返回false
@@ -795,6 +795,46 @@
                        });
                        table.render(option)
                        break;
                    case "HMoney":                                         //金额
                        //数据格式校验  
                        temp = value + "";     //修改后的值 è½¬ä¸ºå­—符串 èµ‹å€¼ç»™  å˜é‡temp
                        // ref很可能是一个正则表达式对象，用于匹配特定的字符串模式。ref.test(temp)会检查变量temp（即转换后的单价字符串）是否符合ref定义的模式。如果test方法返回false
                        if (!ref.test(temp)) { //检查单价字符串是否符合预期的格式                        
                            //恢复数据到编辑前
                            obj.update({            //更新表格某一行数据
                                HMoney: oldText     //将hprice字段恢复到保存前的值
                            });
                            table.render(option);
                            layer.msg("金额请输入数字!");   //请输入单价的数值
                            return;
                        }

                        //数据校验合格，重算记录
                        var HQty = obj.data.HQty * 1;                   //数量
                        var HMoney = value * 1;                     //金额
                        var HTaxRate = obj.data.HTaxRate * 0.01;           //税率 
                        var HPrice = Number((HMoney / HQty));                         //单价 = é‡‘额/(数量)
                        var HTaxPrice = Number(HPrice * (1 + HTaxRate));        //含税单价=单价*(1+税率)
                        
                        
                        var HTaxMoney = Number((HMoney * HTaxRate));         //税额=金额*税率
                        var HDiscountRate = obj.data.HDiscountRate * 1;   //折扣率
                        //数字精度
                        HQty = Number(HQty.toFixed(HQtyDec));
                        HPrice = Number(HPrice.toFixed(HPriceDec));
                        HMoney = Number(HMoney.toFixed(HMoneyDec));
                        HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec));
                        HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
                        //同步更新表格和缓存对应的值
                        obj.update({                    //更新表格数据                æ–¹æ³•æ˜¯è¯¥å¯¹è±¡æä¾›çš„一个方法，用于更新其内部状态或与之关联的数据源
                            HQty: Number(HQty.toFixed(HQtyDec))
                            , HPrice: Number(HPrice.toFixed(HPriceDec))
                            , HMoney: Number(HMoney.toFixed(HMoneyDec))
                            , HTaxMoney: HTaxMoney                  //更新HTaxMoney字段，HTaxMoney
                            , HTaxPrice: Number(HTaxPrice.toFixed(HPriceDec))                    //更新HTaxPrice字段，HTaxPrice
                        });
                        table.render(option)
                        break;
                    default:
                }
            });