1

Surpriseplus

2022-10-14 6d536dea3cec157947947aa075bebde4305f29b9

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
$(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();
    });
});