本文整理汇总了C#中IDataRecord.HasColumn方法的典型用法代码示例。如果您正苦于以下问题:C# IDataRecord.HasColumn方法的具体用法?C# IDataRecord.HasColumn怎么用?C# IDataRecord.HasColumn使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IDataRecord
的用法示例。
在下文中一共展示了IDataRecord.HasColumn方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: MapRecord
/// <summary>
/// Map the basic fields for the BusinessAgreement table to the BusinessAgreement model object
/// </summary>
/// <param name="record">The SqlDataReader with the executed query result</param>
/// <param name="prefix">a prefix used to identify fields for the BusinessAgreement model in the resultset if required</param>
/// <returns>An instance of Model.Business.BusinessAgreement</returns>
internal static BusinessAgreement MapRecord(IDataRecord record, string prefix = "")
{
var businessAgreement = new BusinessAgreement
{
Id = DbHelper.ConvertValue<int>(record[prefix + SelectParameters.Id]),
BusinessId = DbHelper.ConvertValue<long>(record[prefix + SelectParameters.BusinessId]),
AgreementId = DbHelper.ConvertValue<int>(record[prefix + SelectParameters.AgreementId]),
UpdatedByUserId = DbHelper.ConvertValue<Guid>(record[prefix + SelectParameters.UpdatedByUserId]),
UpdatedDateTime = DbHelper.ConvertValue<DateTime>(record[prefix + SelectParameters.UpdatedDatetime])
};
if (record.HasColumn(prefix + SelectParameters.AgreementTypeCode))
{
businessAgreement.LinkedAgreementType =
DbHelper.ConvertEnumValue<AgreementType>(record[prefix + SelectParameters.AgreementTypeCode]);
}
return businessAgreement;
}
示例2: MapRecord
internal static Promotion MapRecord(IDataRecord record, string prefix = "")
{
var promotion = new Promotion
{
AdditionalInformation = DbHelper.ConvertValue<string>(record[prefix + Parameters.AdditionalInformation]),
ApplicableDaysString = DbHelper.ConvertValue<string>(record[prefix + Parameters.ApplicableDays]),
AvailableHours = DbHelper.ConvertValue<int>(record[prefix + Parameters.AvailableNumberOfHours]),
AvailableStatus = DbHelper.ConvertEnumValue<AvailableStatus>(record[prefix + Parameters.AvailableStatusCode]),
BusinessId = DbHelper.ConvertValue<long>(record[prefix + Parameters.BusinessId]),
Discount = DbHelper.ConvertValue<decimal>(record[prefix + Parameters.Discount]),
DisplayName = DbHelper.ConvertValue<string>(record[prefix + Parameters.DisplayName]),
Id = DbHelper.ConvertValue<int>(record[prefix + Parameters.Id]),
Name = DbHelper.ConvertValue<string>(record[prefix + Parameters.Name]),
Status = new PromotionStatus { Type = DbHelper.ConvertEnumValue<PromotionStatusEnum>(record[prefix + Parameters.PromotionStatusCode]) },
AssociatedRatePlanCount = record.HasColumn(prefix + Parameters.AssociatedRatePlanCount) ? DbHelper.ConvertValue<int>(record[prefix + Parameters.AssociatedRatePlanCount]) : -1,
StayStartDate = DbHelper.ConvertValue<DateTime?>(record[prefix + Parameters.StayStartDate]),
StayEndDate = DbHelper.ConvertValue<DateTime?>(record[prefix + Parameters.StayEndDate])
};
return promotion;
}
示例3: MapRecord
/// <summary>
/// Map the basic fields for the Agreement table to the Agreement model object
/// </summary>
/// <param name="record">The SqlDataReader with the executed query result</param>
/// <param name="prefix">a prefix used to identify fields for the Agreement model in the resultset if required</param>
/// <returns>An instance of Model.Business.Agreement</returns>
internal static Agreement MapRecord(IDataRecord record, string prefix = "")
{
var resultAgreement = new Agreement
{
Id = DbHelper.ConvertValue<int>(record[prefix + SelectParameters.Id]),
AgreementType = DbHelper.ConvertEnumValue<AgreementType>(record[prefix + SelectParameters.AgreementTypeCode]),
AgreementTypeName = DbHelper.ConvertValue<string>(record[prefix + SelectParameters.AgreementTypeName]),
BusinessIdsNeedingAgreement = new List<long>(),
BusinessNames = string.Empty,
Name = DbHelper.ConvertValue<string>(record[prefix + SelectParameters.Name]),
CountryId = DbHelper.ConvertValue<int?>(record[prefix + SelectParameters.CountryId]),
CountryName = DbHelper.ConvertValue<string>(record[prefix + SelectParameters.CountryName]),
AgreementStatus = DbHelper.ConvertEnumValue<AgreementStatus>(record[prefix + SelectParameters.AgreementStatusCode]),
ContentType = DbHelper.ConvertEnumValue<ContentTypeEnum>(record[prefix + SelectParameters.ContentTypeCode]),
AgreementText = DbHelper.ConvertValue<string>(record[prefix + SelectParameters.AgreementText]),
IsCurrent = DbHelper.ConvertValue<bool>(record[prefix + SelectParameters.IsCurrent]),
PublishedDateTime = DbHelper.ConvertValue<DateTime>(record[prefix + SelectParameters.PublishedDatetime]),
UpdatedByUserId = DbHelper.ConvertValue<Guid>(record[prefix + SelectParameters.UpdatedByUserId]),
UpdatedDateTime = DbHelper.ConvertValue<DateTime>(record[prefix + SelectParameters.UpdatedDatetime])
};
if (record.HasColumn(prefix + SelectParameters.BusinessNames))
{
resultAgreement.BusinessNames = DbHelper.ConvertValue<string>(record[prefix + SelectParameters.BusinessNames]);
}
if (record.HasColumn(prefix + SelectParameters.BusinessIds))
{
var businessIds = DbHelper.ConvertValue<string>(record[prefix + SelectParameters.BusinessIds]);
var idsAsString = new List<string>();
if (string.IsNullOrWhiteSpace(businessIds) == false)
{
idsAsString = businessIds.Split(',').ToList();
}
resultAgreement.BusinessIdsNeedingAgreement = idsAsString.ConvertAll(long.Parse);
}
return resultAgreement;
}
示例4: MapRecord
/// <summary>
/// Map the basic fields for the RoomsAvailability table to the RoomsAvailability model object
/// </summary>
/// <param name="record">The SqlDataReader with the executed query result</param>
/// <param name="prefix">a prefix used to identify fields for the RoomsAvailability model in the resultset if required</param>
/// <returns>An instance of Model.Room.RoomsAvailability</returns>
internal static RoomsAvailability MapRecord(IDataRecord record, string prefix = "")
{
var roomsAvailability = new RoomsAvailability
{
BusinessId = DbHelper.ConvertValue<long>(record[prefix + Parameters.BusinessId]),
RoomTypeId = DbHelper.ConvertValue<int>(record[prefix + Parameters.RoomTypeId]),
BaseRatePlanId = DbHelper.ConvertValue<int>(record[prefix + Parameters.BaseRatePlanId]),
RatePlanId = DbHelper.ConvertValue<int>(record[prefix + Parameters.RatePlanId]),
MaxAdults = DbHelper.ConvertValue<byte>(record[prefix + Parameters.MaxAdults]),
MaxChildren = DbHelper.ConvertValue<byte>(record[prefix + Parameters.MaxChildren]),
MaxOccupancy = DbHelper.ConvertValue<byte>(record[prefix + Parameters.MaxOccupancy]),
MinStay = DbHelper.ConvertValue<byte>(record[prefix + Parameters.MinStay]),
BoardBasis = new BoardBasis { Code = DbHelper.ConvertValue<string>(record[prefix + Parameters.BoardBasisCode]) },
CancellationClass = new CancellationClass { Code = DbHelper.ConvertValue<string>(record[prefix + Parameters.CancellationClassCode]) },
TotalRate = DbHelper.ConvertValue<decimal>(record[prefix + Parameters.Rate], nullReplace: default(decimal)),
TotalWasRate = DbHelper.ConvertValue<decimal?>(record[prefix + Parameters.WasRate]),
Available = DbHelper.ConvertValue<byte>(record[prefix + Parameters.Available]),
RatePlanName = DbHelper.ConvertValue<string>(record[prefix + Parameters.RatePlanName]),
DisplayName = DbHelper.ConvertValue<string>(record[prefix + Parameters.DisplayName]),
PrePayType = DbHelper.ConvertEnumValue<PrePayRuleTypeEnum>(record[prefix + Parameters.PrePayRuleTypeCode]),
PrePayRuleValue = DbHelper.ConvertValue<decimal?>(record[prefix + Parameters.PrePayRuleValue])
};
var unavailabilityList = DbHelper.ConvertValue<string>(record[prefix + Parameters.NoAvailabilityCode]);
if (string.IsNullOrWhiteSpace(unavailabilityList) == false)
{
roomsAvailability.UnavailabilityReason =
DbHelper.ConvertEnumValue<UnavailabilityReasonCode>(unavailabilityList.Split(',')[0]);
}
if (roomsAvailability.UnavailabilityReason == UnavailabilityReasonCode.Unknown)
{
roomsAvailability.UnavailabilityReason = null;
}
// if we have a room list then we will have a corresponding room name list
if (record.HasColumn(Parameters.RoomList.ToString()))
{
var roomList = DbHelper.ConvertValue<string>(record[prefix + Parameters.RoomList]);
var roomNameList = DbHelper.ConvertValue<string>(record[prefix + Parameters.RoomNameList]);
// only split and convert if not an empty string
if (string.IsNullOrWhiteSpace(roomList) == false)
{
roomsAvailability.RoomList = roomList.Split(',').ToList().ConvertAll(int.Parse);
roomsAvailability.RoomNameList = roomNameList.Split(',').ToList();
}
}
return roomsAvailability;
}
示例5: FillAttachment
private static PermissionAttachment FillAttachment(IDataRecord dr)
{
var result = new PermissionAttachment
{
AttachmentId = Utilities.SafeConvertInt(dr["AttachId"]),
UserId = Utilities.SafeConvertInt(dr["UserId"], -1),
FileName = Utilities.SafeConvertString(dr["FileName"]),
ContentType = Utilities.SafeConvertString(dr["ContentType"]),
FileSize = Utilities.SafeConvertLong(dr["FileSize"]),
FileId = dr["FileId"] as int?,
AllowDownload = Utilities.SafeConvertBool(dr["AllowDownload"], true)
};
if (dr.HasColumn("FileData"))
result.FileData = dr["FileData"] as byte[];
if (dr.HasColumn("CanRead"))
result.CanRead = Utilities.SafeConvertString(dr["CanRead"], "0;1;-3;-1;|||"); // Default to public read permissions
return result;
}