public override void WriteToDatabase()
{
using (Database db = new Database())
{
DataTable dt = db.GetDataSet("select top 1 * from histweather_sample").Tables[0].Clone();
int rowCount = 0;
string line = "";
strReader.ReadLine();
while ((line = strReader.ReadLine()) != null)
{
string[] list = line.Split(',');
DataRow dr = dt.NewRow();
if (list[1] == "" || list[2] == "" || list[3] == "" || list[4] == "" ||
list[5] == "" || list[6] == "" || list[7] == "" || list[8] == "")
{
continue;
}
else
{
dr["city"] = list[1];
dr["cityname"] = list[2];
dr["date"] = list[3];
dr["temphi"] = list[4];
dr["templow"] = list[5];
dr["description"] = list[6];
dr["windir"] = list[7];
dr["windstrength"] = list[8];
}
if (list[9] != "")
{
dr["aqi"] = list[9];
}
if (list[11] != "")
{
dr["aqilevel"] = list[11];
}
dr["aqiinfo"] = list[10];
dt.Rows.Add(dr);
rowCount++;
if (rowCount == 10000)
{
db.CopyToDataBase(dt, "histweather_sample");
dt.Clear();
rowCount = 0;
}
}
if (rowCount != 0)
{
db.CopyToDataBase(dt, "histweather_sample");
dt.Clear();
}
}
}
public override void WriteToDatabase()
{
using (Database db = new Database())
{
DataTable dt = db.GetDataSet("select top 1 * from flight_sample").Tables[0].Clone();
int rowCount = 0;
string line = "";
strReader.ReadLine();
while ((line = strReader.ReadLine()) != null)
{
string[] list = line.Split(',');
DataRow dr = dt.NewRow();
//try
//{
if (list[17] == "" || list[17] == "取消" || list[17] == "未知")
{
dr["TimeSeries"] = list[1];
if (list[2] == "")
{
if (list[3] != "" && list[4] != "")
{
list[2] = list[3] + list[4];
dr["FlightNo"] = list[2];
}
else
{
continue;
}
}
else
{
dr["FlightNo"] = list[2];
}
if (list[10] == "" || list[9] == "" ||
list[11] == "" || list[12] == "" || list[18] == "")
{
continue;
}
else
{
dr["Arrday"] = list[11];
dr["DepTime"] = list[9];
dr["ArrTime"] = list[10];
dr["FlyingTime"] = list[12];
dr["Stops"] = list[18];
}
if (list[16] + list[15] + list[14] + list[13] != "")
{
if (list[16] == "")
{
if (list[17] == "取消")
{
dr["ActFlyingTime"] = 0;
}
else
{
continue;
}
}
else
{
dr["ActFlyingTime"] = list[16];
}
if (list[15] == "")
{
if (list[17] == "")
{
continue;
}
}
else
{
dr["ActArrday"] = list[15];
}
if (list[13] == "" || list[14] == "")
{
if (list[17] == "")
{
continue;
}
}
else
{
dr["ActDepTime"] = list[13];
dr["ActArrTime"] = list[14];
}
TimeSpan t = (TimeSpan)dr["ActDepTime"] - (TimeSpan)dr["DepTime"];
dr["DelayTime"] = t.TotalMinutes;
if (t.TotalMinutes >= 30)
{
dr["IsDelay"] = 1;
}
else
{
dr["IsDelay"] = 0;
}
}
dr["Carrier"] = list[3];
dr["FlightNoShort"] = list[4];
dr["DepAirport"] = list[5];
dr["DepCity"] = list[6];
dr["ArrAirport"] = list[7];
dr["ArrCity"] = list[8];
dr["Comment"] = list[17];
dr["Routing"] = list[19];
dr["Acft"] = list[20];
dr["DistKm"] = list[21];
dr["OpCar"] = list[22] == "O" ? 1 : 0;
dt.Rows.Add(dr);
rowCount++;
}
//}
//catch
//{
// continue;
//}
if (rowCount == 10000)
{
db.CopyToDataBase(dt, "flight_sample");
dt.Clear();
rowCount = 0;
}
}
if (rowCount != 0)
{
db.CopyToDataBase(dt, "flight_sample");
dt.Clear();
}
}
}
