NBDXSY/LeaRun.Application/LeaRun.Application.Web/Areas/WaterWellManage/Views/History/HistoryIndex.cshtml


@{
    ViewBag.Title = "历史记录查询";
    Layout = "~/Views/Shared/_LayoutIndex.cshtml";
}
<script>
    $(function () {
        InitialPage();
        GetTree();
        // device.init();
        GetPointGrid();
        Click();
    })

    //初始化页面
    function InitialPage() {
        //layout布局
        $('#layout').layout({
            applyDemoStyles: true,
            onresize: function () {
                $(window).resize();
            }
        });
        // resize重设(表格、树形)宽高
        $(window).resize(function (e) {
            window.setTimeout(function () {
                $("#pointGridTable").setGridWidth(($('.gridPanel').width()));
                $("#pointGridTable").setGridHeight($(window).height() - 160);
                $("#itemTree").setTreeHeight($(window).height() - 52);
            }, 200);
            e.stopPropagation();
        });
    }

    //获取列表
    function GetPointGrid() {
        var $gridTable = $('#pointGridTable');
        var startTime = "@DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd")";
        var endTime = "@DateTime.Now.ToString("yyyy-MM-dd")";
        $gridTable.jqGrid({
            url: "../../WaterWellManage/History/GetListJson",
            datatype: "json",
            height: $(window).height() - 160,
            autowidth: true,
            rownumbers: true,
            postData: { keyword: "", startT: startTime, endT: endTime, nodes: "", isAll: true },
            colModel: [
                { name: "WaterWellName", label: "水源井名称", width: 130, align: "left", fixed: true },
                { name: "ManufacturerCode", label: "厂商编码", width: 100, align: "left", fixed: true },
                { name: "WaterWellCode", label: "水源井编号", width: 100, align: "left", fixed: true },
                { name: "GetDateTime", label: "采集时间", width: 150, align: "left", fixed: true },
                { name: "VoltageA", label: "A相电压", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "VoltageB", label: "B相电压", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "VoltageC", label: "C相电压", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "CurrentA", label: "A相电流", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "CurrentB", label: "B相电流", width: 100, align: "right", fixed: true, formatter: 'number' },
                { name: "CurrentC", label: "C相电流", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "ActiveElectricalEnergy", label: "有功电能", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "NetAccumulatedCurrent", label: "净累计流量", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "Pressure", label: "压力", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "InstantaneousFlow", label: "瞬时流量", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "Turbidity", label: "浊度", width: 160, align: "right", fixed: true, formatter: 'number' },
                { name: "Temperature", label: "温度", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "HeightOfLiquidLevel", label: "液位高度", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "Frequency", label: "泵频率", width: 130, align: "right", fixed: true, formatter: 'number' },
                { name: "RunningState", label: "泵运行状态", width: 130, align: "left", fixed: true, formatter: "select", editoptions: { value: "0:停止;1:启动;2:故障" } },
                { name: "RunningStateDiscription", label: "泵运行状态故障描述", width: 130, align: "left", fixed: true },
                { name: "SoftStarterFault", label: "软启动器状态", width: 130, align: "left", fixed: true, formatter: "select", editoptions: { value: "0:正常;1:故障;" } },
                { name: "SoftStarterFaultDiscription", label: "软启动器故障描述", width: 130, align: "left", fixed: true },
                { name: "ThermalRelayTripFault", label: "热继电器跳闸状态", width: 130, align: "left", fixed: true, formatter: "select", editoptions: { value: "0:正常;1:故障;" } },
                { name: "ThermalRelayTripFaultDiscription", label: "热继电器跳闸故障描述", width: 130, align: "left", fixed: true },
                { name: "BoxDoorAlarm", label: "箱门状态", width: 130, align: "center", fixed: true, formatter: "select", editoptions: { value: "0:开;1:关;" } },
                //{ name: "Lng", label: "经度", width: 100, align: "right", fixed: true },
                //{ name: "Lat", label: "纬度", width: 100, align: "right", fixed: true },
            ],
            pager: '#gridpager',
            viewrecords: true,
            rowNum: 30,
            rowList: [30, 50, 100],
            sortable: true,
            sortname: '采集时间',
            sortorder: 'desc',
            gridview: true,
            footerrow: true,
            formatter: {
                number: { decimalSeparator: ".", thousandsSeparator: " ", decimalPlaces: 2, defaultValue: '0.00' }
            },
            gridComplete: function () {
                $("#pointGridTable").getDataIDs();
            }
        });
    }

    //加载树
    var PointTreeCode = 0;
    var deviceID = "";
    function GetTree() {
        var item = {
            height: $(window).height() - 52,
            url: "../../WaterWellManage/Device/GetNoParentJson",
            showcheck: true,
            isexpand: true,
            onnodeclick: function (item) {
                PointTreeCode = item.id;
                //展开下级                
                $(".bbit-tree-selected").children('.bbit-tree-ec-icon').trigger("click");
            }
        };

        //初始化
        $("#itemTree").treeview(item);
    }

    // 数据查询
    function getNodes() {
        var nodes = $("#itemTree").getTSNs(true);//获取所有勾选节点包括半勾选
        var devnodes = "";
        $.each(nodes, function (i, value) {
            var id = value.id;
            devnodes += (id + ",");
        });
        var startTime = $("#PointStartTime").val();
        var endTime = $("#PointEndTime").val();
        var searchName = $("#device").val();
        var keyWord = $("#device").val();
        $("#pointGridTable").jqGrid('setGridParam', {
            postData: { keyWord: keyWord, startT: startTime, endT: endTime, nodes: devnodes, isAll: false },
            page: 1
        }).trigger('reloadGrid');
    }

    //AutoComplete
    var device = {
        init: function () {
            var width = $('#device').width();
            $('#device').autocomplete({
                source: function (request, response) {
                    $.ajax({
                        url: "../../WaterWellManage/Device/SearchWaterWellLikeName",
                        type: "GET",
                        data: { name: $('#device').val() },
                        dataType: "json",
                        success: function (data) {
                            response($.map(data, function (item) {
                                return {
                                    label: item.label,
                                    value: item
                                }
                            }));
                        }
                    });
                },
                select: function (event, ui) {
                    $("#device").val(ui.item.label);
                    PointTreeCode = ui.item.value;
                    return false;
                }
            });
        }
    };

    //导出
    function btn_point_export() {
        dialogOpen({
            id: "ExcelIExportDialog",
            title: '导出采购报表',
            url: '/Utility/ExcelExportForm?gridId=pointGridTable',
            width: "500px",
            height: "380px",
            callBack: function (iframeId) {
                top.frames[iframeId].AcceptClick();
            }, btn: ['导出Excel', '关闭']
        });
    }

    // 点击事件
    function Click() {
        //点击时间范围（今天、近7天、近一个月、近三个月）
        $("#time_horizon a.btn-default").click(function () {
            $("#time_horizon a.btn-default").removeClass("active");
            $(this).addClass("active");
            switch ($(this).attr('data-value')) {
                case "1"://今天
                    $("#PointStartTime").val("@DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss")");
                    $("#PointEndTime").val("@DateTime.Now.ToString("yyyy-MM-dd  HH:mm:ss")");
                    break;
                case "2"://近7天
                    $("#PointStartTime").val("@DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd")");
                    $("#PointEndTime").val("@DateTime.Now.ToString("yyyy-MM-dd")");
                    break;
                case "3"://近一个月
                    $("#PointStartTime").val("@DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd")");
                    $("#PointEndTime").val("@DateTime.Now.ToString("yyyy-MM-dd")");
                    break;
                case "4"://自定义
                    $("#PointStartTime").val("");
                    $("#PointEndTime").val("");
                    break;
                default:
                    break;
            }
        })
    }

</script>

<div class="ui-layout" id="layout" style="height: 100%; width: 100%;">
    <div class="ui-layout-west">
        <div class="west-Panel">
            <div class="panel-Title">测点列表</div>
            <div id="itemTree"></div>
        </div>
       
    </div>
    <div class="ui-layout-center">
        <div class="center-Panel">
            <div id="tabs">
                <div id="tabs-1">
                    <div class="titlePanel">
                        <div class="title-search">
                            <table>
                                <tr>
                                    <td style="padding-left: 10px; display: none">测点名称：
                                    </td>
                                    <td style="padding-left: 10px; display:none">
                                        <input type="text" id="device" name="device" class="form-control" style="width: 130px;" />
                                    </td>
                                    <td style="padding-left: 10px;">开始时间：
                                    </td>
                                    <td style="padding-left: 10px;">
                                        <input id="PointStartTime" readonly type="text"  value="@LeaRun.Util.Time.GetDate(-7)" class="form-control input-wdatepicker" onfocus="WdatePicker({maxDate:'%y-%M-%d',dateFmt:'yyyy-MM-dd HH:mm:ss',maxDate:'#F{$dp.$D(\'PointEndTime\')}'})" style="width:175px">
                                    </td>
                                    <td style="padding-left: 10px;">结束时间：
                                    </td>
                                    <td style="padding-left: 10px;">
                                        <input id="PointEndTime"  readonly type="text"  value="@LeaRun.Util.Time.GetToday()" class="form-control input-wdatepicker" onfocus="WdatePicker({maxDate:'%y-%M-%d',dateFmt:'yyyy-MM-dd HH:mm:ss',minDate:'#F{$dp.$D(\'PointStartTime\')}'})" style="width:175px">
                                    </td>
                                    <td style="padding-left: 10px;">
                                        <div id="time_horizon" class="btn-group">
                                            <a class="btn btn-default" data-value="1">24小时</a>
                                            <a class="btn btn-default active" data-value="2">近7天</a>
                                            <a class="btn btn-default" data-value="3">近1个月</a>
                                            <a class="btn btn-default" data-value="4">自定义</a>
                                        </div>
                                    </td>
                                    <td style="padding-left: 10px;">
                                        <a id="btn_point_Search" class="btn btn-primary" onclick="getNodes()">&nbsp;查&nbsp;&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-export" class="btn btn-default" onclick="btn_point_export()"><i class="fa fa-sign-out"></i>&nbsp;导出</a>
                            </div>
                        </div>
                    </div>
                    <div class="gridPanel"  id="gridpanel">
                        <table id="pointGridTable"></table>
                        <div id="gridpager"></div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>