NBDXSY/LeaRun.Application/LeaRun.Application.Web/Areas/PipeNetworkManage/Views/History/Index.cshtml

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

    function getSelectedTabIndex() {
        return $("#tabs").tabs('option', 'active');
    }

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

    //加载树
    function GetTree() {
        var item = {
            height: $(window).height() - 52,
            url: "/PipeNetworkManage/Meter/GetMeterTreeJson?showcheck=true",
            oncheckboxclick: function (item, status) {
                GetAllCheckNodes(item.id, status, item.text);//维护 选中元素id的数组                
            }
        };
        //初始化
        $("#itemTree").treeview(item);
    }

    //被选中元素的ID,TEXT 数组维护
    function GetAllCheckNodes(id, status, text) {
        //数据加入数组
        if (status == 1) {
            if (!checkedIds.contain(id)) {
                checkedIds.push(id);
            }
        }

        if (status == 0) {
            if (checkedIds.contain(id)) {
                checkedIds.splice(checkedIds.indexOf(id), 1);
            }
        }
    }

    //AutoComplete
    var device = {
        init: function () {

            var width = $('#device').width();

            $('#device').autocomplete({
                source: function (request, response) {
                    $.ajax({
                        url: "/IPm/DeviceInfo/GetDeviceBySearch",
                        type: "GET",
                        data: { q: $('#device').val() },
                        dataType: "json",
                        success: function (data) {
                            response($.map(data, function (item) {
                                console.log(item);
                                return {
                                    label: item.label,
                                    value: "dev" + item.value
                                }
                            }));
                        }
                    });
                },
                select: function (event, ui) {
                    $("#device").val(ui.item.label);
                    PointTreeCode = ui.item.value;
                    return false;
                }
            });
        }
    };
    function returnFloat(value){
        var value=Math.round(parseFloat(value)*100)/100;
        var xsd=value.toString().split(".");
        if(xsd.length==1){
            value=value.toString()+".00";
            return value;
        }
        if(xsd.length>1){
            if(xsd[1].length<2){
                value=value.toString()+"0";
            }
            return value;
        }
    }

    function GetPointGrid() {
        var selectedRowIndex = 0;
        var $gridTable = $('#pointGridTable');
        $gridTable.jqGrid({
            url: "/PipeNetworkManage/History/GetListJson",
            datatype: "json",
            height: $(window).height() - 170,
            width: $('.gridPanel').width(),
            autowidth: true,
            rownumbers: true,
            colModel: [
                { name: "测点名称", label: "测点名称", align: "left" },
                { name: "采集时间", label: "采集时间", align: "right" },
                
                {
                    label: "净累计流量(m³)", name: "净累计流量", align: "right",
                    formatter: function (cellvalue, options, rowObject) {
                        if (cellvalue != null && cellvalue != "") {
                            return cellvalue = returnFloat(cellvalue)
                        } else {
                            return cellvalue;
                        }
                    }
                },
                {
                    label: "正累计流量(m³)", name: "正累计流量", align: "right",
                    formatter: function (cellvalue, options, rowObject) {
                        if (cellvalue != null && cellvalue != "") {
                            return cellvalue = returnFloat(cellvalue)
                        } else {
                            return cellvalue;
                        }
                    }
                },
                {
                    label: "负累计流量(m³)", name: "负累计流量", align: "right",
                    formatter: function (cellvalue, options, rowObject) {
                        if (cellvalue != null && cellvalue != "") {
                            return cellvalue = returnFloat(cellvalue)
                        } else {
                            return cellvalue;
                        }
                    }
                },
                {
                    label: "瞬时流量(m³/h)", name: "瞬时流量", align: "right",
                    formatter: function (cellvalue, options, rowObject) {
                        if (cellvalue != null && cellvalue != "") {
                            return cellvalue = returnFloat(cellvalue)
                        } else {
                            return cellvalue;
                        }
                    }
                },
               {
                   label: "压力(MPa)", name: "压力", align: "right",
                   formatter: function (cellvalue, options, rowObject) {
                       if (cellvalue != null && cellvalue != "") {
                           return cellvalue = returnFloat(cellvalue)
                       } else {
                           return cellvalue;
                       }
                   }
               },
               {
                   label: "电池电压(v)", name: "电池电压", align: "right",
                   formatter: function (cellvalue, options, rowObject) {
                       if (cellvalue != null && cellvalue != "") {
                           return cellvalue = returnFloat(cellvalue)
                       } else {
                           return cellvalue;
                       }
                   }
               }               
            ],
            viewrecords: true,
            rowNum: 30,
            rowList: [30, 50, 100],
            pager: "#gridPager",
            gridview: true,
            onSelectRow: function () {
                selectedRowIndex = $("#" + this.id).getGridParam('selrow');
            },
            gridComplete: function () {
                $("#" + this.id).setSelection(selectedRowIndex, false);
            }
        });


        //点击时间范围（今天、近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;
            }
        });

        //查询事件
        $("#btn_point_Search").click(function () {

            var PointStartTime = $("#PointStartTime").val();
            var PointEndTime = $("#PointEndTime").val();

            if (checkedIds.length == 0) {
                dialogMsg('请选择测点！', 0);
                return;
            }

            if (PointStartTime.length <= 0 || PointEndTime.length <= 0) {
                dialogMsg('请选择时间！', 0);
                return;
            }

            $gridTable.jqGrid('setGridParam', {
                postData: { deviceId: checkedIds.toString(), startT: PointStartTime, endT: PointEndTime },
                page: 1
            }).trigger('reloadGrid');
        });
    }


    //导出
    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', '关闭']
        });
    }
</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 class="panel-Title">历史记录</div>
            <div class="titlePanel">
                <div class="title-search">
                    <table>
                        <tr>
                           @* <td style="padding-left: 10px;">测点名称：
                            </td>
                            <td style="padding-left: 10px;">
                                <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">&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">
                <table id="pointGridTable"></table>
                <div id="gridPager"></div>
            </div>
        </div>
    </div>
</div>