TreeView 排序

Table tab = new Table();
        TableRow row = new TableRow();
        TableCell cell = new TableCell();
        cell.Text = "栏目编号";
        row.Cells.Add(cell);
        cell = new TableCell();
        cell.Text = "栏目名称";
        row.Cells.Add(cell);
        cell = new TableCell();
        cell.Text = "排序";
        row.Cells.Add(cell);
        cell = new TableCell();
        cell.Text = " ";
        row.Cells.Add(cell);
        tab.Rows.Add(row);

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            row = new TableRow();
            cell = new TableCell();
            cell.Text = ds.Tables[0].Rows[i]["MenuID"].ToString();
            row.Cells.Add(cell);
            cell = new TableCell();
            cell.Text = ds.Tables[0].Rows[i]["MenuName"].ToString();
            row.Cells.Add(cell);

           
            
            cell = new TableCell();
            string MenuID=ds.Tables[0].Rows[i]["MenuID"].ToString();//当前记录ID
            string MenuOrder = ds.Tables[0].Rows[i]["MenuOrder"].ToString();//当前记录序号
            //向上
            Button btnup = new Button();
            btnup.Text = "up";
            btnup.Command += new CommandEventHandler(btnup_Command);
            btnup.CommandName = "up";
            string UpMenuOrder;
            string UpMenuID;
            if (i==0)
            {
                UpMenuID = MenuID;
                UpMenuOrder = MenuOrder;
            }
            else
            {
                UpMenuID = ds.Tables[0].Rows[i - 1]["MenuID"].ToString();
                UpMenuOrder = ds.Tables[0].Rows[i-1]["MenuOrder"].ToString();
            }
            btnup.CommandArgument = MenuID + ";" + UpMenuID + ";" + MenuOrder + ";" + UpMenuOrder;
            //向下
            Button btnDown = new Button();
            btnDown.Text = "Down";
            btnDown.Command += new CommandEventHandler(btnup_Command);
            btnDown.CommandName = "Down";
            string DownMenuOrder;//下面的记录序号
            string DownMenuID;//下面的记录ID
            if (i==ds.Tables[0].Rows.Count-1)
            {
                DownMenuOrder = MenuOrder;
                DownMenuID = MenuID;
            }
            else
            {
                DownMenuOrder = ds.Tables[0].Rows[i+1]["MenuOrder"].ToString();
                DownMenuID = ds.Tables[0].Rows[i+1]["MenuID"].ToString();
            }
            btnDown.CommandArgument = MenuID+";"+DownMenuID+";"+MenuOrder+";"+DownMenuOrder;
            cell.Controls.Add(btnup);
            cell.Controls.Add(btnDown);
            row.Cells.Add(cell);
            tab.Rows.Add(row);
        }
       this.Label2.Controls.Add(tab);
 void btnup_Command(object sender, CommandEventArgs e)
    {
        string sql = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
        if (e.CommandName=="up")
        {
            string[] str = e.CommandArgument.ToString().Split(';');
            string MenuID = str[0];
            string UpMenuID = str[1];
            string MenuOrder = str[2];
            string UpMenuOrder = str[3];
            using (SqlConnection conn=new SqlConnection (sql))
            {
                SqlCommand comm = conn.CreateCommand();
                comm.CommandText = "update MenuTree set MenuOrder='" + UpMenuOrder+"' where MenuID='"+MenuID+"'";
                conn.Open();
                comm.ExecuteNonQuery();
                comm.CommandText = "update MenuTree set MenuOrder='" + MenuOrder + "' where MenuID='" + UpMenuID+"'";
                comm.ExecuteNonQuery();
            }
            this.TreeView1.Nodes.Clear();
            bindTree();
        }

        if (e.CommandName == "Down")
        {
            string[] str = e.CommandArgument.ToString().Split(';');
            string MenuID = str[0];
            string DownMenuID = str[1];
            string MenuOrder = str[2];
            string DownMenuOrder = str[3];
            using (SqlConnection conn = new SqlConnection(sql))
            {
                SqlCommand comm = conn.CreateCommand();
                comm.CommandText = "update MenuTree set MenuOrder='" + DownMenuOrder + "' where MenuID='" + MenuID + "'";
                conn.Open();
                comm.ExecuteNonQuery();
                comm.CommandText = "update MenuTree set MenuOrder='" + MenuOrder + "' where MenuID='" + DownMenuID + "'";
                comm.ExecuteNonQuery();
            }
            this.TreeView1.Nodes.Clear();
            bindTree();
        }   
        Response.Redirect(Request.Url.ToString());
    }


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值