public JsonResult LoadDeptListNoRole()
{
var userID = Commen.GetUserFromSession().UserID;
var userDept = db.UserDept.Where(w => w.UserID == userID).Select(s => s.DeptID).ToArray();
var deptList = db.DeptInfo.Where(w => w.DeptState == 0).OrderBy(o => o.DeptOrder)
.Select(s => new { id = s.DeptID, name = s.DeptName, pId = s.DeptFatherID, open = s.Open });
return(Json(deptList, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Show(int OutlineId, String comment)
{
if (comment != null)
{
Commen comm = new Commen();
comm.CommentText = comment;
comm.ApplicationUser = await _userManager.GetUserAsync(User);
comm.OutlineId = OutlineId;
_context.Comments.Add(comm);
await _context.SaveChangesAsync();
}
return(RedirectToAction("Show", OutlineId));
}
public ActionResult LoadComment()
{
//加载评论
int id = int.Parse(Request["id"]);
List <T_NewComment> list = commentService.GetNewsComments(id);//查询 评论信息
List <CommentViewModel> newlist = new List <CommentViewModel>();
if (list != null)
{
//当有评论的时候，遍历
foreach (var commentInfo in list)
{
CommentViewModel viewModel = new CommentViewModel();
TimeSpan timeSpan = DateTime.Now - commentInfo.CreateDateTime; //表示一个时间间隔
viewModel.CreateDateTime = Commen.GetTimeSpan(timeSpan); //返回评论的时间
viewModel.Msg = commentInfo.Msg;
newlist.Add(viewModel);
}
}
return(Json(newlist, JsonRequestBehavior.AllowGet));
}
public string AddDept()
{
try
{
var infoList =
JsonConvert.DeserializeObject <Dictionary <String, Object> >(HttpUtility.UrlDecode(Request.Form.ToString()));
var deptName = infoList["deptName"].ToString();
var deptFatherID = 0;
int.TryParse(infoList["detpFatherID"].ToString(), out deptFatherID);
var userID = Commen.GetUserFromSession().UserID;
Models.DeptInfo dept = new Models.DeptInfo();
dept.DeptFatherID = deptFatherID;
dept.DeptName = deptName;
dept.DeptOrder = 0;
dept.DeptState = 0;
dept.Open = 0;
dept.DeptCreateDate = DateTime.Now;
db.DeptInfo.Add(dept);
db.SaveChanges();
//添加单位的用户，默认拥有该单位的管理权限。
Models.UserDept userDept = new Models.UserDept();
userDept.DeptID = dept.DeptID;
userDept.UserID = userID;
db.UserDept.Add(userDept);
db.SaveChanges();
return("ok");
}
catch (Exception e)
{
return(e.Message);
}
}
public JsonResult GetList()
{
var limit = 0;
int.TryParse(Request.Form["limit"], out limit);
var offset = 0;
int.TryParse(Request.Form["offset"], out offset);
var userName = Request.Form["userName"];
var userNum = Request.Form["userNum"];
var deptID = 0;
int.TryParse(Request.Form["deptID"], out deptID);
var userID = Commen.GetUserFromSession().UserID;
//用户所能控制得部门列表
var userDept = db.UserDept.Where(w => w.UserID == userID).Select(s => s.DeptID).ToArray();
var result = (from u in db.UserInfo
join d in db.DeptInfo on u.UserDeptID equals d.DeptID
join f in db.DeptInfo on d.DeptFatherID equals f.DeptID
where u.UserState == 0
orderby u.UserNum
select new
{
u.UserDuty,
u.UserName,
u.UserID,
u.UserNum,
u.UserPhone,
u.UserEmail,
d.DeptName,
fatherDeptName = f.DeptName,
u.UserDeptID,
u.UserMobile,
u.UserRemark
});
//判断所选单位是否为大庆炼化公司
if (deptID != 1)
{
var count = db.UserInfo.Where(w => w.UserDeptID == deptID).Count();
if (count == 0)
{
result = result.Where(w => db.DeptInfo.Where(t => t.DeptFatherID == deptID).Select(s => s.DeptID).Contains(w.UserDeptID));
}
else
{
result = result.Where(w => w.UserDeptID == deptID);
}
}
if (!string.IsNullOrEmpty(userName))
{
result = result.Where(w => w.UserName.Contains(userName));
}
if (!string.IsNullOrEmpty(userNum))
{
result = result.Where(w => w.UserNum.Contains(userNum));
}
return(Json(new { total = result.Count(), rows = result.Skip(offset).Take(limit).ToList() }));
}
