bootstrap adminlte教程10：问答系统的ClubContents的信息管理员的功能
因为问答有涉及公开和不公开。
现在才发现要怎么实现哩，其实最好的方法我觉得是在用户的信息中，给他增加一个字段，是否信息管理员。但又得再次扩充字段。
要么新建一个信息管理员的表？来对应当前角色名，如是存在则返T，不存在则返F，即在搜索信息前加一个总的IF？
好头痛。
为了方便，我觉得还是新建一个表了，就二个字段，一个ID，一个username,为什么不用UserId哩，我老觉得又要去关联一次，反正UserName我们存在了Session中。
1.新建模型
我这新建了一个，还把邮箱太详细（内部的象短信内能的一起建了），好FIRST CODE
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;
namespace jsdhh2.Models
{
public class InfoManageUser
{
/// <summary>
/// 菜单ID
/// </summary>
[Display(Name = "管理用户id")]
public string Id { get; set; }
[Required]
[Display(Name = "信息员")]
public string InfoUsers{ get; set; }
public string bei { get; set; }
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;
namespace jsdhh2.Models
{
public class Email
{
/// <summary>
/// 菜单ID
/// </summary>
[Display(Name = "邮件id")]
public string Id { get; set; }
[Display(Name = "创建日期")]
[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:yyyy-MM-dd HH:mm:ss}")]
public DateTime CreatTime { get; set; }
[Display(Name = "查看日期")]
[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:yyyy-MM-dd HH:mm:ss}")]
public DateTime ShowTime { get; set; }
public int ColumnId { get; set; }
[StringLength(60, MinimumLength = 3, ErrorMessage = "主题的长度必须在3到60个字符")]
public string Title { get; set; }
[Required]
public string Contents { get; set; }
[Display(Name = "发件人")]
public string CreatUser { get; set; }
[Display(Name = "收件人")]
public string ReceiveUser{ get; set; }
[Display(Name = "发件人IP")]
public string PcIp { get;set; }
[Display(Name = "状态")]
public string EmailState { get; set; }
public string UserList { get; set; }
[Display(Name = "头像")]
public string HeadPic { get; set; }
public string bei1 { get; set; }
public string bei2 { 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; }
public DbSet<InfoManageUser> InfoManageUsers{ get; set; }
public DbSet<Email> Emails { get; set; }
}
}
3.生成解决方案
4.打开控制台
Enable-Migrations
然后：
Enable-Migrations -ContextTypeName jsdhh2.DAL.OaDALContent
看见没，二个数据库已成功的 code first
5.添加一个基本EF的带视图的控制器。InfoManageUsersController
这样做的主要目的是，大部份工作都不需要我们做了。
6.在后台，用管理员增加菜单管理，同时对Super用户授权。
7.然后修改样式。
index
edit
详细
删除四个样式。
然后成功新建二个信息管理员
7，改写ClubContents的index方法。
先用
///先分析当前用户是否是信息管理员，在infomanageruser表中进行搜索.然后ifuser.count>0
string varuser = Session["username"].ToString();
var ifuser =from a in db.InfoManageUsers.Where(x =>x.InfoUsers== varuser)
select a;
if (ifuser.Count() > 0)
{}
上面的方法进行读写，分析是否存在数据。
然后再改写所有的读的LING，都加上一句，如《0，则要creatUser=session[username]
public ActionResult Index(string ClubState, string listColumn, string SearchString, int? page)
{
///先分析当前用户是否是信息管理员，在infomanageruser表中进行搜索.然后ifuser.count>0
string varuser = Session["username"].ToString();
var ifuser =from a in db.InfoManageUsers.Where(x =>x.InfoUsers== varuser)
select a;
//读出所有的栏目到表中
ViewBag.drolistmenu = db.CmsColumns.Where(x => x.ColumnType == "2");
///当没有字符串产生的时候，为PAGE1
if ( !string.IsNullOrEmpty(ClubState) && !string.IsNullOrEmpty(SearchString) && !string.IsNullOrEmpty(listColumn))
{
page = 1;
}
ViewBag.listColumn = listColumn;
ViewBag.ClubState = ClubState;
ViewBag.SearchString = SearchString;
///获取数据,我们默认显示未完结
var seachindex = from w in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null).Where(x => x.ClubState == "0")
select w;
//再次分析栏目
///首先看栏目变量是否为空
if (!string.IsNullOrEmpty(listColumn))
{
int clounid = int.Parse(listColumn);
if (ClubState == "1")
{
if (ifuser.Count() > 0)
{
seachindex = from l in db.ClubContents.OrderByDescending(q => q.CreatTime).Where(m => m.ReplyID == null).Where(x => x.ClubState == "1").Where(p => p.ColumnId == clounid)
select l;
}
else
{
seachindex = from l in db.ClubContents.OrderByDescending(q => q.CreatTime).Where(m => m.ReplyID == null).Where(x => x.ClubState == "1").Where(p => p.ColumnId == clounid).Where(t =>t.CreatUser== varuser)
select l;
}
}
else
{
if (ifuser.Count() > 0)
{
seachindex = from l in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null).Where(x => x.ClubState == "0").Where(k => k.ColumnId == clounid)
select l;
}
else
{
seachindex = from l in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null).Where(x => x.ClubState == "0").Where(k => k.ColumnId == clounid).Where(t => t.CreatUser == varuser)
select l;
}
}
}
else
{
if (ClubState == "1")
{
if (ifuser.Count() > 0)
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null).Where(x => x.ClubState == "1")
select x;
}
else
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null).Where(x => x.ClubState == "1").Where(t => t.CreatUser == varuser)
select x;
}
}
if (ClubState == "all")
{
if (ifuser.Count() > 0)
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null)
select x;
}
else
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null).Where(t => t.CreatUser == varuser)
select x;
}
}
}
//搜索,如是搜索字符串不为空，则取消所有的，只取Title包含有，同时降序
if (!string.IsNullOrEmpty(SearchString))
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null).Where(x => x.Title.Contains(SearchString))
select x;
}
int pageNumber = page ?? 1;
int pageSize =8;
//通过ToPagedList扩展方法进行分页
//IPagedList<CmsContent> pagedList = seachindex.ToPagedList(pageNumber, pageSize);
return View(seachindex.ToPagedList(pageNumber, pageSize));
}
改写index方法
// GET: ClubContents
public ActionResult Index(string ClubState, string listColumn, string SearchString, int? page)
{
///先分析当前用户是否是信息管理员，在infomanageruser表中进行搜索.然后ifuser.count>0
string varuser = Session["username"].ToString();
var ifuser =from a in db.InfoManageUsers.Where(x =>x.InfoUsers== varuser)
select a;
//读出所有的栏目到表中
ViewBag.drolistmenu = db.CmsColumns.Where(x => x.ColumnType == "2");
///当没有字符串产生的时候，为PAGE1
if ( !string.IsNullOrEmpty(ClubState) && !string.IsNullOrEmpty(SearchString) && !string.IsNullOrEmpty(listColumn))
{
page = 1;
}
ViewBag.listColumn = listColumn;
ViewBag.ClubState = ClubState;
ViewBag.SearchString = SearchString;
///获取数据,我们默认显示未完结
var seachindex = from w in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null&& m.ClubState == "0")
select w;
//再次分析栏目
///首先看栏目变量是否为空
if (!string.IsNullOrEmpty(listColumn))
{
int clounid = int.Parse(listColumn);
if (ClubState == "1")
{
if (ifuser.Count() > 0)
{
seachindex = from l in db.ClubContents.OrderByDescending(q => q.CreatTime).Where(m => m.ReplyID == null&& m.ClubState == "1"&& m.ColumnId == clounid)
select l;
}
else
{
seachindex = from l in db.ClubContents.OrderByDescending(q => q.CreatTime).Where(m => m.ReplyID == null&& m.ClubState == "1"&& m.ColumnId == clounid).Where(t =>t.CreatUser== varuser||t.ClubPermission=="1")
select l;
}
}
else
{
if (ifuser.Count() > 0)
{
seachindex = from l in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null&& m.ClubState == "0"&& m.ColumnId == clounid)
select l;
}
else
{
seachindex = from l in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null&& m.ClubState == "0"&& m.ColumnId == clounid).Where(t => t.CreatUser == varuser || t.ClubPermission == "1")
select l;
}
}
}
else
{
if (ClubState == "1")
{
if (ifuser.Count() > 0)
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null&& m.ClubState == "1")
select x;
}
else
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null&& m.ClubState == "1").Where(t => t.CreatUser == varuser || t.ClubPermission == "1")
select x;
}
}
if (ClubState == "all")
{
if (ifuser.Count() > 0)
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null)
select x;
}
else
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null).Where(t => t.CreatUser == varuser||t.ClubPermission == "1")
select x;
}
}
}
//搜索,如是搜索字符串不为空，则取消所有的，只取Title包含有，同时降序
if (!string.IsNullOrEmpty(SearchString))
{
if (ifuser.Count() > 0)
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null&& m.Title.Contains(SearchString))
select x;
}
else
{
seachindex = from x in db.ClubContents.OrderByDescending(c => c.CreatTime).Where(m => m.ReplyID == null&& m.Title.Contains(SearchString)).Where(t => t.CreatUser == varuser || t.ClubPermission == "1")
select x;
}
}
int pageNumber = page ?? 1;
int pageSize =8;
//通过ToPagedList扩展方法进行分页
//IPagedList<CmsContent> pagedList = seachindex.ToPagedList(pageNumber, pageSize);
return View(seachindex.ToPagedList(pageNumber, pageSize));
}
//
浙公网安备 33010602011771号