Controllers/I3/I0307Controller.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.Text;
using OPMS.Common;

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

        //
        // GET: /I0307/

        public ActionResult Index(string tid="", string queryStr="")
        {
            GetAssetType(0);
            IQueryable<I0307> list = db.I0307;
            if (!string.IsNullOrEmpty(tid))
            {
                list = list.Where(p => p.AssetType == tid);
            }
            if (!string.IsNullOrEmpty(queryStr))
            {
                //关键字查询
                list = list.Where(p => p.Mc.Contains(queryStr) || p.Remarks.Contains(queryStr) || p.Units.Contains(queryStr));
            }
            ViewBag.queryStr = queryStr;
            return View(list.OrderBy(t=>t.AssetType).ToList());
        }

        private void GetAssetType(int add)
        {
            List<SelectListItem> vlist = new List<SelectListItem>();
            if (add == 0)
            {
                //查询
                vlist.Add((new SelectListItem { Text = "--全部资产--", Value = "" }));
            }
            List<I030d> Data = db.I030d.Where(t => t.Types == 104 && t.States == true).ToList();
            if (Data != null && Data.Count > 0)
            {
                foreach (I030d item in Data)
                {
                    vlist.Add((new SelectListItem { Text = item.Mc.ToString(), Value = item.Mc.ToString() }));
                }
            }
            ViewBag.vAssetType = vlist;
        }

        //
        // GET: /I0307/Details/5

        public ActionResult Details(int id = 0)