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