private void btImport_Click(object sender, EventArgs e) { var model = new Model.F6301(new F6301()); var z = new ImportForms.F6301ImportForm(model); if (z.ShowDialog(this) == DialogResult.OK) { var f6301 = this.f6301BindingSource.Current as Model.F6301; if (f6301 == null) { return; } foreach (var currentF6301Ligne in model.Lignes) { if (currentF6301Ligne != null && !currentF6301Ligne.Calculable) { var l = f6301.Lignes.Single(x => x.CodeN == currentF6301Ligne.CodeN); l.ValeurN = currentF6301Ligne.ValeurN; l = f6301.Lignes.Single(x => x.CodeN1 == currentF6301Ligne.CodeN1); l.ValeurN1 = currentF6301Ligne.ValeurN1; } } this.f6301BindingSource.ResetCurrentItem(); } }
public XtraFrmF6301(LiasseController controller) { _controller = controller; InitializeComponent(); gridView1.CustomRowCellEdit += GridView1OnCustomRowCellEdit; _CurrentF6301 = controller.CurrentF6301(); DBf6301BindingSource.DataSource = _CurrentF6301; var Model = new Model.F6301(_CurrentF6301); this.f6301BindingSource.DataSource = new Model.F6301(_CurrentF6301); btEnregistrer.Click += BtEnregistrer_Click; btExporter.Click += BtExporter_Click; //this.gridView1.OptionsView.RowAutoHeight = true; //colLibelle.AppearanceCell.TextOptions.WordWrap=WordWrap.Wrap; saveFileDialog1.FileName = controller.GetXmlFileName(this.DBf6301BindingSource.Current); }
public F6301ImportForm(Model.F6301 currentF6301) { InitializeComponent(); CurrentF6301 = currentF6301; _fileName = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), Application.ProductName, $"ModelImport_{CurrentF6301.GetType().Name}.xml"); this.f6301BindingSource.DataSource = CurrentF6301; if (File.Exists(_fileName)) { try { this.excelDataSource1.LoadFromXml(XElement.Load(_fileName)); excelDataSource1.Fill(); var col1 = "Code Rubrique (Net)"; var col2 = "Code Rubrique (N-1)"; //var col1 = "Code Rubrique (Net)"; var col3 = "Net"; //var col1 = "Libelle"; // var col4 = "Brut"; // var col5 = "Prov / Amort"; var col4 = "Net N-1"; // this.CodeRubNetcomboBoxEdit.Properties.Items.Clear(); this.CodeRubNetcomboBoxEdit.Properties.Items.AddRange(excelDataSource1.Schema .Where(x => x.Type == typeof(string) && x.Selected).Select(x => x.Name).ToList()); this.CodeRubNetcomboBoxEdit.EditValue = excelDataSource1.Schema .Where(x => x.Type == typeof(string) && x.Selected).Select(x => x.Name) .FirstOrDefault(x => x.Trim() == col1); // this.CodeRubN_1comboBoxEdit.Properties.Items.Clear(); this.CodeRubN_1comboBoxEdit.Properties.Items.AddRange(excelDataSource1.Schema .Where(x => x.Type == typeof(string) && x.Selected).Select(x => x.Name).ToList()); this.CodeRubN_1comboBoxEdit.EditValue = excelDataSource1.Schema .Where(x => x.Type == typeof(string) && x.Selected).Select(x => x.Name) .FirstOrDefault(x => x.Trim() == col2); // this.ValNetcomboBoxEdit.Properties.Items.Clear(); this.ValNetcomboBoxEdit.Properties.Items.AddRange(excelDataSource1.Schema .Where(x => Core.Helpers.Helper.IsNumericType(x.Type) && x.Selected).Select(x => x.Name) .ToList()); this.ValNetcomboBoxEdit.EditValue = excelDataSource1.Schema .Where(x => Core.Helpers.Helper.IsNumericType(x.Type) && x.Selected).Select(x => x.Name) .FirstOrDefault(x => x.Trim() == col3); // this.ValN_1comboBoxEdit.Properties.Items.Clear(); this.ValN_1comboBoxEdit.Properties.Items.AddRange(excelDataSource1.Schema .Where(x => Core.Helpers.Helper.IsNumericType(x.Type) && x.Selected).Select(x => x.Name) .ToList()); this.ValN_1comboBoxEdit.EditValue = excelDataSource1.Schema .Where(x => Core.Helpers.Helper.IsNumericType(x.Type) && x.Selected).Select(x => x.Name) .FirstOrDefault(x => x.Trim() == col4); } catch { // ignored } } this.buttonEdit1.EditValue = excelDataSource1.FileName; layoutControlGroup3.Visibility = LayoutVisibility.Never; }