| | |
|---|
| | | <select id="getLockBl" resultType="com.whyc.pojo.plus_inf.LockBl"> |
|---|
| | | select tb_lock_bl.*, |
|---|
| | | tb_lock_inf.lock_name, |
|---|
| | | tb_station.station_name, |
|---|
| | | tb_station.station_name1, |
|---|
| | | tb_station.station_name2, |
|---|
| | | tb_station.station_name3, |
|---|
| | | tb_station.station_name4 |
|---|
| | | from plus_inf.tb_lock_inf,plus_inf.tb_lock_bl,plus_inf.tb_station |
|---|
| | | tb_station_inf.station_name, |
|---|
| | | tb_station_inf.station_name1, |
|---|
| | | tb_station_inf.station_name2, |
|---|
| | | tb_station_inf.station_name3, |
|---|
| | | tb_station_inf.station_name4 |
|---|
| | | from plus_inf.tb_lock_inf,plus_inf.tb_lock_bl,plus_inf.tb_station_inf |
|---|
| | | <where> |
|---|
| | | tb_lock_inf.lock_id=tb_lock_bl.lock_id |
|---|
| | | and tb_lock_inf.station_id=tb_station.station_id |
|---|
| | | and tb_lock_inf.station_id=tb_station_inf.station_id |
|---|
| | | <if test="dto.stationName1!=null"> |
|---|
| | | and tb_station_inf.station_name1 LIKE CONCAT('%',#{dto.stationName1},'%') |
|---|
| | | </if> |
|---|
| | |
|---|
| | | select distinct lock_id from plus_user.tb_baojigroup_lock,plus_user.tb_baojigroup_usr |
|---|
| | | <where> |
|---|
| | | tb_baojigroup_lock.baoji_id=tb_baojigroup_usr.baoji_id |
|---|
| | | <if test="uid>100"> |
|---|
| | | and tb_baojigroup_usr.uid=#{uid} |
|---|
| | | <if test="dto.uid>100"> |
|---|
| | | and tb_baojigroup_usr.uid=#{dto.uid} |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
| | | ) |
|---|
