| | |
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
|
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
|---|
| | | " left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " where db_user.tb_user_inf.uid=? " +
|
|---|
| | | " where db_user.tb_user_inf.uid=? and db_battinf.tb_battinf.Station_install=1 " +
|
|---|
| | | " limit 1";
|
|---|
| | | List<BattInf> list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {
|
|---|
| | |
|
|---|
| | |
|---|
| | | });
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | //实时历史机历卡
|
|---|
| | | public List serchByBattgroupId(Object obj){
|
|---|
| | | BattInf binf=(BattInf)obj;
|
|---|
| | | String sql="select * from db_battinf.tb_battinf where battgroupid=?";
|
|---|
| | |
|---|
| | | batt.setSignalId(rs.getString("SignalId"));
|
|---|
| | |
|
|---|
| | | batt.setCInterFaceId(Integer.parseInt(rs.getString("CInterFaceId")));
|
|---|
| | | |
|---|
| | | batt.setInstall_user(rs.getString("install_user"));
|
|---|
| | | batt.setSignalName(rs.getString("SignalName"));
|
|---|
| | | int BattGuarantDayCount=rs.getInt("BattGuarantDayCount")-ActionUtil.daysBetween(rs.getDate("BattInUseDate"), new Date());//剩余保修天数
|
|---|
| | | batt.setBattGuarantDayCount(BattGuarantDayCount);
|
|---|
