| | |
|---|
| | | String sql=" select distinct(tb_battinf.StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"
|
|---|
| | | + "FBSDeviceName,count(FBSDeviceId) as batt_num" +
|
|---|
| | | ",MonCount,monVolStd,monResStd,MonSerStd,Load_curr,DisCurrMax,montmpstd,floatVolLevel,offlineVolLevel,battFloatCurrent"
|
|---|
| | | + ",GROUP_CONCAT(tb_battinf.MonCapStd) as moncapstds "
|
|---|
| | | + ",GROUP_CONCAT(tb_battinf.MonCapStd order by groupIndexInFBSDevice separator '/' ) as moncapstds "
|
|---|
| | | + ",db_ram_db.tb_fbs9100_state.dev_version"
|
|---|
| | | + ",web_site.tb_batt_endurance.real_cap_group1 ,web_site.tb_batt_endurance.real_cap_group2,web_site.tb_batt_endurance.real_cap_group3,web_site.tb_batt_endurance.real_cap_group4 "
|
|---|
| | | + " from db_battinf.tb_battinf,db_ram_db.tb_fbs9100_state,web_site.tb_batt_endurance "
|
|---|
