123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201 |
- @{
- ViewBag.Title = "用水异常查询";
- Layout = "~/Views/Shared/_LayoutIndex.cshtml";
- }
- <script>
- var checkedIds = [];
- $(document).ready(function () {
- initialPage();
- GetGrid();
- GetTree();
- //表格表头居中显示
- $(".ui-th-column").css("text-align", "center");
- });
- //重设(表格)宽高
- function initialPage() {
- //layout布局
- $('#layout').layout({
- applyDemoStyles: true,
- onresize: function () {
- $(window).resize();
- }
- });
- //resize重设(表格、树形)宽高
- $(window).resize(function (e) {
- window.setTimeout(function () {
- $('#gridTable').setGridWidth(($('.gridPanel').width()));
- $("#gridTable").setGridHeight($(window).height() - 108.5);
- }, 200);
- e.stopPropagation();
- });
- }
- function GetTree() {
- var item = {
- height: $(window).height() - 52,
- url: "/NBManage/NBAreas/GetAreaTreeJson",
- isexpand: true,
- onnodeclick: function (item) {
- //ReloadData();
- }
- };
- //初始化
- $("#itemTree").treeview(item);
- }
- function getNodes() {
- checkedIds = [];
- var nodes = $("#itemTree").getTSNs(true);//获取所有勾选节点包括半勾选
- $.each(nodes, function (i, value) {
- var id = value.id;
- //如果是测点ID 则加入
- if (id.indexOf("level1_") != -1) {
- checkedIds.push(id.substring(7));
- }
- });
- }
- //加载表格
- function GetGrid() {
- var selectedRowIndex = 0;
- var $gridTable = $('#gridTable');
- $gridTable.jqGrid({
- url: "/NBManage/NBWaterUseAbnormality/GetRecordJson",
- datatype: "json",
- height: $(window).height() - 138.8,
- autowidth: true,
- mtype:"post",
- colModel: [
- { label: '主键', name: 'OrganizeId', hidden: true },
- { label: "区域名称", name: "AreaInfo", width: 200, align: "left", sortable: false },
- { label: "用户编号", name: "UserNo", width: 150, align: "left", sortable: false },
- { label: "用户名称", name: "UserName", width: 150, align: "left", sortable: false },
- { label: "门牌号", name: "HouseNo", width: 100, align: "left", sortable: false },
- { label: "表类型", name: "MeterType", width: 100, align: "left", sortable: false },
- { label: "IMEI", name: "MeterIMEI", width: 200, align: "right", sortable: false },
- { label: "起数(m³)", name: "StartReading", width: 200, align: "right", sortable: false, formatter: 'number', formatoptions: { decimalPlaces: 2, defaulValue: "", thousandsSeparator: "," } },
- { label: "止数(m³)", name: "EndReading", width: 200, align: "right", sortable: false, formatter: 'number', formatoptions: { decimalPlaces: 2, defaulValue: "", thousandsSeparator: "," } },
- { label: "用量(m³)", name: "WaterUsed", width: 200, align: "right", sortable: false, formatter: 'number', formatoptions: { decimalPlaces: 2, defaulValue: "", thousandsSeparator: "," } }
- ],
- viewrecords: true,
- rowNum: 30,
- rowList: [30, 50, 100],
- pager: "#gridPager",
- rownumbers: true,
- shrinkToFit: false,
- gridview: true,
- gridComplete: function () {
- $("#" + this.id).setSelection(selectedRowIndex, false);
- }
- });
- //$gridTable.authorizeColModel();
- //查询条件设置
- }
-
- function btn_Search() {
- getNodes();
- var thisDate = $('#ThisDate').val();
- var lastDate = $('#LastDate').val();
- var moreUsed = $("#moreUsed").val();
- var lessUsed = $("#lessUsed").val();
- if (isNotNull(thisDate)) {
- dialogMsg("开始日期不能为空", -1);
- return;
- }
- if (isNotNull(lastDate)) {
- dialogMsg("结束日期不能为空", -1);
- return;
- }
- if (isNotNull(moreUsed) && isNotNull(lessUsed)) {
- dialogMsg("用量大于和用量小于不能同时为空", -1);
- return;
- }
- if (!isNotNull(moreUsed) && !isNotNull(lessUsed)) {
- dialogMsg("用量大于和用量小于不能同时查询", -1);
- return;
- }
- $("#gridTable").jqGrid('setGridParam', {
- postData: {
- areaId: checkedIds.toString(),
- lastDate: lastDate,
- thisDate: thisDate,
- moreUsed: moreUsed,
- lessUsed: lessUsed
- }
- }).trigger('reloadGrid');
- }
- function isNotNull(obj) {
- obj = $.trim(obj);
- if (obj.length == 0 || obj == null || obj == undefined) {
- return true;
- }
- else
- return false;
- }
- //导出
- 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="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="titlePanel">
- <div class="title-search">
- <table>
- <tr>
- <td>开始日期</td>
- <td>
- <input id="ThisDate" type="text" class="form-control input-wdatepicker" onfocus="WdatePicker()" value="@LeaRun.Util.Time.GetDate(-30)" />
- </td>
- <td>结束日期</td>
- <td>
- <input id="LastDate" type="text" class="form-control input-wdatepicker" onfocus="WdatePicker()" value="@LeaRun.Util.Time.GetDate(0)" />
- </td>
- <td>用量大于</td>
- <td>
- <input id="moreUsed" type="text" class="form-control " />
- </td>
- <td>用量小于</td>
- <td>
- <input id="lessUsed" type="text" class="form-control " />
- </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>
- </div>
- </div>
- </div>
|