Web_THBC 為表示層也就是頁面（.aspx） 
BLL_THBC 為業(yè)務(wù)邏輯層 
DAL_THBC 為數(shù)據(jù)庫交互層 （向數(shù)據(jù)庫執(zhí)行SQL語句） 
Model_THBC 為實(shí)體類 
DbHelper 為數(shù)據(jù)庫連接類 

統(tǒng)計(jì)個(gè)專營(yíng)店的男女?dāng)?shù)量 

復(fù)制代碼代碼如下:

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