public void Click(ShowcaseRankInfo kw, int maxQueryPageNumber, AliAccounts account, bool canInquiry, InquiryMessages msg) { this.item = kw; this.currentPage = 1; this.aliAccount = account; this.inquiryMessage = msg; this.canInquiry = canInquiry; this.maxQueryPage = maxQueryPageNumber; this.eventX = new ManualResetEvent(false); if (this.aliAccount == null) { this.canInquiry = false; } this.clickKey = item.RankKeyword; searchProductUrl = string.Format(SEARCH_URL1, clickKey.Replace(" ", "+")); ClickingEvent(item, @"Clicking " + searchProductUrl); browser.DocumentCompleted -= new WebBrowserDocumentCompletedEventHandler(browser_DocumentCompleted); browser.DocumentCompleted += new WebBrowserDocumentCompletedEventHandler(browser_DocumentCompleted); IEHandleUtils.Navigate(browser, searchProductUrl, null, additionalHeaders); //browser.Navigate(currentRequestUrl, "_self", null, additionalHeaders); eventX.WaitOne(Timeout.Infinite, true); item = null; aliAccount = null; inquiryMessage = null; Console.WriteLine("线程池结束!"); }
private void InsertBtn_Click(object sender, EventArgs e) { InquiryMessages model = new InquiryMessages(); model.Content = this.ContentBox.Text.Trim(); if (string.IsNullOrEmpty(model.Content)) { return; } inquiryDAO.InsertInquiryMessages(model); LoadDataview(); }
public void InsertInquiryMessages(InquiryMessages model) { string sql = @"INSERT INTO InquiryMessages(Content)values(@Content)"; SQLiteParameter[] parameter = new SQLiteParameter[] { new SQLiteParameter("@Content", model.Content) }; dbHelper.ExecuteNonQuery(sql, parameter); }
public InquiryMessages GetInquiryMinMessage() { DataTable dt = dbHelper.ExecuteDataTable( "SELECT MsgId, Content, SendNum from InquiryMessages order by SendNum asc limit 0,1", null); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; InquiryMessages kw = new InquiryMessages(); kw.MsgId = Convert.ToInt32(row["MsgId"]); kw.Content = (string)row["Content"]; kw.SendNum = Convert.ToInt32(row["SendNum"]); return kw; } return null; }
public List<InquiryMessages> GetInquiryMessages() { DataTable dt = dbHelper.ExecuteDataTable("SELECT MsgId, Content, SendNum from InquiryMessages", null); List<InquiryMessages> list = new List<InquiryMessages>(); foreach (DataRow row in dt.Rows) { InquiryMessages kw = new InquiryMessages(); kw.MsgId = Convert.ToInt32(row["MsgId"]); kw.Content = (string)row["Content"]; kw.SendNum = Convert.ToInt32(row["SendNum"]); list.Add(kw); } return list; }