jsp应用bootstrap表格应用实例
一、初始化表格
产量
电
煤气、天然气
压缩空气
蒸汽(t)
清水(t)
软化水(t)
氧气(m3)
焦炭(t)
柴油(t)
单位
量
计量单位
量(kwh×10^4)
单耗(kwh)
量(km3)
单耗(m3)
量(km3)
单耗(m3)
二、获取表格数据
setPlanMakeTable(todayYear + '-' + todayMonth);
function setPlanMakeTable(msg) {
document.getElementById("tableTitle").innerHTML = msg.replace('-', '年') + "月份生产单位能源消耗计划"
$.ajax({
type: "get",
dataType: "json",
url: "/energyPlan/getEnergyPlanMakeData",
data: {
dateString: msg.replace('-', ''),
flag: "0"
},
success: function (json) {
$.unblockUI();
$('#planMakeTable').find('tr:gt(2)').remove();//删除之前的数据
var s = '';
for (var i = 0; i < json.length; i++)
s += '' + ';
'' + json[i].companyName + ' ' +
''style="white-space:nowrap;text-overflow: ellipsis" id="' + json[i].outPutID + '">' + json[i].outPut + ' ' +
'' + json[i].unitName + ' ' +
'' + json[i].electric + ' ' +
'' + json[i].electric_part + ' ' +
'' + json[i].coalGas + ' ' +
'' + json[i].coalGas_Part + ' ' +
'' + json[i].air + ' ' +
'' + json[i].air_part + ' ' +
'' + json[i].steam + ' ' +
'' + json[i].water + ' ' +
'' + json[i].softWater + ' ' +
'' + json[i].oxygen + ' ' +
'' + json[i].coke + ' ' +
'' + json[i].oil + ' ' +
'
$('#planMakeTable').append(s);
// $('#planMakeTable').editableTableWidget().numericInputExample().find('td:first').focus();
// $('#planMakeTable').editableTableWidget({editor: $('
三、监听表格数据改变
function OnInput_cl(value, eleID, elePartID, gasID, gasPartID, airID, airPartID) {
var eleValue = $('#' + eleID + '').text();
var gasValue = $('#' + gasID + '').text();
var airValue = $('#' + airID + '').text();
$('#' + elePartID + '').text(eleValue * 10000 / value);
$('#' + gasPartID + '').text(gasValue * 10000 / value);
$('#' + airPartID + '').text(airValue * 10000 / value);
}四、保存表格数据
function savePlanMake() {
// 遍历所有的table数据
var flag = false;
var html = '';
$('#planMakeTable').find('tbody').each(function () {
$(this).find('tr').each(function () {
$(this).find('td').each(function () {
if ($(this).attr("id") != "" && $(this).attr("id") != null && $.trim($(this).text()) != "") {
if (isNaN($(this).text())) {
flag = true;
return false;
}
html += $(this).attr("id") + ',' + $(this).text() + "||";
}
});
});
return false;
});
if (flag == true) {
$.messager.popup("只允许输入数字,请检查!");
return false;
} else {
var time = $('#datetimepicker').val();
var dataString = {
"data": html,
"time": time
};
$.ajax({
url: "/energyPlan/saveEnergyPlanMakeData",
type: "post",
dataType: "text",
contentType: "application/json; charset=utf-8",
data: $.toJSON(dataString),
success: function (msg) {
$.unblockUI();
$(".blockUI").fadeOut("slow");
$.messager.popup("提交成功!");
var time = $('#datetimepicker').val();
setPlanMakeTable(time);
},
error: function (xhr, msg, e) {
$.unblockUI();
$(".blockUI").fadeOut("slow");
alert("提交失败:" + xhr + "," + msg + "," + e);
},
beforeSend: function () {
$.blockUI({message: '正在提交,请稍候...
'});
}
});
}
}相关