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