private void Button_Click_3(object sender, RoutedEventArgs e) { using (var ctx = new oaEntities()) { var T = ctx.T_FGJHtmlData.DefaultIfEmpty().ToList(); for (int i = 0; i < T.Count(); i++) { T_FGJHtmlData tf = T[i]; tf.SumMoneyID = GetMoney(tf.FwSumMoney); tf.HuXingID = GetHuxing(tf.FwHuXing); tf.MianjiID = GeiMinji(tf.FwMianji); tf.Money_int = GetMoney_int(tf.FwSumMoney); tf.Pingmi_int = GetPingmi_int(tf.FwMianji); } ctx.SaveChanges(); } }
public void Updata() { #region MyRegion using (var ctx = new oaEntities()) { var obj = (ctx as IObjectContextAdapter).ObjectContext; DateTime DBtime = Convert.ToDateTime(DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString()); MaxTime = ctx.T_FGJHtmlData.DefaultIfEmpty().Where(x => x.FbTime != DBtime).Max(x => x.FbTime); // var tfdata = ctx.T_FGJHtmlData.DefaultIfEmpty<T_FGJHtmlData>().Where(x=>x.FbTime==DBtime); iqdata = ctx.T_FGJHtmlData.DefaultIfEmpty <T_FGJHtmlData>().Where(x => x.FbTime == DBtime); web1.LoadCompleted += new LoadCompletedEventHandler(webbrowserUpload); loadingS = true; // 表示正在加载 web1.Navigate("http://liaoyang.58.com/ershoufang/0"); while (loadingS) { System.Windows.Forms.Application.DoEvents(); // 等待本次加载完毕才执行下次循环. } #region 查询完所有网站后执行 for (i = 0; i < L_Class.Count; i++) { web1.LoadCompleted += new LoadCompletedEventHandler(web2_Navigated);; loading = true; // 表示正在加载 web1.Navigate(L_Class[i].href); ChangeTextEvent("支目录条数已读取" + i + "条" + "-----主目录条数" + L_Class.Count()); while (loading) { System.Windows.Forms.Application.DoEvents(); // 等待本次加载完毕才执行下次循环. } } //DPdg.ItemsSource = L_Class; #endregion foreach (var da in L_Class) { T_FGJHtmlData tf = new T_FGJHtmlData(); //如果数据库中出现该名称并且 时间在当前时间那么 该信息不写入数据库 if (ctx.T_FGJHtmlData.FirstOrDefault(x => x.HLName == da.TextName) != null) { continue; } tf.HLName = da.TextName; tf.HLhref = da.href; tf.PersonName = da.PersonName; tf.Address = da.Address; tf.photo = da.photo; tf.FbTime = da.FbTime; tf.FwSumMoney = da.FwSumMoney; tf.FwHuXing = da.FwHuXing; tf.FwMianji = da.FwMianji; tf.FwLoucheng = da.FwLoucheng; tf.FwZhuangxiu = da.FwZhuangxiu; tf.FwNianxian = da.FwNianxian; tf.FwChaoxiang = da.FwChaoxiang; tf.bak = da.bak; tf.Id_count = int.Parse(da.Id_count == null ? "0" : da.Id_count); tf.Laiyuan = da.Laiyuan; tf.Image_str = da.Image_str; ctx.T_FGJHtmlData.Add(tf); } ctx.SaveChanges(); ChangeTextEvent("完成更新————" + DateTime.Now.ToString() + ".OK"); } #endregion this.Close(); }
private void SaveDataHTML(oaEntities ctx, List <newWORD.Class1> L_Class_, int p) { DAL.T_FGJHtmlDataDal Dti = new DAL.T_FGJHtmlDataDal(); foreach (var da in L_Class_) { T_FGJHtmlData tf = new T_FGJHtmlData(); tf.HLName = da.TextName; tf.HLhref = da.href; tf.PersonName = da.PersonName; tf.Address = da.Address; tf.photo = da.photo; tf.FbTime = da.FbTime; tf.FbTime = tf.FbTime > DateTime.Now ? new DateTime(2017, tf.FbTime.Month, tf.FbTime.Day, tf.FbTime.Hour, tf.FbTime.Minute, tf.FbTime.Second):tf.FbTime; if (da.FwSumMoney == null) { continue; } else { if (da.FwSumMoney.Trim().Length <= 0) { continue; } } tf.FwSumMoney = da.FwSumMoney; tf.FwHuXing = da.FwHuXing; tf.FwMianji = da.FwMianji; tf.FwLoucheng = da.FwLoucheng; tf.FwZhuangxiu = da.FwZhuangxiu; tf.FwNianxian = da.FwNianxian; tf.FwChaoxiang = da.FwChaoxiang; tf.bak = da.bak; tf.Id_count = int.Parse(da.Id_count == null ? "0" : da.Id_count); tf.Laiyuan = da.Laiyuan; tf.Image_str = da.Image_str; tf.CityID = p; if (da.FwMianji != null) { tf.MianjiID = GeiMinji(da.FwMianji); tf.Pingmi_int = GetPingmi_int(da.FwMianji); } if (da.FwSumMoney != null) { tf.SumMoneyID = GetMoney(da.FwSumMoney); tf.Money_int = GetMoney_int(da.FwSumMoney); } if (da.FwHuXing != null) { tf.HuXingID = GetHuxing(da.FwHuXing); } //如果数据库中出现该名称并且 时间在当前时间那么 该信息不写入数据库 //如果有该数据那么修改数据库中的数据信息 var isnull = Dti.LoadEntities(x => x.FwMianji == tf.FwMianji && x.photo == tf.photo).DefaultIfEmpty(); if (isnull.ToList()[0] != null) { var tm = isnull.Max(x => x.FbTime); var vtm = isnull.Where(x => x.FbTime == tm).First(); vtm.FbTime = tf.FbTime; vtm.Money_int = tf.Money_int; vtm.FwSumMoney = tf.FwSumMoney; vtm.SumMoneyID = tf.SumMoneyID; Dti.EditEntity(vtm); } else { Dti.AddEntity(tf); } } Dti.SaveChanges(); }