📄 reports.aspx

📁 Bug管理系统
💻 ASPX
字号:
<%@ Page language="C#"%>
<!--
Copyright 2002-2005 Corey Trager
Distributed under the terms of the GNU General Public License
-->
<!-- #include file = "inc.aspx" -->

<script language="C#" runat="server">


DataSet ds;
DbUtil dbutil;
Security security;

void Page_Load(Object sender, EventArgs e)
{

	Util.do_not_cache(Response);
	dbutil = new DbUtil();
	security = new Security();
	security.check_security(dbutil, Request, Response, Security.ANY_USER_OK);


	title.InnerText = Util.get_setting("AppTitle","BugTracker.NET") + " - " 
		+ "reports";
	
	string sql = @"select 
	        rp_desc [report], 
	        case 
	            when rp_chart_type = 'pie' then 
	                '<a target=''_blank'' href=''view_report.aspx?view=chart&id=' + convert(varchar, rp_id) + '''>pie</a>' 
	            when rp_chart_type = 'line' then 
	                '<a target=''_blank'' href=''view_report.aspx?view=chart&id=' + convert(varchar, rp_id) + '''>line</a>' 
	            when rp_chart_type = 'bar' then 
	                '<a target=''_blank'' href=''view_report.aspx?view=chart&id=' + convert(varchar, rp_id) + '''>bar</a>' 
	            else 
	                '&nbsp;' end [view<br>chart], 
	        '<a target=''_blank'' href=''view_report.aspx?view=data&id=' + convert(varchar, rp_id) + '''>data</a>' [view<br>data] 
	        $adm
	        from reports order by rp_desc";

	if (security.this_is_admin) {
		sql = sql.Replace("$adm", ", " +
			"'<a href=''edit_report.aspx?id=' + convert(varchar, rp_id) + '''>edit</a>' [edit], " +
			"'<a href=''delete_report.aspx?id=' + convert(varchar, rp_id) + '''>delete</a>' [delete] ");
	} else {
		sql = sql.Replace("$adm", "");
	}
    
    ds = dbutil.get_dataset(sql);
	
}

void Page_Unload(Object sender, EventArgs e)
{
	if (dbutil != null) {dbutil.close();}
}


</script>

<html>
<head>
<title id="title" runat="server">btnet reports</title>
<link rel="StyleSheet" href="btnet.css" type="text/css">
<script type="text/javascript" language="JavaScript" src="sortable.js"></script>
</head>

<body>
<% security.write_menu(Response, "reports"); %>

<div class=align>
</p>

<% if (security.this_is_admin) { %>
<a href='edit_report.aspx'>add new report</a>
<% } %>


<%

if (ds.Tables[0].Rows.Count > 0)
{
	SortableHtmlTable.create_from_dataset(
		Response, ds, "", "", false);

}
else
{
	Response.Write ("No reports in the database.");
}

%>
</div>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -