예제 #1
0
        /// <summary>
        /// Creates a new instance of the sol_Products class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_Product MakeSol_Product(SqlDataReader dataReader)
        {
            Sol_Product sol_Product = new Sol_Product();

            sol_Product.ProductID           = SqlClientUtility.GetInt32(dataReader, "ProductID", 0);
            sol_Product.ProName             = SqlClientUtility.GetString(dataReader, "ProName", String.Empty);
            sol_Product.ProDescription      = SqlClientUtility.GetString(dataReader, "ProDescription", String.Empty);
            sol_Product.ProShortDescription = SqlClientUtility.GetString(dataReader, "ProShortDescription", String.Empty);
            sol_Product.ProImage            = SqlClientUtility.GetBytes(dataReader, "ProImage", new byte[0]);
            sol_Product.AgencyID            = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0);
            sol_Product.MenuOrder           = SqlClientUtility.GetInt32(dataReader, "MenuOrder", 0);
            sol_Product.IsActive            = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
            sol_Product.Price                    = SqlClientUtility.GetDecimal(dataReader, "Price", Decimal.Zero);
            sol_Product.CategoryID               = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0);
            sol_Product.RefundAmount             = SqlClientUtility.GetDecimal(dataReader, "RefundAmount", Decimal.Zero);
            sol_Product.HandlingCommissionAmount = SqlClientUtility.GetDecimal(dataReader, "HandlingCommissionAmount", Decimal.Zero);
            sol_Product.CommissionUnit           = SqlClientUtility.GetInt32(dataReader, "CommissionUnit", 0);
            sol_Product.VafAmount                = SqlClientUtility.GetDecimal(dataReader, "VafAmount", Decimal.Zero);
            sol_Product.FeeUnit                  = SqlClientUtility.GetInt32(dataReader, "FeeUnit", 0);
            sol_Product.ContainerID              = SqlClientUtility.GetInt32(dataReader, "ContainerID", 0);
            sol_Product.StandardDozenID          = SqlClientUtility.GetInt32(dataReader, "StandardDozenID", 0);
            sol_Product.UPC             = SqlClientUtility.GetString(dataReader, "UPC", String.Empty);
            sol_Product.ProductCode     = SqlClientUtility.GetString(dataReader, "ProductCode", String.Empty);
            sol_Product.TypeId          = SqlClientUtility.GetByte(dataReader, "TypeId", 0x00);
            sol_Product.Tax1Exempt      = SqlClientUtility.GetBoolean(dataReader, "Tax1Exempt", false);
            sol_Product.Tax2Exempt      = SqlClientUtility.GetBoolean(dataReader, "Tax2Exempt", false);
            sol_Product.MasterProductID = SqlClientUtility.GetInt32(dataReader, "MasterProductID", 0);
            sol_Product.Weight          = SqlClientUtility.GetDecimal(dataReader, "Weight", Decimal.Zero);
            sol_Product.Volume          = SqlClientUtility.GetDecimal(dataReader, "Volume", Decimal.Zero);
            sol_Product.TargetQuantity  = SqlClientUtility.GetInt32(dataReader, "TargetQuantity", 0);

            return(sol_Product);
        }
예제 #2
0
        /// <summary>
        /// Creates a new instance of the Sac_Settings class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sac_Setting MakeSac_Setting(SqlDataReader dataReader)
        {
            Sac_Setting sac_Setting = new Sac_Setting();

            sac_Setting.Name        = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
            sac_Setting.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
            sac_Setting.SetValue    = SqlClientUtility.GetBytes(dataReader, "SetValue", new byte[0]);

            return(sac_Setting);
        }
예제 #3
0
        /// <summary>
        /// Creates a new instance of the Sac_Charity class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sac_Charity MakeSac_Charity(SqlDataReader dataReader)
        {
            Sac_Charity sac_Charity = new Sac_Charity();

            sac_Charity.CharityID          = SqlClientUtility.GetInt32(dataReader, "CharityID", 0);
            sac_Charity.CustomerID         = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0);
            sac_Charity.ShortName          = SqlClientUtility.GetString(dataReader, "ShortName", String.Empty);
            sac_Charity.CharityDescription = SqlClientUtility.GetString(dataReader, "CharityDescription", String.Empty);
            sac_Charity.CharityTypeID      = SqlClientUtility.GetInt32(dataReader, "CharityTypeID", 0);
            sac_Charity.RegistrationNumber = SqlClientUtility.GetString(dataReader, "RegistrationNumber", String.Empty);
            sac_Charity.IsActive           = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
            sac_Charity.ButtonPosition     = SqlClientUtility.GetByte(dataReader, "ButtonPosition", 0x00);
            sac_Charity.Logo = SqlClientUtility.GetBytes(dataReader, "Logo", new byte[0]);

            return(sac_Charity);
        }