bootstrap adminlte教程5：文章阅读-显示已阅读的人员名单

我想在打开文章详细，就是内容页上，加上一个已阅读人员的名单。就是哪些用户看过这篇文章。

1.建model。在Model下新建一个ListCMSUser.cs

 

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;

namespace jsdhh2.Models
{
	public class ListCMSUser
	{
		[Display(Name = "文章ID")]
		public string Id { get; set; }
        public string CmsId {get;set;}
		/// <summary>
		/// 名称
		/// </summary>
		[Display(Name = "用户名")]
		public string UserName { get; set; }

		/// <summary>
		/// URL
		/// </summary>
		[Display(Name = "头像地址")]

		public string HeadPicUrl { get; set; }


		/// <summary>
		/// URL
		/// </summary>
		[Display(Name = "角色名")]

		public string RoleName { get; set; }

		/// <summary>
		/// URL
		/// </summary>
		[Display(Name = "阅读日期")]

		public DateTime CreatTime { get; set; }


	}
}

　　

2。改更上下文。DAL-->OaDALContent.cs

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;
using jsdhh2.Models;

namespace jsdhh2.DAL
{
	public class OaDALContent : DbContext
	{
		public OaDALContent() : base("MyOaContent") { }
		public DbSet<Menu> Menus { get; set; }

		public DbSet<MenuRole> MenuRoles { get; set; }

		public DbSet<CmsColumn> CmsColumns { get; set; }
		public DbSet<ClubContent> ClubContents { get; set; }
		public DbSet<CmsContent> CmsContents { get; set; }

		public DbSet<ListCMSUser> ListCMSUsers { get; set; }

	}


}

　　3.删除firest code生成的文件。

在控制台输入

Enable-Migrations

　　然后输入我要的连接字符串

Enable-Migrations -ContextTypeName jsdhh2.DAL.OaDALContent

　　将右那那个first 生成的文件和false改为True

然后运行显示。注意Add---Table,中间--为我的连接字符DAl

 add-migration AddOaDALContentTable

　然后更改生成的这个文件201706010526208_AddOaDALContentTable，删除已存在的数据库表

　

namespace jsdhh2.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class AddOaDALContentTable : DbMigration
    {
        public override void Up()
		{
			CreateTable(
				 "dbo.ListCMSUsers",
				 c => new
				 {
					 Id = c.String(nullable: false, maxLength: 128),
					 UserName = c.String(),
					 HeadPicUrl = c.String(),
					 RoleName = c.String(),
					 CreatTime = c.DateTime(nullable: false),
				 })
				 .PrimaryKey(t => t.Id);

			 
        }
        
        public override void Down()
        {
           
            DropTable("dbo.ListCMSUsers");
            
        }
    }
}

　　5.然后运行：

PM>  update-database 

　　最后一看表，成功的新建了。

 

6.下面开始实现我的最新看过的用户清单功能了。

1）控制器，在详细方法中

 

  // GET: CmsContents/Details/5
        public async Task<ActionResult> Details(string id)
        {
			var dt = DateTime.Now;
			string str = dt.ToString("yyyyMMddHHmmss");
			 if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            CmsContent cmsContent = await db.CmsContents.FindAsync(id);
            if (cmsContent == null)
            {
                return HttpNotFound();
            }
			string ifrolename = Session["role"].ToString();
			if (!cmsContent.CmsPermission.Contains("All")& !cmsContent.CmsPermission.Contains(ifrolename)){
				return View("NoYueDu");
			}
			ViewBag.RlpyList1 = "";
			////查询并新建到表ListCMSUser表中。
			string username = Session["username"].ToString();    ///取出session的usernme的值
			var listcmsusers = (db.ListCMSUsers.Where(x => x.CmsId == id)).ToList();
			//if (listcmsusers !=null)
			if(listcmsusers.Any())
			{
				var xxx = (db.ListCMSUsers.Where(x => x.CmsId == id).Where(z => z.UserName == username)).ToList();
				if (xxx.Any())
				{
					ViewBag.ListUsers = listcmsusers;
				}
				else
				{
					var listCmsUsers = new ListCMSUser();
					listCmsUsers.Id = str;
					listCmsUsers.CmsId= id;
					listCmsUsers.UserName = username;
					listCmsUsers.RoleName = ifrolename;
					listCmsUsers.CreatTime = DateTime.Now;
					listCmsUsers.HeadPicUrl = Session["headerPic"].ToString();
					db.ListCMSUsers.Add(listCmsUsers);
					db.SaveChanges();
					ViewBag.ListUsers = listcmsusers;
				}

			}
			else
			{
				var listCmsUsers = new ListCMSUser();
				listCmsUsers.Id = str;
				listCmsUsers.CmsId = id;
				listCmsUsers.UserName = username;
				listCmsUsers.RoleName = ifrolename;
				listCmsUsers.CreatTime = DateTime.Now;
				listCmsUsers.HeadPicUrl = Session["headerPic"].ToString();
				db.ListCMSUsers.Add(listCmsUsers);
				db.SaveChanges();
				ViewBag.ListUsers = listcmsusers;


			}
			///调出所有的回复
			///
		
			var rlpyList = (db.CmsContents.Where(x => x.ReplyID == id)).ToList();
			if (rlpyList.Any())
			{
				ViewBag.RlpyList = rlpyList;
			}
			else
			{
				ViewBag.RlpyList1 = "nono";
			}
			
			return View(cmsContent);
        }

　　

　　7.前台 

@model jsdhh2.Models.CmsContent

@{
	ViewBag.Title = "Details";
	ViewBag.user11 = Model.CreatUser;

}

 <h2></h2>
<div class="col-md-8 col-xs-12">
 
	<div>
		<h2>@Html.DisplayFor(model => model.Title)</h2>
	 <h2></h2>

		<div class="panel panel-default">
			<div class="panel-heading">
				<div class="col-md-2">
					<img src=@Html.DisplayFor(model => model.yulou1) class="img-circle" style="width: 46px; height: 46px;">
				</div>
				<div>
					<a href="">@Html.DisplayFor(model => model.CreatUser) </a> <span style="color:#c7c2c2;">发表于：@Html.DisplayFor(model => model.CreatTime)</span>

					<br style="padding-left:90px; margin-top:-20px;">	IP地址：@Html.DisplayFor(model => model.PcIp) </br>

				</div>
      
			
			</div>
			 
		</div>
		 
		<div  class="dhhtentext" style="min-height:300px;">
			@Html.DisplayFor(model => model.Contents)

		</div>


		<h2></h2><h2></h2>
		 
			<div >
				@if (ViewBag.user11== Session["username"].ToString()) {

                   @Html.ActionLink("编辑", "Edit", new { id = Model.Id }, new { @class = "btn btn-warning" })
				}

			</div>
		   <hr />
		<div>
		@if (ViewBag.RlpyList1 != "nono") {
			foreach (jsdhh2.Models.CmsContent data1 in (ViewBag.RlpyList as IEnumerable<jsdhh2.Models.CmsContent>))
			{
				<div class="row">

					<div class="col-md-2">
						<img src=@data1.yulou1 class="img-circle" style="width: 46px; height: 46px;">
					</div>
					<div>
						<a href="">@data1.CreatUser </a>

						<br style="padding-left:90px; margin-top:-20px;">发表于：@data1.CreatTime	IP地址：@Html.DisplayFor(model => model.PcIp)  

					</div>
				</div>
				<div class="dhhtentext">
					@data1.Contents

				</div>


			<hr />

		}
		}
		</div>










@using (Html.BeginForm("CreateRlpy", "CmsContents", new { cmsId = Model.Id, count = Model.ReplyCount }, FormMethod.Post))
{
				@Html.AntiForgeryToken()
	  @Html.ValidationSummary(true, "", new { @class = "text-danger" })
	<div class="form-horizontal  col-md-12" style="width:100%">
		<h4>发表回复</h4>
		<hr />
		@Html.ValidationSummary(true, "", new { @class = "text-danger" })
		  <div class="form-group">
		 	<div class="col-md-10">
			<textarea name="Contents" required="" lay-verify="required" 
placeholder="我要回复" class="layui-textarea fly-editor" style="height: 150px;width:100%;" ></textarea>
			 
				@Html.ValidationMessageFor(model => model.Contents, "", new { @class = "text-danger" })
			</div>
		</div>
		 
		<div class="form-group">
			<div class="col-md-offset-2 col-md-10">
				<input type="submit" value="回复" class="btn btn-success" />
			</div>
		</div>
	</div>

 


}



	<p>
	 
	</p>
 
	
</div></div>
<div class="col-md-4 col-xs-12">
	<div class="bs-example bs-example-bg-classes" data-example-id="contextual-backgrounds-helpers">
		<p class="bg-info titlepadding">已阅读此篇文章的人有：</p>

    </div>
	<div class="user">
		<ul style="list-style:none;">
		@foreach (jsdhh2.Models.ListCMSUser data in (ViewBag.ListUsers as IEnumerable<jsdhh2.Models.ListCMSUser>))
		{
			 


			<li    style="text-align:center; float:left;">
				<img src=@data.HeadPicUrl class="img-circle" style=" padding:10px;width: 78px; height: 78px;" alt=@data.RoleName>
				<div>@data.UserName </div>
			 
			</li>
		 
	 
		}
		</ul>
	</div>
	</div>

　　

　　前台我加了回复的textrea 按钮功能。

看效果

 

 

然后看一下，回复的方法。

/// <summary>
		/// 回复的方法
		/// </summary>
		/// <param name="cmsContent"></param>
		/// <param name="form"></param>
		/// <returns></returns>
		[HttpPost]
		[ValidateAntiForgeryToken]
		public async Task<ActionResult> CreateRlpy(string cmsId,int count, [Bind(Include = "Contents")]CmsContent cmsRlpy)
		{
			var dt = DateTime.Now;
			string str = dt.ToString("yyyyMMddHHmmss");
		 
			cmsRlpy.Id = str;
			cmsRlpy.ReplyID = cmsId;
			cmsRlpy.CreatUser = Session["username"].ToString();
			cmsRlpy.PcIp = Request.UserHostAddress;
			cmsRlpy.ReplyCount = count+1;
			cmsRlpy.CreatTime = DateTime.Now;
			cmsRlpy.yulou1 = Session["headerPic"].ToString();
			cmsRlpy.ColumnId = 0;
		 


			if (ModelState.IsValid)
			{
				db.CmsContents.Add(cmsRlpy);
				await db.SaveChangesAsync();
				return RedirectToAction("Details", "CmsContents",new { id= cmsId });
			}

			return View(cmsRlpy);
		}

　　测试，一切正常。

现在需要在详细页面增加对他的调用。