📄 view_subscribers.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") + " - " 
		+ "view subscribers";

	string sql = @"select
		us_username [user],
		us_email [email],
		case when us_only_new_bug_notifications = 1 then 'Y' else 'N' end [only new bug<br>notifications]
		from bug_subscriptions
		inner join users on bs_user = us_id
		where bs_bug = $bg
		and us_enable_notifications = 1
		and us_active = 1
		order by 1";

	sql = sql.Replace("$bg", Util.sanitize_integer(Request["id"]));

	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 view subscribers</title>
<link rel="StyleSheet" href="btnet.css" type="text/css">
<script type="text/javascript" language="JavaScript" src="sortable.js"></script>
</head>

<body>
<div class=align>
Bug Subscribers
<p>
<%
if (ds.Tables[0].Rows.Count > 0)
{
	SortableHtmlTable.create_from_dataset(
		Response, ds, "", "");

}
else
{
	Response.Write ("No subscribers for this bug.");
}
%>
</div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -