| | |
| | | //电池配组管理(重要)
|
| | | public List serchMakeGroup(Object obj){
|
| | | BattInf binf=(BattInf) obj;
|
| | | String sql="SELECT distinct BattGroupId,stationid,stationname1,stationname2,stationname,stationname3,BattProducer,MonVolStd,MonCapStd,monCount from db_battinf.tb_battinf where stationname2 like ? ";
|
| | | String sql="SELECT distinct BattGroupId,battgroupname,stationid,stationname1,stationname2,stationname,stationname3,BattProducer,MonVolStd,MonCapStd,monCount from db_battinf.tb_battinf where stationname2 like ? ";
|
| | | //选中品牌一致
|
| | | String producerSqlT=" order by BattProducer,MonCapStd,MonVolStd ";//一致
|
| | | String producerSqlF=" order by MonCapStd,MonVolStd ";//不一致
|
| | |
| | | while(rs.next()){
|
| | | BattInf binf=new BattInf();
|
| | | binf.setBattGroupId(rs.getInt("battGroupId"));
|
| | | binf.setBattGroupName(rs.getString("battGroupName"));
|
| | | binf.setStationId(rs.getString("stationId"));
|
| | | binf.setStationName(rs.getString("stationName"));
|
| | | binf.setStationName1(rs.getString("stationName1"));
|