From 5c9ff4d11524b55914d8edf7f1ca776c6e0cb62e Mon Sep 17 00:00:00 2001 From: 81041 <81041@192.168.10.16> Date: 星期二, 11 十二月 2018 11:44:48 +0800 Subject: [PATCH] 添加电池组或申请电池组 --- gx_tieta/src/com/fgkj/dao/BattinfGroupFactory.java | 14 + gx_tieta/src/com/fgkj/dao/BaseDAO.java | 2 gx_tieta/src/com/fgkj/actions/Battinf_applyAction.java | 45 ++++ gx_tieta/src/com/fgkj/actions/BattInfAction.java | 10 gx_tieta/src/com/fgkj/dto/Battinf_apply.java | 64 ++++++ gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java | 36 +++ gx_tieta/src/com/fgkj/services/Battinf_applyService.java | 43 ++++ gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java | 7 gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java | 312 +++++++++++++++++++++++++++++++ gx_tieta/src/com/fgkj/services/BattInfServices.java | 10 gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java | 2 11 files changed, 535 insertions(+), 10 deletions(-) diff --git a/gx_tieta/src/com/fgkj/actions/BattInfAction.java b/gx_tieta/src/com/fgkj/actions/BattInfAction.java index 947b4f5..833b60f 100644 --- a/gx_tieta/src/com/fgkj/actions/BattInfAction.java +++ b/gx_tieta/src/com/fgkj/actions/BattInfAction.java @@ -93,7 +93,15 @@ //System.out.println(result); return SUCCESS; } - + + //娣诲姞鎿嶄綔鏃舵煡璇㈠嚭璁惧id + public String searchmaxdev_id(){ + model = service.searchmaxdev_id(); + result = ActionUtil.tojson(model); + return SUCCESS; + } + + public String searchAll() { model = service.searchAll(); result = ActionUtil.tojson(model); diff --git a/gx_tieta/src/com/fgkj/actions/Battinf_applyAction.java b/gx_tieta/src/com/fgkj/actions/Battinf_applyAction.java new file mode 100644 index 0000000..6c63ae6 --- /dev/null +++ b/gx_tieta/src/com/fgkj/actions/Battinf_applyAction.java @@ -0,0 +1,45 @@ +package com.fgkj.actions; + +import java.util.List; + +import com.fgkj.dto.BattInf; +import com.fgkj.dto.Battinf_apply; +import com.fgkj.dto.ServiceModel; +import com.fgkj.services.Battinf_applyService; +import com.google.gson.reflect.TypeToken; + +public class Battinf_applyAction extends ActionUtil{ + + private Battinf_applyService service=new Battinf_applyService(); + private String json; + private String result; + + + //纭鐢宠(澶氭潯) + public String update(){ + List<Battinf_apply> list=ActionUtil.getGson("yyyy-MM-dd HH:mm:ss").fromJson(json,new TypeToken<List<Battinf_apply>>(){}.getType() ); + ServiceModel model=service.update(list); + result=tojson(model); + return SUCCESS; + } + //娣诲姞鐢宠 + public String add(){ + List<Battinf_apply> list=ActionUtil.getGson("yyyy-MM-dd HH:mm:ss").fromJson(json,new TypeToken<List<Battinf_apply>>(){}.getType() ); + ServiceModel model=service.add(list); + result=tojson(model); + return SUCCESS; + } + + + + public String getResult() { + return result; + } + public void setJson(String json) { + this.json = json; + } + + + + +} diff --git a/gx_tieta/src/com/fgkj/dao/BaseDAO.java b/gx_tieta/src/com/fgkj/dao/BaseDAO.java index e720d18..2793c0c 100644 --- a/gx_tieta/src/com/fgkj/dao/BaseDAO.java +++ b/gx_tieta/src/com/fgkj/dao/BaseDAO.java @@ -202,6 +202,8 @@ public static final int APP_BTS_COMM_TASK=99; + public static final int BATTINF_APPLY=100; + public boolean add(Object obj); // 娣诲姞 public boolean update(Object obj); // 鏇存柊 diff --git a/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java b/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java index 628b621..13eebce 100644 --- a/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java +++ b/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java @@ -32,6 +32,7 @@ import com.fgkj.dao.impl.Battalarm_dataDAOImpl; import com.fgkj.dao.impl.Battalarm_data_historyImpl; import com.fgkj.dao.impl.BattinfThirdImpl; +import com.fgkj.dao.impl.Battinf_applyImpl; import com.fgkj.dao.impl.Battinf_exImpl; import com.fgkj.dao.impl.BattresdataDAOImpl; import com.fgkj.dao.impl.Battresdata_infDAOImpl; @@ -208,6 +209,7 @@ case 97:return new Bts_gprs_stateImpl(); case 98:return new Fbs9100_battparamImpl(); case 99:return new App_bts_comm_taskImpl(); + case 100:return new Battinf_applyImpl(); default :return null; } } diff --git a/gx_tieta/src/com/fgkj/dao/BattinfGroupFactory.java b/gx_tieta/src/com/fgkj/dao/BattinfGroupFactory.java index 5024dc6..20e7edf 100644 --- a/gx_tieta/src/com/fgkj/dao/BattinfGroupFactory.java +++ b/gx_tieta/src/com/fgkj/dao/BattinfGroupFactory.java @@ -5,6 +5,7 @@ import com.fgkj.dao.impl.BattInfImpl; import com.fgkj.dao.impl.Batt_rtstateDAOImpl; +import com.fgkj.dao.impl.Battinf_applyImpl; import com.fgkj.dao.impl.Database_backupImpl; import com.fgkj.dto.BattInf; import com.fgkj.dto.Database_backup; @@ -118,7 +119,18 @@ int station_next=station_max+1; return station_next; } - + //鏌ヨ褰撳墠鏈�澶х殑dev_id + public static int searchmaxdev_id(){ + int dev_id=0; + int devid_inf=(new BattInfImpl()).searchMaxdevId_binf(); + int devid_apply=(new Battinf_applyImpl()).searchMaxdevId_apply(); + if(devid_inf>=devid_apply){ + dev_id=devid_inf+1; + }else{ + dev_id=devid_apply+1; + } + return dev_id; + } //褰撳battinf琛ㄤ腑鏁版嵁杩涜澧炲垹鏀圭殑鎿嶄綔鏃讹紝鍏堝浠絛b_battinf.tb_battinf public static boolean backup_battinf(){ boolean en=false; diff --git a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java index 992983c..5b0a86b 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java @@ -382,8 +382,7 @@ } //娣诲姞鐢垫睜缁勬椂鏌ヨ鍑烘渶澶х殑鏈烘埧id鍜岀數姹犵粍id public int searchMaxId(){ - //,max(battgroupid) as maxb - String sql="select max(stationid) as stationid_maxs from db_battinf.tb_battinf limit 1"; + String sql="SELECT GREATEST((select max(StationId) from db_battinf.tb_battinf) ,(select max(StationId) from db_battinf.tb_battinf_apply)) as id"; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { public List getResults(ResultSet rs) { @@ -391,10 +390,10 @@ try { while(rs.next()){ - int maxs=42000000; + int maxs=42010000; //int maxb=1000001; - if(rs.getString("stationid_maxs") != null){ - maxs=Integer.parseInt(rs.getString("stationid_maxs")); + if(rs.getString("id") != null){ + maxs=Integer.parseInt(rs.getString("id")); } /*if(rs.getInt("maxb")!=0){ maxb=rs.getInt("maxb"); @@ -415,6 +414,33 @@ } return stationid; } + //鏌ヨ鍑哄綋鍓嶅瓨鍦ㄥ唴瀛樹腑鏈�澶х殑璁惧鐨刬d(寰堥噸瑕�**********) + public int searchMaxdevId_binf(){ + String sql="select max(FbsDeviceId) as id from db_battinf.tb_battinf limit 1"; + List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { + + public List getResults(ResultSet rs) { + List list=new ArrayList(); + try { + while(rs.next()){ + int dev_id=0; + if(rs.getString("id")!=null){} + dev_id=rs.getInt("id"); + list.add(dev_id); + } + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + return list; + } + }); + int dev_id=0; + if(list!=null&&list.size()>0){ + dev_id=(Integer) list.get(list.size()-1); + } + return dev_id; + } //鍒ゆ柇鏂板鐨勭數姹犵粍鏄惁瀛樺湪 public List judgeBatt(Object obj){ BattInf binf=(BattInf) obj; diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java index 49a50f7..a63fb42 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtstateDAOImpl.java @@ -752,14 +752,17 @@ //鏌ヨ鍑哄綋鍓嶅瓨鍦ㄥ唴瀛樹腑鏈�澶х殑鐢垫睜缁刬d(寰堥噸瑕�**********) public int searchMaxBattgroupId(){ - String sql=" select max(BattGroupId) as max_id from db_ram_db.tb_batt_rtstate limit 1"; + String sql=" SELECT GREATEST((select max(battgroupId) from db_battinf.tb_battinf) ,(select max(battgroupId) from db_battinf.tb_battinf_apply)) as id limit 1"; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { public List getResults(ResultSet rs) { List list=new ArrayList(); try { while(rs.next()){ - int battgroupid=rs.getInt("max_id"); + int battgroupid=1010000; + if(rs.getString("id")!=null){ + battgroupid=rs.getInt("id"); + } list.add(battgroupid); } } catch (SQLException e) { diff --git a/gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java new file mode 100644 index 0000000..5074c64 --- /dev/null +++ b/gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java @@ -0,0 +1,312 @@ +package com.fgkj.dao.impl; + +import java.sql.Connection; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.text.ParseException; +import java.text.SimpleDateFormat; +import java.util.ArrayList; +import java.util.Date; +import java.util.List; + +import com.fgkj.actions.ActionUtil; +import com.fgkj.dao.BaseDAO; +import com.fgkj.dao.BattinfGroupFactory; +import com.fgkj.dao.CallBack; +import com.fgkj.dao.DAOHelper; +import com.fgkj.dao.LimitNumberFactory; +import com.fgkj.dao.UinfDaoFactory; +import com.fgkj.db.DBUtil; +import com.fgkj.dto.BattInf; +import com.fgkj.dto.Battinf_apply; +import com.fgkj.dto.Page; +import com.fgkj.dto.User_inf; +import com.fgkj.dto.User_log; +import com.fgkj.services.User_logService; + +public class Battinf_applyImpl implements BaseDAO,CallBack{ + + public List getResults(ResultSet rs) { + // TODO Auto-generated method stub + return null; + } + //娣诲姞鐢宠 + public boolean add(Object obj) { + List<Battinf_apply> list=(List<Battinf_apply>) obj; + List<User_log> listU=new ArrayList<User_log>();//瀛樻斁user_log + ArrayList<String> sql_str=new ArrayList(); + //鑾峰彇褰撳墠鏈�澶х殑stationid鍜宐attgroupid + int maxs=BattinfGroupFactory.searchStationId(); + int maxb=BattinfGroupFactory.searchMaxBattgroupId(); + if(list!=null && list.size()>0){ + for (int i = 0; i < list.size(); i++) { + Battinf_apply bapply=list.get(i); + /*int uid=((User_inf)ActionUtil.getUser()).getUId(); + bapply.setApply_uid(uid);*/ + BattInf binf=bapply.getBinf(); + //楠岃瘉鏂版坊鍔犵殑鏈烘埧鏄惁瀛樺湪 + List listS=(new BattInfImpl()).judgeBatt(binf); + if(listS!=null&&listS.size()>0){ + binf.setStationId((String) listS.get(listS.size()-1)); + }else{ + binf.setStationId(String.valueOf(maxs)); + } + binf.setBattGroupId(maxb); + String sql = "insert into db_battinf.tb_battinf_apply(" + + "apply_uid,apply_date,StationId,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,FbsDeviceIp,FbsDeviceIp_YM,FbsDeviceIp_WG," + + "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" + + ") values("+bapply.getApply_uid()+",'"+DAOHelper.sdf.format(bapply.getApply_date())+"','"+binf.getStationId()+"','"+binf.getStationName()+"','"+binf.getStationName1()+"','"+binf.getStationName2()+"','"+binf.getStationName3()+"','"+binf.getStationName4()+"','"+binf.getStationName5()+ + "','"+binf.getStationIp()+"',"+binf.getFBSDeviceId()+",'"+binf.getFbsDeviceIp()+"','"+binf.getFbsDeviceIp_YM()+"','"+binf.getFbsDeviceIp_WG()+"','"+binf.getFBSDeviceName()+"',"+binf.getGroupIndexInFBSDevice()+ + ","+binf.getBattGroupId()+","+binf.getBattGroupNum()+",'"+binf.getBattGroupName()+"',"+binf.getFloatVolLevel()+","+binf.getOfflineVolLevel()+","+binf.getBattFloatCurrent()+ + ","+binf.getMonCount()+","+binf.getMonCapStd()+","+binf.getMonVolStd()+","+binf.getMonResStd()+","+binf.getMonSerStd()+","+binf.getMonVolLowToAvg()+ + ",'"+binf.getBattProducer()+"','"+binf.getBattModel()+"','"+DAOHelper.sdf.format(binf.getBattProductDate())+"','"+DAOHelper.sdf.format(binf.getBattInUseDate())+"',"+binf.getLoad_curr()+",'"+binf.getInstall_user()+"',"+binf.getDisCurrMax()+",'"+binf.getStation_phone()+"')"; + + if(binf.getStationId().equals(maxs)){ + maxs++; + } + maxb++; + sql_str.add(sql); + /*{ + String msg=((User_inf)ActionUtil.getUser()).getUId()+"鐢宠娣诲姞"+binf.getStationName()+"鏈烘埧"+binf.getBattGroupId()+"鐢垫睜缁勭殑淇℃伅"; + User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Increase, msg); + listU.add(ulog); + }*/ + } + } + Boolean bl=false; + boolean en=BattinfGroupFactory.backup_battinf(); + if(en){ + bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str); + }else{ + return false; + } + //(new User_logService()).addPro(listU);//灏嗙敤鎴风殑鎿嶄綔璁板綍涓嬫潵 + + return bl; + } + //纭鐢宠(澶氭潯) + public boolean update(Object obj) { + List<Battinf_apply> list=(List<Battinf_apply>) obj; + List<User_log> listU=new ArrayList<User_log>();//瀛樻斁user_log + ArrayList<String> sql_str=new ArrayList(); + if(list!=null&&list.size()>0){ + for (int i = 0; i < list.size(); i++) { + Battinf_apply bapply=list.get(i); + bapply.setConfrim_uid(((User_inf)ActionUtil.getUser()).getUId()); + BattInf binf=bapply.getBinf(); + binf.setStation_install(1); + String sql_update_apply=" update db_battinf.tb_battinf_apply set confrim_uid="+bapply.getConfrim_uid()+",apply_en=1 where num="+bapply.getNum(); + sql_str.add(sql_update_apply); + String sql_insert_binf="insert into db_battinf.tb_battinf(" + + "StationId,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,FbsDeviceIp,FbsDeviceIp_YM,FbsDeviceIp_WG," + + "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,Station_install" + + ") values('"+binf.getStationId()+"','"+binf.getStationName()+"','"+binf.getStationName1()+"','"+binf.getStationName2()+"','"+binf.getStationName3()+"','"+binf.getStationName4()+"','"+binf.getStationName5()+ + "','"+binf.getStationIp()+"',"+binf.getFBSDeviceId()+",'"+binf.getFbsDeviceIp()+"','"+binf.getFbsDeviceIp_YM()+"','"+binf.getFbsDeviceIp_WG()+"','"+binf.getFBSDeviceName()+"',"+binf.getGroupIndexInFBSDevice()+ + ","+binf.getBattGroupId()+","+binf.getBattGroupNum()+",'"+binf.getBattGroupName()+"',"+binf.getFloatVolLevel()+","+binf.getOfflineVolLevel()+","+binf.getBattFloatCurrent()+ + ","+binf.getMonCount()+","+binf.getMonCapStd()+","+binf.getMonVolStd()+","+binf.getMonResStd()+","+binf.getMonSerStd()+","+binf.getMonVolLowToAvg()+ + ",'"+binf.getBattProducer()+"','"+binf.getBattModel()+"','"+DAOHelper.sdf.format(binf.getBattProductDate())+"','"+DAOHelper.sdf.format(binf.getBattInUseDate())+"',"+binf.getLoad_curr()+",'"+binf.getInstall_user()+"',"+binf.getDisCurrMax()+",'"+binf.getStation_phone()+"',"+binf.getStation_install()+")"; + sql_str.add(sql_insert_binf); + { + String msg=((User_inf)ActionUtil.getUser()).getUId()+"纭娣诲姞"+binf.getStationName()+"鏈烘埧"+binf.getBattGroupId()+"鐢垫睜缁勭殑淇℃伅"; + User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Alter, msg); + listU.add(ulog); + } + } + } + Boolean bl=false; + boolean en=BattinfGroupFactory.backup_battinf(); + if(en){ + bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_str); + }else{ + return false; + } + (new User_logService()).addPro(listU);//灏嗙敤鎴风殑鎿嶄綔璁板綍涓嬫潵 + return bl; + + } + + public boolean del(Object obj) { + // TODO Auto-generated method stub + return false; + } + + public List searchAll() { + + return null; + } + //鏌ヨ鍑烘墍鏈夐渶瑕佺‘璁ょ殑鐢宠 + public List serchByCondition(Object obj) { + Battinf_apply bapply=(Battinf_apply) obj; + BattInf b=bapply.getBinf(); + Page page=b.getPage(); + Connection conn=DBUtil.getConn(); + String numberSql=" SELECT FOUND_ROWS() number"; + String sql=" select SQL_CALC_FOUND_ROWS distinct num,apply_uid,confrim_uid,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 " + + " from db_battinf.tb_battinf_apply " + + " where apply_en=0 and stationName1 like ? and stationName2 like ? and stationId like ? and stationName5 like ? " + + " limit ?,? "; + List<Battinf_apply> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{"%"+b.getStationName1()+"%","%"+b.getStationName2()+"%","%"+b.getStationId()+"%","%"+b.getStationName5()+"%",(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() { + + public List getResults(ResultSet rs) { + List list=new ArrayList(); + try { + while(rs.next()){ + Battinf_apply apply=new Battinf_apply(); + apply.setNum(rs.getInt("num")); + apply.setApply_uid(rs.getInt("apply_uid")); + apply.setConfrim_uid(rs.getInt("confrim_uid")); + apply.setApply_en(rs.getInt("apply_en")); + apply.setApply_date(rs.getTimestamp("apply_date")); + apply.setApply_note(rs.getString("apply_note")); + + BattInf binf=new BattInf(); + binf.setStationId(rs.getString("stationId")); + binf.setStationName(rs.getString("stationName")); + binf.setStationName1(rs.getString("stationName1")); + binf.setStationName2(rs.getString("stationName2")); + binf.setStationName3(rs.getString("stationName3")); + binf.setStationName4(rs.getString("stationName4")); + binf.setStationName5(rs.getString("stationName5")); + binf.setStationIp(rs.getString("stationIp")); + binf.setFBSDeviceId(rs.getInt("fBSDeviceId")); + + binf.setFbsDeviceIp(rs.getString("fbsDeviceIp")); + binf.setFbsDeviceIp_YM(rs.getString("fbsDeviceIp_YM")); + binf.setFbsDeviceIp_WG(rs.getString("fbsDeviceIp_WG")); + binf.setFBSDeviceName(rs.getString("fBSDeviceName")); + binf.setGroupIndexInFBSDevice(rs.getInt("groupIndexInFBSDevice")); + binf.setBattGroupId(rs.getInt("battGroupId")); + binf.setBattGroupNum(rs.getInt("battGroupNum")); + binf.setBattGroupName(rs.getString("battGroupName")); + binf.setFloatVolLevel(rs.getFloat("floatVolLevel")); + binf.setOfflineVolLevel(rs.getFloat("offlineVolLevel")); + binf.setBattFloatCurrent(rs.getFloat("battFloatCurrent")); + binf.setMonCount(rs.getInt("monCount")); + binf.setMonCapStd(rs.getFloat("monCapStd")); + binf.setMonVolStd(rs.getFloat("monVolStd")); + binf.setMonResStd(rs.getFloat("monResStd")); + binf.setMonSerStd(rs.getFloat("monSerStd")); + binf.setMonVolLowToAvg(rs.getFloat("monVolLowToAvg")); + binf.setBattProducer(rs.getString("battProducer")); + binf.setBattModel(rs.getString("battModel")); + binf.setBattProductDate(rs.getDate("battProductDate")); + binf.setBattInUseDate(rs.getDate("battInUseDate")); + binf.setLoad_curr(rs.getFloat("load_curr")); + binf.setInstall_user(rs.getString("install_user")); + binf.setDisCurrMax(rs.getFloat("disCurrMax")); + binf.setStation_phone(rs.getString("station_phone")); + + apply.setBinf(binf); + list.add(apply); + + } + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + return list; + } + }); + //鍘绘帀limit鏉′欢鍚庣殑鎬绘暟 + int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql); + //System.out.println("number: "+number); + if(list!=null&&list.size()>0){ + list.get(list.size()-1).setNum(number); + } + return list; + } + //鏌ヨ鍑哄綋鍓嶅瓨鍦ㄥ唴瀛樹腑鏈�澶х殑璁惧鐨刬d(寰堥噸瑕�**********) + public int searchMaxdevId_apply(){ + String sql="select max(FbsDeviceId) as id from db_battinf.tb_battinf_apply limit 1"; + List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { + + public List getResults(ResultSet rs) { + List list=new ArrayList(); + try { + while(rs.next()){ + int dev_id=0; + if(rs.getString("id")!=null){} + dev_id=rs.getInt("id"); + list.add(dev_id); + } + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + return list; + } + }); + int dev_id=0; + if(list!=null&&list.size()>0){ + dev_id=(Integer) list.get(list.size()-1); + } + return dev_id; + } + public List serchByInfo(Object obj) { + // TODO Auto-generated method stub + return null; + } + public static void main(String[] args) throws ParseException { + SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + Date date1 = sdf.parse("2000-01-01 00:00:00"); + Date date2 = sdf.parse("2020-01-01 23:59:59"); + Battinf_applyImpl bimpl=new Battinf_applyImpl(); + Battinf_apply bapply=new Battinf_apply(); + bapply.setApply_date(ActionUtil.getSimpDate(date2)); + bapply.setApply_uid(1002); + + + BattInf binf=new BattInf(); + binf.setStationName1("婀栧寳鐪�"); + binf.setStationName2("姝︽眽甯�"); + binf.setStationName3("鑽嗛棬甯�"); + binf.setStationName4("BTS璁惧"); + binf.setStationName5("閽熺ゥ"); + binf.setStationId("4011100"); + binf.setStationIp(""); + binf.setFBSDeviceId(910001000); + binf.setFbsDeviceIp("127.0.0.1"); + binf.setFbsDeviceIp_YM("255.255.255.0"); + binf.setFbsDeviceIp_WG("127.0.0.1"); + binf.setFBSDeviceName("璁惧鍚嶇О"); + binf.setGroupIndexInFBSDevice(1); + binf.setBattGroupId(1000005); + binf.setBattGroupNum(2); + binf.setBattGroupName("鐢垫睜缁�1"); + binf.setFloatVolLevel(54f); + binf.setOfflineVolLevel(42.9f ); + binf.setBattFloatCurrent(10f); + binf.setMonCount(24); + binf.setMonCapStd(300f); + binf.setMonVolStd(2f); + binf.setMonResStd(0.2f); + binf.setMonSerStd(5000f); + binf.setMonVolLowToAvg(0.05f ); + binf.setLoad_curr(15f); + binf.setDisCurrMax(39.5f); + binf.setStation_phone("12345678912"); + binf.setBattProducer(""); + binf.setBattModel(""); + binf.setBattProductDate(ActionUtil.getSimpDate(date1)); + binf.setBattInUseDate(ActionUtil.getSimpDate(date2)); + binf.setInstall_user(""); + + Page page=new Page(); + page.setPageCurr(1); + page.setPageSize(10); + binf.setPage(page); + bapply.setBinf(binf); + /*List list=bimpl.serchByCondition(bapply); + System.out.println(list.size());*/ + /*List list=new ArrayList(); + list.add(bapply); + boolean bl=bimpl.add(list); + System.err.println(bl);*/ + int dev_id=BattinfGroupFactory.searchmaxdev_id(); + System.out.println(dev_id); + } +} diff --git a/gx_tieta/src/com/fgkj/dto/Battinf_apply.java b/gx_tieta/src/com/fgkj/dto/Battinf_apply.java new file mode 100644 index 0000000..acc61b7 --- /dev/null +++ b/gx_tieta/src/com/fgkj/dto/Battinf_apply.java @@ -0,0 +1,64 @@ +package com.fgkj.dto; + +import java.io.Serializable; +import java.util.Date; + +public class Battinf_apply implements Serializable{ + private int num; + private int apply_uid; + private int confrim_uid; + private Date apply_date; + private int apply_en; + private String apply_note; + private BattInf binf; + public int getNum() { + return num; + } + public void setNum(int num) { + this.num = num; + } + public int getApply_uid() { + return apply_uid; + } + public void setApply_uid(int apply_uid) { + this.apply_uid = apply_uid; + } + public int getConfrim_uid() { + return confrim_uid; + } + public void setConfrim_uid(int confrim_uid) { + this.confrim_uid = confrim_uid; + } + public Date getApply_date() { + return apply_date; + } + public void setApply_date(Date apply_date) { + this.apply_date = apply_date; + } + public int getApply_en() { + return apply_en; + } + public void setApply_en(int apply_en) { + this.apply_en = apply_en; + } + public String getApply_note() { + return apply_note; + } + public void setApply_note(String apply_note) { + this.apply_note = apply_note; + } + public BattInf getBinf() { + return binf; + } + public void setBinf(BattInf binf) { + this.binf = binf; + } + @Override + public String toString() { + return "Battinf_apply [num=" + num + ", apply_uid=" + apply_uid + + ", confrim_uid=" + confrim_uid + ", apply_date=" + apply_date + + ", apply_en=" + apply_en + ", apply_note=" + apply_note + + ", binf=" + binf + "]"; + } + +} diff --git a/gx_tieta/src/com/fgkj/services/BattInfServices.java b/gx_tieta/src/com/fgkj/services/BattInfServices.java index 72477ae..6dcb6f0 100644 --- a/gx_tieta/src/com/fgkj/services/BattInfServices.java +++ b/gx_tieta/src/com/fgkj/services/BattInfServices.java @@ -1015,7 +1015,15 @@ model.setMsg("鏌ヨ鎴愬姛!"); return model; } - public static void main(String[] args) { + + //娣诲姞鎿嶄綔鏃舵煡璇㈠嚭璁惧id + public ServiceModel searchmaxdev_id(){ + int dev_id=BattinfGroupFactory.searchmaxdev_id(); + model.setData(dev_id); + return model; + } + + public static void main(String[] args) { //new BattInfServices().findMenu(); BattInf b=new BattInf(); //b.setBattGroupId(1000005); diff --git a/gx_tieta/src/com/fgkj/services/Battinf_applyService.java b/gx_tieta/src/com/fgkj/services/Battinf_applyService.java new file mode 100644 index 0000000..f174cb7 --- /dev/null +++ b/gx_tieta/src/com/fgkj/services/Battinf_applyService.java @@ -0,0 +1,43 @@ +package com.fgkj.services; + +import java.util.List; + +import com.fgkj.dao.BaseDAO; +import com.fgkj.dao.BaseDAOFactory; +import com.fgkj.dto.ServiceModel; + +public class Battinf_applyService { + + private ServiceModel model; + private BaseDAO dao; + public Battinf_applyService() { + super(); + model=new ServiceModel(); + dao=BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF_APPLY); + } + //纭鐢宠(澶氭潯) + public ServiceModel update(Object obj){ + boolean bl=dao.update(obj); + if(bl){ + model.setCode(1); + model.setMsg("纭鎴愬姛!"); + }else{ + model.setCode(0); + model.setMsg("纭疄澶辫触!"); + } + return model; + } + + //娣诲姞鐢宠 + public ServiceModel add(Object obj){ + boolean bl=dao.add(obj); + if(bl){ + model.setCode(1); + model.setMsg("纭鎴愬姛!"); + }else{ + model.setCode(0); + model.setMsg("纭疄澶辫触!"); + } + return model; + } +} -- Gitblit v1.9.1