partial void Deletebar_revision_t(bar_revision_t instance);
partial void Updatebar_revision_t(bar_revision_t instance);
partial void Insertbar_revision_t(bar_revision_t instance);
private void detach_bar_revision_ts(bar_revision_t entity)
{
this.SendPropertyChanging();
entity.items_table = null;
}
private void detach_bar_revision_ts(bar_revision_t entity)
{
this.SendPropertyChanging();
entity.global_session_t = null;
}
// public void AddItemsToRevision(string itemId, int amountsold)
// {
// var db = new dbDataContext();
// lock (db)
// {
//
// }
// }
public void AddNewOrUpdateBarRevisionRecord(int dailyId, string itemId, int amountSold, int amountBought,
int left, int num)
{
var db = new dbDataContext();
lock (db)
{
var match = (from i in db.GetTable<bar_revision_t>()
where i.item_id == itemId
where i.daily_id == dailyId
select i).SingleOrDefault();
if (match == null)
{
Table<bar_revision_t> soldBarTable = db.GetTable<bar_revision_t>();
var revisionItem = new bar_revision_t
{
bar_item_num = num,
daily_id = dailyId,
item_id = itemId,
amount_sold = amountSold,
amount_bought = amountBought,
left_num = left
};
soldBarTable.InsertOnSubmit(revisionItem);
db.SubmitChanges();
}
else
{
match.bar_item_num = num;
match.amount_sold = amountSold;
match.amount_bought = amountBought;
match.left_num = left;
db.SubmitChanges();
}
}
}
