using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Collections;
 
/// 
/// aboutJson 的摘要说明
/// 
public class AboutJson
{
 
    protected string connString;
    protected string sqlString;
    protected SqlConnection Conn;
    protected DataTable table;
    StringBuilder sb;
 
    protected string _tableName;                   //数据库名
    protected string _parentNodeName;              //表中父亲节点字段名
    protected string _treeIdName;                  //表中的ID字段的名称
    protected string _nodeName;                    //表中的节点字段的名称
    protected string _layerName;                   //表中层字段的名称
    protected int _startTid;
 
 
    public AboutJson()
    {
        this.connString = ConfigurationManager.ConnectionStrings[1].ConnectionString;
    }
 
    public AboutJson(string connString)
    {
        this.connString = connString;
    }
 
    public string tableName
    {
        set
        {
            _tableName = value.Trim();
        }
    }
 
    public string parentNodeName
    {
        set
        {
            _parentNodeName = value.Trim();
        }
    }
 
    public string treeIdName
    {
        set
        {
            _treeIdName = value.Trim();
        }
    }
 
    public string nodeName
    {
        set
        {
            _nodeName = value.Trim();
        }
    }
 
    public string layerName
    {
        set
        {
            _layerName = value.Trim();
        }
    }
 
    public DataTable sqlSelectToTable()
    {
        SqlConnection _conn = new SqlConnection(connString);
        _conn.Open();
        SqlCommand _comm = new SqlCommand(sqlString, _conn);
        DataSet _ds = new DataSet();
        SqlDataAdapter adapter = new SqlDataAdapter(_comm);
        adapter.Fill(_ds, "table1");
        table = _ds.Tables["table1"];
        _conn.Close();
        return table;
    }
 
 
    /// 
    /// 传回0层数据
    /// 
    /// 传送回jsonString
    public string buildTreeHeader()
    {
        sb = new StringBuilder("[");
        this.sqlString = "SELECT * FROM ["+_tableName+"] WHERE ["+_parentNodeName+"]=-1";
        DataTable dt = this.sqlSelectToTable();
        for (int i = 0; i < dt.Rows.Count; i++)
        {
           writeRowJson(dt.Rows[i]);
        }
        sb.Remove(sb.Length - 1, 1);
        if (sb.Length >= 1)
        {
            sb.Append("]");
        }
        return sb.ToString();
    }
 
 
    /// 
    /// 查找一个ID后面所有的数据，并以Ext读取的JSON树方式传回
    /// 
    /// 表示起始的ID
    /// 传送回jsonString
    public string buildTree(int startTid)       
    {
        string json;
        sb = new StringBuilder("[");
        _startTid = startTid;
        this.sqlString = "SELECT * FROM [" + _tableName + "] WHERE [" + _parentNodeName + "]!=-1";
        DataTable dt = this.sqlSelectToTable();
        for (int i = 0; i < dt.Rows.Count; i++)//
        {
            if ( int.Parse(dt.Rows[i][_parentNodeName].ToString()) == _startTid)
            {
                wrJson(dt.Rows[i]);
            }
        }
        sb.Remove(sb.Length - 1, 1);
        if (sb.Length >= 1)
        {
            sb.Append("]");
        }
        json = sb.ToString();
        json = json.Replace(",children:[]","");
        json = json.Replace(",]'","]");
        return json;
 
    }
 
 
 
    protected void writeRowJson(DataRow dr)
    {
        string _iNodeId = dr[_treeIdName].ToString();
        string _sNodeName = dr[_nodeName].ToString();
        sb.Append("{id:'" +_treeIdName+"_"+_iNodeId + "',text:'" + _sNodeName);
        sb.Append("'},");
    }
 
    protected void wrJson(DataRow dr)
    {
        string _iNodeId = dr[_treeIdName].ToString();
        string _sNodeName = dr[_nodeName].ToString();
        sb.Append("{id:'" + _treeIdName + "_" + _iNodeId + "',text:'" + _sNodeName);
        writeChild(int.Parse(_iNodeId));
        sb.Append("'},");
    }
 
    protected void writeChild(int parentId)
    {
 
        sb.Append(",children:[");
 
        for (int i = 0; i < table.Rows.Count; i++)
        {
            int iParNode = int.Parse(table.Rows[i][_parentNodeName].ToString());
            if (iParNode == parentId)
            {
                wrJson(table.Rows[i]); 
            }
        }
 
        sb.Append("]");
    }
}