• 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;
            }
    

      

  • 相关阅读:
    pytorch_基于cifar创建自己的数据集并训练
    Pytorch_3.8_多层感知机
    Pytorch_3.6_ SOFTMAX回归的从零实现
    Linux(debian)下的Python程序守护进程
    Ubuntu16.04安装OpenCV3.4.3
    Beaglebone black 安装docker
    电脑与虚拟机ping
    Beaglebone升级Python3.7过程
    多图上传预览
    放大镜代码
  • 原文地址:https://www.cnblogs.com/geovindu/p/1391300.html
Copyright © 2020-2023  润新知