From 50973d7c3023227bee0aed5fce017e6e38483f5f Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期五, 21 七月 2023 15:48:42 +0800
Subject: [PATCH] 入职申请、工资结算单(个人)、工资结算单(集体):文本框监听,实现数据关联

---
 WebTM/views/工资管理/工资结算单(集体)/Pay_GroupBalBillEdit.html  |   47 +++++++
 WebTM/views/工资管理/工资结算单(个人)/Pay_SingleBalBillEdit.html |  225 ++++++++++++++++++++++++++++++++++++-
 WebTM/Properties/PublishProfiles/JFTM.pubxml.user     |    6 
 WebTM/views/人事管理/入职申请/HR_EmpEngageRequestBill.html    |   23 +++
 4 files changed, 289 insertions(+), 12 deletions(-)

diff --git a/WebTM/Properties/PublishProfiles/JFTM.pubxml.user b/WebTM/Properties/PublishProfiles/JFTM.pubxml.user
index 35f1784..9a30010 100644
--- a/WebTM/Properties/PublishProfiles/JFTM.pubxml.user
+++ b/WebTM/Properties/PublishProfiles/JFTM.pubxml.user
@@ -1728,7 +1728,7 @@
       <publishTime>04/11/2023 16:34:43</publishTime>
     </File>
     <File Include="views/浜轰簨绠$悊/鍏ヨ亴鐢宠/HR_EmpEngageRequestBill.html">
-      <publishTime>07/21/2023 11:01:52</publishTime>
+      <publishTime>07/21/2023 15:40:30</publishTime>
     </File>
     <File Include="views/浜轰簨绠$悊/鍏ヨ亴鐢宠/HR_EmpEngageRequestBillList.html">
       <publishTime>07/21/2023 08:25:45</publishTime>
@@ -2685,7 +2685,7 @@
       <publishTime>10/19/2021 09:27:19</publishTime>
     </File>
     <File Include="views/宸ヨ祫绠$悊/宸ヨ祫缁撶畻鍗�%28涓汉%29/Pay_SingleBalBillEdit.html">
-      <publishTime>07/19/2023 22:05:52</publishTime>
+      <publishTime>07/21/2023 14:49:14</publishTime>
     </File>
     <File Include="views/宸ヨ祫绠$悊/宸ヨ祫缁撶畻鍗�%28涓汉%29/Pay_SingleBalBillEdit1.html">
       <publishTime>07/18/2023 10:57:22</publishTime>
@@ -2718,7 +2718,7 @@
       <publishTime>10/19/2021 09:27:19</publishTime>
     </File>
     <File Include="views/宸ヨ祫绠$悊/宸ヨ祫缁撶畻鍗�%28闆嗕綋%29/Pay_GroupBalBillEdit.html">
-      <publishTime>07/20/2023 18:48:24</publishTime>
+      <publishTime>07/21/2023 15:04:29</publishTime>
     </File>
     <File Include="views/宸ヨ祫绠$悊/宸ヨ祫缁撶畻鍗�%28闆嗕綋%29/Pay_GroupBalBillEdit1.html">
       <publishTime>04/11/2023 16:34:43</publishTime>
diff --git "a/WebTM/views/\344\272\272\344\272\213\347\256\241\347\220\206/\345\205\245\350\201\214\347\224\263\350\257\267/HR_EmpEngageRequestBill.html" "b/WebTM/views/\344\272\272\344\272\213\347\256\241\347\220\206/\345\205\245\350\201\214\347\224\263\350\257\267/HR_EmpEngageRequestBill.html"
index bc2bbd6..31b8f8c 100644
--- "a/WebTM/views/\344\272\272\344\272\213\347\256\241\347\220\206/\345\205\245\350\201\214\347\224\263\350\257\267/HR_EmpEngageRequestBill.html"
+++ "b/WebTM/views/\344\272\272\344\272\213\347\256\241\347\220\206/\345\205\245\350\201\214\347\224\263\350\257\267/HR_EmpEngageRequestBill.html"
@@ -580,6 +580,29 @@
             //#endregion
             //#endregion
 
+            //#region 鏂囨湰妗嗙洃鍚�
+            $(document).ready(function () {
+                //#region 鍒濆鏃ユ湡鏂囨湰妗嗙洃鍚�
+                $("#HBirthday").on('input proprytychange', function (data) {
+                    if (data.currentTarget.value == "") {
+                        $("#HAge").val("");
+                    } else {
+                        var HBirthDay = data.currentTarget.value;                       //鍑虹敓鏃ユ湡
+                        var HToday = Format(new Date(), "yyyy-MM-dd");                  //褰撳ぉ鏃ユ湡
+                        var year = HToday.split("-")[0] - HBirthDay.split("-")[0];      
+                        var month = HToday.split("-")[1] - HBirthDay.split("-")[1];
+                        var day = HToday.split("-")[2] - HBirthDay.split("-")[2];
+                        if (month > 0 || (month == 0 && day >= 0)) {
+                            $("#HAge").val(year);
+                        } else {
+                            $("#HAge").val(year-1);
+                        }
+                    }
+                });
+                //#endregion
+            });
+            //#endregion 
+
             //#region 鎿嶄綔鎸夐挳瑙﹀彂浜嬩欢
             //#region 淇濆瓨鎻愪氦
             form.on('submit(btnSave)', function (data) {//鎻愪氦
diff --git "a/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\345\267\245\350\265\204\347\273\223\347\256\227\345\215\225\050\344\270\252\344\272\272\051/Pay_SingleBalBillEdit.html" "b/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\345\267\245\350\265\204\347\273\223\347\256\227\345\215\225\050\344\270\252\344\272\272\051/Pay_SingleBalBillEdit.html"
index 0478053..44d8fc7 100644
--- "a/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\345\267\245\350\265\204\347\273\223\347\256\227\345\215\225\050\344\270\252\344\272\272\051/Pay_SingleBalBillEdit.html"
+++ "b/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\345\267\245\350\265\204\347\273\223\347\256\227\345\215\225\050\344\270\252\344\272\272\051/Pay_SingleBalBillEdit.html"
@@ -560,7 +560,216 @@
             })
             //#endregion
 
+            //#region 瀛愯〃锛氬崟鍏冩牸缂栬緫鐩戝惉
+            table.on('edit(mainTable)', function (obj) {
+                // 鍗曞厓鏍肩紪杈戜箣鍓嶇殑鍊�
+                var oldText = $(this).prev().text();
+                var value = obj.value //寰楀埌淇敼鍚庣殑鍊�
+                    , data = obj.data //寰楀埌鎵�鍦ㄨ鎵�鏈夐敭鍊�
+                    , field = obj.field; //寰楀埌瀛楁
+                //姝e垯琛ㄨ揪寮�-鏍¢獙闈炶礋娴偣鏁�
+                var ref = /^\d+(\.\d+)?$/;
 
+                switch (field) {
+                    case "HQty":                                            //鏁伴噺
+                        if (!ref.test(value)) {                             //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HQty: oldText
+                            });
+                            layer.msg("鏁伴噺锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = value;                               //鏁伴噺
+                            var HPrice = data.HPrice;                       //宸ヤ环
+                            var HPriceRate = data.HPriceRate;               //瀹氶娴姩姣旂巼
+
+                            var HSubsidyQty = data.HSubsidyQty;             //琛ヨ创鏁伴噺
+
+                            var HPackQty = data.HPackQty;                   //鍖呰鏁伴噺
+                            var HPackPrice = data.HPackPrice;               //鍖呰鍗曚环
+
+                            var HDeuctTotal = data.HDeuctTotal * 1;               //鎵f灏忚
+                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //琛ヨ创鍚堣
+
+                            obj.update({
+                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //閲戦= (鏁伴噺*鍗曚环*瀹氶娴姩姣旂巼) + (琛ヨ创鏁伴噺*宸ヤ环) + (鍖呰鏁伴噺*鍖呰鍗曚环) - 琛ヨ创鍚堣 - 鎵f灏忚
+                            });
+                        }
+                        break;
+                    case "HPrice":                                          //宸ヤ环
+                        if (!ref.test(value)) {                             //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HPrice: oldText
+                            });
+                            layer.msg("宸ヤ环锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = data.HQty;                           //鏁伴噺
+                            var HPrice = value;                             //宸ヤ环
+                            var HPriceRate = data.HPriceRate;               //瀹氶娴姩姣旂巼
+
+                            var HSubsidyQty = data.HSubsidyQty;             //琛ヨ创鏁伴噺
+
+                            var HPackQty = data.HPackQty;                   //鍖呰鏁伴噺
+                            var HPackPrice = data.HPackPrice;               //鍖呰鍗曚环
+
+                            var HDeuctTotal = data.HDeuctTotal * 1;               //鎵f灏忚
+                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //琛ヨ创鍚堣
+
+                            obj.update({
+                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //閲戦= (鏁伴噺*鍗曚环*瀹氶娴姩姣旂巼) + (琛ヨ创鏁伴噺*宸ヤ环) + (鍖呰鏁伴噺*鍖呰鍗曚环) - 琛ヨ创鍚堣 - 鎵f灏忚
+                            });
+                        }
+                        break;
+                    case "HPriceRate":                                      //瀹氶娴姩姣旂巼
+                        if (!ref.test(value)) {                             //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HPriceRate: oldText
+                            });
+                            layer.msg("瀹氶娴姩姣旂巼锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = data.HQty;                           //鏁伴噺
+                            var HPrice = data.HPrice;                       //宸ヤ环
+                            var HPriceRate = value;                         //瀹氶娴姩姣旂巼
+
+                            var HSubsidyQty = data.HSubsidyQty;             //琛ヨ创鏁伴噺
+
+                            var HPackQty = data.HPackQty;                   //鍖呰鏁伴噺
+                            var HPackPrice = data.HPackPrice;               //鍖呰鍗曚环
+
+                            var HDeuctTotal = data.HDeuctTotal * 1;               //鎵f灏忚
+                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //琛ヨ创鍚堣
+
+                            obj.update({
+                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //閲戦= (鏁伴噺*鍗曚环*瀹氶娴姩姣旂巼) + (琛ヨ创鏁伴噺*宸ヤ环) + (鍖呰鏁伴噺*鍖呰鍗曚环) - 琛ヨ创鍚堣 - 鎵f灏忚
+                            });
+                        }
+                        break;
+                    case "HSubsidyQty":                                     //琛ヨ创鏁伴噺
+                        if (!ref.test(value)) {                             //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HSubsidyQty: oldText
+                            });
+                            layer.msg("琛ヨ创鏁伴噺锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = data.HQty;                           //鏁伴噺
+                            var HPrice = data.HPrice;                       //宸ヤ环
+                            var HPriceRate = data.HPriceRate;               //瀹氶娴姩姣旂巼
+
+                            var HSubsidyQty = value;                        //琛ヨ创鏁伴噺
+
+                            var HPackQty = data.HPackQty;                   //鍖呰鏁伴噺
+                            var HPackPrice = data.HPackPrice;               //鍖呰鍗曚环
+
+                            var HDeuctTotal = data.HDeuctTotal * 1;               //鎵f灏忚
+                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //琛ヨ创鍚堣
+
+                            obj.update({
+                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //閲戦= (鏁伴噺*鍗曚环*瀹氶娴姩姣旂巼) + (琛ヨ创鏁伴噺*宸ヤ环) + (鍖呰鏁伴噺*鍖呰鍗曚环) - 琛ヨ创鍚堣 - 鎵f灏忚
+                                , HSubsidyMoney: HSubsidyQty * HPrice                                                                                       //琛ヨ创閲戦=琛ヨ创鏁伴噺*宸ヤ环
+                            });
+                        }
+                        break;
+                    case "HSubsidyTotal":                                       //琛ヨ创鍚堣
+                        if (!ref.test(value)) {                                 //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HSubsidyTotal: oldText
+                            });
+                            layer.msg("琛ヨ创鍚堣锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = data.HQty;                           //鏁伴噺
+                            var HPrice = data.HPrice;                       //宸ヤ环
+                            var HPriceRate = data.HPriceRate;               //瀹氶娴姩姣旂巼
+
+                            var HSubsidyQty = data.HSubsidyQty;              //琛ヨ创鏁伴噺
+
+                            var HPackQty = data.HPackQty;                   //鍖呰鏁伴噺
+                            var HPackPrice = data.HPackPrice;               //鍖呰鍗曚环
+
+                            var HDeuctTotal = data.HDeuctTotal * 1;         //鎵f灏忚
+                            var HSubsidyTotal = value * 1;                  //琛ヨ创鍚堣
+
+                            obj.update({
+                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //閲戦= (鏁伴噺*鍗曚环*瀹氶娴姩姣旂巼) + (琛ヨ创鏁伴噺*宸ヤ环) + (鍖呰鏁伴噺*鍖呰鍗曚环) - 琛ヨ创鍚堣 - 鎵f灏忚
+                            });
+                        }
+                        break;
+                    case "HDeuctTotal":                                         //鎵f灏忚
+                        if (!ref.test(value)) {                                 //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HDeuctTotal: oldText
+                            });
+                            layer.msg("鎵f灏忚锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = data.HQty;                           //鏁伴噺
+                            var HPrice = data.HPrice;                       //宸ヤ环
+                            var HPriceRate = data.HPriceRate;               //瀹氶娴姩姣旂巼
+
+                            var HSubsidyQty = data.HSubsidyQty;              //琛ヨ创鏁伴噺
+
+                            var HPackQty = data.HPackQty;                   //鍖呰鏁伴噺
+                            var HPackPrice = data.HPackPrice;               //鍖呰鍗曚环
+
+                            var HDeuctTotal = value * 1;                    //鎵f灏忚
+                            var HSubsidyTotal = data.HSubsidyTotal * 1;      //琛ヨ创鍚堣
+
+                            obj.update({
+                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //閲戦= (鏁伴噺*鍗曚环*瀹氶娴姩姣旂巼) + (琛ヨ创鏁伴噺*宸ヤ环) + (鍖呰鏁伴噺*鍖呰鍗曚环) - 琛ヨ创鍚堣 - 鎵f灏忚
+                            });
+                        }
+                        break;
+                    case "HPackQty":                                        //鍖呰鏁伴噺
+                        if (!ref.test(value)) {                             //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HPackQty: oldText
+                            });
+                            layer.msg("鍖呰鏁伴噺锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = data.HQty;                           //鏁伴噺
+                            var HPrice = data.HPrice;                       //宸ヤ环
+                            var HPriceRate = data.HPriceRate;               //瀹氶娴姩姣旂巼
+
+                            var HSubsidyQty = data.HSubsidyQty;              //琛ヨ创鏁伴噺
+
+                            var HPackQty = value;                          //鍖呰鏁伴噺
+                            var HPackPrice = data.HPackPrice;               //鍖呰鍗曚环
+
+                            var HDeuctTotal = data.HDeuctTotal * 1;               //鎵f灏忚
+                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //琛ヨ创鍚堣
+
+                            obj.update({
+                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //閲戦= (鏁伴噺*鍗曚环*瀹氶娴姩姣旂巼) + (琛ヨ创鏁伴噺*宸ヤ环) + (鍖呰鏁伴噺*鍖呰鍗曚环) - 琛ヨ创鍚堣 - 鎵f灏忚
+                                , HPackMoney: HPackQty * HPackPrice                                                                                         //鍖呰閲戦= 鍖呰鏁伴噺*鍖呰鍗曚环
+                            });
+                        }
+                        break;
+                    case "HPackPrice":                                          //鍖呰鍗曚环
+                        if (!ref.test(value)) {                                 //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HPackPrice: oldText
+                            });
+                            layer.msg("鍖呰鍗曚环锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = data.HQty;                               //鏁伴噺
+                            var HPrice = data.HPrice;                           //宸ヤ环
+                            var HPriceRate = data.HPriceRate;                   //瀹氶娴姩姣旂巼
+
+                            var HSubsidyQty = data.HSubsidyQty;                 //琛ヨ创鏁伴噺
+
+                            var HPackQty = data.HPackQty;                       //鍖呰鏁伴噺
+                            var HPackPrice = value;                             //鍖呰鍗曚环
+
+                            var HDeuctTotal = data.HDeuctTotal*1;               //鎵f灏忚
+                            var HSubsidyTotal = data.HSubsidyTotal*1;           //琛ヨ创鍚堣
+
+                            obj.update({
+                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //閲戦= (鏁伴噺*鍗曚环*瀹氶娴姩姣旂巼) + (琛ヨ创鏁伴噺*宸ヤ环) + (鍖呰鏁伴噺*鍖呰鍗曚环) - 琛ヨ创鍚堣 - 鎵f灏忚
+                                , HPackMoney: HPackQty * HPackPrice                                                                                         //鍖呰閲戦= 鍖呰鏁伴噺*鍖呰鍗曚环
+                            });
+                        }
+                        break;
+                    default:
+                }
+            });
+            //#endregion
 
             //
             form.on('submit(Cancel)', function () {
@@ -644,15 +853,15 @@
                         , { field: 'HEmpNumber', title: '鑱屽憳浠g爜', edit: 'text', event: "HEmpNumber" }     //f7
                         , { field: 'HEmpName', title: '鑱屽憳鍚嶇О' }
                         , { field: 'HTimes', title: '宸ユ椂', edit: 'text'}
-                        , { field: 'HQty', title: '鏁伴噺', edit: 'text', event: "HQty" }
-                        , { field: 'HPrice', title: '宸ヤ环', edit: 'text', event: "HPrice" }
-                        , { field: 'HPriceRate', title: '瀹氶娴姩姣旂巼', edit: 'text', event: "HPriceRate" }
-                        , { field: 'HSubsidyQty', title: '琛ヨ创鏁伴噺', edit: 'text', event: "HSubsidyQty" }
+                        , { field: 'HQty', title: '鏁伴噺', edit: 'text' }
+                        , { field: 'HPrice', title: '宸ヤ环', edit: 'text'}
+                        , { field: 'HPriceRate', title: '瀹氶娴姩姣旂巼', edit: 'text' }
+                        , { field: 'HSubsidyQty', title: '琛ヨ创鏁伴噺', edit: 'text' }
                         , { field: 'HSubsidyMoney', title: '琛ヨ创閲戦'}
-                        , { field: 'HSubsidyTotal', title: '琛ヨ创鍚堣', edit: 'text', event: "HSubsidyTotal" }
-                        , { field: 'HDeuctTotal', title: '鎵f灏忚', edit: 'text', event: "HDeuctTotal" }
-                        , { field: 'HPackQty', title: '鍖呰鏁伴噺', edit: 'text', event: "HPackQty" }
-                        , { field: 'HPackPrice', title: '鍖呰鍗曚环', edit: 'text', event: "HPackPrice" }
+                        , { field: 'HSubsidyTotal', title: '琛ヨ创鍚堣', edit: 'text' }
+                        , { field: 'HDeuctTotal', title: '鎵f灏忚', edit: 'text' }
+                        , { field: 'HPackQty', title: '鍖呰鏁伴噺', edit: 'text' }
+                        , { field: 'HPackPrice', title: '鍖呰鍗曚环', edit: 'text' }
                         , { field: 'HPackMoney', title: '鍖呰閲戦'}
                         , { field: 'HPackMaterID', title: '鍖呰绫诲瀷ID', hide: true }
                         //, { field: 'HPackMaterNumber', title: '鍖呰绫诲瀷浠g爜' }     //f7
diff --git "a/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\345\267\245\350\265\204\347\273\223\347\256\227\345\215\225\050\351\233\206\344\275\223\051/Pay_GroupBalBillEdit.html" "b/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\345\267\245\350\265\204\347\273\223\347\256\227\345\215\225\050\351\233\206\344\275\223\051/Pay_GroupBalBillEdit.html"
index 359128c..6be380a 100644
--- "a/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\345\267\245\350\265\204\347\273\223\347\256\227\345\215\225\050\351\233\206\344\275\223\051/Pay_GroupBalBillEdit.html"
+++ "b/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\345\267\245\350\265\204\347\273\223\347\256\227\345\215\225\050\351\233\206\344\275\223\051/Pay_GroupBalBillEdit.html"
@@ -674,6 +674,51 @@
             });
             //#endregion
 
+            //#region 瀛愯〃1锛氬崟鍏冩牸缂栬緫鐩戝惉
+            table.on('edit(mainTable)', function (obj) {
+                // 鍗曞厓鏍肩紪杈戜箣鍓嶇殑鍊�
+                var oldText = $(this).prev().text();
+                var value = obj.value //寰楀埌淇敼鍚庣殑鍊�
+                    , data = obj.data //寰楀埌鎵�鍦ㄨ鎵�鏈夐敭鍊�
+                    , field = obj.field; //寰楀埌瀛楁
+                //姝e垯琛ㄨ揪寮�-鏍¢獙闈炶礋娴偣鏁�
+                var ref = /^\d+(\.\d+)?$/;
+
+                switch (field) {
+                    case "HQty":                                            //鏁伴噺
+                        if (!ref.test(value)) {                             //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HQty: oldText
+                            });
+                            layer.msg("鏁伴噺锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = value;                               //鏁伴噺
+                            var HPrice = data.HPrice;                       //宸ヤ环
+                           
+                            obj.update({
+                                HMoney: HQty * HPrice                       //閲戦= 鏁伴噺*宸ヤ环
+                            });
+                        }
+                        break;
+                    case "HPrice":                                          //宸ヤ环
+                        if (!ref.test(value)) {                             //鑻ヨ緭鍏ュ�兼牸寮忎笉姝g‘锛屽垯鍙樺洖鍘熸潵鐨勫��
+                            obj.update({
+                                HPrice: oldText
+                            });
+                            layer.msg("宸ヤ环锛氭暟鎹敊璇紝璇疯緭鍏ラ潪璐熷皬鏁�")
+                        } else {
+                            var HQty = data.HQty;                           //鏁伴噺
+                            var HPrice = value;                             //宸ヤ环
+                           
+                            obj.update({
+                                HMoney: HQty * HPrice                       //閲戦= 鏁伴噺*宸ヤ环
+                            });
+                        }
+                        break;
+                    default:
+                }
+            });
+            //#endregion
      
             //
             form.on('submit(Cancel)', function () {
@@ -762,7 +807,7 @@
                         , { field: 'HTimes', title: '宸ユ椂', edit: 'text' }
                         , { field: 'HQty', title: '鏁伴噺', edit: 'text' }
                         , { field: 'HPrice', title: '宸ヤ环', edit: 'text' }
-                        , { field: 'HMoney', title: '閲戦', edit: 'text' }
+                        , { field: 'HMoney', title: '閲戦' }
                         , { field: 'HRemark', title: '澶囨敞', edit: 'text' }
                         , { field: 'HICMOInterID', title: '鐢熶骇浠诲姟鍗旾D' }
                         , { field: 'HICMOBillNo', title: '鐢熶骇浠诲姟鍗曞彿'}

--
Gitblit v1.9.1