完全拼接的分成两列的树形

最新推荐文章于 2024-11-13 15:29:17 发布

swswssw

最新推荐文章于 2024-11-13 15:29:17 发布

阅读量728

点赞数

分类专栏： C# Web 文章标签： dataset string webform javascript div table

本文链接：https://blog.csdn.net/swswssw/article/details/208798

版权

C# 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

Web

2 篇文章 0 订阅

订阅专栏

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OracleClient ;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace ldter
{
/// <summary>
/// WebForm4 的摘要说明。
/// </summary>
public class WebForm4 : System.Web.UI.Page
{
  DataSet ds;
  string str;
  OracleConnection con;
  string strTree="<center><table width='80%' cellspacing='0' cellpadding='0'><tr valign='top'><td width='50%' align='center'><table width='100%' cellspacing='0' cellpadding='0'>";
  Int32 c=0;
  bool havechild=false;
  public string strsort
  {
   get
   {
    return strTree+"</table></td></tr></table></center>";
   }
  }
  private void LocalDataSet()
  {
   OracleDataAdapter ad;
   OracleDataAdapter adpar;
   str="SELECT * FROM CODESORT ORDER BY CS_ID";
   ad=new OracleDataAdapter(str,con);
   adpar=new OracleDataAdapter("SELECT CS_PAR FROM CODESORT ORDER BY CS_ID",con);
   con.Open();
   ds=new DataSet();
   try
   {
    ad.Fill(ds,"maindoc");
    adpar.Fill(ds,"par");
    this.ViewState["ds"]=ds;
   }
   catch
   {
    throw;
   }
   finally
   {
    con.Close();

   }

}

  public void InitTree(string parent)
  {

   DataView dv=new DataView(ds.Tables["maindoc"]);
   DataView dvpar=new DataView(ds.Tables["par"]);
   dv.RowFilter="cs_par = '" + parent + "'";
   foreach(DataRowView row in dv)
   {
    string nbsp="";
    string div="";
    string td="";
    string checkbox="";
    if(parent=="000") c=c+1;
    for (Int32 i=1;i<=Int32.Parse(row["cs_clas"].ToString());i++) nbsp+="   ";
    if (parent!="000")
    {
      div="<tr valign='top'><td width='100%' height='100%'><div width='100%' height='100%' id='div"+ row["cs_code"].ToString()
      +"' style='display:none'><table width='100%' height='100%' cellspacing='0' cellpadding='0'><tr valign='top'><td width='100%'>";
    }
    else
    {
      div="<tr valign='top'><td width='100%' height='100%'><div width='100%' height='100%' id='div"+ row["cs_code"].ToString()
      +"' style='display:none'><table width='100%'   cellspacing='0' cellpadding='0'><tr valign='top'><td width='100%'>";
    }
    if(c==4)
    {
      td="</table></td><td width='50%' align='center'><table width='100%' cellspacing='0' cellpadding='0'><tr valign='top'><td width='80%' align='left'>";
    }
    else{if(havechild)td=""; else td="<tr valign='top' ><td width='80%' align='left' valign='top'>";}
    foreach(DataRowView rowpar in dvpar) //是否父节点
     if (row["cs_code"].ToString()==rowpar[0].ToString()){havechild=true;break;}else{havechild=false;}
    if(havechild||parent=="000"){checkbox="<img border='0' id='img"+row["cs_code"]+"' src='gif/plus.gif'>";}
    else{checkbox="<img border='0' id='img"+row["cs_code"]+"' src='gif/T.gif'>"+"<input id='" +row["cs_code"]+ "' type='checkbox' classname='" +row["cs_name"]+ "' onClick=javascript:subsel(this)>";}
    string newname="";
    if(row["cs_name"].ToString().Length.CompareTo(14)!=1){newname=row["cs_name"].ToString();}else{newname=row["cs_name"].ToString().Substring(0,10).ToString()+"...";}
    strTree+=td + nbsp + checkbox +"<a title='"+row["cs_name"]+"' href=javascript:expit('" + row["cs_code"].ToString() + "','"+ row["cs_clas"].ToString() +"')"
     +" cursor='hand' class='ainfo'>" + newname +"</a></td></tr>";
    if(havechild){strTree+=div;InitTree(row["cs_code"].ToString());strTree+="</td></tr></table></div></td></tr>";}
   }}
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   ds=(DataSet)this.ViewState["ds"];
   InitTree("000");
   DataBind();
  }

  #region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
   con=new OracleConnection("Data Source=ora9;User Id=system;Password=manager;Integrated Security=no");
   LocalDataSet();

  }

  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.Load += new System.EventHandler(this.Page_Load);
  }
  #endregion
}
}