BaseController.cs

using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using PT.BLL;
using PT.Common;
using PT.Model;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.Sockets;
using System.Threading.Tasks;


namespace PT.Web.Mvc.Controllers
{
    public class BaseController<T, V> : Controller where T : class, new() where V : class, new()
    {

        public BaseBll<T, V> baseBll = new BaseBll<T, V>();

        SystemLogBll systemLogBll = new SystemLogBll();

        private SessionHelper sessionHelper;

        private readonly static IConfiguration Configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: true)
.Build();

        private static string conn = Configuration.GetConnectionString("BaseDb");



        public virtual IActionResult QueryableConfiguration()
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                ////读取配置文件测试
                //string a = Configuration["TestObj"];
                //IPList b = new IPList();
                //Configuration.Bind("TestJson", b);
                //List<string> c = new List<string>();
                //Configuration.Bind("TestArr", c);
                //List<IPList> d = new List<IPList>();
                //Configuration.Bind("TestList", d);
                result.data = conn.IndexOf("xx.xx.xx.xx") < 0 ? "此为测试环境" : "";

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }



        #region 查询

        /// <summary>
        /// 查询表所有数据
        /// </summary>
        /// <returns></returns>
        public virtual IActionResult Queryable()
        {
            LayuiDataResult<T> dataResult = new LayuiDataResult<T>()
            {
                code = 0,
                msg = "成功",
                count = 0,
                data = new List<T>()

            };
            try
            {
                List<T> list = baseBll.Queryable();
                dataResult.count = list.Count;
                dataResult.data = list;

            }
            catch (Exception ex)
            {

                dataResult.code = -1;
                dataResult.msg = ex.Message;
            }

            var res = new JsonResult(dataResult);
            return res;

        }


        /// <summary>
        /// 查询表未删除数据
        /// </summary>
        /// <returns></returns>
        public virtual IActionResult QueryableNotDeleted()
        {
            LayuiDataResult<T> dataResult = new LayuiDataResult<T>()
            {
                code = 0,
                msg = "成功",
                count = 0,
                data = new List<T>()

            };
            try
            {
                List<T> list = baseBll.QueryableNotDeleted();
                dataResult.count = list.Count;
                dataResult.data = list;

            }
            catch (Exception ex)
            {

                dataResult.code = -1;
                dataResult.msg = ex.Message;
            }

            var res = new JsonResult(dataResult);
            return res;

        }


        /// <summary>
        /// 查询表未删除数据  按条件查询
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public virtual IActionResult QueryableNotDeletedWhere(T t)
        {
            LayuiDataResult<T> dataResult = new LayuiDataResult<T>()
            {
                code = 0,
                msg = "成功",
                count = 0,
                data = new List<T>()

            };
            try
            {
                List<T> list = baseBll.QueryableNotDeleted(t);
                dataResult.count = list.Count;
                dataResult.data = list;

            }
            catch (Exception ex)
            {

                dataResult.code = -1;
                dataResult.msg = ex.Message;
            }

            var res = new JsonResult(dataResult);
            return res;

        }


        /// <summary>
        /// 单主键查询
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        public virtual IActionResult QueryableInSingle(string Id)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                T t = baseBll.QueryableInSingle(Id);
                result.data = t;

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }


        /// <summary>
        /// 查询单条  没有返回Null，如果结果大于1条会抛出错误 （根据业务重写）
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public virtual IActionResult QueryableSingle(UserList t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                UserList data = baseBll.QueryableSingle(t);
                result.data = data;

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }


        /// <summary>
        /// 是否存在记录
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public virtual IActionResult IsExist(T t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                bool b = baseBll.IsExist(t);
                result.data = b;

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }

        #endregion


        #region 插入


        /// <summary>
        /// 插入 忽略null列
        /// </summary>
        /// <param name="t"></param>
        /// <returns>返回自增id</returns>
        public virtual IActionResult InsertableIgnoreColumns(T t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                result.data = baseBll.InsertableIgnoreColumns(t);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }

        #endregion


        #region 更新

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public virtual IActionResult Updateable(T t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {

                result.data = baseBll.Updateable(t);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }


        /// <summary>
        /// 更新 批量
        /// </summary>
        /// <param name="ts"></param>
        /// <returns></returns>
        [HttpPost]
        public virtual IActionResult UpdateableBatch(List<T> ts)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {

                result.data = baseBll.Updateable(ts);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }


        /// <summary>
        /// 更新 忽略null列
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public virtual IActionResult UpdateableIgnoreColumns(T t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {

                result.data = baseBll.UpdateableIgnoreColumns(t);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }


        /// <summary>
        /// 更新 忽略null列 批量
        /// </summary>
        /// <param name="ts"></param>
        /// <returns></returns>
        [HttpPost]
        public virtual IActionResult UpdateableIgnoreColumnsBatch(List<T> ts)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {

                result.data = baseBll.UpdateableIgnoreColumns(ts);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }


        /// <summary>
        /// 更新 根据自定义条件 忽略null列  （根据业务重写）
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public virtual IActionResult UpdateableIgnoreColumnsWhere(T t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {

                result.data = baseBll.UpdateableIgnoreColumnsWhere(t);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }

        #endregion


        #region 删除


        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public virtual IActionResult Deleteable(T t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                result.data = baseBll.Deleteable(t);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }

        /// <summary>
        /// 逻辑删除
        /// </summary>
        /// <param name="Ids"></param>
        /// <returns></returns>
        [HttpPost]
        public virtual IActionResult DeleteableLogic(List<int> Ids)
        {
            string ModifyBy = "";

            sessionHelper = new SessionHelper(HttpContext.Session);
            UserList user = sessionHelper.GetUserInfoString();

            ModifyBy = user.Id + "|" + user.UserID + "|" + user.UserName;

            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                result.data = baseBll.DeleteableLogic(ModifyBy, Ids);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }

        #endregion


        #region 业务查询,根据业务需要重写方法


        /// <summary>
        /// 视图 多表联查 查询表未删除数据 （根据业务重写）
        /// </summary>
        /// <returns></returns>
        public virtual IActionResult QueryableNotDeletedV()
        {
            LayuiDataResult<UserListV> dataResult = new LayuiDataResult<UserListV>()
            {
                code = 0,
                msg = "成功",
                count = 0,
                data = new List<UserListV>()

            };
            try
            {
                List<UserListV> list = baseBll.QueryableNotDeletedV();
                dataResult.count = list.Count;
                dataResult.data = list;

            }
            catch (Exception ex)
            {

                dataResult.code = -1;
                dataResult.msg = ex.Message;
            }

            var res = new JsonResult(dataResult);
            return res;

        }


        /// <summary>
        /// 视图 多表联查 查询表未删除数据 按条件查询 （根据业务重写）
        /// </summary>
        /// <returns></returns>
        public virtual IActionResult QueryableNotDeletedVWhere2(IPListV v)
        {
            LayuiDataResult<IPListV> dataResult = new LayuiDataResult<IPListV>()
            {
                code = 0,
                msg = "成功",
                count = 0,
                data = new List<IPListV>()

            };
            try
            {
                List<IPListV> list = baseBll.QueryableNotDeletedV(v);
                dataResult.count = list.Count;
                dataResult.data = list;

            }
            catch (Exception ex)
            {

                dataResult.code = -1;
                dataResult.msg = ex.Message;
            }

            var res = new JsonResult(dataResult);
            return res;

        }


        /// <summary>
        /// 视图 多表联查 分页查询 查询表未删除数据 按条件查询 （根据业务重写）
        /// </summary>
        /// <param name="where"></param>
        /// <param name="page"></param>
        /// <param name="limit"></param>
        /// <returns></returns>
        public virtual IActionResult QueryablePageList2(IPListV where, int page, int limit)
        {
            LayuiDataResult<IPListV> dataResult = new LayuiDataResult<IPListV>()
            {
                code = 0,
                msg = "成功",
                count = 0,
                data = new List<IPListV>()

            };
            try
            {
                int totalCount = 0;
                List<IPListV> list = baseBll.QueryablePageList(where, page, limit, out totalCount);
                dataResult.count = totalCount;
                dataResult.data = list;

            }
            catch (Exception ex)
            {

                dataResult.code = -1;
                dataResult.msg = ex.Message;
            }

            var res = new JsonResult(dataResult);
            return res;

        }

        #endregion


        #region 日志

        /// <summary>
        /// 记录系统操作日志
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public virtual IActionResult AddSystemLog(SystemLog t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                sessionHelper = new SessionHelper(HttpContext.Session);
                UserList userList = sessionHelper.GetUserInfoString();

                //获取本机域账号的几种方式
                System.Security.Principal.WindowsIdentity currentUser = System.Security.Principal.WindowsIdentity.GetCurrent();
                string strUserName = currentUser.Name.ToString();

                string a = HttpContext.GetServerVariable("LOGON_USER");

                string b = HttpContext.GetServerVariable("Remote_Host");

                string c = User.Identity.Name;

                if (string.IsNullOrWhiteSpace(strUserName) || strUserName.IndexOf("APO") == -1)
                {

                    strUserName = a;
                }
                if (string.IsNullOrWhiteSpace(strUserName) || strUserName.IndexOf("APO") == -1)
                {

                    strUserName = b;
                }

                if (string.IsNullOrWhiteSpace(strUserName) || strUserName.IndexOf("APO") == -1)
                {

                    strUserName = c;
                }


                //获取IP
                //string localIP = string.Empty;
                //using (Socket socket = new Socket(AddressFamily.InterNetwork, SocketType.Dgram, 0))
                //{
                //    socket.Connect("8.8.8.8", 65530);
                //    IPEndPoint endPoint = socket.LocalEndPoint as IPEndPoint;
                //    localIP = endPoint.Address.ToString();
                //}


                t.OperatorIP = GetClientIPAddr();
                t.APO = strUserName.Substring(strUserName.IndexOf('\\') + 1);
                t.Operator = userList.Id + "|" + userList.UserID + "|" + userList.UserName;
                t.OperateDate = DateTime.Now;



                result.data = systemLogBll.InsertableIgnoreColumns(t);

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }


        public string GetClientIPAddr()
        {
            var remote = this.HttpContext.Connection.RemoteIpAddress;
            var local = this.HttpContext.Connection.LocalIpAddress;
            string ipAddr = HttpContext.GetServerVariable("HTTP_X_FORWARDED_FOR");
            if (string.IsNullOrEmpty(ipAddr))
                ipAddr = HttpContext.GetServerVariable("REMOTE_ADDR");

            if (string.IsNullOrEmpty(ipAddr))

                ipAddr = local.ToString();

            return ipAddr;
        }

        #endregion

    }
}