1

        

/**/

/// <summary>

 2        /// 填充comboboxB超医师 geovindu@163.com 涂聚文

 3        ///2009-02-16

 4        /// </summary>

 5

        

private

 

void

 setDBPyhNameComboBox()

 6

        

{

 7

 8            this.combPhy.DataSource = null;

 9

10            DBConnectioin dbc = new DBConnectioin();

11            SqlConnection conn = new SqlConnection(DBConnectioin.conStr);

12            conn.Open();

13            //DbHelperSQL.setComboList(combPhy, "select PhyID,PhyName  from Physician", "Physician", "PhyName", "PhyID");

14            string sSQL = "select PhyID,PhyName  from Physician";

15            string sTable = "Physician";

16

17 

18            DataSet dsCourtesy = new DataSet();

19            SqlDataAdapter daCourtesy = new SqlDataAdapter();

20            DbHelperSQL.setCommand(dsCourtesy, daCourtesy, sSQL, sTable);

21            daCourtesy.Fill(dsCourtesy);

22            combPhy.DataSource = dsCourtesy.Tables[0].DefaultView;              

23            DataRow dr = dsCourtesy.Tables[0].NewRow();

24            combPhy.DisplayMember = "PhyName";

25            combPhy.ValueMember = "PhyID";            

26            dr["PhyName"] = "全部";  

27            dr["PhyID"] = -1;  

28            dsCourtesy.Tables[0].Rows.InsertAt(dr, 0);

29            //combPhy.Text = "全部";

30

31

32        }

ProductCatalogListBLL productCatalogListBLL = new ProductCatalogListBLL();        /// 
        ///         /// 
        ///         ///         protected void Page_Load(object sender, EventArgs e)        {            if (!IsPostBack)            {                BindClass();            }        }        /// 
        ///         /// 
        void BindClass()        {            List
     
       list = productCatalogListBLL.get_List();            foreach (ProductCatalogListInfo model in list)            {                ListItem li = new ListItem();                li.Text = "╋" + model.ProductCatalogName;                li.Value = model.ProductCatalogId.ToString();                DropDownList1.Items.Add(li);                BindChild(model.ProductCatalogId.ToString(), "├──");            }        }        /// 
      
        ///         /// 
        /// 
              /// 
              void BindChild(string ParentID, string separator)        {            List
      
        list = productCatalogListBLL.get_List(ParentID);            foreach (ProductCatalogListInfo model in list)            {                ListItem li = new ListItem();                li.Text = separator + model.ProductCatalogName;                li.Value = model.ProductCatalogId.ToString();                DropDownList1.Items.Add(li);                string separator_ = separator + "───";                BindChild(model.ProductCatalogId.ToString(), separator_);            }        }
      
     

　　

/// 
        ///         /// 
        /// 
             public List
     
       get_List()        {            List
      
        List = new List
       
        ();            DataTable dt = DBHelper.getDataSet("select * from ProductCatalogList where ProductCatalogParent=0 order by ProductCatalogId desc").Tables[0];            foreach (DataRow dr in dt.Rows)            {                ProductCatalogListInfo model = new ProductCatalogListInfo();                model.ProductCatalogId = Convert.ToInt32(dr["ProductCatalogId"]);                model.ProductCatalogName = dr["ProductCatalogName"].ToString();                model.ProductCatalogParent = Convert.ToInt32(dr["ProductCatalogParent"]);                List.Add(model);            }            return List;        }        /// 
        
        ///         /// 
        /// 
                /// 
                public List
        
          get_List(string ParentID)        {            List
         
           List = new List
          
           (); DataTable dt = DBHelper.getDataSet("select * from ProductCatalogList where ProductCatalogParent=" + ParentID + " order by ProductCatalogId desc").Tables[0]; foreach (DataRow dr in dt.Rows) { ProductCatalogListInfo model = new ProductCatalogListInfo(); model.ProductCatalogId = Convert.ToInt32(dr["ProductCatalogId"]); model.ProductCatalogName = dr["ProductCatalogName"].ToString(); model.ProductCatalogParent = Convert.ToInt32(dr["ProductCatalogParent"]); List.Add(model); } return List; }