Esempio n. 1
0
        public IEnumerable <Copybook> GetCopybooks(int typeId)
        {
            using (SqlCommand command = _connection.CreateCommand())
            {
                command.CommandText = @"SELECT Tb_CopyBook.Id,Tb_CopyBook.Title,Tb_CopybookType.TypeName,Tb_CopyBook.Author,Tb_CopyBook.FontType,Tb_CopyBook.Content FROM Tb_CopyBook 
                                            LEFT JOIN Tb_CopybookType on Tb_CopyBook.TypeId=Tb_CopybookType.TypeId 
											WHERE Tb_CopyBook.TypeId=@typeId
                                            ORDER BY Tb_CopyBook.TypeId,Tb_CopyBook.Title";

                command.Parameters.AddWithValue("@typeId", typeId);

                SqlDataReader reader = GetSqlDataReader(command);
                while (reader.Read())
                {
                    Copybook book = new Copybook
                    {
                        Id       = reader.GetGuid(0),
                        Title    = reader.GetString(1),
                        BookType = reader.GetString(2),
                        Author   = reader.GetString(3),
                        FontType = reader.GetString(4),
                        Content  = reader.GetString(5)
                    };
                    yield return(book);
                }
                reader.Close();
                CloseConnection();
            }
        }
Esempio n. 2
0
 public UserPlay(Clock startsAt, Copybook copybook)
 {
     StartsAt = startsAt;
     FinishesAt = startsAt + (copybook.FinishesAt - copybook.StartsAt);
     Copybook = copybook;
     Notes = copybook.Select(note => MoveCopybookNotesBasedOnLocalClock(note)).ToList();
 }
Esempio n. 3
0
    void Awake()
    {
        var tempo = 130f;

        var notes = new List<Note>()
        {
            new Note(new Clock(tempo , 4 * 0 + 0), NoteNumber.C),
            new Note(new Clock(tempo , 4 * 0 + 1), NoteNumber.D),
            new Note(new Clock(tempo , 4 * 0 + 2), NoteNumber.E),
            new Note(new Clock(tempo , 4 * 0 + 3), NoteNumber.E),
            new Note(new Clock(tempo , 4 * 1 + 1), NoteNumber.D),
            new Note(new Clock(tempo , 4 * 1 + 2), NoteNumber.C),
        };

        var copybook = new Copybook(new Clock(tempo, 4 * 0), new Clock(tempo, 4 * 4), notes);
        var userplay = new UserPlay(new Clock(tempo, 4 * 4), copybook);

        var phases = new List<IPlayPhase>()
        {
            copybook,
            userplay,
        };

        Score = new Score(phases);
    }
    public void BasicRecordWithoutOptions()
    {
        Copybook book = this.testSingleSentence(
            "01 TOP.",
            new BasicRecord()
        {
            Level = new Int()
            {
                Value = "01"
            },
            LevelName = new LevelName()
            {
                HasFiller  = false,
                Identifier = new Identifier()
                {
                    Name = "TOP"
                }
            },
            Options = new List <Option>()
            {
            }
        }
            );

        Assert.AreEqual(((BasicRecord)book.Records[0]).Level.Value, "01");
    }
    private Copybook testSingleSentence(string src, Record expected)
    {
        Copybook book = this.parse(src);

        Assert.AreEqual(1, book.Records.Count);
        Assert.AreEqual(expected.ToString(), book.Records[0].ToString());
        return(book);
    }
Esempio n. 6
0
        /// <summary>
        /// @see AbstractItemCountingItemStreamItemReader#DoOpen
        /// </summary>
        protected override void DoOpen()
        {
            Assert.IsTrue(Resource.Exists(), "The input file must exist.");
            _inputStream = new BufferedStream(Resource.GetInputStream());

            FileFormat fileFormat = CopybookLoader.LoadCopybook(Copybook.GetInputStream());

            _reader = new EbcdicReader(_inputStream, fileFormat, Rdw);
            EbcdicReaderMapper.RecordFormatMap = new RecordFormatMap(fileFormat);

            _nbRead = 0;
            Name    = string.Concat("EbcdicFileReader.", Resource.GetFilename());
        }
Esempio n. 7
0
        public IEnumerable <Copybook> GetCopybooks()
        {
            SqlDataReader reader = GetSqlDataReader(@"SELECT Tb_CopyBook.Id,Tb_CopyBook.Title,Tb_CopybookType.TypeName,Tb_CopyBook.Author,Tb_CopyBook.FontType,Tb_CopyBook.Content FROM Tb_CopyBook 
                                            LEFT JOIN Tb_CopybookType on Tb_CopyBook.TypeId=Tb_CopybookType.TypeId 
                                            ORDER BY Tb_CopyBook.TypeId,Tb_CopyBook.Title");

            while (reader.Read())
            {
                Copybook book = new Copybook
                {
                    Id       = reader.GetGuid(0),
                    Title    = reader.GetString(1),
                    BookType = reader.GetString(2),
                    Author   = reader.GetString(3),
                    FontType = reader.GetString(4),
                    Content  = reader.GetString(5)
                };
                yield return(book);
            }
            reader.Close();
            CloseConnection();
        }