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
}
}
