Controllers/Admin/CompanyController.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace KeWeb.Controllers.Admin
{
    public class CompanyController : Controller
    {
        //
        // GET: /Company/

        public ActionResult Index()
        {
            //验证是否登录

            if (Session["loginUserName"] == null) { return RedirectToAction("index", "Login"); }
            ViewData["name"] = Session["loginUserName"];
            //分页id 
            ViewData["pageId"] = Convert.ToInt32(Request["id"]);
            //分页
            int pageNum = 1;
            if (Request["pageNum"] != null)
            {
                pageNum = Convert.ToInt32(Request["pageNum"]);
            }
            int start = (pageNum - 1) * 5 + 1;
            int end = pageNum * 5;
            //获取分类信息
            DataTable dt = SqlHelper.ExecuteDataTable(@"
select *from(
select ROW_NUMBER()over(order by id)as num,* from company
) as s
where  s.num between @Start and @End", new SqlParameter("@Start", start), new SqlParameter("@End", end));
            //第一页:between 1and 10，第二页:11 between  11 and 21第pageNum页就是，(pageNum-1)*10+1 and pageNum*10
            int totalCount = (int)SqlHelper.ExecuteScalar("select count(*)from company");
            //总页数
            int pageCount = (int)Math.Ceiling(totalCount / 5.0);
            ViewData["totalCount"] = totalCount;
            ViewData["pageNum"] = pageNum;
            ViewBag.pageCount = pageCount;
            ViewData["company"] = dt;
            return View();
        }
        public ActionResult Add()
        {
            //验证是否登录

            if (Session["loginUserName"] == null) { return RedirectToAction("index", "Login"); }
            ViewData["name"] = Session["loginUserName"];

            return View();
        }
        [HttpPost]
        [ValidateInput(false)]
        public ActionResult Save()
        {