📄 edit_attachment.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">

int id;
int bug_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.ANY_USER_OK_EXCEPT_GUEST);

	title.InnerText = Util.get_setting("AppTitle","BugTracker.NET") + " - " 
		+ "edit attachment";

	msg.InnerText = "";

	string var = Request.QueryString["id"];
	id = Convert.ToInt32(var);

	var = Request.QueryString["bug_id"];
	bug_id = Convert.ToInt32(var);


	if (!IsPostBack)
	{

		// Get this entry's data from the db and fill in the form

		sql = @"select ba_desc, ba_file from bug_attachments where ba_id = $1";
		sql = sql.Replace("$1", Convert.ToString(id));
		DataRow dr = dbutil.get_datarow(sql);

		// Fill in this form
		desc.Value = (string) dr["ba_desc"];
		filename.InnerText = (string) dr["ba_file"];

	}

}

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

///////////////////////////////////////////////////////////////////////
Boolean validate()
{

	Boolean good = true;

	return good;
}

///////////////////////////////////////////////////////////////////////
void on_update (Object sender, EventArgs e)
{

	Boolean good = validate();

	if (good)
	{

		sql = @"update bug_attachments set
			ba_desc = N'$1'
			where ba_id = $3";

		sql = sql.Replace("$3", Convert.ToString(id));
		sql = sql.Replace("$1", desc.Value.Replace("'", "''"));
		dbutil.execute_nonquery(sql);
		Response.Redirect ("edit_bug.aspx?id=" + Convert.ToString(bug_id));

	}
	else
	{
		msg.InnerText = "Attachment was not updated.";
	}

}

</script>

<html>
<head>
<title id="title" runat="server">btnet edit attachment</title>
<link rel="StyleSheet" href="btnet.css" type="text/css">
</head>
<body>
<% security.write_menu(Response, Util.get_setting("PluralBugLabel","bugs")); %>


<div class=align><table border=0><tr><td>
<a href=edit_bug.aspx?id=<% Response.Write(Convert.ToString(bug_id));%>>back to <% Response.Write(Util.get_setting("SingularBugLabel","bug")); %></a>
<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">&nbsp;</td>
	</tr>

	<tr>
	<td class=lbl>Filename:</td>
	<td><b><span id=filename runat="server">&nbsp;</span></b></td>
	<td>&nbsp;</td>
	</tr>


	<tr><td colspan=3 align=left>
	<span runat="server" class=err id="msg">&nbsp;</span>
	</td></tr>

	<tr>
	<td colspan=2 align=center>
	<input runat="server" class=btn type=submit id="sub" value="Update" OnServerClick="on_update">
	<td>&nbsp</td>
	</td>
	</tr>
	</td></tr></table>
</form>
</td></tr></table></div>
</body>
</html>
⌨️ 快捷键说明

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