Controllers/I3/I0303Controller.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
{
    /// <summary>
    /// 出差阶段任务单表I0303 个人任务 
    /// </summary>
    public class I0303Controller : BaseController
    {
        private DBHelp db = new DBHelp();

        //
        // GET: /I0303/

        public ActionResult Index(string queryStr, int pageIndex = 1)
        {
            int pageSize = 20;
            int totalCount = 0;

            IQueryable<I0303> list = db.I0303.Include(i => i.i0302).Where(t=>t.Traveler==CurrentUserInfo.Number);
            if (!string.IsNullOrEmpty(queryStr))
            {
                list = list.Where(t => t.ProjectName.Contains(queryStr) || t.Place.Contains(queryStr));
            }
            totalCount = list.Count();//一次计算总数即可！
            //分页排序
            List<I0303> Data = list.OrderBy(t => t.Stime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            var pageList = new PagedList<I0303>(Data, pageIndex, pageSize, totalCount);
            ViewBag.queryStr = queryStr;
            return View(pageList);
        }

        //
        // GET: /I0303/Details/5

        public ActionResult Details(string id = null)
        {
            I0303 i0303 = db.I0303.Find(id);
            if (i0303 == null)
            {
                return HttpNotFound();
            }
            return View(i0303);
        }

        //
        // GET: /I0303/Create

        public ActionResult Create()
        {
            int Applicant = CurrentUserInfo.Number;//申请人
            string StrSql = @"select i.BtripID ID,i.Title MC from I0302 i  where i.States<4 and i.States>0 and i.Traveler like '%" + Applicant + "%' and  i.TravelerName like '%" + CurrentUserInfo.Name + "%' ";//获取最大ID
            List<DropdownBoxTo> list = db.Database.SqlQuery<DropdownBoxTo>(StrSql).ToList();