| | |
|---|
| | | @Override
|
|---|
| | | public List serchByCondition(Object obj) {
|
|---|
| | | BattInf binf=(BattInf) obj;
|
|---|
| | | String sql="select db_battinf.tb_battinf.BattGroupId,db_battinf.tb_battinf.BattGroupName "
|
|---|
| | | String sql="select distinct db_battinf.tb_battinf.BattGroupId,db_battinf.tb_battinf.BattGroupName " |
|---|
| | | + ",db_ram_db.tb_batt_rtstate.group_vol,db_ram_db.tb_batt_rtstate.group_curr,db_ram_db.tb_batt_rtstate.batt_state "
|
|---|
| | | + ",(case when db_alarm.tb_battalarm_data.alm_signal_id is null then 0 ELSE db_alarm.tb_battalarm_data.alm_id end) AS alm_signal_id "
|
|---|
| | | + ",(case when db_alarm.tb_battalarm_data.alm_signal_id is null then 0 ELSE db_alarm.tb_battalarm_data.alm_signal_id end) AS alm_signal_id " |
|---|
| | | + " FROM db_battinf.tb_battinf "
|
|---|
| | | + " LEFT OUTER JOIN db_ram_db.tb_batt_rtstate on db_battinf.tb_battinf.BattGroupId=db_ram_db.tb_batt_rtstate.BattGroupId "
|
|---|
| | | + " LEFT OUTER JOIN db_alarm.tb_battalarm_data on db_battinf.tb_battinf.BattGroupId=db_alarm.tb_battalarm_data.BattGroupId "
|
|---|
