//每天超过的 public ActionResult EveryDayYujing() { string date = Request.QueryString["date"].ToString(); M_HitchInfoBll bll = new M_HitchInfoBll(); return(View(bll.GetEveryDayYujiList(DateTime.Parse(date)))); }
public void Execute(IJobExecutionContext context) { // string path = System.Environment.CurrentDirectory; // MapPath("/App_Data/selfsetting.xml"); HttpContext http = HttpContext.Current; string path = System.IO.Path.Combine(HttpRuntime.AppDomainAppPath, "App_Data/selfsetting.xml"); XmlDocument xmldoc = new XmlDocument(); // string path = System.AppDomain.CurrentDomain.BaseDirectory.ToString()+ "App_Data/selfsetting.xml"; xmldoc.Load(path); string time = xmldoc.SelectSingleNode("root").SelectSingleNode("daorutime").Attributes[0].Value; string daorupath = xmldoc.SelectSingleNode("root").SelectSingleNode("daorudir").Attributes[0].Value; string daorunowdate = xmldoc.SelectSingleNode("root").SelectSingleNode("daorunowdate").Attributes[0].Value; var files = DirFileHelper.GetFileNames(daorupath); if (files.Length > 0) { DataSet ds = ExportFile.ExcelSqlConnection(files[0], "Info"); //调用自定义方法 DataRow[] dr = ds.Tables[0].Select(); int successcount = 0; int failcount = 0; M_HitchInfoBll M_HitchInfoBll = new M_HitchInfoBll(); for (int i = 0; i < dr.Length; i++) { try { M_HitchInfo model = new M_HitchInfo(); model.AreaName = dr[0][0].ToString(); model.FactorySation = dr[i][1].ToString(); model.Signal = dr[i][2].ToString(); model.HappenTimes = int.Parse(dr[i][3].ToString()); model.SignalType = dr[i][4].ToString(); model.HappenTimes1 = int.Parse(dr[i][5].ToString()); model.MessageType = dr[i][6].ToString(); model.CreateUserId = 1; model.CreateUserName = "******"; model.CreateTime = DateTime.Now.AddDays(int.Parse(daorunowdate)); if (M_HitchInfoBll.M_HitchInfoAdd(model) > 0) { successcount++; } else { failcount++; } } catch (Exception) { failcount++; } } for (int i = 0; i < files.Length; i++) { File.Delete(files[i]); } } }
public ActionResult SettingList() { M_HitchInfoBll bll = new M_HitchInfoBll(); return(View(bll.GetSettingModel())); }