三明商城网站开发设计,电商设计美工,做网站技术选择,网站主页设计优点加Param()
dao //根据区域id获取对应的 楼宇、楼层、房间数据范围 ListDbAread findBuildingListByAreaId(Param(dbAread)DbAread dbAread,Param(type)Integer type); xml !-- 根据区域id获取对应的 楼宇、楼层、房间数据范…加Param()
dao //根据区域id获取对应的 楼宇、楼层、房间数据范围 ListDbAread findBuildingListByAreaId(Param(dbAread)DbAread dbAread,Param(type)Integer type); xml !-- 根据区域id获取对应的 楼宇、楼层、房间数据范围 -- select idfindBuildingListByAreaId resultTypeDbAread SELECT include refiddbAreadColumns/ FROM db_aread a include refiddbAreadJoins/ where area_id #{dbAread.dbArea.id} /where GROUP BY choose when testtype !null and type 1 a.building_id /when when testtype !null and type 2 a.storey_id /when when testtype !null and type 3 a.room_id /when otherwise /otherwise /choose /select 不加Param() 不用写 dbAread参数 //根据 楼宇楼层房间 获取区域明细 (找对应的区域) ListDbAread findDbAreadByBBR(DbAread dbAread); !-- 根据 楼宇楼层房间 获取区域明细 (找对应的区域) -- select idfindDbAreadByBBR resultTypeDbAread SELECT include refiddbAreadColumns/ FROM db_aread a include refiddbAreadJoins/ where 11 if testdbBuilding !null and dbBuilding.id !null and dbBuilding.id ! and a.building_id #{dbBuilding.id} /if if testdbBuildingStorey !null and dbBuildingStorey.id !null and dbBuildingStorey.id ! and a.storey_id #{dbBuildingStorey.id} /if if testdbBsRoom !null and dbBsRoom.id !null and dbBsRoom.id ! and a.room_id #{dbBsRoom.id} /if /where /select
