From 1a2b07f01ba4616fd9e894dddf474b56d020158c Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期一, 07 四月 2025 15:18:51 +0800 Subject: [PATCH] 整理版本 --- pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java | 711 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 711 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java new file mode 100644 index 0000000..b2a6a43 --- /dev/null +++ b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java @@ -0,0 +1,711 @@ +package com.dy.rtuMw.server.rtuData.dbSv; + +import com.dy.common.util.NumUtil; +import com.dy.pipIrrGlobal.daoPr.PrControllerMapper; +import com.dy.pipIrrGlobal.daoPr.PrControllerTrampMapper; +import com.dy.pipIrrGlobal.daoRm.*; +import com.dy.pipIrrGlobal.daoSe.SeClientCardMapper; +import com.dy.pipIrrGlobal.daoSe.SeVirtualCardMapper; +import com.dy.pipIrrGlobal.pojoPr.PrController; +import com.dy.pipIrrGlobal.pojoPr.PrControllerTramp; +import com.dy.pipIrrGlobal.pojoRm.*; +import com.dy.pipIrrGlobal.pojoSe.SeClient; +import com.dy.pipIrrGlobal.voSe.VoCardInfo1; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; + +import java.util.Date; +import java.util.List; +import java.util.Map; + +/** + * @Author liurunyu + * @Date 2024/1/13 10:57 + * @LastEditTime 2024/1/13 10:57 + * @Description + */ +@Service() +public class DbSv { + @Autowired + private SeClientCardMapper seClientCardDao;//鍐滄埛姘村崱DAO + @Autowired + private SeVirtualCardMapper seVirtualCardDao ;//铏氭嫙鍗$浉鍏矰AO + @Autowired + private PrControllerTrampMapper prControllerTrampMapperDao;//娴佹氮鎺у埗鍣―AO + @Autowired + private PrControllerMapper prControllerMapperDao ;//鎺у埗鍣―AO + @Autowired + private RmAlarmStateLastMapper rmAlarmStateLastMapperDao ;//鎺у埗鍣ㄦ渶鏂版姤璀﹀拰鐘舵�丏AO + @Autowired + private RmAlarmStateHistoryMapper rmAlarmStateHistoryMapperDao ;//鎺у埗鍣ㄥ巻鍙叉姤璀﹀拰鐘舵�丏AO + @Autowired + private RmOpenCloseValveLastMapper rmOpenCloseValveLastMapperDao ;//鎺у埗鍣ㄦ渶鏂板紑鍏抽榾涓婃姤鏁版嵁DAO + @Autowired + private RmOpenCloseValveHistoryMapper rmOpenCloseValveHistoryMapperDao ;//鎺у埗鍣ㄥ巻鍙插紑鍏抽榾涓婃姤鏁版嵁DAO + @Autowired + private RmWorkReportLastMapper rmWorkReportLastMapperDao ;//鎺у埗鍣ㄦ渶鏂板伐浣滄姤鏁版嵁DAO + @Autowired + private RmWorkReportHistoryMapper rmWorkReportHistoryMapperDao ;//鎺у埗鍣ㄥ巻鍙插伐浣滄姤鏁版嵁DAO + @Autowired + private RmIntakeAmountDayLastMapper rmIntakeAmountDayLastMapperDao ;//鍙栨按鍙e彇姘寸粺璁℃渶鏂版暟鎹瓺AO + @Autowired + private RmIntakeAmountDayMapper rmIntakeAmountDayMapperDao ;//鍙栨按鍙e彇姘村拰婕忔崯缁熻DAO + @Autowired + private RmClientAmountDayLastMapper rmClientAmountDayLastMapperDao ;//鍐滄埛鏃ョ敤姘撮噺缁熻鏈�鏂版暟鎹瓺AO + @Autowired + private RmClientAmountDayMapper rmClientAmountDayMapperDao ;//鍐滄埛鏃ョ敤姘撮噺缁熻鏁版嵁DAO + @Autowired + private RmLossDayLastMapper rmLossLastMapperDao ;//鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁℃渶鏂版暟鎹瓺AO + @Autowired + private RmLossDayMapper rmLossHistoryMapperDao ;//鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁″巻鍙叉暟鎹瓺AO + @Autowired + private RmCommandHistoryMapper rmCommandHistoryDao ;//杩滅▼鍛戒护鏃ュ織鐩稿叧 + + @Autowired + private RmTimingReportHistoryMapper rmTimingReportHistoryDao; // 瀹氱偣涓婃姤鍘嗗彶鏁版嵁DAO + @Autowired + private RmTimingReportLastMapper rmTimingReportLastDao; // 瀹氱偣涓婃姤鏈�鏂版暟鎹瓺AO + + @Autowired + private RmOnHourReportHistoryMapper rmOnHourReportHistoryDao; // 瀹氱偣涓婃姤鍘嗗彶鏁版嵁DAO + @Autowired + private RmOnHourReportLastMapper rmOnHourReportLastDao; // 瀹氱偣涓婃姤鏈�鏂版暟鎹瓺AO + + + //@Autowired + //@Lazy + //private DbSv sv ; + + ///////////////////////////////////////////////// + // + // 鍩虹鍔熻兘 + // + //////////////////////////////////////////////// + + /** + * 閫氳繃鐗╃悊IC鍦板潃鍙婂崱鍙峰緱鍒板啘鎴穒d鍜屽鍚� + * @param icCardAddr + * @param icCardNo + * @return + */ + public SeClient getClientIdAndNameByCardAddrAndCardNo(String icCardAddr, String icCardNo){ + SeClient vo = null ; + if(NumUtil.isPlusIntNumber(icCardNo)){ + Long icCardNoLong = Long.parseLong(icCardNo) ; + Map<String, Object> map = seClientCardDao.getClientIdAndNameByCardAddrAndCardNo(icCardAddr, icCardNoLong) ; + if(map != null && map.size() > 0) { + vo = new SeClient() ; + vo.setId(Long.parseLong(map.get("clientId").toString())); + vo.setName(map.get("clientName").toString()); + vo.setAddress(map.get("clientAddress").toString()); + } + } + return vo ; + } + /** + * 閫氳繃铏氭嫙IC鍗″彿寰楀埌鍐滄埛id鍜屽鍚� + * @param icCardNo + * @return + */ + public SeClient getClientIdAndNameByVsCardNo(String icCardNo){ + SeClient vo = null ; + if(NumUtil.isPlusIntNumber(icCardNo)){ + Long icCardNoLong = Long.parseLong(icCardNo) ; + Map<String, Object> map = seVirtualCardDao.getClientIdAndNameByVsCardNo(icCardNoLong) ; + if(map != null && map.size() > 0) { + vo = new SeClient() ; + vo.setId(Long.parseLong(map.get("clientId").toString())); + vo.setName(map.get("clientName").toString()); + vo.setAddress(map.get("clientAddress").toString()); + } + } + return vo ; + } + + + /** + * 閫氳繃鎺у埗鍣ㄥ湴鍧�浠庢暟鎹簱琛ㄤ腑鏌ヨ鎺у埗鍣� + * @param rtuAddr 鎺у埗鍣ㄥ湴鍧� + * @return 鎺у埗鍣� + */ + public PrController getControllersByRtuAddrAndIntakeNotNull(String rtuAddr){ + List<PrController> list = this.prControllerMapperDao.getControllersByRtuAddrAndIntakeNotNull(rtuAddr) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + /** + * 閫氳繃鎺у埗鍣ㄥ湴鍧�浠庢暟鎹簱琛ㄤ腑鏌ヨ娴佹氮鎺у埗鍣� + * @param rtuAddr 鎺у埗鍣ㄥ湴鍧� + * @return 娴佹氮鎺у埗鍣� + */ + public PrControllerTramp getPrControllerTrampByRtuAddr(String rtuAddr){ + List<PrControllerTramp> list = this.prControllerTrampMapperDao.getPrControllerTrampByRtuAddr(rtuAddr) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + /** + * 淇濆瓨娴佹氮鎺у埗鍣� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void savePrConctrollerTramp(PrControllerTramp po){ + if(po.getOrgTag().trim().length() > 2) { + po.setOrgTag("DY"); + } + this.prControllerTrampMapperDao.insert(po) ; + } + /** + * 淇濆瓨娴佹氮鎺у埗鍣� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updatePrConctrollerTramp(PrControllerTramp po){ + this.prControllerTrampMapperDao.updateByPrimaryKey(po) ; + } + + + ///////////////////////////////////////////////// + // + // 鎶ヨ鍙婄姸鎬佸姛鑳� + // + //////////////////////////////////////////////// + /** + * 寰楀埌鎺у埗鍣ㄦ姤璀︿笌鐘舵�佹渶鏂拌褰� + * @param intakeId + * @return + */ + public RmAlarmStateLast getRmAlarmStateLast(Long intakeId){ + List<RmAlarmStateLast> list = rmAlarmStateLastMapperDao.selectByIntakeId(intakeId) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + /** + * 淇濆瓨鎺у埗鍣ㄦ姤璀︿笌鐘舵�佹渶鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmAlarmStateLast(RmAlarmStateLast po){ + this.rmAlarmStateLastMapperDao.insert(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄦ姤璀︿笌鐘舵�佹渶鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmAlarmStateLast(RmAlarmStateLast po){ + this.rmAlarmStateLastMapperDao.updateByPrimaryKey(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄦ姤璀︿笌鐘舵�佸巻鍙茶褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmAlarmStateHistory(RmAlarmStateHistory po){ + this.rmAlarmStateHistoryMapperDao.insert(po) ; + } + + /** + * 鍙樻洿铏氭嫙鍗″崰鐢ㄧ姸鎬� + * @param intakeId + */ + @Transactional(rollbackFor = Exception.class) + public void updateVirCardNoUseState(Long intakeId, Date now){ + this.seVirtualCardDao.updateVcCardNoUseStateByIntakeId(intakeId, now) ; + } + + + ///////////////////////////////////////////////// + // + // 瀹氱偣鎶ユ暟鎹姛鑳�(鍙湪鐜嬫睙娴风殑鍗忚鏈夋鏁版嵁) + // + //////////////////////////////////////////////// + + /** + * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ュ巻鍙叉暟鎹� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmTimingReportHistory(RmTimingReportHistory po){ + this.rmTimingReportHistoryDao.insert(po); + } + + /** + * 鏍规嵁闃�鎺у櫒鍦板潃鑾峰彇瀹氱偣涓婃姤鏈�鏂版暟鎹� + * @param intakeId + * @return + */ + @Transactional(rollbackFor = Exception.class) + public RmTimingReportLast getRmTimingReportLast(Long intakeId) { + List<RmTimingReportLast> list = this.rmTimingReportLastDao.getRmTimingReportLast(intakeId) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + + /** + * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ユ渶鏂版暟鎹� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmTimingReportLast(RmTimingReportLast po) { + this.rmTimingReportLastDao.insert(po); + } + + /** + * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ョ姜琛屾暟鎹� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmTimingReportLast(RmTimingReportLast po) { + this.rmTimingReportLastDao.updateByPrimaryKey(po); + } + + ///////////////////////////////////////////////// + // + // 瀹氱偣涓婃姤瀹炴椂鏁版嵁鍔熻兘(鍙湪闈虫�荤殑鍗忚鏈夋鏁版嵁) + // + //////////////////////////////////////////////// + + /** + * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ュ巻鍙叉暟鎹� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmOnHourReportHistory(RmOnHourReportHistory po){ + this.rmOnHourReportHistoryDao.insert(po); + } + + /** + * 鏍规嵁闃�鎺у櫒鍦板潃鑾峰彇瀹氱偣涓婃姤鏈�鏂版暟鎹� + * @param intakeId + * @return + */ + @Transactional(rollbackFor = Exception.class) + public RmOnHourReportLast getRmOnHourReportLast(Long intakeId) { + List<RmOnHourReportLast> list = this.rmOnHourReportLastDao.getRmOnHourReportLast(intakeId) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + + /** + * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ユ渶鏂版暟鎹� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmOnHourReportLast(RmOnHourReportLast po) { + this.rmOnHourReportLastDao.insert(po); + } + + /** + * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ョ姜琛屾暟鎹� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmOnHourReportLast(RmOnHourReportLast po) { + this.rmOnHourReportLastDao.updateByPrimaryKey(po); + } + + ///////////////////////////////////////////////// + // + // 寮�鍏抽榾涓婃姤鏁版嵁鍔熻兘 + // + //////////////////////////////////////////////// + /** + * 寰楀埌鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鏈�鏂拌褰� + * @param intakeId + * @return + */ + public RmOpenCloseValveLast getRmOpenCloseValveLast(Long intakeId){ + List<RmOpenCloseValveLast> list = rmOpenCloseValveLastMapperDao.selectByIntakeId(intakeId) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + /** + * 淇濆瓨鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鏈�鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmOpenCloseValveLast(RmOpenCloseValveLast po){ + this.rmOpenCloseValveLastMapperDao.insert(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鏈�鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmOpenCloseValveLast(RmOpenCloseValveLast po){ + this.rmOpenCloseValveLastMapperDao.updateByPrimaryKey(po) ; + } + /** + * 寰楀埌鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鍘嗗彶鏁版嵁涓殑鏈�鏂拌褰� + * @param id + * @return + */ + public RmOpenCloseValveHistory getRmOpenCloseValveHistory(Long id){ + return rmOpenCloseValveHistoryMapperDao.selectByPrimaryKey(id) ; + } + + /** + * 淇濆瓨鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鍘嗗彶璁板綍 + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmOpenCloseValveHistory(RmOpenCloseValveHistory po){ + this.rmOpenCloseValveHistoryMapperDao.insert(po) ; + } + + /** + * 淇濆瓨鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鍘嗗彶璁板綍 + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmOpenCloseValveHistory(RmOpenCloseValveHistory po){ + this.rmOpenCloseValveHistoryMapperDao.updateByPrimaryKey(po) ; + } + + ///////////////////////////////////////////////// + // + // 宸ヤ綔鎶ユ暟鎹姛鑳� + // + //////////////////////////////////////////////// + /** + * 寰楀埌鎺у埗鍣ㄤ笂鎶ユ暟鎹渶鏂拌褰� + * @param intakeId + * @return + */ + public RmWorkReportLast getRmWorkReportLast(Long intakeId){ + List<RmWorkReportLast> list = rmWorkReportLastMapperDao.selectByIntakeId(intakeId) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + /** + * 淇濆瓨鎺у埗鍣ㄤ笂鎶ユ暟鎹渶鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmWorkReportLast(RmWorkReportLast po){ + this.rmWorkReportLastMapperDao.insert(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄤ笂鎶ユ暟鎹渶鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmWorkReportLast(RmWorkReportLast po){ + this.rmWorkReportLastMapperDao.updateByPrimaryKey(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄤ笂鎶ユ暟鎹巻鍙茶褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmWorkReportHistory(RmWorkReportHistory po){ + this.rmWorkReportHistoryMapperDao.insert(po) ; + } + + ///////////////////////////////////////////////// + // + // 鍙栨按鍙f棩鍙栨按閲忕粺璁″姛鑳� + // + //////////////////////////////////////////////// + /** + * 寰楀埌鏈�鏂拌褰� + * @param intakeId + * @return + */ + public RmIntakeAmountDayLast getRmIntakeAmountLast(Long intakeId){ + List<RmIntakeAmountDayLast> list = rmIntakeAmountDayLastMapperDao.selectByIntakeId(intakeId) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + /** + * 淇濆瓨鏈�鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmIntakeAmountLast(RmIntakeAmountDayLast po){ + this.rmIntakeAmountDayLastMapperDao.insert(po) ; + } + /** + * 淇濆瓨璁板綍 + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmIntakeAmountDay(RmIntakeAmountDay po){ + this.rmIntakeAmountDayMapperDao.insert(po) ; + } + /** + * 淇濆瓨鏈�鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmIntakeAmountLast(RmIntakeAmountDayLast po){ + this.rmIntakeAmountDayLastMapperDao.updateByPrimaryKey(po) ; + } + /** + * 淇濆瓨鍘嗗彶璁板綍 + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmIntakeAmountDay(RmIntakeAmountDay po){ + this.rmIntakeAmountDayMapperDao.updateByPrimaryKey(po) ; + } + + /** + * 寰楀埌绗﹀悎鏉′欢鐨勫巻鍙茶褰� + * @param id + * @return + */ + public RmIntakeAmountDay getRmIntakeAmountDay(Long id){ + return rmIntakeAmountDayMapperDao.selectByPrimaryKey(id) ; + } + + ///////////////////////////////////////////////// + // + // 鍐滄埛鏃ョ敤姘撮噺鍙婅姳璐圭粺璁″姛鑳� + // + //////////////////////////////////////////////// + /** + * 寰楀埌鏈�鏂拌褰� + * @param clientId + * @return + */ + public RmClientAmountDayLast getRmClientAmountLast(Long clientId){ + List<RmClientAmountDayLast> list = rmClientAmountDayLastMapperDao.selectByClientId(clientId) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + /** + * 淇濆瓨鏈�鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmClientAmountLast(RmClientAmountDayLast po){ + this.rmClientAmountDayLastMapperDao.insert(po) ; + } + /** + * 淇濆瓨璁板綍 + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmClientAmountDay(RmClientAmountDay po){ + this.rmClientAmountDayMapperDao.insert(po) ; + } + /** + * 鏇存柊鏈�鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmClientAmountLast(RmClientAmountDayLast po){ + this.rmClientAmountDayLastMapperDao.updateByPrimaryKey(po) ; + } + /** + * 鏇存柊璁板綍 + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmClientAmountDay(RmClientAmountDay po){ + this.rmClientAmountDayMapperDao.updateByPrimaryKey(po) ; + } + + /** + * 寰楀埌绗﹀悎鏉′欢鐨勫巻鍙茶褰� + * @param id + * @return + */ + public RmClientAmountDay getRmClientAmountDay(Long id){ + return rmClientAmountDayMapperDao.selectByPrimaryKey(id) ; + } + + + /** + * 寰楀埌绗﹀悎鏉′欢鐨勫巻鍙茶褰� + * @param clientId + * @param dt + * @return + */ + public RmClientAmountDay getRmClientAmountByClientAndDate(Long clientId, Date dt){ + List<RmClientAmountDay> list = rmClientAmountDayMapperDao.selectByClientAndDate(clientId, dt) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + + + ///////////////////////////////////////////////// + // + // 婕忔崯姘撮噺缁熻鍔熻兘 + // + //////////////////////////////////////////////// + /** + * 寰楀埌鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁℃渶鏂拌褰� + * @param intakeId + * @return + */ + public RmLossDayLast getRmLossLast(Long intakeId){ + List<RmLossDayLast> list = rmLossLastMapperDao.selectByIntakeId(intakeId) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + /** + * 淇濆瓨鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁℃渶鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmLossLast(RmLossDayLast po){ + this.rmLossLastMapperDao.insert(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁℃渶鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmLossHistory(RmLossDay po){ + this.rmLossHistoryMapperDao.insert(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁℃渶鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmLossLast(RmLossDayLast po){ + this.rmLossLastMapperDao.updateByPrimaryKey(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁℃渶鏂拌褰� + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmLossHistory(RmLossDay po){ + this.rmLossHistoryMapperDao.updateByPrimaryKey(po) ; + } + + /** + * 寰楀埌鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁″巻鍙茶褰曚腑鐨勬渶鏂拌褰� + * @param id + * @return + */ + public RmLossDay getRmLossHistory(Long id){ + return rmLossHistoryMapperDao.selectByPrimaryKey(id) ; + } + + + /** + * 寰楀埌鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁℃渶鏂拌褰� + * @param dt + * @return + */ + public RmLossDayLast getRmLossLastByDate(Date dt){ + List<RmLossDayLast> list = rmLossLastMapperDao.selectByDate(dt) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + + /** + * 寰楀埌鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁″巻鍙茶褰曚腑鐨勬煇鏃ヨ褰� + * @param dt + * @return + */ + public RmLossDay getRmLossHistoryByDate(Date dt){ + List<RmLossDay> list = rmLossHistoryMapperDao.selectByDate(dt) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + + ////////////////////////////////////////////////////// + // + // IC鍗$浉鍏� + // + ////////////////////////////////////////////////////// + /** + * 寰楀埌鍐滄埛鍗� + * @param cardAddr + * @param cardNo + * @return + */ + public VoCardInfo1 getIcCard(String cardAddr, String cardNo){ + if(NumUtil.isPlusIntNumber(cardNo)){ + Long icCardNoLong = Long.parseLong(cardNo) ; + List<VoCardInfo1> list = seClientCardDao.getCardsByAddrAndNum(cardAddr, icCardNoLong) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + } + return null ; + } + /** + * 寰楀埌鍐滄埛铏氭嫙鍗� + * @param cardNo + * @return + */ + public VoCardInfo1 getVirIcCard(String cardNo){ + if(NumUtil.isPlusIntNumber(cardNo)){ + Long icCardNoLong = Long.parseLong(cardNo) ; + List<VoCardInfo1> list = seVirtualCardDao.getCardsByNum(icCardNoLong) ; + if(list != null && list.size() > 0){ + return list.get(0) ; + } + } + return null ; + } + + /** + * 鏇存柊瀹炰綋鍗″墿浣欓噾棰� + * @param id + * @param remainMoney + */ + @Transactional(rollbackFor = Exception.class) + public void updateIcCardRemainMoney(Long id , Double remainMoney){ + seClientCardDao.updateMoney(id,remainMoney); + } + + /** + * 鏇存柊铏氭嫙鍗″墿浣欓噾棰� + * @param id + * @param remainMoney + */ + @Transactional(rollbackFor = Exception.class) + public void updateVirIcCardRemainMoney(Long id , Double remainMoney){ + seVirtualCardDao.updateMoney(id,remainMoney); + } + + ////////////////////////////////////////////////////// + // + // 鍛戒护鏃ュ織鐩稿叧 + // + ////////////////////////////////////////////////////// + public RmCommandHistory getCommandLog(String commandId){ + return rmCommandHistoryDao.selectByPrimaryKey(Long.parseLong(commandId)) ; + } + @Transactional(rollbackFor = Exception.class) + public void updateCommandLog(RmCommandHistory po){ + rmCommandHistoryDao.updateByPrimaryKey(po) ; + } + + +} -- Gitblit v1.8.0