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());
}