public string GeTeamRank()
{
UserGroupService usergSerivice = new UserGroupService();
UserService userService = new UserService();
List<UserGroup> usergList = usergSerivice.FindAll();
List<RankListTeam> rankListTeam = new List<RankListTeam>();
List<User> userList = new List<User>();
for (int i = 2; i < usergList.Count; i++) {
userList = userService.FindUsersByGroupId(usergList[i].Id);
int count = 0;
for (int j = 0; j < userList.Count; j++) {
//获取每个用户的发表的知识数量，并求和
AriticleService ariticleService = new AriticleService();
int n = ariticleService.GetAriticleCount(userList[j].Id);
count += n;
}
RankListTeam rlt = new RankListTeam();
rlt.Title = usergList[i].Title;
rlt.AriticleCount = count;
rankListTeam.Add(rlt);
}
//对结果排序
var queryResults =
from n in rankListTeam
orderby n.AriticleCount descending
select n;
List<RankListTeam> rktList = new List<RankListTeam>();
foreach (var n in queryResults)
{
rktList.Add(n);
}
string result = JsonConvert.SerializeObject(rktList);
return result;
}
private void grdUserGroupDataBind()
{
UserGroupService userGroupService = new UserGroupService();
grdUserGroup.DataSource = userGroupService.FindAll();
grdUserGroup.DataBind();
}
public string Add(string title) {
UserGroup ug = new UserGroup();
ug.Title = title;
UserGroupService ugs = new UserGroupService();
ugs.Add(ug);
List<UserGroup> list = ugs.FindAll();
UserGroupViewModel ugv = new UserGroupViewModel(list[list.Count-1]);
string result = JsonConvert.SerializeObject(ugv);
return result;
}
//得到所有用户分组
public string GetUserGroups() {
UserGroupService ugs = new UserGroupService();
List<UserGroup> list = ugs.FindAll();
List<UserGroupViewModel> ugvList = new List<UserGroupViewModel>();
for (int i = 0; i < list.Count; i ++ )
{
UserGroupViewModel ugv = new UserGroupViewModel(list[i]);
ugvList.Add(ugv);
}
string result = JsonConvert.SerializeObject(ugvList);
return result;
}
public string Rename(string id,string name) {
UserGroupService ugs = new UserGroupService();
List<UserGroup> list = ugs.FindAll();
UserGroup ug = new UserGroup();
for (int i = 0; i < list.Count; i++)
{
if (id == list[i].Id + "")
{
ug = list[i];
}
}
ug.Title = name;
ugs.Update(ug);
return null;
}
// GET: Users/Create
public async Task <IActionResult> Create()
{
if (_userService.VerificarAutenticacao() == 0 || _userService.VerificarAutenticacao() == 1)
{
return(RedirectToAction("Login", "Users"));
}
var userGroups = await _userGroupsService.FindAll();
var viewModel = new UserViewModel {
UserGroups = userGroups
};
return(View(viewModel));
}
public ActionResult UploadAriticle()
{
UserGroupService ugs = new UserGroupService();
List<UserGroup> list = ugs.FindAll();
List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>();
UserGroupViewModel ugv;
for (int i = 0; i < list.Count; i++)
{
ugv = new UserGroupViewModel(list[i]);
ugvlist.Add(ugv);
}
string result = JsonConvert.SerializeObject(ugvlist);
ViewBag.OpenString = result;
return View();
}
//动态获取当前数据库中的 组 列表
public ActionResult GetGroups()
{
UserGroupService usergroup = new UserGroupService();
List<UserGroup> usergrouplist = new List<UserGroup>();
usergrouplist = usergroup.FindAll();
List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>();
UserGroupViewModel ugv;
for (int i = 0; i < usergrouplist.Count; i++)
{
ugv = new UserGroupViewModel(usergrouplist[i]);
ugvlist.Add(ugv);
}
//string resultlist = JsonConvert.SerializeObject(ugvlist);
string result = JsonConvert.SerializeObject(ugvlist);
return Content(result);
}
public ActionResult ToKnowledgeModify(string ariticleId)
{
using (RRDLEntities db = new RRDLEntities())
{
AriticleService ars = new AriticleService(db);
Ariticle ariticle = ars.FindById(ariticleId);
AriticleViewModel avm = new AriticleViewModel(ariticle);
List<AriticleVisibility> visibilityList = ars.GetAriticleVisibility(ariticle.Id);
avm.Id = ariticle.Id;
string result = JsonConvert.SerializeObject(avm);
ViewBag.Ariticle = result;
UserGroupService ugs = new UserGroupService();
List<UserGroup> list = ugs.FindAll();
List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>();
UserGroupViewModel ugv;
for (int i = 0; i < list.Count; i++)
{
ugv = new UserGroupViewModel(list[i]);
ugvlist.Add(ugv);
}
string resultlist = JsonConvert.SerializeObject(ugvlist);
ViewBag.OpenString = resultlist;
Tree tree = new Tree();
TreeNode treeNode = tree.SearchByAriticle(ariticle.Id);
List<TreeNode> treelist = tree.GetTreeNodePath(treeNode);
string treeresult = "";
for (int i = treelist.Count - 1; i >= 0; i--)
{
treeresult = treeresult + treelist[i].Title + "TreePathSplit";
}
ViewBag.TreeId = treeNode.ParentId;
ViewBag.TreePath = treeresult;
VisibilityViewModel vvm = new VisibilityViewModel();
List<VisibilityViewModel> vvlist = new List<VisibilityViewModel>();
int count = ugs.FindAll().Count;
if (count == visibilityList.Count)
{
ViewBag.visibilityList = "all";
}
else
{
for (int i = 0; i < visibilityList.Count; i++)
{
vvm = new VisibilityViewModel();
vvm.Id = visibilityList[i].Id;
vvm.UserGroupId = visibilityList[i].UserGroupId;
vvlist.Add(vvm);
}
string vlist = JsonConvert.SerializeObject(vvlist);
ViewBag.visibilityList = vlist;
}
string author = ariticle.User.NickName;
string createTime = ariticle.Createtime.ToString();
ViewBag.author = author;
ViewBag.createTime = createTime;
return View();
}
}
/// <summary>
/// 后台返回：所有小组名称和小组ID
/// </summary>
/// <returns></returns>
public JsonResult GetAllGroups()
{
RRDLEntities rr = new RRDLEntities();
UserGroupService ugs = new UserGroupService(rr);
rr.Configuration.ProxyCreationEnabled = false;
List<UserGroup> list = ugs.FindAll();
List<UserGroup> newList = new List<UserGroup>();//去除了游客和超级管理员之后的UserGroup
foreach (var l in list) {
if (l.Id != 1 && l.Id != 2) {
newList.Add(l);
}
}
return Json(newList);
}
//public string getMemberById(string userId) {
// UserService userservice = new UserService();
// User user = userservice.FindById(userId);
// MemberViewModel mvm = new MemberViewModel(user);
// UserGroupService ugs = new UserGroupService();
// List<UserGroup> list = ugs.FindAll();
// string memberResult = JsonConvert.SerializeObject(mvm);
// List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>();
// UserGroupViewModel ugv;
// for (int i = 0; i < list.Count; i++)
// {
// ugv = new UserGroupViewModel(list[i]);
// ugvlist.Add(ugv);
// }
// string result = JsonConvert.SerializeObject(ugvlist);
// return memberResult+"MemberAndGroupList"+result;
//}
public string getMemberById(string userId)
{
using (RRDLEntities db = new RRDLEntities())
{
UserService userservice = new UserService();
User user = userservice.FindById(userId);
MemberViewModel mvm = new MemberViewModel(user);
int approvedcount = 0;
int allcount = 0;
AriticleService ariticleService = new AriticleService();
Expression<Func<Ariticle, bool>> condition =
a => a.Approve.ApproveStatus == EnumAriticleApproveStatus.Approved
&& a.UserId == user.Id;
approvedcount = ariticleService.GetAriticleCount(condition);
condition =
a => a.UserId == user.Id;
allcount = ariticleService.GetAriticleCount(condition);
mvm.approvedArticleCount = approvedcount;
mvm.allArticleCount = allcount;
UserGroupService ugs = new UserGroupService();
List<UserGroup> list = ugs.FindAll();
string memberResult = JsonConvert.SerializeObject(mvm);
List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>();
UserGroupViewModel ugv;
for (int i = 0; i < list.Count; i++)
{
ugv = new UserGroupViewModel(list[i]);
ugvlist.Add(ugv);
}
string result = JsonConvert.SerializeObject(ugvlist);
return memberResult + "MemberAndGroupList" + result;
}
}
public ActionResult SearchPorformUser(string key)
{
int groupId = 0;
string newkey = System.Web.HttpUtility.UrlDecode(key).ToLower().Trim();
R2.RRDL.BusinessModel.UserService us = new UserService();
UserGroupService ugs = new UserGroupService();
List<User> lists = new List<User>();
List<UserGroup> listsgroup = new List<UserGroup>();
listsgroup = ugs.FindAll();
lists = us.FindAll();
List<UserViewModel> listuvm = new List<UserViewModel>();
for (int i = 0; i < listsgroup.Count; i++)
{
UserGroup ug = new UserGroup();
ug = listsgroup[i];
if (ug.Title.ToLower().Contains(newkey))
{
groupId = ug.Id;
for (int j = 0; j < lists.Count; j++)
{
UserViewModel uvm = new UserViewModel();
uvm.Id = lists[j].Id;
uvm.ApproveStatus = lists[j].ApproveStatus;
uvm.RealName = lists[j].RealName;
uvm.RegisterName = lists[j].RegisterName;
uvm.ReplyContent = lists[j].ReplyContent;
uvm.NickName = lists[j].NickName;
uvm.Gender = lists[j].Gender;
uvm.AuthorityCategory = lists[j].AuthorityCategory;
uvm.PersonalDescription = lists[j].PersonalDescription;
if ((R2.RRDL.Models.EnumAriticleApproveStatus)uvm.ApproveStatus == R2.RRDL.Models.EnumAriticleApproveStatus.Approved && lists[j].ContentGroupId == groupId)
{
if (!isExtence(listuvm, uvm))
{
listuvm.Add(uvm);
}
}
}
}
}
if (listuvm.Count <= 0)
{
for (int j = 0; j < lists.Count; j++)
{
UserViewModel uvm1 = new UserViewModel();
uvm1.Id = lists[j].Id;
uvm1.ApproveStatus = lists[j].ApproveStatus;
uvm1.RealName = lists[j].RealName;
uvm1.RegisterName = lists[j].RegisterName;
uvm1.ReplyContent = lists[j].ReplyContent;
uvm1.NickName = lists[j].NickName;
uvm1.Gender = lists[j].Gender;
uvm1.AuthorityCategory = lists[j].AuthorityCategory;
uvm1.PersonalDescription = lists[j].PersonalDescription;
if ((R2.RRDL.Models.EnumAriticleApproveStatus)uvm1.ApproveStatus == R2.RRDL.Models.EnumAriticleApproveStatus.Approved && uvm1.RealName.Contains(newkey))
{
if (!isExtence(listuvm, uvm1))
{
listuvm.Add(uvm1);
}
}
}
}
if (newkey.ToLower().Contains("管理员") || newkey.ToLower().Contains("管理") || newkey.ToLower().Contains("管") || newkey.ToLower().Contains("理"))
{
for (int k = 0; k < lists.Count; k++)
{
UserViewModel uvm2 = new UserViewModel();
uvm2.Id = lists[k].Id;
uvm2.ApproveStatus = lists[k].ApproveStatus;
uvm2.RealName = lists[k].RealName;
uvm2.RegisterName = lists[k].RegisterName;
uvm2.ReplyContent = lists[k].ReplyContent;
uvm2.NickName = lists[k].NickName;
uvm2.Gender = lists[k].Gender;
uvm2.AuthorityCategory = lists[k].AuthorityCategory;
uvm2.PersonalDescription = lists[k].PersonalDescription;
if ((R2.RRDL.Models.EnumAriticleApproveStatus)uvm2.ApproveStatus == R2.RRDL.Models.EnumAriticleApproveStatus.Approved && uvm2.AuthorityCategory == R2.RRDL.Models.EnumUserCategory.Administrator)
{
if (!isExtence(listuvm, uvm2))
{
listuvm.Add(uvm2);
}
}
}
}
string result = JsonConvert.SerializeObject(listuvm);
result = result + "ContentAndCount" + listuvm.Count.ToString();
return Content(result);
}
public ActionResult GetAriticleById(string ariticleId)
{
using (RRDLEntities db = new RRDLEntities())
{
AriticleService ars = new AriticleService(db);
Ariticle ariticle = ars.FindById(ariticleId);
AriticleViewModel avm = new AriticleViewModel(ariticle);
avm.Title = ariticle.Title;
avm.UGC = ariticle.UGC;
avm.author = ariticle.User.NickName;
avm.Createtime = ariticle.Createtime.ToString();
Tree tree = new Tree();
TreeNode treeNode = tree.SearchByAriticle(ariticle.Id);
List<TreeNode> list = tree.GetTreeNodePath(treeNode);
string result = "";
for (int i = list.Count - 1; i >= 0; i--)
{
result = result + list[i].Title + "#";
}
string arrayList = "";
List<AriticleVisibility> visibilityList = ars.GetAriticleVisibility(ariticle.Id);
UserGroupService ugs = new UserGroupService();
int count = ugs.FindAll().Count;
if (0 == visibilityList.Count)
{
arrayList = JsonConvert.SerializeObject(avm) + "AriticleAndTreeNode" + result + "AriticleAndTreeNodeall";
}
else {
VisibilityViewModel vvm = new VisibilityViewModel();
List<VisibilityViewModel> vvlist = new List<VisibilityViewModel>();
for (int i = 0; i < visibilityList.Count; i++)
{
vvm = new VisibilityViewModel();
vvm.Id = visibilityList[i].Id;
vvm.UserGroupId = visibilityList[i].UserGroupId;
vvm.userGroupTitle = visibilityList[i].UserGroup.Title;
vvlist.Add(vvm);
}
string vlist = JsonConvert.SerializeObject(vvlist);
arrayList = JsonConvert.SerializeObject(avm) + "AriticleAndTreeNode" + result + "AriticleAndTreeNode" + vlist;
}
return Content(arrayList);
}
}
