定义了 sytle 用TABLE引用,但是总会把余下的网页代码包含进去,改怎么设置?
<script language="c#" runat="server">
string Get_Username(int departmentid)
{
string rv="";
DataTable mdt=Get_Data("select username from pa_member where department_id="+departmentid);
DataRow dr;
for(int i=0;i<mdt.Rows.Count;i++)
{
dr=mdt.Rows[i]; //说明:给dr赋值
rv+=dr["username"].ToString()+",";
}
return rv;
}
int Get_Count(string username)
{
int count=0;
string[] Ausername=username.Split(',');
for(int i=0;i<Ausername.Length;i++)
{
if(Ausername[i]==""){continue;}
count+=int.Parse(Get_Data("co","select count(id) as co from article where username='"+Ausername[i]+"'"));
}
return count;
}
</script>
<%
DataTable tgdt=new DataTable("default"); //新建一个投稿DataTable
DataRow row;
tgdt.Columns.Add("department",Type.GetType("System.String"));
tgdt.Columns.Add("tgcount",Type.GetType("System.Int32"));
//给新建的DataTable赋值
DataTable dt=Get_Data("select id,name from pa_department");
DataRow dr;
string usernames="";
for(int i=0;i<dt.Rows.Count;i++)
{
dr=dt.Rows[i];
row = tgdt.NewRow();
row["department"]=dr["name"].ToString();
usernames=Get_Username(int.Parse(dr["id"].ToString()));
row["tgcount"]= Get_Count(usernames);
tgdt.Rows.Add(row);
}
tgdt.DefaultView.Sort="tgcount desc";
tgdt=tgdt.DefaultView.ToTable();
//给新建的DataTable赋值结束
%>
<style type="text/css">
.tgtb{border:1px solid #d2e5ee;border-collapse:collapse;width:100%}
.tgtb td{border:1px solid #d2e5ee;padding:4px;}
</style>
<table cellpadding="0" cellspacing="0" class="tgtb">
<tr>
<td align=center>排名</td>
<td align=center>部门</td>
<td align=center>投稿数</td>
</tr>
<%
for(int i=0;i<tgdt.Rows.Count;i++)
{
if(i==10){return;} //只统计前10位。
dr=tgdt.Rows[i];
%>
<tr>
<td><%=i+1%></td>
<td><%=dr["department"]%></td>
<td><%=dr["tgcount"]%></td>
</tr>
<%}%>
</table>