本文整理汇总了C#中System.Data.Common.DbDataReader.GetDateTime方法的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader.GetDateTime方法的具体用法?C# DbDataReader.GetDateTime怎么用?C# DbDataReader.GetDateTime使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbDataReader
的用法示例。
在下文中一共展示了DbDataReader.GetDateTime方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ReadOutboundInvoiceFromDataReader
private BasicOutboundInvoice ReadOutboundInvoiceFromDataReader(DbDataReader reader)
{
int outboundInvoiceId = reader.GetInt32(0);
string customerName = reader.GetString(1);
string invoiceAddressPaper = reader.GetString(2);
string invoiceAddressMail = reader.GetString(3);
int currencyId = reader.GetInt32(4);
// double amount = reader.GetDouble(5);
int organizationId = reader.GetInt32(6);
int budgetId = reader.GetInt32(7);
DateTime createdDateTime = reader.GetDateTime(8);
int createdByPersonId = reader.GetInt32(9);
DateTime dueDate = reader.GetDateTime(10);
int reminderCount = reader.GetInt32(11);
string reference = reader.GetString(12);
bool domestic = reader.GetBoolean(13);
bool open = reader.GetBoolean(14);
bool sent = reader.GetBoolean(15);
string securityCode = reader.GetString(16);
string theirReference = reader.GetString(17);
return new BasicOutboundInvoice(outboundInvoiceId, customerName, invoiceAddressPaper, invoiceAddressMail,
currencyId, organizationId, budgetId, createdDateTime,
createdByPersonId, dueDate, reminderCount, reference, domestic, open, sent, securityCode, theirReference);
}
示例2: 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);
}
示例3: GetDateTime
public static DateTime? GetDateTime(DbDataReader reader, int index)
{
if (reader.IsDBNull(index))
return null;
else
return reader.GetDateTime(index);
}
示例4: 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);
}
示例5: ReadPWEventFromDataReader
private BasicPWEvent ReadPWEventFromDataReader (DbDataReader reader)
{
int eventId = reader.GetInt32(0);
EventType eventType = (EventType)Enum.Parse(typeof(EventType), reader.GetString(1));
EventSource eventSource = (EventSource)Enum.Parse(typeof(EventSource), reader.GetString(2));
int actingPersonId = reader.GetInt32(3);
int affectedPersonId = reader.GetInt32(4);
DateTime eventDateTime = reader.GetDateTime(5);
DateTime processedDateTime = reader.GetDateTime(6);
bool open = reader.GetBoolean(7);
int organizationId = reader.GetInt32(8);
int geographyId = reader.GetInt32(9);
int parameterInt = reader.GetInt32(10);
string parameterText = reader.GetString(11);
return new BasicPWEvent(eventId, eventDateTime, open, processedDateTime, eventType, eventSource, actingPersonId,
affectedPersonId, organizationId, geographyId, parameterInt, parameterText);
}
示例6: 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);
}
示例7: ReadPayrollItemFromDataReader
private BasicPayrollItem ReadPayrollItemFromDataReader(DbDataReader reader)
{
int payrollItemId = reader.GetInt32(0);
int personId = reader.GetInt32(1);
int organizationId = reader.GetInt32(2);
int countryId = reader.GetInt32(3);
DateTime employedDate = reader.GetDateTime(4);
int reportsToPersonId = reader.GetInt32(5);
Int64 baseSalaryCents = reader.GetInt64(6);
int budgetId = reader.GetInt32(7);
bool open = reader.GetBoolean(8);
DateTime terminatedDate = reader.GetDateTime(9);
int subtractiveTaxLevelId = reader.GetInt32(10);
double additiveTaxLevel = reader.GetDouble(11);
return new BasicPayrollItem(payrollItemId, personId, organizationId, countryId, employedDate,
reportsToPersonId, baseSalaryCents, budgetId, open, terminatedDate, subtractiveTaxLevelId, additiveTaxLevel);
}
示例8: Map
public SelectedSnapshot Map(DbDataReader reader)
{
var persistenceId = reader.GetString(0);
var sequenceNr = reader.GetInt64(1);
var timestamp = reader.GetDateTime(2);
var metadata = new SnapshotMetadata(persistenceId, sequenceNr, timestamp);
var snapshot = GetSnapshot(reader);
return new SelectedSnapshot(metadata, snapshot);
}
示例9: ReadInternalPollFromDataReader
private BasicInternalPoll ReadInternalPollFromDataReader(DbDataReader reader)
{
int internalPollId = reader.GetInt32(0);
int organizationId = reader.GetInt32(1);
int geographyId = reader.GetInt32(2);
string name = reader.GetString(3);
bool runningOpen = reader.GetBoolean(4);
bool votingOpen = reader.GetBoolean(5);
int maxVoteLength = reader.GetInt32(6);
int createdByPersonId = reader.GetInt32(7);
DateTime runningOpens = reader.GetDateTime(8);
DateTime runningCloses = reader.GetDateTime(9);
DateTime votingOpens = reader.GetDateTime(10);
DateTime votingCloses = reader.GetDateTime(11);
int resultsTypeId = reader.GetInt32(12);
InternalPollResultsType resultsType = (InternalPollResultsType) resultsTypeId;
return new BasicInternalPoll(internalPollId, createdByPersonId, organizationId, geographyId, name, runningOpen, votingOpen, maxVoteLength, runningOpens, runningCloses, votingOpens, votingCloses, resultsType);
}
示例10: ReadInboundInvoiceFromDataReader
private BasicInboundInvoice ReadInboundInvoiceFromDataReader(DbDataReader reader)
{
int inboundInvoiceId = reader.GetInt32(0);
int organizationId = reader.GetInt32(1);
DateTime createdDateTime = reader.GetDateTime(2);
int createdByPersonId = reader.GetInt32(3);
DateTime dueDate = reader.GetDateTime(4);
Int64 amountCents = reader.GetInt64(5);
int budgetId = reader.GetInt32(6);
bool attested = reader.GetBoolean(7);
bool open = reader.GetBoolean(8);
string supplier = reader.GetString(9);
string payToAccount = reader.GetString(10);
string ocr = reader.GetString(11);
string invoiceReference = reader.GetString(12);
DateTime closedDateTime = reader.GetDateTime(13);
int closedByPersonId = reader.GetInt32(14);
return new BasicInboundInvoice(inboundInvoiceId, organizationId, createdDateTime, dueDate,
amountCents, budgetId, supplier, payToAccount, ocr, invoiceReference,
attested, open, closedDateTime, closedByPersonId);
}
示例11: mapValues
private void mapValues(DbDataReader reader, object record)
{
foreach (var accessor in this.accessors) {
var index = reader.GetOrdinal(accessor.Name);
if (reader.IsDBNull(index)) {
continue;
}
if (accessor.PropertyType == typeof(string)) {
accessor.Set(record, reader.GetString(index));
} else if (accessor.PropertyType == typeof(int) || accessor.PropertyType == typeof(int?)) {
accessor.Set(record, reader.GetInt32(index));
} else if (accessor.PropertyType == typeof(long) || accessor.PropertyType == typeof(long?)) {
accessor.Set(record, reader.GetInt64(index));
} else if (accessor.PropertyType == typeof(DateTime) || accessor.PropertyType == typeof(DateTime?)) {
accessor.Set(record, reader.GetDateTime(index));
} else if (accessor.PropertyType == typeof(char) || accessor.PropertyType == typeof(char?)) {
accessor.Set(record, reader.GetChar(index));
}
}
}
示例12: GetUserFromReader
MembershipUser GetUserFromReader (DbDataReader reader)
{
return new MembershipUser (this.Name, /* XXX is this right? */
reader.GetString (0), /* name */
reader.GetGuid (1), /* providerUserKey */
reader.IsDBNull (2) ? null : reader.GetString (2), /* email */
reader.IsDBNull (3) ? null : reader.GetString (3), /* passwordQuestion */
reader.IsDBNull (4) ? null : reader.GetString (4), /* comment */
reader.GetBoolean (5), /* isApproved */
reader.GetBoolean (6), /* isLockedOut */
reader.GetDateTime (7).ToLocalTime (), /* creationDate */
reader.GetDateTime (8).ToLocalTime (), /* lastLoginDate */
reader.GetDateTime (9).ToLocalTime (), /* lastActivityDate */
reader.GetDateTime (10).ToLocalTime (), /* lastPasswordChangedDate */
reader.GetDateTime (11).ToLocalTime () /* lastLockoutDate */);
}
示例13: IterateMessages
private static IEnumerable<Msg> IterateMessages(DbDataReader reader)
{
while(!reader.IsClosed && reader.Read())
{
yield return
new Msg
{
Time = reader.GetDateTime(0),
Type = reader.TryGetString(1).TryParseOrDefault(MsgType.Unknown),
Text = reader.TryGetString(2)
};
}
}
示例14: ReadFinancialAccountRowFromDataReader
private BasicFinancialAccountRow ReadFinancialAccountRowFromDataReader (DbDataReader reader)
{
int accountId = reader.GetInt32(0);
int transactionId = reader.GetInt32(1);
DateTime transactionDateTime = reader.GetDateTime(2);
string comment = reader.GetString(3);
Int64 amountCents = reader.GetInt64(4);
DateTime rowDateTime = reader.GetDateTime(5);
int rowCreatedByPersonId = reader.GetInt32(6);
return new BasicFinancialAccountRow(accountId, transactionId, transactionDateTime, comment, amountCents, rowDateTime, rowCreatedByPersonId);
}
示例15: ReadFinancialTransactionFromDataReader
private BasicFinancialTransaction ReadFinancialTransactionFromDataReader (DbDataReader reader)
{
int transactionId = reader.GetInt32(0);
int organizationId = reader.GetInt32(1);
DateTime dateTime = reader.GetDateTime(2);
string comment = reader.GetString(3);
string importHash = reader.GetString(4);
return new BasicFinancialTransaction(transactionId, organizationId, dateTime, comment, importHash);
}