public async Task <VersionData> GetVersionDataAsync(int versionId)
        {
            using (var ctx = MainProvider.CreateDataContext(CancellationToken.None))
            {
                return(await ctx.ExecuteReaderAsync("SELECT * FROM Versions WHERE VersionId = @VersionId", cmd =>
                {
                    cmd.Parameters.Add(ctx.CreateParameter("@VersionId", DbType.Int32, versionId));
                }, async (reader, cancel) =>
                {
                    if (!await reader.ReadAsync(cancel))
                    {
                        return null;
                    }

                    return new VersionData
                    {
                        VersionId = DataReaderExtension.GetInt32(reader, "VersionId"),
                        NodeId = DataReaderExtension.GetInt32(reader, "NodeId"),
                        Version = new VersionNumber(DataReaderExtension.GetInt16(reader, "MajorNumber"), DataReaderExtension.GetInt16(reader, "MinorNumber"),
                                                    (VersionStatus)DataReaderExtension.GetInt16(reader, "Status")),
                        CreationDate = reader.GetDateTimeUtc("CreationDate"),
                        CreatedById = reader.GetSafeInt32("CreatedById"),
                        ModificationDate = reader.GetDateTimeUtc("ModificationDate"),
                        ModifiedById = reader.GetSafeInt32("ModifiedById"),
                        ChangedData = reader.GetChangedData("ChangedData"),
                        Timestamp = reader.GetSafeLongFromBytes("Timestamp"),
                    };
                }));
            }
        }
예제 #2
0
파일: IMRM.cs 프로젝트: zr10728/Chloe
        public void Map(object instance, IDataReader reader, int ordinal)
        {
            object value = DataReaderExtension.GetValue(reader, ordinal);

            if (value == null)
            {
                this._valueSetter(instance, null);
                return;
            }

            value = this._mappingType.DbValueConverter.Convert(value);
            this._valueSetter(instance, value);
        }
        public async Task <NodeHeadData> GetNodeHeadDataAsync(int nodeId)
        {
            using (var ctx = MainProvider.CreateDataContext(CancellationToken.None))
            {
                return(await ctx.ExecuteReaderAsync("SELECT * FROM Nodes WHERE NodeId = @NodeId", cmd =>
                {
                    cmd.Parameters.Add(ctx.CreateParameter("@NodeId", DbType.Int32, nodeId));
                }, async (reader, cancel) =>
                {
                    if (!await reader.ReadAsync(cancel))
                    {
                        return null;
                    }

                    return new NodeHeadData
                    {
                        NodeId = DataReaderExtension.GetInt32(reader, "NodeId"),
                        NodeTypeId = DataReaderExtension.GetInt32(reader, "NodeTypeId"),
                        ContentListTypeId = reader.GetSafeInt32("ContentListTypeId"),
                        ContentListId = reader.GetSafeInt32("ContentListId"),
                        CreatingInProgress = reader.GetSafeBooleanFromByte("CreatingInProgress"),
                        IsDeleted = reader.GetSafeBooleanFromByte("IsDeleted"),
                        ParentNodeId = reader.GetSafeInt32("ParentNodeId"),
                        Name = DataReaderExtension.GetString(reader, "Name"),
                        DisplayName = reader.GetSafeString("DisplayName"),
                        Path = DataReaderExtension.GetString(reader, "Path"),
                        Index = reader.GetSafeInt32("Index"),
                        Locked = reader.GetSafeBooleanFromByte("Locked"),
                        LockedById = reader.GetSafeInt32("LockedById"),
                        ETag = DataReaderExtension.GetString(reader, "ETag"),
                        LockType = reader.GetSafeInt32("LockType"),
                        LockTimeout = reader.GetSafeInt32("LockTimeout"),
                        LockDate = reader.GetDateTimeUtc("LockDate"),
                        LockToken = DataReaderExtension.GetString(reader, "LockToken"),
                        LastLockUpdate = reader.GetDateTimeUtc("LastLockUpdate"),
                        LastMinorVersionId = reader.GetSafeInt32("LastMinorVersionId"),
                        LastMajorVersionId = reader.GetSafeInt32("LastMajorVersionId"),
                        CreationDate = reader.GetDateTimeUtc("CreationDate"),
                        CreatedById = reader.GetSafeInt32("CreatedById"),
                        ModificationDate = reader.GetDateTimeUtc("ModificationDate"),
                        ModifiedById = reader.GetSafeInt32("ModifiedById"),
                        IsSystem = reader.GetSafeBooleanFromByte("IsSystem"),
                        OwnerId = reader.GetSafeInt32("OwnerId"),
                        SavingState = reader.GetSavingState("SavingState"),
                        Timestamp = reader.GetSafeLongFromBytes("Timestamp"),
                    };
                }));
            }
        }