public ITemporaryQueue CreateTemporaryQueue() { TempQueue answer = new TempQueue(Connection.CreateTemporaryDestinationName()); return(answer); }
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()); } // } } } // }); }