private void btn_Click(object sender, EventArgs e) { col = new BusinessObjects.OutputCollection(); string filter = tbOptimizerFilter.Text.Trim(); sumOfItems = float.Parse("0.0"); int partID; if (int.TryParse(filter, out partID)) { BusinessObjects.OutputQuery qry = new BusinessObjects.OutputQuery(); qry.Select(qry.CutlistID, qry.Qnty, qry.Length, qry.SourceDescription, qry.PartIdentifier); qry.Where(qry.PartID == partID); col.Load(qry); this.dgOptimizerItems.DataSource = col; } foreach (BusinessObjects.Output o in col) { if (o.Length.HasValue) { sumOfItems += (float)o.Length.Value; } } float totalFeet = sumOfItems / 12.0f; lbSumofParts.Text = totalFeet.ToString() + " ft"; //col = Db.OutParts(); }
private void btnWrite_Click(object sender, EventArgs e) { //if (buildUnits != null && buildUnits.Count > 0) //{ // this.dataGridView3.DataSource = Db.Write(buildUnits); BusinessObjects.OutputCollection colOutParts = new BusinessObjects.OutputCollection(); BusinessObjects.OutputQuery qry = new BusinessObjects.OutputQuery(); colOutParts.LoadAll(); this.dataGridView3.DataSource = colOutParts; col = colOutParts; //} }