$(document).ready(function () {
    //表头
    var listHead = [
      
        '姓名',
        '城市',
        '部门',
        '选取',
        '票数',
    ]
    var html = "";

    for (var i = 0; i < listHead.length; i++) {
        //动态创建一个tr行标签,并且转换成jQuery对象
        html += `<td class='headtd'>` + listHead[i] + `<button type='submit' class='btnStyle delbtn' style='margin-left: 50px;'>删除</button></td >`
        $("#test_thead").html(html);
    }
    //表格
    var listData = [
        {
            id: 1,
            name: "Small",
            city: "New York",
            department: "Eastern",
            selection: "Metropolitan Region",
            number: 378
        },
        {
            id: 1,
            name: "Small1",
            city: "New York",
            department: "Eastern",
            selection: "Metropolitan Region",
            number: 378
        },
        {
            id: 1,
            name: "Small2",
            city: "New York",
            department: "Eastern",
            selection: "Metropolitan Region",
            number: 378
        },
        {
            id: 1,
            name: "Small3",
            city: "New York",
            department: "Eastern",
            selection: "Metropolitan Region",
            number: 378
        },
        {
            id: 1,
            name: "Small4",
            city: "New York",
            department: "Eastern",
            selection: "Metropolitan Region",
            number: 378
        },
        {
            id: 1,
            name: "Small5",
            city: "New York",
            department: "Eastern",
            selection: "Metropolitan Region",
            number: 378
        }
    ];
    listGenerate(listData)
    function listGenerate(e) {
        //清空所有的子节点 
        $("#test_tbody").empty();
        for (var i = 0; i < e.length; i++) {
            //动态创建一个tr行标签,并且转换成jQuery对象
            var $trTemp = $("<tr></tr>");

            //往行里面追加 td单元格
       
            $trTemp.append("<td>" + e[i].name + "</td>");
            $trTemp.append("<td>" + e[i].city + "</td>");
            $trTemp.append("<td>" + e[i].department + "</td>");
            $trTemp.append("<td>" + e[i].selection + "</td>");
            $trTemp.append("<td>" + e[i].number + "</td>");
            // $("#J_TbData").append($trTemp);
            $trTemp.appendTo("#test_tbody");
        }
    }

    //点击查询
    $("#querybtn").click(function () {
        listGenerate(listData)
    });
    //点击显示按钮
    $("#eject").click(function () {
      
        $('.delbtn').toggle();
    });
    //点击删除当前列
    $(".delbtn").click(function () {
        var l = $("#test_table tr").length;

        var ind= $(this).parent().index();
     
        if(l>1){
            for (var i = 0; i < l; i++) {
               $("#test_table tr").eq(i).find("td").eq(ind).remove();
           }  
           $('.delbtn').toggle();
       }
       
    });

    //导出表格
    excel = new ExcelGen({
        "src_id": "test_table",
        "show_header": true
    });
    $("#generate-excel").click(function () {
        excel.generate();
    });
});