private void btImport_Click(object sender, EventArgs e) { var model = new Model.F6003(new F6003()); var z = new ImportForms.F6003ImportForm(model); if (z.ShowDialog(this) == DialogResult.OK) { var f6003 = this.F6003BindingSource.Current as Model.F6003; if (f6003 == null) { return; } foreach (var currentF6003Ligne in model.Lignes) { if (currentF6003Ligne != null && !currentF6003Ligne.Calculable) { var l = f6003.Lignes.Single(x => x.CodeN == currentF6003Ligne.CodeN); l.ValeurN = currentF6003Ligne.ValeurN; l = f6003.Lignes.Single(x => x.CodeN1 == currentF6003Ligne.CodeN1); l.ValeurN1 = currentF6003Ligne.ValeurN1; } } this.F6003BindingSource.ResetCurrentItem(); } }
public XtraFrmF6003(LiasseController controller) { _controller = controller; InitializeComponent(); gridView1.CustomRowCellEdit += GridView1OnCustomRowCellEdit; _CurrentF6003 = controller.CurrentF6003(); DBf6003BindingSource.DataSource = _CurrentF6003; var Model = new Model.F6003(_CurrentF6003); this.F6003BindingSource.DataSource = new Model.F6003(_CurrentF6003); btEnregistrer.Click += BtEnregistrer_Click; btExporter.Click += BtExporter_Click; //this.gridView1.OptionsView.RowAutoHeight = true; //colLibelle.AppearanceCell.TextOptions.WordWrap=WordWrap.Wrap; saveFileDialog1.FileName = controller.GetXmlFileName(this.DBf6003BindingSource.Current); }
public F6003ImportForm(Model.F6003 currentF6003) { InitializeComponent(); CurrentF6003 = currentF6003; _fileName = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), Application.ProductName, $"ModelImport_{CurrentF6003.GetType().Name}.xml"); this.f6003BindingSource.DataSource = CurrentF6003; 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; }