private void m_lnkExporter_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
{
if (!(m_dataGrid.DataSource is DataSet))
{
CFormAlerte.Afficher(I.T("This function cannot be used with this data set|30036"), EFormAlerteType.Erreur);
return;
}
IExporteurDataset exporteur = null;
IDestinationExport destination = null;
if (CFormOptionsExport.EditeOptions(ref destination, ref exporteur))
{
if (exporteur != null)
{
CResultAErreur result = exporteur.Export((DataSet)m_dataGrid.DataSource, destination);
if (!result)
{
CFormAlerte.Afficher(result);
return;
}
else
{
CFormAlerte.Afficher(I.T("Export finished|30037"));
}
}
}
}
public CPanelOptionStructure(IExporteurDataset exporteur)
{
// Cet appel est requis par le Concepteur de formulaires Windows.Forms.
InitializeComponent();
m_exporteur = exporteur;
}
private void m_btnOK_Click(object sender, System.EventArgs e)
{
CResultAErreur result = CResultAErreur.True;
IDestinationExport destination = m_panelOptionsExport.DestinationExport;
if (destination == null || !destination.EstValidePourExport())
{
result.EmpileErreur(I.T("Export destination is not valid|227"));
CFormAlerte.Afficher(result);
return;
}
m_destinationExport = destination;
m_exporteur = Exporteur;
//C2iStructureExportInDB structure = (C2iStructureExportInDB)m_cmbStructures.SelectedValue;
m_multistructure = m_panelMultiStructure.MultiStructure;
if (m_multistructure == null)
{
result.EmpileErreur(I.T("Invalid structure|228"));
CFormAlerte.Afficher(result);
return;
}
m_multistructure.ContexteDonnee = CSc2iWin32DataClient.ContexteCourant;
CFormProgression.StartThreadWithProgress(I.T("Exporting data|229"), new System.Threading.ThreadStart(StartExport));
/*
*
* result = structure.GetDataSet ( false, m_listeObjets, null );
*
* //result = structure.Export(m_listeObjets.ContexteDonnee.IdSession, m_listeObjets, ref ds, null);
*
* if (!result)
* {
* CFormAlerte.Afficher(result);
* return;
* }
*
* DataSet ds = (DataSet)result.Data;
*
* CDestinationExportFile dest = new CDestinationExportFile(m_panelOptions.FileName);
*
* result = Exporteur.Export(ds, dest);
* if (!result)
* CFormAlerte.Afficher(result);
* else
* CFormAlerte.Afficher("Exportation des données réussie");
*
* ds.Dispose();*/
Close();
}
public static bool EditeOptions(ref IDestinationExport destination, ref IExporteurDataset exporteur)
{
CFormOptionsExport form = new CFormOptionsExport();
bool bOk = form.ShowDialog() == DialogResult.OK;
form.Exporteur = exporteur;
if (bOk)
{
//destination = new CDestinationExportFile(form.m_panelOptions.FileName);
destination = form.m_panelFormatExport.DestinationExport;
exporteur = form.Exporteur;
}
form.Dispose();
return(bOk);
}
private void m_lnkExport_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
IExporteurDataset exporteur = null;
IDestinationExport destination = null;
if (CFormOptionsExport.EditeOptions(ref destination, ref exporteur))
{
if (exporteur != null)
{
DataSet dsExport = new DataSet();
DataTable tableExport = new DataTable("EXPORT");
foreach (DataGridViewColumn colView in m_grid.Columns)
{
if (!tableExport.Columns.Contains(colView.HeaderText))
{
tableExport.Columns.Add(colView.HeaderText);
}
}
int rowIndex = 0;
foreach (DataGridViewRow rowView in m_grid.Rows)
{
tableExport.Rows.Add(tableExport.NewRow());
foreach (DataGridViewColumn colView in m_grid.Columns)
{
int colIndex = colView.Index;
tableExport.Rows[rowIndex][colIndex] = rowView.Cells[colIndex].Value;
}
rowIndex++;
}
dsExport.Tables.Add(tableExport);
CResultAErreur result = exporteur.Export(dsExport, destination);
if (!result)
{
CFormAlerte.Afficher(result);
return;
}
else
{
CFormAlerte.Afficher(I.T("Export completed|30037"));
}
}
}
}
private void UpdatePanelOptions()
{
Control oldPanel = m_panelOptions;
IExporteurDataset exporteur = null;
if (m_panelOptions != null)
{
exporteur = m_panelOptions.Exporteur;
}
if (m_rbtnXML.Checked && !(m_panelOptions is CPanelOptionStructure))
{
m_panelOptions = new CPanelOptionStructure(!(exporteur is CExporteurDatasetXML)?new CExporteurDatasetXML():(CExporteurDatasetXML)exporteur);
}
else if (m_rbtnAccess.Checked && !(m_panelOptions is CPanelOptionStructureAccess))
{
m_panelOptions = new CPanelOptionStructureAccess(!(exporteur is CExporteurDatasetAccess)?new CExporteurDatasetAccess():(CExporteurDatasetAccess)exporteur);
}
else if (m_rbtnText.Checked && !(m_panelOptions is CPanelOptionStructureTexte))
{
m_panelOptions = new CPanelOptionStructureTexte(!(exporteur is CExporteurDatasetText)?new CExporteurDatasetText():(CExporteurDatasetText)exporteur);
}
if (m_rbtnExcel.Checked && !(m_panelOptions is CPanelOptionStructureExcel))
{
m_panelOptions = new CPanelOptionStructureExcel(!(exporteur is CExporteurDatasetExcelXml)?new CExporteurDatasetExcelXml():(CExporteurDatasetExcelXml)exporteur);
}
if (oldPanel != null)
{
oldPanel.Hide();
oldPanel = null;
}
m_panelOptions.Parent = m_panelContainerOption;
m_panelOptions.Dock = DockStyle.Fill;
m_panelOptions.SansFichier = m_bSansFichier;
m_panelOptions.Show();
sc2i.win32.common.CWin32Traducteur.Translate(this);
}
/// ////////////////////////////////////////////////////////
protected override CResultAErreur MySerialize(C2iSerializer serializer)
{
int nVersion = GetNumVersion();
CResultAErreur result = serializer.TraiteVersion(ref nVersion);
if (!result)
{
return(result);
}
result = base.MySerialize(serializer);
if (!result)
{
return(result);
}
I2iSerializable objet = m_structureExport;
result = serializer.TraiteObject(ref objet);
if (!result)
{
return(result);
}
m_structureExport = (CMultiStructureExport)objet;
objet = m_expressionCleGED;
result = serializer.TraiteObject(ref objet);
if (!result)
{
return(result);
}
m_expressionCleGED = (C2iExpression )objet;
objet = m_expressionDescriptifDocument;
result = serializer.TraiteObject(ref objet);
if (!result)
{
return(result);
}
m_expressionDescriptifDocument = (C2iExpression )objet;
objet = m_expressionLibelleDocument;
result = serializer.TraiteObject(ref objet);
if (!result)
{
return(result);
}
m_expressionLibelleDocument = (C2iExpression )objet;
int nNbCategories = m_listeIdsCategorieStockage.Count;
serializer.TraiteInt(ref nNbCategories);
switch (serializer.Mode)
{
case ModeSerialisation.Ecriture:
foreach (int nIdCat in m_listeIdsCategorieStockage)
{
int nTmp = nIdCat;
serializer.TraiteInt(ref nTmp);
}
break;
case ModeSerialisation.Lecture:
m_listeIdsCategorieStockage.Clear();
for (int nVal = 0; nVal < nNbCategories; nVal++)
{
int nTmp = 0;
serializer.TraiteInt(ref nTmp);
m_listeIdsCategorieStockage.Add(nTmp);
}
break;
}
objet = (I2iSerializable)m_exporteur;
result = serializer.TraiteObject(ref objet, new object[0]);
if (!result)
{
return(result);
}
m_exporteur = (IExporteurDataset)objet;
if (nVersion >= 1)
{
serializer.TraiteBool(ref m_bUtiliserFormule);
result = serializer.TraiteObject <C2iExpression>(ref m_expressionSelectedStructure);
if (!result)
{
return(result);
}
}
AssureVariableProcessDansStructure();
return(result);
}
