Controllers/I3/I0302Controller.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>
    /// 出差申请单表
    /// </summary>
    public class I0302Controller : BaseController
    {
        private DBHelp db = new DBHelp();

        public ActionResult Index(string startime, string queryStr, int cstate = 1, int pageIndex = 1)
        {
            //每月的第一天
            if (string.IsNullOrWhiteSpace(startime))
            {
                startime = StringHelper.NowTime.ToString("yyyy-MM-01");
            }
            DateTime t1 = Convert.ToDateTime(Convert.ToDateTime(startime).ToString("yyyy-MM-dd"));
            ViewBag.t1 = t1.ToString("yyyy-MM-dd");
            int pageSize = 20;
            int totalCount = 0;

            IQueryable<I0302> list = db.I0302.Where(t => t.Applicant == CurrentUserInfo.Number);//员工只能查看自己的申请记录

            if (cstate==1)
            {
                list = list.Where(t => t.States == 1 || t.States == 2);
            }else{
            list = list.Where(t => t.States == cstate);
            }
            list = list.Where(p => p.ApplyTime >= t1);
            if (!string.IsNullOrEmpty(queryStr))
            {
                list = list.Where(t => t.FullName.Contains(queryStr) || t.GoAndBack.Contains(queryStr) || t.Title.Contains(queryStr) || t.DeptName.Contains(queryStr));
            }
            totalCount = list.Count();//一次计算总数即可！
            //分页排序
            List<I0302> Data = list.OrderBy(t => t.BtripID).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();

            var pageList = new PagedList<I0302>(Data, pageIndex, pageSize, totalCount);
            ViewBag.queryStr = queryStr;
            ViewBag.state = cstate;
            return View(pageList);
        }

        public ActionResult ExIndex(string startime, string queryStr, int cstate = 1, int pageIndex = 1)
        {
            //每月的第一天
            if (string.IsNullOrWhiteSpace(startime))
            {
                startime = StringHelper.NowTime.ToString("yyyy-MM-01");
            }