本文固定链接:http://www.verydemo.com/demo_c98_i51778.html
sql没有行转换列:
我们理想的结果是 Objectid为77的 groupName 合并为一行
最后看js处理的页面效果
可能有朋友问 效果不一样,我在后面做的时候修改了数据,毕竟这个是最终的页面 中间修改了一些bug
js代码:
js:
ztCallBack = (json.result == "0"= ( i = 0; i < json.Rows.length - 1; i++ ( j = i + 1; j < json.Rows.length; j++ (json.Rows[i].ObjectID ==+="," +1 ( i = 0; i < json.Rows.length; i++ (json.Rows[i].GroupName == || json.Rows[i].GroupName == ""= "未分组""direct"] = Math.random() * 360; json.Rows[i]["uni_status"] = []; json.Rows[i]["uni_alerts"] = columns ='终端卡号', name: 'SIM', minWidth: 90'分组', name: 'GroupName', width: 120, align: 'left''状态', name: 'State', width: 70, align: 'left''id', name: 'ObjectID', id: "ObjectID", minWidth: 0, isAllowHide: id = $("#userGridID"= { id: id, columns: columns, data: json, sortName: 'userMangerID', width: "98%", height: "94%"== (json != 0].ObjectID, ,