public static long UpdatePTLListDetail(tblPickingListDetail item) { using (var database = WMSDatabase.NewConnection()) { database.Update(item); return(item.id); } }
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()); } }