LIOT/EMIS.Web/Controllers/UniversityInformationManage/AdministrativeOrgan/CampusController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using EMIS.Web.Controls;
using Bowin.Common.JSON;
using EMIS.Entities;
using Bowin.Common.Linq.Entity;
using EMIS.CommonLogic.AdministrativeOrgan;
using EMIS.ViewModel;
using EMIS.CommonLogic.SystemServices;
using Bowin.Web.Controls.Mvc;
using Bowin.Common.Utility;
using System.Data;
using Bowin.Common.Data;
using Bowin.Common.Exceptions;
using EMIS.Utility;

namespace EMIS.Web.Controllers.AdministrativeOrgan
{
    [Authorization]
    public class CampusController : Controller
    {
        public ICampusServices CampusServices { get; set; }

        /// <summary>
        /// 校区信息页面
        /// </summary>
        /// <returns></returns>
        public ActionResult List()
        {
            return View();
        }

        /// <summary>
        /// 校区信息列表查询
        /// </summary>
        /// <param name="pararms"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult List(QueryParamsModel pararms)
        {
            ConfiguretView configuretView = ConfiguretExtensions.GetConfiguretermsView(pararms);
            return base.Json(CampusServices.GetCampusViewGrid(configuretView, (int)pararms.page, (int)pararms.rows));
        }

        /// <summary>
        /// 校区信息下拉查询
        /// </summary>
        /// <param name="bindType"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult CampusDropdownListBanid(DropdownListBindType? bindType)
        {
            List<DropdownListItem> list = CampusServices.GetCampusList()
                    .Select(x => new DropdownListItem
                    {
                        Text = x.Name,
                        Value = x.CampusID.ToString()
                    }).ToList();

            DropdownList.FormatDropdownItemList(bindType.Value, list);

            return base.Json(list);
        }

        /// <summary>
        /// 复制新增
        /// </summary>
        /// <param name="campusID"></param>
        /// <returns></returns>
        public ActionResult CopyAdd(Guid campusID)
        {
            CampusView campusView = new CampusView();
            campusView = CampusServices.GetCampusView(campusID);

            return View("Edit", campusView);
        }

        /// <summary>
        /// 复制新增
        /// </summary>
        /// <param name="campusView"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult CopyAdd(CampusView campusView)
        {
            campusView.CampusID = Guid.Empty;

            return this.Edit(campusView);
        }

        /// <summary>
        /// 编辑（新增、修改，业务主键：校区代码或校区名称）
        /// </summary>
        /// <param name="campusID"></param>
        /// <returns></returns>
        [HttpGet]
        public ActionResult Edit(Guid? campusID)
        {
            ViewBag.Type = Request.Params["Type"];//临时性加参数控制、屏蔽列表进入无保存按钮权限
            CampusView campusView = new CampusView();
            if (campusID.HasValue && campusID != Guid.Empty)
            {
                campusView = CampusServices.GetCampusView(campusID);
            }

            return View(campusView);
        }

        /// <summary>
        /// 编辑（新增、修改，业务主键：校区代码或校区名称）
        /// </summary>
        /// <param name="campusView"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult Edit(CampusView campusView)
        {
            try
            {
                CampusServices.CampusEdit(campusView);

                return Json(new ReturnMessage()
                {
                    IsSuccess = true,
                    Message = "保存成功。"
                });
            }
            catch (Exception ex)
            {
                return Json(new ReturnMessage()
                {
                    IsSuccess = false,
                    Message = "保存失败，原因：" + ex.Message
                });
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="campusIDs"></param>
        /// <returns></returns>
        [HttpPost]
        public JsonResult Delete(string campusIDs)
        {
            try
            {
                List<Guid?> list = campusIDs.Split(',').Where(x => !string.IsNullOrEmpty(x))
                          .Select(x => (Guid?)new Guid(x)).ToList();

                CampusServices.CampusDelete(list);

                return base.Json("删除成功。");
            }
            catch (Exception ex)
            {
                string mge = ex.Message;
                System.Data.SqlClient.SqlException num = ExceptionHelper.GetSqlException(ex);
                if (num != null)
                {
                    if (num.Number == 547)
                    {
                        mge = "请先删除与其有关联的数据，如：" + RSL.Get("College") + "等";
                    }
                }

                return base.Json("删除失败，原因：" + mge);
            }
        }

        /// <summary>
        /// Excel导出
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public ActionResult Excel()
        {
            NpoiExcelHelper neh = new NpoiExcelHelper();
            ConfiguretView configuretView = ConfiguretExtensions.GetConfiguretermsView(null);
            var dt = CampusServices.GetCampusViewList(configuretView)
                    .Select(x => new
                    {
                        x.No,
                        x.Name,
                        x.SimpleName,
                        x.EnglishName,
                        x.UniversityCode,
                        x.UniversityName,
                        x.GeneralsuperName,
                        x.RecruitstudentsName,
                        x.PlacesuperName,
                        x.TeachingsuperName,
                        x.StudentchargeName,
                        x.ZIPCode,
                        x.Officephone,
                        x.FAX,
                        x.Email,
                        x.Evolution,
                        x.Remark
                    }).ToTable();

            string[] liststring = { 
                                      RSL.Get("CampusCode"), RSL.Get("CampusName"), RSL.Get("CampusSimpleName"), 
                                      "英文名称", "学校代码", "学校名称", "总负责人", "招生负责人", "学籍负责人", 
                                      "教学负责人", "学生负责人", "邮政编码", "办公电话", 
                                      "传真", "电子邮箱", "历史沿革", "备注" 
                                  };

            neh.Export(dt, liststring, RSL.Get("CampusName") + "信息" + DateTime.Now.ToString("yyyyMMdd"));

            return Json(new ReturnMessage()
            {
                IsSuccess = true,
                Message = "导出成功。"
            });
        }
    }
}