事务备份

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="default.aspx.cs" Inherits="pgDatashow.pgData" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>pgsql数据测试</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css" rel="stylesheet" />
    <style>
        .main{
            max-800px;
            margin:50px auto;
        }

    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div class="main">

            <table id="Onedesk"  data-toggle="table" class="table table-bordered table-striped table-hover">
                <tr>
                    <th>domainid</th>
                    <th>domaintitle</th>
                    <th>domainparent</th>
                </tr>
            </table>
            <p style="text-align:right;">列表总行数 <span id="h1" style="font-weight:900;"></span></p>

            <table id="table" data-toggle="table" class="table table-bordered table-striped table-hover">
                <thead>
                    <tr>
                        <th scope="col">MetaID</th>
                        <th scope="col">MetaTitle</th>
                        <th scope="col">KeyWord</th>
                        <th scope="col">MetaContent</th>
                    </tr>
                </thead>
                <tbody>
                    
                </tbody>
            </table>
        </div>
    <script src="https://cdn.jsdelivr.net/npm/jquery@1.12.4/dist/jquery.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/js/bootstrap.min.js"></script>
    <script type="text/javascript">
        $(function () {
            $.ajax({
                type:'post',
                url:"/default.aspx/retJson",
                dataType: 'json',
                contentType: "application/json",
                async:false,
                success: function (data) {
                    var tirm = eval('(' + data.d + ')');
                    //console.log(data.d);
                    //console.log(eval('(' + data.d + ')'));
                    //console.log(tirm.Table1);
                    //console.log(tirm.Table1[0]);
                    //console.log(tirm.Table1[0].MetaID);
                    for (var i=0; i < tirm.Table1.length  ; i++) {
                        $("#table").append('<tr><td>'+ tirm.Table1[i].MetaID+ '</td><td>'+ tirm.Table1[i].MetaTitle+ '</td><td>'+ tirm.Table1[i].KeyWord+ '</td><td>'+ tirm.Table1[i].MetaContent+ '</td></tr>')
                    }
                    $("#h1").html(tirm.Table2[0].count);
                },
                error: function () {
                    console.log("other");
                }
            });
            $.ajax({
                type:'post',
                url:"/default.aspx/retJsons",
                dataType: 'json',
                contentType: "application/json",
                async:false,
                success: function (data) {
                    console.log(data.d)
                    var tirm = eval('(' + data.d + ')');
                    console.log(data.d);
                    console.log(tirm);

                    for (var i=0; i < tirm.Table.length  ; i++) {
                        $("#Onedesk").append('<tr><td>'+ tirm.Table[i].domainid+ '</td><td>'+ tirm.Table[i].domaintitle+ '</td><td>'+ tirm.Table[i].domainparent+ '</td></tr>')
                    }
                },
                error: function () {
                    console.log("otherOne");
                }
            });
        })
    </script>
    </form>
</body>
</html>