//保存数据
public void SaveUrl(PageContentEntity entity, string ErrorMsg)
{
CookieFunc cookieFunc = new CookieFunc();
DatUrlEntity urlEntity = new DatUrlEntity();
urlEntity.ID = entity.ID;
urlEntity.KeyWord = entity.KeyWord;
urlEntity.ProgramName = entity.ProgramName;
urlEntity.SpiderDate = entity.SpiderDate;
urlEntity.PID = entity.PID;
urlEntity.SiteUrl = entity.SiteUrl;
urlEntity.SType = entity.SType;
urlEntity.SourUrl = entity.SourUrl;
urlEntity.Url = entity.Url;
urlEntity.UrlType = entity.UrlType;
urlEntity.UrlPara = entity.UrlPara;
urlEntity.EnCode = entity.EnCode;
urlEntity.APara = entity.APara;
urlEntity.CookieContent = cookieFunc.GetCookiesStr(entity.CookieContent);
urlEntity.AContent = entity.AContent;
urlEntity.PConent = entity.PContent;
urlEntity.ErrorMsg = ErrorMsg;
urlEntity.TrySpiderTimes = entity.TrySpiderTimes + 1;
urlEntity.Depth = entity.Depth;
urlEntity.SpiderTime = entity.SpiderTime;
DbHelp.ClsDB clsdb = new DbHelp.ClsDB();
Analysis.SqlBuild sqlBuild = new Analysis.SqlBuild();
Analysis.SqlPara sqlPara = new Analysis.SqlPara();
clsdb.AddPageDB(entity, sqlBuild.GetHalfBakeInsSql(), sqlPara.GetHalfBakeInsPara(urlEntity));
DbHelp.Utilities util = new DbHelp.Utilities();
}
public SqlParameter[] GetHalfBakeInsPara(DatUrlEntity model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 36),
new SqlParameter("@KeyWord", SqlDbType.VarChar, 500),
new SqlParameter("@ProgramName", SqlDbType.VarChar, 100),
new SqlParameter("@SpiderDate", SqlDbType.VarChar, 10),
new SqlParameter("@PID", SqlDbType.VarChar, 36),
new SqlParameter("@SType", SqlDbType.VarChar, 50),
new SqlParameter("@SiteUrl", SqlDbType.VarChar, 2000),
new SqlParameter("@SourUrl", SqlDbType.VarChar, 2000),
new SqlParameter("@Url", SqlDbType.VarChar, 2000),
new SqlParameter("@UrlType", SqlDbType.VarChar, 50),
new SqlParameter("@UrlPara", SqlDbType.Text),
new SqlParameter("@EnCode", SqlDbType.VarChar, 50),
new SqlParameter("@Apara", SqlDbType.VarChar, 4000),
new SqlParameter("@CookieContent", SqlDbType.Text),
new SqlParameter("@AContent", SqlDbType.Text),
new SqlParameter("@PConent", SqlDbType.Text),
new SqlParameter("@TrySpiderTimes", SqlDbType.Int, 4),
new SqlParameter("@Depth", SqlDbType.Int, 4),
new SqlParameter("@SpiderTime", SqlDbType.DateTime),
new SqlParameter("@ErrorMsg", SqlDbType.Text)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.KeyWord;
parameters[2].Value = model.ProgramName;
parameters[3].Value = model.SpiderDate;
parameters[4].Value = model.PID;
parameters[5].Value = model.SType;
parameters[6].Value = model.SiteUrl;
parameters[7].Value = model.SourUrl;
parameters[8].Value = model.Url;
parameters[9].Value = model.UrlType;
parameters[10].Value = model.UrlPara;
parameters[11].Value = model.EnCode;
parameters[12].Value = model.APara;
parameters[13].Value = model.CookieContent;
parameters[14].Value = model.AContent;
parameters[15].Value = model.PConent;
parameters[16].Value = model.TrySpiderTimes;
parameters[17].Value = model.Depth;
parameters[18].Value = model.SpiderTime;
parameters[19].Value = model.ErrorMsg;
return(parameters);
}
