From fa00382db413a8489d07983b66f0869305b51a9a Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期五, 11 一月 2019 11:35:54 +0800
Subject: [PATCH] 批量读取系统参数
---
gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java | 35 +++++++++++++++++++++++++++++++++--
1 files changed, 33 insertions(+), 2 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java
index f52488e..de25c0f 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java
@@ -14,6 +14,7 @@
import com.fgkj.dao.UinfDaoFactory;
import com.fgkj.db.DBUtil;
import com.fgkj.dto.User_log;
+import com.fgkj.dto.ram.Fbs9100_battparam;
import com.fgkj.dto.ram.Fbs9100_setparam;
import com.fgkj.dto.ram.Fbs9100_sysparam;
import com.fgkj.services.User_logService;
@@ -47,9 +48,9 @@
if(list!=null&&list.size()>0){
for (int i = 0; i < list.size(); i++) {
Fbs9100_sysparam fs=list.get(i);
- String sql="REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime"
+ String sql="REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime"
+ ",MACADDR,LoaderCount,DtCardCount,PowerBreakChargeCurr,MajorBattGroupNum,POF_BG_Boost_Cnt,POF_BG_Boost_VolStop,POF_BG_Boost_VolStart) "
- + " values("+fs.getDev_id()+",'"+fs.getIPADDR()+"','"+fs.getSubIPADDR()+"','"+fs.getNetGateADDR()+"',"+fs.getGroupVolRange()+","+fs.getGroupVolSorce()+","+fs.getCurrentRange()+","+fs.getCurrentTyte()+","+fs.getMonomerOrder()+","+fs.getBackLightTime()
+ + " values("+fs.getDev_id()+","+fs.getOp_cmd()+",'"+fs.getIPADDR()+"','"+fs.getSubIPADDR()+"','"+fs.getNetGateADDR()+"',"+fs.getGroupVolRange()+","+fs.getGroupVolSorce()+","+fs.getCurrentRange()+","+fs.getCurrentTyte()+","+fs.getMonomerOrder()+","+fs.getBackLightTime()
+",'"+fs.getMACADDR()+"',"+fs.getLoaderCount()+","+fs.getDtCardCount()+","+fs.getPowerBreakChargeCurr()+","+fs.getMajorBattGroupNum()+","+fs.getPOF_BG_Boost_Cnt()+","+fs.getPOF_BG_Boost_VolStop()+","+fs.getPOF_BG_Boost_VolStart()+")";
sql_str.add(sql);
{
@@ -71,6 +72,36 @@
boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id()});
return bl;
}
+ //鏌ヨ绯荤粺鍙傛暟鍓�(濡傛灉娌℃湁榛樿鏁版嵁瑕佺敤REPLACE 娣诲姞涓�绗旀暟鎹�)鍚屾椂鍙戦�佸懡浠�
+ public boolean replacePL(Object obj){
+ Fbs9100_sysparam sys=(Fbs9100_sysparam) obj;
+ String sql=" REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd) values(?,?)";
+ boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id(),sys.getOp_cmd()});
+ return bl;
+ }
+ //鎵归噺璇诲彇鐢垫睜鍙傛暟
+ public boolean readPL(Object obj) {
+ List<Fbs9100_sysparam> list=(List<Fbs9100_sysparam>) obj;
+ ArrayList sql_str=new ArrayList();
+ List<User_log> listU=new ArrayList<User_log>();//瀛樻斁user_log
+ if(list!=null&&list.size()>0){
+ for (int i = 0; i < list.size(); i++) {
+ Fbs9100_sysparam fs=list.get(i);
+ String sql="replace into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd) "
+ + " values("+fs.getDev_id()+","+fs.getOp_cmd()+")";
+ sql_str.add(sql);
+ {
+ String msg="鑾峰彇"+fs.getDev_id()+"绯荤粺鍙傛暟";
+ User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Alter, msg);
+ listU.add(ulog);
+ }
+ }
+ }
+
+ Boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str);
+ (new User_logService()).addPro(listU);//灏嗙敤鎴风殑鎿嶄綔璁板綍涓嬫潵
+ return bl;
+ }
public boolean del(Object obj) {
// TODO Auto-generated method stub
return false;
--
Gitblit v1.9.1