📄 add_customfield.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;
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);
msg.InnerText = "";
if (!IsPostBack)
{
datatype.Items.Insert(0, new ListItem("char", "char"));
datatype.Items.Insert(0, new ListItem("datetime", "datetime"));
datatype.Items.Insert(0, new ListItem("decimal", "decimal"));
datatype.Items.Insert(0, new ListItem("int", "int"));
datatype.Items.Insert(0, new ListItem("nchar", "nchar"));
datatype.Items.Insert(0, new ListItem("nvarchar", "nvarchar"));
datatype.Items.Insert(0, new ListItem("varchar", "varchar"));
}
}
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 = "Field name is required.";
}
else
{
name_err.InnerText = "";
}
if (length.Value == "")
{
if (datatype.SelectedItem.Value == "int"
|| datatype.SelectedItem.Value == "datetime")
{
length_err.InnerText = "";
}
else
{
good = false;
length_err.InnerText = "Length or Precision is required for this datatype.";
}
}
else
{
if (datatype.SelectedItem.Value == "int" || datatype.SelectedItem.Value == "datetime")
{
good = false;
length_err.InnerText = "Length or Precision not allowed for this datatype.";
}
else
{
length_err.InnerText = "";
}
}
default_err.InnerText = "";
if (required.Checked && default_text.Value == "")
{
if (default_text.Value == "")
{
good = false;
default_err.InnerText = "If \"Required\" is checked, then Default is required.";
}
}
return good;
}
///////////////////////////////////////////////////////////////////////
void on_update (Object sender, EventArgs e)
{
Boolean good = validate();
if (good)
{
sql = "alter table bugs add [$nm] $dt $ln $null $df";
sql = sql.Replace("$nm", name.Value);
sql = sql.Replace("$dt", datatype.SelectedItem.Value);
sql = sql.Replace("$ln", length.Value);
if (default_text.Value != "")
{
sql = sql.Replace("$df", "DEFAULT " + default_text.Value);
}
else
{
sql = sql.Replace("$df", "");
}
if (required.Checked)
{
sql = sql.Replace("$null", "NOT NULL");
}
else
{
sql = sql.Replace("$null", "NULL");
}
try
{
dbutil.execute_nonquery(sql);
Server.Transfer ("customfields.aspx");
}
catch (Exception e2)
{
msg.InnerHtml = "The generated SQL was invalid:<br><br>SQL: " + sql + "<br><br>Error: " + e2.Message;
}
}
else
{
msg.InnerText = "Custom field was not created.";
}
}
</script>
<html>
<head>
<title id="title" runat="server">btnet add custom field</title>
<link rel="StyleSheet" href="btnet.css" type="text/css">
</head>
<body>
<% security.write_menu(Response, "admin"); %>
<div class=align><table border=0><tr><td>
<a href=customfields.aspx>back to custom fields</a>
<form class=frm runat="server">
<table border=0 width=640>
<tr>
<td class=lbl>Field Name:</td>
<td><input runat="server" type=text class=txt id="name" maxlength=30 size=30></td>
<td runat="server" class=err id="name_err"> </td>
</tr>
<tr>
<td class=lbl>Datatype:</td>
<td>
<asp:DropDownList id="datatype" runat="server">
</asp:DropDownList>
</td>
<td> </td>
</tr>
<tr>
<td colspan=3>
<span class=smallnote>
<br><br>For char, varchar, etc, specify as (NNN). Don't forget the parenthesis.<br><br>
For decimal specify as (A,B) where A is the total number of digits and B is the number of those digits to the right of decimal point. Don't forget the parenthesis.<br><br>
</span>
</td>
</tr>
<tr>
<td class=lbl>Length/Precision:</td>
<td><input runat="server" type=text class=txt id="length" maxlength=6 size=6></td>
<td nowrap runat="server" class=err id="length_err"> </td>
</tr>
<tr>
<td colspan=3>
<span class=smallnote>
<br><br>If you specify required, you must supply a default. Don't forget the parenthesis.
</span>
</td>
</tr>
<tr>
<td class=lbl>Required (NULL or NOT NULL):</td>
<td><asp:checkbox runat="server" class=txt id="required"/></td>
<td> </td>
</tr>
<tr>
<td class=lbl>Default:</td>
<td><input runat="server" type=text class=txt id="default_text" maxlength=30 size=30></td>
<td nowrap runat="server" class=err id="default_err"> </td>
</tr>
<tr><td colspan=3 align=left>
<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" OnServerClick="on_update">
<td> </td>
</td>
</tr>
</td></tr></table>
</form>
</td></tr></table></div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -