public long DeleteRPoList(tblPoList item)
{
using (var database = WMSDatabase.NewConnection())
{
database.Delete(item);
return(item.id);
}
}
public long UpdateConnectionURL(tblConnectionURL item)
{
using (var database = WMSDatabase.NewConnection())
{
database.Update(item);
return(item.id);
}
}
public static long UpdateBoxDetail(tblBoxDetail item)
{
using (var database = WMSDatabase.NewConnection())
{
database.Update(item);
return(item.id);
}
}
public tblConnectionURL GetConnectionURL()
{
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblConnectionURL> ().SingleOrDefault());
}
}
public static long UserLogin(tblUser item)
{
using (var database = WMSDatabase.NewConnection())
{
database.Update(item);
return(item.id);
}
}
public long UpdateRPoListDetail(tblPoListDetail item)
{
using (var database = WMSDatabase.NewConnection())
{
database.Update(item);
return(item.id);
}
}
public tblPoListDetail[] ChkRPoListVariance(string receiver_num, string division_id)
{
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPoListDetail> ()
.Where(t => t.receiver_num == receiver_num && t.division_id == division_id && t.oqty != t.rqty).ToArray());
}
}
public tblPoListDetail[] UpdateRPoListDetail(string receiver_num, string division_id)
{
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPoListDetail> ()
.Where(t => t.receiver_num == receiver_num && t.division_id == division_id).ToArray());
}
}
public tblPoListDetail GetRPoUPC(string receiver_num, string division_id, string upc)
{
upc = upc.Substring(0, Convert.ToInt32(upc.Length - 1));
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPoListDetail> ()
.Where(t => t.receiver_num == receiver_num && t.division_id == division_id && t.upc == upc).SingleOrDefault());
}
}
public static tblPickingListDetail GetPTLUPC(string move_doc, string upc)
{
upc = upc.Substring(0, Convert.ToInt32(upc.Length - 1));
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPickingListDetail> ()
.Where(t => t.move_doc == move_doc && t.upc == upc).SingleOrDefault());
}
}
public static tblBox GetPBoxCode(string boxcode)
{
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblBox> ()
.Where(t => t.box_code == boxcode)
.SingleOrDefault());
}
}
public static tblPoList ChkPoListExist(string receiver_num, string division)
{
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPoList> ()
.Where(t => t.receiver_num == receiver_num && t.division == division)
.SingleOrDefault());
}
}
public static tblBoxDetail ChkBoxDetailUPC(string box_code, string move_doc, string upc)
{
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblBoxDetail> ()
.Where(t => t.box_code == box_code && t.move_doc == move_doc && t.upc == upc)
.SingleOrDefault());
}
}
public List <tblPickingList> GetPTLList(string po)
{
tblPickingList itemlist = new tblPickingList();
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPickingList>().ToList()
.Where(t => t.move_doc.Contains(po)).ToList());
}
}
public List <tblPoList> GetRPoList(string po)
{
tblPoList itemlist = new tblPoList();
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPoList>().ToList()
.Where(t => t.po_num.Contains(po)).ToList());
}
}
public static List <tblBox> GetBoxList()
{
tblBox itemlist = new tblBox();
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblBox>()
.OrderByDescending(t => t.id)
.ToList());
}
}
public static List <tblPickingListDetail> GetPickingListDetail(string move_doc)
{
tblPickingListDetail itemlist = new tblPickingListDetail();
using (var database = WMSDatabase.NewConnection())
{
return(database
.Table <tblPickingListDetail> ()
.Where(t => t.move_doc == move_doc)
.OrderBy(t => t.dept).ToList()
.OrderBy(t => t.status).ToList());
}
}
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());
}
}
public static long AddBoxDetail(string box_code, string move_doc, string upc, string rqty)
{
using (var database = WMSDatabase.NewConnection())
{
return(database.Insert
(new tblBoxDetail
{
box_code = box_code,
move_doc = move_doc,
upc = upc,
rqty = rqty
}
));
}
}
public static long AddPBox(string box_code, string move_doc, string number, string total)
{
using (var database = WMSDatabase.NewConnection())
{
return(database.Insert
(new tblBox
{
box_code = box_code,
move_doc = move_doc,
number = number,
total = total
}
));
}
}
public static long AddRPoList(string po_num, string receiver_num, string division_id, string division, string status)
{
using (var database = WMSDatabase.NewConnection())
{
return(database.Insert
(new tblPoList
{
po_num = po_num,
receiver_num = receiver_num,
division_id = division_id,
division = division,
slot_num = "",
status = status
}
));
}
}
public static long AddRPoListDetail(string receiver_num, string division_id, string upc, string description, string oqty, string rqty, string status)
{
using (var database = WMSDatabase.NewConnection())
{
return(database.Insert
(new tblPoListDetail
{
receiver_num = receiver_num,
division_id = division_id,
upc = upc,
description = description,
oqty = oqty,
rqty = rqty,
status = status
}
));
}
}