From f9dc37de61954ea173d0f79aa801402df9b4bc9a Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期二, 25 十二月 2018 15:18:02 +0800
Subject: [PATCH] 修改页面上验收时候的数据
---
gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java
index 696012f..bc32ce1 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java
@@ -172,6 +172,8 @@
bapply.setCheck_uid(((User_inf)ActionUtil.getUser()).getUId());
String sql_update_apply=" update db_battinf.tb_battinf_apply set check_uid="+bapply.getCheck_uid()+",check_en=1 where battgroupid="+binf.getBattGroupId();
sql_str.add(sql_update_apply);
+ String sql_replace_map=" replace into web_site.tb_battmap_information(StationId,StationName,address,longitude,latitude) values('"+binf.getStationId()+"','"+binf.getStationName()+"','"+bapply.getAddress()+"',"+bapply.getLongitude()+","+bapply.getLatitude()+")";
+ sql_str.add(sql_replace_map);
{
String msg="楠屾敹"+binf.getStationName()+"鏈烘埧";
User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Alter, msg);
@@ -192,7 +194,7 @@
for (int i = 0; i < list.size(); i++) {
Battinf_apply bapply=list.get(i);
BattInf binf=bapply.getBinf();
- String sql_update_apply=" update db_battinf.tb_battinf_apply set check_en=2 where battgroupid="+binf.getBattGroupId();
+ String sql_update_apply=" update db_battinf.tb_battinf_apply set check_en=2,longitude="+bapply.getLongitude()+",latitude="+bapply.getLatitude()+",address='"+bapply.getAddress()+"' where battgroupid="+binf.getBattGroupId();
sql_str.add(sql_update_apply);
{
String msg="鐢宠楠屾敹"+binf.getStationName()+"鏈烘埧";
@@ -280,7 +282,8 @@
String numberSql=" SELECT FOUND_ROWS() number";
String sql=" select SQL_CALC_FOUND_ROWS distinct num,apply_uid,confrim_uid,check_uid,check_en,apply_date,apply_en,apply_note,StationId,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FbsDeviceId,FbsDeviceIp_YM,FbsDeviceIp_WG,FbsDeviceIp"+
",FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent" +
- ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,Load_curr,install_user,DisCurrMax,station_phone " +
+ ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,Load_curr,install_user,DisCurrMax,station_phone "
+ + ",longitude,latitude,address " +
" from db_battinf.tb_battinf_apply " +
" where apply_en=? order by apply_date desc" +
" limit ?,? ";
@@ -302,6 +305,9 @@
apply.setCheck_uname((new User_infImpl()).changeUidToUname(apply.getCheck_uid()));
apply.setApply_date(rs.getTimestamp("apply_date"));
apply.setApply_note(rs.getString("apply_note"));
+ apply.setLongitude(rs.getDouble("longitude"));
+ apply.setLatitude(rs.getDouble("latitude"));
+ apply.setAddress(rs.getString("address"));
BattInf binf=new BattInf();
binf.setStationId(rs.getString("stationId"));
--
Gitblit v1.9.1