SQL Server 2000层次数据查询的实现方法

复制public class ComLevelDataEntity      {          public ComLevelDataEntity()          {   searchLevel = 0;   startWithRoot = true;   dataObjectAlias = "t";          }          private int searchLevel;          /// <summary>        /// 查询层次          /// </summary>        public int SearchLevel          {              get { return searchLevel; }              set { searchLevel = value; }          }          private string dataObjectAlias;          /// <summary>        /// 别名          /// </summary>        public string DataObjectAlias          {              get { return dataObjectAlias; }              set { dataObjectAlias = value; }          }          private string protasis;          /// <summary>        /// 条件从句          /// </summary>        public string Protasis          {              get              {                  return string.IsNullOrEmpty(protasis) ?层次数 string.Empty : string.Concat(" and ", protasis);              }              set { protasis = value; }          }          private bool startWithRoot;          /// <summary>        /// 整树搜索          /// </summary>        public bool StartWithRoot          {              get { return startWithRoot; }              set { startWithRoot = value; }          }          private string dataObjectName;          /// <summary>        /// 数据对象名称          /// </summary>        public string DataObjectName          {              get { return dataObjectName; }              set { dataObjectName = value; }          }          private int cascadeLevel;          /// <summary>        /// 层级          /// </summary>        public int CascadeLevel          {              get { return cascadeLevel; }              set { cascadeLevel = value; }          }          private string displayFieldName;          /// <summary>        /// 显示字段名称          /// </summary>        public string DisplayFieldName          {              get { return displayFieldName; }              set { displayFieldName = value; }          }          private string keyFieldName;          /// <summary>        /// 键值字段名称          /// </summary>        public string KeyFieldName          {              get { return keyFieldName; }              set { keyFieldName = value; }          }          private string displayFieldValue;          /// <summary>        /// 显示字段值          /// </summary>        public string DisplayFieldValue          {              get { return displayFieldValue; }              set { displayFieldValue = value; }          }          private string keyFieldValue;          /// <summary>        /// 键值字段值          /// </summary>        public string KeyFieldValue          {              get { return keyFieldValue; }              set { keyFieldValue = value; }          }          private string levelFieldName;          /// <summary>        /// 层次字段名称          /// </summary>        public string LevelFieldName          {              get { return levelFieldName; }              set { levelFieldName = value; }          }          private string levelFieldValue;          /// <summary>        /// 层次字段值          /// </summary>        public string LevelFieldValue          {              get { return levelFieldValue; }              set { levelFieldValue = value; }          }      }  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.104.105.106.107.108.109.110.111.112.113.114.115.116.117.118.119.120.121.122.123.124.125.126.127.128.129.

本文地址：http://www.bzve.cn/html/363c8499552.html