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