private void btnBegin_Click(object sender, EventArgs e)
{
AirForCast afc = new AirForCast();
afc.con = con;
// afc.InsertAirForeCastTJData1();
}
/// <summary>
/// 补数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnStart_Click(object sender, EventArgs e)
{
DateTime StartTime = timeStart.Value;
DateTime EndTime = timeEnd.Value;
listBox1.Items.Add("..........");
//空气质量监测数据
if (rbAirMon.Checked)
{
AirMonitor am = new AirMonitor();
am.con = con;
am.getAirHourData();
//am.getAirDayData();
//am.getCountyAirData();
//TimeSpan ts = timeEnd.Value - timeStart.Value;
//int days = int.Parse(ts.TotalDays.ToString().Split('.')[0]);
//for (int i = 0; i < days; i++)
//{
// am.getCountyAirData(0 - i);
//}
listBox1.Items.Add("空气质量检测数据更新成功！");
}
//空气质量预报数据
if (rbAirForCast.Checked)
{
AirForCast afc = new AirForCast();
afc.con = con;
if (rbNew.Checked)
{
//afc.InsertAirForeCastWRFDataNew();
//afc.InsertAirForeCastSSCIData();
afc.InsertAirForeCastCMAQData();
}
if (rbOld.Checked)
{
DateTime start = timeStart.Value.AddDays(-1);
DateTime end = timeEnd.Value;
afc.startTime = start;
afc.endTime = end;
//afc.InsertAirForeCastWRFDataNew();
afc.InsertAirForeCastSSCIData();
afc.con = con;
if (rbNew.Checked)
{
//afc.InsertAirForeCastWRFDataNew();
afc.InsertAirForeCastCMAQData();
//afc.InsertAirForeCastSSCIData();
}
if (rbOld.Checked)
{
DateTime startS = timeStart.Value.AddDays(-1);
DateTime endE = timeEnd.Value;
afc.startTime = startS;
afc.endTime = endE;
//afc.InsertAirForeCastWRFDataNew();
afc.InsertAirForeCastSSCIData();
}
//afc.InsertAirForeCastSSCIData();
//afc.InsertAirForeCastCMAQData();
//afc.InsertAirForeCastWRFData();
listBox1.Items.Add("空气质量预报数据更新成功！");
}
//afc.InsertAirForeCastSSCIData();
//afc.InsertAirForeCastCMAQData();
//afc.InsertAirForeCastWRFData();
listBox1.Items.Add("空气质量预报数据更新成功！");
}
//气象监测数据
if (rbQxMon.Checked)
{
//string scon = ConfigurationManager.ConnectionStrings["sourceDB"].ToString();
//string tcon = ConfigurationManager.ConnectionStrings["targetDB"].ToString();
//QxMonitor qm = new QxMonitor();
//qm.scon = scon;
//qm.tcon = tcon;
//qm.getQxMonitorData();
//listBox1.Items.Add("气象监测数据更新成功！");
ReadXml();
listBox1.Items.Add("气象监测数据更新成功！");
}
//气象预报报文
if (rbQxForCast.Checked)
{
string scon = ConfigurationManager.ConnectionStrings["sourceDB"].ToString();
string tcon = ConfigurationManager.ConnectionStrings["targetDB"].ToString();
QxForeCast qf = new QxForeCast();
qf.scon = scon;
qf.tcon = tcon;
qf.getQxPacket();
listBox1.Items.Add("气象预报报文更新成功！");
}
//气象监测资料
if (rbQxFile.Checked)
{
QxFiles qf = new QxFiles();
//qf.getShareFile();
qf.ClearFile();
listBox1.Items.Add("气象监测资料更新成功！");
}
//QxImg qximg = new QxImg();
//qximg.DownLoadSoundingImg();
//气象监测图片
if (rbQxImg.Checked)
{
}
if (rbCityAir.Checked)
{
getCityAirHtml(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"));
listBox1.Items.Add("全国空气质量获取成功！");
}
//统计预报数据
if (rbQxTj.Checked)
{
if (!string.IsNullOrEmpty(txtPath.Text.Trim()))
{
string forecastTime = System.Text.RegularExpressions.Regex.Match(txtPath.Text, @"\d{4}-\d{1,2}-\d{1,2}").Value;
ImportData(txtPath.Text, forecastTime);
listBox1.Items.Add("统计预报数据更新成功！");
//getCityAirHtml("2015-10-01");
}
else
{
MessageBox.Show("请选择Excel文件！");
AirForCast afc = new AirForCast();
afc.con = con;
//afc.InsertAirForeCastTJData();
listBox1.Items.Add("统计预测数据获取成功！");
return;
if (!string.IsNullOrEmpty(txtPath.Text.Trim()))
{
string forecastTime = System.Text.RegularExpressions.Regex.Match(txtPath.Text, @"\d{4}-\d{1,2}-\d{1,2}").Value;
ImportData(txtPath.Text, forecastTime);
listBox1.Items.Add("统计预报数据更新成功！");
}
else
{
MessageBox.Show("请选择Excel文件！");
}
}
}
}
