本文整理汇总了C#中System.Data.Common.DbDataReader.GetInt64方法的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader.GetInt64方法的具体用法?C# DbDataReader.GetInt64怎么用?C# DbDataReader.GetInt64使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbDataReader
的用法示例。
在下文中一共展示了DbDataReader.GetInt64方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: WorkoutPlan
public WorkoutPlan(DbDataReader reader)
{
_id = reader.GetInt64(0);
_title = reader.GetValue(1).ToString() == "" ? "" : reader.GetString(1);
_period = reader.GetValue(2).ToString() == "" ? (byte)0 : reader.GetByte(2);
_creatorId = reader.GetValue(3).ToString() == "" ? 0 : reader.GetInt64(3);
}
示例2: Map
public SelectedSnapshot Map(DbDataReader reader)
{
var persistenceId = reader.GetString(0);
var sequenceNr = reader.GetInt64(1);
var timestamp = new DateTime(reader.GetInt64(2));
var metadata = new SnapshotMetadata(persistenceId, sequenceNr, timestamp);
var snapshot = GetSnapshot(reader);
return new SelectedSnapshot(metadata, snapshot);
}
示例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: Map
public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null)
{
var persistenceId = reader.GetString(0);
var sequenceNr = reader.GetInt64(1);
var isDeleted = reader.GetBoolean(2);
var payload = GetPayload(reader);
return new Persistent(payload, sequenceNr, persistenceId, isDeleted, sender);
}
示例5: Map
public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null)
{
var persistenceId = reader.GetString(PersistenceIdIndex);
var sequenceNr = reader.GetInt64(SequenceNrIndex);
var isDeleted = reader.GetBoolean(IsDeletedIndex);
var manifest = reader.GetString(ManifestIndex);
// timestamp is SQL-journal specific field, it's not a part of casual Persistent instance
var payload = GetPayload(reader, manifest);
return new Persistent(payload, sequenceNr, persistenceId, manifest, isDeleted, sender);
}
示例6: 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);
}
示例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: 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);
}
示例9: 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));
}
}
}
示例10: WorkType
/// <summary>
/// Конструктор класса WorkType
/// </summary>
public WorkType(DbDataReader reader)
{
this._id = reader.GetInt16(0);
this._sportTypeId = reader.GetByte(1);
this._userId = reader.GetInt64(2);
this._count = reader.GetInt32(3);
this._value = reader.GetString(4);
}
示例11: ProcessRecord
private void ProcessRecord(DbDataReader record, DbOperation dbOperation)
#endif
{
var id = record.GetInt64(0);
ScaleoutMessage message = SqlPayload.FromBytes(record);
_logger.LogVerbose(String.Format("{0}SqlReceiver last payload ID={1}, new payload ID={2}", _loggerPrefix, _lastPayloadId, id));
if (id > _lastPayloadId + 1)
{
_logger.LogError(String.Format("{0}Missed message(s) from SQL Server. Expected payload ID {1} but got {2}.", _loggerPrefix, _lastPayloadId + 1, id));
}
else if (id <= _lastPayloadId)
{
_logger.LogInformation(String.Format("{0}Duplicate message(s) or payload ID reset from SQL Server. Last payload ID {1}, this payload ID {2}", _loggerPrefix, _lastPayloadId, id));
}
_lastPayloadId = id;
// Update the Parameter with the new payload ID
dbOperation.Parameters[0].Value = _lastPayloadId;
_logger.LogVerbose(String.Format("{0}Updated receive reader initial payload ID parameter={1}", _loggerPrefix, _dbOperation.Parameters[0].Value));
_logger.LogVerbose(String.Format("{0}Payload {1} containing {2} message(s) received", _loggerPrefix, id, message.Messages.Count));
Received((ulong)id, message);
}
示例12: ReadInternal
protected override object ReadInternal(DbDataReader reader, int ordinal, SqlRandomTableColumn columnInfo, Type asType)
{
ValidateReadType(typeof(Int64), asType);
if (reader.IsDBNull(ordinal))
return DBNull.Value;
return reader.GetInt64(ordinal);
}
示例13: Workout
/// <summary>
/// Конструктор класса Workout
/// </summary>
public Workout(DbDataReader reader)
{
this._id = reader.GetValue(0).ToString() == "" ? (long)0 : reader.GetInt64(0);
this._date = reader.GetValue(1).ToString() == "" ? (long)0 : reader.GetInt64(1);
this._timeBegin = reader.GetValue(2).ToString() == "" ? (long)0 : reader.GetInt64(2);
this._timeEnd = reader.GetValue(3).ToString() == "" ? (long)0 : reader.GetInt64(3);
this._warmUp = reader.GetValue(4).ToString() == "" ? (byte)0 : reader.GetByte(4);
this._musclesGroupId = reader.GetValue(5).ToString() == "" ? (Int16)0 : reader.GetInt16(5);
this._workoutPlanId = reader.GetValue(6).ToString() == "" ? (long)0 : reader.GetInt64(6);
this._workoutTypeId = reader.GetValue(7).ToString() == "" ? (Int16)0 : reader.GetInt16(7);
this._athleteId = reader.GetValue(8).ToString() == "" ? (long)0 : reader.GetInt64(8);
this._createDate = reader.GetValue(9).ToString() == "" ? (long)0 : reader.GetInt64(9);
this._workoutPlanTypeId = reader.GetValue(10).ToString() == "" ? (Int16)0 : reader.GetInt16(10);
}
示例14: ReadFinancialTransactionRowFromDataReader
private BasicFinancialTransactionRow ReadFinancialTransactionRowFromDataReader(DbDataReader reader)
{
int rowId = reader.GetInt32(0);
int accountId = reader.GetInt32(1);
int transactionId = reader.GetInt32(2);
Int64 amountCents = reader.GetInt64(3);
DateTime createdDateTime = reader.GetDateTime(4);
int createdByPersonId = reader.GetInt32(5);
return new BasicFinancialTransactionRow(rowId, accountId, transactionId, amountCents, createdDateTime, createdByPersonId);
}
示例15: 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);
}