Controllers/AdminController.cs

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

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Drawing.Imaging;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using XXX公司积分评比系统.Models;
using System.Data;
namespace XXX公司积分评比系统.Controllers
{
    public class AdminController : Controller
    {
        /// <summary>
        /// 账号管理
        /// </summary>
        /// <returns></returns>

        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 bbh, string bname, string adminRole)
        {
            string sql = "insert into '帐号'(id,帐号名,密码,角色) values(null,'" + bbh + "','" + bname + "','" + adminRole + "')";
            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;
            int n = 0;
            n = SQLiteHelper.ExecuteNonQuery(sql);