FJDPXT202002/Areas/OthersMaintenance/Controllers/IssuanceTicketController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using FJDPXT202002.EntityClass;
using FJDPXT202002.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace FJDPXT202002.Areas.OthersMaintenance.Controllers
{
    public class IssuanceTicketController : Controller
    {
        // GET: OthersMaintenance/IssuanceTicket
        //其他：票证下发
        Models.FJDPXTEntities myModel = new FJDPXTEntities();
        public ActionResult Index()
        {
            //检查是否登录
            try
            {
                int userID = Convert.ToInt32(Session["userId"].ToString());
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                //如果出现异常就说明没有登录，重定向到登录页面
                return Redirect(Url.Content("~/Main/Login"));
            }
            return View();
        }

        public ActionResult SelectUser()
        {
            //获取当前用户的id
            int userID = Convert.ToInt32(Session["UserID"].ToString());
            //查询出当前用户
            S_User dbUser = myModel.S_User.SingleOrDefault(o => o.userID == userID);
            //查询出所有的下级用户组 （linq递归查询）
            List<S_UserGroup> childGroups = GetChildGroup(dbUser.userGroupID).ToList();
            //查询出所有用户组的ID
            List<int> childGroupIds = childGroups.Select(o => o.userGroupID).ToList();

            //查询出下级员工
            var list = (from tbUser in myModel.S_User
                        join tbUserGroup in myModel.S_UserGroup on tbUser.userGroupID equals tbUserGroup.userGroupID
                        where childGroupIds.Contains(tbUser.userGroupID)
                        select new
                        {
                            id = tbUser.userID,
                            text = tbUser.jobNumber + " " + tbUser.userName
                        }).ToList();
            //添加自己的信息到列表
            list.Add(new
            {
                id = dbUser.userID,
                text = dbUser.jobNumber + " " + dbUser.userName
            });
            //对数据进行排序 根据id
            list = list.OrderBy(m => m.id).ToList();
            //将用户列表保存到session中，供列表查询是使用