winform: 设置下拉框数据源的公共函数

        //  设置下拉框   传入参数(需要设置的下拉框控件，查询的语句，默认第一行的内容)
        public static void SetComboList(DevExpress.XtraEditors.ComboBoxEdit ComboList, string QuerySQL, ArrayList arrSource = null, DataTable dtSource = null, string FirstRowText = "", bool bSelectFirstItem = false, bool bEditable = false)
        {
            DataTable dtList = null;
            if (dtSource != null)
            {
                dtList = dtSource;
            }
            else if (arrSource != null)
            {
                dtList = new DataTable();
                dtList.Columns.Add("name");
                foreach (string s in arrSource)
                {
                    dtList.Rows.Add(s);
                }
            }
            else if (!string.IsNullOrEmpty(QuerySQL))
            {
                try
                {
                    dtList = SqlHelper.ExecuteDataTable(SqlHelper.ConnString, CommandType.Text, QuerySQL, null);
                }
                catch (Exception ex)
                {
                    Common.DisplayMsg("数据访问异常:", ex.Message.ToString());
                    return;
                }
            }
            else { return; }

            int intCount = (dtList != null) ? dtList.Rows.Count : 0;
            if (bEditable)
            {
                ComboList.Properties.TextEditStyle = TextEditStyles.Standard;
            }
            else
            {
                ComboList.Properties.TextEditStyle = TextEditStyles.DisableTextEditor; // 设置 comboBox的文本值不能被编辑
            }
            ComboList.Properties.Items.Clear();
            if (!string.IsNullOrEmpty(FirstRowText)) ComboList.Properties.Items.Add(FirstRowText);

            if (intCount > 0)
            {
                for (int i = 0; i < intCount; i++)
                {
                    ComboList.Properties.Items.Add(dtList.Rows[i][0].ToString());
                }
            }
            if (bSelectFirstItem) ComboList.SelectedIndex = 0; // 设置选中第1项
        }