<script language="c#" runat="server">
string TheTable,sql;
OleDbCommand comm;
private void Create_Date()
{
TheTable="article";
DataTable dt=new DataTable("default");
DataRow row;
dt.Columns.Add("id",Type.GetType("System.Int32"));
dt.Columns.Add("department",Type.GetType("System.String"));
dt.Columns.Add("tongji",Type.GetType("System.Int32"));
sql="select id,name from pa_department";
OleDbCommand comm=new OleDbCommand(sql,conn);
OleDbDataReader dr=comm.ExecuteReader();
while(dr.Read())
{
row = dt.NewRow();
row["id"]=int.Parse(dr["id"].ToString());
row["department"]=dr["name"].ToString();
row["tongji"]=TongJi(int.Parse(dr["id"].ToString()));
dt.Rows.Add(row);
}
dr.Close();
DataView dv=new DataView();
dv.Table=GetTable(dt,"tongji desc");
P1.DataSource=dv;
P1.DataBind();
}
private int TongJi(int dpid)
{
int rv=0;
sql="select count("+TheTable+".id) as co from "+TheTable+",pa_member where "+TheTable+".checked=1 and pa_member.department_id="+dpid+" and "+TheTable+".username=pa_member.username";
OleDbCommand comm=new OleDbCommand(sql,conn);
OleDbDataReader dr=comm.ExecuteReader();
if(dr.Read())
{
rv=int.Parse(dr["co"].ToString());
}
return rv;
}
private DataTable GetTable(DataTable sorucedt,string orderby)
{
sorucedt.DefaultView.Sort=orderby;
DataTable newdt = sorucedt.DefaultView.ToTable();
return newdt;
}
</script>
<%Create_Date();%>
<html>
<head>
<style type="text/css">
td{font:12px/1.7em Verdana,Tahoma,Helvetica,Arial,sans-serif;}
</style>
</head>
<body bgColor="transparent">
<div>
<table border=0 cellpadding=0 cellspacing=0>
<tr><td>部门</td><td> 投稿数</td></tr>
<asp:Repeater id="P1" runat="server">
<ItemTemplate>
<tr><td><%#DataBinder.Eval(Container.DataItem,"department")%></td><td> <%#DataBinder.Eval(Container.DataItem,"tongji")%></td></tr>
</ItemTemplate>
</asp:Repeater>
</table>
</body>
</html>
