⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 add_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" -->
<!-- #include file = "inc_insert_bug.aspx" -->
<!-- #include file = "inc_print_bug.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.ANY_USER_OK);

	msg.InnerText = "";

	string string_id = Request.QueryString["id"];
	back_href.HRef = "edit_bug.aspx?id=" + string_id;

	if (string_id == null)
	{
		id = 0;
	}
	else
	{
		id = Convert.ToInt32(string_id);
	}


}

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



void on_update(object Source, EventArgs e)
{

	if (attached_file.PostedFile == null)
	{
		msg.InnerText = "Please select file.";
		return;
	}

	string filename = System.IO.Path.GetFileName(attached_file.PostedFile.FileName);
	if (filename == "")
	{
		msg.InnerText = "Please select file.";
		return;
	}

	int max_upload_size = Convert.ToInt32(Util.get_setting("MaxUploadSize","100000"));
	int content_length = attached_file.PostedFile.ContentLength;
	if (content_length > max_upload_size)
	{
		msg.InnerText = "File exceeds maximum allowed length of "
			+ Convert.ToString(max_upload_size)
			+ ".";
		return;
	}

	if (content_length == 0)
	{
		msg.InnerText = "No data was uploaded.";
		return;
	}

	string upload_folder = Util.get_setting("UploadFolder","c:\\");
	if (!System.IO.Directory.Exists(upload_folder))
	{
		msg.InnerText = "Upload Folder does not exist on server.";
		return;
	}


	sql = @"insert into bug_comments
			(bc_bug, bc_user, bc_date, bc_comment, bc_type)
			values($bg, $us, getdate(), 'added attachment: $de', 'update')
		
			declare @bc_id int
			set @bc_id = @@IDENTITY
			
			insert into bug_attachments
			(ba_bug, ba_file, ba_desc, ba_size, ba_uploaded_date, ba_uploaded_user, ba_content_type)
			values ($bg, N'$fi', N'$de', $si, getdate(), $us, N'$ct')
			
			declare @ba_id int
			set @ba_id = @@IDENTITY
			
			select @bc_id, @ba_id";
	
	sql = sql.Replace("$bg", Convert.ToString(id));
	sql = sql.Replace("$fi", filename.Replace("'","''"));
	sql = sql.Replace("$de", desc.Value.Replace("'", "''"));
	sql = sql.Replace("$si", Convert.ToString(content_length));
	sql = sql.Replace("$us", Convert.ToString(security.this_usid));
	sql = sql.Replace("$ct", attached_file.PostedFile.ContentType);

	// save the attachment's identity
	
	DataRow dr = dbutil.get_datarow (sql);
	
	int bc_id = (int) dr[0];
	int ba_id = (int) dr[1];


	try
	{
	
		attached_file.PostedFile.SaveAs(
			upload_folder + "\\"
			+ id + "_"      // bug id
			+ ba_id + "_"   // attachment id
			+ filename);

		send_notifications(UPDATE, id, security.this_usid);

		Response.Redirect ("edit_bug.aspx?id=" + Convert.ToString(id), false);

	}
	catch (Exception e2)
	{
		
		// clean up
		sql = @"delete from bug_attachments where ba_id = $ba
			delete from bug_comments where bc_id = $bc";
			
		sql = sql.Replace("$ba",Convert.ToString(ba_id));
		sql = sql.Replace("$bc",Convert.ToString(bc_id));

		dbutil.execute_nonquery(sql);
	
	
		msg.InnerText = e2.Message;
		return;
	}
}


</script>

<html>
<head>
<title id="title" runat="server">btnet add 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 id="back_href" runat="server" href="">back to <% Response.Write(Util.get_setting("SingularBugLabel","bug")); %></a>

<form class=frm runat="server" enctype="multipart/form-data">
	<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>File:</td>
	<td><input runat="server" type=file class=txt id="attached_file" maxlength=255 size=60></td>
	<td runat="server" class=err id="attached_file_err">&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="Upload" 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 + -