验证中...
开源中国 2018 年度最后一场技术盛会邀你来约~错过就要等明年啦!点此立即预约
语言: SQL
分类: 数据库相关
最后更新于 2018-07-12 14:41
easyUI对应的sql表单
原始数据 复制代码
select A.ID,CASE B.ZUFANG_TYPE WHEN 1 THEN '整租' WHEN 2 THEN '合租' END ZUFAN_TYPR,
B.TILE,B.ADDRESS,B.XIAOQU_ID,B.HM_TYPE,B.CREATE_TIME,
CAST (B.LOUCENG AS VARCHAR)+'层' LOUCEN,
CAST (B.LOUCENG_SUM AS VARCHAR)+'层' LOUCEN_SUM,
CAST(B.SHI_NUM AS VARCHAR)+'室'+CAST(B.TING_NUM AS VARCHAR)+'厅'+CAST(B.WEI_NUM AS VARCHAR)+'卫' FY_TYPE,
A.DANYUAN,A.PRICE,A.MIANJI,
CASE A.STATE WHEN 1 THEN '未租' WHEN 2 THEN '已租' ELSE '' END STATE
FROM TPRG_HOUSE_INFOR A,TPRG_HOUSE_LIST B where B.ID = A.HM_ID
and B.CREATE_USER = 'admin'

评论列表( 0 )

你可以在登录后,发表评论

搜索帮助

12_float_left_people 12_float_left_close