当前位置: 首页>>代码示例>>C#>>正文


C# IDataRecord.HasColumn方法代码示例

本文整理汇总了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;
        }
开发者ID:ognjenm,项目名称:egle,代码行数:25,代码来源:BusinessAgreementMapper.cs

示例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;
        }
开发者ID:ognjenm,项目名称:egle,代码行数:21,代码来源:PromotionMapper.cs

示例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;
        }
开发者ID:ognjenm,项目名称:egle,代码行数:46,代码来源:AgreementMapper.cs

示例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;
        }
开发者ID:ognjenm,项目名称:egle,代码行数:58,代码来源:RoomsAvailabilityMapper.cs

示例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;
        }
开发者ID:allanedk,项目名称:ActiveForums,代码行数:21,代码来源:AttachmentsDB.cs


注:本文中的IDataRecord.HasColumn方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。