?? edit_report.aspx
字號(hào):
<%@ 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">
int id;
String sql;
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.MUST_BE_ADMIN);
title.InnerText = Util.get_setting("AppTitle","BugTracker.NET") + " - "
+ "edit report";
msg.InnerText = "";
string var = Request.QueryString["id"];
if (var == null) {
id = 0;
} else {
id = Convert.ToInt32(var);
}
if (!IsPostBack) {
// add or edit?
if (id == 0) {
sub.Value = "Create";
sql_text.Value = Request.Form["sql_text"]; // if coming from search.aspx
table.Checked = true;
} else {
sub.Value = "Update";
// Get this entry's data from the db and fill in the form
sql = @"select
rp_desc, rp_sql, rp_chart_type
from reports where rp_id = $1";
sql = sql.Replace("$1", Convert.ToString(id));
DataRow dr = dbutil.get_datarow(sql);
// Fill in this form
desc.Value = (string) dr["rp_desc"];
sql_text.Value = Server.HtmlEncode((string) dr["rp_sql"]);
switch ((string) dr["rp_chart_type"]) {
case "pie":
pie.Checked = true;
break;
case "bar":
bar.Checked = true;
break;
case "line":
line.Checked = true;
break;
default:
table.Checked = true;
break;
}
}
}
}
void Page_Unload(Object sender, EventArgs e) {
if (dbutil != null) { dbutil.close(); }
}
///////////////////////////////////////////////////////////////////////
Boolean validate() {
Boolean good = true;
if (desc.Value == "") {
good = false;
desc_err.InnerText = "Description is required.";
} else {
desc_err.InnerText = "";
}
if (sql_text.Value == "") {
good = false;
msg.InnerText = "The SQL statement is required. ";
} else {
msg.InnerText = "";
}
return good;
}
///////////////////////////////////////////////////////////////////////
void on_update (Object sender, EventArgs e) {
Boolean good = validate();
string ct;
if (good)
{
if (id == 0) { // insert new
sql = @"insert into reports
(rp_desc, rp_sql, rp_chart_type)
values (N'$de', N'$sq', N'$ct')";
}
else
{ // edit existing
sql = @"update reports set
rp_desc = N'$de',
rp_sql = N'$sq',
rp_chart_type = N'$ct'
where rp_id = $id";
sql = sql.Replace("$id", Convert.ToString(id));
}
sql = sql.Replace("$de", desc.Value.Replace("'","''"));
sql = sql.Replace("$sq", Server.HtmlDecode(sql_text.Value.Replace("'", "''")));
if (pie.Checked) {
ct = "pie";
} else if (bar.Checked) {
ct = "bar";
} else if (line.Checked) {
ct = "line";
} else {
ct = "table";
}
sql = sql.Replace("$ct", ct);
dbutil.execute_nonquery(sql);
Server.Transfer("reports.aspx");
}
else
{
if (id == 0)
{ // insert new
msg.InnerText += "Query was not created.";
}
else
{ // edit existing
msg.InnerText += "Query was not updated.";
}
}
}
</script>
<html>
<head>
<title id="title" runat="server">btnet edit report</title>
<link rel="stylesheet" href="/include/site.css" type="text/css">
<link rel="stylesheet" href="btnet.css" type="text/css">
</head>
<body>
<% security.write_menu(Response, "reports"); %>
<div class='align'>
<a href='reports.aspx'>back to reports</a>
<br><br>
<table border='0'>
<tr>
<td>
<form class='frm' runat="server">
<table border='0'>
<tr>
<td class='lbl'>Description:</td>
<td><input runat="server" type='text' class='txt' id="desc" maxlength='80' size='80'></td>
<td runat="server" class='err' id="desc_err"> </td>
</tr>
<tr>
<td class='lbl'>Chart Type:</td>
<td>
<asp:RadioButton text="Table" runat="server" class='txt' GroupName="chart_type" id="table" />
<asp:RadioButton text="Pie" runat="server" class='txt' GroupName="chart_type" id="pie" />
<asp:RadioButton text="Bar" runat="server" class='txt' GroupName="chart_type" id="bar" />
<asp:RadioButton text="Line" runat="server" class='txt' GroupName="chart_type" id="line" />
</td>
<td runat="server" class='err' id="chart_type_err"> </td>
</tr>
<tr>
<td class='lbl'>SQL:</td>
<td colspan='2'>
<textarea rows='10' cols='70' runat="server" class='txt' name="sql_text" id="sql_text"></textarea>
</td>
</tr>
<tr>
<td colspan='3' align='center'>
<span runat="server" class='err' id="msg"> </span>
</td>
</tr>
<tr>
<td colspan='2' align='center'>
<input runat="server" class='btn' type='submit' id="sub" value="Create or Edit" OnServerClick="on_update">
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td colspan='2' class='cmt'>
To use "Pie", "Bar", or "Line", your SQL statement should have two columns <br>where the first column is the label and the second column contains the value.
<br><br>
You can use the pseudo-variable $ME in your report which will be replaced by your user ID.
<br>
For example:
<ul>
select .... from ....<br>
where bg_assigned_to_user = $ME
</ul>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -