从零开始，搭建博客系统MVC5+EF6搭建框架（5），博客详情页、留言、轮播图管理、右侧统计博文
2024-10-16 20:09:48
一、博客系统进度回顾
上一遍博客介绍到，系统已经实现到了发布以及前台布局展示，接下来就是实现一些，详情页，留言、轮播图管理、右侧博文统计信息实现。
二、博客系统详情页实现
2.1先来看看详情页展示的效果
2.2实现控制器在前台控制器中创建一个Blog的控制器，主要是展示博客分类以及详情页
Action详情页实现：
1 /// <summary>
2 /// 详情页
3 /// </summary>
4 /// <param name="id"></param>
5 /// <returns></returns>
6 public ActionResult Detail(int id)
7 {
8 //获取控制器名称
9 ViewBag.controllername = RouteData.Values["controller"].ToString().ToLower();
10 var model = BlogArticleServive.getBlogDetails(id);
11 ViewBag.gblist = GuestbookServices.QueryOrderBy(c => c.blogId == id, c => c.createdate, false).ToPagedList(1, 5);
12
13 //发布时间排序
14 ViewBag.blogtimelist = BlogArticleServive.QueryOrderBy(c => true, c => c.bCreateTime, false);
15 //评论排序
16 ViewBag.blogtrafficlist = BlogArticleServive.QueryOrderBy(c => true, c => c.btraffic, false);
17 //留言排序
18 string sql = @"select a.*,b.btitle from (select blogId,count(1) as counts from Guestbook group by blogId) as a
19 inner join BlogArticle as b
20 on
21 b.bID=a.blogId order by counts desc";
22
23 ViewBag.blogguestbooklist = GuestbookServices.RunProc<TopgbViewModels>(sql);
24
25 return View(model);
26 }
由于展示的内容比实际存储在数据库中的信息多，所以把所有能展示的信息都放在BlogViewModels中，在blog业务逻辑层单独实现了一个包含上一页 下一页，以及摘要赋值的方法。
由于这一部分需要从详情内容中只保留部分文字，所以这里需要对索取的详情信息做处理，由于详情信息是通过富文本编辑来添加的里面包含了很多html代码信息，所以在common程序集中，创建一个工具类，Tools类来存放，辅助的相关方法。
ReplaceHtmlTag方法：
1 #region 去除富文本中的HTML标签
2 /// <summary>
3 /// 去除富文本中的HTML标签
4 /// </summary>
5 /// <param name="html"></param>
6 /// <param name="length"></param>
7 /// <returns></returns>
8 public static string ReplaceHtmlTag(string html, int length = 0)
9 {
10 string strText = System.Text.RegularExpressions.Regex.Replace(html, "<[^>]+>", "");
11 strText = System.Text.RegularExpressions.Regex.Replace(strText, "&[^;]+;", "");
12
13 if (length > 0 && strText.Length > length)
14 return strText.Substring(0, length);
15
16 return strText;
17 }
18 #endregion
然后在获取到多有信息，要处理的地方就是用三元运算符来判断，截取前面的文字部分
2.3详情页视图代码
1 @model Wchl.WMBlog.Model.VeiwModels.BlogViewModels
2
3 @{
4 ViewBag.Title = "博客详情页";
5 }
6 <link href="~/Content/lib/zui/doc.css" rel="stylesheet" />
7 <section>
8 <article>
9 <div spellcheck="false" class="example">
10 <br>
11 <ul class="breadcrumb">
12 <li><i class="icon-location-arrow icon-muted"></i></li>
13 <li><a href="/home/index">首页</a></li>
14 <li><a href="/blog/index">博客</a></li>
15 <li class="active">Data</li>
16 </ul>
17 <hr>
18 <article class="article">
19 <header>
20 <h1 class="text-center">@Model.btitle</h1>
21 <dl class="dl-inline">
22 <dt>发布时间：</dt>
23 <dd>@Model.bCreateTime</dd>
24 <dt>作者：</dt>
25 <dd>@Model.bsubmitter</dd>
26 <dt></dt>
27 <dd class="pull-right"><span class="label label-success">新</span> <span class="label label-warning">火爆</span> <span class="label label-info">原创</span> <span class="label label-danger"><i class="icon-eye-open"></i> @Model.btraffic</span></dd>
28 </dl>
29 <section class="abstract">
30 <p><strong>摘要：</strong>@Model.digest</p>
31 </section>
32 </header>
33 <section class="article-content">
34 @Html.Raw(Model.bcontent)
35 </section>
36 <footer>
37 <p class="pull-right text-muted">
38 发布时间：@Model.bCreateTime.ToString("yyyy年MM月dd日 HH:mm:ss") 点击数：@Model.btraffic
39 </p>
40 <p class="text-important">本文版权所有归<a href="###">@Model.bsubmitter</a></p>
41 <ul class="pager pager-justify">
42 @if (Model.previous == null)
43 {
44 <li class="previous disabled"><a href="#" title=""><i class="icon-arrow-left"></i> 上一篇: </a></li>
45 }
46 else
47 {
48 <li class="previous"><a href="/blog/Detail/@Model.previousID " title="@Model.previous"><i class="icon-arrow-left"></i> 上一篇: @Model.previous.Substring(0, 5) </a></li>
49 }
50 @if (Model.next == null)
51 {
52 <li class="next disabled"><a href="#">下一篇: <i class="icon-arrow-right"></i></a></li>
53 }
54 else
55 {
56 <li class="next"><a href="/blog/Detail/@Model.nextID " title="=@Model.next">下一篇:@Model.next.Substring(0, 5) <i class="icon-arrow-right"></i></a></li>
57 }
58
59
60 </ul>
61 </footer>
62 </article>
63 </div>
64 </article>
65 <div id="comment">
66 @Html.Partial("_GuestbookPage")
67 </div>
68
69 </section>
70 @section scripts
71 {
72 <script src="~/Content/lib/laypage/laypage.js"></script>
73 <script type="text/javascript">
74 var blogid;
75 var curr;
76 $(function () {
77 $("#blogId").val(@Model.bID);
78 //运行分页
79 blogid = $("#blogId").val();
80 guestbookpage(curr,blogid);
81 })
82
83 function su(data) {
84 $("#comment").html(data);
85 $("#blogId").val(@Model.bID);
86 //setTimeout(function () {
87 // if (document.getElementById('textcenter') != null) {
88 // //运行分页
89 // guestbookpage(1, blogid);
90 // }
91 //}, 3000);
92 if (document.getElementById('textcenter') != null) {
93 //运行分页
94 guestbookpage(1, blogid);
95 }
96
97
98
99 }
100
101 //以下将以jquery.ajax为例，演示一个异步分页
102 function guestbookpage(curr,blogid) {
103 $.getJSON('/blog/getGuestbook', {
104 page: curr || 1,
105 blogId: blogid//向服务端传的参数，此处只是演示
106 }, function (res) {
107 //此处仅仅是为了演示变化的内容
108 $("#comments-list").html(res.content);
109 //显示分页
110 laypage({
111 cont: document.getElementById('textcenter'), //容器。值支持id名、原生dom对象，jquery对象。【如该容器为】：<div id="page1"></div>
112 pages: res.pages, //通过后台拿到的总页数
113 curr: curr || 1, //当前页
114 jump: function (obj, first) { //触发分页后的回调
115 if (!first) { //点击跳页触发函数自身，并传递当前页：obj.curr
116 curr = obj.curr;
117 guestbookpage(curr, blogid);
118 } else {
119 curr = first;
120 guestbookpage(curr, blogid);
121 }
122
123 }
124 });
125 });
126 };
127 </script>
128 }
129
这里博客的详情页也是通过布局页来实现的。
三、博客系统详情页留言实现
3.1留言展示页面效果
先要创建一个类在数据库中创建一个表：
Guestbook类
1 namespace Wchl.WMBlog.Model.Models
2 {
3 public class Guestbook
4 {
5
6 /// <summary>留言表
7 ///
8 /// </summary>
9 public int id { get; set; }
10
11 /// <summary>博客ID
12 ///
13 /// </summary>
14 public int? blogId { get; set; }
15 /// <summary>创建时间
16 ///
17 /// </summary>
18 public DateTime createdate { get; set; }
19 public string username { get; set; }
20
21 /// <summary>手机
22 ///
23 /// </summary>
24 public string phone { get; set; }
25 /// <summary>qq
26 ///
27 /// </summary>
28 public string QQ { get; set; }
29
30 /// <summary>留言内容
31 ///
32 /// </summary>
33 public string body { get; set; }
34 /// <summary>ip地址
35 ///
36 /// </summary>
37 public string ip { get; set; }
38
39 /// <summary>是否显示在前台,0否1是
40 ///
41 /// </summary>
42 public bool isshow { get; set; }
43
44 public BlogArticle blogarticle { get; set; }
45 }
46 }
GuestbookViewModels展示类：
1 namespace Wchl.WMBlog.Model.VeiwModels
2 {
3 /// <summary>
4 /// 留言信息展示类
5 /// </summary>
6 public class GuestbookViewModels
7 {
8 /// <summary>留言表
9 ///
10 /// </summary>
11 public int id { get; set; }
12
13 /// <summary>博客ID
14 ///
15 /// </summary>
16 public int? blogId { get; set; }
17 /// <summary>创建时间
18 ///
19 /// </summary>
20 public DateTime createdate { get; set; }
21 public string username { get; set; }
22
23 /// <summary>手机
24 ///
25 /// </summary>
26 public string phone { get; set; }
27 /// <summary>qq
28 ///
29 /// </summary>
30 public string QQ { get; set; }
31
32 /// <summary>留言内容
33 ///
34 /// </summary>
35 public string body { get; set; }
36 /// <summary>ip地址
37 ///
38 /// </summary>
39 public string ip { get; set; }
40
41 /// <summary>是否显示在前台,0否1是
42 ///
43 /// </summary>
44 public bool isshow { get; set; }
45
46 public BlogArticle blogarticle { get; set; }
47 }
48 }
GuestbookMap字段约束:
1
2 namespace Wchl.WMBlog.Model.Maps
3 {
4 public class GuestbookMap: EntityTypeConfiguration<Guestbook>
5 {
6 public GuestbookMap() {
7 this.HasKey(p => p.id);
8 //设置外键
9 this.HasRequired(p => p.blogarticle).WithMany().HasForeignKey(p => p.blogId);
10 }
11 }
12 }
接下来就是创建相应的仓储接口、实现，服务接口、实现，这里就不一一介绍了，跟上一篇实现博客类的是一样的。
我在实现这个功能的时候，想使用ajax来提交：
这里我把所有留言的内容放在一个部分视图页
_GuestbookPage代码：
1 <article>
2 <div spellcheck="false" class="example">
3 <div class="comments">
4 <header>
5 <div class="pull-right"><a href="#commentReplyForm2" class="btn btn-primary"><i class="icon-comment-alt"></i> 发表评论</a></div>
6 <h3>所有评论</h3>
7 </header>
8 <section class="comments-list" id="comments-list">
9 @{ if (ViewBag.gblist != null)
10 {
11 foreach (var list in ViewBag.gblist)
12 {
13 <div class="comment">
14 <a href="###" class="avatar">
15 <i class="icon-user icon-2x"></i>
16 </a>
17 <div class="content">
18 <div class="pull-right text-muted">@list.createdate</div>
19 <div><a href="###"><strong>@list.username</strong></a></div>
20 <div class="text">@list.body</div>
21 <div class="actions">
22 <a href="##">回复</a>
23 </div>
24 </div>
25 </div>
26 }
27 }
28
29 }
30 </section>
31 <br />
32 <div class="text-center" id="textcenter">
33
34 </div>
35 <footer>
36 <div class="reply-form" id="commentReplyForm2">
37 <a href="###" class="avatar"><i class="icon-user icon-2x"></i></a>
38 @using (Ajax.BeginForm("addGuestbook", "Blog", new AjaxOptions()
39 {
40 HttpMethod = "post",
41 OnSuccess="su"
42
43 }, new { @class = "form-horizontal" }))
44 {
45 <input type="hidden" id="blogId" name="blogId" value=""/>
46 <div class="form-group col-md-4 form-inline">
47 <label for="username" class="col-xs-3">昵称</label>
48 <div>
49 <input type="text" class="form-control" name="username" id="username" placeholder="昵称">
50 </div>
51 </div>
52 <div class="form-group col-md-4 form-inline">
53 <label for="phone" class="col-xs-3">手机</label>
54 <div>
55 <input type="text" class="form-control" name="phone" id="phone" placeholder="手机">
56 </div>
57 </div>
58 <div class="form-group col-md-4 form-inline">
59 <label for="QQ" class="col-xs-3">Q Q</label>
60 <div>
61 <input type="text" class="form-control" name="QQ" id="QQ" placeholder="Q Q">
62 </div>
63 </div>
64 <div class="form-group"></div>
65 <div class="form-group">
66 <textarea class="form-control new-comment-text" id="body" name="body" rows="4" placeholder="撰写留言..."></textarea>
67 </div>
68 <div class="form-group comment-user">
69 <div class="row">
70 <div class="col-md-2 col-md-offset-10"><button type="submit" class="btn btn-block btn-primary " value="提交">提交</button></div>
71 </div>
72 </div>
73 }
74 </div>
75 </footer>
76 </div>
77 </div>
78 </article>
79
其中分为两部分，一部分是输入留言，一部分是展示信息。
留言提交的表单如下：
在blog控制器中实现添加数据方法：
1 /// <summary>
2 ///提交评论
3 /// </summary>
4 /// <param name="model"></param>
5 /// <returns></returns>
6 [HttpPost]
7 public ActionResult addGuestbook(GuestbookViewModels model)
8 {
9 model.createdate = DateTime.Now;
10 model.ip = Request.UserHostAddress;
11 //AutoMapper自动映射
12 Mapper.Initialize(cfg => cfg.CreateMap<GuestbookViewModels, Guestbook > ());
13 Guestbook models = Mapper.Map< GuestbookViewModels, Guestbook> (model);
14 BlogArticle blogArticle = BlogArticleServive.QueryWhere(a => a.bID == model.blogId).FirstOrDefault();
15 blogArticle.bcommentNum += 1;
16 BlogArticleServive.SaverChanges();
17 GuestbookServices.Add(models);
18 GuestbookServices.SaverChanges();
19 ViewBag.gblist = GuestbookServices.QueryOrderBy(c => c.blogId == model.blogId, c => c.createdate, false).ToPagedList(1, 5);
20 return PartialView("_GuestbookPage");
21 }
执行成功之后就把信息加载到分页信息的位置。
3.2添加实现之后就是展示数据，展示数据使用的是一个js分页插件laypage.js
在mvc的视图中只能在页面有一个model类，所以就只能使用ViewBag.gblist来传值了，本来这个打算用mvcpager插件，结果发现不行，就只能使用js来分页，实现如下：
后台blog控制器下，实现分页，然后拼接数据：
1 /// <summary>
2 /// js分页实现
3 /// </summary>
4 /// <param name="page"></param>
5 /// <param name="blogId"></param>
6 /// <returns></returns>
7 public ActionResult getGuestbook(int page,int blogId)
8 {
9 StringBuilder sb = new StringBuilder();
10 int pages = 0;
11 var modelsLists = GuestbookServices.QueryByPage(page, 5,out pages, c => c.blogId == blogId, c => c.createdate, false);
12 foreach (var item in modelsLists)
13 {
14 sb.AppendFormat(@"<div class='comment'>
15 <a href = '###' class='avatar'>
16 <i class='icon-user icon-2x'></i>
17 </a>
18 <div class='content'>
19 <div class='pull-right text-muted'>{0}</div>
20 <div><a href = '###' ><strong > {1}</strong ></a ></div>
21 <div class='text'>{2}</div>
22 <div class='actions'>
23 <a href = '##' > 回复 </a>
24 </div >
25 </div >
26 </div >",item.createdate,item.username,item.body);
27 }
28 if (pages % 5 == 0)
29 {
30 pages = pages / 5;
31 }
32 else
33 {
34 pages = (pages / 5)+1;
35 }
36
37
38 return Json(new {
39 content = sb.ToString(),
40 pages= pages
41 });
42 }
在详情页中直接调用就可以了实现分页了
四、博客系统广告轮播图管理实现
4.1实现效果这里的轮播图使用的是zui中组件来实现的，
4.2主页轮播图视图中的代码实现
4.3轮播图管理后台页面实现展示
这里上传图片使用的是百度的上传控件
视图页代码实现:
1
2 @{
3 ViewBag.Title = "广告管理";
4 }
5 @section stylesheet{
6 <link href="~/Content/CSS/blogArticleStyle.css" rel="stylesheet" />
7 <link href="~/Content/lib/DataTables/css/jquery.dataTables.css" rel="stylesheet" />
8 <link href="~/Content/lib/DataTables/css/dataTables.bootstrap.css" rel="stylesheet" />
9 <link href="~/Content/lib/webuploader/dist/webuploader.css" rel="stylesheet" />
10 <style type="text/css">
11 .uploader-list {
12 width: 100%;
13 overflow: hidden;
14 }
15
16 .file-item {
17 float: left;
18 position: relative;
19 margin: 0 20px 20px 0;
20 padding: 4px;
21 }
22
23 .file-item .info {
24 position: absolute;
25 left: 4px;
26 bottom: 4px;
27 right: 4px;
28 height: 20px;
29 line-height: 20px;
30 text-indent: 5px;
31 background: rgba(0, 0, 0, 0.6);
32 color: white;
33 overflow: hidden;
34 white-space: nowrap;
35 text-overflow: ellipsis;
36 font-size: 12px;
37 z-index: 10;
38 }
39
40 .file-item .error {
41 position: absolute;
42 top: 4px;
43 left: 4px;
44 right: 4px;
45 background: red;
46 color: white;
47 text-align: center;
48 height: 20px;
49 font-size: 14px;
50 line-height: 23px;
51 }
52
53 .upload-state-done:after {
54 content: "\f00c";
55 font-family: FontAwesome;
56 font-style: normal;
57 font-weight: normal;
58 line-height: 1;
59 -webkit-font-smoothing: antialiased;
60 -moz-osx-font-smoothing: grayscale;
61 font-size: 32px;
62 position: absolute;
63 bottom: 0;
64 right: 4px;
65 color: #4cae4c;
66 z-index: 99;
67 }
68
69 .thumbnail {
70 }
71 /*表格信息对齐重写*/
72 .dataTables_wrapper .dataTables_length {
73 float: left;
74 margin-left: 15px;
75 margin-top: 5px;
76 }
77 </style>
78 }
79
80 @*<link href="~/Content/CSS/userStyle.css" rel="stylesheet" />*@
81 <script src="~/Content/lib/DataTables/js/jquery.dataTables.js"></script>
82 <script src="~/Content/lib/DataTables/js/dataTables.bootstrap.js"></script>
83 <script src="~/Content/lib/webuploader/dist/webuploader.js"></script>
84 <script type="text/javascript">
85 var table;
86 // 图片上传demo
87 $(function () {
88 //百度上传方法
89 baiduuploader();
90 //创建表格
91 creatabel();
92 });
93 //初始化表格
94 function creatabel() {
95 table = $('#adtabel').DataTable({
96 "processing": true,
97 "serverSide": true,
98 //"paging": true,
99 "scrollY": 366,
100 "ajax": {
101 url: '@Url.Action("getData", "Advertisement")'
102 //"dataType": "json"
103 },
104 // "pagingType": "full_numbers",
105 // "sLoadingRecords": "正在加载数据...",
106 // "sZeroRecords": "暂无数据",
107 //"stateSave": true,
108 "searching": false,
109 "aaSorting": [[1, "desc"]],//默认第几个排序
110 "dom": 'rt<"bottom"iflp><"clear">',
111 "columns": [
112 {
113 "data": "count",
114 "width": "28px",
115 },
116 {
117 "data": "imgUrl",
118 "width": "60px",
119 render: function (data, type, row, meta) {
120 //这里是主题 把url变成超链接、把图片路径显示为图片
121 //return "<a href='" + data + "'>" + data + "</a>";
122 return "<img src='" + data + "' style='width:50px;height:50px' />";
123 }
124 },
125 { "data": "title" },
126 { "data": "url" },
127 { "data": "createdate" },
128 { "data": "remark" },
129 {
130 data: null
131 }
132 ],
133 "columnDefs": [
134 {
135 // 指定第一列，从0开始，0表示第一列，1表示第二列……
136 targets: -1,
137 "width": "100px",
138 render: function (data, type, row, meta) {
139 return '<a type="button" class="btn btn-danger" href="#" onclick="del(\'' + row.id + '\')" ><i class="icon icon-trash"></i>删除</a>'
140 }
141 }
142 ],
143 "language": {
144 "processing": "玩命加载中...",
145 "lengthMenu": "显示 _MENU_ 项结果",
146 "zeroRecords": "没有匹配结果",
147 "info": "显示第 _START_ 至 _END_ 项结果，共 _TOTAL_ 项",
148 "infoEmpty": "显示第 0 至 0 项结果，共 0 项",
149 "infoFiltered": "(由 _MAX_ 项结果过滤)",
150 "infoPostFix": "",
151 "url": "",
152 "paginate": {
153 "first": "首页",
154 "previous": "上一页",
155 "next": "下一页",
156 "last": "末页"
157 }
158 }
159 });
160 };
161
162 //删除轮播数据
163 function del(adid) {
164 if (confirm("是否确认删除？"))
165 {
166 $.post('@Url.Action("del", "Advertisement")', { id: adid },function(ajaxobj){
167 if(ajaxobj.status=="0")
168 {
169 //如果后台删除成功，则刷新表格，并提示用户删除成功
170 //保留分页信息
171 table.ajax.reload(null,false);
172 alert("删除成功");
173 }
174 })
175 }
176 }
177
178 //百度上传
179 function baiduuploader() {
180 var $ = jQuery,
181 $list = $('#fileList'),
182 // 优化retina, 在retina下这个值是2
183 ratio = window.devicePixelRatio || 1,
184
185 // 缩略图大小
186 thumbnailWidth = 80 * ratio,
187 thumbnailHeight = 80 * ratio,
188
189 // Web Uploader实例
190 uploader;
191
192 // 初始化Web Uploader
193 uploader = WebUploader.create({
194
195 // 自动上传。
196 auto: true,
197
198 // swf文件路径
199 swf: '/Content/lib/webuploader/dist/Uploader.swf',
200
201 // 文件接收服务端。
202 server: '@Url.Action("UpLoadProcess", "Advertisement")',
203
204 // 选择文件的按钮。可选。
205 // 内部根据当前运行是创建，可能是input元素，也可能是flash.
206 pick: '#filePicker',
207
208 // 只允许选择文件，可选。
209 accept: {
210 title: 'Images',
211 extensions: 'gif,jpg,jpeg,bmp,png',
212 mimeTypes: 'image/*'
213 }
214 });
215
216 // 当有文件添加进来的时候
217 uploader.on('fileQueued', function (file) {
218 var $li = $(
219 '<div id="' + file.id + '" class="file-item thumbnail">' +
220 '<img>' +
221 '<div class="info">' + file.name + '</div>' +
222 '</div>'
223 ),
224 $img = $li.find('img');
225
226 $list.append($li);
227
228 // 创建缩略图
229 uploader.makeThumb(file, function (error, src) {
230 if (error) {
231 $img.replaceWith('<span>不能预览</span>');
232 return;
233 }
234
235 $img.attr('src', src);
236 }, thumbnailWidth, thumbnailHeight);
237 });
238
239 // 文件上传过程中创建进度条实时显示。
240 uploader.on('uploadProgress', function (file, percentage) {
241 var $li = $('#' + file.id),
242 $percent = $li.find('.progress span');
243
244 // 避免重复创建
245 if (!$percent.length) {
246 $percent = $('<p class="progress"><span></span></p>')
247 .appendTo($li)
248 .find('span');
249 }
250
251 $percent.css('width', percentage * 100 + '%');
252 });
253
254 // 文件上传成功，给item添加成功class, 用样式标记上传成功。
255 uploader.on('uploadSuccess', function (file, response) {
256 $('#' + file.id).addClass('upload-state-done');
257 //alert(response.filePath);
258 $('#ImgUrl').val(response.filePath);
259 });
260
261 // 文件上传失败，现实上传出错。
262 uploader.on('uploadError', function (file) {
263 var $li = $('#' + file.id),
264 $error = $li.find('div.error');
265
266 // 避免重复创建
267 if (!$error.length) {
268 $error = $('<div class="error"></div>').appendTo($li);
269 }
270
271 $error.text('上传失败');
272 });
273
274 // 完成上传完了，成功或者失败，先删除进度条。
275 uploader.on('uploadComplete', function (file) {
276 $('#' + file.id).find('.progress').remove();
277 });
278 };
279 //上传轮播信息成功之后调用
280 function afterSu(ajaxobj) {
281 if (ajaxobj.status == "0") {
282 alert("上传成功！");
283 window.location.reload();
284 } else if (ajaxobj.status == "1") {
285 alert("上传失败！");
286 window.location.reload();
287 }
288 }
289 </script>
290
291 <!-- head star -->
292 <div class="tnav row border-bottom white-bg page-heading">
293 <div class="col-sm-4">
294 <h2 class="fl">博客后台</h2>
295 <ol class="breadcrumb fl">
296 <li><a href="/admin/Home">广告管理</a></li>
297 <li><strong>轮播图管理</strong></li>
298 </ol>
299 </div>
300 </div>
301 <!-- head end -->
302
303 <div class="example scrollbar-hover" style="max-height: 600px; overflow: scroll;">
304 <!--table star-->
305 <table id="adtabel" class="table table-striped table-bordered table-hover dataTables-example dataTable" cellspacing="0">
306 <thead>
307 <tr>
308 <th>编号</th>
309 <th>图片</th>
310 <th>标题</th>
311 <th>链接</th>
312 <th>创建时间</th>
313 <th>备注</th>
314 <th>操作</th>
315 </tr>
316 </thead>
317 <!-- tbody是必须的 -->
318
319 </table>
320 <!--table end-->
321 <hr />
322 <!--form star-->
323 @using (Ajax.BeginForm("add", "Advertisement", new AjaxOptions()
324 {
325 HttpMethod = "post",
326 OnSuccess = "afterSu"
327 }, new { @class = "form-horizontal" }))
328 {
329 <input type="hidden" id="ImgUrl" name="ImgUrl" value="" />
330 <div class="form-group">
331 <div class="form-group">
332 <label for="Title" class="col-sm-2">标题：</label>
333 <div class="col-md-4 col-sm-10">
334 <input type="text" class="form-control" id="Title" name="Title" placeholder="标题">
335 </div>
336 </div>
337 <div class="form-group">
338 <label for="Url" class="col-sm-2">链接：</label>
339 <div class="col-md-4 col-sm-10">
340 <input type="text" class="form-control" name="Url" id="Url" placeholder="http://">
341 </div>
342 </div>
343 <div class="form-group">
344 <label for="Remark" class="col-sm-2">备注：</label>
345 <div class="col-md-4 col-sm-10">
346 <textarea rows="2" type="text" class="form-control" name="Remark" id="Remark" placeholder="说明"></textarea>
347 </div>
348 </div>
349 </div>
350 <div class="form-group">
351 <label for="exampleInputPassword4" class="col-sm-2">上传图片：</label>
352 <div class="col-md-10 col-sm-10">
353 <!--dom结构部分-->
354 <div id="uploader-demo">
355 <!--用来存放item-->
356 <div id="fileList" class="uploader-list"></div>
357 <div id="filePicker">选择图片</div>
358 </div>
359 </div>
360 </div>
361 <div class="form-group">
362 <div class="col-sm-offset-2 col-sm-10">
363 <button type="submit" class="btn btn-info">提交</button>
364 </div>
365 </div>
366 }
367 <!--form end-->
368 </div>
369
370
371
控制器实现后台代码
1 namespace Wchl.WMBlog.WebUI.Areas.admin.Controllers
2 {
3 public class AdvertisementController : BaseController
4 {
5 IAdvertisementServices AdvertisementServices;
6 public AdvertisementController(IAdvertisementServices AdvertisementServices)
7 {
8 this.AdvertisementServices = AdvertisementServices;
9 }
10
11 // GET: admin/Advertisement
12 public ActionResult Index()
13 {
14 return View();
15 }
16
17 /// <summary>
18 /// 获取广告信息
19 /// </summary>
20 /// <returns></returns>
21 public ActionResult getData()
22 {
23 int pageIndex = Request["start"] != null ? int.Parse(Request["start"]) : 1;
24 int pageSize = Request["length"] != null ? int.Parse(Request["length"]) : 5;
25 int draw = Request["draw"] != null ? int.Parse(Request["draw"]) : 1;
26 int totalCount;
27 int count = 0;
28 var adInfoList = AdvertisementServices.QueryByBeginPage(pageIndex, pageSize, out totalCount, r =>true , r => r.Createdate, false);
29 var temp = from u in adInfoList
30 select new { count= count+=1, ID = u.Id, Title = u.Title, ImgUrl = u.ImgUrl, Createdate = u.Createdate,url=u.Url, Remark = u.Remark };
31 return Json(new {
32 data = temp.ToList(),
33 draw = draw,
34 recordsTotal = totalCount,
35 recordsFiltered = totalCount
36 },JsonRequestBehavior.AllowGet);
37 }
38
39 /// <summary>
40 /// 删除广告
41 /// </summary>
42 /// <param name="id"></param>
43 /// <returns></returns>
44 [HttpPost]
45 public ActionResult del(int id)
46 {
47 Advertisement model = new Advertisement() {Id=id };
48 AdvertisementServices.Delete(model, false);
49 AdvertisementServices.SaverChanges();
50 return Json(new { status = "0" },JsonRequestBehavior.AllowGet);
51 }
52
53 /// <summary>
54 /// 添加广告信息
55 /// </summary>
56 /// <returns></returns>
57 [HttpPost]
58 public ActionResult Add(AdvertisementViewModels model)
59 {
60 model.Createdate = DateTime.Now;
61 //AutoMapper自动映射
62 Mapper.Initialize(cfg => cfg.CreateMap<AdvertisementViewModels, Advertisement>());
63 Advertisement models = Mapper.Map<AdvertisementViewModels, Advertisement>(model);
64 AdvertisementServices.Add(models);
65 AdvertisementServices.SaverChanges();
66 return Json(new { status="0" },JsonRequestBehavior.AllowGet);
67 }
68
69 /// <summary>
70 /// 百度上传图片
71 /// </summary>
72 /// <param name="id">百度插件自定义对图片的命名id</param>
73 /// <param name="name">图片名称</param>
74 /// <param name="type">图片类型</param>
75 /// <param name="lastModifiedDate">图片本身的修改时间</param>
76 /// <param name="size">图片大小</param>
77 /// <param name="file">文件流</param>
78 /// <returns></returns>
79 public ActionResult UpLoadProcess(string id, string name, string type, string lastModifiedDate, int size, HttpPostedFileBase file)
80 {
81 string filePathName = string.Empty;
82
83 string localPath = Server.MapPath("/upload/");
84 if (Request.Files.Count == 0)
85 {
86 return Json(new { jsonrpc = 2.0, error = new { code = 102, message = "保存失败" }, id = "id" });
87 }
88
89 string ex = Path.GetExtension(file.FileName);
90 filePathName = Guid.NewGuid().ToString("N") + ex;
91
92 string datedir = DateTime.Now.ToString("yyyyMMdd");
93 if (!Directory.Exists(localPath + datedir))
94 {
95 Directory.CreateDirectory(localPath + datedir);
96 }
97 string path = localPath + datedir;
98 try
99 {
100 file.SaveAs(Path.Combine(path, filePathName));
101 }
102 catch (Exception)
103 {
104 return Json(new { jsonrpc = 2.0, error = new { code = 103, message = "保存失败" }, id = "id" });
105 }
106 return Json(new
107 {
108 jsonrpc = "2.0",
109 id = id,
110 filePath = "/Upload/"+datedir + "/" + filePathName
111 });
112
113 }
114 }
115 }
广告对应的表的类Advertisement：
1 namespace Wchl.WMBlog.Model.Models
2 {
3 public class Advertisement
4 {
5 /// <summary>
6 /// 分类ID
7 /// </summary>
8 public int Id { get; set; }
9 /// <summary>
10 /// 创建时间
11 /// </summary>
12 public DateTime Createdate { get; set; }
13
14 /// <summary>
15 /// 广告图片
16 /// </summary>
17 public string ImgUrl { get; set; }
18
19 /// <summary>
20 /// 广告标题
21 /// </summary>
22 public string Title { get; set; }
23
24 /// <summary>
25 /// 广告链接
26 /// </summary>
27 public string Url { get; set; }
28
29 /// <summary>
30 /// 备注
31 /// </summary>
32 public string Remark { get; set; }
33 }
34 }
展示类AdvertisementViewModels:
1 namespace Wchl.WMBlog.Model.VeiwModels
2 {
3 /// <summary>
4 /// 广告类
5 /// </summary>
6 public class AdvertisementViewModels
7 {
8 /// <summary>
9 /// 分类ID
10 /// </summary>
11 public int Id { get; set; }
12 /// <summary>
13 /// 创建时间
14 /// </summary>
15 public DateTime Createdate { get; set; }
16
17 /// <summary>
18 /// 广告图片
19 /// </summary>
20 public string ImgUrl { get; set; }
21
22 /// <summary>
23 /// 广告标题
24 /// </summary>
25 public string Title { get; set; }
26
27 /// <summary>
28 /// 广告链接
29 /// </summary>
30 public string Url { get; set; }
31
32 /// <summary>
33 /// 备注
34 /// </summary>
35 public string Remark { get; set; }
36 }
37 }
表约束AdvertisementMap:
1 namespace Wchl.WMBlog.Model.Maps
2 {
3 public class AdvertisementMap: EntityTypeConfiguration<Advertisement>
4 {
5 public AdvertisementMap()
6 {
7 this.HasKey(p => p.Id);
8 this.Property(p => p.ImgUrl).HasMaxLength(512);
9 this.Property(p => p.Title).HasMaxLength(64);
10 this.Property(p => p.Url).HasMaxLength(256);
11 }
12 }
13 }
这里实现的是添加图片自动上传：
五、博客系统右侧统计
5.1效果显示，这里的统计主要是对发布时间、阅读排行、评论排行做了统计。
后台实现代码：
部分布局视图代码：
1 <!--右边栏部分-->
2 <aside>
3 <div class="col-md-4">
4 <section class="youbianlan">
5 <div class="panel-group">
6 <div class="panel">
7 <div class="panel-heading">
8 <div class="panel-title panel-info">
9 <h4>最新发布</h4>
10 </div>
11 </div>
12 <div class="panel-body">
13 <ul>
14 @{
15 if (ViewBag.blogtimelist != null)
16 {
17 for (int i = 0; i < 10; i++)
18 {
19 <li><a href="/blog/Detail/@ViewBag.blogtimelist[i].bID">@ViewBag.blogtimelist[i].btitle</a></li>
20 }
21 }
22
23 }
24 </ul>
25 </div>
26 </div>
27 </div>
28 </section>
29 <section class="youbianlan">
30 <div class="panel-group">
31 <div class="panel">
32 <div class="panel-heading">
33 <div class="panel-title panel-info">
34 <h4>阅读排行榜</h4>
35 </div>
36 </div>
37 <div class="panel-body">
38 <ul>
39 @{
40 if (ViewBag.blogtrafficlist != null)
41 {
42 for (int i = 0; i < 10; i++)
43 {
44 <li><a href="/blog/Detail/@ViewBag.blogtrafficlist[i].bID">@ViewBag.blogtrafficlist[i].btitle</a></li>
45 }
46 }
47
48 }
49 </ul>
50 </div>
51 </div>
52 </div>
53 </section>
54 <section class="youbianlan">
55 <div class="panel-group">
56 <div class="panel">
57 <div class="panel-heading">
58 <div class="panel-title panel-info">
59 <h4>评论排行榜</h4>
60 </div>
61 </div>
62 <div class="panel-body">
63 <ul>
64 @{
65 List<TopgbViewModels> list = ViewBag.blogguestbooklist as List<TopgbViewModels>;
66 if (list != null && list.Any())
67 {
68 if (list.Count < 10)
69 {
70 for (int i = 0; i < list.Count; i++)
71 {
72 <li><a href="/blog/Detail/@list[i].blogId">@list[i].btitle</a></li>
73 }
74 }
75 else
76 {
77 for (int i = 0; i < 10; i++)
78 {
79 <li><a href="/blog/Detail/@list[i].blogId">@list[i].btitle</a></li>
80 }
81 }
82
83 }
84
85 }
86 </ul>
87 </div>
88 </div>
89 </div>
90 </section>
91 </div>
92 </aside>
93 <!--右边栏部分结束-->
94
95
这里重点讲讲怎么在EF中执行SQL语句：
在仓储父类的实现中这里传入的实体就是需要展示表内容的类：
六、博客系统小结
现阶段博客系统已经完成了前台展示，后台发布基本功能，接下来打算在后台添加一个权限模块，个人能力有限，代码水平不够好，也许我这样的代码还入不了大神的法眼，等我把权限做完之后，我会一点一点的来修改代码。
其实我写代码的时间不长，主要是每次想功能怎么实现的时候，要把每一步都想到，感觉编程，真正实现功能的开发编码的时间只有40%左右。
如果大家对这个有什么意见和想法，可以提出来，我会尽量，去修改的，谢谢了。
补充内容：
根据园友提出的补漏部分说明：
这个QueryByBeginPage是在仓储层写的一个查询分页的功能，是为了配合DataTables使用的。
1 /// <summary>
2 /// 从第几条开始用于DataTables
3 /// </summary>
4 /// <typeparam name="TKey"></typeparam>
5 /// <param name="pageIndex">第几页开始</param>
6 /// <param name="pagesize">一页几条</param>
7 /// <param name="rowcount">一共多少条</param>
8 /// <param name="predicate">条件</param>
9 /// <param name="keySelector">排序关键字</param>
10 /// <param name="IsQueryOrderBy">升序还是降序</param>
11 /// <returns></returns>
12 public List<TEntity> QueryByBeginPage<TKey>(int pageIndex, int pagesize, out int rowcount, Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, TKey>> keySelector, bool IsQueryOrderBy)
13 {
14 rowcount = _dbSet.Count(predicate);
15 if (IsQueryOrderBy)
16 {
17 return _dbSet.Where(predicate).OrderBy(keySelector).Skip(pageIndex).Take(pagesize).ToList();
18 }
19 else
20 {
21 return _dbSet.Where(predicate).OrderByDescending(keySelector).Skip(pageIndex).Take(pagesize).ToList();
22 }
23 }
这个TopgbViewModels是查询统计留言排行用的一个类，是根据你数据库查询出来表建的相应的类
1 /// <summary>
2 /// 留言排名展示类
3 /// </summary>
4 public class TopgbViewModels
5 {
6 /// <summary>博客ID
7 ///
8 /// </summary>
9 public int? blogId { get; set; }
10
11 /// <summary>
12 /// 评论数量
13 /// </summary>
14 public int counts { get; set; }
15
16 /// <summary>博客标题
17 ///
18 /// </summary>
19 public string btitle { get; set; }
20 }
有什么不明白的地方都可以跟我留言，我会尽量写清楚点，让大家看的明白点。
最新文章
- (转载)解决GDI闪烁
- fontAwesome代替网页icon小图标
- DirectX 总结和DirectX 9.0 学习笔记
- FusionCharts
- php 检查email电子邮件函数(奇葩写法)
- vm安装mac系统
- Extjs3 Combo实现百度搜索查询
- 全国计算机等级考试二级教程-C语言程序设计_第14章_结构体、共用体和用户定义类型
- c++ 调用DLL函数，出现错误
- KbmMW两种查询结果集通讯方式
- java线程之线程通信控制
- javax.el.PropertyNotFoundException: Property 'XXX' not found on type bean.XXXXX
- 小L的试卷
- String 练习
- PHP：判断客户端是否使用代理服务器及其匿名级别
- A+B for Input-Output Practice (IV)
- android 异步线程刷新UI 以及 JSON解析 以及 url get请求
- 微软收购跨平台移动应用开发商Xamarin
- SpringCloud 进阶之Eureka(服务注册和发现)
- Git学习系列 (二)