工艺路线子表添加字段

yusijie

2025-01-10 ca1ffee834f0d6f86cbc38ed7df922d405b8febe

工艺路线子表添加字段

 WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBill.html

@@ -588,6 +588,7 @@
                , "HQCSchemeID_Proc": 0, "HQCSchemeNumber_Proc": "", "HQCSchemeName_Proc": ""
                , "HQCSchemeID_Patrol": 0, "HQCSchemeNumber_Patrol": "", "HQCSchemeName_Patrol": ""
                , "HQCFst": false, "HQCProc": false, "HQCPatrol": false, "HMaterToSourceCtrl": false
                ,"HSubStdEmpAvg_S": 0
            }];
            var HModName = "Gy_RoutingBill";
            //#endregion
@@ -648,7 +649,9 @@
                    , { field: 'HQCSchemeID_Patrol', title: '巡检检验方案ID', hide: true }//f7
                    , { field: 'HQCSchemeNumber_Patrol', title: '巡检检验方案代码', edit: 'text', event: "HQCSchemeNumber_Patrol", width: 125 }
                    , { field: 'HQCSchemeName_Patrol', title: '巡检检验方案名称', width: 125 }//f7
                    , { field: 'HWorkQty', title: '加工数量', edit: 'text', width: 125}
                    , { field: 'HWorkQty', title: '加工数量', edit: 'text', width: 125 }
                    , { field: 'HSubStdEmpQty_S', title: '产线人数', edit: 'text', width: 125 }
                    , { field: 'HSubStdEmpAvg_S', title: '人均产能', edit: 'text', width: 125}
                    //, { field: 'HPassRate', title: '良率', edit: 'text' }//默认
                    //, { field: 'HProcID_S', title: '工段', edit: 'text' }
                    ////, { field: 'HCenterID_S', title: '产线中心id', hide: true }//hide: true
@@ -1205,6 +1208,7 @@
                    , "HQCSchemeID_Proc": 0, "HQCSchemeNumber_Proc": "", "HQCSchemeName_Proc": ""
                    , "HQCSchemeID_Patrol": 0, "HQCSchemeNumber_Patrol": "", "HQCSchemeName_Patrol": ""
                    , "HQCFst": false, "HQCProc": false, "HQCPatrol": false, "HMaterToSourceCtrl": false
                    , "HSubStdEmpAvg_S": 0
                };
                switch (obj.event) {
                    case 'btn-AddLine':
@@ -1366,6 +1370,33 @@
                            return false;
                        }
                    }
                }
            })

            //明细网格单元格编辑事件
            table.on('edit(mainTable)', function (obj) {
                var value = obj.value //得到修改后的值
                    , data = obj.data //得到所在行所有键值
                    , field = obj.field; //得到字段
                switch (field) {
                    case 'HSubStdEmpQty_S': //产线人数
                        if (value != 0 && value != "" && data.HSubStdEmpAvg_S != 0 && data.HSubStdEmpAvg_S != "") {
                            //同步更新表格和缓存对应的值
                            obj.update({
                                HWorkQty: Number((value * data.HSubStdEmpAvg_S).toFixed(2))
                            });
                            //table.render(option)
                        }                       
                        break;
                    case 'HSubStdEmpAvg_S': //产线人均产能
                        if (value != 0 && value != "" && data.HSubStdEmpQty_S != 0 && data.HSubStdEmpQty_S != "") {
                            //同步更新表格和缓存对应的值
                            obj.update({
                                HWorkQty: Number((value * data.HSubStdEmpQty_S).toFixed(2))
                            });
                            //table.render(option)
                        }
                        break;
                }
            })

@@ -2209,7 +2240,8 @@
                                                , "HQCSchemeID_Fst": 0, "HQCSchemeNumber_Fst": "", "HQCSchemeName_Fst": ""
                                                , "HQCSchemeID_Proc": 0, "HQCSchemeNumber_Proc": "", "HQCSchemeName_Proc": ""
                                                , "HQCSchemeID_Patrol": 0, "HQCSchemeNumber_Patrol": "", "HQCSchemeName_Patrol": ""
                                                , "HQCFst": false, "HQCProc": false, "HQCPatrol": false,"HMaterToSourceCtrl":false
                                                , "HQCFst": false, "HQCProc": false, "HQCPatrol": false, "HMaterToSourceCtrl": false
                                                , "HSubStdEmpAvg_S": 0
                                            })
                                            j++;
                                        }
@@ -2656,6 +2688,7 @@
                                    , "HQCSchemeID_Proc": d.data[i].HQCSchemeID_Proc, "HQCSchemeNumber_Proc": d.data[i].转序检验方案代码, "HQCSchemeName_Proc": d.data[i].转序检验方案
                                    , "HQCSchemeID_Patrol": d.data[i].HQCSchemeID_Patrol, "HQCSchemeNumber_Patrol": d.data[i].巡检检验方案代码, "HQCSchemeName_Patrol": d.data[i].巡检检验方案
                                    , "HQCFst": d.data[i].HQCFst == 1 ? true : false, "HQCProc": d.data[i].HQCProc == 1 ? true : false, "HQCPatrol": d.data[i].HQCPatrol == 1 ? true : false, "HMaterToSourceCtrl": d.data[i].HMaterToSourceCtrl == 1 ? true : false
                                    , "HSubStdEmpAvg_S": d.data[i].人均产能
                                }
                            )
                        }
@@ -2714,6 +2747,14 @@
                for (var i = 0; i < table.cache["mainTable"].length; i++) {
                    if (table.cache["mainTable"][i] != "") {
                        table.cache["mainTable"][i].LAY_TABLE_INDEX = i;

                        //加工数量=产线人数 * äº§çº¿äººå‡äº§èƒ½
                        if (table.cache["mainTable"][i].HSubStdEmpQty_S != 0 && table.cache["mainTable"][i].HSubStdEmpQty_S != "" && table.cache["mainTable"][i].HSubStdEmpAvg_S != 0 && table.cache["mainTable"][i].HSubStdEmpAvg_S != "") {

                            table.cache["mainTable"][i].HWorkQty = Number((table.cache["mainTable"][i].HSubStdEmpQty_S * table.cache["mainTable"][i].HSubStdEmpAvg_S).toFixed(2))

                        }

                        num.push(table.cache["mainTable"][i])
                    }                 
                }