Controllers/I3/I0308Controller.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 I0308Controller : BaseController
    {
        private DBHelp db = new DBHelp();

        public ActionResult Index(int tid = 0, string queryStr = "")
        {
            GetAssetID(0);
            IQueryable<I0308> list = db.I0308.Include(i => i.i0307);
            if (tid!=0)
            {
                list = list.Where(p => p.AssetID == tid);
            }
            if (!string.IsNullOrEmpty(queryStr))
            {
                //关键字查询
                list = list.Where(p => p.Mc.Contains(queryStr) || p.Remarks.Contains(queryStr) || p.Operator.Contains(queryStr));
            }
            ViewBag.queryStr = queryStr;
            return View(list.OrderBy(t => t.i0307.AssetType).ThenBy(t => t.i0307.Mc).ToList());
        }

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

        //
        // GET: /I0308/Details/5

        public ActionResult Details(string id = "")
        {
            I0308 i0308 = db.I0308.Find(id);
            if (i0308 == null)
            {