public static DbContext CreateDbContext()
{
DbContext db = (DbContext)CallContext.GetData("db");
if (db == null)
{
db = new WolfLairBlogEntities();
CallContext.SetData("db", db);
}
return(db);
}
static void Chuli()
{
WolfLairBlogEntities db = new WolfLairBlogEntities();
// ThreadPool.QueueUserWorkItem(c =>
// {
while (true)
{
Console.WriteLine("队列剩余数量为：{0}", TempQueue.Count);
// Thread.Sleep(500);
// lock (_obj)
//{
if (TempQueue.Count > 0)
{
Result r = TempQueue.Dequeue() as Result;
HtmlWeb htmlWeb = new HtmlWeb();
HtmlDocument htmlDoc = htmlWeb.Load(r.Url);
string innerHtml = string.Empty;
innerHtml = htmlDoc.DocumentNode.SelectSingleNode("//*[@id='cnblogs_post_body']").InnerHtml;
Article articleEntity = new Article
{
CategoryId = 1,
Content = innerHtml,
PubTime = DateTime.Now,
Title = r.Title,
UserId = 2
};
db.Articles.Add(articleEntity);
db.SaveChanges();
// count++;
try
{
#region MyRegion
//SqlParameter[] pms = new SqlParameter[] {
// new SqlParameter("@CategoryId",1),
// new SqlParameter("@Content",innerHtml),
// new SqlParameter("@PubTime",DateTime.Now),
// new SqlParameter("@Title",r.Title),
// new SqlParameter("@UserId",2)
//};
//using (SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=1125;database=WolfLairBlog"))
//{
// using (SqlCommand cmd = new SqlCommand("INSERT INTO Article(CategoryId,Content,PubTime,Title,UserId)VALUES(@CategoryId,@Content,@PubTime,@Title,@UserId)", con))
// {
// con.Open();
// cmd.Parameters.AddRange(pms);
// cmd.ExecuteNonQuery();
// //if (cmd.ExecuteNonQuery() > 0)
// //{
// // // count++;
// // // Console.WriteLine(string.Format("标题：{0}，地址为：{1}", r.Title, r.Url));
// //}
// }
//}
////if (db.SaveChanges() > 0)
//{
//}
#endregion
}
catch (Exception ex)
{
NLogHelper.Error(ex.ToString());
}
// }
}
}
// });
}
