📄 edit_user.aspx
字号:
us_bugs_per_page = N'$bp',
us_email = N'$em',
us_active = $ac,
us_admin = $ad,
us_enable_notifications = $en,
us_only_new_bug_notifications = $on,
us_send_notifications_to_self = $ss,
us_only_status_change_notifications = $os,
us_auto_subscribe = $as,
us_auto_subscribe_own_bugs = $ao,
us_auto_subscribe_reported_bugs = $ar,
us_default_query = $dq
where us_id = $id";
sql = sql.Replace("$pw", password_to_store);
}
else
{
sql = @"update users set
us_username = N'$un',
us_firstname = N'$fn',
us_lastname = N'$ln',
us_bugs_per_page = N'$bp',
us_email = N'$em',
us_active = $ac,
us_admin = $ad,
us_enable_notifications = $en,
us_only_new_bug_notifications = $on,
us_send_notifications_to_self = $ss,
us_only_status_change_notifications = $os,
us_auto_subscribe = $as,
us_auto_subscribe_own_bugs = $ao,
us_auto_subscribe_reported_bugs = $ar,
us_default_query = $dq
where us_id = $id";
}
sql = sql.Replace("$un", username.Value.Replace("'","''"));
sql = sql.Replace("$fn", firstname.Value.Replace("'","''"));
sql = sql.Replace("$ln", lastname.Value.Replace("'","''"));
sql = sql.Replace("$bp", bugs_per_page.Value.Replace("'","''"));
sql = sql.Replace("$em", email.Value.Replace("'","''"));
sql = sql.Replace("$ac", Util.bool_to_string(active.Checked));
sql = sql.Replace("$ad", Util.bool_to_string(admin.Checked));
sql = sql.Replace("$en", Util.bool_to_string(enable_notifications.Checked));
sql = sql.Replace("$on", Util.bool_to_string(only_new_bug_notifications.Checked));
sql = sql.Replace("$ss", Util.bool_to_string(send_to_self.Checked));
sql = sql.Replace("$os", Util.bool_to_string(only_status_changes.Checked));
sql = sql.Replace("$as", Util.bool_to_string(auto_subscribe.Checked));
sql = sql.Replace("$ao", Util.bool_to_string(auto_subscribe_own.Checked));
sql = sql.Replace("$ar", Util.bool_to_string(auto_subscribe_reported.Checked));
sql = sql.Replace("$dq", query.SelectedItem.Value);
sql = sql.Replace("$id", Convert.ToString(id));
dbutil.execute_nonquery(sql);
// Now update project_user_xref
// First turn everything off, then turn selected ones on.
sql = @"update project_user_xref
set pu_auto_subscribe = 0 where pu_user = $id";
sql = sql.Replace("$id", Convert.ToString(id));
dbutil.execute_nonquery(sql);
// Second see what to turn back on
string projects = "";
foreach (ListItem li in project_auto_subscribe.Items)
{
if (li.Selected)
{
if (projects != "")
{
projects += ",";
}
projects += Convert.ToInt32(li.Value);
}
}
// If we need to turn anything back on
if (projects != "")
{
sql = @"update project_user_xref
set pu_auto_subscribe = 1 where pu_user = $id and pu_project in ($projects)
insert into project_user_xref (pu_project, pu_user, pu_auto_subscribe)
select pj_id, $id, 1
from projects
where pj_id in ($projects)
and pj_id not in (select pu_project from project_user_xref where pu_user = $id)";
sql = sql.Replace("$id", Convert.ToString(id));
sql = sql.Replace("$projects", projects);
dbutil.execute_nonquery(sql);
}
Server.Transfer ("users.aspx");
}
else
{
username_err.InnerText = "Username already exists. Choose another username.";
msg.InnerText = "User was not updated.";
}
}
}
else
{
if (id == 0) // insert new
{
msg.InnerText = "User was not created.";
}
else // edit existing
{
msg.InnerText = "User was not updated.";
}
}
}
</script>
<html>
<head>
<title id="title" runat="server">btnet edit user</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=users.aspx>back to users</a>
<% if (id != 0) { %>
<a id="permissions_href" runat="server" href="" style='font-weight: bold;'>per project permissions</a>
<% } %>
<form class=frm runat="server">
<table border=0 cellpadding=3>
<tr>
<td class=lbl>Username:</td>
<td><input runat="server" type=text class=txt id="username" maxlength=20 size=20></td>
<td runat="server" class=err id="username_err"> </td>
</tr>
<tr>
<td class=lbl>Password:</td>
<td><input runat="server" type=password class=txt id="pw" maxlength=20 size=20></td>
<td runat="server" class=err id="pw_err"> </td>
</tr>
<tr>
<td class=lbl>Confirm Password:</td>
<td><input runat="server" type=password class=txt id="confirm_pw" maxlength=20 size=20></td>
<td runat="server" class=err id="confirm_pw_err"> </td>
</tr>
<tr>
<td class=lbl>First Name:</td>
<td><input runat="server" type=text class=txt id="firstname" maxlength=20 size=20></td>
<td runat="server" class=err id="firstname_err"> </td>
</tr>
<tr>
<td class=lbl>Last Name:</td>
<td><input runat="server" type=text class=txt id="lastname" maxlength=20 size=20></td>
<td runat="server" class=err id="lastname_err"> </td>
</tr>
<tr>
<td class=lbl>Active:</td>
<td><asp:checkbox runat="server" class=txt id="active"/></td>
<td> </td>
</tr>
<tr>
<td class=lbl>Admin:</td>
<td><asp:checkbox runat="server" class=txt id="admin"/></td>
<td> </td>
</tr>
<tr>
<td class=lbl>Bugs Per Page:</td>
<td><input runat="server" type=text class=txt id="bugs_per_page" maxlength=3 size=3></td>
<td runat="server" class=err id="bugs_per_page_err"> </td>
</tr>
<tr>
<td colspan=3>
</td>
</tr>
<tr>
<td colspan=3>
<div class=smallnote style="width: 400px;">Default Bug Query is what you see when you click on the "bugs" link
</div>
</td>
</tr>
<tr>
<td class=lbl>Default Bug Query:</td>
<td>
<asp:DropDownList id="query" runat="server">
</asp:DropDownList>
</td>
<td> </td>
</tr>
<tr>
<td colspan=3>
</td>
</tr>
<tr>
<td colspan=3>
<span class=smallnote>
<br><br>
<div style="width: 400px;">
ADMIN - SEE "NotificationEmailEnabled", "NotificationEmailFrom", "SmtpServer" settings in Web.config.<br><br>
To receive email notifications when items are added or changed, fill in your email address, enable notifications, and then select "Auto-subscribe to all items" or the other options.<br>
<br>
</div>
</td>
</tr>
<tr>
<td class=lbl>Email:</td>
<td><input runat="server" type=text class=txt id="email" maxlength=40 size=40></td>
<td runat="server" class=err id="email_err"> </td>
</tr>
<tr>
<td class=lbl>Enable notifications:</td>
<td><asp:checkbox runat="server" class=txt id="enable_notifications"/></td>
<td> </td>
</tr>
<tr>
<td colspan=3>
<br>
<br>
<div class=smallnote style="width: 400px;">You can AUTOMATICALLY subscribe to receive notifications to items by selecting either "Auto-subscribe to all items" or by selecting the other options.<br>
</div>
</td>
</tr>
<tr>
<td class=lbl>Auto-subscribe to all items:</td>
<td><asp:checkbox runat="server" class=txt id="auto_subscribe"/></td>
<td> </td>
</tr>
<tr>
<td class=lbl nowrap>Auto-subscribe per project:</td>
<td>
<span class=smallnote>Hold down Ctrl key to select multiple items.</span>
<br>
<asp:ListBox id="project_auto_subscribe" runat="server" SelectionMode="Multiple" Rows=4>
</asp:ListBox >
</td>
<td> </td>
</tr>
<tr>
<td class=lbl>Auto-subscribe to all items ASSIGNED TO you:</td>
<td><asp:checkbox runat="server" class=txt id="auto_subscribe_own"/></td>
<td> </td>
</tr>
<tr>
<td class=lbl>Auto-subscribe to all items REPORTED BY you:</td>
<td><asp:checkbox runat="server" class=txt id="auto_subscribe_reported"/></td>
<td> </td>
</tr>
<tr>
<td colspan=3>
<br><br>
<div class=smallnote style="width: 400px;">You can REDUCE or INCREASE the amount of email you receive by selecting the following.<br>
</div>
</td>
</tr>
<tr>
<td class=lbl>New <% Response.Write(Util.get_setting("SingularBugLabel","Bug")); %> notifications only:</td>
<td><asp:checkbox runat="server" class=txt id="only_new_bug_notifications"/></td>
<td> </td>
</tr>
<tr>
<td class=lbl>Notify only when new or when status changes:</td>
<td><asp:checkbox runat="server" class=txt id="only_status_changes"/></td>
<td> </td>
</tr>
<tr>
<td class=lbl>Send notifications even for items you add or change:</td>
<td><asp:checkbox runat="server" class=txt id="send_to_self"/></td>
<td> </td>
</tr>
<tr>
<td colspan=3>
</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 or Edit" OnServerClick="on_update">
<td> </td>
</td>
</tr>
</table>
</form>
</td></tr></table></div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -