| | |
|---|
| | | order by id asc |
|---|
| | | </select> |
|---|
| | | <select id="getScreenType" resultType="java.lang.String"> |
|---|
| | | select distinct screen_type from plus_inf.tb_lock_inf |
|---|
| | | select distinct screen_box_type from plus_inf.tb_lock_inf |
|---|
| | | <where> |
|---|
| | | tb_lock_inf.lock_id in( |
|---|
| | | select distinct lock_id from plus_user.tb_baojigroup_lock,plus_user.tb_baojigroup_usr |
|---|
| | |
|---|
| | | </where> |
|---|
| | | </select> |
|---|
| | | <select id="getScreenProduct" resultType="java.lang.String"> |
|---|
| | | select distinct screen_product from plus_inf.tb_lock_inf |
|---|
| | | select distinct screen_box_product from plus_inf.tb_lock_inf |
|---|
| | | <where> |
|---|
| | | tb_lock_inf.lock_id in( |
|---|
| | | select distinct lock_id from plus_user.tb_baojigroup_lock,plus_user.tb_baojigroup_usr |
|---|
