private void GetTableInfo(DataTable dt)

         {

             listBh = new List<BH_DICTInfo>();

             foreach (DataRow dr in dt.Rows)

             {

                 BH_DICTInfo model = new BH_DICTInfo();

                 model.DictId = dr["DICT_ID"].ToString();

                 model.DictName = dr["DICT_NAME"].ToString();

                 model.DictType = dr["DICT_TYPE"].ToString();

                 model.Enable = Convert.ToDecimal(dr["ENABLE"].ToString());

                 model.Orders = Convert.ToDecimal(dr["ORDERS"].ToString());

                 model.Remark = dr["REMARK"].ToString();

                 listBh.Add(model);

             }

             dgvBh.DataSource = listBh;

             //清除上次数据源

             this.dgvBh.Columns.Clear();

             //属性时是否自动创建列

             dgvBh.AutoGenerateColumns = false;

             DisplayCol(dgvBh, "DictId", "字典编号");

             DisplayCol(dgvBh, "DictName", "字典名称");

             DisplayCol(dgvBh, "DictType", "字典类型");

             DisplayCol(dgvBh, "Orders", "字典名称");

             DisplayCol(dgvBh, "Enable", "是否可用");

             DisplayCol(dgvBh, "Remark", "备注");

             DisplayCol(dgvBh, "Checkbox", "删除");

             //this.dgvBh.DataMember = "DictName,DictType,Orders,Enable,Remark";

             this.dgvBh.Columns[].Visible = false;

         }

         /// <summary>

         /// 添加列表头

         /// </summary>

         /// <param name="dgv"></param>

         /// <param name="dataPropertyName"></param>

         /// <param name="headerText"></param>

         void DisplayCol(DataGridView dgv, string dataPropertyName, string headerText)

         {

             //dgv.Columns[dataPropertyName].Width = 100;

             if (dataPropertyName == "Checkbox")

             {

                 DataGridViewCheckBoxColumn ck = new DataGridViewCheckBoxColumn();

                 ck.DataPropertyName = dataPropertyName;

                 ck.HeaderText = headerText;

                 ck.Name = dataPropertyName;

                 dgv.Columns.AddRange(new DataGridViewColumn[] { ck });

             }

             else

             {

                 DataGridViewTextBoxColumn obj = new DataGridViewTextBoxColumn();

                 obj.DataPropertyName = dataPropertyName;

                 obj.HeaderText = headerText;

                 obj.Name = dataPropertyName;

                 obj.Resizable = DataGridViewTriState.True;

                 obj.ReadOnly = true;

                 dgv.Columns.AddRange(new DataGridViewColumn[] { obj });

             }

         }

 #region 修改事件

        /// <summary>

        /// 修改事件

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void btnBh_update_Click(object sender, EventArgs e)

        {

            model = new BH_DICTInfo();

            foreach (DataGridViewRow row in this.dgvBh.SelectedRows)

            {

                model.DictId = row.Cells["DictId"].Value.ToString();

                model.DictName = row.Cells["DictName"].Value.ToString();

                model.DictType = row.Cells["DictType"].Value.ToString();

                model.Enable = Convert.ToDecimal(row.Cells["Enable"].Value.ToString());

                model.Orders = Convert.ToDecimal(row.Cells["Orders"].Value.ToString());

                model.Remark = row.Cells["Remark"].Value.ToString();

            }

            if (model == null)

                MessageBox.Show("请选择");

            BhDictAddEdit SysEdit = new BhDictAddEdit("业务字典编辑信息", "保存编辑", model);

            SysEdit.ShowDialog();

            BindDataBh();

        }

        #endregion

   #region 删除事件

         /// <summary>

         ///删除事件

         /// </summary>

         /// <param name="sender"></param>

         /// <param name="e"></param>

         private void btnBh_delete_Click(object sender, EventArgs e)

         {

             //动态添加链接对象语句

             StringBuilder sqlStr = new StringBuilder();

             for (int i = ; i < dgvBh.Rows.Count; i++)

             {

                 object cbh = this.dgvBh.Rows[i].Cells["Checkbox"].Value;

                 if (cbh != null)

                 {

                     sqlStr.Append("DICT_ID=");

                     sqlStr.Append("\'");

                     sqlStr.Append(this.dgvBh.Rows[i].Cells["DictId"].Value.ToString());

                     sqlStr.Append("\'");

                     sqlStr.Append(" or ");

                 }

             }

             if (sqlStr.ToString() != "")

             {

                 string sq = sqlStr.ToString().Substring(, sqlStr.ToString().TrimEnd().LastIndexOf("or"));

                 if (DevExpress.XtraEditors.XtraMessageBox.Show("您确定要删除吗？", "系统提示") == System.Windows.Forms.DialogResult.OK)

                // if (MessageBox.Show("您确定要删除吗？", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == System.Windows.Forms.DialogResult.Yes)

                 {

                     string sql = "delete from bh_dict where " + sq + "";

                     ParameterSetConfig.GetDataDal();

                     ParameterSetConfig.OpenDB();

                     DataTable dt = ParameterSetConfig._dataDal.ExecuteSqlReturnTable(sql);

                     ParameterSetConfig.closeDB();

                     BindDataBh();

                 }

             }

             else

             {

                 MessageBox.Show("请选择要删除的行");

             }

         }