本文整理汇总了C#中System.Data.Common.DbDataReader.GetInt32方法的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader.GetInt32方法的具体用法?C# DbDataReader.GetInt32怎么用?C# DbDataReader.GetInt32使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbDataReader
的用法示例。
在下文中一共展示了DbDataReader.GetInt32方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ReadPersonFromDataReader
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);
}
示例2: ReadGeographyFromDataReader
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);
}
示例3: ReadOutboundInvoiceItemFromDataReader
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);
}
示例4: ReadGeographyDesignationFromDataReader
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);
}
示例5: ReadCityFromDataReader
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);
}
示例6: ReadPostalCodeFromDataReader
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);
}
示例7: ReadOutboundMailRecipientFromDataReader
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);
}
示例8: ReadCountryFromDataReader
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);
}
示例9: ReadChurnDataPointFromDataReader
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);
}
示例10: ReadPersonRoleFromDataReader
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);
}
示例11: ReadAutoMailFromDataReader
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);
}
示例12: ReadPayrollAdjustmentFromDataReader
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);
}
示例13: ReadExternalCredentialFromDataReader
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);
}
示例14: ReadOrganizationFromDataReader
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);
}
示例15: ExceptionLogFromDataReader
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);
}