Controllers/I2/I0208Controller.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 OPMS.Common;

namespace OPMS.Controllers
{
    public class I0208Controller : BaseController
    {
        private DBHelp db = new DBHelp();

        //
        // GET: /I0208/
        public ActionResult Index(int State = 1, int timeType = -1, string startime = "", string endtime = "", int pageIndex = 1)
        {
            List<SelectListItem> workStateList = new List<SelectListItem>();
            workStateList.Add((new SelectListItem { Text = "草稿", Value = "0" }));
            workStateList.Add((new SelectListItem { Text = "审核中", Value = "1", Selected = true }));
            workStateList.Add((new SelectListItem { Text = "已审核", Value = "2" }));
            workStateList.Add((new SelectListItem { Text = "退回", Value = "3" }));
            ViewBag.StateList = workStateList;

            List<SelectListItem> workTypeList = new List<SelectListItem>();
            workTypeList.Add((new SelectListItem { Text = "-请选择-", Value = "-1" }));
            workTypeList.Add((new SelectListItem { Text = "正常", Value = "1" }));
            workTypeList.Add((new SelectListItem { Text = "加班", Value = "2" }));
            ViewBag.timeTypeList = workTypeList;


            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;
            List<I0208> Data = new List<I0208>();

            IQueryable<I0208> list = db.I0208.Include(i => i.i0201).Include(i => i.i0208c).Where(t => t.Number == CurrentUserInfo.Number).Where(t => t.States == State);
            if (timeType > 0)
            {
                list = list.Where(t => t.HoursType == timeType);
            }
            DateTime t1 = Convert.ToDateTime(Convert.ToDateTime(startime).ToString("yyyy-MM-dd 00:00:00"));
            DateTime t2 = Convert.ToDateTime(Convert.ToDateTime(endtime).ToString("yyyy-MM-dd 23:59:59"));
            if (t1 > t2)
            {
                ViewBag.t1 = t2.ToString("yyyy-MM-dd");
                ViewBag.t2 = t1.ToString("yyyy-MM-dd");
                list = list.Where(p => p.Stime >= t2 && p.Stime <= t1);
            }