private void ValideColonneEnCours() { CParametreLectureExcel.CColonneExcel col = m_parametre.GetColonne(m_nColSel); if (m_cmbType.SelectedValue != null) { col.DataType = (Type)m_cmbType.SelectedValue; } //Nom Colonne string strNom = m_txtNomColonne.Text.Trim() != "" ? m_txtNomColonne.Text.Trim() : GetNomColonneDefaut(m_nColSel); if (!m_parametre.ValideNomPourColonne(m_nColSel, strNom)) { CFormAlerte.Afficher(I.T("This name already exists|125"), EFormAlerteType.Exclamation); } else { col.Nom = strNom; } //Null Colonne col.HasNullMapping = m_chkMapperNull.Checked; if (m_chkMapperNull.Checked) { col.NullMapping = m_txtNullValue.Text; col.NullCaseSensitive = m_chkNullCaseSensitive.Checked; } //Set Colonne m_parametre.SetColonne(m_nColSel, col); m_wndListeExemple.Columns[m_nColSel].Text = col.Nom; }
private void SelectColonne(int nCol) { if (m_bInitialise) { ValideColonneEnCours(); } m_nColSel = nCol; CParametreLectureExcel.CColonneExcel col = m_parametre.GetColonne(nCol); m_grpColonne.Text = I.T("Column n°@1|126", (nCol + 1).ToString()); m_txtNomColonne.Text = col.Nom; if (col.DataType == null) { m_cmbType.SelectedValue = typeof(string); } else { m_cmbType.SelectedValue = col.DataType; } m_chkMapperNull.Checked = col.HasNullMapping; if (col.HasNullMapping) { m_txtNullValue.Text = col.NullMapping; m_chkNullCaseSensitive.Checked = col.NullCaseSensitive; } else { m_txtNullValue.Text = ""; m_chkNullCaseSensitive.Checked = false; } m_panNull.Visible = m_chkMapperNull.Checked; }
public static DialogResult FillOptions(CParametreLectureExcel parametre, string strFichierExemple) { CFormOptionsImportExcel2 form = new CFormOptionsImportExcel2(); form.m_parametre = parametre; string strTexteExemple = ""; if (strFichierExemple != "") { CLecteurFichierExcel reader = null; try { reader = new CLecteurFichierExcel(strFichierExemple, parametre.SheetName, parametre.PlageDonnees); form.m_tableExemple = reader.GetTable(parametre.NomChampsSurPremiereLigne); form.m_nomsCol = new Dictionary <int, string>(); //CREATION DU LISTVIEW form.m_wndListeExemple.Columns.Clear(); foreach (DataColumn col in form.m_tableExemple.Columns) { ColumnHeader header = new ColumnHeader(); header.Text = col.ColumnName; form.m_wndListeExemple.Columns.Add(header); } int nMaxRowsApercu = Math.Min(100, form.m_tableExemple.Rows.Count); // Limite l'affichage du liste view à 100 lignes for (int i = 0; i < nMaxRowsApercu; i++) { DataRow row = form.m_tableExemple.Rows[i]; ListViewItem item = new ListViewItem(row[0].ToString()); for (int n = 1; n < form.m_tableExemple.Columns.Count; n++) { item.SubItems.Add(row[n].ToString()); } form.m_wndListeExemple.Items.Add(item); } //CREATION DES COLONNES EXCEL DANS FICHIER PARAMETRAGE for (int nCol = 0; nCol < form.m_tableExemple.Columns.Count; nCol++) { CParametreLectureExcel.CColonneExcel col = form.m_parametre.GetColonne(nCol); if (col == null || col.Nom != form.m_tableExemple.Columns[nCol].ColumnName) { col = new CParametreLectureExcel.CColonneExcel(); col.Nom = form.m_tableExemple.Columns[nCol].ColumnName; col.DataType = typeof(string); form.m_parametre.SetColonne(nCol, col); } } reader.Close(); form.m_strTexteExemple = strTexteExemple; DialogResult result = form.ShowDialog(); form.Dispose(); return(result); } catch { } finally { try { reader.Close(); } catch { } } } return(DialogResult.Abort); }