예제 #1
0
        public static ItemImageCollection GetbyUser(string CreatedUser)
        {
            ItemImageCollection collection = new ItemImageCollection();
            ItemImage           obj;

            using (var reader = SqlHelper.ExecuteReader("tblItemImage_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
            {
                while (reader.Read())
                {
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
예제 #2
0
        public static ItemImageCollection GetbyItemCode(string ItemCode)
        {
            ItemImageCollection collection = new ItemImageCollection();
            ItemImage           obj;

            using (var reader = SqlHelper.ExecuteReader("tblItemImage_GetByItemCode", new SqlParameter("@ItemCode", ItemCode)))
            {
                while (reader.Read())
                {
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
예제 #3
0
        public static ItemImageCollection GetAllItem()
        {
            ItemImageCollection collection = new ItemImageCollection();

            using (var reader = SqlHelper.ExecuteReader("tblItemImage_GetAll", null))
            {
                while (reader.Read())
                {
                    ItemImage obj = new ItemImage();
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }