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); } }