/// <summary>
/// ��������б�
/// </summary>
public List<Maticsoft.Model.BlogPost> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.BlogPost> modelList = new List<Maticsoft.Model.BlogPost>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Maticsoft.Model.BlogPost model;
for (int n = 0; n < rowsCount; n++)
{
model = new Maticsoft.Model.BlogPost();
if(dt.Rows[n]["Id"].ToString()!="")
{
model.Id=int.Parse(dt.Rows[n]["Id"].ToString());
}
if(dt.Rows[n]["OwnerId"].ToString()!="")
{
model.OwnerId=int.Parse(dt.Rows[n]["OwnerId"].ToString());
}
model.OwnerType=dt.Rows[n]["OwnerType"].ToString();
model.OwnerUrl=dt.Rows[n]["OwnerUrl"].ToString();
if(dt.Rows[n]["AppId"].ToString()!="")
{
model.AppId=int.Parse(dt.Rows[n]["AppId"].ToString());
}
if(dt.Rows[n]["SysCategoryId"].ToString()!="")
{
model.SysCategoryId=int.Parse(dt.Rows[n]["SysCategoryId"].ToString());
}
if(dt.Rows[n]["CreatorId"].ToString()!="")
{
model.CreatorId=int.Parse(dt.Rows[n]["CreatorId"].ToString());
}
model.CreatorUrl=dt.Rows[n]["CreatorUrl"].ToString();
if(dt.Rows[n]["CategoryId"].ToString()!="")
{
model.CategoryId=int.Parse(dt.Rows[n]["CategoryId"].ToString());
}
model.Title=dt.Rows[n]["Title"].ToString();
model.Content=dt.Rows[n]["Content"].ToString();
model.Abstract=dt.Rows[n]["Abstract"].ToString();
model.Pic=dt.Rows[n]["Pic"].ToString();
if(dt.Rows[n]["CommentCondition"].ToString()!="")
{
model.CommentCondition=int.Parse(dt.Rows[n]["CommentCondition"].ToString());
}
if(dt.Rows[n]["Hits"].ToString()!="")
{
model.Hits=int.Parse(dt.Rows[n]["Hits"].ToString());
}
if(dt.Rows[n]["IsPic"].ToString()!="")
{
model.IsPic=int.Parse(dt.Rows[n]["IsPic"].ToString());
}
if(dt.Rows[n]["IsPick"].ToString()!="")
{
model.IsPick=int.Parse(dt.Rows[n]["IsPick"].ToString());
}
if(dt.Rows[n]["IsTop"].ToString()!="")
{
model.IsTop=int.Parse(dt.Rows[n]["IsTop"].ToString());
}
if(dt.Rows[n]["Replies"].ToString()!="")
{
model.Replies=int.Parse(dt.Rows[n]["Replies"].ToString());
}
if(dt.Rows[n]["SaveStatus"].ToString()!="")
{
model.SaveStatus=int.Parse(dt.Rows[n]["SaveStatus"].ToString());
}
if(dt.Rows[n]["AccessStatus"].ToString()!="")
{
model.AccessStatus=int.Parse(dt.Rows[n]["AccessStatus"].ToString());
}
model.Ip=dt.Rows[n]["Ip"].ToString();
if(dt.Rows[n]["Created"].ToString()!="")
{
model.Created=DateTime.Parse(dt.Rows[n]["Created"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
private static void savePageDetail( DetailLink lnk, StringBuilder sb )
{
SpiderTemplate template = lnk.Template;
string url = lnk.Url;
string title = lnk.Title;
string summary = lnk.Abstract;
if (isPageExist( url, sb )) return;
String pageBody = new PagedDetailSpider().GetContent( url, template, sb );
if (pageBody == null) return;
SpiderArticle pd = new SpiderArticle();
pd.Title = title;
pd.Url = strUtil.SubString( url, 250 );
pd.Abstract = summary;
pd.Body = pageBody;
pd.SpiderTemplate = template;
MatchCollection matchs = Regex.Matches( pageBody, RegPattern.Img, RegexOptions.Singleline );
if (matchs.Count > 0) {
pd.IsPic = 1;
pd.PicUrl = matchs[0].Groups[1].Value;
}
pd.insert();
sb.AppendLine( "保存成功..." + lnk.Title + "_" + lnk.Url );
pageBody = Regex.Replace(pageBody, "font-size", "", RegexOptions.IgnoreCase);
string strArcitleLink = "<div class=\"ArcitleLink\"><a href=" + pd.Url + ">原文链接</a></div>";
pageBody = pageBody + strArcitleLink;
Maticsoft.BLL.BlogCategory bllBlogCategory = new Maticsoft.BLL.BlogCategory();
DataSet ds = bllBlogCategory.GetList("AppId = '" + template.IsDelete.ToString() + "'");
int nCateID = 1;
if (ds.Tables[0].Rows.Count > 0)
{
nCateID = (int)ds.Tables[0].Rows[0]["Id"];
}
BlogPost data = new BlogPost();
data.CategoryId = nCateID;
data.Title = title;
data.Abstract = summary;
data.Content = pageBody;
data.AccessStatus = 0;
data.CommentCondition = 0;
data.SaveStatus = 1;//草稿
data.Created = System.DateTime.Now.Date;
data.IsTop = 0;
data.IsPick = 0;
data.IsPic = 0;
data.Ip = "";
data.OwnerId = template.IsDelete;
data.OwnerUrl = template.SiteName;
data.OwnerType = "wojilu.Members.Users.Domain.User";
data.CreatorUrl = template.SiteName;
data.AppId = template.IsDelete; ;
data.CreatorId = template.IsDelete;
Maticsoft.BLL.BlogPost bll = new Maticsoft.BLL.BlogPost();
bll.Add(data);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.BlogPost model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.BlogPost model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Maticsoft.Model.BlogPost> DataTableToList(DataTable dt)
{
List <Maticsoft.Model.BlogPost> modelList = new List <Maticsoft.Model.BlogPost>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Maticsoft.Model.BlogPost model;
for (int n = 0; n < rowsCount; n++)
{
model = new Maticsoft.Model.BlogPost();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
if (dt.Rows[n]["OwnerId"].ToString() != "")
{
model.OwnerId = int.Parse(dt.Rows[n]["OwnerId"].ToString());
}
model.OwnerType = dt.Rows[n]["OwnerType"].ToString();
model.OwnerUrl = dt.Rows[n]["OwnerUrl"].ToString();
if (dt.Rows[n]["AppId"].ToString() != "")
{
model.AppId = int.Parse(dt.Rows[n]["AppId"].ToString());
}
if (dt.Rows[n]["SysCategoryId"].ToString() != "")
{
model.SysCategoryId = int.Parse(dt.Rows[n]["SysCategoryId"].ToString());
}
if (dt.Rows[n]["CreatorId"].ToString() != "")
{
model.CreatorId = int.Parse(dt.Rows[n]["CreatorId"].ToString());
}
model.CreatorUrl = dt.Rows[n]["CreatorUrl"].ToString();
if (dt.Rows[n]["CategoryId"].ToString() != "")
{
model.CategoryId = int.Parse(dt.Rows[n]["CategoryId"].ToString());
}
model.Title = dt.Rows[n]["Title"].ToString();
model.Content = dt.Rows[n]["Content"].ToString();
model.Abstract = dt.Rows[n]["Abstract"].ToString();
model.Pic = dt.Rows[n]["Pic"].ToString();
if (dt.Rows[n]["CommentCondition"].ToString() != "")
{
model.CommentCondition = int.Parse(dt.Rows[n]["CommentCondition"].ToString());
}
if (dt.Rows[n]["Hits"].ToString() != "")
{
model.Hits = int.Parse(dt.Rows[n]["Hits"].ToString());
}
if (dt.Rows[n]["IsPic"].ToString() != "")
{
model.IsPic = int.Parse(dt.Rows[n]["IsPic"].ToString());
}
if (dt.Rows[n]["IsPick"].ToString() != "")
{
model.IsPick = int.Parse(dt.Rows[n]["IsPick"].ToString());
}
if (dt.Rows[n]["IsTop"].ToString() != "")
{
model.IsTop = int.Parse(dt.Rows[n]["IsTop"].ToString());
}
if (dt.Rows[n]["Replies"].ToString() != "")
{
model.Replies = int.Parse(dt.Rows[n]["Replies"].ToString());
}
if (dt.Rows[n]["SaveStatus"].ToString() != "")
{
model.SaveStatus = int.Parse(dt.Rows[n]["SaveStatus"].ToString());
}
if (dt.Rows[n]["AccessStatus"].ToString() != "")
{
model.AccessStatus = int.Parse(dt.Rows[n]["AccessStatus"].ToString());
}
model.Ip = dt.Rows[n]["Ip"].ToString();
if (dt.Rows[n]["Created"].ToString() != "")
{
model.Created = DateTime.Parse(dt.Rows[n]["Created"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
