public void HandleCommand(ReportCommand command, object[] args) { // open file dialogue var dialog = new OpenFileDialog { Title = COpenDialogFileFormTitle, DefaultExt = Cextension, Filter = COpenDialogFileExtensionFilter, InitialDirectory = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData), "AMEN CONSEIL\\Declaration\\Etats") }; if (dialog.ShowDialog() != DialogResult.OK) { return; } if (string.IsNullOrEmpty(dialog.FileName)) { return; } if (!File.Exists(dialog.FileName)) { return; } // initialize the report file (XtraReport) var xreport = XtraReport.FromFile(dialog.FileName, true); xreport.SourceUrl = dialog.FileName; var reportTypeName = xreport.Tag.ToString(); // load the report initializer (ITresorerieReport) // set report data properties var source = new DsVirement(); // set data adapter if the report is type of `ITresorerieReportView` xreport.DataSource = source; xreport.DataMember = "TEntete"; // open the report _xrDesigner.OpenReport(xreport); // set report designer properties [DataAdapter/Dataset] foreach (var comp in xreport.Container.Components.OfType <SqlDataAdapter>()) { xreport.Container.Remove(comp); } var pd = TypeDescriptor.GetProperties(xreport.DataSource)[NameProperty]; pd.SetValue(xreport.DataSource, ((DataSet)xreport.DataSource).DataSetName); foreach (var comp in xreport.Container.Components.OfType <SqlDataAdapter>()) { pd = TypeDescriptor.GetProperties(comp)[NameProperty]; pd.SetValue(comp, DataAdapterName); } }
public System.Data.DataSet GetDataSet(SocieteBanque banque, VirementEntete entete, List <VirementLigne> lignes) { if (entete == null) { throw new ArgumentNullException(nameof(entete)); } var dataSet = new DsVirement(); // ajout de la ligne societe var tableSociete = dataSet.TSociete; tableSociete.AddTSocieteRow( _societe.Id, int.Parse(_societe.MatriculFiscal), _societe.MatriculCle, _societe.MatriculCategorie, _societe.MatriculEtablissement, _exercice.Annee, _societe.RaisonSocial, _societe.Activite, _societe.Ville, _societe.Adresse, 0, int.Parse(_societe.CodePostal)); var tableEntete = dataSet.TEntete; var row = tableEntete.AddTEnteteRow(entete.Id, entete.DateEcheance, entete.DateCreation, entete.ReferenceEnvoi, entete.MotifOperation, entete.Total, entete.NombreTotal, entete.Rib, banque.Agence.ToUpper(), banque.Adresse ); foreach (var ligne in lignes) { var tableLigne = dataSet.TLignes; tableLigne.AddTLignesRow(ligne.Id, row, ligne.Nom, ligne.Prenom, ligne.Rib, ligne.NomBanque, ligne.NetAPaye ); } return(dataSet); }