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

        //
        // GET: /I0205/

        public ActionResult Index(string ProjectID = null, string TaskID = "0", int States = 0, string BugType = "", string queryStr = null)
        {
            List<I0201> i0201s = db.I0201.ToList();
            if (ProjectID == null)
            {
                if (i0201s.Count > 0)
                    ProjectID = i0201s[0].ProjectID;
            }
            ViewBag.ProjectID = new SelectList(i0201s, "ProjectID", "ProjectName");
            ViewBag.taskName = TaskID;//选中任务
            GetBugStatus();
            GetBugType(1);
            //var list = db.I0205.Include(i => i.i0205c); 
            //if (!string.IsNullOrEmpty(queryStr))
            //{
            //    //关键字查询
            //    list = list.Where(p => p.Location.Contains(queryStr) || p.Title.Contains(queryStr) || p.FullName.Contains(queryStr));
            //}
            if (string.IsNullOrWhiteSpace(ProjectID))
            {
                List<I0205> list = new List<I0205>();
                return View(list);
            }
            string Sql = @"SELECT i.BugId
                                  ,i.ProjectId
                                  ,i.FId
                                  ,i.Location
                                  ,i.Title
                                  ,i.BugType
                                  ,i.Founder
                                  ,i.FullName
                                  ,i.Assigned
                                  ,i.Addtime
                                  ,i.Endtime
                                  ,i.States
                                  ,i.Priority
                                  ,i.Description
                              FROM I0205 i  join I0204 i4 on i.FId=i4.FId
                              join I0203 i3 on i4.MId=i3.MId
                              join I0202 i2 on i2.TId=i3.TId and i2.ProjectID=i.ProjectId where i.ProjectID='" + ProjectID + "' ";
            if (!string.IsNullOrWhiteSpace(TaskID) && TaskID != "0")
            { Sql += "  and i2.TaskName='" + TaskID + "' "; }