123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350 |
- @{
- 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()"> 查 询</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> 刷新</a>
-
- <a id="lr-export" class="btn btn-default" onclick="btn_point_export()"><i class="fa fa-sign-out"></i> 导出</a>
- </div>
- </div>
- </div>
- <div class="gridPanel" id="gridpanel">
- <table id="pointGridTable"></table>
- <div id="gridpager"></div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
|