📄 user_group.aspx
字号:
<!-- #include virtual="/include/pagedirective.inc" -->
<!-- #include virtual="/include/imports.inc" -->
<!-- #include virtual="/include/common_function.inc" -->
<html>
<head>
<link REL="StyleSheet" HREF="/css/standard.css" >
<script language="C#" runat="server">
/*************************************************
* 模块: user_group.aspx
* 作者: miles
* 修改: 1/30/2001
* 目的: user_group table maintain
* 参数: none
* 数据: sel: user_group
* ins: user_group
* del: user_group
* upt: user_group
* 批注:
***************************************************/
SqlConnection myConnection;
protected void Page_Load(Object Src, EventArgs E) {
try{
myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
if (!IsPostBack)
BindGrid();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
public void Add_Click(Object sender, EventArgs E) {
try{
String insertCmd = "insert into user_group values (@user_group_id,@user_group_name,@menu_id)";
SqlCommand myCommand = new SqlCommand(insertCmd, myConnection);
myCommand.Parameters.Add(new SqlParameter("@user_group_id", SqlDbType.VarChar, 50));
myCommand.Parameters["@user_group_id"].Value = user_group_id.Value;
myCommand.Parameters.Add(new SqlParameter("@user_group_name", SqlDbType.VarChar, 50));
myCommand.Parameters["@user_group_name"].Value = user_group_name.Value;
myCommand.Parameters.Add(new SqlParameter("@menu_id", SqlDbType.VarChar, 50));
myCommand.Parameters["@menu_id"].Value = menu_id.Value;
myConnection.Open();
try {
myCommand.ExecuteNonQuery();
MessageSQLInsDone();
}
catch (System.Data.SqlClient.SqlException e) {
SQLErrorHandler(e);
}
myConnection.Close();
BindGrid();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs E) {
try{
String deleteCmd = "delete from user_group where user_group_id = @user_group_id";
SqlCommand myCommand = new SqlCommand(deleteCmd, myConnection);
myCommand.Parameters.Add(new SqlParameter("@user_group_id", SqlDbType.VarChar, 50));
myCommand.Parameters["@user_group_id"].Value =MyDataGrid.DataKeys[(int)E.Item.ItemIndex];
myConnection.Open();
try {
myCommand.ExecuteNonQuery();
MessageSQLDelDone();
}
catch (System.Data.SqlClient.SqlException e) {
SQLErrorHandler(e);
}
myConnection.Close();
BindGrid();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
public void MyDataGrid_Edit(Object sender, DataGridCommandEventArgs E){
try{
MyDataGrid.EditItemIndex = (int)E.Item.ItemIndex;
BindGrid();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
public void MyDataGrid_Cancel(Object sender, DataGridCommandEventArgs E){
try{
MyDataGrid.EditItemIndex = -1;
BindGrid();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs E) {
try{
if (Page.IsValid)
{
String updateCmd = "update user_group set user_group_name = @user_group_name,menu_id=@menu_id where user_group_id = @user_group_id";
SqlCommand myCommand = new SqlCommand(updateCmd, myConnection);
myCommand.Parameters.Add(new SqlParameter("@user_group_id", SqlDbType.VarChar, 50));
myCommand.Parameters["@user_group_id"].Value = MyDataGrid.DataKeys[(int)E.Item.ItemIndex];
myCommand.Parameters.Add(new SqlParameter("@user_group_name", SqlDbType.VarChar, 50));
myCommand.Parameters["@user_group_name"].Value = ((TextBox)E.Item.FindControl("edit_user_group_name")).Text;
myCommand.Parameters.Add(new SqlParameter("@menu_id", SqlDbType.VarChar, 50));
myCommand.Parameters["@menu_id"].Value = ((TextBox)E.Item.FindControl("edit_menu_id")).Text;
myConnection.Open();
try {
myCommand.ExecuteNonQuery();
MessageSQLUptDone();
MyDataGrid.EditItemIndex = -1;
}
catch (System.Data.SqlClient.SqlException e){
SQLErrorHandler(e);
}
myConnection.Close();
BindGrid();
}
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
public void BindGrid(){
try{
SqlDataAdapter myCommand = new SqlDataAdapter("select * from user_group ", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "user_group");
MyDataGrid.DataSource=ds.Tables["user_group"].DefaultView;
MyDataGrid.DataBind();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
</script>
</head>
<body style="font: 10pt verdana">
<!-- #include virtual="/include/header.inc" -->
<form runat="server">
<table width=100% cellspacing=0 cellpadding=0>
<tr>
<td align="center" class="CONTENTTITLE" width="100%" bgcolor="D3C9C7">
用户群组数据维护
</td>
</tr>
<tr>
<td>
<span id="Message" EnableViewState="false" class="MESSAGE" runat="server"/>
</td>
</tr>
<tr>
<td colspan="10" bgcolor="#aaaadd" style="font:10pt verdana">新增:</td>
</tr>
</table>
<table style="font: 8pt verdana">
<tr>
<TD VALIGN="top" ALIGN="left"><span class="REQUIREDFIELD">用户群组代码:</LABEL><BR><input type="text" id="user_group_id" value="000" runat="server"></TD>
<TD VALIGN="top" ALIGN="left"><span class="REQUIREDFIELD"><LABEL FOR=txtUserID>用户群组名称:<BR><input type="text" id="user_group_name" value="000" runat="server"></TD>
<TD VALIGN="top" ALIGN="left"><span class="REQUIREDFIELD"><LABEL FOR=txtUserID>功能选单代码:<BR><input type="text" id="menu_id" value="000" runat="server"></TD>
<TD VALIGN="top" ALIGN="left"><FONT FACE="Verdana,Helvetica,Arial" SIZE=1> <BR> <input type="submit" OnServerClick="Add_Click" value="新增" runat="server"></FONT></TD>
</tr>
<TR>
<TD > <asp:RequiredFieldValidator ControlToValidate="user_group_id" Display="Static" ErrorMessage="*:不可空白" runat=server/></TD>
<TD > <asp:RequiredFieldValidator ControlToValidate="user_group_name" Display="Static" ErrorMessage="*:不可空白" runat=server/></TD>
</TR>
</table>
<table style="font: 8pt verdana" width=100% >
<tr>
<td colspan="5" bgcolor="#aaaadd" style="font:10pt verdana">修改/删除:</td>
</tr>
</table>
<ASP:DataGrid id="MyDataGrid" runat="server"
BackColor="#F4FFF4"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="lightblue"
OnEditCommand="MyDataGrid_Edit"
OnCancelCommand="MyDataGrid_Cancel"
OnUpdateCommand="MyDataGrid_Update"
OnDeleteCommand="MyDataGrid_Delete"
DataKeyField="user_group_id"
AutoGenerateColumns="false"
>
<Columns>
<asp:EditCommandColumn EditText="修改" CancelText="取消" UpdateText="储存" ItemStyle-Wrap="false" ButtonType=" PushButton" />
<asp:ButtonColumn Text="删除" CommandName="Delete" ButtonType="PushButton" />
<asp:BoundColumn HeaderText="用户群组代码" SortExpression="user_group_id" ReadOnly="True" DataField="user_group_id" ItemStyle-Wrap="false"/>
<asp:TemplateColumn HeaderText="用户群组名称" SortExpression="user_group_name">
<ItemTemplate>
<asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "user_group_name") %>'/>
</ItemTemplate>
<EditItemTemplate>
<nobr>
<asp:TextBox runat="server" id="edit_user_group_name" Text='<%# DataBinder.Eval(Container.DataItem, "user_group_name") %>'/>
<asp:RequiredFieldValidator id="user_group_name_ReqVal"
ControlToValidate="edit_user_group_name"
Display="Dynamic"
Font-Name="Verdana" Font-Size="12"
runat=server>
*
</asp:RequiredFieldValidator>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="功能选单代码" >
<ItemTemplate>
<asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "menu_id") %>'/>
</ItemTemplate>
<EditItemTemplate>
<nobr>
<asp:TextBox runat="server" id="edit_menu_id" Text='<%# DataBinder.Eval(Container.DataItem, "menu_id") %>'/>
<asp:RequiredFieldValidator id="menu_id_ReqVal"
ControlToValidate="edit_menu_id"
Display="Dynamic"
Font-Name="Verdana" Font-Size="12"
runat=server>
*
</asp:RequiredFieldValidator>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
</ASP:DataGrid>
</form>
<p>
<!-- #include virtual="/include/footer.inc" -->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -