delete_customfield.aspx

来自「Bug管理系统」· ASPX 代码 · 共 97 行

ASPX
97 行
字号 
<%@ 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">

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") + " - " 
		+ "delete custom field";

	string id = Util.sanitize_integer(Request["id"]);
	string confirm = Request.QueryString["confirm"];

	if (confirm == "y")
	{
		// do delete here
		
		sql = @"select sc.name [column_name], df.name [default_constraint_name]
			from syscolumns sc
			inner join sysobjects so on sc.id = so.id 
			left outer join sysobjects df on df.id = sc.cdefault
			where so.name = 'bugs'
			and sc.colorder = $id";

		sql = sql.Replace("$id",id);
		DataRow dr = dbutil.get_datarow(sql);

		// if there is a default, delete it
		if (dr["default_constraint_name"].ToString() != "")
		{
			sql = @"alter table bugs drop constraint $df";
			sql = sql.Replace("$df", (string) dr["default_constraint_name"]);
			dbutil.execute_nonquery(sql);
		}
		
		
		// delete column itself
		sql = @"alter table bugs drop column [$nm]";
		sql = sql.Replace("$nm", (string) dr["column_name"]);
		dbutil.execute_nonquery(sql);
		Server.Transfer ("customfields.aspx");
		
		Response.Write(sql);
		Response.End();
	}
	else
	{
		confirm_href.HRef = "delete_customfield.aspx?confirm=y&id=" + id;
	}

}

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



</script>

<html>
<head>
<title id="title" runat="server">btnet delete customfield</title>
<link rel="StyleSheet" href="btnet.css" type="text/css">
</head>
<body>
<% security.write_menu(Response, "admin"); %>
<p>
<div class=align>
<p>&nbsp</p>
<a href=customfields.aspx>back to custom fields</a>
<p>
or
<p>
<a id="confirm_href" runat="server" href="">confirm delete</a>
</div>
</body>
</html>

delete_customfield.aspx - 源码说明

本页面展示了「Bug管理系统」中的 delete_customfield.aspx 源码文件，采用 ASPX 编程语言编写，共 97 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与Bug管理相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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