123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131 |
- @{
- 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/GetRealTimeData",
- datatype: "json",
- height: $(window).height() - 138.5,
- autowidth: true,
- colModel: [
- { label: '主键', name: 'OrganizeId', hidden: true ,fixed: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: "NowRadingDT", width: 165, align: "right", formatter: "date", formatoptions: { srcformat: 'Y-m-d H:i:s', newformat: 'Y-m-d H:i:s' }, fixed: true },
- { label: "表地址", name: "ElecAddress", width: 150, align: "right", fixed: true },
- { label: "净累计(m³)", name: "NowReading", width: 150, align: "right", formatter: 'number', formatoptions: { decimalPlaces: 2, defaulValue: "", thousandsSeparator: "," }, fixed: true },
- {
- label: "阀门状态", name: "ValveStatus", width: 100, align: "left", sortable: false,
- formatter: function (cellvalue, options, rowObject) {
- if (cellvalue == "00") { return "开" }
- if (cellvalue == "01") { return "关" }
- if (cellvalue == "11") { return "异常" }
- }
- , fixed: true
- }
- ],
- viewrecords: true,
- rowNum: 30,
- rowList: [30, 50, 100],
- pager: "#gridPager",
- gridview: true,
- sortable: true,
- sortname: "NowRadingDT",
- sortorder: "desc",
- rownumbers: true,
- gridComplete: function () {
- $("#" + this.id).setSelection(selectedRowIndex, false);
- }
- });
- }
- 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> 查询</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-edit" class="btn btn-default" onclick="btn_export()"><i class="fa fa-file-excel-o"></i> 导出</a>
- </div>
- </div>
- </div>
- <div class="gridPanel">
- <table id="gridTable"></table>
- <div id="gridPager"></div>
- </div>
|