Controllers/I5/I0504Controller.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 I0504Controller : BaseController
    {
        private DBHelp db = new DBHelp();
       
        public ActionResult Index(string startime, string endtime, string queryStr, int pageIndex = 1)
        {
            if (string.IsNullOrWhiteSpace(startime))
            {
                startime = StringHelper.NowTime.AddDays(-3).ToString("yyyy-MM-dd");
            }
            if (string.IsNullOrWhiteSpace(endtime))
            {
                endtime = StringHelper.NowTime.AddDays(1).ToString("yyyy-MM-dd");
            }
            int pageSize = 20;
            int totalCount = 0;
            List<I0504> Data = new List<I0504>();

            IQueryable<I0504> list = db.I0504;
            if (!string.IsNullOrEmpty(queryStr))
            {
                //关键字查询
                list = list.Where(p => p.Operator.ToString().Contains(queryStr) || p.Message.Contains(queryStr) || p.Result.Contains(queryStr));
            }
            DateTime t1 = Convert.ToDateTime(Convert.ToDateTime(startime).ToString("yyyy-MM-dd"));
            DateTime t2 = Convert.ToDateTime(Convert.ToDateTime(endtime).ToString("yyyy-MM-dd"));
            if (t1 > t2)
            {
                ViewBag.t1 = t2.ToString("yyyy-MM-dd");
                ViewBag.t2 = t1.ToString("yyyy-MM-dd");
                list = list.Where(p => p.CreateTime >= t2 && p.CreateTime <= t1);
            }
            else if (t1 == t2)
            {
                ViewBag.t2 = ViewBag.t1 = t1.ToString("yyyy-MM-dd");
                t2 = t1.AddDays(1);
                list = list.Where(p => p.CreateTime >= t1 && p.CreateTime < t2);
            }
            else
            {
                ViewBag.t1 = t1.ToString("yyyy-MM-dd");
                ViewBag.t2 = t2.ToString("yyyy-MM-dd");
                list = list.Where(p => p.CreateTime >= t1 && p.CreateTime <= t2);
            }
            
            totalCount = list.Count();//一次计算总数即可！
            //分页排序
            Data = list.OrderByDescending(t => t.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            var pageList = new PagedList<I0504>(Data, pageIndex, pageSize, totalCount);