首页 > 代码库 > 部分扩展功能总结
部分扩展功能总结
EasyUI中datagrid的行编辑模式中,找到特定的Editor,并为其添加事件
function editrow(index) { if (rowedit == 0) { $(‘#ZCEditList‘).datagrid(‘beginEdit‘, index); rowedit = 1; var editors = $(‘#ZCEditList‘).datagrid(‘getEditors‘, index); var TonsEditor = editors[3]; var HorsepowerEditor = editors[4]; var StandardEditor = editors[10]; TonsEditor.target.bind(‘blur‘, function () { HorsepowerEditor.target.val(‘‘); var sum = TonsEditor.target.val() * 10; StandardEditor.target.val(sum); }); } }
//keyCtr 扩展方法 下上键实现选择 $.extend($.fn.datagrid.methods, { keyCtr : function (jq) { return jq.each(function () { var grid = $(this); grid.datagrid(‘getPanel‘).panel(‘panel‘).attr(‘tabindex‘, 1).bind(‘keydown‘, function (e) { switch (e.keyCode) { case 38: // up var selected = grid.datagrid(‘getSelected‘); if (selected) { var index = grid.datagrid(‘getRowIndex‘, selected); grid.datagrid(‘selectRow‘, index - 1); } else { var rows = grid.datagrid(‘getRows‘); grid.datagrid(‘selectRow‘, rows.length - 1); } break; case 40: // down var selected = grid.datagrid(‘getSelected‘); if (selected) { var index = grid.datagrid(‘getRowIndex‘, selected); grid.datagrid(‘selectRow‘, index + 1); } else { grid.datagrid(‘selectRow‘, 0); } break; } }); }); } });
//实现统计功能
$.extend($.fn.datagrid.methods, { statistics: function (jq) { var opt=$(jq).datagrid(‘options‘).columns; var rows = $(jq).datagrid("getRows"); var footer = new Array(); footer[‘sum‘] = ""; footer[‘avg‘] = ""; footer[‘max‘] = ""; footer[‘min‘] = ""; for(var i=0; i<opt[0].length; i++){ if(opt[0][i].sum){ footer[‘sum‘] = footer[‘sum‘] + sum(opt[0][i].field)+ ‘,‘; } if(opt[0][i].avg){ footer[‘avg‘] = footer[‘avg‘] + avg(opt[0][i].field)+ ‘,‘; } if(opt[0][i].max){ footer[‘max‘] = footer[‘max‘] + max(opt[0][i].field)+ ‘,‘; } if(opt[0][i].min){ footer[‘min‘] = footer[‘min‘] + min(opt[0][i].field)+ ‘,‘; } } var footerObj = new Array(); if(footer[‘sum‘] != ""){ var tmp = ‘{‘ + footer[‘sum‘].substring(0,footer[‘sum‘].length - 1) + "}"; var obj = eval(‘(‘ + tmp + ‘)‘); if(obj[opt[0][0].field] == undefined){ footer[‘sum‘] += ‘"‘ + opt[0][0].field + ‘":"<b>当页合计:</b>"‘; obj = eval(‘({‘ + footer[‘sum‘] + ‘})‘); }else{ obj[opt[0][0].field] = "<b>当页合计:</b>" + obj[opt[0][0].field]; } footerObj.push(obj); } if(footer[‘avg‘] != ""){ var tmp = ‘{‘ + footer[‘avg‘].substring(0,footer[‘avg‘].length - 1) + "}"; var obj = eval(‘(‘ + tmp + ‘)‘); if(obj[opt[0][0].field] == undefined){ footer[‘avg‘] += ‘"‘ + opt[0][0].field + ‘":"<b>当页均值:</b>"‘; obj = eval(‘({‘ + footer[‘avg‘] + ‘})‘); }else{ obj[opt[0][0].field] = "<b>当页均值:</b>" + obj[opt[0][0].field]; } footerObj.push(obj); } if(footer[‘max‘] != ""){ var tmp = ‘{‘ + footer[‘max‘].substring(0,footer[‘max‘].length - 1) + "}"; var obj = eval(‘(‘ + tmp + ‘)‘); if(obj[opt[0][0].field] == undefined){ footer[‘max‘] += ‘"‘ + opt[0][0].field + ‘":"<b>当页最大值:</b>"‘; obj = eval(‘({‘ + footer[‘max‘] + ‘})‘); }else{ obj[opt[0][0].field] = "<b>当页最大值:</b>" + obj[opt[0][0].field]; } footerObj.push(obj); } if(footer[‘min‘] != ""){ var tmp = ‘{‘ + footer[‘min‘].substring(0,footer[‘min‘].length - 1) + "}"; var obj = eval(‘(‘ + tmp + ‘)‘); if(obj[opt[0][0].field] == undefined){ footer[‘min‘] += ‘"‘ + opt[0][0].field + ‘":"<b>当页最小值:</b>"‘; obj = eval(‘({‘ + footer[‘min‘] + ‘})‘); }else{ obj[opt[0][0].field] = "<b>当页最小值:</b>" + obj[opt[0][0].field]; } footerObj.push(obj); } if(footerObj.length > 0){ $(jq).datagrid(‘reloadFooter‘,footerObj); } function sum(filed){ var sumNum = 0; for(var i=0;i<rows.length;i++){ sumNum += Number(rows[i][filed]); } return ‘"‘ + filed + ‘":"‘ + sumNum.toFixed(2) +‘"‘; }; function avg(filed){ var sumNum = 0; for(var i=0;i<rows.length;i++){ sumNum += Number(rows[i][filed]); } return ‘"‘ + filed + ‘":"‘+ (sumNum/rows.length).toFixed(2) +‘"‘; } function max(filed){ var max = 0; for(var i=0;i<rows.length;i++){ if(i==0){ max = Number(rows[i][filed]); }else{ max = Math.max(max,Number(rows[i][filed])); } } return ‘"‘ + filed + ‘":"‘+ max +‘"‘; } function min(filed){ var min = 0; for(var i=0;i<rows.length;i++){ if(i==0){ min = Number(rows[i][filed]); }else{ min = Math.min(min,Number(rows[i][filed])); } } return ‘"‘ + filed + ‘":"‘+ min +‘"‘; } }});
用法 :在字段中加入 sum:true;
http://www.oschina.net/code/snippet_659525_20039
部分扩展功能总结
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。