Controllers/DepartmentController.cs

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

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

namespace XXX公司积分评比系统.Controllers
{
    public class DepartmentController : Controller
    {
        /// <summary>
        /// 部门管理
        /// </summary>
        /// <returns></returns>

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

            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 bbh, string bname)
        {
            string sql = "insert into 部门(id,部门编号,部门名) values(null,'"+bbh+"','"+bname+"')";
            int n = SQLiteHelper.ExecuteNonQuery(sql);
            //响应内容，响应json数据,构建匿名类对象，有一个属性r
            if (n > 0)
            {
                return Json(new { r = n }, JsonRequestBehavior.AllowGet);
            }
            else 
            {
                return Json(new { r = 0 }, JsonRequestBehavior.AllowGet);
            }
        }
        #endregion

        #region 部门删除
        public ActionResult Delete(int id)
        {
            string sql = "delete from 部门 where ID="+id;