Exemplo n.º 1
0
        /// <summary>
        /// Populates the fields of a single objects from the columns found in an open reader.
        /// </summary>
        /// <param name="obj" type="INVProductStock">Object of INVProductStock to populate</param>
        /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			12/27/2014 6:56:07 PM		Created function
        ///
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        internal static void PopulateObjectFromReader(INVProductStockBase obj, IDataReader rdr)
        {
            obj.ProductStockID = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.ProductStockID));
            obj.ProductID      = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.ProductID));
            obj.TotalQty       = rdr.GetDecimal(rdr.GetOrdinal(INVProductStockFields.TotalQty));
            obj.StockTypeID    = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.StockTypeID));
            obj.OpeningQty     = rdr.GetDecimal(rdr.GetOrdinal(INVProductStockFields.OpeningQty));
            if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.OpennigDate)))
            {
                obj.OpennigDate = rdr.GetDateTime(rdr.GetOrdinal(INVProductStockFields.OpennigDate));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.CreateDate)))
            {
                obj.CreateDate = rdr.GetDateTime(rdr.GetOrdinal(INVProductStockFields.CreateDate));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.CreatedBy)))
            {
                obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.CreatedBy));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.UpdateDate)))
            {
                obj.UpdateDate = rdr.GetDateTime(rdr.GetOrdinal(INVProductStockFields.UpdateDate));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.UpdatedBy)))
            {
                obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.UpdatedBy));
            }
        }
Exemplo n.º 2
0
		/// <summary>
		/// Populates the fields of a single objects from the columns found in an open reader.
		/// </summary>
		/// <param name="obj" type="INVProductStock">Object of INVProductStock to populate</param>
		/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
		///
		/// <remarks>
		///
		/// <RevisionHistory>
		/// Author				Date			Description
		/// DLGenerator			3/7/2015 2:37:24 PM		Created function
		/// 
		/// </RevisionHistory>
		///
		/// </remarks>
		///
		internal static void PopulateObjectFromReader(INVProductStockBase obj,IDataReader rdr) 
		{

			obj.ProductStockID = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.ProductStockID));
			obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.ProductID));
			obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(INVProductStockFields.TotalQty));
			obj.StockTypeID = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.StockTypeID));
			obj.OpeningQty = rdr.GetDecimal(rdr.GetOrdinal(INVProductStockFields.OpeningQty));
			if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.OpennigDate)))
			{
				obj.OpennigDate = rdr.GetDateTime(rdr.GetOrdinal(INVProductStockFields.OpennigDate));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.CreateDate)))
			{
				obj.CreateDate = rdr.GetDateTime(rdr.GetOrdinal(INVProductStockFields.CreateDate));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.CreatedBy)))
			{
				obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.CreatedBy));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.UpdateDate)))
			{
				obj.UpdateDate = rdr.GetDateTime(rdr.GetOrdinal(INVProductStockFields.UpdateDate));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.UpdatedBy)))
			{
				obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.UpdatedBy));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.InventoryID)))
			{
				obj.InventoryID = rdr.GetInt32(rdr.GetOrdinal(INVProductStockFields.InventoryID));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(INVProductStockFields.IsBlocked)))
			{
				obj.IsBlocked = rdr.GetBoolean(rdr.GetOrdinal(INVProductStockFields.IsBlocked));
			}
			

		}