Exemplo n.º 1
0
        //根据高度范围查询
        public List <nacarsdata01> selectByNalt(int min, int max)
        {
            using (var context = new acarsEntities())
            {
                List <nacarsdata01> db = new List <nacarsdata01>();

                var query = context.nacarsdata01
                            .Where(nalt => nalt.naltitude >= min && nalt.naltitude < max)
                            .Select(nalt => nalt);

                foreach (var q in query)
                {
                    nacarsdata01 nacarsdata = new nacarsdata01();

                    nacarsdata.nindex         = q.nindex;
                    nacarsdata.nregister      = q.nregister;
                    nacarsdata.nflightnum     = q.nflightnum;
                    nacarsdata.nlat           = q.nlat;
                    nacarsdata.nlong          = q.nlong;
                    nacarsdata.naltitude      = q.naltitude;
                    nacarsdata.ntemperature   = q.ntemperature;
                    nacarsdata.nwinddirection = q.nwinddirection;
                    nacarsdata.nwindspeed     = q.nwindspeed;
                    nacarsdata.ndatetime      = q.ndatetime;

                    db.Add(nacarsdata);
                }

                return(db);
            }
        }
Exemplo n.º 2
0
        //查询所有
        public List <nacarsdata01> selectAll()
        {
            List <nacarsdata01> db = new List <nacarsdata01>();

            using (var context = new acarsEntities())
            {
                var query = context.nacarsdata01
                            .Select(nar => nar);

                foreach (var q in query)
                {
                    nacarsdata01 nacarsdata = new nacarsdata01();

                    nacarsdata.nindex         = q.nindex;
                    nacarsdata.nregister      = q.nregister;
                    nacarsdata.nflightnum     = q.nflightnum;
                    nacarsdata.nlat           = q.nlat;
                    nacarsdata.nlong          = q.nlong;
                    nacarsdata.naltitude      = q.naltitude;
                    nacarsdata.ntemperature   = q.ntemperature;
                    nacarsdata.nwinddirection = q.nwinddirection;
                    nacarsdata.nwindspeed     = q.nwindspeed;
                    nacarsdata.ndatetime      = q.ndatetime;

                    db.Add(nacarsdata);
                }

                return(db);
            }
        }