行业类别下拉框

  #region 绑定行业类别下拉列表
  /// <summary>
  /// 读取行业类别数据绑定至下拉列表
  /// </summary>
  private void BindCategory()
  {
   DataHelper dh=new DataHelper("YP");
   DataTable dt=dh.ExecuteDataSet("select * from YP_CoCategory where IsDel=0 and Category <> '未设置' order by indexs").Tables[0];
   treeCategory.DataSource=dt;
   schTreeCategory.DataSource=dt;

   treeCategory.DataTextField="Category";
   treeCategory.DataValueField="ID";
   treeCategory.DefaultParentValue="0";
   treeCategory.ParentValueField="ID";
   treeCategory.ParentKeyField="ParentID";

   schTreeCategory.DataTextField="Category";
   schTreeCategory.DataValueField="ID";
   schTreeCategory.DefaultParentValue="0";
   schTreeCategory.ParentValueField="ID";
   schTreeCategory.ParentKeyField="ParentID";

   treeCategory.DataBind();
   schTreeCategory.DataBind();
  }

  #endregion

  #region 获取当前行业的父级类别ID，用于保存完整类别路径
  /// <summary>
  /// 依据当前行业类别ID获取你级类别ID，用于返回完整类别ID字符串
  /// </summary>
  /// <param name="currentID">当前类别ID</param>
  /// <returns>完整类别ID字符串</returns>
  private string GetParentID(string currentID)
  {
   string strSql="select ParentID from YP_CoCategory where ID="+currentID;
   string parentID;
   DataHelper dh=new DataHelper("YP");
   parentID=dh.ExecuteScalar(strSql).ToString();
   categoryPath=categoryPath.Insert(0,parentID+",");
   if(parentID!="0")
    GetParentID(parentID);
   return categoryPath;
  }
  #endregion