private void Unload_Clicked(object sender, DialogClickEventArgs args)
{
tblPoListDetail item = new tblPoListDetail();
item.id = Convert.ToInt32(Intent.GetStringExtra("id"));
((WMSApplication)Application).ItemRepository.DeleteUPC(item);
Finish();
}
public long DeleteUPC(tblPoListDetail item)
{
using (var database = WMSDatabase.NewConnection())
{
database.Delete(item);
return(item.id);
}
}
public long UpdateRPoListDetail(tblPoListDetail item)
{
using (var database = WMSDatabase.NewConnection())
{
database.Update(item);
return(item.id);
}
}
public List <tblPoListDetail> GetRPoListDetail(string receiver_num, string division_id)
{
tblPoListDetail itemlist = new tblPoListDetail();
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPoListDetail>().ToList()
.Where(t => t.receiver_num.Equals(receiver_num) && t.division_id.Equals(division_id)).ToList()
.OrderBy(t => t.upc).ToList()
.OrderByDescending(t => t.rqty).ToList()
.OrderBy(t => t.status).ToList());
}
}
