public PublishipAdvanceCartonTableCollection FetchByQuery(Query qry)
        {
            PublishipAdvanceCartonTableCollection coll = new PublishipAdvanceCartonTableCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public PublishipAdvanceCartonTableCollection FetchAll()
        {
            PublishipAdvanceCartonTableCollection coll = new PublishipAdvanceCartonTableCollection();
            Query qry = new Query(PublishipAdvanceCartonTable.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public PublishipAdvanceCartonTableCollection FetchByID(object PubAdvCartonID)
        {
            PublishipAdvanceCartonTableCollection coll = new PublishipAdvanceCartonTableCollection().Where("PubAdvCartonID", PubAdvCartonID).Load();

            return(coll);
        }
        public PublishipAdvanceCartonTableCollection CartonsFetchByPATitleID(object PATitleID)
        {
            PublishipAdvanceCartonTableCollection coll = new PublishipAdvanceCartonTableCollection().Where("PATitleID", PATitleID).Load();

            return(coll);
        }