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());
}
}
}
