NBDXSY/LeaRun.Application/LeaRun.Application.Web/Areas/WaterWellManage/Views/MonthReport/Index.cshtml

@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_LayoutIndex.cshtml";
}

<script>
    "use strict"
    $(function () {
        InitialPage();
        initControl();
        GetPointGrid();
    })

    //初始化页面
    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);
            }, 200);
            e.stopPropagation();
        });
    }

    //获取列表
    function GetPointGrid() {
        var $gridTable = $('#pointGridTable');
        $gridTable.jqGrid({
            url: "../../WaterWellManage/MonthReport/GetListJson",
            datatype: "json",
            height: $(window).height() - 160,
            autowidth: true,
            rownumbers: true,
            postData: { waterWellId: "", month: "" },
            colModel: [
                { name: 'WaterWellId', label: 'id', hidden: true },
                { name: 'Month', label: '月份', hidden: true },
                { name: "Day", label: "时间", width: 80, align: "left", fixed: true },
                { name: "MaxVoltageA", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinVoltageA", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgVoltageA", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxVoltageB", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinVoltageB", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgVoltageB", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxVoltageC", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinVoltageC", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgVoltageC", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxCurrentA", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinCurrentA", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgCurrentA", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxCurrentB", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinCurrentB", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgCurrentB", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxCurrentC", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinCurrentC", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgCurrentC", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxActiveElectricalEnergy", label: "起始值", width: 80, align: "right", fixed: true },
                { name: "MinActiveElectricalEnergy", label: "终止值", width: 80, align: "right", fixed: true },
                { name: "IncrementActiveElectricalEnergy", label: "增量", width: 80, align: "right", fixed: true },

                { name: "MaxNetAccumulatedCurrent", label: "起始值", width: 80, align: "right", fixed: true },
                { name: "MinNetAccumulatedCurrent", label: "终止值", width: 80, align: "right", fixed: true },
                { name: "IncrementNetAccumulatedCurrent", label: "增量", width: 80, align: "right", fixed: true },


                { name: "MaxPressure", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinPressure", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgPressure", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxInstantaneousFlow", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinInstantaneousFlow", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgInstantaneousFlow", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxTurbidity", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinTurbidity", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgTurbidity", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxTemperature", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinTemperature", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgTemperature", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxHeightOfLiquidLevel", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinHeightOfLiquidLevel", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgHeightOfLiquidLevel", label: "平均值", width: 80, align: "right", fixed: true },

                { name: "MaxFrequency", label: "最大值", width: 80, align: "right", fixed: true },
                { name: "MinFrequency", label: "最小值", width: 80, align: "right", fixed: true },
                { name: "AvgFrequency", label: "平均值", width: 80, align: "right", fixed: true }

            ],
            viewrecords: true,
            rowNum: 31,
            sortable: true,
            sortorder: 'desc',
            gridview: true,
            footerrow: true,
            subGrid: true,
            subGridRowExpanded: function (subgrid_id, row_id) {
                var rowData = $(this).getRowData(row_id);
                var Day = rowData['Day'];
                var Month = rowData['Month'];
                var WaterWellId = rowData['WaterWellId'];
                var subgrid_table_id = subgrid_id + "_t";
                $("#" + subgrid_id).html(
                    "<table id='" + subgrid_table_id
                        + "' class='scroll'></table>");
                jQuery("#" + subgrid_table_id).jqGrid(
                    {
                        url: '../../WaterWellManage/MonthReport/GetSubListJson?id=' + row_id + '&Day=' + Day + '&Month=' + Month + '&WaterWellId='+WaterWellId,
                        datatype: "json",
                        colNames: ['水源井名称', '厂商编码', '水源井编号', '采集时间', 'A相电压', 'B相电压', 'C相电压', 'A相电流', 'B相电流', 'C相电流', '有功电能', '净累计流量', '压力', '瞬时流量', '浊度', '温度', '液位高度', '泵频率', '泵运行状态', '泵运行状态故障描述', '软启动器状态', '软启动器故障描述', '热继电器跳闸状态', '热继电器跳闸故障描述', '箱门状态'],
                        colModel: [
                            { name: "WaterWellName", index: "WaterWellName", width: 100, key: true, align: "left" },
                            { name: "ManufacturerCode", index: "ManufacturerCode", width: 100, key: true, align: "left" },
                            { name: "WaterWellCode", index: "WaterWellCode", width: 100, key: true, align: "left" },
                            { name: "GetDateTime", index: "GetDateTime", width: 140, key: true, align: "left" },
                            { name: "VoltageA", index: "VoltageA", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "VoltageB", index: "VoltageB", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "VoltageC", index: "VoltageC", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "CurrentA", index: "CurrentA", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "CurrentB", index: "CurrentB", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "CurrentC", index: "CurrentC", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "ActiveElectricalEnergy", index: "ActiveElectricalEnergy", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "NetAccumulatedCurrent", index: "NetAccumulatedCurrent", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "Pressure", index: "Pressure", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "InstantaneousFlow", index: "InstantaneousFlow", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "Turbidity", index: "Turbidity", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "Temperature", index: "Temperature", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "HeightOfLiquidLevel", index: "HeightOfLiquidLevel", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "Frequency", index: "Frequency", width: 100, key: true, formatter: 'number', align: "right" },
                            { name: "RunningState", index: "RunningState", width: 100, key: true, formatter: "select", editoptions: { value: "0:停止;1:启动;2:故障" }, align: "left" },
                            { name: "RunningStateDiscription", index: "RunningStateDiscription", width: 140, key: true },
                            { name: "SoftStarterFault", index: "SoftStarterFault", width: 100, key: true, formatter: "select", editoptions: { value: "0:正常;1:故障;" }, align: "left" },
                            { name: "SoftStarterFaultDiscription", index: "SoftStarterFaultDiscription", width: 140, key: true, align: "left" },
                            { name: "ThermalRelayTripFault", index: "ThermalRelayTripFault", width: 100, key: true, formatter: "select", editoptions: { value: "0:正常;1:故障;" }, align: "left" },
                            { name: "ThermalRelayTripFaultDiscription", index: "ThermalRelayTripFaultDiscription", width: 140, key: true, align: "left" },
                            { name: "BoxDoorAlarm", index: "BoxDoorAlarm", width: 120, key: true, formatter: "select", editoptions: { value: "0:开;1:关;" }, align: "left" }
                        ],
                        rowNum: 1000,
                        height: '100%'
                    });
            },
            gridComplete: function () {
                $gridTable.footerData('set', {
                    "Day": '合计',
                    MaxVoltageA: $gridTable.getCol('MaxVoltageA', false, 'max'),
                    MinVoltageA: $gridTable.getCol('MinVoltageA', false, 'min'),
                    AvgVoltageA: $gridTable.getCol('MinVoltageA', false, 'avg').toFixed(2),

                    MaxVoltageB: $gridTable.getCol('MaxVoltageB', false, 'max'),
                    MinVoltageB: $gridTable.getCol('MinVoltageB', false, 'min'),
                    AvgVoltageB: $gridTable.getCol('AvgVoltageB', false, 'avg').toFixed(2),

                    MaxVoltageC: $gridTable.getCol('MaxVoltageC', false, 'max'),
                    MinVoltageC: $gridTable.getCol('MinVoltageC', false, 'min'),
                    AvgVoltageC: $gridTable.getCol('AvgVoltageC', false, 'avg').toFixed(2),

                    MaxCurrentA: $gridTable.getCol('MaxCurrentA', false, 'max'),
                    MinCurrentA: $gridTable.getCol('MinCurrentA', false, 'min'),
                    AvgCurrentA: $gridTable.getCol('AvgCurrentA', false, 'avg').toFixed(2),

                    MaxCurrentB: $gridTable.getCol('MaxCurrentB', false, 'max'),
                    MinCurrentB: $gridTable.getCol('MinCurrentB', false, 'min'),
                    AvgCurrentB: $gridTable.getCol('AvgCurrentB', false, 'avg').toFixed(2),

                    MaxCurrentC: $gridTable.getCol('MaxCurrentC', false, 'max'),
                    MinCurrentC: $gridTable.getCol('MinCurrentC', false, 'min'),
                    AvgCurrentC: $gridTable.getCol('AvgCurrentC', false, 'avg').toFixed(2),

                    MaxActiveElectricalEnergy: $gridTable.getCol('MaxActiveElectricalEnergy', false, 'max'),
                    MinActiveElectricalEnergy: $gridTable.getCol('MinActiveElectricalEnergy', false, 'min'),
                    IncrementActiveElectricalEnergy: $gridTable.getCol('IncrementActiveElectricalEnergy', false, 'sum'),

                    MaxNetAccumulatedCurrent: $gridTable.getCol('MaxNetAccumulatedCurrent', false, 'max'),
                    MinNetAccumulatedCurrent: $gridTable.getCol('MinNetAccumulatedCurrent', false, 'min'),
                    IncrementNetAccumulatedCurrent: $gridTable.getCol('IncrementNetAccumulatedCurrent', false, 'sum'),


                    MaxPressure: $gridTable.getCol('MaxPressure', false, 'max'),
                    MinPressure: $gridTable.getCol('MinPressure', false, 'min'),
                    AvgPressure: $gridTable.getCol('AvgPressure', false, 'avg').toFixed(2),

                    MaxInstantaneousFlow: $gridTable.getCol('MaxInstantaneousFlow', false, 'max'),
                    MinInstantaneousFlow: $gridTable.getCol('MinInstantaneousFlow', false, 'min'),
                    AvgInstantaneousFlow: $gridTable.getCol('AvgInstantaneousFlow', false, 'avg').toFixed(2),

                    MaxTurbidity: $gridTable.getCol('MaxTurbidity', false, 'max'),
                    MinTurbidity: $gridTable.getCol('MinTurbidity', false, 'min'),
                    AvgTurbidity: $gridTable.getCol('AvgTurbidity', false, 'avg').toFixed(2),

                    MaxTemperature: $gridTable.getCol('MaxTemperature', false, 'max'),
                    MinTemperature: $gridTable.getCol('MinTemperature', false, 'min'),
                    AvgTemperature: $gridTable.getCol('AvgTemperature', false, 'avg').toFixed(2),

                    MaxHeightOfLiquidLevel: $gridTable.getCol('MaxHeightOfLiquidLevel', false, 'max'),
                    MinHeightOfLiquidLevel: $gridTable.getCol('MinHeightOfLiquidLevel', false, 'min'),
                    AvgHeightOfLiquidLevel: $gridTable.getCol('AvgHeightOfLiquidLevel', false, 'avg').toFixed(2),

                    MaxFrequency: $gridTable.getCol('MaxFrequency', false, 'max'),
                    MinFrequency: $gridTable.getCol('MinFrequency', false, 'min'),
                    AvgFrequency: $gridTable.getCol('AvgFrequency', false, 'avg').toFixed(2)
                });
            }
        });
        // 设置头部
        $gridTable.jqGrid('setGroupHeaders', {
            useColSpanStyle: true,
            groupHeaders: [
                { startColumnName: 'MaxVoltageA', numberOfColumns: 3, titleText: 'A相电压（V）' },
                { startColumnName: 'MaxVoltageB', numberOfColumns: 3, titleText: 'B相电压（V）' },
                { startColumnName: 'MaxVoltageC', numberOfColumns: 3, titleText: 'C相电压（V）' },

                { startColumnName: 'MaxCurrentA', numberOfColumns: 3, titleText: 'A相电流（A）' },
                { startColumnName: 'MaxCurrentB', numberOfColumns: 3, titleText: 'C相电流（A）' },
                { startColumnName: 'MaxCurrentC', numberOfColumns: 3, titleText: 'C相电流（A）' },

                { startColumnName: 'MaxActiveElectricalEnergy', numberOfColumns: 3, titleText: '有功电能' },

                { startColumnName: 'MaxNetAccumulatedCurrent', numberOfColumns: 3, titleText: '净累计流量' },

                { startColumnName: 'MaxPressure', numberOfColumns: 3, titleText: '压力' },

                { startColumnName: 'MaxInstantaneousFlow', numberOfColumns: 3, titleText: '瞬时流量' },

                { startColumnName: 'MaxTurbidity', numberOfColumns: 3, titleText: '浊度' },

                { startColumnName: 'MaxTemperature', numberOfColumns: 3, titleText: '温度' },

                { startColumnName: 'MaxHeightOfLiquidLevel', numberOfColumns: 3, titleText: '液位高度' },

                { startColumnName: 'MaxFrequency', numberOfColumns: 3, titleText: '泵频率' }
            ]
        })

    }
   function initControl() {
        $.ajax({
            type: "GET",
            url: "../../WaterWellManage/Device/SearchWaterWellName",//路径  
            data: {},
            success: function (result) { 
                if (result !== "") {
                    var data = JSON.parse(result);
                    var str = "";
                    $.map(data, function (item) {
                        str += "<li><a data-value=" + item.WaterWellId + ">" + item.WaterWellName.trim() + "</a></li>";
                    })
                    $("#query_menu").html(str);
                    //查询条件
                    $("#queryCondition .dropdown-menu li").click(function () {
                        var text = $(this).find('a').html();
                        var value = $(this).find('a').attr('data-value');
                        $("#queryCondition .dropdown-text").html(text).attr('data-value', value)
                    });
                }
            }
        });
    }

    // 查询测点
    function searchData() {
        var month = $("#report_month").val();
        var waterWellId = $("#queryCondition").find('.dropdown-text').attr('data-value')
        if (!waterWellId) {
           return alert("请选择测点！")
        }
        $("#pointGridTable").jqGrid('setGridParam', {
            postData: { waterWellId: waterWellId, month: month },
            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-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;">测点名称：
                                    </td>
                                    <td style="padding-left: 10px;">
                                        <div id="queryCondition" class="btn-group">
                                            <a class="btn btn-default dropdown-text" data-toggle="dropdown">选择测点</a>
                                            <a class="btn btn-default dropdown-toggle" data-toggle="dropdown"><span class="caret"></span></a>
                                            <ul id="query_menu" class="dropdown-menu">
                                            </ul>
                                        </div>
                                    </td>
                                    <td style="padding-left: 10px;">月份：
                                    </td>
                                    <td style="padding-left: 10px;">
                                        <input id="report_month" readonly type="text"  value="@LeaRun.Util.Time.GetToday().Split('-')[0]-@LeaRun.Util.Time.GetToday().Split('-')[1]" class="form-control input-wdatepicker" onfocus="WdatePicker({dateFmt:'yyyy-MM'})" style="width:175px">
                                    </td>
                                    <td style="padding-left: 10px;">
                                        <a id="btn_point_Search" class="btn btn-primary" onclick="searchData()">&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>