C# DbDataReader.GetInt32方法代码示例

        private static BasicPerson ReadPersonFromDataReader (DbDataReader reader)
        {
            int personId = reader.GetInt32(0);
            string passwordHash = reader.GetString(1);
            string name = reader.GetString(2);
            string email = reader.GetString(3);
            string street = reader.GetString(4);
            string postalCode = reader.GetString(5);
            string cityName = reader.GetString(6);
            int countryId = reader.GetInt32(7);
            string phone = reader.GetString(8);
            int geographyId = reader.GetInt32(9);
            DateTime birthdate = reader.GetDateTime(10);
            int genderId = reader.GetInt32(11);


            // Fix broken names, emails

            email = email.ToLower().Trim();
            name = name.Trim();

            while (name.Contains("  "))
            {
                name = name.Replace("  ", " ");
            }


            return new BasicPerson(personId, passwordHash, name, email, street, postalCode, cityName, countryId, phone,
                                   geographyId, birthdate, (PersonGender)genderId);
        }

        private static BasicGeography ReadGeographyFromDataReader (DbDataReader reader)
        {
            int geographyId = reader.GetInt32(0);
            int parentGeographyId = reader.GetInt32(1);
            string name = reader.GetString(2);

            return new BasicGeography(geographyId, parentGeographyId, name);
        }

        private BasicOutboundInvoiceItem ReadOutboundInvoiceItemFromDataReader (DbDataReader reader)
        {
            int outboundInvoiceItemId = reader.GetInt32(0);
            int outboundInvoiceId = reader.GetInt32(1);
            string description = reader.GetString(2);
            Int64 amountCents = reader.GetInt64(3);

            return new BasicOutboundInvoiceItem(outboundInvoiceItemId, outboundInvoiceId, description, amountCents);
        }

        private static BasicGeographyDesignation ReadGeographyDesignationFromDataReader (DbDataReader reader)
        {
            int geographyId = reader.GetInt32(0);
            int countryId = reader.GetInt32(1);
            string designation = reader.GetString(2);
            GeographyLevel level = (GeographyLevel) reader.GetInt32(3);

            return new BasicGeographyDesignation(geographyId, countryId, designation, level);
        }

        private static BasicCity ReadCityFromDataReader (DbDataReader reader)
        {
            int cityId = reader.GetInt32(0);
            int countryId = reader.GetInt32(1);
            string cityName = reader.GetString(2);
            int geographyId = reader.GetInt32(3);

            return new BasicCity(cityId, cityName, countryId, geographyId);
        }

        private BasicPostalCode ReadPostalCodeFromDataReader(DbDataReader reader)
        {
            int postalCodeId = reader.GetInt32(0);
            string postalCode = reader.GetString(1);
            int cityId = reader.GetInt32(2);
            int countryId = reader.GetInt32(3);

            return new BasicPostalCode(postalCodeId, postalCode, cityId, countryId);
        }

        private BasicOutboundMailRecipient ReadOutboundMailRecipientFromDataReader(DbDataReader reader)
        {
            int outboundMailRecipientId = reader.GetInt32(0);
            int outboundMailId = reader.GetInt32(1);
            int personId = reader.GetInt32(2);
            bool asOfficer = reader.GetBoolean(3);
            int personType = reader.GetInt32(4);

            return new BasicOutboundMailRecipient(outboundMailRecipientId, outboundMailId, personId, asOfficer, personType);
        }

        private static BasicCountry ReadCountryFromDataReader(DbDataReader reader)
        {
            int countryId = reader.GetInt32(0);
            string name = reader.GetString(1);
            string code = reader.GetString(2).ToUpperInvariant();
            string culture = reader.GetString(3);
            int geographyId = reader.GetInt32(4);

            return new BasicCountry(countryId, name, code, culture, geographyId);
        }

        static private BasicChurnDataPoint ReadChurnDataPointFromDataReader (DbDataReader reader)
        {
            int personId = reader.GetInt32(0);
            int organizationId = reader.GetInt32(1);
            bool churn = reader.GetBoolean(2);
            DateTime decisionDateTime = reader.GetDateTime(3);
            DateTime expiryDateTime = reader.GetDateTime(4);

            return new BasicChurnDataPoint(churn ? ChurnDataType.Churn : ChurnDataType.Retention, decisionDateTime,
                                           expiryDateTime, personId, organizationId);
        }

        static private BasicPersonRole ReadPersonRoleFromDataReader (DbDataReader reader)
        {
            int personRoleId = reader.GetInt32(0);
            string personRoleTypeName = reader.GetString(1);
            int personId = reader.GetInt32(2);
            int organizationId = reader.GetInt32(3);
            int geographyId = reader.GetInt32(4);

            RoleType roleType = (RoleType) Enum.Parse(typeof (RoleType), personRoleTypeName);

            return new BasicPersonRole(personRoleId, personId, roleType, organizationId, geographyId);
        }

        private static BasicAutoMail ReadAutoMailFromDataReader (DbDataReader reader)
        {
            int autoMailId = reader.GetInt32(0);
            AutoMailType type = (AutoMailType) Enum.Parse(typeof (AutoMailType), reader.GetString(1));
            int geographyId = reader.GetInt32(3);
            int organizationId = reader.GetInt32(2);
            int authorPersonId = reader.GetInt32(4); // appear to be unused?
            string title = reader.GetString(5);
            string body = reader.GetString(6);

            return new BasicAutoMail(autoMailId, type, organizationId, geographyId, authorPersonId,
                                     title, body);
        }

        private BasicPayrollAdjustment ReadPayrollAdjustmentFromDataReader(DbDataReader reader)
        {
            int payrollAdjustmentId = reader.GetInt32(0);
            int payrollAdjustmentTypeId = reader.GetInt32(1);
            int payrollItemId = reader.GetInt32(2);
            Int64 amountCents = reader.GetInt64(3);
            string description = reader.GetString(4);
            bool open = reader.GetBoolean(5);
            int salaryId = reader.GetInt32(6);

            return new BasicPayrollAdjustment(payrollAdjustmentId, payrollItemId,
                                              (PayrollAdjustmentType) payrollAdjustmentTypeId,
                                              amountCents, description, open, salaryId);
        }

        private BasicExternalCredential ReadExternalCredentialFromDataReader (DbDataReader reader)
        {
            int externalCredentialId = reader.GetInt32(0);
            string serviceName = reader.GetString(1);
            string login = reader.GetString(2);
            string password = reader.GetString(3);

            return new BasicExternalCredential(externalCredentialId, serviceName, login, password);
        }

        private static BasicOrganization ReadOrganizationFromDataReader (DbDataReader reader)
        {
            int organizationId = reader.GetInt32(0);
            int parentOrganizationId = reader.GetInt32(1);
            string name = reader.GetString(2);
            string nameInternational = reader.GetString(3);
            string nameShort = reader.GetString(4);
            string domain = reader.GetString(5);
            string mailPrefix = reader.GetString(6);
            int anchorGeographyId = reader.GetInt32(7);
            bool acceptsMembers = reader.GetBoolean(8);
            bool autoAssignNewMembers = reader.GetBoolean(9);
            int defaultCountryId = reader.GetInt32(10);

            return new BasicOrganization(organizationId, parentOrganizationId, name, nameInternational, nameShort,
                                         domain, mailPrefix, anchorGeographyId, acceptsMembers, autoAssignNewMembers,
                                         defaultCountryId);
        }

        private static BasicExceptionLog ExceptionLogFromDataReader (DbDataReader reader)
        {

            int ExceptionId = reader.GetInt32(0);
            DateTime ExceptionDateTime = reader.GetDateTime(1);
            string Source = reader.GetString(2);
            string ExceptionText = reader.GetString(3);
            return new BasicExceptionLog(ExceptionId, ExceptionDateTime, Source, ExceptionText);
        }