//数据库字段为aFlag,类型为int
string sqltt = " select case when aFlag = 1 then '审核'
when aFlag = 0 then '未审核' else '带核实' end as aFlag,
appgroup,aID,appCode,appItem,appName,appPrice,appCount,
appUnit,appCause,appPerson,appDate from tbl_BuyApp";
sql语句数据库数据是1,0 前台显示审核,未审核
最新推荐文章于 2022-09-30 17:58:58 发布