1
<%...@ Page language="C#"%>
2
<!--
3Copyright 2002-2006 Corey Trager
4Distributed under the terms of the GNU General Public License
5-->
6<!-- #include file = "inc.aspx" -->
7
8<script language="C#" runat="server">...
9
10String sql;
11DbUtil dbutil;
12Security security;
13
14///////////////////////////////////////////////////////////////////////
15void Page_Load(Object sender, EventArgs e)
16
...{
17
18 Util.do_not_cache(Response);
19 dbutil = new DbUtil();
20 security = new Security();
21
22 if (Util.get_setting("AllowQueryEditingForNonAdmins","0") == "1")
23 ...{
24 security.check_security(dbutil, HttpContext.Current, Security.ANY_USER_OK_EXCEPT_GUEST);
25
}
26 else
27 ...{
28 security.check_security(dbutil, HttpContext.Current, Security.MUST_BE_ADMIN);
29 }
30
31 title.InnerText = Util.get_setting("AppTitle","BugTracker.NET") + " - "
32 + "delete query";
33
34 string id = Util.sanitize_integer(Request["id"]);
35 string confirm = Request.QueryString["confirm"];
36
37 if (confirm == "y")
38 ...{
39 // do delete here
40 sql = @"delete queries where qu_id = $1";
41 sql = sql.Replace("$1", id);
42 dbutil.execute_nonquery(sql);
43 Server.Transfer ("queries.aspx");
44 }
45 else
46 ...{
47 confirm_href.HRef = "delete_query.aspx?confirm=y&id=" + id;
48
49 sql = @"select qu_desc from queries where qu_id = $1";
50 sql = sql.Replace("$1", id);
51
52 DataRow dr = dbutil.get_datarow(sql);
53
54 confirm_href.InnerText = "confirm delete of query: "
55 + Convert.ToString(dr["qu_desc"]);
56
57
58 }
59
60
61}
62
63void Page_Unload(Object sender, EventArgs e)
64...{
65 if (dbutil != null) ...{dbutil.close();}
66}
67
68
69</script>
70
71<html>
72<head>
73<title id="title" runat="server">btnet delete query</title>
74<link rel="StyleSheet" href="btnet.css" type="text/css">
75</head>
76<body>
77<%... security.write_menu(Response, "queries"); %>
78<p>
79<div class=align>
80<p> </p>
81<a href=queries.aspx>back to queries</a>
82<p>
83or
84<p>
85<a id="confirm_href" runat="server" href="">confirm delete</a>
86</div>
87</body>
88</html>
89
90
91
XTXHGRGZAXU57/delete_query.aspx，打开代码结构图
打包下载该项目完整源码：BugTrack免安装英文原版2.4.8
