Controllers/I3/I0309Controller.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 OPMS.Common;

namespace OPMS.Controllers
{
    public class I0309Controller : BaseController
    {
        private DBHelp db = new DBHelp();

        public ActionResult Index(int id = 0, string queryStr = "")
        {
            GetAssetID(0);
            IQueryable<I0309> list = db.I0309.Include(i => i.i0308).Include(i => i.i0307);
            if (id != 0)
            {
                list = list.Where(p => p.i0307.AssetID == id);
            }
            if (!string.IsNullOrEmpty(queryStr))
            {
                //关键字查询
                list = list.Where(p => p.Goods.Contains(queryStr) || p.Remarks.Contains(queryStr)|| p.FullName.Contains(queryStr));
            }
            //查询近一年内数据
            return View(list.ToList());
        }

        //办公用品审批
        public ActionResult ExIndex(int id = 0, int cstate = 1,int pageIndex = 1, string queryStr = "")
        {
            GetAssetID(0);
            IQueryable<I0309> list = db.I0309.Include(i => i.i0308).Include(i => i.i0307).Where(t => t.States == cstate);
            if (id != 0)
            {
                list = list.Where(p => p.i0307.AssetID== id);
            }
            if (!string.IsNullOrEmpty(queryStr))
            {
                //关键字查询
                list = list.Where(p => p.Goods.Contains(queryStr) || p.Remarks.Contains(queryStr) || p.FullName.Contains(queryStr));
            }
            int  totalCount = list.ToList().Count();//一次计算总数即可！
            int pageSize = 20;
            //分页排序
            List<I0309> Data = list.OrderBy(t => t.ApplyTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            var pageList = new PagedList<I0309>(Data, pageIndex, pageSize, totalCount);
            ViewBag.queryStr = queryStr;
            ViewBag.state = cstate;
            return View(pageList);
        }

        private void GetAssetID(int add)
        {
            List<SelectListItem> vlist = new List<SelectListItem>();