コード例 #1
0
        private List <Warehouses> GetWarehousesList()
        {
            List <Warehouses> listWarehouses = new List <Warehouses>();
            DataBaseReader    dbReader       = new DataBaseReader(this.sqlConnect);

            string command = "SELECT [Warehouses].[WarehouseID], " +
                             "[Warehouses].[WarehouseName] FROM [Warehouses]";

            dbReader.GetSqlReader(command);

            while (dbReader.SqlReader.Read())
            {
                listWarehouses.Add(new Warehouses
                {
                    RowNumber     = dbReader.SqlReader[0].ToString(),
                    WarehouseName = dbReader.SqlReader[1].ToString()
                });
            }

            dbReader.CloseReader();

            return(listWarehouses);
        }