WebUI/AchieveManageWeb/Controllers/TableController.cs

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

微信扫码关注公众号，代码整理好后第一时间通知你。

using AchieveBLL;
using AchieveCommon;
using AchieveEntity;
using System;
using System.Web.Mvc;

namespace AchieveManageWeb.Controllers
{
    [AchieveManageWeb.App_Start.JudgmentLogin]
    public class TableController : Controller
    {
        public ActionResult Index()
        {
            return View();
        }

        public ActionResult GetAllTableInfo()
        {
            string strWhere = "1=1";
            string sort = Request["sort"] == null ? "id" : Request["sort"];
            string order = Request["order"] == null ? "asc" : Request["order"];
            if (!string.IsNullOrEmpty(Request["TabName"]) && !SqlInjection.GetString(Request["TabName"]))
            {
                strWhere += " and TabName like '%" + Request["TabName"] + "%'";
            }
            if (!string.IsNullOrEmpty(Request["TabViewName"]) && !SqlInjection.GetString(Request["TabViewName"]))
            {
                strWhere += " and TabViewName like '%" + Request["TabViewName"] + "%'";
            }
            //首先获取前台传递过来的参数
            int pageindex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]);
            int pagesize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]);
            int totalCount = 0;   //输出参数
            string strJson = new TableBLL().GetPager("tbTable", "Id, TabName, TabViewName, IsActive, CreateTime, CreateBy, UpdateTime, UpdateBy", sort + " " + order, pagesize, pageindex, strWhere, out totalCount);

            return Content("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}");
        }

        /// <summary>
        /// 新增页面展示
        /// </summary>
        /// <returns></returns>
        public ActionResult TableAdd()
        {
            return View();
        }

        /// <summary>
        /// 新增数据表
        /// </summary>
        /// <returns></returns>
        public ActionResult AddTable()
        {
            try
            {
                UserEntity uInfo = ViewData["Account"] as UserEntity;
                TableEntity typeAdd = new TableEntity();
                typeAdd.TabName = Request["TabName"].Trim();
                typeAdd.TabViewName = Request["TabViewName"].Trim();
                typeAdd.IsActive = bool.Parse(Request["IsActive"]);