public ActionResult Index(ViewModel model, int i = 0)
{
if (model != null)
{
Response.Write(model.content);
}
return View();
}
public ActionResult Index(ViewModel model)
{
if (model != null)
{
Response.Write(model.title);
}
return View();
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddData(ViewModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append(
"insert into blogs(title,briefContent,titleurl,CreateTime,name,bloggerurl,pinglun_url,pinglunnum,readercount) values(@title,@briefcontent,@titleurl,@CreateTime,@name,@bloggerurl,@pinglun_url,@pinglunnum,@readercount)");
Hashtable ht = new Hashtable();
ht.Add("@title", string.IsNullOrWhiteSpace(model.title)?string.Empty:model.title);
ht.Add("@briefContent", string.IsNullOrWhiteSpace(model.content)?string.Empty:model.content);
ht.Add("@titleurl", string.IsNullOrWhiteSpace(model.url) ? string.Empty : model.url);
ht.Add("@CreateTime", model.CreateTime);
ht.Add("@name", string.IsNullOrWhiteSpace(model.name) ? string.Empty : model.name);
ht.Add("@bloggerurl", string.IsNullOrWhiteSpace(model.bloggerurl) ? string.Empty : model.bloggerurl);
ht.Add("@pinglun_url", string.IsNullOrWhiteSpace(model.pinglun_url) ? string.Empty : model.pinglun_url);
ht.Add("@pinglunnum", model.pinglunNum);
ht.Add("@readercount", model.readerCount);
using (SqlHelper sqlhelp = new SqlHelper())
{
return sqlhelp.ExecuteNonQuery(sb.ToString(), ht);
}
}
/// <summary>
/// 分析Html 解析出里面具体的数据
/// </summary>
/// <param name="htmlContent"></param>
public List<ViewModel> AnalysisHtml(List<string> htmlstr)
{
//请注意就是转义字符的问题
string strPattern =
"<a\\s*class=\"titlelnk\"\\s*href=\"(?<href>.*)\"\\s*target=\"_blank\">(?<title>.*)</a>.*\\s*<p\\s*class=\"post_item_summary\">\\s*(.*<a\\s*.*>\\s*.*</a>)?\\s*(?<content>.*)\\s*</p>\\s*<div\\s*class=\"post_item_foot\">\\s*<a\\s*href=\"(?<BloggerHref>.*)\"\\s*class=\"lightblue\">(?<blogger>.*)</a>\\s*发布于(?<CreateTime>.*)\\s*<span\\s*class=\"article_comment\"\\s*>\\s*<a\\s*href=\"(?<pinglun_href>.*)\"\\s*.*>\\s*评论(?<pinglun>.*)</a>.*.*.*.*class=\"gray\"\\s*>阅读(?<readercount>.*)\\s*</a>";
Regex regex = new Regex(strPattern,
RegexOptions.IgnoreCase | RegexOptions.Multiline | RegexOptions.CultureInvariant);
List<ViewModel> list = new List<ViewModel>();
foreach (string htmlContent in htmlstr)
{
if (regex.IsMatch(htmlContent))
{
MatchCollection matchCollection = regex.Matches(htmlContent);
//Thread.Sleep(1000);
foreach (Match match in matchCollection)
{
ViewModel model = new ViewModel();
model.title = match.Groups["title"].Value; //获取到的是列表数据的标题
model.content = match.Groups[4].Value; //获取到的是内容
model.url = match.Groups[2].Value; //获取到的是链接到的地址
model.CreateTime = DateTime.Parse(match.Groups[7].Value);
model.name = match.Groups[6].Value;
model.bloggerurl = match.Groups[5].Value;
model.pinglun_url = match.Groups[8].Value;
int pinglunNum,readernum;
int.TryParse(match.Groups[9].Value.Replace("(","").Replace(")",""), out pinglunNum);
model.pinglunNum = pinglunNum;
int.TryParse(match.Groups[10].Value.Replace("(", "").Replace(")", ""), out readernum);
model.readerCount = readernum;
AddData(model);
list.Add(model);
}
}
}
return list;
}
/// <summary>
/// 列表数据获取
/// </summary>
/// <param name="page"></param>
/// <param name="sid"></param>
/// <returns></returns>
public List<ViewModel> DataGet(int page)
{
//分页助手
PageHelper parameter = GetPageParameterInfo();
ViewBag.PageParameter = parameter;
DataTable dt = new DataTable();
List<ViewModel> list = new List<ViewModel>();
using (SqlHelper sqlhelper = new SqlHelper())
{
string sql = "select * from blogs";
parameter.SqlScript = sql;
parameter.OrderBy = " createtime desc ";
parameter.RecordCount =
TypeParse.StrToInt(
sqlhelper.ExecuteScalar(string.Format("select count(1) from {0}", parameter.SqlScript)), 0);
dt = sqlhelper.ExecuteSql(parameter.ToString());
if (dt == null) return null;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ViewModel model = new ViewModel();
model.title = dt.Rows[i]["title"].ToString();
model.content = dt.Rows[i]["briefcontent"].ToString();
model.url = dt.Rows[i]["titleurl"].ToString();
model.CreateTime = (DateTime)dt.Rows[i]["createtime"];
model.name = dt.Rows[i]["name"].ToString();
model.bloggerurl = dt.Rows[i]["bloggerurl"].ToString();
model.pinglun_url = dt.Rows[i]["pinglun_url"].ToString();
int pinglunNum, readernum;
int.TryParse(dt.Rows[i]["pinglunNum"].ToString(), out pinglunNum);
model.pinglunNum = pinglunNum;
int.TryParse(dt.Rows[i]["readerCount"].ToString(), out readernum);
model.readerCount = readernum;
list.Add(model);
}
}
}
return list;
}
public ActionResult Index(ViewModel model, string page = "")
{
if (model != null)
{
Response.Write(model.title + "hidden：" + Request.Form["xx123"] + "page" + page);
}
return View();
}
