protected void Btn_DataImport_Warn_Click(object sender, EventArgs e)
{
DateTime startTime = DateTime.Parse(DDL_Year_Warn.SelectedItem.Value + "-" + DDL_Month_Warn.SelectedItem.Value + "-01");
DateTime endTime = startTime.AddMonths(1);
string[] categorys = { "暴雨", "暴雪", "大风", "大雾" };
EARLY_WARNING_COUNTRIES_BLL ebll = new EARLY_WARNING_COUNTRIES_BLL();
List <EARLY_WARNING_COUNTRIES> elist =
ebll.GetList(
a => a.COUNTRY == "青岛" && !a.WARNING_CONTENT.Contains("解除") && !a.WARNING_CONTENT.Contains("继续发布") && a.INSERTTIME >= startTime && a.INSERTTIME < endTime && categorys.Contains(a.WARNING_CATAGRAY)).OrderBy(a => a.INSERTTIME).ToList();
WarnCheck_BLL wbll = new WarnCheck_BLL();
wbll.Delete(a => a.ReleaseTime >= startTime && a.ReleaseTime < endTime);
foreach (var warningCountries in elist)
{
DateTime da = DateTime.ParseExact(warningCountries.PUBLISHTIME, "yyyy年MM月dd日HH时mm分", CultureInfo.InvariantCulture);
WarnCheck wc = new WarnCheck()
{
CheckID = Guid.NewGuid(),
ReleaseTime = da,
WarningCategory = warningCountries.WARNING_CATAGRAY,
WarningLevel = warningCountries.WARNING_LEVEL.Substring(0, 2)
};
wbll.Add(wc);
}
QueryWarnInfo();
Response.Write("<script language=javascript defer>alert('导入成功！');</script>");
}
protected void Button1_Click(object sender, EventArgs e)
{
DateTime ddd = DateTime.Parse("2017-03-01 00:00");
DateTime eee = DateTime.Parse("2017-04-01 00:00");
EARLY_WARNING_COUNTRIES_BLL ebll = new EARLY_WARNING_COUNTRIES_BLL();
List <EARLY_WARNING_COUNTRIES> elist =
ebll.GetList(
a => a.COUNTRY == "青岛" && !a.WARNING_CONTENT.Contains("解除") && !a.WARNING_CONTENT.Contains("继续发布") && a.INSERTTIME >= ddd && a.INSERTTIME < eee).OrderBy(a => a.INSERTTIME).ToList();
var aaa = elist;
//GridView1.DataSource = elist;
// GridView1.DataBind();
WarnCheck_BLL wbll = new WarnCheck_BLL();
foreach (var warningCountries in elist)
{
DateTime da = DateTime.ParseExact(warningCountries.PUBLISHTIME, "yyyy年MM月dd日HH时mm分", CultureInfo.InvariantCulture);
int minute = 295;
if (da.Day == 1)
{
minute = 295;
}
else if (da.Day == 2)
{
minute = 115;
}
else if (da.Day == 4)
{
minute = 0;
}
else if (da.Day == 5)
{
minute = 325;
}
else if (da.Day == 8)
{
minute = 75;
}
else if (da.Day == 11)
{
minute = 0;
}
else if (da.Day == 12)
{
minute = 0;
}
else if (da.Day == 13)
{
minute = 65;
}
else if (da.Day == 19)
{
minute = 0;
}
else if (da.Day == 28)
{
minute = 195;
}
PF.Models.SQL.WarnCheck wc = new PF.Models.SQL.WarnCheck()
{
CheckID = Guid.NewGuid(),
ReleaseTime = da,
Accuracy = "正确",
ReachSpendMinute = minute,
ReachTime = da.AddMinutes(minute),
WarningCategory = warningCountries.WARNING_CATAGRAY,
WarningLevel = warningCountries.WARNING_LEVEL.Substring(0, 2)
};
wbll.Add(wc);
}
}
