private void CreateCalk() { var query = from k in db.kalkulationstabellen where k.id == 794 select k; var calc = query.FirstOrDefault(); kalkulationstabelle_detail det = db.CreateObject <kalkulationstabelle_detail>(); det.created = DateTime.Now; det.artikelnr = "1140"; det.beschreibung = "Keine"; det.einheit = "Stück"; det.einzelpreis = 6625; det.epnok = 0; det.idx = 4; det.menge = 13; det.id_kalkulationstabelle = 794; db.AddTokalkulationstabelle_details(det); db.SaveChanges(); }
void KalkulationView_CurrentChanged(object sender, EventArgs e) { CurrDetails = (kalkulationstabelle_detail)KalkulationDetailView.CurrentItem; }
void PopulateGrid() { int[] widths = { 20, 20, 30, 60, 80, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60, 60 }; string[] headers = { "Id", "Pos.", "Menge", "Einheit", "Beschreibung", "Artikel Nr.", "EP NOK", "Umrechn. €", "Summe Pos.", "Aufschlag", "Einzelpreis", "Gesamt alle Pos", "% von Gesamt", "Anteil Transport", "SI EInzel inl. Transp.", "Rundumgspreis", "Gesamt Angebot" }; string[] surpress = { "kalkulationstabelle", "created", "kalkulationstabelle", "kalkulationstabelleReference", "SummePosition", "EntityState", "EntityKey", "id_kalkulationstabelle" }; _flex.ItemsSource = null; _flex.Rows.Clear(); _flex.Columns.Clear(); var neu = new kalkulationstabelle_detail(); var detailQuery = from d in db.kalkulationstabelle_details where d.id_kalkulationstabelle == 794 select d; int rows = detailQuery.Count(); using (_flex.Rows.DeferNotifications()) using (_flex.Columns.DeferNotifications()) { while (_flex.Columns.Count <= headers.Count()) { _flex.Columns.Add(new Column()); } while (_flex.Rows.Count < rows + 1) { _flex.Rows.Add(new Row()); } } int z = 1; int s = 0; bool bSurpress = false; object xx; for (int i = 0; i < headers.Count(); i++) { _flex[0, i] = headers[i]; _flex.Columns[i].Width = new System.Windows.GridLength((double)widths[i]); } PropertyInfo[] cols = null; foreach (var c in detailQuery) { s = 0; cols = c.GetType().GetProperties(); foreach (PropertyInfo pi in cols) { bSurpress = false; // Spaltentyp: Type colType = pi.PropertyType; if (colType.IsGenericType && colType.GetGenericTypeDefinition() == typeof(Nullable <>)) { colType = colType.GetGenericArguments()[0]; } foreach (var item in surpress) { if (pi.Name == item) { bSurpress = true; break; } } if (bSurpress == false) { xx = pi.GetValue(c, null) == null ? DBNull.Value : pi.GetValue(c, null); _flex[z, s] = xx.ToString(); s++; } } s = 0; z++; } }