From 3ea3e6ac0db260b46aa262bc2ab33d8ab8860b86 Mon Sep 17 00:00:00 2001 From: hdw <496960745@qq.com> Date: 星期一, 29 十月 2018 14:36:24 +0800 Subject: [PATCH] Merge branch 'dev_lxw' of https://whychdw@gitlab.com/whyclxw1/gx_tieta.git into dev_lxw --- gx_tieta/src/com/fgkj/actions/Battinf_exAction.java | 31 + gx_tieta/src/com/fgkj/dao/impl/StationtrafficImpl.java | 167 +++++ gx_tieta/src/com/fgkj/actions/StationtrafficAction.java | 32 + gx_tieta/src/com/fgkj/services/Deverror_recordService.java | 46 + gx_tieta/src/com/fgkj/actions/Deverror_recordAction.java | 42 + gx_tieta/src/com/fgkj/dao/impl/Battinf_exImpl.java | 128 ++++ gx_tieta/src/com/fgkj/dto/Deverror_record.java | 113 +++ gx_tieta/.settings/org.jboss.tools.jst.web.xml | 68 +- gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java | 6 gx_tieta/src/com/fgkj/dto/Battinf_ex.java | 444 ++++++++++++++ gx_tieta/src/com/fgkj/services/StationtrafficService.java | 32 + gx_tieta/src/com/fgkj/dao/BaseDAO.java | 6 gx_tieta/src/com/fgkj/dto/Stationtraffic.java | 117 +++ gx_tieta/WebRoot/batt-traffic-statistics.jsp | 381 ++++++++++++ gx_tieta/src/com/fgkj/dao/impl/Deverror_recordImpl.java | 126 ++++ gx_tieta/src/com/fgkj/services/Battinf_exService.java | 31 + 16 files changed, 1,736 insertions(+), 34 deletions(-) diff --git a/gx_tieta/.settings/org.jboss.tools.jst.web.xml b/gx_tieta/.settings/org.jboss.tools.jst.web.xml index ab7f92f..7ad3e7b 100644 --- a/gx_tieta/.settings/org.jboss.tools.jst.web.xml +++ b/gx_tieta/.settings/org.jboss.tools.jst.web.xml @@ -9,73 +9,73 @@ <file-system NAME="classes" location="%workspace.home%/classes" model-entity="FileSystemFolder"/> <file-system NAME="fuguang" location="%eclipse.project%" model-entity="FileSystemFolder"/> <file-system NAME="lib-javaee.jar" - location="D:\Program Files\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\javaee.jar" model-entity="FileSystemJar"/> + location="D:\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\javaee.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-jsf-impl.jar" - location="D:\Program Files\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jsf-impl.jar" model-entity="FileSystemJar"/> + location="D:\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jsf-impl.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-jsf-api.jar" - location="D:\Program Files\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jsf-api.jar" model-entity="FileSystemJar"/> + location="D:\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jsf-api.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-jstl-1.2.jar" - location="D:\Program Files\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jstl-1.2.jar" model-entity="FileSystemJar"/> + location="D:\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jstl-1.2.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-c3p0-0.9.5.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\lib\c3p0-0.9.5.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\lib\c3p0-0.9.5.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-c3p0-oracle-thin-extras-0.9.5.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\lib\c3p0-oracle-thin-extras-0.9.5.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\lib\c3p0-oracle-thin-extras-0.9.5.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-mchange-commons-java-0.2.9.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\lib\mchange-commons-java-0.2.9.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\lib\mchange-commons-java-0.2.9.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-resources.jar" - location="D:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\resources.jar" model-entity="FileSystemJar"/> + location="D:\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\resources.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-dnsns.jar" - location="D:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\dnsns.jar" model-entity="FileSystemJar"/> + location="D:\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\dnsns.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-localedata.jar" - location="D:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\localedata.jar" model-entity="FileSystemJar"/> + location="D:\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\localedata.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-sunjce_provider.jar" - location="D:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\sunjce_provider.jar" model-entity="FileSystemJar"/> + location="D:\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\sunjce_provider.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-beanutils-1.7.0.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-beanutils-1.7.0.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-beanutils-1.7.0.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-codec-1.10.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-codec-1.10.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-codec-1.10.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-collections-3.1.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-collections-3.1.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-collections-3.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-dbcp-1.2.1.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-dbcp-1.2.1.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-dbcp-1.2.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-fileupload-1.2.2.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-fileupload-1.2.2.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-fileupload-1.2.2.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-io-2.0.1.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-io-2.0.1.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-io-2.0.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-lang-2.5.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-lang-2.5.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-lang-2.5.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-pool-1.2.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-pool-1.2.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-pool-1.2.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-dom4j-1.6.1.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\dom4j-1.6.1.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\dom4j-1.6.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-ezmorph-1.0.3.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\ezmorph-1.0.3.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\ezmorph-1.0.3.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-freemarker-2.3.16.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\freemarker-2.3.16.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\freemarker-2.3.16.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-gson-2.2.4.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\gson-2.2.4.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\gson-2.2.4.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-javassist-3.11.0.GA.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\javassist-3.11.0.GA.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\javassist-3.11.0.GA.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-json-lib-2.1-jdk15.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\json-lib-2.1-jdk15.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\json-lib-2.1-jdk15.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-mysql-connector-java-5.1.33-bin.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.33-bin.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.33-bin.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-ognl-3.0.1.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\ognl-3.0.1.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\ognl-3.0.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-poi-3.10.1-20140818.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\poi-3.10.1-20140818.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\poi-3.10.1-20140818.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-sqljdbc.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\sqljdbc.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\sqljdbc.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-struts2-core-2.2.3.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-core-2.2.3.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-core-2.2.3.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-struts2-json-plugin-2.2.3.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-json-plugin-2.2.3.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-json-plugin-2.2.3.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-struts2-sunspoter-stream-1.0.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-sunspoter-stream-1.0.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-sunspoter-stream-1.0.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-xwork-core-2.2.3.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\xwork-core-2.2.3.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\xwork-core-2.2.3.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-jacob.jar" - location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\jacob.jar" model-entity="FileSystemJar"/> + location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\jacob.jar" model-entity="FileSystemJar"/> <web SERVLET_VERSION="2.4" model-entity="JstWeb" model-path="/web.xml"> <module URI="/WEB-INF/faces-config.xml" model-entity="WebJSFModule" model-path="/faces-config.xml" src="src" web-root="WEB-ROOT"/> diff --git a/gx_tieta/WebRoot/batt-traffic-statistics.jsp b/gx_tieta/WebRoot/batt-traffic-statistics.jsp new file mode 100644 index 0000000..56a6455 --- /dev/null +++ b/gx_tieta/WebRoot/batt-traffic-statistics.jsp @@ -0,0 +1,381 @@ +<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> +<% +String path = request.getContextPath(); +String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; +%> +<%@ taglib uri="/struts-tags" prefix="s" %> +<!DOCTYPE HTML> +<html> + <head> + <base href="<%=basePath%>"> + + <title>娴侀噺缁熻</title> <!--娴侀噺缁熻--> + <meta charset="UTF-8"> + <meta name="viewport" content="width=device-width, initial-scale=1"> + <link href="css/basic.css" rel="stylesheet"> + <link rel="stylesheet" href="css/BrdwMaint.css"> + <link rel="stylesheet" type="text/css" href="css/loading.css"> + <link rel="stylesheet" type="text/css" href="css/dischargeplan_layout.css"> + <link rel="stylesheet" type="text/css" href="src/css/layui.css"> + <meta http-equiv="pragma" content="no-cache"> + <meta http-equiv="cache-control" content="no-cache"> + <meta http-equiv="expires" content="0"> + <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> + <meta http-equiv="description" content="This is my page"> + <style type="text/css"> + body { + overflow-x: hidden !important; + } + #tbHead table{ + width: 100%; + } + #tbBrdw { + overflow: auto; + } + #tbBrdw tbody tr:hover { + background-color: #DDDDDD; + } + #cardOption .con_table { + overflow: auto; + } + #tbBrdw table { + width: 100%; + } + #tbBrdw table i.fa-refresh { + font-size:18px; + cursor: pointer; + } + #cardOption input[type="checkbox"] { + vertical-align: middle; + } + #cardOption table thead input[type="checkbox"]{ + margin-left: 4px; + } + </style> + </head> + <body> + <!--澶撮儴鍐呭寮�濮�--> + <jsp:include page="Top.jsp" flush="true"/> + <!--澶撮儴鍐呭缁撴潫--> + <!--瀵艰埅寮�濮�--> + <jsp:include page="nav.jsp" flush="true"/> + <!-- 涓讳綋鍐呭 --> + <div id="main"> + <div id="eleInfor"> + <span class="summary">娴侀噺缁熻</span> + <div class="checkCon"> + <!-- 缁存姢鍖轰俊鎭� --> + <form action="" id="search_form"> + <table> + <tr class="fWeight"> + <td>鐪�</td> <!-- 鐪� --> + <td>甯�</td> <!-- 甯� --> + <td><s:text name="Computer_name"/></td> <!-- 鏈烘埧鍚嶇О --> + <td>缁熻鏂瑰紡</td> + <td colspan="2" style="width: 30%;">鏃堕棿娈�</td> + </tr> + <tr> + <td> + <select id="station_name1"> + + </select> + </td> + <td> + <select id="city"> + + </select> + </td> + <td> + <select id="station_name"> + </select> + </td> + <td> + <select> + <option>鎸夊勾缁熻</option> + <option>鎸夋湀缁熻</option> + <option>鎸夋棩缁熻</option> + </select> + </td> + <td><input type="text" id="startalm" readonly="readonly" name="bmd.adata.alm_start_time" value="2000-1-1" /></td> + <td><input type="text" id="endTalm" readonly="readonly" name="bmd.adata.alm_start_time1" /></td> + </tr> + </table> + </form> + </div> + </div> + <!-- 琛ㄦ牸鍥哄畾鐨勫ご閮� --> + <div id="tbHead"></div> + <!-- 琛ㄦ牸婊氬姩鐨勯儴鍒� --> + <div id="tbBrdw"></div> + + + + <!-- 鎸夐挳鍐呭 --> + <div id="paging"> + <span>鎬昏</span> + <span>5000</span> + </div> + </div> + + <!-- 鏁翠綋鐏拌壊閬僵灞� --> + <div id="allShade"></div> + <script type="text/javascript" src="js/loading.js"></script> + <script type="text/javascript" src="js/createTab.js"></script> + <script type="text/javascript" src="src/layui.js"></script> + + <script type="text/javascript" src="js/eleHistWarn1-jquery.ui.js"></script> + <script type="text/javascript"> + layui.use(['layer'], function() { + var layer = layui.layer; + var arrTh = new Array(); // 琛ㄦ牸鐨勫ご閮� + var arrTd = new Array(); // 琛ㄦ牸鐨勮〃浣� + var tblStatus = new Array(); // 琛ㄦ牸鐘舵�佹暟缁� + var tblOptsHd = new Array(); // 琛ㄦ牸閫夐」澶撮儴 + var tblOptsBd = new Array(); // 琛ㄦ牸閫夐」鏁扮粍 + arrTh = ['鏃堕棿娈�', '鏈烘埧鍚嶇О','娴侀噺','缁熻鏃堕棿']; + //arrTh = ['<s:text name="Maintenance_area"/>', '<s:text name="Computer_name"/>', '<s:text name="Nominal_capacity"/>(AH)', '<s:text name="Actual_capacity"/>(AH)','<s:text name="Residual_capacity"/>(AH)', '<s:text name="real_time"/><s:text name="Current"/>(A)', '<s:text name="Power_cut"/><s:text name="Endurance"/><s:text name="Time"/>']; + //tblOptsHd = ['缂栧彿', '閫夐」', '鏄惁閫夋嫨']; + tblOptsHd = ['<s:text name="Number"/>', '<s:text name="Options"/>', '<s:text name="IsChecked"/>']; + var tblHd = $('#tbHead'); + var tblBd = $('#tbBrdw'); + + // 鏍规嵁琛ㄦ牸鐨勫ご閮ㄧ敓鎴愯〃鏍奸�夐」鍜岃〃鏍肩殑鐘舵�佹暟缁� + $(function() { + centerDiv($('#cardOption')); + // 閬嶅巻琛ㄦ牸澶撮儴鐢熸垚鐘舵�佹暟缁� + for(var i = 0; i < arrTh.length; i++) { + tblStatus.push(1); + var temp = new Array(); + temp.push(i+1); + temp.push(arrTh[i]); + temp.push('<input type="checkbox" checked="checked"/>'); + + tblOptsBd.push(temp); + } + var cardHd = $('#cardOption .tbHead'); + var cardBd = $('#cardOption .con_table'); + createCard(cardHd, tblOptsHd, tblOptsBd); + createCard(cardBd, tblOptsHd, tblOptsBd); + }); + + // 鐢熸垚琛ㄦ牸 + $(function() { + for(i=0;i<5000;i++){arrTd.push(i)} + createAllTbl(tblHd, tblBd, arrTh, arrTd, tblStatus); + // 鐐瑰嚮琛ㄦ牸閫夐」鏄剧ず琛ㄦ牸閫夐」寮瑰嚭妗� + $('#paging .card-opt').click(function() { + var checkboxList = $('#cardOption .con_table table tbody').find('input[type="checkbox"]'); + // 鏍规嵁鐘舵�佹暟缁勪慨鏀硅〃鏍奸�夐」澶嶉�夋鐨勭姸鎬� + for(var i = 0; i < tblStatus.length; i++) { + if(tblStatus[i] == 1) { + checkboxList.eq(i).prop('checked', true); + }else{ + checkboxList.eq(i).prop('checked', false); + } + } + $('#cardOption').show(); + $('#allShade').show(); + }); + + // 鐐瑰嚮鍙栨秷鍜岀‘瀹氶殣钘忚〃鏍奸�夐」绐楀彛鍜岄伄缃╁眰 + $('#cardOption .en-card-opts').click(function() { + // 鏍规嵁琛ㄦ牸閫夐」鐨勫閫夋璁剧疆鐘舵�佹暟缁� + var checkboxList = $('#cardOption .con_table table tbody').find('input[type="checkbox"]'); + checkboxList.each(function(i) { + if($(this).is(':checked')) { + tblStatus[i] = 1; + }else{ + tblStatus[i] = 0; + } + }); + createAllTbl(tblHd, tblBd, arrTh, arrTd, tblStatus); + $('#cardOption').hide(); + $('#allShade').hide(); + }); + $('#cardOption .out-card-opts').click(function() { + $('#cardOption').hide(); + $('#allShade').hide(); + }); + }); + + // 鏍规嵁琛ㄦ牸鐨勭殑澶撮儴鐢熸垚 + $(function() { + $('#endtime').val(new Date().format('yyyy-MM-dd')); + }); + + // 鍒濆鍖栭〉闈㈤珮搴� + $(function() { + pageInit(); + $(window).resize(function() { + pageInit(); + }); + }); + + // 鍒濆鍖栭〉闈㈠唴瀹� + function pageInit() { + var winHt = $(window).height(); + var bodyHt = $('body').height(); + var tblHt = $('#tbBrdw').height(); + var shiftHt = winHt - bodyHt - 32; + if(shiftHt > 0) { + $('#tbBrdw').height(shiftHt + tblHt); + } + } + + // 鐢熸垚琛ㄦ牸鐨勫ご閮ㄥ拰琛ㄤ綋 + function createAllTbl (header, body, arrTh, arrTd, status) { + //console.info(status); + var newArrTh = new Array(); + var newArrTd = new Array(); + newArrTh = getArrTh(status, arrTh); + newArrTd = getArrTd(status, arrTd); + createTablenew(header, newArrTh, newArrTd); + createTablenew(body, newArrTh, newArrTd); + // 瀹氫箟琛ㄦ牸鐨勫ご閮ㄥ拰琛ㄤ綋瀹藉害涓�鑷� + var bdWidth = body.find('table').width(); + header.find('table').width(bdWidth); + } + + //瀵逛簬寮瑰嚭涓插彛杩涜瀹氫綅(position:fixed) + function centerDiv(ele){ + //鑾峰彇灞忓箷鐨勯珮搴﹀寮瑰嚭绐楀彛杩涜瀹氫綅 + var srnHei=$(window).height(); //灞忓箷鐨勯珮搴� + var eleHei=ele.height(); //寮瑰嚭绐楀彛鐨勯珮搴� + var topHei=parseInt((srnHei-eleHei)/2); //鑾峰彇灞呬腑楂樺害 + ele.css({ + 'top':topHei + }); + } + + + + + + + + // 鐪�-甯�-鏈烘埧-鐢垫睜缁� + $(document).ready(function(){ + //椤甸潰鍔犺浇鏃舵煡璇㈢淮鎶ゅ尯涓殑鏋㈢航绫诲瀷 + $.post("User_battgroup_baojigroup_battgroupAction!serchStationName1InGroup",null,function(data){ + data=data.result; + data=eval("("+data+")"); + //console.info(data); + if(data.code==1 && data.data.length>0){ + var $select = $("#station_name1"); + $select.text(''); + for(var i=0;i<=data.data.length;i++){ + $option=$("<option></option>"); + if(i==0){ + $option.html("<s:text name='All'/>(<s:text name='Common'/>"+data.data.length+"<s:text name='Species'/>)"); + $option.attr("value", ""); + }else{ + $option.text(data.data[i-1]); + $option.attr("value",data.data[i-1]); + } + $select.append($option); + } + }else{ + $("#station_name1").text('').html('<option>鏆傛棤绠$悊鐨勭淮鎶ゅ尯</option>'); + } + findCity(); + }); + }); + + function findCity() { + var data = { + StationName1: $("#station_name1").val() + }; + // 璇锋眰鑾峰彇褰撳墠鐪佷笅鐨勫競 + $.ajax({ + type: "post", + url: "BattInfAction!serchStationName2", + async:true, + dataType:'json', + data:"json = "+JSON.stringify(data), + success: function(data){ + var rs = JSON.parse(data.result); + var $select = $("#city"); + if(rs.code == 1) { + var _data= rs.data; + // 鏍规嵁鏁版嵁鏋勯�犵敓鎴愪笅鎷夊垪琛ㄧ殑鏁版嵁 + var optsList = []; + for(var i=0;i<_data.length;i++){ + var __data = _data[i]; + var tmp = getOptionsData(__data.StationName2, __data.StationName2, __data); + optsList.push(tmp); + } + // 鏍规嵁鏁版嵁鐢熸垚涓嬫媺鍒楄〃 + createOptions($select, optsList, true); + }else { + $select.text('').html('<option>鏆傛棤鍙祴甯�</option>'); + } + findStationNamebyStationname1(); + } + }); + } + //褰撶淮鎶ゅ尯鐨勫�煎彉鎹㈡椂鏇存柊甯� + $('#station_name1').change(function(){ + findCity(); + }); + //褰撶淮鎶ゅ尯鐨勫�煎彉鎹㈡椂鏇存柊鏈烘埧绔欑偣 + $('#city').change(function(){ + findStationNamebyStationname1(); + }); + + //鏍规嵁鐪侊紝甯傛煡璇㈢珯鐐� + function findStationNamebyStationname1(){ + findStationNamebyStationname1.stations = new Array(); + var tmp = { + StationName1:$("#station_name1").val(), + StationName2:$("#city").val() + }; + //var selectvalue=$("#station_name1 option:selected").val(); + //alert(selectvalue); + $.post("BattInfAction!serchStationName3","json="+JSON.stringify(tmp),function(data){ + var rs = JSON.parse(data.result); + if(rs.code==1){ + var _data = rs.data; + var $select = $("#station_name"); + // 鏍规嵁鏁版嵁鏋勯�犵敓鎴愪笅鎷夊垪琛ㄧ殑鏁版嵁 + var optsList = []; + for(var i=0;i<_data.length;i++){ + var __data = _data[i]; + //console.info(__data); + var _attr = { + StationId: __data.FBSDeviceId, + }; + var tmp = getOptionsData(__data.StationName3, __data.StationName, __data, _attr); + optsList.push(tmp); + } + findStationNamebyStationname1.stations = _data; + // 鏍规嵁鏁版嵁鐢熸垚涓嬫媺鍒楄〃 + createOptions($select, optsList, true); + }else{ + $("#station_name").text('').html('<option>鏆傛棤鍙祴鏈烘埧绔欑偣</option>'); + } + }); + } + }); + + + + + //鑾峰彇閫変腑鐨勬満鎴垮璞� + function getSelectStation(dev_id,arr){ + if(arr != undefined && arr.length > 0){ + for(var i=0;i<arr.length;i++){ + if(arr[i].FBSDeviceId == dev_id){ + return arr[i]; + } + } + } + return undefined; + } + + + + + + </script> + </body> +</html> \ No newline at end of file diff --git a/gx_tieta/src/com/fgkj/actions/Battinf_exAction.java b/gx_tieta/src/com/fgkj/actions/Battinf_exAction.java new file mode 100644 index 0000000..b0eddce --- /dev/null +++ b/gx_tieta/src/com/fgkj/actions/Battinf_exAction.java @@ -0,0 +1,31 @@ +package com.fgkj.actions; + +import com.fgkj.dto.BattInf; +import com.fgkj.dto.ServiceModel; +import com.fgkj.services.Battinf_exService; +import com.opensymphony.xwork2.ActionSupport; + +public class Battinf_exAction extends ActionUtil{ + private Battinf_exService service=new Battinf_exService(); + private String json; + private String result; + + + + //鏍规嵁鐢垫睜缁勭殑淇℃伅stationid鏌ヨ + public String serchByCondition(){ + BattInf binf=getGson().fromJson(json, BattInf.class); + ServiceModel model=service.serchByCondition(binf); + result=tojson(model); + return SUCCESS; + } + + public String getResult() { + return result; + } + public void setJson(String json) { + this.json = json; + } + + +} diff --git a/gx_tieta/src/com/fgkj/actions/Deverror_recordAction.java b/gx_tieta/src/com/fgkj/actions/Deverror_recordAction.java new file mode 100644 index 0000000..5b7b313 --- /dev/null +++ b/gx_tieta/src/com/fgkj/actions/Deverror_recordAction.java @@ -0,0 +1,42 @@ +package com.fgkj.actions; + +import java.util.List; + +import com.fgkj.dto.BattInf; +import com.fgkj.dto.Deverror_record; +import com.fgkj.dto.ServiceModel; +import com.fgkj.dto.User_inf; +import com.fgkj.services.Deverror_recordService; + +public class Deverror_recordAction extends ActionUtil{ + private Deverror_recordService service=new Deverror_recordService(); + private String json; + private String result; + //鐢ㄦ埛鎵嬪姩娣诲姞闂 + public String add(){ + Deverror_record dev_record=getGson("yyyy-MM-dd").fromJson(json, Deverror_record.class); + User_inf uinf=(User_inf) getUser(); + dev_record.setUid(uinf.getUId()); + ServiceModel model=service.add(dev_record); + result=tojson(model); + return SUCCESS; + } + //鏍规嵁stationid鏌ヨ璁惧鐨勯棶棰樿褰� + public String serchByCondition(){ + BattInf binf=getGson().fromJson(json, BattInf.class); + User_inf uinf=(User_inf) getUser(); + binf.setNum(uinf.getUId()); + ServiceModel model=service.serchByCondition(binf); + result=tojson(model); + return SUCCESS; + } + + public String getResult() { + return result; + } + public void setJson(String json) { + this.json = json; + } + + +} diff --git a/gx_tieta/src/com/fgkj/actions/StationtrafficAction.java b/gx_tieta/src/com/fgkj/actions/StationtrafficAction.java new file mode 100644 index 0000000..91f2c75 --- /dev/null +++ b/gx_tieta/src/com/fgkj/actions/StationtrafficAction.java @@ -0,0 +1,32 @@ +package com.fgkj.actions; + +import com.fgkj.dto.ServiceModel; +import com.fgkj.dto.Stationtraffic; +import com.fgkj.dto.User_inf; +import com.fgkj.services.StationtrafficService; + + +public class StationtrafficAction extends ActionUtil{ + private StationtrafficService service=new StationtrafficService(); + private String json; + private String result; + + + //缁熻鍩虹珯娴侀噺 + public String serchByCondition() { + Stationtraffic st=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, Stationtraffic.class); + User_inf uinf=(User_inf) getUser(); + st.setNote(uinf.getUId().toString()); + ServiceModel model=service.serchByCondition(st); + result=tojson(model); + return SUCCESS; + } + public String getResult() { + return result; + } + public void setJson(String json) { + this.json = json; + } + + +} diff --git a/gx_tieta/src/com/fgkj/dao/BaseDAO.java b/gx_tieta/src/com/fgkj/dao/BaseDAO.java index 812d302..5bbfbd7 100644 --- a/gx_tieta/src/com/fgkj/dao/BaseDAO.java +++ b/gx_tieta/src/com/fgkj/dao/BaseDAO.java @@ -188,6 +188,12 @@ public static final int ECHARTS_USR=92; + public static final int BATTINF_EX=93; + + public static final int DEVERROR_RECORD=94; + + public static final int STATIONTRAFFIC=95; + public boolean add(Object obj); // 娣诲姞 public boolean update(Object obj); // 鏇存柊 diff --git a/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java b/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java index e742d57..d3fafa5 100644 --- a/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java +++ b/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java @@ -31,6 +31,7 @@ import com.fgkj.dao.impl.Battalarm_dataDAOImpl; import com.fgkj.dao.impl.Battalarm_data_historyImpl; import com.fgkj.dao.impl.BattinfThirdImpl; +import com.fgkj.dao.impl.Battinf_exImpl; import com.fgkj.dao.impl.BattresdataDAOImpl; import com.fgkj.dao.impl.Battresdata_infDAOImpl; import com.fgkj.dao.impl.BatttestdataDAOImpl; @@ -42,12 +43,14 @@ import com.fgkj.dao.impl.CustompageImpl; import com.fgkj.dao.impl.Database_backupImpl; import com.fgkj.dao.impl.Dev_paramImpl; +import com.fgkj.dao.impl.Deverror_recordImpl; import com.fgkj.dao.impl.Devstate_usrImpl; import com.fgkj.dao.impl.Echarts_usrImpl; import com.fgkj.dao.impl.Fbsdev_Statechange_infImpl; import com.fgkj.dao.impl.MapImpl; import com.fgkj.dao.impl.Positiomap_usrImpl; import com.fgkj.dao.impl.Process_surveyImpl; +import com.fgkj.dao.impl.StationtrafficImpl; import com.fgkj.dao.impl.UserDAOImpl; import com.fgkj.dao.impl.User_ChartImpl; import com.fgkj.dao.impl.User_battgroup_baojigroupImpl; @@ -194,6 +197,9 @@ case 90:return new Fbs9100s_dfu_stateImpl(); case 91:return new Bts_station_eventImpl(); case 92:return new Echarts_usrImpl(); + case 93:return new Battinf_exImpl(); + case 94:return new Deverror_recordImpl(); + case 95:return new StationtrafficImpl(); default :return null; } } diff --git a/gx_tieta/src/com/fgkj/dao/impl/Battinf_exImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Battinf_exImpl.java new file mode 100644 index 0000000..cef1cbd --- /dev/null +++ b/gx_tieta/src/com/fgkj/dao/impl/Battinf_exImpl.java @@ -0,0 +1,128 @@ +package com.fgkj.dao.impl; + +import java.sql.ResultSet; +import java.sql.SQLException; +import java.util.ArrayList; +import java.util.List; + +import com.fgkj.dao.BaseDAO; +import com.fgkj.dao.CallBack; +import com.fgkj.dao.DAOHelper; +import com.fgkj.db.DBUtil; +import com.fgkj.dto.BattInf; +import com.fgkj.dto.Battinf_ex; + +public class Battinf_exImpl implements BaseDAO,CallBack{ + + public List getResults(ResultSet rs) { + // TODO Auto-generated method stub + return null; + } + + public boolean add(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public boolean update(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public boolean del(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public List searchAll() { + // TODO Auto-generated method stub + return null; + } + //鏍规嵁鐢垫睜缁勭殑淇℃伅stationid鏌ヨ + public List serchByCondition(Object obj) { + BattInf binf=(BattInf) obj; + String sql=" select * from db_battinf.tb_battinf_ex where stationId=? "; + List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getStationId()}, new CallBack() { + + public List getResults(ResultSet rs) { + List list=new ArrayList(); + try { + while(rs.next()){ + Battinf_ex binf_ex=new Battinf_ex(); + binf_ex.setNum(rs.getInt("num")); + binf_ex.setStationId(rs.getString("stationId")); + binf_ex.setFBSDeviceId(rs.getInt("fBSDeviceId")); + binf_ex.setStationName(rs.getString("stationName")); + binf_ex.setStationCode(rs.getString("stationCode")); + binf_ex.setStationRegion(rs.getString("stationRegion")); + binf_ex.setKeyWords(rs.getString("keyWords")); + binf_ex.setAffiliation(rs.getString("affiliation")); + binf_ex.setDataSources(rs.getString("dataSources")); + binf_ex.setStationType(rs.getString("stationType")); + binf_ex.setLongitude(rs.getDouble("longitude")); + binf_ex.setLatitude(rs.getInt("latitude")); + binf_ex.setStationAddr(rs.getString("stationAddr")); + binf_ex.setStationLevel(rs.getString("stationLevel")); + binf_ex.setMaintenanceState(rs.getString("maintenanceState")); + binf_ex.setBlockedState(rs.getString("blockedState")); + binf_ex.setMaintenanceCompany(rs.getString("maintenanceCompany")); + binf_ex.setBusinessScenario(rs.getString("businessScenario")); + binf_ex.setCoverScenario(rs.getString("coverScenario")); + binf_ex.setSiteTerrain(rs.getString("siteTerrain")); + binf_ex.setPropertyRights(rs.getString("propertyRights")); + binf_ex.setPropertyUnit(rs.getString("propertyUnit")); + binf_ex.setIsShare(rs.getString("isShare")); + binf_ex.setUseUnit(rs.getString("useUnit")); + binf_ex.setSiteCode(rs.getString("siteCode")); + binf_ex.setHistorySiteCode(rs.getString("historySiteCode")); + binf_ex.setSiteInternalNumber(rs.getString("siteInternalNumber")); + binf_ex.setSitePinyinReferred(rs.getString("sitePinyinReferred")); + binf_ex.setSiteChineseReferred(rs.getString("siteChineseReferred")); + binf_ex.setSiteMergeRecord(rs.getString("siteMergeRecord")); + binf_ex.setIsOpenBusiness(rs.getString("isOpenBusiness")); + binf_ex.setSchoolPersonnel(rs.getString("schoolPersonnel")); + binf_ex.setEntryTime(rs.getString("entryTime")); + binf_ex.setModifyPeople(rs.getString("modifyPeople")); + binf_ex.setModifyTime(rs.getString("modifyTime")); + binf_ex.setNote(rs.getString("note")); + binf_ex.setSiteReceivesMark(rs.getString("siteReceivesMark")); + binf_ex.setSiteValidity(rs.getString("siteValidity")); + binf_ex.setSiteNameCMCC(rs.getString("siteNameCMCC")); + binf_ex.setSiteNameCUCC(rs.getString("siteNameCUCC")); + binf_ex.setSiteNameCTC(rs.getString("siteNameCTC")); + binf_ex.setProducer(rs.getString("producer")); + binf_ex.setLastTimeLong(rs.getDouble("lastTimeLong")); + binf_ex.setLastTimeType(rs.getString("lastTimeType")); + binf_ex.setLastTimeDate(rs.getTimestamp("lastTimeDate")); + binf_ex.setShareInfo(rs.getString("shareInfo")); + binf_ex.setElectPowerCMCC(rs.getInt("electPowerCMCC")); + binf_ex.setElectPowerCUCC(rs.getInt("electPowerCUCC")); + binf_ex.setElectPowerCTC(rs.getInt("electPowerCTC")); + binf_ex.setIsCanElectPower(rs.getInt("isCanElectPower")); + binf_ex.setUpperStationRoute(rs.getDouble("upperStationRoute")); + binf_ex.setUpperStationDifficult(rs.getString("upperStationDifficult")); + binf_ex.setClienteleErrorService(rs.getString("clienteleErrorService")); + list.add(binf_ex); + } + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + return list; + } + }); + return list; + } + + public List serchByInfo(Object obj) { + // TODO Auto-generated method stub + return null; + } + public static void main(String[] args) { + Battinf_exImpl bimpl=new Battinf_exImpl(); + BattInf binf=new BattInf(); + binf.setStationId("42000001"); + List list=bimpl.serchByCondition(binf); + System.out.println(list.size()); + } +} diff --git a/gx_tieta/src/com/fgkj/dao/impl/Deverror_recordImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Deverror_recordImpl.java new file mode 100644 index 0000000..9f246b1 --- /dev/null +++ b/gx_tieta/src/com/fgkj/dao/impl/Deverror_recordImpl.java @@ -0,0 +1,126 @@ +package com.fgkj.dao.impl; + +import java.sql.Connection; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.util.ArrayList; +import java.util.List; + +import com.fgkj.dao.BaseDAO; +import com.fgkj.dao.CallBack; +import com.fgkj.dao.DAOHelper; +import com.fgkj.dao.LimitNumberFactory; +import com.fgkj.db.DBUtil; +import com.fgkj.dto.BattInf; +import com.fgkj.dto.Deverror_record; +import com.fgkj.dto.Page; + +public class Deverror_recordImpl implements BaseDAO,CallBack{ + + public List getResults(ResultSet rs) { + // TODO Auto-generated method stub + return null; + } + //鐢ㄦ埛鎵嬪姩娣诲姞闂 + public boolean add(Object obj) { + Deverror_record dev_record=(Deverror_record) obj; + String sql=" insert into db_battinf.tb_deverror_record(stationId,record_time,error_descript,uid) values(?,?,?,?)"; + boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{dev_record.getStationId(),dev_record.getRecord_time(),dev_record.getError_descript(),dev_record.getUid()}); + return bl; + } + + public boolean update(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public boolean del(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public List searchAll() { + // TODO Auto-generated method stub + return null; + } + //鏍规嵁stationid鏌ヨ璁惧鐨勯棶棰樿褰� + public List serchByCondition(Object obj) { + BattInf binf=(BattInf) obj; + Page p=binf.getPage(); + Connection conn=DBUtil.getConn(); + String numberSql=" SELECT FOUND_ROWS() number"; + String sql=" select SQL_CALC_FOUND_ROWS distinct tb_deverror_record.num,tb_deverror_record.stationid,record_time,error_descript,error_en " + + " ,db_battinf.tb_battinf.stationname,stationname1,stationname2,stationname3,stationname5 " + + " from db_battinf.tb_deverror_record,db_battinf.tb_battinf " + + " where tb_deverror_record.stationid=tb_battinf.stationid " + + " and tb_deverror_record.stationid like ? and stationname1 like ? and stationname2 like ? and stationname5 like ? " + + " and tb_deverror_record.uid=? and error_en=0 " ; + //鐢ㄦ埛绠$悊 + String userSql=" and db_battinf.tb_battinf.StationId in(" + + " select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=? "+ + " ) "; + sql+=userSql; + + String orderSql=" order by record_time desc "; + sql+=orderSql; + String limitSql=" limit ?,? "; + sql+=limitSql; + List<Deverror_record> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{"%"+binf.getStationId()+"%","%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName5()+"%",binf.getNum() + ,binf.getNum(),(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()}, new CallBack() { + + public List getResults(ResultSet rs) { + List list=new ArrayList(); + try { + while(rs.next()){ + Deverror_record dev_record=new Deverror_record(); + dev_record.setNum(rs.getInt("num")); + dev_record.setStationId(rs.getString("stationId")); + dev_record.setStationName(rs.getString("stationName")); + dev_record.setStationName1(rs.getString("stationName1")); + dev_record.setStationName2(rs.getString("stationName2")); + dev_record.setStationName3(rs.getString("stationName3")); + dev_record.setStationName5(rs.getString("stationName5")); + dev_record.setRecord_time(rs.getTimestamp("record_time")); + dev_record.setError_descript(rs.getString("error_descript")); + dev_record.setError_en(rs.getInt("error_en")); + Page page=new Page(); + dev_record.setPage(page); + list.add(dev_record); + } + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + return list; + } + }); + //鍘绘帀limit鏉′欢鍚庣殑鎬绘暟 + int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql); + if(list!=null&&list.size()>0){ + list.get(list.size()-1).getPage().setPageSize(number); + } + return list; + } + + public List serchByInfo(Object obj) { + // TODO Auto-generated method stub + return null; + } + public static void main(String[] args) { + Deverror_recordImpl dimpl=new Deverror_recordImpl(); + BattInf binf=new BattInf(); + binf.setNum(1002); + binf.setStationName(""); + binf.setStationName1(""); + binf.setStationName2(""); + binf.setStationName3(""); + binf.setStationName5(""); + binf.setStationId(""); + Page p=new Page(); + p.setPageCurr(1); + p.setPageSize(10); + binf.setPage(p); + dimpl.serchByCondition(binf); + } + +} diff --git a/gx_tieta/src/com/fgkj/dao/impl/StationtrafficImpl.java b/gx_tieta/src/com/fgkj/dao/impl/StationtrafficImpl.java new file mode 100644 index 0000000..4cbec20 --- /dev/null +++ b/gx_tieta/src/com/fgkj/dao/impl/StationtrafficImpl.java @@ -0,0 +1,167 @@ +package com.fgkj.dao.impl; + +import java.sql.ResultSet; +import java.sql.SQLException; +import java.text.ParseException; +import java.text.SimpleDateFormat; +import java.util.ArrayList; +import java.util.Calendar; +import java.util.Date; +import java.util.List; + +import com.fgkj.actions.ActionUtil; +import com.fgkj.dao.BaseDAO; +import com.fgkj.dao.CallBack; +import com.fgkj.dao.DAOHelper; +import com.fgkj.db.DBUtil; +import com.fgkj.dto.Stationtraffic; +import com.sun.org.apache.bcel.internal.generic.IINC; + +public class StationtrafficImpl implements BaseDAO,CallBack{ + + public List getResults(ResultSet rs) { + // TODO Auto-generated method stub + return null; + } + + public boolean add(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public boolean update(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public boolean del(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public List searchAll() { + // TODO Auto-generated method stub + return null; + } + //缁熻鍩虹珯娴侀噺 + public List serchByCondition(Object obj) { + final Stationtraffic straffic=(Stationtraffic) obj; + String sql=" select distinct tb_stationtraffic.num,dev_id,record_time,dayflow,nowflow" + + " ,tb_battinf.StationId,tb_battinf.stationName,tb_battinf.stationName1,tb_battinf.stationName2,tb_battinf.stationName3,tb_battinf.stationName5 " + + " from web_site.tb_stationtraffic,db_battinf.tb_battinf " + + " where web_site.tb_stationtraffic.dev_id=db_battinf.tb_battinf.fBSDeviceId " + + " and record_time>? and record_time<? " + + " and dev_id=? " ; + //鐢ㄦ埛绠$悊 + String userSql=" and db_battinf.tb_battinf.StationId in(" + + " select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=? "+ + " ) "; + sql+=userSql; + String orderSql=" order by dev_id,record_time asc "; + sql+=orderSql; + List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{straffic.getRecord_time(),straffic.getRecord_time1(),straffic.getDev_id(),Integer.parseInt(straffic.getNote())}, new CallBack() { + + public List getResults(ResultSet rs) { + List list=new ArrayList(); + // 鏃堕棿娈� + String perid_Time = ""; + Calendar now = Calendar.getInstance(); + int nowflow=0; + try { + while(rs.next()){ + + int nowflows=rs.getInt("nowflow"); + // 骞翠唤锛屽搴︼紝鏈堜唤 + Date dev_recordtime = rs.getTimestamp("record_time"); + // 鑾峰彇鍏蜂綋骞翠唤锛屾湀浠藉拰璇ユ湀鐨勬�诲ぉ鏁� + /*int year = dev_recordtime.getYear() + 1900; + int month = dev_recordtime.getMonth() + 1;*/ + now.setTime(dev_recordtime); + int year = now.get(Calendar.YEAR); + int month = now.get(Calendar.MONTH) + 1; // 0-based! + int day = now.get(Calendar.DAY_OF_MONTH); + //System.out.println(dev_recordtime+" "+day); + String perid_Times=""; + if(straffic.getNum()==1){//鏈堢粺璁� + perid_Times = ActionUtil.getFirstDayOfMonth(year, month - 1); + perid_Times += "~"; + perid_Times += ActionUtil.getLastDayOfMonth(year, month - 1); + }else if (straffic.getNum()==3) {// 鎸夊勾浠� + perid_Times = ActionUtil.getFirstDayOfMonth(year, 0); + perid_Times += "~"; + perid_Times += ActionUtil.getLastDayOfMonth(year, 11); + }else if(straffic.getNum()==2){ //鏃ョ粺璁� + perid_Times = ActionUtil.getDayTime(year, month-1, day, 1); + perid_Times += "~"; + perid_Times += ActionUtil.getDayTime(year, month-1, day, 4); + } + //System.out.println(perid_Times+" "+perid_Time+" "+nowflows); + if(perid_Times.equals(perid_Time)){ + nowflow+=nowflows; + }else{ + if(perid_Time.equals("")){ + perid_Time=perid_Times; + nowflow+=nowflows; + continue; + } + Stationtraffic st=new Stationtraffic(); + st.setDev_id(rs.getInt("dev_id")); + st.setNowflow(nowflow); + st.setStationName(rs.getString("stationName")); + st.setStationName1(rs.getString("stationName1")); + st.setStationName2(rs.getString("stationName2")); + st.setStationName3(rs.getString("stationName3")); + st.setStationName5(rs.getString("stationName5")); + st.setNote(perid_Time); + list.add(st); + nowflow=0; + nowflow+=nowflows; + perid_Time=perid_Times; + + } + if(rs.isLast()){ + Stationtraffic st=new Stationtraffic(); + st.setDev_id(rs.getInt("dev_id")); + st.setNowflow(nowflow); + st.setStationName(rs.getString("stationName")); + st.setStationName1(rs.getString("stationName1")); + st.setStationName2(rs.getString("stationName2")); + st.setStationName3(rs.getString("stationName3")); + st.setStationName5(rs.getString("stationName5")); + st.setNote(perid_Time); + list.add(st); + } + } + + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + return list; + } + }); + return list; + } + + public List serchByInfo(Object obj) { + // TODO Auto-generated method stub + return null; + } + public static void main(String[] args) throws ParseException { + StationtrafficImpl simpl=new StationtrafficImpl(); + SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + Date date1 = sdf.parse("2000-01-01 00:00:00"); + Date date2 = sdf.parse("2020-01-01 00:00:00"); + + Stationtraffic st=new Stationtraffic(); + st.setNum(3); + st.setDev_id(910000001); + st.setNote("1002"); + st.setRecord_time(ActionUtil.getSimpDate(date1)); + st.setRecord_time1(ActionUtil.getSimpDate(date2)); + List<Stationtraffic> list=simpl.serchByCondition(st); + for (Stationtraffic s : list) { + System.out.println(s); + } +} +} diff --git a/gx_tieta/src/com/fgkj/dto/Battinf_ex.java b/gx_tieta/src/com/fgkj/dto/Battinf_ex.java new file mode 100644 index 0000000..83ef2ec --- /dev/null +++ b/gx_tieta/src/com/fgkj/dto/Battinf_ex.java @@ -0,0 +1,444 @@ +package com.fgkj.dto; + +import java.io.Serializable; +import java.util.Date; + +public class Battinf_ex implements Serializable{ + private int num; + public String stationId; //鏈烘埧id + public int FBSDeviceId; //璁惧id + public String stationName; //鏈烘埧鍚嶇О + public String stationCode; //绔欏潃缂栫爜 * + public String stationRegion; //鎵�灞炲尯鍩� * + public String keyWords; //鍏抽敭瀛� * + public String affiliation; //鎵�灞炵粍缁� * + public String dataSources; //鏁版嵁鏉ユ簮 * + public String stationType; //绔欏潃绫诲瀷 * + public double longitude; //缁忓害 * + public double latitude; //绾害 * + public String stationAddr; //鎵�鍦ㄥ湴鍧� * + public String stationLevel; //绔欏潃绛夌骇 * + public String maintenanceState; //缁存姢鐘舵�� * + public String blockedState; //灏侀攣鐘舵�� * + public String maintenanceCompany; //缁存姢鍗曚綅 * + public String businessScenario; //涓氬姟鍦烘櫙 * + public String CoverScenario; //瑕嗙洊鍦烘櫙 * + public String siteTerrain; //绔欏潃鍦板舰 * + public String propertyRights; //浜ф潈鎬ц川 * + public String propertyUnit; //浜ф潈鍗曚綅 * + public String isShare; //鏄惁鍏变韩 * + public String useUnit; //浣跨敤鍗曚綅 * + public String siteCode; //鐗╃悊绔欏潃缂栫爜 * + public String historySiteCode; //鍘嗗彶鐗╃悊绔欏潃缂栫爜 * + public String siteInternalNumber; //绔欏潃鍐呴儴缂栧彿 * + public String sitePinyinReferred; //绔欏潃鎷奸煶绠�绉� * + public String siteChineseReferred; //涓枃绠�绉� * + public String siteMergeRecord; //绔欏潃鍚堝苟璁板綍 * + public String isOpenBusiness; //鏄惁寮�閫氫笟鍔� * + public String schoolPersonnel; //褰曞叆浜哄憳 * + public String entryTime; //褰曞叆鏃堕棿 * + public String modifyPeople; //淇敼浜� * + public String modifyTime; //淇敼鏃堕棿 * + public String note; //澶囨敞 * + public String siteReceivesMark; //绔欏潃鎺ユ敹鏍囪 * + public String siteValidity; //鏄惁鏈夋晥 * + public String siteNameCMCC; //绉诲姩绔欏潃鍚嶇О * + public String siteNameCUCC; //鑱旈�氱珯鍧�鍚嶇О * + public String siteNameCTC; //鐢典俊绔欏潃鍚嶇О * + + public String producer; //鐢熶骇鍘傚晢 * + /*public String battBrand; //鐢垫睜鍝佺墝 * + public String battModel; //鐢垫睜鍨嬪彿 + public String battCapStd; //鏍囩О瀹归噺 + + + + public int battCount; //鐢垫睜缁勬暟 + public int isElectLose; //鏄惁澶囩數涓嶈冻 + public int isUpError; //鏄惁鑴辨満涓婃姤寮傚父 + public int isNotElect; //鏄惁鐤戜技鏃犲鐢� +*/ public double lastTimeLong; //缁埅娴嬬畻鏃堕暱 + public String lastTimeType; //缁埅娴嬬畻绫诲埆 + public Date lastTimeDate; //缁埅鍙戠敓鏃堕棿 + + /*public String februaryOutTimeLong; //浜屾湀閫�鏈嶆椂闀� + public String marchOutTimeLong; //涓夋湀閫�鏈嶆椂闀� + public String aprilOutTimeLong; //鍥涙湀閫�鏈嶆椂闀� + public String mayOutTimeLong; //浜旀湀閫�鏈嶆椂闀� + public String februaryOutTimeCount; //浜屾湀閫�鏈嶆鏁� + public String marchOutTimeCount; //涓夋湀閫�鏈嶆鏁� + public String aprilOutTimeCount; //鍥涙湀閫�鏈嶆鏁� + public String mayOutTimeCount; //浜旀湀閫�鏈嶆鏁� +*/ + public String shareInfo; //鍏变韩鎯呭喌 + + public int electPowerCMCC; //绉诲姩鏄惁璐拱鍙戠數鏈嶅姟 + public int electPowerCUCC; //鑱旈�氭槸鍚﹁喘涔板彂鐢垫湇鍔� + public int electPowerCTC; //鐢典俊鏄惁璐拱鍙戠數鏈嶅姟 + public int isCanElectPower; //鏄惁鍏峰鍙戠數鏈嶅姟 + public double upperStationRoute; //涓婄珯璺▼ + public String upperStationDifficult; //涓婄珯闅炬槗绋嬪害 + public String clienteleErrorService; //瀹㈡埛闂搴撴湭瀹屾垚钃勭數姹犵淮淇� + /*public String verifyStationExist; //鍒嗗叕鍙告牳瀹炵珯鍧�鏄惁瀹為檯瀛樺湪 + public String verifyIsDisCharge; //鍒嗗叕鍙� 鏍稿疄2018骞存槸鍚﹀凡杩涜杩囩數姹犳暣娌� + public String devletOrAdd; //鍒犻櫎鎴栧鍔� + public String islastTime; //鏄惁鍦ㄧ數姹犵粍缁埅鑳藉姏鍐� + */ + public int getNum() { + return num; + } + public void setNum(int num) { + this.num = num; + } + public String getStationId() { + return stationId; + } + public void setStationId(String stationId) { + this.stationId = stationId; + } + public int getFBSDeviceId() { + return FBSDeviceId; + } + public void setFBSDeviceId(int fBSDeviceId) { + FBSDeviceId = fBSDeviceId; + } + public String getStationName() { + return stationName; + } + public void setStationName(String stationName) { + this.stationName = stationName; + } + public String getStationCode() { + return stationCode; + } + public void setStationCode(String stationCode) { + this.stationCode = stationCode; + } + public String getStationRegion() { + return stationRegion; + } + public void setStationRegion(String stationRegion) { + this.stationRegion = stationRegion; + } + public String getKeyWords() { + return keyWords; + } + public void setKeyWords(String keyWords) { + this.keyWords = keyWords; + } + public String getAffiliation() { + return affiliation; + } + public void setAffiliation(String affiliation) { + this.affiliation = affiliation; + } + public String getDataSources() { + return dataSources; + } + public void setDataSources(String dataSources) { + this.dataSources = dataSources; + } + public String getStationType() { + return stationType; + } + public void setStationType(String stationType) { + this.stationType = stationType; + } + public double getLongitude() { + return longitude; + } + public void setLongitude(double longitude) { + this.longitude = longitude; + } + public double getLatitude() { + return latitude; + } + public void setLatitude(double latitude) { + this.latitude = latitude; + } + public String getStationAddr() { + return stationAddr; + } + public void setStationAddr(String stationAddr) { + this.stationAddr = stationAddr; + } + public String getStationLevel() { + return stationLevel; + } + public void setStationLevel(String stationLevel) { + this.stationLevel = stationLevel; + } + public String getMaintenanceState() { + return maintenanceState; + } + public void setMaintenanceState(String maintenanceState) { + this.maintenanceState = maintenanceState; + } + public String getBlockedState() { + return blockedState; + } + public void setBlockedState(String blockedState) { + this.blockedState = blockedState; + } + public String getMaintenanceCompany() { + return maintenanceCompany; + } + public void setMaintenanceCompany(String maintenanceCompany) { + this.maintenanceCompany = maintenanceCompany; + } + public String getBusinessScenario() { + return businessScenario; + } + public void setBusinessScenario(String businessScenario) { + this.businessScenario = businessScenario; + } + public String getCoverScenario() { + return CoverScenario; + } + public void setCoverScenario(String coverScenario) { + CoverScenario = coverScenario; + } + public String getSiteTerrain() { + return siteTerrain; + } + public void setSiteTerrain(String siteTerrain) { + this.siteTerrain = siteTerrain; + } + public String getPropertyRights() { + return propertyRights; + } + public void setPropertyRights(String propertyRights) { + this.propertyRights = propertyRights; + } + public String getPropertyUnit() { + return propertyUnit; + } + public void setPropertyUnit(String propertyUnit) { + this.propertyUnit = propertyUnit; + } + public String getIsShare() { + return isShare; + } + public void setIsShare(String isShare) { + this.isShare = isShare; + } + public String getUseUnit() { + return useUnit; + } + public void setUseUnit(String useUnit) { + this.useUnit = useUnit; + } + public String getSiteCode() { + return siteCode; + } + public void setSiteCode(String siteCode) { + this.siteCode = siteCode; + } + public String getHistorySiteCode() { + return historySiteCode; + } + public void setHistorySiteCode(String historySiteCode) { + this.historySiteCode = historySiteCode; + } + public String getSiteInternalNumber() { + return siteInternalNumber; + } + public void setSiteInternalNumber(String siteInternalNumber) { + this.siteInternalNumber = siteInternalNumber; + } + public String getSitePinyinReferred() { + return sitePinyinReferred; + } + public void setSitePinyinReferred(String sitePinyinReferred) { + this.sitePinyinReferred = sitePinyinReferred; + } + public String getSiteChineseReferred() { + return siteChineseReferred; + } + public void setSiteChineseReferred(String siteChineseReferred) { + this.siteChineseReferred = siteChineseReferred; + } + public String getSiteMergeRecord() { + return siteMergeRecord; + } + public void setSiteMergeRecord(String siteMergeRecord) { + this.siteMergeRecord = siteMergeRecord; + } + public String getIsOpenBusiness() { + return isOpenBusiness; + } + public void setIsOpenBusiness(String isOpenBusiness) { + this.isOpenBusiness = isOpenBusiness; + } + public String getSchoolPersonnel() { + return schoolPersonnel; + } + public void setSchoolPersonnel(String schoolPersonnel) { + this.schoolPersonnel = schoolPersonnel; + } + public String getEntryTime() { + return entryTime; + } + public void setEntryTime(String entryTime) { + this.entryTime = entryTime; + } + public String getModifyPeople() { + return modifyPeople; + } + public void setModifyPeople(String modifyPeople) { + this.modifyPeople = modifyPeople; + } + public String getModifyTime() { + return modifyTime; + } + public void setModifyTime(String modifyTime) { + this.modifyTime = modifyTime; + } + public String getNote() { + return note; + } + public void setNote(String note) { + this.note = note; + } + public String getSiteReceivesMark() { + return siteReceivesMark; + } + public void setSiteReceivesMark(String siteReceivesMark) { + this.siteReceivesMark = siteReceivesMark; + } + public String getSiteValidity() { + return siteValidity; + } + public void setSiteValidity(String siteValidity) { + this.siteValidity = siteValidity; + } + public String getSiteNameCMCC() { + return siteNameCMCC; + } + public void setSiteNameCMCC(String siteNameCMCC) { + this.siteNameCMCC = siteNameCMCC; + } + public String getSiteNameCUCC() { + return siteNameCUCC; + } + public void setSiteNameCUCC(String siteNameCUCC) { + this.siteNameCUCC = siteNameCUCC; + } + public String getSiteNameCTC() { + return siteNameCTC; + } + public void setSiteNameCTC(String siteNameCTC) { + this.siteNameCTC = siteNameCTC; + } + public String getProducer() { + return producer; + } + public void setProducer(String producer) { + this.producer = producer; + } + public double getLastTimeLong() { + return lastTimeLong; + } + public void setLastTimeLong(double lastTimeLong) { + this.lastTimeLong = lastTimeLong; + } + public String getLastTimeType() { + return lastTimeType; + } + public void setLastTimeType(String lastTimeType) { + this.lastTimeType = lastTimeType; + } + public Date getLastTimeDate() { + return lastTimeDate; + } + public void setLastTimeDate(Date lastTimeDate) { + this.lastTimeDate = lastTimeDate; + } + public String getShareInfo() { + return shareInfo; + } + public void setShareInfo(String shareInfo) { + this.shareInfo = shareInfo; + } + public int getElectPowerCMCC() { + return electPowerCMCC; + } + public void setElectPowerCMCC(int electPowerCMCC) { + this.electPowerCMCC = electPowerCMCC; + } + public int getElectPowerCUCC() { + return electPowerCUCC; + } + public void setElectPowerCUCC(int electPowerCUCC) { + this.electPowerCUCC = electPowerCUCC; + } + public int getElectPowerCTC() { + return electPowerCTC; + } + public void setElectPowerCTC(int electPowerCTC) { + this.electPowerCTC = electPowerCTC; + } + public int getIsCanElectPower() { + return isCanElectPower; + } + public void setIsCanElectPower(int isCanElectPower) { + this.isCanElectPower = isCanElectPower; + } + public double getUpperStationRoute() { + return upperStationRoute; + } + public void setUpperStationRoute(double upperStationRoute) { + this.upperStationRoute = upperStationRoute; + } + public String getUpperStationDifficult() { + return upperStationDifficult; + } + public void setUpperStationDifficult(String upperStationDifficult) { + this.upperStationDifficult = upperStationDifficult; + } + public String getClienteleErrorService() { + return clienteleErrorService; + } + public void setClienteleErrorService(String clienteleErrorService) { + this.clienteleErrorService = clienteleErrorService; + } + @Override + public String toString() { + return "Battinf_ex [num=" + num + ", stationId=" + stationId + + ", FBSDeviceId=" + FBSDeviceId + ", stationName=" + + stationName + ", stationCode=" + stationCode + + ", stationRegion=" + stationRegion + ", keyWords=" + keyWords + + ", affiliation=" + affiliation + ", dataSources=" + + dataSources + ", stationType=" + stationType + ", longitude=" + + longitude + ", latitude=" + latitude + ", stationAddr=" + + stationAddr + ", stationLevel=" + stationLevel + + ", maintenanceState=" + maintenanceState + ", blockedState=" + + blockedState + ", maintenanceCompany=" + maintenanceCompany + + ", businessScenario=" + businessScenario + ", CoverScenario=" + + CoverScenario + ", siteTerrain=" + siteTerrain + + ", propertyRights=" + propertyRights + ", propertyUnit=" + + propertyUnit + ", isShare=" + isShare + ", useUnit=" + + useUnit + ", siteCode=" + siteCode + ", historySiteCode=" + + historySiteCode + ", siteInternalNumber=" + + siteInternalNumber + ", sitePinyinReferred=" + + sitePinyinReferred + ", siteChineseReferred=" + + siteChineseReferred + ", siteMergeRecord=" + siteMergeRecord + + ", isOpenBusiness=" + isOpenBusiness + ", schoolPersonnel=" + + schoolPersonnel + ", entryTime=" + entryTime + + ", modifyPeople=" + modifyPeople + ", modifyTime=" + + modifyTime + ", note=" + note + ", siteReceivesMark=" + + siteReceivesMark + ", siteValidity=" + siteValidity + + ", siteNameCMCC=" + siteNameCMCC + ", siteNameCUCC=" + + siteNameCUCC + ", siteNameCTC=" + siteNameCTC + ", producer=" + + producer + ", lastTimeLong=" + lastTimeLong + + ", lastTimeType=" + lastTimeType + ", lastTimeDate=" + + lastTimeDate + ", shareInfo=" + shareInfo + + ", electPowerCMCC=" + electPowerCMCC + ", electPowerCUCC=" + + electPowerCUCC + ", electPowerCTC=" + electPowerCTC + + ", isCanElectPower=" + isCanElectPower + + ", upperStationRoute=" + upperStationRoute + + ", upperStationDifficult=" + upperStationDifficult + + ", clienteleErrorService=" + clienteleErrorService + "]"; + } + +} diff --git a/gx_tieta/src/com/fgkj/dto/Deverror_record.java b/gx_tieta/src/com/fgkj/dto/Deverror_record.java new file mode 100644 index 0000000..b43f6d9 --- /dev/null +++ b/gx_tieta/src/com/fgkj/dto/Deverror_record.java @@ -0,0 +1,113 @@ +package com.fgkj.dto; + +import java.io.Serializable; +import java.util.Date; + + +public class Deverror_record implements Serializable{ + private int num; + private String stationId; + private String stationName; + private String stationName1; + private String stationName2; + private String stationName3; + private String stationName5; + private Date record_time; + private String error_descript;//闂鎻忚堪 + private int uid; + private int error_en; //闂鏄惁瑙e喅 + private String note; + private Page page; + public int getNum() { + return num; + } + public void setNum(int num) { + this.num = num; + } + + public String getStationId() { + return stationId; + } + public void setStationId(String stationId) { + this.stationId = stationId; + } + public String getStationName() { + return stationName; + } + public void setStationName(String stationName) { + this.stationName = stationName; + } + public String getStationName1() { + return stationName1; + } + public void setStationName1(String stationName1) { + this.stationName1 = stationName1; + } + public String getStationName2() { + return stationName2; + } + public void setStationName2(String stationName2) { + this.stationName2 = stationName2; + } + public String getStationName3() { + return stationName3; + } + public void setStationName3(String stationName3) { + this.stationName3 = stationName3; + } + public String getStationName5() { + return stationName5; + } + public void setStationName5(String stationName5) { + this.stationName5 = stationName5; + } + public Date getRecord_time() { + return record_time; + } + public void setRecord_time(Date record_time) { + this.record_time = record_time; + } + public String getError_descript() { + return error_descript; + } + public void setError_descript(String error_descript) { + this.error_descript = error_descript; + } + public int getUid() { + return uid; + } + public void setUid(int uid) { + this.uid = uid; + } + public int getError_en() { + return error_en; + } + public void setError_en(int error_en) { + this.error_en = error_en; + } + public String getNote() { + return note; + } + public void setNote(String note) { + this.note = note; + } + public Page getPage() { + return page; + } + public void setPage(Page page) { + this.page = page; + } + @Override + public String toString() { + return "Deverror_record [num=" + num + ", stationId=" + stationId + + ", stationName=" + stationName + ", stationName1=" + + stationName1 + ", stationName2=" + stationName2 + + ", stationName3=" + stationName3 + ", stationName5=" + + stationName5 + ", record_time=" + record_time + + ", error_descript=" + error_descript + ", uid=" + uid + + ", error_en=" + error_en + ", note=" + note + ", page=" + + page + "]"; + } + + +} diff --git a/gx_tieta/src/com/fgkj/dto/Stationtraffic.java b/gx_tieta/src/com/fgkj/dto/Stationtraffic.java new file mode 100644 index 0000000..e117a16 --- /dev/null +++ b/gx_tieta/src/com/fgkj/dto/Stationtraffic.java @@ -0,0 +1,117 @@ +package com.fgkj.dto; + +import java.io.Serializable; +import java.util.Date; + +public class Stationtraffic implements Serializable{ + private int num; + private int dev_id; + private Date record_time; + private Date record_time1; + private int dayflow; + private int nowflow; + private String note; + + private String stationName; + private String stationName1; + private String stationName2; + private String stationName3; + private String stationName5; + + private Page page; + + public int getNum() { + return num; + } + public void setNum(int num) { + this.num = num; + } + public int getDev_id() { + return dev_id; + } + public void setDev_id(int dev_id) { + this.dev_id = dev_id; + } + public Date getRecord_time() { + return record_time; + } + public void setRecord_time(Date record_time) { + this.record_time = record_time; + } + + public Date getRecord_time1() { + return record_time1; + } + public void setRecord_time1(Date record_time1) { + this.record_time1 = record_time1; + } + public int getDayflow() { + return dayflow; + } + public void setDayflow(int dayflow) { + this.dayflow = dayflow; + } + public int getNowflow() { + return nowflow; + } + public void setNowflow(int nowflow) { + this.nowflow = nowflow; + } + public String getNote() { + return note; + } + public void setNote(String note) { + this.note = note; + } + public String getStationName() { + return stationName; + } + public void setStationName(String stationName) { + this.stationName = stationName; + } + public String getStationName1() { + return stationName1; + } + public void setStationName1(String stationName1) { + this.stationName1 = stationName1; + } + public String getStationName2() { + return stationName2; + } + public void setStationName2(String stationName2) { + this.stationName2 = stationName2; + } + public String getStationName3() { + return stationName3; + } + public void setStationName3(String stationName3) { + this.stationName3 = stationName3; + } + public String getStationName5() { + return stationName5; + } + public void setStationName5(String stationName5) { + this.stationName5 = stationName5; + } + public Page getPage() { + return page; + } + public void setPage(Page page) { + this.page = page; + } + @Override + public String toString() { + return "Stationtraffic [num=" + num + ", dev_id=" + dev_id + + ", record_time=" + record_time + ", record_time1=" + + record_time1 + ", dayflow=" + dayflow + ", nowflow=" + + nowflow + ", note=" + note + ", stationName=" + stationName + + ", stationName1=" + stationName1 + ", stationName2=" + + stationName2 + ", stationName3=" + stationName3 + + ", stationName5=" + stationName5 + ", page=" + page + "]"; + } + + + + + +} diff --git a/gx_tieta/src/com/fgkj/services/Battinf_exService.java b/gx_tieta/src/com/fgkj/services/Battinf_exService.java new file mode 100644 index 0000000..7616c90 --- /dev/null +++ b/gx_tieta/src/com/fgkj/services/Battinf_exService.java @@ -0,0 +1,31 @@ +package com.fgkj.services; + +import java.util.List; + +import com.fgkj.dao.BaseDAO; +import com.fgkj.dao.BaseDAOFactory; +import com.fgkj.dto.ServiceModel; + +public class Battinf_exService { + private ServiceModel model; + private BaseDAO dao; + public Battinf_exService() { + super(); + model=new ServiceModel(); + dao=BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF_EX); + } + //鏍规嵁鐢垫睜缁勭殑淇℃伅stationid鏌ヨ + public ServiceModel serchByCondition(Object obj){ + List list=dao.serchByCondition(obj); + if (list!=null&&list.size()>0) { + model.setCode(1); + model.setData(list); + model.setMsg("鏌ヨ鎴愬姛!"); + } else { + model.setCode(0); + model.setMsg("鏌ヨ澶辫触!"); + } + return model; + } + +} diff --git a/gx_tieta/src/com/fgkj/services/Deverror_recordService.java b/gx_tieta/src/com/fgkj/services/Deverror_recordService.java new file mode 100644 index 0000000..3b03f10 --- /dev/null +++ b/gx_tieta/src/com/fgkj/services/Deverror_recordService.java @@ -0,0 +1,46 @@ +package com.fgkj.services; + +import java.util.List; + +import com.fgkj.dao.BaseDAO; +import com.fgkj.dao.BaseDAOFactory; +import com.fgkj.dto.ServiceModel; + +public class Deverror_recordService { + private ServiceModel model; + private BaseDAO dao; + + public Deverror_recordService() { + super(); + model=new ServiceModel(); + dao=BaseDAOFactory.getBaseDAO(BaseDAO.DEVERROR_RECORD); + + } + //鐢ㄦ埛鎵嬪姩娣诲姞闂 + public ServiceModel add(Object obj){ + boolean bl=dao.add(obj); + if (bl) { + model.setCode(1); + model.setMsg("娣诲姞鎴愬姛!"); + } else { + model.setCode(0); + model.setMsg("娣诲姞澶辫触!"); + } + return model; + } + //鏍规嵁stationid鏌ヨ璁惧鐨勯棶棰樿褰� + public ServiceModel serchByCondition(Object obj){ + List list=dao.serchByCondition(obj); + if (list!=null&&list.size()>0) { + model.setCode(1); + model.setData(list); + model.setMsg("鏌ヨ鎴愬姛!"); + } else { + model.setCode(0); + model.setMsg("鏌ヨ澶辫触!"); + } + return model; + } + + +} diff --git a/gx_tieta/src/com/fgkj/services/StationtrafficService.java b/gx_tieta/src/com/fgkj/services/StationtrafficService.java new file mode 100644 index 0000000..c30b6c7 --- /dev/null +++ b/gx_tieta/src/com/fgkj/services/StationtrafficService.java @@ -0,0 +1,32 @@ +package com.fgkj.services; + +import java.util.List; + +import com.fgkj.dao.BaseDAO; +import com.fgkj.dao.BaseDAOFactory; +import com.fgkj.dto.ServiceModel; + +public class StationtrafficService { + private BaseDAO dao; + private ServiceModel model; + public StationtrafficService() { + super(); + dao=BaseDAOFactory.getBaseDAO(BaseDAO.STATIONTRAFFIC); + model=new ServiceModel(); + } + //缁熻鍩虹珯娴侀噺 + public ServiceModel serchByCondition(Object obj) { + List list=dao.serchByCondition(obj); + if(list!=null&&list.size()>0){ + model.setCode(1); + model.setData(list); + model.setMsg("鏌ヨ鎴愬姛!"); + }else{ + model.setCode(0); + model.setMsg("鏌ヨ澶辫触!"); + } + return model; + } + + +} -- Gitblit v1.9.1