嵌套

来源：互联网发布：在太空看不到长城知乎编辑：程序博客网时间：2024/04/29 22:10

.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="addRole.aspx.cs" Inherits="addRole" Debug="true" %>
<%@ IMPORT Namespace="System.Data" %>
<%@Register TagPrefix="uc1" TagName="leftmenu" Src="WebUserControl.ascx" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>权限管理</title>
    <style>
      table{font-size:12px;}
      b{font-size:14px;}
      button{font-size:12px;}
    </style>
    <script>

    </script>
</head>
<body>
    <form id="form1" runat="server">
        <UC1:LEFTMENU ID="leftmenu" runat="server" />
        <table>
           <tr>
                <td>
                     新角色名称
                </td>
                <td>
                    <ASP:TEXTBOX ID="RoleName" runat="server"></ASP:TEXTBOX>
                </td>
            </tr>

        </table>
        <ASP:REPEATER ID="RoleRP" runat="server">
        <HEADERTEMPLATE>
        <table>
        </HEADERTEMPLATE>
        <ITEMTEMPLATE>
            <tr>
                <td>
                     <%# Eval("moduleName")%>
                </td>
                <td>

                    <asp:DataList id="child" runat="server" RepeatColumns="2" RepeatDirection="Horizontal" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("myrelation") %>' CellPadding="16" CellSpacing="0" Width="300px" BorderWidth="1" BorderColor="Silver" RepeatLayout="table" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" AlternatingItemStyle-BackColor="Gainsboro">
                          <ItemTemplate>
                            <ASP:CHECKBOX ID="CheckBox1" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "[/"FuncName/"]")%>' />
                          </ItemTemplate>
                    </asp:DataList>
               </td>
            </tr>
        </ITEMTEMPLATE>
        <FOOTERTEMPLATE>
            </table>
        </FOOTERTEMPLATE>

        </ASP:REPEATER>
<table>
    <tr>
    <td align="right">
        角色说明：
    </td>
    <td>
        <ASP:TEXTBOX ID="RoleDesc" runat="server" TextMode="MultiLine" Columns="20" Rows="5" ></ASP:TEXTBOX>
    </td>
    </tr>
</table>
        <div align="center">
            <ASP:BUTTON ID="Button1" runat="server" Text="添加" Width="150" OnClick="Button1_Click" /></div>
    </form>
</body>
</html>
.cs

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using zhouzhou;

public partial class addRole : System.Web.UI.Page
{
    Config conn = new Config();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string queryStr = "SELECT * FROM [TModule] Order by innerId";

            //string queryStr = "select * from orders order by OrderID";
            //SqlCommand cmd = new SqlCommand(queryStr, conn);
            SqlDataAdapter sda = new SqlDataAdapter(queryStr, conn.myConnection);
            //sda.SelectCommand = cmd;
            DataSet ds = new DataSet();
            sda.Fill(ds, "Module");
            SqlDataAdapter sda1 = new SqlDataAdapter("SELECT * FROM [TFunction] Order by innerId", conn.myConnection);
            sda1.Fill(ds, "Func");
            ds.Relations.Add("myrelation", ds.Tables["Module"].Columns["ModuleNo"], ds.Tables["Func"].Columns["ModuleNo"]);
            RoleRP.DataSource = ds.Tables["Module"];
            Page.DataBind();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        DataList finddatalist = new DataList();
        CheckBox findchk = new CheckBox();
        makeRole makerole = new makeRole ();
        string result="";
        string insertStr = "";
        for (int i = 0; i < this.RoleRP.Items.Count; i++)
        {
            finddatalist = (System.Web.UI.WebControls.DataList)this.RoleRP.Items[i].FindControl("child");

            for (int j = 0; j < finddatalist.Items.Count; j++)
            {
                    findchk = (System.Web.UI.WebControls.CheckBox)finddatalist.Items[j].FindControl("CheckBox1");
                    makerole.FuncName = findchk.Text;
                   if (findchk.Checked)
                    {
                        makerole.makeRoleValue(1,conn);
                    }
                    else
                    {
                        makerole.makeRoleValue(2, conn);
                    }
            }
        }
        insertStr = "Insert TRoleInfo(RoleName,RoleValue,RoleDesc) Values(@RoleName,@RoleValue,@RoleDesc)";
        Parameters pstring = new Parameters();
        //Response.Write(RoleName.Text);
        //Response.Write("<br>");
        //Response.Write(makerole.RoleValue);
        //Response.Write("<br>");
        //Response.Write(RoleDesc.Text);
        //Response.Write("<br>");
        //Response.End();
        pstring.Add("@RoleName", Request.Form["RoleName"]);
        pstring.Add("@RoleValue", makerole.RoleValue);
        pstring.Add("@RoleDesc", Request.Form["RoleDesc"]);
        conn.ExecuteSql(insertStr, pstring);
        Response.Redirect("viewRole.aspx");
    }
}