2007-02-28工作安排

1.cinrad的中间状态表,关机状态记录重做.

2.自动气象站中心站Web版的功能需求,材料收集.

3.与Gst公司联系briefnet相关事宜.

 

######################################

Z9834
Z9555
Z9476
Z9912
 
SQL> select radar_status,count(radar_status)
 from CINRAD_EVLUATION_INFO
 where stationnum =‘Z9834‘
 group by radar_status;

       1
       4
       3
       0

SQL> select distinct radar_status
  2  from CINRAD_EVLUATION_INFO
  3  where stationnum =‘Z9555‘;

           1

SQL> select distinct radar_status
  2  from CINRAD_EVLUATION_INFO
  3  where stationnum =‘Z9476‘;

           1

SQL> select distinct radar_status
  2  from CINRAD_EVLUATION_INFO
  3  where stationnum =‘Z9912‘;

           1
           4
           0

###################################
SQL> select radar_status,count(radar_status)
  2   from CINRAD_EVLUATION_INFO
  3   where stationnum =‘Z9834‘
  4   group by radar_status;

           1                   1
           4                  16
           3                   1
           0                 269

SQL> select radar_status,count(radar_status)
     from CINRAD_EVLUATION_INFO
     where stationnum =‘Z9912‘
     group by radar_status;

           1                   1
           4                   1
           0                 265

SQL> select radar_status,count(radar_status)
     from CINRAD_EVLUATION_INFO
     where stationnum =‘Z9555‘
     group by radar_status;
           1                 134

SQL> select radar_status,count(radar_status)
     from CINRAD_EVLUATION_INFO
     where stationnum =‘Z9476‘
     group by radar_status;

           1                 711

################################################
select status_time,radar_status
from CINRAD_EVLUATION_INFO
where stationnum=‘Z9476‘
and status_date=‘20070228‘
order by status_time;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9476‘
and status_date=‘20070228‘
and status_time>=‘151000‘;

select status_time,radar_status
from CINRAD_HIS_EVLUATION_INFO
where stationnum=‘Z9912‘
and status_date=‘20070228‘
order by status_time;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9912‘
and status_date=‘20070228‘
and status_time>=‘153000‘;

select status_time,radar_status
from CINRAD_HIS_EVLUATION_INFO
where stationnum=‘Z9551‘
and status_date=‘20070228‘
order by status_time;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9551‘
and status_date=‘20070228‘
and status_time>=‘150000‘;

select status_time,radar_status
from CINRAD_HIS_EVLUATION_INFO
where stationnum=‘Z9555‘
and status_date=‘20070228‘
order by status_time;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9555‘
and status_date=‘20070228‘
and status_time>=‘154000‘;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘5‘
where stationnum=‘Z9453‘
and status_date=‘20070228‘
and status_time>=‘151000‘;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9532‘
and status_date=‘20070228‘
and status_time>=‘150000‘;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9834‘
and status_date=‘20070228‘
and status_time>=‘154000‘;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9817‘
and status_date=‘20070228‘
and status_time>=‘145000‘;

#################################
更新实时表中的
Z9555
Z9476

select count(*) from CINRAD_EVLUATION_INFO
where STATIONNUM = ‘Z9555‘;
delete from CINRAD_EVLUATION_INFO
where STATIONNUM = ‘Z9555‘;
insert into CINRAD_EVLUATION_INFO
(select * from CINRAD_HIS_EVLUATION_INFO
where STATIONNUM = ‘Z9555‘
and status_date > ‘20070225‘);

select count(*) from CINRAD_EVLUATION_INFO
where STATIONNUM = ‘Z9476‘;
delete from CINRAD_EVLUATION_INFO
where STATIONNUM = ‘Z9476‘;
insert into CINRAD_EVLUATION_INFO
(select * from CINRAD_HIS_EVLUATION_INFO
where STATIONNUM = ‘Z9476‘
and status_date > ‘20070225‘);