C# IDataRecord.GetString方法代码示例

        private static BasicOutboundMail ReadOutboundMailFromDataReader (IDataRecord reader)
        {
            int outboundMailId = reader.GetInt32(0);
            int authorType = reader.GetInt32(1);
            int authorPersonId = reader.GetInt32(2);
            string title = reader.GetString(3);
            string body = reader.GetString(4);

            int mailPriority = reader.GetInt32(5);
            int mailTypeId = reader.GetInt32(6);
            int organizationId = reader.GetInt32(7);
            int geographyId = reader.GetInt32(8);
            DateTime createdDateTime = reader.GetDateTime(9);

            DateTime releaseDateTime = reader.GetDateTime(10);
            bool readyForPickup = reader.GetBoolean(11);
            bool resolved = reader.GetBoolean(12);
            bool processed = reader.GetBoolean(13);
            DateTime resolvedDateTime = reader.GetDateTime(14);

            DateTime startProcessDateTime = reader.GetDateTime(15);
            DateTime endProcessDateTime = reader.GetDateTime(16);
            int recipientCount = reader.GetInt32(17);
            int recipientsSuccess = reader.GetInt32(18);
            int recipientsFail = reader.GetInt32(19);

            return new BasicOutboundMail(outboundMailId, (MailAuthorType)authorType, authorPersonId, title, body,
                mailPriority, mailTypeId, organizationId, geographyId, createdDateTime,
                releaseDateTime, readyForPickup, resolved, processed, resolvedDateTime, startProcessDateTime, endProcessDateTime,
                recipientCount, recipientsSuccess, recipientsFail);
        }

        private static BasicParley ReadParleyFromDataReader (IDataRecord reader)
        {
            int parleyId = reader.GetInt32(0);
            int organizationId = reader.GetInt32(1);
            int personId = reader.GetInt32(2);
            int budgetId = reader.GetInt32(3);
            DateTime createdDateTime = reader.GetDateTime(4);

            bool open = reader.GetBoolean(5);
            bool attested = reader.GetBoolean(6);
            string name = reader.GetString(7);
            int geographyId = reader.GetInt32(8);
            string description = reader.GetString(9);

            string informationUrl = reader.GetString(10);
            DateTime startDate = reader.GetDateTime(11);
            DateTime endDate = reader.GetDateTime(12);
            Int64 budgetCents = reader.GetInt64(13);
            Int64 guaranteeCents = reader.GetInt64(14);

            Int64 attendanceFeeCents = reader.GetInt64(15);
            DateTime closedDateTime = reader.GetDateTime(16);

            return new BasicParley(
                parleyId, organizationId, personId, budgetId, createdDateTime,
                open, attested, name, geographyId, description,
                informationUrl, startDate, endDate, budgetCents, guaranteeCents,
                attendanceFeeCents, closedDateTime);
        }

 /// <summary>
 /// 
 /// </summary>
 /// <param name="databaseId"></param>
 /// <param name="reader"></param>
 internal DbTable(Guid databaseId, IDataRecord reader)
     : this(databaseId, reader.GetString(reader.GetOrdinal("Id")),
         reader.GetString(reader.GetOrdinal("CatalogName")),
         reader.GetString(reader.GetOrdinal("SchemaName")),
         reader.GetString(reader.GetOrdinal("Name")),
         reader.GetNullableString("Description"))
 {
 }

 public SearchResult(IDataRecord data)
 {
     PrimaryId = data.GetInt32(0);
     SecondaryId = data.GetInt32(1);
     ClassName = data.GetString(2);
     PrimaryText = data.GetString(3);
     SecondaryText = data.GetString(4);
 }

 public override void Load(IDataRecord record)
 {
     Id = record.GetInt32(0);
     OKPO = record.GetString(1);
     SOATO = record.GetString(2);
     INN = record.GetString(3);
     Name = record.GetString(4);
     Type = (OrgType)record.GetByte(5);
 }

        private static BasicCurrency ReadCurrencyFromDataReader(IDataRecord reader)
        {
            int currencyId = reader.GetInt32(0);
            string code = reader.GetString(1);
            string name = reader.GetString(2);
            string sign = reader.GetString(3);

            return new BasicCurrency(currencyId, code, name, sign);
        }

        private static BasicPaymentInformation ReadPaymentInformationFromDataReader (IDataRecord reader)
        {
            string dataTypeString = reader.GetString(2);
            string data = reader.GetString(3);

            PaymentInformationType dataType =
                (PaymentInformationType) Enum.Parse(typeof (PaymentInformationType), dataTypeString, true);

            return new BasicPaymentInformation(dataType, data);
        }

 public static void RecordHandler(IDataRecord record, TrackLayout layout)
 {
     var number = record.GetString(record.GetOrdinal("Number"));
     var fromStationSignature = record.GetString(record.GetOrdinal("FromStation"));
     var toStationSignature = record.GetString(record.GetOrdinal("ToStation"));
     if (!layout.HasTimetableStretch(number)) layout.Add(new TimetableStretch(number));
     var currentTimetableStretch = layout.TimetableStretch(number);
     var trackStretch = layout.TrackStretch(fromStationSignature, toStationSignature);
     currentTimetableStretch.Add(trackStretch);
 }

        private Gnosis.ILink ReadLink(IDataRecord record)
        {
            var source = record.GetUri("Source");
            var target = record.GetUri("Target");
            var relationship = record.GetString("Relationship");
            var name = record.GetString("Name");
            var id = record.GetInt64("Id");

            return new Gnosis.Links.Link(source, target, relationship, name, id);
        }

        private static BasicBallot ReadBallotFromDataReader(IDataRecord reader)
        {
            int ballotId = reader.GetInt32(0);
            int electionId = reader.GetInt32(1);
            string name = reader.GetString(2);
            int organizationId = reader.GetInt32(3);
            int geographyId = reader.GetInt32(4);
            int ballotCount = reader.GetInt32(5);
            string deliveryAddress = reader.GetString(6);

            return new BasicBallot(ballotId, electionId, organizationId, geographyId, name, ballotCount, deliveryAddress);
        }

        private static BasicPayment ReadPaymentFromDataReader(IDataRecord reader)
        {
            int paymentId = reader.GetInt32(0);
            int paymentGroupId = reader.GetInt32(1);
            Int64 amountCents = reader.GetInt64(2);
            string reference = reader.GetString(3);
            string fromAccount = reader.GetString(4);
            string key = reader.GetString(5);
            bool hasImage = reader.GetBoolean(6);
            int outboundInvoiceId = reader.GetInt32(7);

            return new BasicPayment(paymentId, paymentGroupId, amountCents, reference, fromAccount, key, hasImage, outboundInvoiceId);
        }

        private static MobileService FillDataRecord(IDataRecord myDataRecord)
        {
            MobileService mobileService = new MobileService();

            mobileService.Id = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Id"));
            mobileService.ProviderId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("providerid"));
            mobileService.ServiceName = myDataRecord.GetString(myDataRecord.GetOrdinal("servicename"));
            mobileService.Description = myDataRecord.GetString(myDataRecord.GetOrdinal("description"));
            mobileService.HowToAccess = myDataRecord.GetString(myDataRecord.GetOrdinal("howtoaccess"));
            mobileService.Charges = myDataRecord.GetString(myDataRecord.GetOrdinal("charges"));

            return mobileService;
        }

        private static BasicFinancialValidation ReadFinancialValidationFromDataReader(IDataRecord reader)
        {
            int financialValidationId = reader.GetInt32(0);
            FinancialValidationType validationType =
                (FinancialValidationType)(Enum.Parse(typeof(FinancialValidationType), reader.GetString(1)));
            FinancialDependencyType dependencyType =
                (FinancialDependencyType)(Enum.Parse(typeof(FinancialDependencyType), reader.GetString(2)));
            int foreignId = reader.GetInt32(3);
            DateTime dateTime = reader.GetDateTime(4);
            int personId = reader.GetInt32(5);
            double amount = reader.GetDouble(6); // not yet used

            return new BasicFinancialValidation(financialValidationId, validationType, personId, dateTime, dependencyType, foreignId);
        }

 /// <summary>
 /// Creates an instance of this class
 /// </summary>
 /// <param name="rdr">The data record</param>
 /// <param name="connectionString">The connection string</param>
 public GpkgContent(IDataRecord rdr, string connectionString)
 {
     int index;
     _tableName = rdr.IsDBNull(index=rdr.GetOrdinal("table_name")) ? string.Empty : rdr.GetString(index);
     _dataType = rdr.IsDBNull(index=rdr.GetOrdinal("data_type")) ? string.Empty : rdr.GetString(index);
     _identifier = rdr.IsDBNull(index = rdr.GetOrdinal("identifier")) ? string.Empty : rdr.GetString(index);
     _description = rdr.IsDBNull(index = rdr.GetOrdinal("description")) ? string.Empty : rdr.GetString(index);
     _lastChange = rdr.IsDBNull(index = rdr.GetOrdinal("last_change")) ? DateTime.MinValue : rdr.GetDateTime(index);
     _extent = new Envelope(
         rdr.GetDouble(rdr.GetOrdinal("min_x")), rdr.GetDouble(rdr.GetOrdinal("max_x")), 
         rdr.GetDouble(rdr.GetOrdinal("min_y")), rdr.GetDouble(rdr.GetOrdinal("max_y")));
     _srid = rdr.GetInt32(rdr.GetOrdinal("srs_id"));
     _connectionString = connectionString;
 }

        private static BasicExternalActivity ReadExternalActivityFromDataReader (IDataRecord reader)
        {
            int externalActivityId = reader.GetInt32(0);
            int organizationId = reader.GetInt32(1);
            int geographyId = reader.GetInt32(2);
            DateTime dateTime = reader.GetDateTime(3);
            ExternalActivityType type = (ExternalActivityType)Enum.Parse(typeof(ExternalActivityType), reader.GetString(4));
            string description = reader.GetString(5);
            DateTime createdDateTime = reader.GetDateTime(6);
            int createdByPersonId = reader.GetInt32(7);
            int dupeOfActivityId = reader.GetInt32(8);

            return new BasicExternalActivity(externalActivityId, organizationId, geographyId, type, dateTime, description, createdByPersonId, createdDateTime, dupeOfActivityId);
        }