展示首页
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/3b8173bb5d592910c95a39ff25774660.png)
增加
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/f41e47d403bc5e816c6a1258b2bab712.png)
修改
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/d96f05d147abaacfbfd97268e0455a80.png)
审核
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/3102fd449092a9ef4ef7204aefdffe9d.png)
jsp页面部分
添加模块
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<html>
<!--<![endif]-->
<!-- BEGIN HEAD -->
<head>
<meta charset="utf-8" />
<title>服务企业维护</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta content="width=device-width, initial-scale=1" name="viewport" />
<meta content="" name="description" />
<meta content="" name="author" />
<link
href="<%=basePath%>assets/global/plugins/font-awesome/css/font-awesome.min.css"
rel="stylesheet" type="text/css" />
<%-- <link href="<%=basePath%>assets/global/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" /> 2018年11月4日14:54:37 --%>
<link
href="<%=basePath%>assets/global/plugins/bootstrap/css/bootstrap.min.css"
rel="stylesheet" type="text/css" />
<%-- <link href="<%=basePath%>assets/global/plugins/uniform/css/uniform.default.css" rel="stylesheet" type="text/css" /> 2018年11月4日15:10:56--%>
<%-- <link href="<%=basePath%>assets/global/plugins/bootstrap-switch/css/bootstrap-switch.min.css" rel="stylesheet" type="text/css" /> --%>
<link href="<%=basePath%>assets/global/css/components.min.css"
rel="stylesheet" id="style_components" type="text/css" />
<link href="<%=basePath%>assets/global/css/plugins.min.css"
rel="stylesheet" type="text/css" />
<%-- <link href="<%=basePath%>assets/apps/css/inbox.min.css" rel="stylesheet" type="text/css" /> 2018年11月4日14:55:10 --%>
<link href="<%=basePath%>assets/layouts/layout4/css/layout.min.css"
rel="stylesheet" type="text/css" />
<link
href="<%=basePath%>assets/layouts/layout4/css/themes/light.min.css"
rel="stylesheet" type="text/css" id="style_color" />
<%-- <link href="<%=basePath%>assets/layouts/layout4/css/custom.min.css" rel="stylesheet" type="text/css" />2018年11月4日15:08:19 --%>
<link rel="shortcut icon" href="favicon.ico" />
<link
href="<%=basePath%>assets/global/plugins/jstree/dist/themes/default/style.min.css"
rel="stylesheet" type="text/css" />
<script src="<%=basePath%>assets/global/plugins/jquery.min.js"
type="text/javascript"></script>
<script
src="<%=basePath%>assets/global/plugins/bootstrap/js/bootstrap.min.js"
type="text/javascript"></script>
<%-- <script src="<%=basePath%>assets/global/plugins/bootstrap-hover-dropdown/bootstrap-hover-dropdown.min.js" type="text/javascript"></script> 2018年11月4日15:09:00--%>
<%-- <script src="<%=basePath%>assets/global/plugins/uniform/jquery.uniform.min.js" type="text/javascript"></script> 2018年11月4日15:11:33--%>
<%-- <script src="<%=basePath%>assets/global/plugins/bootstrap-switch/js/bootstrap-switch.min.js" type="text/javascript"></script>2018年11月4日15:08:44 --%>
<script src="<%=basePath%>assets/global/scripts/app.min.js"
type="text/javascript"></script>
<%-- <script src="<%=basePath%>assets/apps/scripts/inbox.min.js" type="text/javascript"></script> 2018年11月4日15:05:28--%>
<%-- <script src="<%=basePath%>assets/layouts/layout4/scripts/layout.min.js" type="text/javascript"></script> 2018年11月4日15:06:16--%>
<%-- <script src="<%=basePath%>assets/layouts/layout4/scripts/demo.min.js" type="text/javascript"></script>2018年11月4日15:06:26 --%>
<%-- <script src="<%=basePath%>assets/layouts/global/scripts/quick-sidebar.min.js" type="text/javascript"></script>2018年11月4日15:06:42 --%>
<script
src="<%=basePath%>assets/global/plugins/bootstrap-hover-dropdown/bootstrap-hover-dropdown.min.js"
type="text/javascript"></script>
<script
src="<%=basePath%>assets/global/plugins/uniform/jquery.uniform.min.js"
type="text/javascript"></script>
<%-- <script src="<%=basePath%>assets/global/plugins/bootstrap-switch/js/bootstrap-switch.min.js" type="text/javascript"></script> --%>
<!-- END CORE PLUGINS -->
<!-- BEGIN THEME GLOBAL SCRIPTS -->
<script src="<%=basePath%>assets/global/scripts/app.min.js"
type="text/javascript"></script>
<!-- END THEME GLOBAL SCRIPTS -->
<!-- BEGIN PAGE LEVEL SCRIPTS -->
<script src="<%=basePath%>assets/apps/scripts/inbox.min.js"
type="text/javascript"></script>
<!-- END PAGE LEVEL SCRIPTS -->
<!-- BEGIN THEME LAYOUT SCRIPTS -->
<script src="<%=basePath%>assets/layouts/layout4/scripts/layout.min.js"
type="text/javascript"></script>
<%-- <script src="<%=basePath%>assets/layouts/layout4/scripts/demo.min.js" type="text/javascript"></script> --%>
<%-- <script src="<%=basePath%>assets/layouts/global/scripts/quick-sidebar.min.js" type="text/javascript"></script> --%>
<!-- END THEME LAYOUT SCRIPTS -->
<!-- BEGIN PAGE LEVEL PLUGINS -->
<link rel="stylesheet"
href="<%=basePath%>css/bootstrap/bootstrap-table.min.css" />
<script src="<%=basePath%>js/bootstrap/bootstrap-table.min.js"></script>
<script src="<%=basePath%>js/bootstrap/bootstrap-table-zh-CN.min.js"></script>
<!-- easyui -->
<%-- <script src="<%=basePath%>easyui/jquery.easyui.min.js"></script> --%>
<%-- <link rel="stylesheet" type="text/css" href="<%=basePath%>easyui/themes/default/easyui.css"> --%>
<%-- <link type="text/css" rel="stylesheet" href="<%=basePath%>jeDate/test/jeDate-test.css"> --%>
<link type="text/css" rel="stylesheet"
href="<%=basePath%>jeDate/skin/jedate.css">
<script type="text/javascript" src="<%=basePath%>jeDate/src/jedate.js"></script>
<%-- <script type="text/javascript" src="<%=basePath%>js/bootstrap/bootstrap-select.js"></script> --%>
<%-- <link type="text/css" rel="stylesheet" href="<%=basePath%>css/bootstrap/bootstrap-select.css"> --%>
<script src="<%=basePath%>js/bootstrap/center-loader.js"></script>
<link href="<%=basePath%>css/ySelect.css" rel="stylesheet"
type="text/css">
<%-- <script src="<%=basePath%>js/jquery-1.11.3.min.js"></script> --%>
<%-- <script src="<%=basePath%>js/bootstrap.min.js"></script> --%>
<script src="<%=basePath%>js/ySelect.js"></script>
</head>
<style>
* {
font-family: "微软雅黑";
font-size: 14px;
letter-spacing: 2px;
}
.mb {
margin-bottom: 10px
}
</style>
<body
class="page-container-bg-solid page-header-fixed page-sidebar-closed-hide-logo">
<div class="clearfix"></div>
<div class="page-content">
<ul class="page-breadcrumb breadcrumb">
<li class="active"><span
style="color: #5e738b; font-size: 16px;">港口填报</span> <i
class="fa fa-circle"> </i>
<li><span class="active">服务企业维护</span></li>
</ul>
<!-- END PAGE BREADCRUMB -->
<div class="row">
<div class="col-md-12">
<div class="portlet light bordered" style="height: 866px;">
<div class="portlet-body">
<ul class="nav nav-tabs">
<c:forEach items="${allPollutantDeliveryBtn}"
var="allPollutantDeliveryBtn" varStatus="status_index">
<li>
<li <c:if test="${status_index.index==0}">class="active"</c:if>>
<a href="#${allPollutantDeliveryBtn.FBI_URL}" data-toggle="tab"
style="font-size: 16px;">${allPollutantDeliveryBtn.FBI_NAME}</a>
</li>
</c:forEach>
</ul>
<div class="tab-content">
<div class="tab-pane fade active in" id="tab_1_1">
<div>
<!-- <div class="container" style="margin-top: 25px"> -->
<div class="" style="margin-top: 25px">
<div class="row clearfix">
<div class="col-md-4 col-sm-4 col-lg-4 column mb ">
<div class="form-group">
<label class="col-md-5 col-sm-6 col-lg-4 control-label">服务企业名称</label>
<div class="col-md-7 col-sm-6 col-lg-6">
<select id="RR_SERVICE_COMPANY" class="demo1"
multiple="multiple">
<!-- <option value="" >请选择</option> -->
<c:forEach var="hc" items="${hc}">
<option value="${hc.HC_FID}">${hc.HC_NAME}</option>
</c:forEach>
</select>
</div>
</div>
</div>
<div class="col-md-4 col-sm-4 col-lg-4 column mb ">
<label class="col-md-5 col-sm-6 col-lg-4 column mb">接收污染类型</label>
<!-- <div class="col-md-7 col-sm-6 col-lg-6">
<input type="text" id="MO_FID" name="MO_FID" class="easyui-combotree form-control input-inline" style="width:100%;height: 34px" />
</div> -->
<div class="col-md-7 col-sm-6 col-lg-6">
<select id="RR_RECEIVING_POLLUTANTS"
name="RR_RECEIVING_POLLUTANTS" class="form-control">
<option value="">请选择</option>
<c:forEach var="sys" items="${sys}">
<option value="${sys.SDD_DICTIONARY_CODE}">${sys.SDD_DICTIONARY_CNAME}</option>
</c:forEach>
</select>
</div>
</div>
<div class="col-md-4 col-sm-4 col-lg-4 column mb">
<div class="row clearfix">
<c:forEach var="pdBtnSecond0"
items="${pollutantDeliverySecondtab_1_1}">
<c:if test="${pdBtnSecond0.FBI_TYPE==1}">
<a class="btn green" onclick="initResearchReportTable()"
id="searchBtn"
style="font-size: 16px; font-family: '微软雅黑';">${pdBtnSecond0.FBI_NAME}
<i class="fa fa-search"></i>
</a>
</c:if>
</c:forEach>
<c:forEach var="pdBtnSecond0"
items="${pollutantDeliverySecondtab_1_1}">
<c:if test="${pdBtnSecond0.FBI_TYPE==2}">
<a href="javascript:;" id="addBtn" class="btn yellow"
style="font-size: 16px; font-family: '微软雅黑';">${pdBtnSecond0.FBI_NAME}
<i class="fa fa-plus"></i>
</a>
</c:if>
</c:forEach>
</div>
</div>
</div>
<div class="row clearfix">
<div class="col-md-4 col-sm-4 col-lg-4 column mb"></div>
<div class="col-md-4 col-sm-4 col-lg-4 column mb"></div>
<div class="col-md-4 col-sm-4 col-lg-4 column mb">
<div class="row clearfix">
<c:forEach var="pdBtnSecond0"
items="${pollutantDeliverySecondtab_1_1}">
<c:if test="${pdBtnSecond0.FBI_TYPE==3}">
<a class="btn blue" id="updateBtn"
style="font-size: 16px; font-family: '微软雅黑';">${pdBtnSecond0.FBI_NAME}
<i class="fa fa-eraser"></i>
</a>
</c:if>
</c:forEach>
<c:forEach var="pdBtnSecond0"
items="${pollutantDeliverySecondtab_1_1}">
<c:if test="${pdBtnSecond0.FBI_TYPE==4}">
<a href="javascript:;" id="deleteBtn" class="btn red"
style="font-size: 16px; font-family: '微软雅黑';">${pdBtnSecond0.FBI_NAME}
<i class="fa fa-times"></i>
</a>
</c:if>
</c:forEach>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<input id="updateHoldFid" type="hidden" name="RR_FID">
<div class="col-md-12">
<div class="portlet-body" style="height: 500px;">
<div class="table-scrollable table-responsive">
<table id="initResearchReportTable"
class="table table-striped table-bordered table-hover table-checkable order-column ">
</table>
</div>
</div>
<div></div>
</div>
</div>
</div>
</div>
<div class="clearfix margin-bottom-20"></div>
</div>
</div>
</div>
</div>
<script type="text/javascript">
var search_pollutants;
var search_company;
initResearchReportTable();
function initResearchReportTable(){
$('body').loader('show','<img src="<%=basePath%>images/loading1.gif">');
$('#initResearchReportTable').bootstrapTable('destroy');
$('#initResearchReportTable').bootstrapTable({
method: 'post',
contentType: "application/x-www-form-urlencoded",
url : '<%=basePath%>researchReport/initResearchReport.te',
cache: false,
pagination: true,
paginationHAlign:'right',
queryParamsType:'',
queryParams:queryParams,
singleSelect: false,
pageSize: 10,
pageList: [10, 20,30],
search: false,
showColumns: false,
sidePagination: "server",
striped:true,
clickToSelect:true,
columns: [{
checkbox: true,
visible: true
},
{
field: 'rr_FID',
visible:false,
valign:'middle',
align: 'center',
},
{
field: 'rownum_',
title: '序号',
valign:'middle',
align: 'center',
},
{
field: 'rr_SERVICE_COMPANY',
title: '服务企业名称',
valign:'middle',
align: 'center',
},
{
field: 'rr_RECEIVING_POLLUTANTS',
title: '接收污染物类型',
valign:'middle',
align: 'center',
},
{
field: 'rr_DEADLINE',
title: '服务截止日期',
valign:'middle',
align: 'center',
},
{
field: 'rr_TIME_REQUIRED',
title: '到达港口企业所需时间(h)',
valign:'middle',
align: 'center',
}],
onLoadSuccess:function(){
$('body').loader('hide');
search_pollutants=$("#RR_RECEIVING_POLLUTANTS").val();
search_company=$("#RR_SERVICE_COMPANY").val();
},
onLoadError: function () {
window.parent.modalOutError("数据加载失败!");
}
});
};
function queryParams(params){
var RR_SERVICE_COMPANY = $("#RR_SERVICE_COMPANY").ySelectedValues(",");
var RR_RECEIVING_POLLUTANTS=$("#RR_RECEIVING_POLLUTANTS").val();
var temp = {
pageSize:params.pageSize,
pageNumber:params.pageNumber,
RR_SERVICE_COMPANY:RR_SERVICE_COMPANY,
RR_RECEIVING_POLLUTANTS:RR_RECEIVING_POLLUTANTS,
};
return temp;
}
initResearchReportTable();
$("#searchBtn").click(function(){
initResearchReportTable();
});
$("#addBtn").on("click",function(){
window.parent.modalOut('<%=basePath%>researchReport/insertResearchReportInfo.te?auditFid=${auditFid}');
})
$("#updateBtn").click(function(){
var row=$("#initResearchReportTable").bootstrapTable('getSelections');
if(row==null || row=='' || row.length>1){
window.parent.modalOutError("请选择一条修改记录。");
}else{
window.parent.modalOut('<%=basePath%>researchReport/updateInfo.te?fid='+row[0].rr_FID);
}
});
function delResearchReportInfo(){
var rows=$('#initResearchReportTable').bootstrapTable("getSelections");
var INEM_ID="";
$.each(rows,function(i,n){
if(i==0){
INEM_ID+="'"+n.rr_FID+"'";
}else{
INEM_ID+=",'"+n.rr_FID+"'";
}
})
$.ajax({
cache: true,
type: "POST",
url:"<%=basePath%>
researchReport/delResearchReport.te",
data : {
INEM_ID : INEM_ID
},
success : function(data) {
console.log(data.result);
if (data.result == 'success') {
window.parent.modalOutError("删除成功");
initResearchReportTable();
} else {
window.parent.modalOutError("删除数据产生错误!!");
}
},
error : function(request) {
window.parent.modalOutError("操作超时,请重新登录!!");
}
});
}
$("#deleteBtn").on(
"click",
function() {
var rowarray = $('#initResearchReportTable')
.bootstrapTable('getSelections');
if (rowarray == null || rowarray == '') {
window.parent.modalOutError("至少选中一条需要删除的信息。");
} else {
var showInfo = "";
for ( var i = 0; i < rowarray.length; i++) {
var tempstr = rowarray[i].rr_FID;
if (tempstr != null && tempstr != '') {
showInfo = showInfo + tempstr + ",";
}
}
$("#initResearchReportTable").val(showInfo);
window.parent.modalDeleteInfoShow('6');
}
})
$(function() {
$('.demo1').ySelect({
placeholder : '请选择',
searchText : '搜索',
showSearch : true,
numDisplayed : 4,
overflowText : '已选中 {n}项',
isCheck : false
});
});
</script>
</body>
</html>
cortroller
package enytek.com.cn.controller.corpprateinfo;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.HttpSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import com.sun.org.apache.xpath.internal.axes.HasPositionalPredChecker;
import enytek.com.cn.model.approve.Approve;
import enytek.com.cn.model.corpprateinfo.CorpprateinfoModel;
import enytek.com.cn.model.corpprateinfo.DeviceInfoModel;
import enytek.com.cn.model.corpprateinfo.MonitoringFactorModel;
import enytek.com.cn.model.corpprateinfo.MonitoringPointModel;
import enytek.com.cn.model.excessiveAlarm.ExcessiveAlarm;
import enytek.com.cn.model.functionbuttoninfo.FunctionButtonInfoModel;
import enytek.com.cn.model.sysDataDictionary.SysDataDictionayModel;
import enytek.com.cn.model.userInfo.UserInfoEntity;
import enytek.com.cn.service.ApproveService;
import enytek.com.cn.service.corpprateinfo.CorpprateinfoService;
import enytek.com.cn.service.corpprateinfo.DeviceInfoService;
import enytek.com.cn.service.corpprateinfo.MonitoringFactorService;
import enytek.com.cn.service.corpprateinfo.MonitoringPointService;
import enytek.com.cn.service.sysDataDictionary.SysDataDictionaryService;
import enytek.com.cn.util.CommonUtil;
import enytek.com.cn.util.echecomap.EhcacheMapUtil;
import enytek.com.cn.util.userlimit.AllLimitUtil;
@Controller
@RequestMapping("Corpprateinfo")
public class CorpprateinfoController {
@Autowired
private CorpprateinfoService corpprateinfoService;
@Autowired
private DeviceInfoService deviceInfoService;
@Autowired
private MonitoringFactorService monitoringFactorService;
@Autowired
private MonitoringPointService monitoringPointService;
@Resource(name = "sysDataDictionaryService")
private SysDataDictionaryService sysDataDictionaryService;
@Resource(name="approveService")
ApproveService approveService;
public List<SysDataDictionayModel> getDataDic(String dic){
SysDataDictionayModel sysData = new SysDataDictionayModel();
sysData.setSDD_DICTIONARY(dic);
List<SysDataDictionayModel> sysDataList = sysDataDictionaryService.findDicInfo(sysData);
return sysDataList;
}
@RequestMapping("initSiteManger")
public String showShippingInfo(HttpSession session,String noChangeFid,Model model,String auditFid) throws Exception{
UserInfoEntity userInfo = (UserInfoEntity)session.getAttribute("LoginUserInfo");
Object obj = EhcacheMapUtil.getObject("btn"+userInfo.getUI_FID());
if(obj!=null){
List<FunctionButtonInfoModel> tempList = (List<FunctionButtonInfoModel>)obj;
List<FunctionButtonInfoModel> resultList = new ArrayList<FunctionButtonInfoModel>();
AllLimitUtil.getButtonListInfoFromFid(noChangeFid, tempList, resultList);
model.addAttribute("allPollutantDeliveryBtn",resultList);
if(resultList!=null && resultList.size()>0){
for (int j = 0; j < resultList.size(); j++) {
List<FunctionButtonInfoModel> resultListErJi = new ArrayList<FunctionButtonInfoModel>();
FunctionButtonInfoModel tempFunctionButtonInfoModel=resultList.get(j);
String erJiFId = tempFunctionButtonInfoModel.getFBI_FID();
AllLimitUtil.getButtonListInfoFromFid(erJiFId, tempList, resultListErJi);
model.addAttribute("pollutantDeliverySecond"+resultList.get(j).getFBI_URL(),resultListErJi);
}
}
SysDataDictionayModel sys = new SysDataDictionayModel();
sys.setSDD_DICTIONARY("0030");
List<SysDataDictionayModel> findDicInfo = sysDataDictionaryService.findDicInfo(sys);
model.addAttribute("sys", findDicInfo);
List<SysDataDictionayModel> sysRtdType = getDataDic("0050");
model.addAttribute("sysRtdType",sysRtdType);
model.addAttribute("auditFid", auditFid);
}else{
return "permissionDenied";
}
return "corpprateinfo/showcorpprateinfo";
}
@RequestMapping("updateInfo")
public String updateInfo(HttpSession session,String noChangeFid,Model model,String fid,String auditFid) throws Exception{
if(fid!=null && fid!=""){
model.addAttribute("fid", fid);
CorpprateinfoModel corpprateinfo=new CorpprateinfoModel();
corpprateinfo.setCI_FID(fid);
List<CorpprateinfoModel> listCM=corpprateinfoService.selectCorpprateinfoList(corpprateinfo);
if(listCM!=null && listCM.size()>0){
CorpprateinfoModel cm = listCM.get(0);
model.addAttribute("cm", cm);
}
DeviceInfoModel deviceInfo=new DeviceInfoModel();
deviceInfo.setDI_MFFID(fid);
List<DeviceInfoModel> listds = deviceInfoService.selectDeviceInfoList(deviceInfo);
if(listds!=null && listds.size()>0){
model.addAttribute("ds", listds.get(0));
}
MonitoringFactorModel monitoringFactor=new MonitoringFactorModel();
monitoringFactor.setMF_MPFID(fid);
List<MonitoringFactorModel> listMF = monitoringFactorService.selectMonitoringFactorList(monitoringFactor);
model.addAttribute("listMF", listMF);
MonitoringPointModel monitoringPoint=new MonitoringPointModel();
monitoringPoint.setMP_CIFID(fid);
List<MonitoringPointModel> listMP = monitoringPointService.selectMonitoringPointList(monitoringPoint);
if(listMP!=null && listMP.size()>0){
model.addAttribute("mp", listMP.get(0));
}
List<SysDataDictionayModel> sysRtdType = getDataDic("0050");
model.addAttribute("sysRtdType",sysRtdType);
model.addAttribute("auditFid",auditFid);
}
return "corpprateinfo/updateCorpprateInfo";
}
@RequestMapping("updateCorpprateinfo")
@ResponseBody
public Map<String,Object> updateCorpprateinfo(String fid,HttpSession session,CorpprateinfoModel corpprateinfo,DeviceInfoModel deviceInfo,MonitoringPointModel monitoringPoint) throws Exception{
Map<String,Object>result=new HashMap<String,Object>();
UserInfoEntity userInfo = (UserInfoEntity) session.getAttribute("LoginUserInfo");
try {
String ui_ifd=userInfo.getUI_FID();
corpprateinfo.setCI_AUDIT("1");
corpprateinfo.setCI_PERPER(ui_ifd);
corpprateinfo.setCI_FID(fid);
monitoringPoint.setMP_CIFID(fid);
monitoringPoint.setMP_PERPER(ui_ifd);
deviceInfo.setDI_MFFID(fid);
deviceInfo.setDI_PERPER(ui_ifd);
List<MonitoringFactorModel> list = corpprateinfo.getListmf();
if(list!=null && list.size()>0){
for (MonitoringFactorModel mf : list) {
mf.setMF_PERPER(ui_ifd);
mf.setMF_MPFID(fid);
}
}
corpprateinfoService.updateInfo(corpprateinfo,deviceInfo,monitoringPoint);
Approve approve=new Approve();
approve.setAPPR_FID(fid);
approve.setAPPR_PEOPLE(userInfo.getUI_FID());
approve.setAPPR_RESULT("1");
approveService.insertApprove(approve);
result.put("result", "0");
} catch (Exception e) {
e.printStackTrace();
result.put("result", "1");
}
return result;
}
@RequestMapping("detailCorpprateInfo")
public String detailInfo(HttpSession session,String noChangeFid,Model model,String fid) throws Exception{
if(fid!=null && fid!=""){
CorpprateinfoModel corpprateinfo=new CorpprateinfoModel();
corpprateinfo.setCI_FID(fid);
List<CorpprateinfoModel> listCM=corpprateinfoService.selectCorpprateinfoList(corpprateinfo);
if(listCM!=null && listCM.size()>0){
CorpprateinfoModel cm = listCM.get(0);
model.addAttribute("cm", cm);
}
DeviceInfoModel deviceInfo=new DeviceInfoModel();
deviceInfo.setDI_MFFID(fid);
List<DeviceInfoModel> listds = deviceInfoService.selectDeviceInfoList(deviceInfo);
if(listds!=null && listds.size()>0){
model.addAttribute("ds", listds.get(0));
}
MonitoringFactorModel monitoringFactor=new MonitoringFactorModel();
monitoringFactor.setMF_MPFID(fid);
List<MonitoringFactorModel> listMoF = monitoringFactorService.selectMonitoringFactorList(monitoringFactor);
model.addAttribute("listMoF", listMoF);
MonitoringPointModel monitoringPoint=new MonitoringPointModel();
monitoringPoint.setMP_CIFID(fid);
List<MonitoringPointModel> listMP = monitoringPointService.selectMonitoringPointList(monitoringPoint);
if(listMP!=null && listMP.size()>0){
model.addAttribute("mp", listMP.get(0));
}
List<SysDataDictionayModel> sysRtdType = getDataDic("0050");
model.addAttribute("sysRtdType",sysRtdType);
Approve approve=new Approve();
approve.setAPPR_FID(fid);
List<Approve> showlist = approveService.selectApprAuit(approve);
model.addAttribute("showlist", showlist);
}
return "corpprateinfo/detailCorpprateInfo";
}
@RequestMapping("inserCorpprateinfo")
@ResponseBody
public Map<String,Object> inserCorpprateinfo(HttpSession session,CorpprateinfoModel corpprateinfo,DeviceInfoModel deviceInfo,MonitoringPointModel monitoringPoint) throws Exception{
Map<String,Object> result=new HashMap<String,Object>();
UserInfoEntity userInfo = (UserInfoEntity) session.getAttribute("LoginUserInfo");
try {
String ui_ifd=userInfo.getUI_FID();
String ci_fid=CommonUtil.getRandomNum("CI");
corpprateinfo.setCI_AUDIT("1");
corpprateinfo.setCI_FID(ci_fid);
corpprateinfo.setCI_PERPER(ui_ifd);
monitoringPoint.setMP_FID(CommonUtil.getRandomNum("MP"));
monitoringPoint.setMP_CIFID(ci_fid);
monitoringPoint.setMP_PERPER(ui_ifd);
deviceInfo.setDI_FID(CommonUtil.getRandomNum("DI"));
deviceInfo.setDI_MFFID(ci_fid);
deviceInfo.setDI_PERPER(ui_ifd);
List<MonitoringFactorModel> list = corpprateinfo.getListmf();
if(list!=null && list.size()>0){
for (MonitoringFactorModel mf : list) {
mf.setMF_FID(CommonUtil.getRandomNum("MF"));
mf.setMF_PERPER(ui_ifd);
mf.setMF_MPFID(ci_fid);
}
}
corpprateinfoService.insertInfo(corpprateinfo,deviceInfo,monitoringPoint);
Approve approve=new Approve();
approve.setAPPR_FID(ci_fid);
approve.setAPPR_PEOPLE(userInfo.getUI_FID());
approve.setAPPR_RESULT("1");
approveService.insertApprove(approve);
result.put("result", "0");
} catch (Exception e) {
e.printStackTrace();
result.put("result", "1");
}
return result;
}
}
CorpprateinfoService.java
package enytek.com.cn.service.corpprateinfo;
import java.util.List;
import enytek.com.cn.model.corpprateinfo.CorpprateinfoModel;
import enytek.com.cn.model.corpprateinfo.DeviceInfoModel;
import enytek.com.cn.model.corpprateinfo.MonitoringPointModel;
public interface CorpprateinfoService {
public int inserCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception;
public List<CorpprateinfoModel> selectCorpprateinfoList(CorpprateinfoModel corpprateinfo) throws Exception;
public int batchInsertCorpprateinfo(List<CorpprateinfoModel> corpprateinfo) throws Exception;
public List<CorpprateinfoModel> selectCorpprateinfoPaging(CorpprateinfoModel entity, int pager_offset, int pageSize) throws Exception;
public Integer selectCorpprateinfoCount(CorpprateinfoModel entity) throws Exception;
public Integer audit(CorpprateinfoModel entity);
public void insertInfo(CorpprateinfoModel corpprateinfo,
DeviceInfoModel deviceInfo, MonitoringPointModel monitoringPoint);
public void updateInfo(CorpprateinfoModel corpprateinfo,
DeviceInfoModel deviceInfo, MonitoringPointModel monitoringPoint);
}
DeviceInfoService.java
package enytek.com.cn.service.corpprateinfo;
import java.util.List;
import enytek.com.cn.model.corpprateinfo.DeviceInfoModel;
public interface DeviceInfoService {
public int inserDeviceInfo(DeviceInfoModel deviceInfo) throws Exception;
public int updateDeviceInfo(DeviceInfoModel deviceInfo) throws Exception;
public Integer deleteDeviceInfo(DeviceInfoModel deviceInfo) throws Exception;
public Integer deleteDeviceInfoList(DeviceInfoModel deviceInfo) throws Exception;
public List<DeviceInfoModel> selectDeviceInfoList(DeviceInfoModel deviceInfo) throws Exception;
public List<DeviceInfoModel> selectDeviceInfoPaging(DeviceInfoModel deviceInfo ,int pager_offset,int pageSize) throws Exception;
public Integer selectDeviceInfoCount(DeviceInfoModel deviceInfo) throws Exception;
public int batchInsertDeviceInfo(List<DeviceInfoModel> deviceInfo) throws Exception;
}
MonitoringFactorService.java
package enytek.com.cn.service.corpprateinfo;
import java.util.List;
import enytek.com.cn.model.corpprateinfo.MonitoringFactorModel;
public interface MonitoringFactorService {
public int inserMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception;
public int updateMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception;
public Integer deleteMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception;
public Integer deleteMonitoringFactorList(MonitoringFactorModel monitoringFactor) throws Exception;
public List<MonitoringFactorModel> selectMonitoringFactorList(MonitoringFactorModel monitoringFactor) throws Exception;
public List<MonitoringFactorModel> selectMonitoringFactorPaging(MonitoringFactorModel monitoringFactor,int pager_offset,int pageSize) throws Exception;
public Integer selectMonitoringFactorCount(MonitoringFactorModel monitoringFactor) throws Exception;
public int batchInsertMonitoringFactor(List<MonitoringFactorModel> monitoringFactor) throws Exception;
}
MonitoringPointService.java
package enytek.com.cn.service.corpprateinfo;
import java.util.List;
import enytek.com.cn.model.corpprateinfo.MonitoringPointModel;
public interface MonitoringPointService {
public int inserMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception;
public int updateMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception;
public Integer deleteMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception;
public Integer deleteMonitoringPointList(MonitoringPointModel monitoringPoint) throws Exception;
public List<MonitoringPointModel> selectMonitoringPointList(MonitoringPointModel monitoringPoint) throws Exception;
public List<MonitoringPointModel> selectMonitoringPointPaging(MonitoringPointModel monitoringPoint,int pager_offset,int pageSize) throws Exception;
public Integer selectMonitoringPointCount(MonitoringPointModel monitoringPoint) throws Exception;
public int batchInsertMonitoringPoint(List<MonitoringPointModel> monitoringPoint) throws Exception;
}
CorpprateinfoServiceImpl.java
package enytek.com.cn.service.Impl.corpprateinfo;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import enytek.com.cn.dao.corpprateinfo.CorpprateinfoDao;
import enytek.com.cn.dao.corpprateinfo.DeviceInfoDao;
import enytek.com.cn.dao.corpprateinfo.MonitoringFactorDao;
import enytek.com.cn.dao.corpprateinfo.MonitoringPointDao;
import enytek.com.cn.model.corpprateinfo.CorpprateinfoModel;
import enytek.com.cn.model.corpprateinfo.DeviceInfoModel;
import enytek.com.cn.model.corpprateinfo.MonitoringFactorModel;
import enytek.com.cn.model.corpprateinfo.MonitoringPointModel;
import enytek.com.cn.service.corpprateinfo.CorpprateinfoService;
import enytek.com.cn.util.PageTools;
@Service("CorpprateinfoService")
public class CorpprateinfoServiceImpl implements CorpprateinfoService {
@Resource(name="CorpprateinfoDao")
private CorpprateinfoDao corpprateinfoDao;
@Resource(name="DeviceInfoDao")
private DeviceInfoDao deviceInfoDao;
@Resource(name="MonitoringFactorDao")
private MonitoringFactorDao monitoringFactorDao;
@Resource(name="MonitoringPointDao")
private MonitoringPointDao monitoringPointDao;
public int inserCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception {
return corpprateinfoDao.inserCorpprateinfo(corpprateinfo);
}
public int updateCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception {
return corpprateinfoDao.updateCorpprateinfo(corpprateinfo);
}
public Integer deleteCorpprateinfo(CorpprateinfoModel corpprateinfo)throws Exception {
return corpprateinfoDao.deleteCorpprateinfo(corpprateinfo);
}
public Integer deleteCorpprateinfoList(CorpprateinfoModel corpprateinfo) throws Exception {
return corpprateinfoDao.deleteCorpprateinfoList(corpprateinfo);
}
public List<CorpprateinfoModel> selectCorpprateinfoList(CorpprateinfoModel corpprateinfo) throws Exception {
return corpprateinfoDao.selectCorpprateinfoList(corpprateinfo);
}
@Override
public List<CorpprateinfoModel> selectCorpprateinfoPaging(CorpprateinfoModel corpprateinfo,int pager_offset,int pageSize) throws Exception {
PageTools pt = new PageTools();
int startPage = pt.getBeginNumbers(pager_offset, pageSize);
int endPage = pt.getEndNumbers(pager_offset, pageSize);
corpprateinfo.setStartPage(startPage);
corpprateinfo.setEndPage(endPage);
return corpprateinfoDao.selectCorpprateinfoPaging(corpprateinfo);
}
@Override
public Integer selectCorpprateinfoCount(CorpprateinfoModel corpprateinfo) throws Exception {
return corpprateinfoDao.selectCorpprateinfoCount(corpprateinfo);
}
public int batchInsertCorpprateinfo(List<CorpprateinfoModel> corpprateinfo) throws Exception {
return corpprateinfoDao.batchInsertCorpprateinfo(corpprateinfo);
}
@Override
public Integer audit(CorpprateinfoModel entity) {
if(entity.getCI_AUDIT()==null || entity.getCI_AUDIT()==""){
return null;
}
return corpprateinfoDao.audit(entity);
}
@Override
public void insertInfo(CorpprateinfoModel corpprateinfo,
DeviceInfoModel deviceInfo, MonitoringPointModel monitoringPoint) {
try {
corpprateinfoDao.inserCorpprateinfo(corpprateinfo);
List<MonitoringFactorModel> listmf = corpprateinfo.getListmf();
if(listmf!=null && listmf.size()>0){
monitoringFactorDao.batchInsertMonitoringFactor(listmf);
}
deviceInfoDao.inserDeviceInfo(deviceInfo);
monitoringPointDao.inserMonitoringPoint(monitoringPoint);
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
public void updateInfo(CorpprateinfoModel corpprateinfo,
DeviceInfoModel deviceInfo, MonitoringPointModel monitoringPoint) {
try {
corpprateinfoDao.updateCorpprateinfo(corpprateinfo);
List<MonitoringFactorModel> listmf = corpprateinfo.getListmf();
if(listmf!=null && listmf.size()>0){
MonitoringFactorModel monitoringFactor=new MonitoringFactorModel();
monitoringFactor.setMF_MPFID(corpprateinfo.getCI_FID());
monitoringFactorDao.deleteMonitoringFactor(monitoringFactor);
monitoringFactorDao.batchInsertMonitoringFactor(listmf);
}
deviceInfoDao.updateDeviceInfo(deviceInfo);
monitoringPointDao.updateMonitoringPoint(monitoringPoint);
} catch (Exception e) {
e.printStackTrace();
}
}
}
DeviceInfoServiceImpl.java
package enytek.com.cn.service.Impl.corpprateinfo;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import enytek.com.cn.dao.corpprateinfo.CorpprateinfoDao;
import enytek.com.cn.dao.corpprateinfo.DeviceInfoDao;
import enytek.com.cn.model.corpprateinfo.DeviceInfoModel;
import enytek.com.cn.service.corpprateinfo.DeviceInfoService;
import enytek.com.cn.util.PageTools;
@Service("DeviceInfoService")
public class DeviceInfoServiceImpl implements DeviceInfoService {
@Resource(name="DeviceInfoDao")
private DeviceInfoDao deviceInfoDao;
public int inserDeviceInfo(DeviceInfoModel deviceInfo) throws Exception {
return deviceInfoDao.inserDeviceInfo(deviceInfo);
}
public int updateDeviceInfo(DeviceInfoModel deviceInfo) throws Exception {
return deviceInfoDao.updateDeviceInfo(deviceInfo);
}
public Integer deleteDeviceInfo(DeviceInfoModel deviceInfo) throws Exception {
return deviceInfoDao.deleteDeviceInfo(deviceInfo);
}
public Integer deleteDeviceInfoList(DeviceInfoModel deviceInfo) throws Exception {
return deviceInfoDao.deleteDeviceInfoList(deviceInfo);
}
public List<DeviceInfoModel> selectDeviceInfoList(DeviceInfoModel deviceInfo) throws Exception {
return deviceInfoDao.selectDeviceInfoList(deviceInfo);
}
public List<DeviceInfoModel> selectDeviceInfoPaging(DeviceInfoModel deviceInfo, int pager_offset, int pageSize)
throws Exception {
PageTools pt = new PageTools();
int startPage = pt.getBeginNumbers(pager_offset, pageSize);
int endPage = pt.getEndNumbers(pager_offset, pageSize);
deviceInfo.setStartPage(startPage);
deviceInfo.setEndPage(endPage);
return deviceInfoDao.selectDeviceInfoPaging(deviceInfo);
}
public Integer selectDeviceInfoCount(DeviceInfoModel deviceInfo)
throws Exception {
return deviceInfoDao.selectDeviceInfoCount(deviceInfo);
}
public int batchInsertDeviceInfo(List<DeviceInfoModel> deviceInfo)
throws Exception {
return deviceInfoDao.batchInsertDeviceInfo(deviceInfo);
}
}
MonitoringFactorServiceImpl.java
package enytek.com.cn.service.Impl.corpprateinfo;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import enytek.com.cn.dao.corpprateinfo.MonitoringFactorDao;
import enytek.com.cn.model.corpprateinfo.MonitoringFactorModel;
import enytek.com.cn.service.corpprateinfo.MonitoringFactorService;
import enytek.com.cn.util.PageTools;
@Service("MonitoringFactorService")
public class MonitoringFactorServiceImpl implements MonitoringFactorService {
@Resource(name="MonitoringFactorDao")
private MonitoringFactorDao monitoringFactorDao;
public int inserMonitoringFactor(MonitoringFactorModel monitoringFactor)
throws Exception {
return monitoringFactorDao.inserMonitoringFactor(monitoringFactor);
}
public int updateMonitoringFactor(MonitoringFactorModel monitoringFactor)
throws Exception {
return monitoringFactorDao.updateMonitoringFactor(monitoringFactor);
}
public Integer deleteMonitoringFactor(MonitoringFactorModel monitoringFactor)
throws Exception {
return monitoringFactorDao.deleteMonitoringFactor(monitoringFactor);
}
public Integer deleteMonitoringFactorList(
MonitoringFactorModel monitoringFactor) throws Exception {
return monitoringFactorDao.deleteMonitoringFactorList(monitoringFactor);
}
public List<MonitoringFactorModel> selectMonitoringFactorList(
MonitoringFactorModel monitoringFactor) throws Exception {
return monitoringFactorDao.selectMonitoringFactorList(monitoringFactor);
}
public List<MonitoringFactorModel> selectMonitoringFactorPaging(MonitoringFactorModel monitoringFactor, int pager_offset,int pageSize) throws Exception {
PageTools pt = new PageTools();
int startPage = pt.getBeginNumbers(pager_offset, pageSize);
int endPage = pt.getEndNumbers(pager_offset, pageSize);
monitoringFactor.setStartPage(startPage);
monitoringFactor.setEndPage(endPage);
return monitoringFactorDao.selectMonitoringFactorPaging(monitoringFactor);
}
public Integer selectMonitoringFactorCount(
MonitoringFactorModel monitoringFactor) throws Exception {
return monitoringFactorDao.selectMonitoringFactorCount(monitoringFactor);
}
public int batchInsertMonitoringFactor(
List<MonitoringFactorModel> monitoringFactor) throws Exception {
return monitoringFactorDao.batchInsertMonitoringFactor(monitoringFactor);
}
}
MonitoringPointServiceImpl.java
package enytek.com.cn.service.Impl.corpprateinfo;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import enytek.com.cn.dao.corpprateinfo.MonitoringPointDao;
import enytek.com.cn.model.corpprateinfo.MonitoringPointModel;
import enytek.com.cn.service.corpprateinfo.MonitoringPointService;
import enytek.com.cn.util.PageTools;
@Service("MonitoringPointService")
public class MonitoringPointServiceImpl implements MonitoringPointService {
@Resource(name="MonitoringPointDao")
private MonitoringPointDao monitoringPointDao;
public int inserMonitoringPoint(MonitoringPointModel monitoringPoint)
throws Exception {
return monitoringPointDao.inserMonitoringPoint(monitoringPoint);
}
public int updateMonitoringPoint(MonitoringPointModel monitoringPoint)
throws Exception {
return monitoringPointDao.updateMonitoringPoint(monitoringPoint);
}
public Integer deleteMonitoringPoint(MonitoringPointModel monitoringPoint)
throws Exception {
return monitoringPointDao.deleteMonitoringPoint(monitoringPoint);
}
public Integer deleteMonitoringPointList(
MonitoringPointModel monitoringPoint) throws Exception {
return monitoringPointDao.deleteMonitoringPointList(monitoringPoint);
}
public List<MonitoringPointModel> selectMonitoringPointList(
MonitoringPointModel monitoringPoint) throws Exception {
return monitoringPointDao.selectMonitoringPointList(monitoringPoint);
}
public List<MonitoringPointModel> selectMonitoringPointPaging(
MonitoringPointModel monitoringPoint, int pager_offset, int pageSize)
throws Exception {
PageTools pt = new PageTools();
int startPage = pt.getBeginNumbers(pager_offset, pageSize);
int endPage = pt.getEndNumbers(pager_offset, pageSize);
monitoringPoint.setStartPage(startPage);
monitoringPoint.setEndPage(endPage);
return monitoringPointDao.selectMonitoringPointPaging(monitoringPoint);
}
public Integer selectMonitoringPointCount(
MonitoringPointModel monitoringPoint) throws Exception {
return monitoringPointDao.selectMonitoringPointCount(monitoringPoint);
}
public int batchInsertMonitoringPoint(
List<MonitoringPointModel> monitoringPoint) throws Exception {
return monitoringPointDao.batchInsertMonitoringPoint(monitoringPoint);
}
}
mapper.xml文件(共4张表)
第一张表CorpprateinfoMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="enytek.com.cn.dao.corpprateinfo.CorpprateinfoDao">
<sql id="Base_Column_List">
CI_ID
,CI_FID
,CI_NAME
,CI_PRINCIPAL
,CI_PHONE
,CI_ADDRESS
,CI_LONGITUDE
,CI_LATITUDE
,CI_AUDIT
,CI_PERPER
,CI_DELFLAG
,CI_CREATION_TIME
,CI_ADDRESSCON
</sql>
<sql id="where_conditions">
<if test="CI_ID != null and CI_ID != ''">
and CI_ID = #{CI_ID,jdbcType=DECIMAL}
</if>
<if test="CI_FID != null and CI_FID != ''">
and CI_FID = #{CI_FID,jdbcType=VARCHAR}
</if>
<if test="CI_NAME != null and CI_NAME != ''">
and CI_NAME = #{CI_NAME,jdbcType=VARCHAR}
</if>
<if test="CI_PRINCIPAL != null and CI_PRINCIPAL != ''">
and CI_PRINCIPAL = #{CI_PRINCIPAL,jdbcType=VARCHAR}
</if>
<if test="CI_PHONE != null and CI_PHONE != ''">
and CI_PHONE = #{CI_PHONE,jdbcType=VARCHAR}
</if>
<if test="CI_ADDRESS != null and CI_ADDRESS != ''">
and CI_ADDRESS = #{CI_ADDRESS,jdbcType=VARCHAR}
</if>
<if test="CI_LONGITUDE != null and CI_LONGITUDE != ''">
and CI_LONGITUDE = #{CI_LONGITUDE,jdbcType=VARCHAR}
</if>
<if test="CI_LATITUDE != null and CI_LATITUDE != ''">
and CI_LATITUDE = #{CI_LATITUDE,jdbcType=VARCHAR}
</if>
<if test="CI_AUDIT != null and CI_AUDIT != ''">
and CI_AUDIT = #{CI_AUDIT,jdbcType=VARCHAR}
</if>
<if test="CI_PERPER != null and CI_PERPER != ''">
and CI_PERPER = #{CI_PERPER,jdbcType=VARCHAR}
</if>
<if test="CI_DELFLAG != null and CI_DELFLAG != ''">
and CI_DELFLAG = #{CI_DELFLAG,jdbcType=VARCHAR}
</if>
<if test="CI_CREATION_TIME != null and CI_CREATION_TIME != ''">
and CI_CREATION_TIME = #{CI_CREATION_TIME,jdbcType=DATE}
</if>
<if test="CI_ADDRESSCON != null and CI_ADDRESSCON != ''">
and CI_ADDRESSCON = #{CI_ADDRESSCON,jdbcType=VARCHAR}
</if>
</sql>
<!-- 新增方法 -->
<insert id="inserCorpprateinfo" parameterType="corpprateinfo">
<selectKey resultType="Integer" keyProperty="CI_ID" order="BEFORE">
SELECT SEQ_CI_ID.nextval FROM DUAL
</selectKey>
insert into CORPORATE_INFO (
CI_ID
,CI_FID
,CI_NAME
,CI_PRINCIPAL
,CI_PHONE
,CI_ADDRESS
,CI_LONGITUDE
,CI_LATITUDE
,CI_AUDIT
,CI_PERPER
,CI_DELFLAG
,CI_CREATION_TIME
,CI_ADDRESSCON
)values(
#{ CI_ID,jdbcType=DECIMAL},
#{ CI_FID,jdbcType=VARCHAR},
#{ CI_NAME,jdbcType=VARCHAR},
#{ CI_PRINCIPAL,jdbcType=VARCHAR},
#{ CI_PHONE,jdbcType=VARCHAR},
#{ CI_ADDRESS,jdbcType=VARCHAR},
#{ CI_LONGITUDE,jdbcType=VARCHAR},
#{ CI_LATITUDE,jdbcType=VARCHAR},
#{ CI_AUDIT,jdbcType=VARCHAR},
#{ CI_PERPER,jdbcType=VARCHAR},
'0',
sysdate,
#{ CI_ADDRESSCON,jdbcType=VARCHAR}
)
</insert>
<!-- 批量新增方法 -->
<insert id="batchInsertCorpprateinfo" parameterType="corpprateinfo">
insert into CORPORATE_INFO (
CI_ID
,CI_FID
,CI_NAME
,CI_PRINCIPAL
,CI_PHONE
,CI_ADDRESS
,CI_LONGITUDE
,CI_LATITUDE
,CI_AUDIT
,CI_PERPER
,CI_DELFLAG
,CI_CREATION_TIME
,CI_ADDRESSCON
)
SELECT SEQ_CI_ID.NEXTVAL cd.* FROM (
<foreach collection="list" item="item" index="index" separator="union all">
select
#{item.CI_FID,jdbType=VARCHAR},
#{item.CI_NAME,jdbType=VARCHAR},
#{item.CI_PRINCIPAL,jdbType=VARCHAR},
#{item.CI_PHONE,jdbType=VARCHAR},
#{item.CI_ADDRESS,jdbType=VARCHAR},
#{item.CI_LONGITUDE,jdbType=VARCHAR},
#{item.CI_LATITUDE,jdbType=VARCHAR},
#{item.CI_AUDIT,jdbType=VARCHAR},
#{item.CI_PERPER,jdbType=VARCHAR},
#{item.CI_DELFLAG,jdbType=VARCHAR},
#{item.CI_CREATION_TIME,jdbType=VARCHAR},
#{item.CI_ADDRESSCON,jdbType=VARCHAR}
from dual
</foreach>
)cd
</insert>
<!-- 查询方法 -->
<select id="selectCorpprateinfoList" parameterType="corpprateinfo" resultType="corpprateinfo">
select
CI_ID
,CI_FID
,CI_NAME
,CI_PRINCIPAL
,CI_PHONE
,CI_ADDRESS
,CI_LONGITUDE
,CI_LATITUDE
,CI_AUDIT
,CI_PERPER
,CI_DELFLAG
,CI_CREATION_TIME
,CI_ADDRESSCON
<include refid="Base_Column_List"/>
from CORPORATE_INFO
<where>
1=1
<include refid="where_conditions"></include>
</where>
</select>
<!-- 分页查询 -->
<select id="selectCorpprateinfoPaging" resultType="corpprateinfo" parameterType="corpprateinfo">
select CI_ID
,CI_FID
,CI_NAME
,CI_PRINCIPAL
,CI_PHONE
,CI_ADDRESS
,CI_LONGITUDE
,CI_LATITUDE
,CI_AUDIT
,CI_PERPER
,CI_DELFLAG
,CI_CREATION_TIME
,CI_ADDRESSCON,rownum_ from(
select CI_ID
,CI_FID
,CI_NAME
,CI_PRINCIPAL
,CI_PHONE
,CI_ADDRESS
,CI_LONGITUDE
,CI_LATITUDE
,CI_AUDIT
,CI_PERPER
,CI_DELFLAG
,to_char(CI_CREATION_TIME,'yyyy-MM-dd') CI_CREATION_TIME
,CI_ADDRESSCON,row_number() over(order by CI_FID desc) as rownum_ from CORPORATE_INFO
<where>
CI_DELFLAG='0'
<if test="company_name != null and company_name !=''">
and CI_NAME LIKE '%${company_name}%'
</if>
<if test="creater_in != null and creater_in !=''">
and (${creater_in})
</if>
<if test="CI_AUDIT != null and CI_AUDIT !=''">
and CI_AUDIT =#{CI_AUDIT,jdbcType=VARCHAR}
</if>
</where>
<!-- <if test="STARTTIME != null and STARTTIME !=''">
and to_date(to_char(HD_DATA_COLLECTION, 'yyyy-MM-dd'),'yyyy-MM-dd') >= to_date(#{STARTTIME},'yyyy-MM-dd')
</if>
<if test="ENDTIME != null and ENDTIME !=''">
and to_date(to_char(HD_DATA_COLLECTION, 'yyyy-MM-dd'),'yyyy-MM-dd') <= to_date(#{ENDTIME},'yyyy-MM-dd')
</if> -->
)row_ WHERE row_.rownum_ between #{startPage} and #{endPage}
</select>
<select id="selectCorpprateinfoCount" resultType="Integer" parameterType="corpprateinfo">
select count(1) from CORPORATE_INFO
<where>
CI_DELFLAG='0'
<if test="company_name != null and company_name !=''">
and CI_NAME LIKE '%${company_name}%'
</if>
<if test="creater_in != null and creater_in !=''">
and (${creater_in})
</if>
<if test="CI_AUDIT != null and CI_AUDIT !=''">
and CI_AUDIT =#{CI_AUDIT,jdbcType=VARCHAR}
</if>
</where>
</select>
<update id="auditCorpprateinfo" parameterType="corpprateinfo">
update CORPORATE_INFO set CI_AUDIT =#{CI_AUDIT,jdbcType=VARCHAR}
where CI_FID=#{CI_FID,jdbcType=VARCHAR}
</update>
<!-- 修改方法 2019-09-25 15:04:38 YH-->
<update id="updateCorpprateinfo" parameterType="corpprateinfo">
update CORPORATE_INFO
<set>
<if test="CI_ID != null and CI_ID!=''">
CI_ID=#{CI_ID,jdbcType=DECIMAL},
</if>
<if test="CI_FID != null and CI_FID!=''">
CI_FID=#{CI_FID,jdbcType=VARCHAR},
</if>
<if test="CI_NAME != null and CI_NAME!=''">
CI_NAME=#{CI_NAME,jdbcType=VARCHAR},
</if>
<if test="CI_PRINCIPAL != null and CI_PRINCIPAL!=''">
CI_PRINCIPAL=#{CI_PRINCIPAL,jdbcType=VARCHAR},
</if>
<if test="CI_PHONE != null and CI_PHONE!=''">
CI_PHONE=#{CI_PHONE,jdbcType=VARCHAR},
</if>
<if test="CI_ADDRESS != null and CI_ADDRESS!=''">
CI_ADDRESS=#{CI_ADDRESS,jdbcType=VARCHAR},
</if>
<if test="CI_LONGITUDE != null and CI_LONGITUDE!=''">
CI_LONGITUDE=#{CI_LONGITUDE,jdbcType=VARCHAR},
</if>
<if test="CI_LATITUDE != null and CI_LATITUDE!=''">
CI_LATITUDE=#{CI_LATITUDE,jdbcType=VARCHAR},
</if>
<if test="CI_AUDIT != null and CI_AUDIT!=''">
CI_AUDIT=#{CI_AUDIT,jdbcType=VARCHAR},
</if>
<if test="CI_PERPER != null and CI_PERPER!=''">
CI_PERPER=#{CI_PERPER,jdbcType=VARCHAR},
</if>
<if test="CI_DELFLAG != null and CI_DELFLAG!=''">
CI_DELFLAG=#{CI_DELFLAG,jdbcType=VARCHAR},
</if>
<if test="CI_CREATION_TIME != null and CI_CREATION_TIME!=''">
CI_CREATION_TIME=#{CI_CREATION_TIME,jdbcType=DATE},
</if>
<if test="CI_ADDRESSCON != null and CI_ADDRESSCON!=''">
CI_ADDRESSCON=#{CI_ADDRESSCON,jdbcType=VARCHAR},
</if>
</set>
where CI_FID=#{CI_FID,jdbcType=VARCHAR}
</update>
</mapper>
DeviceInfoMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="enytek.com.cn.dao.corpprateinfo.DeviceInfoDao">
<sql id="Base_Column_List">
DI_ID
,DI_MFFID
,DI_FID
,DI_DEVICE_NAME
,DI_DEVICE_MODEL
,DI_SERIAL_NUMBER
,DI_MANUFACTURER
,DI_DIRECTION
,DI_ADDED_MONITORING
,DI_AGENT
,DI_LICENSE
,DI_ENVIRONMENTAL
,DI_PRINCIPLE
,DI_INSTALLATION_DATE
,DI_OPERATING
,DI_OPERATION_STARTTIME
,DI_OPERATION_ENDTIME
,DI_TSP_MILEAGE1
,DI_TSP_MILEAGE2
,DI_TEMPERATURE1
,DI_TEMPERATURE2
,DI_HUMIDITY1
,DI_HUMIDITY2
,DI_TSP_SLOPE
,DI_TSP_INTERCEPT
,DI_WIND
,DI_PRESSURE
,DI_OTHER
,DI_ACCEPTANCE_TIME
,DI_MEASUREMENT
,DI_MEASUREMENT_TIME1
,DI_MEASUREMENT_TIME2
,DI_PERPER
,DI_DELFLAG
,DI_CREATION_TIME
</sql>
<sql id="where_conditions">
<if test="DI_ID != null and DI_ID != ''">
and DI_ID = #{DI_ID,jdbcType=DECIMAL}
</if>
<if test="DI_MFFID != null and DI_MFFID != ''">
and DI_MFFID = #{DI_MFFID,jdbcType=VARCHAR}
</if>
<if test="DI_FID != null and DI_FID != ''">
and DI_FID = #{DI_FID,jdbcType=VARCHAR}
</if>
<if test="DI_DEVICE_NAME != null and DI_DEVICE_NAME != ''">
and DI_DEVICE_NAME = #{DI_DEVICE_NAME,jdbcType=VARCHAR}
</if>
<if test="DI_DEVICE_MODEL != null and DI_DEVICE_MODEL != ''">
and DI_DEVICE_MODEL = #{DI_DEVICE_MODEL,jdbcType=VARCHAR}
</if>
<if test="DI_SERIAL_NUMBER != null and DI_SERIAL_NUMBER != ''">
and DI_SERIAL_NUMBER = #{DI_SERIAL_NUMBER,jdbcType=VARCHAR}
</if>
<if test="DI_MANUFACTURER != null and DI_MANUFACTURER != ''">
and DI_MANUFACTURER = #{DI_MANUFACTURER,jdbcType=VARCHAR}
</if>
<if test="DI_DIRECTION != null and DI_DIRECTION != ''">
and DI_DIRECTION = #{DI_DIRECTION,jdbcType=VARCHAR}
</if>
<if test="DI_ADDED_MONITORING != null and DI_ADDED_MONITORING != ''">
and DI_ADDED_MONITORING = #{DI_ADDED_MONITORING,jdbcType=VARCHAR}
</if>
<if test="DI_AGENT != null and DI_AGENT != ''">
and DI_AGENT = #{DI_AGENT,jdbcType=VARCHAR}
</if>
<if test="DI_LICENSE != null and DI_LICENSE != ''">
and DI_LICENSE = #{DI_LICENSE,jdbcType=VARCHAR}
</if>
<if test="DI_ENVIRONMENTAL != null and DI_ENVIRONMENTAL != ''">
and DI_ENVIRONMENTAL = #{DI_ENVIRONMENTAL,jdbcType=VARCHAR}
</if>
<if test="DI_PRINCIPLE != null and DI_PRINCIPLE != ''">
and DI_PRINCIPLE = #{DI_PRINCIPLE,jdbcType=VARCHAR}
</if>
<if test="DI_INSTALLATION_DATE != null and DI_INSTALLATION_DATE != ''">
and DI_INSTALLATION_DATE = #{DI_INSTALLATION_DATE,jdbcType=VARCHAR}
</if>
<if test="DI_OPERATING != null and DI_OPERATING != ''">
and DI_OPERATING = #{DI_OPERATING,jdbcType=DECIMAL}
</if>
<if test="DI_OPERATION_STARTTIME != null and DI_OPERATION_STARTTIME != ''">
and DI_OPERATION_STARTTIME = #{DI_OPERATION_STARTTIME,jdbcType=DECIMAL}
</if>
<if test="DI_OPERATION_ENDTIME != null and DI_OPERATION_ENDTIME != ''">
and DI_OPERATION_ENDTIME = #{DI_OPERATION_ENDTIME,jdbcType=DECIMAL}
</if>
<if test="DI_TSP_MILEAGE1 != null and DI_TSP_MILEAGE1 != ''">
and DI_TSP_MILEAGE1 = #{DI_TSP_MILEAGE1,jdbcType=DECIMAL}
</if>
<if test="DI_TSP_MILEAGE2 != null and DI_TSP_MILEAGE2 != ''">
and DI_TSP_MILEAGE2 = #{DI_TSP_MILEAGE2,jdbcType=DECIMAL}
</if>
<if test="DI_TEMPERATURE1 != null and DI_TEMPERATURE1 != ''">
and DI_TEMPERATURE1 = #{DI_TEMPERATURE1,jdbcType=DECIMAL}
</if>
<if test="DI_TEMPERATURE2 != null and DI_TEMPERATURE2 != ''">
and DI_TEMPERATURE2 = #{DI_TEMPERATURE2,jdbcType=DECIMAL}
</if>
<if test="DI_HUMIDITY1 != null and DI_HUMIDITY1 != ''">
and DI_HUMIDITY1 = #{DI_HUMIDITY1,jdbcType=DECIMAL}
</if>
<if test="DI_HUMIDITY2 != null and DI_HUMIDITY2 != ''">
and DI_HUMIDITY2 = #{DI_HUMIDITY2,jdbcType=DECIMAL}
</if>
<if test="DI_TSP_SLOPE != null and DI_TSP_SLOPE != ''">
and DI_TSP_SLOPE = #{DI_TSP_SLOPE,jdbcType=DECIMAL}
</if>
<if test="DI_TSP_INTERCEPT != null and DI_TSP_INTERCEPT != ''">
and DI_TSP_INTERCEPT = #{DI_TSP_INTERCEPT,jdbcType=DECIMAL}
</if>
<if test="DI_WIND != null and DI_WIND != ''">
and DI_WIND = #{DI_WIND,jdbcType=DECIMAL}
</if>
<if test="DI_PRESSURE != null and DI_PRESSURE != ''">
and DI_PRESSURE = #{DI_PRESSURE,jdbcType=DECIMAL}
</if>
<if test="DI_OTHER != null and DI_OTHER != ''">
and DI_OTHER = #{DI_OTHER,jdbcType=DECIMAL}
</if>
<if test="DI_ACCEPTANCE_TIME != null and DI_ACCEPTANCE_TIME != ''">
and DI_ACCEPTANCE_TIME = #{DI_ACCEPTANCE_TIME,jdbcType=DECIMAL}
</if>
<if test="DI_MEASUREMENT != null and DI_MEASUREMENT != ''">
and DI_MEASUREMENT = #{DI_MEASUREMENT,jdbcType=DECIMAL}
</if>
<if test="DI_MEASUREMENT_TIME1 != null and DI_MEASUREMENT_TIME1 != ''">
and DI_MEASUREMENT_TIME1 = #{DI_MEASUREMENT_TIME1,jdbcType=DECIMAL}
</if>
<if test="DI_MEASUREMENT_TIME2 != null and DI_MEASUREMENT_TIME2 != ''">
and DI_MEASUREMENT_TIME2 = #{DI_MEASUREMENT_TIME2,jdbcType=DECIMAL}
</if>
<if test="DI_PERPER != null and DI_PERPER != ''">
and DI_PERPER = #{DI_PERPER,jdbcType=DECIMAL}
</if>
<if test="DI_DELFLAG != null and DI_DELFLAG != ''">
and DI_DELFLAG = #{DI_DELFLAG,jdbcType=DECIMAL}
</if>
<if test="DI_CREATION_TIME != null and DI_CREATION_TIME != ''">
and DI_CREATION_TIME = #{DI_CREATION_TIME,jdbcType=DECIMAL}
</if>
</sql>
<!-- 新增方法 -->
<insert id="inserDeviceInfo" parameterType="deviceInfo" >
<selectKey keyProperty="DI_ID" order="BEFORE" resultType="Integer">
SELECT SEQ_DI_ID.NEXTVAL AS VALUE FROM DUAL
</selectKey>
insert into DEVICE_INFO(
DI_ID
,DI_MFFID
,DI_FID
,DI_DEVICE_NAME
,DI_DEVICE_MODEL
,DI_SERIAL_NUMBER
,DI_MANUFACTURER
,DI_DIRECTION
,DI_ADDED_MONITORING
,DI_AGENT
,DI_LICENSE
,DI_ENVIRONMENTAL
,DI_PRINCIPLE
,DI_INSTALLATION_DATE
,DI_OPERATING
,DI_OPERATION_STARTTIME
,DI_OPERATION_ENDTIME
,DI_TSP_MILEAGE1
,DI_TSP_MILEAGE2
,DI_TEMPERATURE1
,DI_TEMPERATURE2
,DI_HUMIDITY1
,DI_HUMIDITY2
,DI_TSP_SLOPE
,DI_TSP_INTERCEPT
,DI_WIND
,DI_PRESSURE
,DI_OTHER
,DI_ACCEPTANCE_TIME
,DI_MEASUREMENT
,DI_MEASUREMENT_TIME1
,DI_MEASUREMENT_TIME2
,DI_PERPER
,DI_DELFLAG
,DI_CREATION_TIME
)values(
#{ DI_ID,jdbcType=DECIMAL},
#{ DI_MFFID,jdbcType=VARCHAR},
#{ DI_FID,jdbcType=VARCHAR},
#{ DI_DEVICE_NAME,jdbcType=VARCHAR},
#{ DI_DEVICE_MODEL,jdbcType=VARCHAR},
#{ DI_SERIAL_NUMBER,jdbcType=VARCHAR},
#{ DI_MANUFACTURER,jdbcType=VARCHAR},
#{ DI_DIRECTION,jdbcType=VARCHAR},
#{ DI_ADDED_MONITORING,jdbcType=VARCHAR},
#{ DI_AGENT,jdbcType=VARCHAR},
#{ DI_LICENSE,jdbcType=VARCHAR},
#{ DI_ENVIRONMENTAL,jdbcType=VARCHAR},
#{ DI_PRINCIPLE,jdbcType=VARCHAR},
#{ DI_INSTALLATION_DATE,jdbcType=VARCHAR},
#{ DI_OPERATING,jdbcType=VARCHAR},
#{ DI_OPERATION_STARTTIME,jdbcType=VARCHAR},
#{ DI_OPERATION_ENDTIME,jdbcType=VARCHAR},
#{ DI_TSP_MILEAGE1,jdbcType=VARCHAR},
#{ DI_TSP_MILEAGE2,jdbcType=VARCHAR},
#{ DI_TEMPERATURE1,jdbcType=VARCHAR},
#{ DI_TEMPERATURE2,jdbcType=VARCHAR},
#{ DI_HUMIDITY1,jdbcType=VARCHAR},
#{ DI_HUMIDITY2,jdbcType=VARCHAR},
#{ DI_TSP_SLOPE,jdbcType=VARCHAR},
#{ DI_TSP_INTERCEPT,jdbcType=VARCHAR},
#{ DI_WIND,jdbcType=VARCHAR},
#{ DI_PRESSURE,jdbcType=VARCHAR},
#{ DI_OTHER,jdbcType=VARCHAR},
#{ DI_ACCEPTANCE_TIME,jdbcType=VARCHAR},
#{ DI_MEASUREMENT,jdbcType=VARCHAR},
#{ DI_MEASUREMENT_TIME1,jdbcType=VARCHAR},
#{ DI_MEASUREMENT_TIME2,jdbcType=VARCHAR},
#{ DI_PERPER,jdbcType=VARCHAR},
'0',
sysdate
)
</insert>
<!-- 查询方法 -->
<select id="selectDeviceInfoList" parameterType="deviceInfo" resultType="deviceInfo">
select
DI_ID
,DI_MFFID
,DI_FID
,DI_DEVICE_NAME
,DI_DEVICE_MODEL
,DI_SERIAL_NUMBER
,DI_MANUFACTURER
,DI_DIRECTION
,DI_ADDED_MONITORING
,DI_AGENT
,DI_LICENSE
,DI_ENVIRONMENTAL
,DI_PRINCIPLE
,DI_INSTALLATION_DATE
,DI_OPERATING
,DI_OPERATION_STARTTIME
,DI_OPERATION_ENDTIME
,DI_TSP_MILEAGE1
,DI_TSP_MILEAGE2
,DI_TEMPERATURE1
,DI_TEMPERATURE2
,DI_HUMIDITY1
,DI_HUMIDITY2
,DI_TSP_SLOPE
,DI_TSP_INTERCEPT
,DI_WIND
,DI_PRESSURE
,DI_OTHER
,DI_ACCEPTANCE_TIME
,DI_MEASUREMENT
,DI_MEASUREMENT_TIME1
,DI_MEASUREMENT_TIME2
,DI_PERPER
,DI_DELFLAG
,DI_CREATION_TIME
<include refid="Base_Column_List"/>
from DEVICE_INFO
<where>
1=1
<include refid="where_conditions"></include>
</where>
</select>
<!-- 修改方法 2019-09-25 15:04:38 YH-->
<update id="updateDevice" parameterType="deviceInfo">
update DEVICE_INFO
<set>
<if test="DI_ID != null and DI_ID != ''">
DI_ID = #{DI_ID,jdbcType=DECIMAL},
</if>
<if test="DI_MFFID != null and DI_MFFID != ''">
DI_MFFID = #{DI_MFFID,jdbcType=VARCHAR},
</if>
<if test="DI_FID != null and DI_FID != ''">
DI_FID = #{DI_FID,jdbcType=VARCHAR},
</if>
<if test="DI_DEVICE_NAME != null and DI_DEVICE_NAME != ''">
DI_DEVICE_NAME = #{DI_DEVICE_NAME,jdbcType=VARCHAR},
</if>
<if test="DI_DEVICE_MODEL != null and DI_DEVICE_MODEL != ''">
DI_DEVICE_MODEL = #{DI_DEVICE_MODEL,jdbcType=VARCHAR},
</if>
<if test="DI_SERIAL_NUMBER != null and DI_SERIAL_NUMBER != ''">
DI_SERIAL_NUMBER = #{DI_SERIAL_NUMBER,jdbcType=VARCHAR},
</if>
<if test="DI_MANUFACTURER != null and DI_MANUFACTURER != ''">
DI_MANUFACTURER = #{DI_MANUFACTURER,jdbcType=VARCHAR},
</if>
<if test="DI_DIRECTION != null and DI_DIRECTION != ''">
DI_DIRECTION = #{DI_DIRECTION,jdbcType=VARCHAR},
</if>
<if test="DI_ADDED_MONITORING != null and DI_ADDED_MONITORING != ''">
DI_ADDED_MONITORING = #{DI_ADDED_MONITORING,jdbcType=VARCHAR},
</if>
<if test="DI_AGENT != null and DI_AGENT != ''">
DI_AGENT = #{DI_AGENT,jdbcType=VARCHAR},
</if>
<if test="DI_LICENSE != null and DI_LICENSE != ''">
DI_LICENSE = #{DI_LICENSE,jdbcType=VARCHAR},
</if>
<if test="DI_ENVIRONMENTAL != null and DI_ENVIRONMENTAL != ''">
DI_ENVIRONMENTAL = #{DI_ENVIRONMENTAL,jdbcType=VARCHAR},
</if>
<if test="DI_PRINCIPLE != null and DI_PRINCIPLE != ''">
DI_PRINCIPLE = #{DI_PRINCIPLE,jdbcType=VARCHAR},
</if>
<if test="DI_INSTALLATION_DATE != null and DI_INSTALLATION_DATE != ''">
DI_INSTALLATION_DATE = #{DI_INSTALLATION_DATE,jdbcType=VARCHAR},
</if>
<if test="DI_OPERATING != null and DI_OPERATING != ''">
DI_OPERATING = #{DI_OPERATING,jdbcType=VARCHAR},
</if>
<if test="DI_OPERATION_STARTTIME != null and DI_OPERATION_STARTTIME != ''">
DI_OPERATION_STARTTIME = #{DI_OPERATION_STARTTIME,jdbcType=VARCHAR},
</if>
<if test="DI_OPERATION_ENDTIME != null and DI_OPERATION_ENDTIME != ''">
DI_OPERATION_ENDTIME = #{DI_OPERATION_ENDTIME,jdbcType=VARCHAR},
</if>
<if test="DI_TSP_MILEAGE1 != null and DI_TSP_MILEAGE1 != ''">
DI_TSP_MILEAGE1 = #{DI_TSP_MILEAGE1,jdbcType=VARCHAR},
</if>
<if test="DI_TSP_MILEAGE2 != null and DI_TSP_MILEAGE2 != ''">
DI_TSP_MILEAGE2 = #{DI_TSP_MILEAGE2,jdbcType=VARCHAR},
</if>
<if test="DI_TEMPERATURE1 != null and DI_TEMPERATURE1 != ''">
DI_TEMPERATURE1 = #{DI_TEMPERATURE1,jdbcType=VARCHAR},
</if>
<if test="DI_TEMPERATURE2 != null and DI_TEMPERATURE2 != ''">
DI_TEMPERATURE2 = #{DI_TEMPERATURE2,jdbcType=VARCHAR},
</if>
<if test="DI_HUMIDITY1 != null and DI_HUMIDITY1 != ''">
DI_HUMIDITY1 = #{DI_HUMIDITY1,jdbcType=VARCHAR},
</if>
<if test="DI_HUMIDITY2 != null and DI_HUMIDITY2 != ''">
DI_HUMIDITY2 = #{DI_HUMIDITY2,jdbcType=VARCHAR},
</if>
<if test="DI_TSP_SLOPE != null and DI_TSP_SLOPE != ''">
DI_TSP_SLOPE = #{DI_TSP_SLOPE,jdbcType=VARCHAR},
</if>
<if test="DI_TSP_INTERCEPT != null and DI_TSP_INTERCEPT != ''">
DI_TSP_INTERCEPT = #{DI_TSP_INTERCEPT,jdbcType=VARCHAR},
</if>
<if test="DI_WIND != null and DI_WIND != ''">
DI_WIND = #{DI_WIND,jdbcType=VARCHAR},
</if>
<if test="DI_PRESSURE != null and DI_PRESSURE != ''">
DI_PRESSURE = #{DI_PRESSURE,jdbcType=VARCHAR},
</if>
<if test="DI_OTHER != null and DI_OTHER != ''">
DI_OTHER = #{DI_OTHER,jdbcType=VARCHAR},
</if>
<if test="DI_ACCEPTANCE_TIME != null and DI_ACCEPTANCE_TIME != ''">
DI_ACCEPTANCE_TIME = #{DI_ACCEPTANCE_TIME,jdbcType=VARCHAR},
</if>
<if test="DI_MEASUREMENT != null and DI_MEASUREMENT != ''">
DI_MEASUREMENT = #{DI_MEASUREMENT,jdbcType=VARCHAR},
</if>
<if test="DI_MEASUREMENT_TIME1 != null and DI_MEASUREMENT_TIME1 != ''">
DI_MEASUREMENT_TIME1 = #{DI_MEASUREMENT_TIME1,jdbcType=VARCHAR},
</if>
<if test="DI_MEASUREMENT_TIME2 != null and DI_MEASUREMENT_TIME2 != ''">
DI_MEASUREMENT_TIME2 = #{DI_MEASUREMENT_TIME2,jdbcType=VARCHAR},
</if>
<if test="DI_PERPER != null and DI_PERPER != ''">
DI_PERPER = #{DI_PERPER,jdbcType=VARCHAR},
</if>
<if test="DI_DELFLAG != null and DI_DELFLAG != ''">
DI_DELFLAG = #{DI_DELFLAG,jdbcType=VARCHAR},
</if>
<if test="DI_CREATION_TIME != null and DI_CREATION_TIME != ''">
DI_CREATION_TIME = #{DI_CREATION_TIME,jdbcType=VARCHAR},
</if>
</set>
where DI_MFFID=#{DI_MFFID,jdbcType=VARCHAR}
</update>
</mapper>
MonitoringFactorMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="enytek.com.cn.dao.corpprateinfo.MonitoringFactorDao">
<sql id="Base_Column_List">
MF_ID
,MF_MPFID
,MF_FID
,MF_FACTOR
,MF_STANDARD
,MF_EXECUTIVE_DESCRIPTION
,MF_STATUS
,MF_OPERATING
,MF_PERPER
,MF_DELFLAG
,MF_CREATION_TIME
</sql>
<sql id="where_conditions">
<if test="MF_ID != null and MF_ID != ''">
and MF_ID = #{MF_ID,jdbcType=DECIMAL}
</if>
<if test="MF_MPFID != null and MF_MPFID != ''">
and MF_MPFID = #{MF_MPFID,jdbcType=VARCHAR}
</if>
<if test="MF_FID != null and MF_FID != ''">
and MF_FID = #{MF_FID,jdbcType=VARCHAR}
</if>
<if test="MF_FACTOR != null and MF_FACTOR != ''">
and MF_FACTOR = #{MF_FACTOR,jdbcType=VARCHAR}
</if>
<if test="MF_STANDARD != null and MF_STANDARD != ''">
and MF_STANDARD = #{MF_STANDARD,jdbcType=VARCHAR}
</if>
<if test="MF_EXECUTIVE_DESCRIPTION != null and MF_EXECUTIVE_DESCRIPTION != ''">
and MF_EXECUTIVE_DESCRIPTION = #{MF_EXECUTIVE_DESCRIPTION,jdbcType=VARCHAR}
</if>
<if test="MF_STATUS != null and MF_STATUS != ''">
and MF_STATUS = #{MF_STATUS,jdbcType=VARCHAR}
</if>
<if test="MF_OPERATING != null and MF_OPERATING != ''">
and MF_OPERATING = #{MF_OPERATING,jdbcType=VARCHAR}
</if>
<if test="MF_PERPER != null and MF_PERPER != ''">
and MF_PERPER = #{MF_PERPER,jdbcType=VARCHAR}
</if>
</sql>
<!-- 新增方法 -->
<insert id="inserMonitoringFactor" parameterType="monitoringFactor">
<selectKey resultType="Integer" keyProperty="MF_ID" order="BEFORE">
SELECT SEQ_MF_ID.NEXTVAL AS VALUE FROM DUAL
</selectKey>
insert into MONITORING_FACTOR(
MF_ID
,MF_MPFID
,MF_FID
,MF_FACTOR
,MF_STANDARD
,MF_EXECUTIVE_DESCRIPTION
,MF_STATUS
,MF_OPERATING
,MF_PERPER
,MF_DELFLAG
,MF_CREATION_TIME,
MF_CHECKED
)values(
#{ MF_ID,jdbcType=DECIMAL},
#{ MF_MPFID,jdbcType=VARCHAR},
#{ MF_FID,jdbcType=VARCHAR},
#{ MF_FACTOR,jdbcType=VARCHAR},
#{ MF_STANDARD,jdbcType=VARCHAR},
#{ MF_EXECUTIVE_DESCRIPTION,jdbcType=VARCHAR},
#{ MF_STATUS,jdbcType=VARCHAR},
#{ MF_OPERATING,jdbcType=VARCHAR},
#{ MF_PERPER,jdbcType=VARCHAR},
#{ MF_DELFLAG,jdbcType=VARCHAR},
#{ MF_CREATION_TIME,jdbcType=DATE},
#{ MF_CHECKED,jdbcType=DATE}
)
</insert>
<!-- 查询方法 -->
<select id="selectMonitoringFactorList" parameterType="monitoringFactor" resultType="monitoringFactor">
select
MF_ID
,MF_MPFID
,MF_FID
,MF_FACTOR
,MF_STANDARD
,MF_EXECUTIVE_DESCRIPTION
,MF_STATUS
,MF_OPERATING
,MF_PERPER
,MF_DELFLAG
,to_char(MF_CREATION_TIME,'yyyy-MM-dd') MF_CREATION_TIME
,(select sdd_dictionary_cname from SYS_DATA_DICTIONARY where sdd_dictionary='0030' and SDD_DELFALG='0' and MF_FACTOR=sdd_dictionary_code) MF_FACTOR_NAME
,MF_CHECKED
<!-- <include refid="Base_Column_List"/> -->
from MONITORING_FACTOR
<where>
MF_DELFLAG='0'
<include refid="where_conditions"/>
</where>
</select>
<!-- 批量新增方法 -->
<insert id="batchInsertMonitoringFactor" parameterType="monitoringFactor">
insert into MONITORING_FACTOR (
MF_ID
,MF_MPFID
,MF_FID
,MF_FACTOR
,MF_STANDARD
,MF_EXECUTIVE_DESCRIPTION
,MF_STATUS
,MF_OPERATING
,MF_PERPER
,MF_DELFLAG
,MF_CREATION_TIME
,MF_CHECKED
)
select SEQ_MF_ID.nextval, cd.* from (
<foreach collection="list" item="item" index="index" separator="union all">
select
#{item.MF_MPFID,jdbcType=VARCHAR},
#{item.MF_FID,jdbcType=VARCHAR},
#{item.MF_FACTOR,jdbcType=VARCHAR},
#{item.MF_STANDARD,jdbcType=VARCHAR},
#{item.MF_EXECUTIVE_DESCRIPTION,jdbcType=VARCHAR},
#{item.MF_STATUS,jdbcType=VARCHAR},
#{item.MF_OPERATING,jdbcType=VARCHAR},
#{item.MF_PERPER,jdbcType=VARCHAR},
<!-- #{item.MF_DELFLAG,jdbcType=VARCHAR}, -->
'0',
sysdate,
#{item.MF_CHECKED,jdbcType=VARCHAR}
from dual
</foreach>
) cd
</insert>
<!-- 修改方法 2019-09-25 15:04:38 YH-->
<update id="updateMonitoringFactor" parameterType="monitoringFactor">
update MONITORING_FACTOR
<set>
<if test="MF_ID != null and MF_ID != ''">
MF_ID = #{MF_ID,jdbcType=DECIMAL},
</if>
<if test="MF_MPFID != null and MF_MPFID != ''">
MF_MPFID = #{MF_MPFID,jdbcType=VARCHAR},
</if>
<if test="MF_FID != null and MF_FID != ''">
MF_FID = #{MF_FID,jdbcType=VARCHAR},
</if>
<if test="MF_FACTOR != null and MF_FACTOR != ''">
MF_FACTOR = #{MF_FACTOR,jdbcType=VARCHAR},
</if>
<if test="MF_STANDARD != null and MF_STANDARD != ''">
MF_STANDARD = #{MF_STANDARD,jdbcType=VARCHAR},
</if>
<if test="MF_EXECUTIVE_DESCRIPTION != null and MF_EXECUTIVE_DESCRIPTION != ''">
MF_EXECUTIVE_DESCRIPTION = #{MF_EXECUTIVE_DESCRIPTION,jdbcType=VARCHAR},
</if>
<if test="MF_STATUS != null and MF_STATUS != ''">
MF_STATUS = #{MF_STATUS,jdbcType=VARCHAR},
</if>
<if test="MF_OPERATING != null and MF_OPERATING != ''">
MF_OPERATING = #{MF_OPERATING,jdbcType=VARCHAR},
</if>
<if test="MF_PERPER != null and MF_PERPER != ''">
MF_PERPER = #{MF_PERPER,jdbcType=VARCHAR},
</if>
</set>
where MF_MPFID=#{MF_MPFID,jdbcType=VARCHAR}
</update>
<!-- 删除方法 -->
<delete id="deleteMonitoringFactor" parameterType="monitoringFactor">
delete MONITORING_FACTOR
where MF_MPFID=#{MF_MPFID,jdbcType=VARCHAR}
</delete>
</mapper>
MonitoringPointMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="enytek.com.cn.dao.corpprateinfo.MonitoringPointDao">
<sql id="Base_Column_List">
MP_ID
,MP_CIFID
,MP_FID
,MP_POINT_FULLNAME
,MP_ADDRESS
,MP_LONGITUDE
,MP_LATITUDE
,to_char(MP_NETWORK_STARTTIME,'yyyy-MM-dd') MP_NETWORK_STARTTIME
,MP_INFORMATION
,to_char(MP_INSTALLATIONTIME,'yyyy-MM-dd') MP_INSTALLATIONTIME
,MP_MN
,MP_PERPER
,MP_DELFLAG
,MP_CREATION_TIME
</sql>
<sql id="where_conditions">
<if test="MP_ID != null and MP_ID != ''">
and MP_ID = #{MP_ID,jdbcType=DECIMAL}
</if>
<if test="MP_CIFID != null and MP_CIFID != ''">
and MP_CIFID = #{MP_CIFID,jdbcType=VARCHAR}
</if>
<if test="MP_FID != null and MP_FID != ''">
and MP_FID = #{MP_FID,jdbcType=VARCHAR}
</if>
<if test="MP_POINT_FULLNAME != null and MP_POINT_FULLNAME != ''">
and MP_POINT_FULLNAME = #{MP_POINT_FULLNAME,jdbcType=VARCHAR}
</if>
<if test="MP_ADDRESS != null and MP_ADDRESS != ''">
and MP_ADDRESS = #{MP_ADDRESS,jdbcType=VARCHAR}
</if>
<if test="MP_LONGITUDE != null and MP_LONGITUDE != ''">
and MP_LONGITUDE = #{MP_LONGITUDE,jdbcType=VARCHAR}
</if>
<if test="MP_NETWORK_STARTTIME != null and MP_NETWORK_STARTTIME != ''">
and MP_NETWORK_STARTTIME = to_date(#{MP_NETWORK_STARTTIME},'yyyy-mm-dd')
</if>
<if test="MP_INFORMATION != null and MP_INFORMATION != ''">
and MP_INFORMATION = #{MP_INFORMATION,jdbcType=VARCHAR}
</if>
<if test="MP_INSTALLATIONTIME != null and MP_INSTALLATIONTIME != ''">
and MP_INSTALLATIONTIME = to_date(#{MP_INSTALLATIONTIME},'yyyy-mm-dd')
</if>
<if test="MP_MN != null and MP_MN != ''">
and MP_MN = #{MP_MN,jdbcType=VARCHAR}
</if>
<if test="MP_PERPER != null and MP_PERPER != ''">
and MP_PERPER = #{MP_PERPER,jdbcType=VARCHAR}
</if>
<if test="MP_DELFLAG != null and MP_DELFLAG != ''">
and MP_DELFLAG = #{MP_DELFLAG,jdbcType=VARCHAR}
</if>
<if test="MP_CREATION_TIME != null and MP_CREATION_TIME != ''">
and MP_CREATION_TIME = #{MP_CREATION_TIME,jdbcType=VARCHAR}
</if>
</sql>
<!-- 新增方法 -->
<insert id="inserMonitoringPoint" parameterType="monitoringPoint">
<selectKey resultType="Integer" keyProperty="MP_ID" order="BEFORE">
SELECT SEQ_MP_ID.NEXTVAL AS VALUE FROM DUAL
</selectKey>
insert into MONITORING_POINT(
MP_ID
,MP_CIFID
,MP_FID
,MP_POINT_FULLNAME
,MP_ADDRESS
,MP_LONGITUDE
,MP_LATITUDE
,MP_NETWORK_STARTTIME
,MP_INFORMATION
,MP_INSTALLATIONTIME
,MP_MN
,MP_PERPER
,MP_DELFLAG
,MP_CREATION_TIME
)values(
#{ MP_ID,jdbcType=DECIMAL},
#{ MP_CIFID,jdbcType=VARCHAR},
#{ MP_FID,jdbcType=VARCHAR},
#{ MP_POINT_FULLNAME,jdbcType=VARCHAR},
#{ MP_ADDRESS,jdbcType=VARCHAR},
#{ MP_LONGITUDE,jdbcType=VARCHAR},
#{ MP_LATITUDE,jdbcType=VARCHAR},
<!-- #{ MP_NETWORK_STARTTIME,jdbcType=VARCHAR}, -->
to_date(#{MP_NETWORK_STARTTIME},'yyyy-MM-dd '),
#{ MP_INFORMATION,jdbcType=VARCHAR},
<!-- #{ MP_INSTALLATIONTIME,jdbcType=VARCHAR}, -->
to_date(#{MP_INSTALLATIONTIME},'yyyy-MM-dd '),
#{ MP_MN,jdbcType=VARCHAR},
#{ MP_PERPER,jdbcType=VARCHAR},
'0',
sysdate
)
</insert>
<!-- 查询方法 -->
<select id="selectMonitoringPointList" parameterType="monitoringPoint" resultType="monitoringPoint">
select
<include refid="Base_Column_List"/>
from MONITORING_POINT
<where>
1=1
<include refid="where_conditions"/>
</where>
</select>
<!-- 修改方法 2019-09-25 15:04:38 YH-->
<update id="updateMonitoringPoint" parameterType="monitoringPoint">
update MONITORING_POINT
<set>
<if test="MP_ID != null and MP_ID != ''">
MP_ID = #{MP_ID,jdbcType=DECIMAL},
</if>
<if test="MP_CIFID != null and MP_CIFID != ''">
MP_CIFID = #{MP_CIFID,jdbcType=VARCHAR},
</if>
<if test="MP_FID != null and MP_FID != ''">
MP_FID = #{MP_FID,jdbcType=VARCHAR},
</if>
<if test="MP_POINT_FULLNAME != null and MP_POINT_FULLNAME != ''">
MP_POINT_FULLNAME = #{MP_POINT_FULLNAME,jdbcType=VARCHAR},
</if>
<if test="MP_ADDRESS != null and MP_ADDRESS != ''">
MP_ADDRESS = #{MP_ADDRESS,jdbcType=VARCHAR},
</if>
<if test="MP_LONGITUDE != null and MP_LONGITUDE != ''">
MP_LONGITUDE = #{MP_LONGITUDE,jdbcType=VARCHAR},
</if>
<if test="MP_NETWORK_STARTTIME != null and MP_NETWORK_STARTTIME != ''">
MP_NETWORK_STARTTIME = to_date(#{MP_NETWORK_STARTTIME},'yyyy-mm-dd '),
</if>
<if test="MP_INFORMATION != null and MP_INFORMATION != ''">
MP_INFORMATION = #{MP_INFORMATION,jdbcType=VARCHAR},
</if>
<if test="MP_INSTALLATIONTIME != null and MP_INSTALLATIONTIME != ''">
MP_INSTALLATIONTIME = to_date(#{MP_INSTALLATIONTIME},'yyyy-mm-dd '),
</if>
<if test="MP_MN != null and MP_MN != ''">
MP_MN = #{MP_MN,jdbcType=VARCHAR},
</if>
<if test="MP_PERPER != null and MP_PERPER != ''">
MP_PERPER = #{MP_PERPER,jdbcType=VARCHAR},
</if>
<if test="MP_DELFLAG != null and MP_DELFLAG != ''">
MP_DELFLAG = #{MP_DELFLAG,jdbcType=VARCHAR},
</if>
<if test="MP_CREATION_TIME != null and MP_CREATION_TIME != ''">
MP_CREATION_TIME = #{MP_CREATION_TIME,jdbcType=VARCHAR},
</if>
</set>
where MP_CIFID=#{MP_CIFID,jdbcType=VARCHAR}
</update>
</mapper>
dao层(4张表)
CorpprateinfoDao.java
package enytek.com.cn.dao.corpprateinfo;
import java.util.List;
import enytek.com.cn.model.corpprateinfo.CorpprateinfoModel;
public interface CorpprateinfoDao {
public int inserCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception;
public int updateCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception;
public Integer deleteCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception;
public Integer deleteCorpprateinfoList(CorpprateinfoModel corpprateinfo) throws Exception;
public List<CorpprateinfoModel> selectCorpprateinfoList(CorpprateinfoModel corpprateinfo) throws Exception;
public List<CorpprateinfoModel> selectCorpprateinfoPaging(CorpprateinfoModel corpprateinfo) throws Exception;
public Integer selectCorpprateinfoCount(CorpprateinfoModel corpprateinfo) throws Exception;
public int batchInsertCorpprateinfo(List<CorpprateinfoModel> corpprateinfo) throws Exception;
public Integer audit(CorpprateinfoModel entity);
}
DeviceInfoDao.java
package enytek.com.cn.dao.corpprateinfo;
import java.util.List;
import enytek.com.cn.model.corpprateinfo.DeviceInfoModel;
public interface DeviceInfoDao {
public int inserDeviceInfo(DeviceInfoModel deviceInfo) throws Exception;
public int updateDeviceInfo(DeviceInfoModel deviceInfo) throws Exception;
public Integer deleteDeviceInfo(DeviceInfoModel deviceInfo) throws Exception;
public Integer deleteDeviceInfoList(DeviceInfoModel deviceInfo) throws Exception;
public List<DeviceInfoModel> selectDeviceInfoList(DeviceInfoModel deviceInfo) throws Exception;
public List<DeviceInfoModel> selectDeviceInfoPaging(DeviceInfoModel deviceInfo) throws Exception;
public Integer selectDeviceInfoCount(DeviceInfoModel deviceInfo) throws Exception;
public int batchInsertDeviceInfo(List<DeviceInfoModel> deviceInfo) throws Exception;
}
MonitoringFactorDao.java
package enytek.com.cn.dao.corpprateinfo;
import java.util.List;
import enytek.com.cn.model.corpprateinfo.MonitoringFactorModel;
public interface MonitoringFactorDao {
public int inserMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception;
public int updateMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception;
public Integer deleteMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception;
public Integer deleteMonitoringFactorList(MonitoringFactorModel monitoringFactor) throws Exception;
public List<MonitoringFactorModel> selectMonitoringFactorList(MonitoringFactorModel monitoringFactor) throws Exception;
public List<MonitoringFactorModel> selectMonitoringFactorPaging(MonitoringFactorModel monitoringFactor) throws Exception;
public Integer selectMonitoringFactorCount(MonitoringFactorModel monitoringFactor) throws Exception;
public int batchInsertMonitoringFactor(List<MonitoringFactorModel> monitoringFactor) throws Exception;
}
MonitoringPointDao.java
package enytek.com.cn.dao.corpprateinfo;
import java.util.List;
import enytek.com.cn.model.corpprateinfo.MonitoringPointModel;
public interface MonitoringPointDao {
public int inserMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception;
public int updateMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception;
public Integer deleteMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception;
public Integer deleteMonitoringPointList(MonitoringPointModel monitoringPoint) throws Exception;
public List<MonitoringPointModel> selectMonitoringPointList(MonitoringPointModel monitoringPoint) throws Exception;
public List<MonitoringPointModel> selectMonitoringPointPaging(MonitoringPointModel monitoringPoint) throws Exception;
public Integer selectMonitoringPointCount(MonitoringPointModel monitoringPoint) throws Exception;
public int batchInsertMonitoringPoint(List<MonitoringPointModel> monitoringPoint) throws Exception;
}
daoImpl(4张表)
package enytek.com.cn.dao.Impl.corpprateinfo;
import java.util.List;
import org.springframework.stereotype.Repository;
import enytek.com.cn.base.PublicSqlSessionDao;
import enytek.com.cn.dao.corpprateinfo.CorpprateinfoDao;
import enytek.com.cn.model.corpprateinfo.CorpprateinfoModel;
@Repository("CorpprateinfoDao")
public class CorpprateinfoDaoImpl extends PublicSqlSessionDao implements CorpprateinfoDao {
public int inserCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception {
return this.getSqlSession().insert("inserCorpprateinfo",corpprateinfo);
}
public int updateCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception {
return this.getSqlSession().update("updateCorpprateinfo",corpprateinfo);
}
public Integer deleteCorpprateinfo(CorpprateinfoModel corpprateinfo) throws Exception {
return this.getSqlSession().delete("deleteCorpprateinfo",corpprateinfo);
}
public Integer deleteCorpprateinfoList(CorpprateinfoModel corpprateinfo) throws Exception {
return this.getSqlSession().delete("deleteCorpprateinfoList",corpprateinfo);
}
public List<CorpprateinfoModel> selectCorpprateinfoList(CorpprateinfoModel corpprateinfo) throws Exception {
return this.getSqlSession().selectList("selectCorpprateinfoList",corpprateinfo);
}
public List<CorpprateinfoModel> selectCorpprateinfoPaging(CorpprateinfoModel corpprateinfo) throws Exception {
return this.getSqlSession().selectList("selectCorpprateinfoPaging",corpprateinfo);
}
public Integer selectCorpprateinfoCount(CorpprateinfoModel corpprateinfo) throws Exception {
return this.getSqlSession().selectOne("selectCorpprateinfoCount",corpprateinfo);
}
public int batchInsertCorpprateinfo(List<CorpprateinfoModel> corpprateinfo) throws Exception {
return this.getSqlSession().insert("batchInsertCorpprateinfo", corpprateinfo);
}
@Override
public Integer audit(CorpprateinfoModel entity) {
return this.getSqlSession().update("auditCorpprateinfo",entity);
}
}
DeviceInfoDaoImpl.java
package enytek.com.cn.dao.Impl.corpprateinfo;
import java.util.List;
import org.springframework.stereotype.Repository;
import enytek.com.cn.base.PublicSqlSessionDao;
import enytek.com.cn.dao.corpprateinfo.DeviceInfoDao;
import enytek.com.cn.model.corpprateinfo.DeviceInfoModel;
@Repository("DeviceInfoDao")
public class DeviceInfoDaoImpl extends PublicSqlSessionDao implements DeviceInfoDao {
public int inserDeviceInfo(DeviceInfoModel deviceInfo) throws Exception {
return this.getSqlSession().insert("inserDeviceInfo", deviceInfo);
}
public int updateDeviceInfo(DeviceInfoModel deviceInfo) throws Exception {
return this.getSqlSession().update("updateDevice", deviceInfo);
}
public Integer deleteDeviceInfo(DeviceInfoModel deviceInfo) throws Exception {
return this.getSqlSession().delete("deleteDeviceInfo", deviceInfo);
}
public Integer deleteDeviceInfoList(DeviceInfoModel deviceInfo) throws Exception {
return this.getSqlSession().delete("deleteDeviceInfoList", deviceInfo);
}
public List<DeviceInfoModel> selectDeviceInfoList(DeviceInfoModel deviceInfo) throws Exception {
return this.getSqlSession().selectList("selectDeviceInfoList", deviceInfo);
}
public List<DeviceInfoModel> selectDeviceInfoPaging(DeviceInfoModel deviceInfo) throws Exception {
return this.getSqlSession().selectList("selectDeviceInfoPaging", deviceInfo);
}
public Integer selectDeviceInfoCount(DeviceInfoModel deviceInfo) throws Exception {
return this.getSqlSession().selectOne("selectDeviceInfoCount", deviceInfo);
}
public int batchInsertDeviceInfo(List<DeviceInfoModel> deviceInfo) throws Exception {
return this.getSqlSession().insert("batchInsertDeviceInfo", deviceInfo);
}
}
MonitoringFactorDaoImpl.java
package enytek.com.cn.dao.Impl.corpprateinfo;
import java.util.List;
import org.springframework.stereotype.Repository;
import enytek.com.cn.base.PublicSqlSessionDao;
import enytek.com.cn.dao.corpprateinfo.MonitoringFactorDao;
import enytek.com.cn.model.corpprateinfo.MonitoringFactorModel;
@Repository("MonitoringFactorDao")
public class MonitoringFactorDaoImpl extends PublicSqlSessionDao implements MonitoringFactorDao {
public int inserMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception {
return this.getSqlSession().insert("inserMonitoringFactor", monitoringFactor);
}
public int updateMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception {
return this.getSqlSession().update("updateMonitoringFactor", monitoringFactor);
}
public Integer deleteMonitoringFactor(MonitoringFactorModel monitoringFactor) throws Exception {
return this.getSqlSession().delete("deleteMonitoringFactor", monitoringFactor);
}
public Integer deleteMonitoringFactorList(MonitoringFactorModel monitoringFactor) throws Exception {
return this.getSqlSession().delete("deleteMonitoringFactorList", monitoringFactor);
}
public List<MonitoringFactorModel> selectMonitoringFactorList(MonitoringFactorModel monitoringFactor) throws Exception {
return this.getSqlSession().selectList("selectMonitoringFactorList", monitoringFactor);
}
public List<MonitoringFactorModel> selectMonitoringFactorPaging(MonitoringFactorModel monitoringFactor) throws Exception {
return this.getSqlSession().selectList("selectMonitoringFactorPaging", monitoringFactor);
}
public Integer selectMonitoringFactorCount(MonitoringFactorModel monitoringFactor) throws Exception {
return this.getSqlSession().selectOne("selectMonitoringFactorCount", monitoringFactor);
}
public int batchInsertMonitoringFactor(List<MonitoringFactorModel> monitoringFactor) throws Exception {
return this.getSqlSession().insert("batchInsertMonitoringFactor", monitoringFactor);
}
}
MonitoringFactorDaoImpl.java
package enytek.com.cn.dao.Impl.corpprateinfo;
import java.util.List;
import org.springframework.stereotype.Repository;
import enytek.com.cn.base.PublicSqlSessionDao;
import enytek.com.cn.dao.corpprateinfo.MonitoringPointDao;
import enytek.com.cn.model.corpprateinfo.MonitoringPointModel;
@Repository("MonitoringPointDao")
public class MonitoringPointDaoImpl extends PublicSqlSessionDao implements MonitoringPointDao {
public int inserMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception {
return this.getSqlSession().insert("inserMonitoringPoint", monitoringPoint);
}
public int updateMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception {
return this.getSqlSession().update("updateMonitoringPoint", monitoringPoint);
}
public Integer deleteMonitoringPoint(MonitoringPointModel monitoringPoint) throws Exception {
return this.getSqlSession().delete("deleteMonitoringPoint", monitoringPoint);
}
public Integer deleteMonitoringPointList(MonitoringPointModel monitoringPoint) throws Exception {
return this.getSqlSession().delete("deleteMonitoringPointList", monitoringPoint);
}
public List<MonitoringPointModel> selectMonitoringPointList(MonitoringPointModel monitoringPoint) throws Exception {
return this.getSqlSession().selectList("selectMonitoringPointList", monitoringPoint);
}
public List<MonitoringPointModel> selectMonitoringPointPaging(MonitoringPointModel monitoringPoint) throws Exception {
return this.getSqlSession().selectList("selectMonitoringPointPaging", monitoringPoint);
}
public Integer selectMonitoringPointCount(MonitoringPointModel monitoringPoint) throws Exception {
return this.getSqlSession().selectOne("selectMonitoringPointCount", monitoringPoint);
}
public int batchInsertMonitoringPoint(List<MonitoringPointModel> monitoringPoint) throws Exception {
return this.getSqlSession().insert("batchInsertMonitoringPoint", monitoringPoint);
}
}
实体类层
CorpprateinfoModel.java
package enytek.com.cn.model.corpprateinfo;
import java.util.List;
public class CorpprateinfoModel {
private Integer CI_ID;
private String CI_FID;
private String CI_NAME;
private String CI_PRINCIPAL;
private String CI_PHONE;
private String CI_ADDRESS;
private String CI_LONGITUDE;
private String CI_LATITUDE;
private String CI_AUDIT;
private String CI_PERPER;
private String CI_DELFLAG;
private String CI_CREATION_TIME;
private String CI_ADDRESSCON;
private Integer StartPage;
private Integer EndPage;
private String rownum_;
private String company_name;
private String creater_in;
private List<MonitoringFactorModel> listmf;
public List<MonitoringFactorModel> getListmf() {
return listmf;
}
public void setListmf(List<MonitoringFactorModel> listmf) {
this.listmf = listmf;
}
public String getCreater_in() {
return creater_in;
}
public void setCreater_in(String creater_in) {
this.creater_in = creater_in;
}
public String getCompany_name() {
return company_name;
}
public void setCompany_name(String company_name) {
this.company_name = company_name;
}
public CorpprateinfoModel() {
super();
}
public CorpprateinfoModel(Integer cI_ID, String cI_FID, String cI_NAME,
String cI_PRINCIPAL, String cI_PHONE, String cI_ADDRESS,
String cI_LONGITUDE, String cI_LATITUDE, String cI_AUDIT,
String cI_PERPER, String cI_DELFLAG, String cI_CREATION_TIME,
String cI_ADDRESSCON, Integer startPage, Integer endPage,
String rownum_) {
super();
CI_ID = cI_ID;
CI_FID = cI_FID;
CI_NAME = cI_NAME;
CI_PRINCIPAL = cI_PRINCIPAL;
CI_PHONE = cI_PHONE;
CI_ADDRESS = cI_ADDRESS;
CI_LONGITUDE = cI_LONGITUDE;
CI_LATITUDE = cI_LATITUDE;
CI_AUDIT = cI_AUDIT;
CI_PERPER = cI_PERPER;
CI_DELFLAG = cI_DELFLAG;
CI_CREATION_TIME = cI_CREATION_TIME;
CI_ADDRESSCON = cI_ADDRESSCON;
StartPage = startPage;
EndPage = endPage;
this.rownum_ = rownum_;
}
public Integer getStartPage() {
return StartPage;
}
public void setStartPage(Integer startPage) {
StartPage = startPage;
}
public Integer getEndPage() {
return EndPage;
}
public void setEndPage(Integer endPage) {
EndPage = endPage;
}
public String getRownum_() {
return rownum_;
}
public void setRownum_(String rownum_) {
this.rownum_ = rownum_;
}
public Integer getCI_ID() {
return CI_ID;
}
public void setCI_ID(Integer cI_ID) {
CI_ID = cI_ID;
}
public String getCI_FID() {
return CI_FID;
}
public void setCI_FID(String cI_FID) {
CI_FID = cI_FID;
}
public String getCI_NAME() {
return CI_NAME;
}
public void setCI_NAME(String cI_NAME) {
CI_NAME = cI_NAME;
}
public String getCI_PRINCIPAL() {
return CI_PRINCIPAL;
}
public void setCI_PRINCIPAL(String cI_PRINCIPAL) {
CI_PRINCIPAL = cI_PRINCIPAL;
}
public String getCI_PHONE() {
return CI_PHONE;
}
public void setCI_PHONE(String cI_PHONE) {
CI_PHONE = cI_PHONE;
}
public String getCI_ADDRESS() {
return CI_ADDRESS;
}
public void setCI_ADDRESS(String cI_ADDRESS) {
CI_ADDRESS = cI_ADDRESS;
}
public String getCI_LONGITUDE() {
return CI_LONGITUDE;
}
public void setCI_LONGITUDE(String cI_LONGITUDE) {
CI_LONGITUDE = cI_LONGITUDE;
}
public String getCI_LATITUDE() {
return CI_LATITUDE;
}
public void setCI_LATITUDE(String cI_LATITUDE) {
CI_LATITUDE = cI_LATITUDE;
}
public String getCI_AUDIT() {
return CI_AUDIT;
}
public void setCI_AUDIT(String cI_AUDIT) {
CI_AUDIT = cI_AUDIT;
}
public String getCI_PERPER() {
return CI_PERPER;
}
public void setCI_PERPER(String cI_PERPER) {
CI_PERPER = cI_PERPER;
}
public String getCI_DELFLAG() {
return CI_DELFLAG;
}
public void setCI_DELFLAG(String cI_DELFLAG) {
CI_DELFLAG = cI_DELFLAG;
}
public String getCI_CREATION_TIME() {
return CI_CREATION_TIME;
}
public void setCI_CREATION_TIME(String cI_CREATION_TIME) {
CI_CREATION_TIME = cI_CREATION_TIME;
}
public String getCI_ADDRESSCON() {
return CI_ADDRESSCON;
}
public void setCI_ADDRESSCON(String cI_ADDRESSCON) {
CI_ADDRESSCON = cI_ADDRESSCON;
}
@Override
public String toString() {
return "CorpprateinfoModel [CI_ID=" + CI_ID + ", CI_FID=" + CI_FID
+ ", CI_NAME=" + CI_NAME + ", CI_PRINCIPAL=" + CI_PRINCIPAL
+ ", CI_PHONE=" + CI_PHONE + ", CI_ADDRESS=" + CI_ADDRESS
+ ", CI_LONGITUDE=" + CI_LONGITUDE + ", CI_LATITUDE="
+ CI_LATITUDE + ", CI_AUDIT=" + CI_AUDIT + ", CI_PERPER="
+ CI_PERPER + ", CI_DELFLAG=" + CI_DELFLAG
+ ", CI_CREATION_TIME=" + CI_CREATION_TIME + ", CI_ADDRESSCON="
+ CI_ADDRESSCON + ", StartPage=" + StartPage + ", EndPage="
+ EndPage + ", rownum_=" + rownum_ + "]";
}
}
DeviceInfoModel.java
package enytek.com.cn.model.corpprateinfo;
public class DeviceInfoModel {
private Integer DI_ID;
private String DI_MFFID;
private String DI_FID;
private String DI_DEVICE_NAME;
private String DI_DEVICE_MODEL;
private String DI_SERIAL_NUMBER;
private String DI_MANUFACTURER;
private String DI_DIRECTION;
private String DI_ADDED_MONITORING;
private String DI_AGENT;
private String DI_LICENSE;
private String DI_ENVIRONMENTAL;
private String DI_PRINCIPLE;
private String DI_INSTALLATION_DATE;
private String DI_OPERATING;
private String DI_OPERATION_STARTTIME;
private String DI_OPERATION_ENDTIME;
private String DI_TSP_MILEAGE1;
private String DI_TSP_MILEAGE2;
private String DI_TEMPERATURE1;
private String DI_TEMPERATURE2;
private String DI_HUMIDITY1;
private String DI_HUMIDITY2;
private String DI_TSP_SLOPE;
private String DI_TSP_INTERCEPT;
private String DI_WIND;
private String DI_PRESSURE;
private String DI_OTHER;
private String DI_ACCEPTANCE_TIME;
private String DI_MEASUREMENT;
private String DI_MEASUREMENT_TIME1;
private String DI_MEASUREMENT_TIME2;
private String DI_PERPER;
private String DI_DELFLAG;
private String DI_CREATION_TIME;
private Integer StartPage;
private Integer EndPage;
private String rownum_;
public DeviceInfoModel() {
super();
}
public Integer getDI_ID() {
return DI_ID;
}
public void setDI_ID(Integer dI_ID) {
DI_ID = dI_ID;
}
public String getDI_MFFID() {
return DI_MFFID;
}
public void setDI_MFFID(String dI_MFFID) {
DI_MFFID = dI_MFFID;
}
public String getDI_FID() {
return DI_FID;
}
public void setDI_FID(String dI_FID) {
DI_FID = dI_FID;
}
public String getDI_DEVICE_NAME() {
return DI_DEVICE_NAME;
}
public void setDI_DEVICE_NAME(String dI_DEVICE_NAME) {
DI_DEVICE_NAME = dI_DEVICE_NAME;
}
public String getDI_DEVICE_MODEL() {
return DI_DEVICE_MODEL;
}
public void setDI_DEVICE_MODEL(String dI_DEVICE_MODEL) {
DI_DEVICE_MODEL = dI_DEVICE_MODEL;
}
public String getDI_SERIAL_NUMBER() {
return DI_SERIAL_NUMBER;
}
public void setDI_SERIAL_NUMBER(String dI_SERIAL_NUMBER) {
DI_SERIAL_NUMBER = dI_SERIAL_NUMBER;
}
public String getDI_MANUFACTURER() {
return DI_MANUFACTURER;
}
public void setDI_MANUFACTURER(String dI_MANUFACTURER) {
DI_MANUFACTURER = dI_MANUFACTURER;
}
public String getDI_DIRECTION() {
return DI_DIRECTION;
}
public void setDI_DIRECTION(String dI_DIRECTION) {
DI_DIRECTION = dI_DIRECTION;
}
public String getDI_ADDED_MONITORING() {
return DI_ADDED_MONITORING;
}
public void setDI_ADDED_MONITORING(String dI_ADDED_MONITORING) {
DI_ADDED_MONITORING = dI_ADDED_MONITORING;
}
public String getDI_AGENT() {
return DI_AGENT;
}
public void setDI_AGENT(String dI_AGENT) {
DI_AGENT = dI_AGENT;
}
public String getDI_LICENSE() {
return DI_LICENSE;
}
public void setDI_LICENSE(String dI_LICENSE) {
DI_LICENSE = dI_LICENSE;
}
public String getDI_ENVIRONMENTAL() {
return DI_ENVIRONMENTAL;
}
public void setDI_ENVIRONMENTAL(String dI_ENVIRONMENTAL) {
DI_ENVIRONMENTAL = dI_ENVIRONMENTAL;
}
public String getDI_PRINCIPLE() {
return DI_PRINCIPLE;
}
public void setDI_PRINCIPLE(String dI_PRINCIPLE) {
DI_PRINCIPLE = dI_PRINCIPLE;
}
public String getDI_INSTALLATION_DATE() {
return DI_INSTALLATION_DATE;
}
public void setDI_INSTALLATION_DATE(String dI_INSTALLATION_DATE) {
DI_INSTALLATION_DATE = dI_INSTALLATION_DATE;
}
public String getDI_OPERATING() {
return DI_OPERATING;
}
public void setDI_OPERATING(String dI_OPERATING) {
DI_OPERATING = dI_OPERATING;
}
public String getDI_OPERATION_STARTTIME() {
return DI_OPERATION_STARTTIME;
}
public void setDI_OPERATION_STARTTIME(String dI_OPERATION_STARTTIME) {
DI_OPERATION_STARTTIME = dI_OPERATION_STARTTIME;
}
public String getDI_OPERATION_ENDTIME() {
return DI_OPERATION_ENDTIME;
}
public void setDI_OPERATION_ENDTIME(String dI_OPERATION_ENDTIME) {
DI_OPERATION_ENDTIME = dI_OPERATION_ENDTIME;
}
public String getDI_TSP_MILEAGE1() {
return DI_TSP_MILEAGE1;
}
public void setDI_TSP_MILEAGE1(String dI_TSP_MILEAGE1) {
DI_TSP_MILEAGE1 = dI_TSP_MILEAGE1;
}
public String getDI_TSP_MILEAGE2() {
return DI_TSP_MILEAGE2;
}
public void setDI_TSP_MILEAGE2(String dI_TSP_MILEAGE2) {
DI_TSP_MILEAGE2 = dI_TSP_MILEAGE2;
}
public String getDI_TEMPERATURE1() {
return DI_TEMPERATURE1;
}
public void setDI_TEMPERATURE1(String dI_TEMPERATURE1) {
DI_TEMPERATURE1 = dI_TEMPERATURE1;
}
public String getDI_TEMPERATURE2() {
return DI_TEMPERATURE2;
}
public void setDI_TEMPERATURE2(String dI_TEMPERATURE2) {
DI_TEMPERATURE2 = dI_TEMPERATURE2;
}
public String getDI_HUMIDITY1() {
return DI_HUMIDITY1;
}
public void setDI_HUMIDITY1(String dI_HUMIDITY1) {
DI_HUMIDITY1 = dI_HUMIDITY1;
}
public String getDI_HUMIDITY2() {
return DI_HUMIDITY2;
}
public void setDI_HUMIDITY2(String dI_HUMIDITY2) {
DI_HUMIDITY2 = dI_HUMIDITY2;
}
public String getDI_TSP_SLOPE() {
return DI_TSP_SLOPE;
}
public void setDI_TSP_SLOPE(String dI_TSP_SLOPE) {
DI_TSP_SLOPE = dI_TSP_SLOPE;
}
public String getDI_TSP_INTERCEPT() {
return DI_TSP_INTERCEPT;
}
public void setDI_TSP_INTERCEPT(String dI_TSP_INTERCEPT) {
DI_TSP_INTERCEPT = dI_TSP_INTERCEPT;
}
public String getDI_WIND() {
return DI_WIND;
}
public void setDI_WIND(String dI_WIND) {
DI_WIND = dI_WIND;
}
public String getDI_PRESSURE() {
return DI_PRESSURE;
}
public void setDI_PRESSURE(String dI_PRESSURE) {
DI_PRESSURE = dI_PRESSURE;
}
public String getDI_OTHER() {
return DI_OTHER;
}
public void setDI_OTHER(String dI_OTHER) {
DI_OTHER = dI_OTHER;
}
public String getDI_ACCEPTANCE_TIME() {
return DI_ACCEPTANCE_TIME;
}
public void setDI_ACCEPTANCE_TIME(String dI_ACCEPTANCE_TIME) {
DI_ACCEPTANCE_TIME = dI_ACCEPTANCE_TIME;
}
public String getDI_MEASUREMENT() {
return DI_MEASUREMENT;
}
public void setDI_MEASUREMENT(String dI_MEASUREMENT) {
DI_MEASUREMENT = dI_MEASUREMENT;
}
public String getDI_MEASUREMENT_TIME1() {
return DI_MEASUREMENT_TIME1;
}
public void setDI_MEASUREMENT_TIME1(String dI_MEASUREMENT_TIME1) {
DI_MEASUREMENT_TIME1 = dI_MEASUREMENT_TIME1;
}
public String getDI_MEASUREMENT_TIME2() {
return DI_MEASUREMENT_TIME2;
}
public void setDI_MEASUREMENT_TIME2(String dI_MEASUREMENT_TIME2) {
DI_MEASUREMENT_TIME2 = dI_MEASUREMENT_TIME2;
}
public String getDI_PERPER() {
return DI_PERPER;
}
public void setDI_PERPER(String dI_PERPER) {
DI_PERPER = dI_PERPER;
}
public String getDI_DELFLAG() {
return DI_DELFLAG;
}
public void setDI_DELFLAG(String dI_DELFLAG) {
DI_DELFLAG = dI_DELFLAG;
}
public String getDI_CREATION_TIME() {
return DI_CREATION_TIME;
}
public void setDI_CREATION_TIME(String dI_CREATION_TIME) {
DI_CREATION_TIME = dI_CREATION_TIME;
}
public Integer getStartPage() {
return StartPage;
}
public void setStartPage(Integer startPage) {
StartPage = startPage;
}
public Integer getEndPage() {
return EndPage;
}
public void setEndPage(Integer endPage) {
EndPage = endPage;
}
public String getRownum_() {
return rownum_;
}
public void setRownum_(String rownum_) {
this.rownum_ = rownum_;
}
}
MonitoringFactorModel.java
package enytek.com.cn.model.corpprateinfo;
public class MonitoringFactorModel {
private Integer MF_ID;
private String MF_MPFID;
private String MF_FID;
private String MF_FACTOR;
private String MF_STANDARD;
private String MF_EXECUTIVE_DESCRIPTION;
private String MF_STATUS;
private String MF_OPERATING;
private String MF_PERPER;
private String MF_DELFLAG;
private String MF_CREATION_TIME;
private Integer StartPage;
private Integer EndPage;
private String rownum_;
private String MF_CHECKED;
private String MF_FACTOR_NAME;
public String getMF_FACTOR_NAME() {
return MF_FACTOR_NAME;
}
public void setMF_FACTOR_NAME(String mF_FACTOR_NAME) {
MF_FACTOR_NAME = mF_FACTOR_NAME;
}
public String getMF_CHECKED() {
return MF_CHECKED;
}
public void setMF_CHECKED(String mF_CHECKED) {
MF_CHECKED = mF_CHECKED;
}
public MonitoringFactorModel() {
super();
}
public MonitoringFactorModel(Integer mF_ID, String mF_MPFID, String mF_FID,
String mF_FACTOR, String mF_STANDARD,
String mF_EXECUTIVE_DESCRIPTION, String mF_STATUS,
String mF_OPERATING, String mF_PERPER, String mF_DELFLAG,
String mF_CREATION_TIME, Integer startPage, Integer endPage,
String rownum_) {
super();
MF_ID = mF_ID;
MF_MPFID = mF_MPFID;
MF_FID = mF_FID;
MF_FACTOR = mF_FACTOR;
MF_STANDARD = mF_STANDARD;
MF_EXECUTIVE_DESCRIPTION = mF_EXECUTIVE_DESCRIPTION;
MF_STATUS = mF_STATUS;
MF_OPERATING = mF_OPERATING;
MF_PERPER = mF_PERPER;
MF_DELFLAG = mF_DELFLAG;
MF_CREATION_TIME = mF_CREATION_TIME;
StartPage = startPage;
EndPage = endPage;
this.rownum_ = rownum_;
}
public Integer getStartPage() {
return StartPage;
}
public void setStartPage(Integer startPage) {
StartPage = startPage;
}
public Integer getEndPage() {
return EndPage;
}
public void setEndPage(Integer endPage) {
EndPage = endPage;
}
public String getRownum_() {
return rownum_;
}
public void setRownum_(String rownum_) {
this.rownum_ = rownum_;
}
public Integer getMF_ID() {
return MF_ID;
}
public void setMF_ID(Integer mF_ID) {
MF_ID = mF_ID;
}
public String getMF_MPFID() {
return MF_MPFID;
}
public void setMF_MPFID(String mF_MPFID) {
MF_MPFID = mF_MPFID;
}
public String getMF_FID() {
return MF_FID;
}
public void setMF_FID(String mF_FID) {
MF_FID = mF_FID;
}
public String getMF_FACTOR() {
return MF_FACTOR;
}
public void setMF_FACTOR(String mF_FACTOR) {
MF_FACTOR = mF_FACTOR;
}
public String getMF_STANDARD() {
return MF_STANDARD;
}
public void setMF_STANDARD(String mF_STANDARD) {
MF_STANDARD = mF_STANDARD;
}
public String getMF_EXECUTIVE_DESCRIPTION() {
return MF_EXECUTIVE_DESCRIPTION;
}
public void setMF_EXECUTIVE_DESCRIPTION(String mF_EXECUTIVE_DESCRIPTION) {
MF_EXECUTIVE_DESCRIPTION = mF_EXECUTIVE_DESCRIPTION;
}
public String getMF_STATUS() {
return MF_STATUS;
}
public void setMF_STATUS(String mF_STATUS) {
MF_STATUS = mF_STATUS;
}
public String getMF_OPERATING() {
return MF_OPERATING;
}
public void setMF_OPERATING(String mF_OPERATING) {
MF_OPERATING = mF_OPERATING;
}
public String getMF_PERPER() {
return MF_PERPER;
}
public void setMF_PERPER(String mF_PERPER) {
MF_PERPER = mF_PERPER;
}
public String getMF_DELFLAG() {
return MF_DELFLAG;
}
public void setMF_DELFLAG(String mF_DELFLAG) {
MF_DELFLAG = mF_DELFLAG;
}
public String getMF_CREATION_TIME() {
return MF_CREATION_TIME;
}
public void setMF_CREATION_TIME(String mF_CREATION_TIME) {
MF_CREATION_TIME = mF_CREATION_TIME;
}
@Override
public String toString() {
return "MonitoringFactorModel [MF_ID=" + MF_ID + ", MF_MPFID="
+ MF_MPFID + ", MF_FID=" + MF_FID + ", MF_FACTOR=" + MF_FACTOR
+ ", MF_STANDARD=" + MF_STANDARD
+ ", MF_EXECUTIVE_DESCRIPTION=" + MF_EXECUTIVE_DESCRIPTION
+ ", MF_STATUS=" + MF_STATUS + ", MF_OPERATING=" + MF_OPERATING
+ ", MF_PERPER=" + MF_PERPER + ", MF_DELFLAG=" + MF_DELFLAG
+ ", MF_CREATION_TIME=" + MF_CREATION_TIME + ", StartPage="
+ StartPage + ", EndPage=" + EndPage + ", rownum_=" + rownum_
+ "]";
}
}
MonitoringPointModel.java
package enytek.com.cn.model.corpprateinfo;
public class MonitoringPointModel {
private Integer MP_ID;
private String MP_CIFID;
private String MP_FID;
private String MP_POINT_FULLNAME;
private String MP_ADDRESS;
private String MP_LONGITUDE;
private String MP_LATITUDE;
private String MP_NETWORK_STARTTIME;
private String MP_INFORMATION;
private String MP_INSTALLATIONTIME;
private String MP_MN;
private String MP_PERPER;
private String MP_DELFLAG;
private String MP_CREATION_TIME;
private Integer StartPage;
private Integer EndPage;
private String rownum_;
public MonitoringPointModel() {
super();
}
public MonitoringPointModel(Integer mP_ID, String mP_CIFID, String mP_FID,
String mP_POINT_FULLNAME, String mP_ADDRESS, String mP_LONGITUDE,
String mP_LATITUDE, String mP_NETWORK_STARTTIME,
String mP_INFORMATION, String mP_INSTALLATIONTIME, String mP_MN,
String mP_PERPER, String mP_DELFLAG, String mP_CREATION_TIME,
Integer startPage, Integer endPage, String rownum_) {
super();
MP_ID = mP_ID;
MP_CIFID = mP_CIFID;
MP_FID = mP_FID;
MP_POINT_FULLNAME = mP_POINT_FULLNAME;
MP_ADDRESS = mP_ADDRESS;
MP_LONGITUDE = mP_LONGITUDE;
MP_LATITUDE = mP_LATITUDE;
MP_NETWORK_STARTTIME = mP_NETWORK_STARTTIME;
MP_INFORMATION = mP_INFORMATION;
MP_INSTALLATIONTIME = mP_INSTALLATIONTIME;
MP_MN = mP_MN;
MP_PERPER = mP_PERPER;
MP_DELFLAG = mP_DELFLAG;
MP_CREATION_TIME = mP_CREATION_TIME;
StartPage = startPage;
EndPage = endPage;
this.rownum_ = rownum_;
}
public Integer getStartPage() {
return StartPage;
}
public void setStartPage(Integer startPage) {
StartPage = startPage;
}
public Integer getEndPage() {
return EndPage;
}
public void setEndPage(Integer endPage) {
EndPage = endPage;
}
public String getRownum_() {
return rownum_;
}
public void setRownum_(String rownum_) {
this.rownum_ = rownum_;
}
public Integer getMP_ID() {
return MP_ID;
}
public void setMP_ID(Integer mP_ID) {
MP_ID = mP_ID;
}
public String getMP_CIFID() {
return MP_CIFID;
}
public void setMP_CIFID(String mP_CIFID) {
MP_CIFID = mP_CIFID;
}
public String getMP_FID() {
return MP_FID;
}
public void setMP_FID(String mP_FID) {
MP_FID = mP_FID;
}
public String getMP_POINT_FULLNAME() {
return MP_POINT_FULLNAME;
}
public void setMP_POINT_FULLNAME(String mP_POINT_FULLNAME) {
MP_POINT_FULLNAME = mP_POINT_FULLNAME;
}
public String getMP_ADDRESS() {
return MP_ADDRESS;
}
public void setMP_ADDRESS(String mP_ADDRESS) {
MP_ADDRESS = mP_ADDRESS;
}
public String getMP_LONGITUDE() {
return MP_LONGITUDE;
}
public void setMP_LONGITUDE(String mP_LONGITUDE) {
MP_LONGITUDE = mP_LONGITUDE;
}
public String getMP_LATITUDE() {
return MP_LATITUDE;
}
public void setMP_LATITUDE(String mP_LATITUDE) {
MP_LATITUDE = mP_LATITUDE;
}
public String getMP_NETWORK_STARTTIME() {
return MP_NETWORK_STARTTIME;
}
public void setMP_NETWORK_STARTTIME(String mP_NETWORK_STARTTIME) {
MP_NETWORK_STARTTIME = mP_NETWORK_STARTTIME;
}
public String getMP_INFORMATION() {
return MP_INFORMATION;
}
public void setMP_INFORMATION(String mP_INFORMATION) {
MP_INFORMATION = mP_INFORMATION;
}
public String getMP_INSTALLATIONTIME() {
return MP_INSTALLATIONTIME;
}
public void setMP_INSTALLATIONTIME(String mP_INSTALLATIONTIME) {
MP_INSTALLATIONTIME = mP_INSTALLATIONTIME;
}
public String getMP_MN() {
return MP_MN;
}
public void setMP_MN(String mP_MN) {
MP_MN = mP_MN;
}
public String getMP_PERPER() {
return MP_PERPER;
}
public void setMP_PERPER(String mP_PERPER) {
MP_PERPER = mP_PERPER;
}
public String getMP_DELFLAG() {
return MP_DELFLAG;
}
public void setMP_DELFLAG(String mP_DELFLAG) {
MP_DELFLAG = mP_DELFLAG;
}
public String getMP_CREATION_TIME() {
return MP_CREATION_TIME;
}
public void setMP_CREATION_TIME(String mP_CREATION_TIME) {
MP_CREATION_TIME = mP_CREATION_TIME;
}
@Override
public String toString() {
return "MonitoringPointModel [MP_ID=" + MP_ID + ", MP_CIFID="
+ MP_CIFID + ", MP_FID=" + MP_FID + ", MP_POINT_FULLNAME="
+ MP_POINT_FULLNAME + ", MP_ADDRESS=" + MP_ADDRESS
+ ", MP_LONGITUDE=" + MP_LONGITUDE + ", MP_LATITUDE="
+ MP_LATITUDE + ", MP_NETWORK_STARTTIME="
+ MP_NETWORK_STARTTIME + ", MP_INFORMATION=" + MP_INFORMATION
+ ", MP_INSTALLATIONTIME=" + MP_INSTALLATIONTIME + ", MP_MN="
+ MP_MN + ", MP_PERPER=" + MP_PERPER + ", MP_DELFLAG="
+ MP_DELFLAG + ", MP_CREATION_TIME=" + MP_CREATION_TIME
+ ", StartPage=" + StartPage + ", EndPage=" + EndPage
+ ", rownum_=" + rownum_ + ", getStartPage()=" + getStartPage()
+ ", getEndPage()=" + getEndPage() + ", getRownum_()="
+ getRownum_() + ", getMP_ID()=" + getMP_ID()
+ ", getMP_CIFID()=" + getMP_CIFID() + ", getMP_FID()="
+ getMP_FID() + ", getMP_POINT_FULLNAME()="
+ getMP_POINT_FULLNAME() + ", getMP_ADDRESS()="
+ getMP_ADDRESS() + ", getMP_LONGITUDE()=" + getMP_LONGITUDE()
+ ", getMP_LATITUDE()=" + getMP_LATITUDE()
+ ", getMP_NETWORK_STARTTIME()=" + getMP_NETWORK_STARTTIME()
+ ", getMP_INFORMATION()=" + getMP_INFORMATION()
+ ", getMP_INSTALLATIONTIME()=" + getMP_INSTALLATIONTIME()
+ ", getMP_MN()=" + getMP_MN() + ", getMP_PERPER()="
+ getMP_PERPER() + ", getMP_DELFLAG()=" + getMP_DELFLAG()
+ ", getMP_CREATION_TIME()=" + getMP_CREATION_TIME()
+ ", getClass()=" + getClass() + ", hashCode()=" + hashCode()
+ ", toString()=" + super.toString() + "]";
}
}
mybatis-config.xml
<!--企业信息 -->
<typeAlias alias="corpprateinfo" type="enytek.com.cn.model.corpprateinfo.CorpprateinfoModel" />
<typeAlias alias="deviceInfo" type="enytek.com.cn.model.corpprateinfo.DeviceInfoModel" />
<typeAlias alias="monitoringFactor" type="enytek.com.cn.model.corpprateinfo.MonitoringFactorModel" />
<typeAlias alias="monitoringPoint" type="enytek.com.cn.model.corpprateinfo.MonitoringPointModel" />
<!--企业信息 -->
<mapper resource="enytek/com/cn/mappers/corpprateinfo/CorpprateinfoMapper.xml"/>
<mapper resource="enytek/com/cn/mappers/corpprateinfo/DeviceInfoMapper.xml"/>
<mapper resource="enytek/com/cn/mappers/corpprateinfo/MonitoringFactorMapper.xml"/>
<mapper resource="enytek/com/cn/mappers/corpprateinfo/MonitoringPointMapper.xml"/>