动态添加表格并打印

动态添加表格并打印

//打印
function printText() {
/*    bdhtml=window.document.body.innerHTML;
    sprnstr="<!--startprint-->";
    eprnstr="<!--endprint-->";
    prnhtml=bdhtml.substr(bdhtml.indexOf(sprnstr)+17);
    prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr));
    window.document.body.innerHTML=prnhtml;
    window.print();
    window.close();
    window.location.reload();*/
     // $('#policeAssessmentTable').printThis();

    $.ajax({
        url: '/policeAssessment/getPoliceAssessmentTable.do',
        type: "post",
        // data: data,
        dataType: "json",
        success: function (data) {
            console.log(JSON.stringify(data.rows))
            var window1 = window.open('');
            window1.document.write('<table align="center" width="100%" border="1" cellspacing="0"> \n' +
                '  <thead> \n' +
                '   <tr> \n' +
                '     <th>专题名称</th> \n' +
                '     <th>干警姓名</th> \n' +
                '     <th>总学时</th> \n' +
                '     <th>培训学时</th> \n' +
                '     <th>培训内容</th> \n' +
                '     <th>培训总结</th> \n' +
                '   </tr>  \n' +
                '  </thead> \n' +
                '  <tbody id="tbMain"></tbody> \n' +
                '</table>')
            var tbody = window1.document.getElementById('tbMain');

            for(var i = 0;i < data.rows.length; i++){ //遍历一下json数据
                var trow = getDataRow(data.rows[i]); //定义一个方法,返回tr数据
                tbody.appendChild(trow);
            }


window1.print();
window1.close();
window1.location.reload();
            //$("#policeAssessmentTable").bootstrapTable('refresh', data);
        }, error: function (data) {
            alert("error");
        }
    })

}

function getDataRow(h){
    var row = document.createElement('tr'); //创建行
/*$.each(h,function (k,v) {
    var specialNameCell = document.createElement('td');//创建列
    specialNameCell.innerHTML = v;
    row.appendChild(specialNameCell);

})*/
    var specialNameCell = document.createElement('td');//创建第二列name
    specialNameCell.innerHTML = h.specialName;
    specialNameCell.style.textAlign='center';
    row.appendChild(specialNameCell);

var publicPeopleNameCell = document.createElement('td');//创建第二列name
    publicPeopleNameCell.innerHTML = h.publicPeopleName;
    publicPeopleNameCell.style.textAlign='center';
    row.appendChild(publicPeopleNameCell);

    var totalClassHourCell = document.createElement('td');//创建第三列job
    totalClassHourCell.innerHTML = h.totalClassHour;
    totalClassHourCell.style.textAlign='center';
    row.appendChild(totalClassHourCell);

    var trainClassHourCell = document.createElement('td');//创建第三列job
    trainClassHourCell.innerHTML = h.trainClassHour;
    trainClassHourCell.style.textAlign='center';
    row.appendChild(trainClassHourCell);

    var trainContentCell = document.createElement('td');//创建第三列job
    trainContentCell.innerHTML = h.trainContent;
    trainContentCell.style.textAlign='center';
    row.appendChild(trainContentCell);

    var trainSummaryCell = document.createElement('td');//创建第三列job
    trainSummaryCell.innerHTML = h.trainSummary;
    trainSummaryCell.style.textAlign='center';
    row.appendChild(trainSummaryCell);

/*    //到这里，json中的数据已经添加到表格中，下面为每行末尾添加删除按钮
    var delCell = document.createElement('td');//创建第四列，操作列
    row.appendChild(delCell);
    var btnDel = document.createElement('input'); //创建一个input控件
    btnDel.setAttribute('type','button'); //type="button"
    btnDel.setAttribute('value','删除');
    //删除操作
    btnDel.onclick=function(){
        if(confirm("确定删除这一行嘛？")){
            //找到按钮所在行的节点，然后删掉这一行
            this.parentNode.parentNode.parentNode.removeChild(this.parentNode.parentNode);
            //btnDel - td - tr - tbody - 删除(tr)
            //刷新网页还原。实际操作中，还要删除数据库中数据，实现真正删除
        }
    }
    delCell.appendChild(btnDel);*/ //把删除按钮加入td，别忘了
    return row; //返回tr数据
}

 var window1 = window.open('');
            window1.document.write('<table align="center" width="1000px" style="table-layout:fixed;" border="1" cellspacing="0"> \n' +
                '  <thead> \n' +
                '   <tr> \n' +
                '     <th>专题名称</th> \n' +
                '     <th>干警姓名</th> \n' +
                '     <th>总学时</th> \n' +
                '     <th>培训学时</th> \n' +
                '     <th>培训内容</th> \n' +
                '     <th>培训总结</th> \n' +
                '   </tr>  \n' +
                '  </thead> \n' +
                '  <tbody id="tbMain"></tbody> \n' +
                '</table>')
            var tbody = window1.document.getElementById('tbMain');

            var html1='';
            for (var i = 0; i < data.rows.length; i++) { //遍历一下json数据
                // var trow = getDataRow(data.rows[i]); //定义一个方法,返回tr数据
                // tbody.appendChild(trow);
                 html1+='<tr>' +
                    '<td style="text-align: center; white-space: nowrap;text-overflow: ellipsis;overflow: hidden;" >'+data.rows[i].specialName+'</td>' +
                    '<td style="text-align: center; white-space: nowrap;text-overflow: ellipsis;overflow: hidden;" >'+data.rows[i].name+'</td>' +
                    '<td style="text-align: center; white-space: nowrap;text-overflow: ellipsis;overflow: hidden;" >'+data.rows[i].totalClassHour+'</td>' +
                    '<td style="text-align: center; white-space: nowrap;text-overflow: ellipsis;overflow: hidden;" >'+data.rows[i].trainClassHour+'</td>' +
                    '<td style="text-align: center; white-space: nowrap;text-overflow: ellipsis;overflow: hidden;">'+data.rows[i].trainContent+'</td>' +
                    '<td style="text-align: center; white-space: nowrap;text-overflow: ellipsis;overflow: hidden;" >'+data.rows[i].trainSummary+'</td>' +
                    '</tr>'

            }
            $(tbody).html(html1)

            window1.print();
            window1.close();
            window1.location.reload();