SELECT
A.ID,
A.AccountID,
B.OrganFullName,
A.AccountType,
B.OrganShortName,
C.StageName,
A.AddTime
FROM AccountInfo A
join OrganInfo B on A.StageID=B.OrganID
left join StageInfo C on A.StageID=C.StageIDAccountType是用户类型,如果为1那么就在界面上显示OrganShortName的值,如果为0就显示StageName的值,在哪里判断比较好呢?下面是界面上的绑定
<td>
<%#Eval("AccountType")%>
</td>
A.ID,
A.AccountID,
B.OrganFullName,
A.AccountType,
B.OrganShortName,
C.StageName,
A.AddTime
FROM AccountInfo A
join OrganInfo B on A.StageID=B.OrganID
left join StageInfo C on A.StageID=C.StageIDAccountType是用户类型,如果为1那么就在界面上显示OrganShortName的值,如果为0就显示StageName的值,在哪里判断比较好呢?下面是界面上的绑定
<td>
<%#Eval("AccountType")%>
</td>
三元运算符 来判定
<td>
<%#DataBinder.Eval(Container.DataItem, "AccountType", "{0} ") ==1 ? DataBinder.Eval(Container.DataItem, "OrganShortName", "{0} "):
DataBinder.Eval(Container.DataItem, "StageName", "{0} ")%>
</td>