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 | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 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 5679f3e..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; @@ -78,6 +79,29 @@ 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