obout tree view 做 sub load功能的冬冬.很好玩哦.

最新推荐文章于 2020-10-02 18:25:00 发布

qi_gu

最新推荐文章于 2020-10-02 18:25:00 发布

阅读量1.1k

点赞数

分类专栏： c# 设计模式文章标签： tree string null html server import

本文链接：https://blog.csdn.net/qi_gu/article/details/234938

版权

c# 设计模式专栏收录该内容

7 篇文章 0 订阅

订阅专栏

<%@ Page Language="C#" ASPCOMPAT="TRUE" Debug="true" %>
<%@ Import Namespace="obout_ASPTreeView_2_NET" %>
<%@ Import Namespace="System.Data.SqlClient" %>

SqlConnection myConn = new SqlConnection("server=localhost;uid=sa;pwd=guqi123456;database=odgweb");
String CommStr="SELECT layerid, parentlayer, layername, expanded, icon,haschildren FROM maplayer ";
String OrdStr=" ORDER BY parentlayer, layerid ";

if (ParentID==null)
{
  CommStr=CommStr+" where parentlayer is null";
}else
{
  CommStr=CommStr+" where parentlayer="+"'"+ParentID+"'";

}

SqlCommand myComm = new SqlCommand(CommStr+OrdStr, myConn);
myConn.Open();
SqlDataReader myReader = myComm.ExecuteReader();
   while (myReader.Read())
   {
  if (myReader.IsDBNull(1))
  {
    ParentID = "root";//根节点用root表示.
    clickstr="οnclick=ob_t2c(this)";
    subload="/odg/layerview.aspx?ParentID="+myReader.GetString(0);
  }
  else
  {
    ParentID ="id"+myReader.GetString(1);
    if (myReader.GetBoolean(5))
    {
   clickstr="οnclick=ob_t2c(this)";
   subload="/odg/layerview.aspx?ParentID="+myReader.GetString(0);

    }
    else
    {
   clickstr="";
   subload=null;
    }
  }
  chkid="chk_"+myReader.GetString(0);
  chkname="chk_"+myReader.GetString(0);
  html = String.Format("<input type='checkbox' class='chk' id={0}' name={1} {2}>{3}",chkid,chkname,clickstr,myReader.GetString(2));
  oTree.Add("root", "id" + myReader.GetString(0), html, myReader.GetBoolean(3), null,subload);
   }
TreeView.Text = oTree.HTML();
myReader.Close();
myConn.Close();
}
</script>