コード例 #1
0
        private void btImport_Click(object sender, EventArgs e)
        {
            var model = new Model.F6004(new F6004());
            var z     = new ImportForms.F6004ImportForm(model);

            if (z.ShowDialog(this) == DialogResult.OK)
            {
                var f6004 = this.F6004BindingSource.Current as Model.F6004;
                if (f6004 == null)
                {
                    return;
                }
                foreach (var currentF6004Ligne in model.Lignes)
                {
                    if (currentF6004Ligne != null && !currentF6004Ligne.Calculable)
                    {
                        var l = f6004.Lignes.Single(x => x.CodeN == currentF6004Ligne.CodeN);
                        l.ValeurN = currentF6004Ligne.ValeurN;

                        l          = f6004.Lignes.Single(x => x.CodeN1 == currentF6004Ligne.CodeN1);
                        l.ValeurN1 = currentF6004Ligne.ValeurN1;
                    }
                }
                this.F6004BindingSource.ResetCurrentItem();
            }
        }
コード例 #2
0
        public F6004ImportForm(Model.F6004 currentF6004)
        {
            InitializeComponent();
            CurrentF6004 = currentF6004;

            _fileName = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), Application.ProductName, $"ModelImport_{CurrentF6004.GetType().Name}.xml");
            this.f6004BindingSource.DataSource = CurrentF6004;
            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;
        }