/// <summary>
/// 单条插入数据库
/// </summary>
/// <param name="pCrawlResultDetailList"></param>
public void InsertCrawlResult(CrawlResultDetail pCrawlResultDetail)
{
using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection))
{
string sql = string.Format("Insert into CTaskResult values(@url,@rcontent,@isdeleted,@createdtime)");
sqlConnection.Open();
sqlConnection.Execute(sql,
new
{
url = "",
rcontent = pCrawlResultDetail.Content,
isdeleted = false,
createdtime = DateTime.Now
});
sqlConnection.Close();
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="pTaskDetail"></param>
/// <param name="pResultDetail"></param>
public CrawlOriData(CrawlTaskDetail pTaskDetail, CrawlResultDetail pResultDetail, byte pChaset)
{
Host = pTaskDetail.Host;
Title = pTaskDetail.Title;
Url = pTaskDetail.Url;
Ext = pResultDetail.Ext;
Data = pResultDetail.Content;
Dt = DateTime.Now;
if (Ext == null)
{
Ext = "html";
}
mDataTypeDic.TryGetValue(Ext, out DataType);
Key = pTaskDetail.Key;
Chaset = pChaset;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="pTaskDetail"></param>
/// <param name="pResultDetail"></param>
public CrawlOriData(CrawlTaskDetail pTaskDetail, CrawlResultDetail pResultDetail, byte pChaset)
{
Host = pTaskDetail.Host;
Title = pTaskDetail.Title;
Url = pTaskDetail.Url;
Ext = pResultDetail.Ext;
Data = pResultDetail.Content;
Dt = DateTime.Now;
if (Ext == null) { Ext = "html"; }
mDataTypeDic.TryGetValue(Ext, out DataType);
Key = pTaskDetail.Key;
Chaset = pChaset;
}