DataList 的 ItemCommand事件

 private void DataList1_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
  {
    System.Web.UI.WebControls.Label Label1;
   foreach(DataListItem oDataListItem in DataList1.Items)
   {
     Label1=(Label)oDataListItem.FindControl("IDshow");
    int id=(int)Label1.TabIndex;
    if (e.CommandName=="up")
    {
      int Board_FatherID;
     string sql1="Select Board_FatherID From Dxbbs_Board where ID='"+id+"'";
     SQLBASE obj=new SQLBASE();
     Board_FatherID=int.Parse(obj.ExecuteScalar(sql1).ToString());
     string sql2="Select ID From Dxbbs_Board where Board_FatherID='"+Board_FatherID+"' and ID<'"+id+"' order by ID DESC";
     bool bool1;
     // SqlDataReader myread=SQLBASE.ExecuteReader
     bool1=SQLBASE.IfRead(sql2);
     if (bool1==true)
     {
       SqlDataReader myread=SQLBASE.ExecuteReader(sql2);
      int ID3=(int)myread.GetValue(0);
      string sql3="Update Dxbbs_Board Set Board_Order='"+ID3+"' Where ID='"+ id +"'";
      string sql4="Update Dxbbs_Board Set Board_Order='"+id+"' Where ID='"+ ID3 +"'";
      obj.ExecuteNonQuery(sql3);
      obj.ExecuteNonQuery(sql4);
      myread.Close();
      databind();
     }
     else
     {Response.Write ("<script>alert(/"已经是最顶了！/");</script>");   }
    }
    else if (e.CommandName=="down")
    { 
     int Board_FatherID;
     string sql1="Select Board_FatherID From Dxbbs_Board where ID='"+id+"'";
     SQLBASE obj=new SQLBASE();
     Board_FatherID=int.Parse(obj.ExecuteScalar(sql1).ToString());
     string sql2="Select ID From Dxbbs_Board where Board_FatherID='"+Board_FatherID+"' and ID>'"+id+"' order by ID";
     bool bool1;
     bool1=SQLBASE.IfRead(sql2);
     if (bool1==true)
     {
      SqlDataReader myread=SQLBASE.ExecuteReader(sql2);
      int ID3=(int)myread.GetValue(0);
      string sql3="Update Dxbbs_Board Set Board_Order='"+ID3+"' Where ID='"+ id +"'";
      string sql4="Update Dxbbs_Board Set Board_Order='"+id+"' Where ID='"+ ID3 +"'";
      obj.ExecuteNonQuery(sql3);
      obj.ExecuteNonQuery(sql4);    
      databind();
      myread.Close();
     }
     else
     {Response.Write ("<script>alert(/"已经是最底了！/");</script>");   }

    }
     
    else if (e.CommandName=="delete")
    {
      System.Web.UI.WebControls.LinkButton mylinkbutton;
     mylinkbutton=(LinkButton)oDataListItem.FindControl("LinkButton4");
     mylinkbutton.Attributes.Add("onclic","return confirm('您真的要删除此行吗');");
     string sql="Delete from Dxbbs_Board where ID='"+id +"'";
     SQLBASE obj=new SQLBASE();
     obj.ExecuteNonQuery(sql);
     databind();
    }
    
   }
  }