Ejemplo n.º 1
0
        /// <summary>
        /// Populates the fields of a single objects from the columns found in an open reader.
        /// </summary>
        /// <param name="obj" type="SALSalesLine">Object of SALSalesLine 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:03 PM		Created function
        ///
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        internal static void PopulateObjectFromReader(SALSalesLineBase obj, IDataReader rdr)
        {
            obj.SalesLineID   = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.SalesLineID));
            obj.SalesHeaderID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.SalesHeaderID));
            obj.ProductID     = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.ProductID));
            obj.TotalQty      = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.TotalQty));
            obj.TotalBonus    = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.TotalBonus));
            if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DiscountAmount)))
            {
                obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.DiscountAmount));
            }

            obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.DiscountRatio));
            obj.UnitPrice     = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.UnitPrice));
            if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.CreatedBy)))
            {
                obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.CreatedBy));
            }

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

            if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.UpdatedBy)))
            {
                obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.UpdatedBy));
            }

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

            obj.IsDeleted = rdr.GetBoolean(rdr.GetOrdinal(SALSalesLineFields.IsDeleted));
            if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DeletedBy)))
            {
                obj.DeletedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.DeletedBy));
            }

            if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DeleteDate)))
            {
                obj.DeleteDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.DeleteDate));
            }
        }
Ejemplo n.º 2
0
		/// <summary>
		/// Populates the fields of a single objects from the columns found in an open reader.
		/// </summary>
		/// <param name="obj" type="SALSalesLine">Object of SALSalesLine 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:16 PM		Created function
		/// 
		/// </RevisionHistory>
		///
		/// </remarks>
		///
		internal static void PopulateObjectFromReader(SALSalesLineBase obj,IDataReader rdr) 
		{

			obj.SalesLineID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.SalesLineID));
			obj.SalesHeaderID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.SalesHeaderID));
			obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.ProductID));
			obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.TotalQty));
			obj.TotalBonus = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.TotalBonus));
			if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DiscountAmount)))
			{
				obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.DiscountAmount));
			}
			
			obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.DiscountRatio));
			obj.UnitPrice = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.UnitPrice));
			if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.CreatedBy)))
			{
				obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.CreatedBy));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.CreateDate)))
			{
				obj.CreateDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.CreateDate));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.UpdatedBy)))
			{
				obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.UpdatedBy));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.UpdateDate)))
			{
				obj.UpdateDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.UpdateDate));
			}
			
			obj.IsDeleted = rdr.GetBoolean(rdr.GetOrdinal(SALSalesLineFields.IsDeleted));
			if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DeletedBy)))
			{
				obj.DeletedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.DeletedBy));
			}
			
			if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DeleteDate)))
			{
				obj.DeleteDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.DeleteDate));
			}
			

		}