C# winform combobox 在绑定数据之后插入一项选择项

 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();
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindClass();
            }
        }
        /// <summary>
        /// 
        /// </summary>
        void BindClass()
        {
            List<ProductCatalogListInfo> 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(), "├──");
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="ParentID"></param>
        /// <param name="separator"></param>
        void BindChild(string ParentID, string separator)
        {
            List<ProductCatalogListInfo> 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_);
            }
        }

  

 /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public List<ProductCatalogListInfo> get_List()
        {
            List<ProductCatalogListInfo> List = new List<ProductCatalogListInfo>();
            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;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="ParentID"></param>
        /// <returns></returns>
        public List<ProductCatalogListInfo> get_List(string ParentID)
        {
            List<ProductCatalogListInfo> List = new List<ProductCatalogListInfo>();
            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;
        }

  

posted @ 2009-02-16 10:40  ®Geovin Du Dream Park™  阅读(1189)  评论(1编辑  收藏  举报