Controllers/I5/I0501Controller.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;

namespace OPMS.Controllers
{
    public class I0501Controller : BaseController
    {
        private DBHelp db = new DBHelp();
        #region Index 
        
        public ActionResult Index(int id = -1, int pageIndex = 1,string queryStr = null)
        {
            GetParentID(id);
            int pageSize = 20;
            int totalCount = 0;
            List<I0501> Data = new List<I0501>();
            IQueryable<I0501> list = db.I0501;
            if (id != -1)
            {
                //关键字查询
                list = list.Where(t => t.ParentId == id || t.Id == id);
            }

            if (!string.IsNullOrEmpty(queryStr))
            {
                //关键字查询
                list = list.Where(p => p.Name.Contains(queryStr) || p.SiteCode.Contains(queryStr));
            }
            totalCount = list.Count();

            //分页排序
            Data = list.OrderBy(t => t.SiteCode).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            var pageList = new PagedList<I0501>(Data, pageIndex, pageSize, totalCount);
            ViewBag.queryStr = queryStr;
            return View(pageList);
        }

        //获取父级别下拉框
        protected void GetParentID(int sel)
        {
            List<SelectListItem> vParentIDlist = db.I0501.Where(t => t.ParentId == 0).OrderBy(t=>t.SiteCode).ToList().Select(c => new SelectListItem() { Text = c.Name, Value = c.Id.ToString() }).ToList();//将实体集合 转成 SelectListItem集合 
            //将 下拉框选项 集合 设置给 ViewBag ，用以传递 到 视图 
            vParentIDlist.Insert(0, (new SelectListItem { Text = "--全部--", Value = "-1" }));
            vParentIDlist.Insert(1, (new SelectListItem { Text = "一级目录", Value = "0" }));
            ViewBag.ParentID = new SelectList(vParentIDlist, "Value", "Text", sel);
        }

        #endregion

        #region 新增
        public ActionResult Create(int id)
        {
            ParentIDdrp(id);
            I0501 i0501 = new I0501();