From 9cd14356ba16fd0f8e8d930236edd118a9b8c306 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期二, 25 十二月 2018 14:26:33 +0800
Subject: [PATCH] 验收时加机房的经纬度
---
gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java | 4 +++-
1 files changed, 3 insertions(+), 1 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..969d020 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()+"鏈烘埧";
--
Gitblit v1.9.1