edit_priority.aspx

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

ASPX
269 行
字号 
<%@ 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 priority";

	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";
		}
		else
		{
			sub.Value = "Update";

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

			sql = @"select
				pr_name, pr_sort_seq, pr_background_color, isnull(pr_style,'') [pr_style]
				from priorities where pr_id = $1";

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

			// Fill in this form
			name.Value = (string) dr["pr_name"];
			sort_seq.Value = Convert.ToString((int) dr["pr_sort_seq"]);
			color.Value = (string) dr["pr_background_color"];
			style.Value = (string) dr["pr_style"];

		}
	}

}

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

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

	Boolean good = true;
	if (name.Value == "")
	{
		good = false;
		name_err.InnerText = "Description is required.";
	}
	else
	{
		name_err.InnerText = "";
	}

	if (sort_seq.Value == "")
	{
		good = false;
		sort_seq_err.InnerText = "Sort Sequence is required.";
	}
	else
	{
		sort_seq_err.InnerText = "";
	}

	if (!Util.is_int(sort_seq.Value))
	{
		good = false;
		sort_seq_err.InnerText = "Sort Sequence must be an integer.";
	}
	else
	{
		sort_seq_err.InnerText = "";
	}


	if (color.Value == "")
	{
		good = false;
		color_err.InnerText = "Background Color in #FFFFFF format is required.";
	}
	else
	{
		color_err.InnerText = "";
	}


	return good;
}

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

	Boolean good = validate();

	if (good)
	{
		if (id == 0)  // insert new
		{
			sql = @"insert into priorities
				(pr_name, pr_sort_seq, pr_background_color, pr_style)
				values (N'$na', $ss, N'$co', N'$st')";
		}
		else // edit existing
		{

			sql = @"update priorities set
				pr_name = N'$na',
				pr_sort_seq = $ss,
				pr_background_color = N'$co',
				pr_style = N'$st'
				where pr_id = $id";

			sql = sql.Replace("$id", Convert.ToString(id));

		}
		sql = sql.Replace("$na", name.Value.Replace("'","''"));
		sql = sql.Replace("$ss", sort_seq.Value);
		sql = sql.Replace("$co", color.Value.Replace("'","''"));
		sql = sql.Replace("$st", style.Value.Replace("'","''"));
		dbutil.execute_nonquery(sql);
		Server.Transfer ("priorities.aspx");

	}
	else
	{
		if (id == 0)  // insert new
		{
			msg.InnerText = "Priority was not created.";
		}
		else // edit existing
		{
			msg.InnerText = "Priority was not updated.";
		}

	}

}

</script>

<html>
<head>
<title id="title" runat="server">btnet edit priority</title>
<link rel="StyleSheet" href="btnet.css" type="text/css">

<script>

function change_sample_color()
{

	var sample = document.getElementById("sample");
	var color = document.getElementById("color");
	
	try 
	{
		sample.style.background = color.value;
	}
	catch(e)
	{
	}
	
	
}
</script>

</head>
<body onload="change_sample_color()">
<% security.write_menu(Response, "admin"); %>


<div class=align><table border=0><tr><td>
<a href=priorities.aspx>back to priorities</a>
<form class=frm runat="server">
	<table border=0>

	<tr>
	<td class=lbl>Description:</td>
	<td><input runat="server" type=text class=txt id="name" maxlength=20 size=20></td>
	<td runat="server" class=err id="name_err">&nbsp;</td>
	</tr>

	<tr>
	<td colspan=3>
	<span class=smallnote>Sort Sequence controls the sort order in the dropdowns.</span>
	</td>
	</tr>

	<tr>
	<td class=lbl>Sort Sequence:</td>
	<td><input runat="server" type=text class=txt id="sort_seq" maxlength=2 size=2></td>
	<td runat="server" class=err id="sort_seq_err">&nbsp;</td>
	</tr>

	<tr>
	<td colspan=3>
	<span class=smallnote>Background Color and CSS Class can be used to control the look of lists.<br>See the example queries.</span>
	</td>
	</tr>

	<tr>
	<td class=lbl>Background Color:</td>
	<td><input onkeyup="change_sample_color()" runat="server" type=text class=txt id="color" value="#ffffff" maxlength=7 size=7>
	&nbsp;&nbsp;&nbsp;&nbsp;<span style="padding: 3px;" id="sample">&nbsp;&nbsp;Sample&nbsp;&nbsp;</span></td>
	<td runat="server" class=err id="color_err">&nbsp;</td>
	</tr>

	<tr>
	<td class=lbl>CSS Class:</td>
	<td><input runat="server" type=text class=txt id="style" value="" maxlength=10 size=10></td>
	<td runat="server" class=err id="style_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="Create or Edit" OnServerClick="on_update">
	<td>&nbsp</td>
	</td>
	</tr>
	</td></tr></table>
</form>
</td></tr></table></div>
</body>
</html>

edit_priority.aspx - 源码说明

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

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

⌨️ 快捷键说明

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