Controllers/I1/I0106Controller.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using OPMS.Models;
using System.IO;

namespace OPMS.Controllers
{
    public class I0106Controller : BaseController
    {
        private DBHelp db = new DBHelp();
        public ActionResult Index(string DCode = "0", int cstate = 1, string queryStr = null, int pageIndex = 1)
        {
            List<I0102> bmlist = db.I0102.ToList();
            //获取一级部门
            List<SelectListItem> vParentIDlist = db.I0102.Where(con => con.PCode == null).OrderBy(t => t.ALevel).ToList().Select(c => new SelectListItem() { Text = c.DeptName, Value = c.DCode.ToString(), Selected = (c.DCode == DCode) }).ToList();//将实体集合 转成 SelectListItem集合 
            vParentIDlist.Add((new SelectListItem { Text = "--全部--", Value = "0", Selected = (DCode == "0") }));
            ViewBag.APCode = vParentIDlist;
            IQueryable<I0106> list = db.I0106.Include(i => i.i0102);
            if (!string.IsNullOrEmpty(queryStr))
            {
                list = list.Where(t => t.Name.Contains(queryStr) || t.Position.Contains(queryStr) || t.Emails.Contains(queryStr));
            }
            if (DCode != "0")
            {
                list = list.Where(t => t.DCode.Contains(DCode));
            }
            if (cstate == 1)
            {
                list = list.Where(t => t.Inauguration > 2 && t.Inauguration <= 10);//在职
            }
            else if (cstate == 0)
            {
                list = list.Where(t => t.Inauguration < 3 || t.Inauguration > 10);//离职
            }
            ViewBag.queryStr = queryStr;
            ViewBag.cstate = cstate;
            int pageSize = 20;
            int totalCount = 0;
            totalCount = list.Count();//一次计算总数即可！
            //分页排序
            List<I0106> Data = list.OrderBy(t => t.Number).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            var pageList = new PagedList<I0106>(Data, pageIndex, pageSize, totalCount);
            return View(pageList);
        }

        public ActionResult Details(int id = 0)
        {
            I0106 i0106 = db.I0106.Find(id);
            if (i0106 == null)
            {
                return HttpNotFound();
            }
            List<SelectListItem> vPIDlist = db.I0102.Where(con => con.PCode == null).OrderBy(t => t.ALevel).ToList().Select(c => new SelectListItem() { Text = c.DeptName, Value = c.DCode.ToString(), Selected = (c.DCode == i0106.DCode) }).ToList();//将实体集合 转成 SelectListItem集合 
            ViewBag.APCode = vPIDlist;
            return View(i0106);