public async Task GetEditItems() { var edititems = from items in Items join vat in VAT on items.vatId equals vat.vatId join sekce in Sekces on items.sectionId equals sekce.id select new { ItemId = items.itemId, Name = items.name, VatName = vat.name, Price = items.price, SectionName = sekce.name }; foreach (var item in edititems) { EditItems.Add(new EditItem() { SectionName = item.SectionName, itemId = item.ItemId, Name = item.Name, Price = (int)item.Price, VatName = item.VatName } ); } }
/// <summary> /// /// </summary> /// <param name="item"></param> /// <returns></returns> protected Task <bool> OnSaveAsync(BindItem item) { // 增加数据演示代码 if (item.Id == 0) { lock (_objectLock) { item.Id = EditItems.Max(i => i.Id) + 1; EditItems.Add(item); } } else { var oldItem = EditItems.FirstOrDefault(i => i.Id == item.Id); if (oldItem != null) { oldItem.Name = item.Name; oldItem.Address = item.Address; oldItem.DateTime = item.DateTime; oldItem.Count = item.Count; oldItem.Complete = item.Complete; oldItem.Education = item.Education; } } return(Task.FromResult(true)); }
private void UC_Sclad_Load(object sender, EventArgs e) { OleDbDataAdapter dataAdapter = new OleDbDataAdapter(db.selectSclad, db.connect); DataSet ds = new DataSet(); dataAdapter.Fill(ds); DGVIEWBlydo.DataSource = ds.Tables[0].DefaultView; DGVIEWBlydo.Columns[0].Visible = false; if (DGVIEWBlydo.RowCount > 0) { EditItems.Clear(); for (int i = 0; i < DGVIEWBlydo.ColumnCount; i++) { EditItems.Add(DGVIEWBlydo.Rows[0].Cells[i].Value.ToString()); } } }
private void UC_Blydo_Load(object sender, EventArgs e) { OleDbDataAdapter dataAdapter = new OleDbDataAdapter(db.selectBlydo, db.connect); DataSet ds = new DataSet(); dataAdapter.Fill(ds); DGVIEWBlydo.DataSource = ds.Tables[0].DefaultView; //TRecept.Enabled = false; DGVIEWBlydo.Columns[0].Visible = false; if (DGVIEWBlydo.RowCount > 0) { EditItems.Clear(); for (int i = 0; i < DGVIEWBlydo.ColumnCount; i++) { EditItems.Add(DGVIEWBlydo.Rows[0].Cells[i].Value.ToString()); } } DGSostav(Convert.ToInt32(EditItems[0])); getRecept(Convert.ToInt32(EditItems[0])); }
private void UC_Menu_Load(object sender, EventArgs e) { TBlydo.Items.Clear(); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(db.selectMenu, db.connect); DataSet ds = new DataSet(); dataAdapter.Fill(ds); DGVIEWBlydo.DataSource = ds.Tables[0].DefaultView; string[] kategor = getProdict().Select(n => n.ToString()).ToArray(); TBlydo.Items.AddRange(kategor); DGVIEWBlydo.Columns[0].Visible = false; if (DGVIEWBlydo.RowCount > 0) { EditItems.Clear(); for (int i = 0; i < DGVIEWBlydo.ColumnCount; i++) { EditItems.Add(DGVIEWBlydo.Rows[0].Cells[i].Value.ToString()); } } }