web_thbc 为表示层也就是页面(.aspx)
bll_thbc 为业务逻辑层
dal_thbc 为数据库交互层 (向数据库执行sql语句)
model_thbc 为实体类
dbhelper 为数据库连接类
统计个专营店的男女数量
复制代码 代码如下:
select dua.uarters_id,dua.uarters_name
,sum(case when sex = ‘1’ then 1 else 0 end) as man
,sum(case when sex = ‘0’ then 1 else 0 end) as woman
from dbo.dcad_user as du
left join
dbo.dcad_uarters as dua
on du.uarters_id = dua.uarters_id
group by dua.uarters_id,dua.uarters_name
作者 ershouyage