MvcBug/Controllers/EmployController.cs

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

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

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

namespace MvcBug.Controllers
{
    public class EmployController : Controller
    {
        //
        // GET: /Employ/

        public ActionResult Index()
        {
            ViewData["department"] = new DAL.QueryDAL().GetDataTable("department", "Id", "Id,Code,Name", "", "", "");
            return View();
        }
        public string GetDataGridJson()
        {
            string pagesize = "10";
            string curpage = "1";

            int totalcount;

            pagesize = string.IsNullOrEmpty(Request.Params["rows"]) ? pagesize : Request.Params["rows"];
            curpage = string.IsNullOrEmpty(Request.Params["page"]) ? curpage : Request.Params["page"];

            DataTable dt = new DAL.QueryDAL().GetDataTable("v_employ", "Id", "Id,Code,Name,Departmentid,Showallbug,DepartmentName", "", "", "", curpage, pagesize, out totalcount);

            string jsonstr = JsonHelper.DataGridJson(dt, totalcount);
            return jsonstr;
        }
        public string AddUpdate(FormCollection forms)
        {
            int Id = forms["Id"] == "" ? 0 : Convert.ToInt32(forms["Id"]);
            string Code = forms["Code"];
            string Name = forms["Name"];
            int Departmentid = forms["Departmentid"] == "" ? 0 : Convert.ToInt32(forms["Departmentid"]);
            int Showallbug = forms["Showallbug"] == "" ? 0 : Convert.ToInt32(forms["Showallbug"]);
            string jsonstr = string.Empty;
            try
            {
                int result = new DAL.EmployDAL().AddUpdate(Id, Code, Name,Departmentid,Showallbug);
                if (result > 0)
                {
                    jsonstr = "{\"success\":true}";
                }
            }
            catch (SqlException ex)
            {
                jsonstr = "{\"errorMsg\":\"" + ex.Errors[0].ToString() + "\"}";
            }
            return jsonstr;
        }
        public string Del()
        {