NBDXSY/LeaRun.Application/LeaRun.Application.Web/Areas/NBManage/Views/NBHistorySearch/GetLastedDataBySql.cshtml

@{
    ViewBag.Title = "抄表历史查询";
    Layout = "~/Views/Shared/_Index.cshtml";
}
<script>
    $(document).ready(function () {
        initControl();
        initialPage();
        GetGrid();
        //表格表头居中显示
        $(".ui-th-column").css("text-align", "center");
    });
    //重设(表格)宽高
    function initialPage() {
        //resize重设(表格、树形)宽高
        $(window).resize(function (e) {
            window.setTimeout(function () {
                $('#gridTable').setGridWidth(($('.gridPanel').width()));
                $("#gridTable").setGridHeight($(window).height() - 108.5);
            }, 200);
            e.stopPropagation();
        });
    }
    //加载表格
    function GetGrid() {
        var selectedRowIndex = 0;
        var $gridTable = $('#gridTable');
        $gridTable.jqGrid({
            url: "/NBManage/NBHistorySearch/GetRealTimeDataBySql",
            datatype: "json",
            height: $(window).height() - 148.5,
            autowidth: true,
            colModel: [
                { label: '主键', name: 'OrganizeId', hidden: true, fixed: true },
                { label: "IMEI", name: "IMEI", width: 200, align: "right", sortable: false, fixed: true, hidden: true },
                { label: "DeviceID", name: "IOT_Code", width: 300, align: "left", sortable: false, fixed: true, hidden: true },
                { label: "区域名称", name: "area", width: 300, align: "left", sortable: false, fixed: true },
                //{ label: "门牌号", name: "room", width: 100, align: "left", sortable: false, fixed: true },
                //{ label: "用户编号", name: "UserNo", width: 150, align: "left", sortable: false, fixed: true },
                //{ label: "用户名称", name: "UserName", width: 150, align: "left", sortable: false, fixed: true },
                { label: "表类型", name: "MeterType", width: 100, align: "left", sortable: false, hidden: true, fixed: true },
                { label: "表地址", name: "ElecAddress", width: 150, align: "right", fixed: true },
                { label: "抄表时间", name: "NowRadingDT", width: 165, align: "right", fixed: true },
                { label: "净累计(m³)", name: "NowReading", width: 150, align: "right", fixed: true },
                { label: "信号强度", name: "Rsrp", width: 100, align: "left", sortable: false, fixed: true },
                { label: "注册时间", name: "CreateDT", width: 100, align: "left", sortable: false, fixed: true }
            ],
            multiselect: true,
            viewrecords: true,
            rowNum: 3000,
            pager: "#gridPager",
            gridview: true,
            sortable: true,
            sortname: "NowRadingDT",
            sortorder: "desc",
            rownumbers: true,
            gridComplete: function () {
                $("#" + this.id).setSelection(selectedRowIndex, false);
            }
        });
    }

    // 取最新数据
    function getLastData() {
        var ids = $("#gridTable").jqGrid("getGridParam", "selarrrow");
        var startQueque = Promise.resolve();
        $(ids).each(function (index, id) {
            var row = $("#gridTable").jqGrid('getRowData', id);
            var IOT_Code = row.IOT_Code;
            (function (IOT_Code) {
                startQueque = startQueque.then(function () {
                    $.ajax({
                        type: 'POST',
                        url: "/NBManage/NBEquipmentDebug/GetAjaxData?deviceId=" + IOT_Code,
                        cache: false,
                        ifModified: true,
                        dataType: 'JSON',
                        beforeSend: function () {
                            $("#gridTable").jqGrid('setCell', id, "Total", '<img class="alarmimg" src="/Content/images/send_wait.gif" " />');
                            $("#gridTable").jqGrid('setCell', id, "ReadingDT", '读取中...');
                        },
                        success: function (jsonData) {
                            console.log(jsonData);
                            $("#gridTable").jqGrid('setCell', id, "Total", jsonData[0].total);
                            $("#gridTable").jqGrid('setCell', id, "ReadingDT", jsonData[0].read_time);
                        },
                    })
                });
            })(IOT_Code);
        })
    }

    function initControl() {
        //小区
        $("#AreaId").ComboBox({
            url: "/NBManage/NBHistorySearch/GetAreaListJson",
            id: "AreaId",
            text: "AreaName",
            description: "选择小区",
            height: "170px"
        });
    }

    function btn_Search() {
        var areaId = $("#AreaId").attr('data-value');

        $("#gridTable").jqGrid('setGridParam', {
            postData: {
                areaId: areaId
            }
        }).trigger('reloadGrid');
    }

    //导出
    function btn_export() {
        var datavalue = $("#gridTable").jqGrid('getRowData');   //获取全部数据
        dialogOpen({
            id: "ExcelIExportDialog",
            title: '导出',
            url: '/Utility/ExcelExportForm?gridId=gridTable&filename=历史记录',
            width: "500px",
            height: "380px",
            callBack: function (iframeId) {
                top.frames[iframeId].AcceptClick();
            }, btn: ['导出Excel', '关闭']
        });
    }
</script>
<div class="titlePanel">
    <div class="title-search">
        <table>
            <tr>
                <td>
                    <div id="queryCondition">
                        <div id="AreaId" type="select" class="ui-select" style="float: left; min-width: 150px; margin-right: 1px;"></div>
                    </div>
                </td>
                <td style="padding-left: 5px;">
                    <a id="btn_Search" class="btn btn-primary" onclick="btn_Search()"><i class="fa fa-search"></i>&nbsp;查询</a>
                </td>
            </tr>
        </table>
    </div>
    <div class="toolbar">
        <div class="btn-group">
            @*<a id="lr-replace" class="btn btn-default" onclick="reload();"><i class="fa fa-refresh"></i>&nbsp;刷新</a>
            <a id="lr-replace" class="btn btn-default" onclick="getLastData();"><i class="fa fa-refresh"></i>&nbsp;取数据</a>*@
            <a id="lr-edit" class="btn btn-default" onclick="btn_export()"><i class="fa  fa-file-excel-o"></i>&nbsp;导出</a>
        </div>
    </div>
</div>
<div class="gridPanel">
    <table id="gridTable"></table>
    <div id="gridPager"></div>
</div>