コード例 #1
0
ファイル: DBConnection.cs プロジェクト: taquinil-selei/omnius
        public ListJson <DBItem> Read(DBReader reader, Tabloid tabloid)
        {
            ListJson <DBItem> items = new ListJson <DBItem>();

            while (reader.Read())
            {
                DBItem newItem = new DBItem(this, tabloid);

                for (int i = 0; i < reader.FieldCount; i++)
                {
                    string columnName = reader.GetName(i);
                    newItem[columnName] = reader[columnName];
                }

                items.Add(newItem);
            }

            return(items);
        }
コード例 #2
0
        protected override ListJson <DBItem> Read(SqlDataReader reader)
        {
            ListJson <DBItem> items = new ListJson <DBItem>();

            while (reader.Read())
            {
                DBItem newItem = new DBItem();

                for (int i = 0; i < reader.FieldCount; i++)
                {
                    string columnName = reader.GetName(i);
                    // sloupec, kt. není součástí tabulky (as, count, ...)
                    DBColumn column   = tabloid.columns.SingleOrDefault(x => x.Name == columnName);
                    int      columnId = column != null ? column.ColumnId : -1;
                    newItem.createProperty(columnId, columnName, reader[columnName]);
                }

                items.Add(newItem);
            }

            return(items);
        }