62,074
社区成员
发帖
与我相关
我的任务
分享
//业务逻辑获取数据类
DisportManager manager = new DisportManager();
//用table接收数据
DataTable table = manager.showPack();
if (table.Rows.Count > 0)
{
int disportClass = (int)table.Rows[0]["DisportPackClass"];
if (disportClass == 0)
{
packClass = "无";
}
else if (disportClass == 1)
{
packClass = "优惠";
}
else if (disportClass == 2)
{
packClass = "热门";
}
}
else
{
table = null;
}//Repeater绑定数据
this.reapterShowDisortPack.DataSource = table;
this.reapterShowDisortPack.DataBind();
public string getString(string str)
{
string packClass = "";
switch (str)
{
case "0":
packClass = "无";
break;
case "1":
packClass = "优惠";
break;
case "2":
packClass = "热门";
break;
}
return packClass;
}
<%#getString( Eval("DisportPackClass").ToString())%>
select
case(sex)
when '1' then '男'
else '女'
end as sex
from MemberInfo
case when 性别=1 then '男' else '女' end