Controllers/EmpCheckController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using XXX公司积分评比系统.Models;
using System.Data;
using System.Text;
using System.IO;
namespace XXX公司积分评比系统.Controllers
{
    public class EmpCheckController : Controller
    {
        /// <summary>
        /// 员工考核
        /// </summary>
        /// <returns></returns>

        public ActionResult Index(string datemin, string datemax, string namekey)
        {

            if (Session["name"] == null)
            {
                return Content("<script>alert('请登陆再访问');window.location.href='/Admin/Login';</script>");
            }

            //
            ViewData["namekey"] = namekey;
            ViewData["datemin"] = datemin;
            ViewData["datemax"] = datemax;//
            /////////////////////
            string sql2 = @"select t1.id as yid,t1.员工序号,t3.员工姓名,t2.考核项序号,t2.考核名,t1.事由,t1.分值,t1.考核时间,t1.操作人员,t1.增加时间 
                            from '考核记录表' as t1
                            inner join  '考核分值表' t2 on t1.考核所属项=t2.ID
                            inner join '员工' t3 on t3.id=t1.员工序号 where 1=1 ";
            if (!string.IsNullOrEmpty(namekey))
            {
                sql2 += " and  员工姓名 like '%" + namekey + "%' ";
            }
            if (!string.IsNullOrEmpty(datemin))
            {
                sql2 += " and 考核时间>='" + datemin + "'";
            }
            if (!string.IsNullOrEmpty(datemax))
            {
                sql2 += " and 考核时间<='" + datemax + "'";
            }

            sql2 += " order by  yid  desc";
            DataTable tab2 = SQLiteHelper.GetDataTable(sql2);
            return View(tab2);
        }


        public ActionResult IndexToExcel(string datemin, string datemax, string namekey)
        {
            string filenamemethod = "";
            if (Session["name"] == null)
            {
                return Content("<script>alert('请登陆再访问');window.location.href='/Admin/Login';</script>");