-- SELECT * FROM vi_FeeItem where id=470 -- 腰臀比 RID=352 -- SELECT * FROM Dict_ReportItem WHERE RptItemName='体重指数' -- 值计算:身高RID=250,体重RID=351 -- Round((10000*[351] / ([350] *[350])), 1) -- 体检词计算 -- SELECT id as SID,SignName FROM Dict_Sign WHERE rid=352 -- 703 正常, 704 消瘦, 705 超重, 706 肥胖, 707 轻度肥胖, 708 中度肥胖, 709 重度肥胖 ([value]<18.5)?(704):(([value]>=18.5&&[value]<24)?703:(([value]>=24&&[value]<28)?705:(([value]>=28&&[value]<30)?705:(([value]>=30&&[value]<35)?707:(([value]>=35&&[value]<40)?708:(([value]>=40)?709:703)))))) -- SELECT id as SID,SignName FROM Dict_Sign WHERE rid=362 -- 736 正常, 737 消瘦, 738 超重, 739 肥胖, 740 轻度肥胖, 741 中度肥胖, 742 重度肥胖 ([value]<18.5)?( 737):(([value]>=18.5&&[value]<24)? 736:(([value]>=24&&[value]<28)? 738:(([value]>=28&&[value]<30)? 739:(([value]>=30&&[value]<35)? 740:(([value]>=35&&[value]<40)? 741:(([value]>=40)? 742: 736)))))) ([value]<18.5)?(737):(([value]>=18.5&&[value]<24)?736:(([value]>=24&&[value]<28)?738:(([value]>=28&&[value]<30)?739:(([value]>=30&&[value]<35)?740:(([value]>=35&&[value]<40)?741:(([value]>=40)?742:736))))))