Skip to content

库区检索

AreaSearch

库区检索

sqlId: selectArea

SQL

sql
select a.*
        from bas_wh_area a
        where a.is_enable = '0001'
        --@ and a.wh_id = #{wh_id, javaType=long}
        --% and (a.wh_area_code like #{wh_area_code} or a.wh_area_name like #{wh_area_code})
        --# and A.#

字段

总共 6

字段描述
wh_area_id库区ID
wh_id仓库ID
wh_area_code库区编号
wh_area_name库区名称
wh_area_classify库区分类
director负责人