Controllers/I3/I0301Controller.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 System.Text;
using OPMS.Common;

namespace OPMS.Controllers
{
    /// <summary>
    /// 请假管理
    /// </summary>
    public class I0301Controller : BaseController
    {
        private DBHelp db = new DBHelp();

        public ActionResult Index(string startime, string endtime, string queryStr, int cstate = -1, int pageIndex = 1)
        {
            //每月的第一天和最后一天
            DateTime datetime = StringHelper.NowTime;
            if (string.IsNullOrWhiteSpace(startime))
            {
                startime = datetime.AddDays(1 - datetime.Day).ToString("yyyy-MM-dd");
            }
            if (string.IsNullOrWhiteSpace(endtime))
            {
                endtime = datetime.AddDays(1 - datetime.Day).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd");
            }

            int pageSize = 20;
            int totalCount = 0;

            IQueryable<I0301> list = db.I0301.Where(t => t.LeaveType != "加班" && t.Applicant == CurrentUserInfo.Number);
            if (cstate != -1)
            {
                list = list.Where(t => t.States == cstate);
            }
            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");
                t1 = Convert.ToDateTime(t1.ToString("yyyy-MM-dd 23:59"));
                list = list.Where(p => (p.ApplyTime >= t2 && p.ApplyTime < t1));
            }
            else
            {
                ViewBag.t1 = t1.ToString("yyyy-MM-dd");
                ViewBag.t2 = t2.ToString("yyyy-MM-dd");
                t2 = Convert.ToDateTime(t2.ToString("yyyy-MM-dd 23:59"));
                list = list.Where(p => (p.ApplyTime >= t1 && p.ApplyTime < t2));
            }
            if (!string.IsNullOrEmpty(queryStr))
            {
                list = list.Where(t => t.LeaveType.Contains(queryStr) || t.Reason.Contains(queryStr));