Controllers/ExamCheckTimeController.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data;
using XXX公司积分评比系统.Models;

namespace XXX公司积分评比系统.Controllers
{
    public class ExamCheckTimeController : Controller
    {
        //
        // GET: /ExamCheckTime/


        public ActionResult Index()
        {
            string sql = "select * from '评比段记录' order by Id desc";
            DataTable tab = SQLiteHelper.GetDataTable(sql);
            return View(tab);
        }

        #region 增加 视图
        public ActionResult Add()
        {
            return View();
        }

        /// <summary>
        /// 增加帐号的处理方法，该方法给异步请求调用
        /// </summary>
        /// <param name="st"></param>
        /// <returns></returns>
        public ActionResult AddAction(string a1, string a2, string a3,string a4,string a5)
        {
            string sql = "insert into '评比段记录'(id,评比名,评比开始时间,初始分,说明) values(null,'" + a1 + "','" + a2 + "','" + a3 + "','" + a4 + "')";
            int n = SQLiteHelper.ExecuteNonQuery(sql);
            
            //查询所有员工
            string sql2 = "select * from '员工'";
            DataTable tab2 = SQLiteHelper.GetDataTable(sql2);
            //每个组员增加一条
            string ip = Request.UserHostAddress;//获取ip
            foreach (DataRow dr in tab2.Rows)
            {
                string sql3 = "insert into 考核记录表(id,员工序号,考核时间,增加时间,操作人员,使用IP,批准人员,事由,考核所属项,分值) "
              + " values(null,'" + dr["ID"].ToString()
              + "','" + a2 + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
              + "','" + Session["name"].ToString() + "','" + ip + "','" + ""
              + "','" + "初始化考核基础分" + "','" + a5 + "','" + a3 + "' )";
                int n3 = SQLiteHelper.ExecuteNonQuery(sql3);
            }
            
            //响应内容，响应json数据,构建匿名类对象，有一个属性r
            if (n > 0)
            {
                return Json(new { r = n }, JsonRequestBehavior.AllowGet);
            }
            else