SQ12345_Api/CallCenterApi/CallCenterAp.../CallCenterAp.../Controllers/HomeControll...


using CallCenter.Utility;
using CallCenterApi.Common;
using CallCenterApi.Interface.Controllers.Base;
using CallCenterApi.Interface.Models.Common;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlTypes;
using System.Linq;
using System.Text;
using System.Threading;
using System.Web;
using System.Web.Caching;
using System.Web.Mvc;

namespace CallCenterApi.Interface.Controllers
{
    public class HomeController : BaseController
    {
        // GET: Home
        public ActionResult Index()
        {
            //string result = EncryptHelper.EncryptAES("Data Source=192.168.8.3;User ID=sa;pwd=800100;Connection Timeout=2880000;Initial Catalog=SQ12345;");
            
            //string result = EncryptHelper.EncryptAES("Data Source = 172.16.1.7; User ID = sa; pwd = sqszrx12345; Connection Timeout = 3600; Initial Catalog = SQSZRX;");
            return Success("成功");
        }
        public ActionResult Index1()
        {
            string result = DB.DbHelperSQL.GetSingle("select count(1) from T_Sys_UserAccount").ToString();
            return Success("成功");
        }
        public ActionResult Index2(string url)
        {
            string result = EncryptHelper.DecryptAES(url);
            return Success(result);
        }
        [Authorize]
        public JsonResult json1()
        {
            var person = new
            {
                Name = "张三",
                Age = 22,
                Sex = "男"
            };
            return Json(person, JsonRequestBehavior.AllowGet);
        }

        public string json2()
        {
            var person = new
            {
                Name = "张三",
                Age = 22,
                Sex = "男",
                Date = DateTime.Now
            };
            return person.ToJson();
        }



        public string json2_()
        {
            var tt = new
            {
                exp = 20,
                money = 12
            };
            var person = new
            {
                Name = "张三",
                Age = 22,
                Sex = "男",
                other = tt,
                Date = DateTime.Now
            };
            return person.ToJson();
        }

        /// <summary>
        /// 演示 查询出来datatable的数据进行展示
        /// </summary>
        /// <returns></returns>
        public string json3()
        {
            DataTable tblDatas = new DataTable("Datas");
            DataColumn dc = null;


            dc = tblDatas.Columns.Add("Product", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Version", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Description", Type.GetType("System.String"));

            DataRow newRow;
            newRow = tblDatas.NewRow();
            newRow["Product"] = "大话西游";
            newRow["Version"] = "2.0";
            newRow["Description"] = "我很喜欢";
            tblDatas.Rows.Add(newRow);

            newRow = tblDatas.NewRow();
            newRow["Product"] = "梦幻西游";
            newRow["Version"] = "3.0";
            newRow["Description"] = "比大话更幼稚";
            tblDatas.Rows.Add(newRow);

            return tblDatas.ToJson();
        }

        public ActionResult json3_()
        {
            DataTable tblDatas = new DataTable("Datas");
            DataColumn dc = null;


            dc = tblDatas.Columns.Add("Product", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Version", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Description", Type.GetType("System.String"));

            DataRow newRow;
            newRow = tblDatas.NewRow();
            newRow["Product"] = "大话西游";
            newRow["Version"] = "2.0";
            newRow["Description"] = "我很喜欢";
            tblDatas.Rows.Add(newRow);

            newRow = tblDatas.NewRow();
            newRow["Product"] = "梦幻西游";
            newRow["Version"] = "3.0";
            newRow["Description"] = "比大话更幼稚";
            tblDatas.Rows.Add(newRow);

            return Success("成功", tblDatas);
        }

        public ActionResult excel()
        {
            DataTable tblDatas = new DataTable("Datas");
            DataColumn dc = null;


            dc = tblDatas.Columns.Add("Product", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Version", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Description", Type.GetType("System.String"));

            DataRow newRow;
            newRow = tblDatas.NewRow();
            newRow["Product"] = "大话西游";
            newRow["Version"] = "2.0";
            newRow["Description"] = "我很喜欢";
            tblDatas.Rows.Add(newRow);

            newRow = tblDatas.NewRow();
            newRow["Product"] = "梦幻西游";
            newRow["Version"] = "3.0";
            newRow["Description"] = "比大话更幼稚";
            tblDatas.Rows.Add(newRow);

            NPOIHelper npoi = new NPOIHelper();
            string[] s = { "列1", "列2", "列3" };
            if (npoi.ToExcel(tblDatas, "test", null, "D:/2.xlsx", s))
            {
                return Success("成功", tblDatas);
            }
            else
            {
                return Error("导出失败");
            }

        }
        public ActionResult excel1()
        {
            DataTable tblDatas = new DataTable("Datas");
            DataColumn dc = null;


            dc = tblDatas.Columns.Add("Product", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Version", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Description", Type.GetType("System.String"));

            DataRow newRow;
            newRow = tblDatas.NewRow();
            newRow["Product"] = "大话西游";
            newRow["Version"] = "2.0";
            newRow["Description"] = "我很喜欢";
            tblDatas.Rows.Add(newRow);

            newRow = tblDatas.NewRow();
            newRow["Product"] = "梦幻西游";
            newRow["Version"] = "3.0";
            newRow["Description"] = "比大话更幼稚";
            tblDatas.Rows.Add(newRow);

            NPOIHelper npoi = new NPOIHelper();

            if (npoi.ExportToExcel("test", tblDatas) == "")
            {
                return Success("成功", tblDatas);
            }
            else
            {
                return Error("导出失败");
            }

        }

        public ActionResult error()
        {
            return Error("不具备权限");
        }

        public string ss()
        {
            return "ss";
        }

        public string tt(string name, string pass)
        {
            return "sss  " + name + pass;
        }

        /// <summary>
        /// 抛出HTTP 500
        /// </summary>
        /// <returns></returns>        
        public ActionResult ThrowHttp500()
        {
            throw new HttpException(500, "服务器错误");
        }
        /// <summary>
        /// 抛出HTTP 404
        /// </summary>
        /// <returns></returns>
        public ActionResult ThrowHttp404()
        {
            throw new HttpException(404, "页面未找到");
        }

        /// <summary>
        /// 抛出未引用对象异常
        /// ，此处单独使用HandleError特性
        /// ，并指定异常类型及响应视图
        /// </summary>
        /// <returns></returns>
        [HandleError(ExceptionType = typeof(NullReferenceException), View = "CustomError")]
        public ActionResult ThrowNullReferenceException()
        {
            throw new NullReferenceException();
        }
        /// <summary>
        /// 引发输入字符串的格式不正确异常
        /// ，此处指定了响应的错误页面
        /// ，由于是不同的控制器所以要完整的相对路径
        /// </summary>
        /// <returns></returns>
        [HandleError(View = "~/Views/Error/CustomHttpError.cshtml")]
        public ActionResult ThrowFormatException()
        {
            string str = "";
            int count = Convert.ToInt32(str);
            return View("Index");
        }

        public ActionResult GetRedis(string key)
        {
            List<object> caches = new List<object>();
            var keys = RedisHelper.GetKeyList(string.IsNullOrEmpty(key) ? "" : key);

            foreach (var k in keys)
            {
                caches.Add(new
                {
                    key = k,
                    value = RedisHelper.StringGet(k),
                    outtime=RedisHelper.GetKeyOutTime(k)
                });
            }
            return Success("成功", caches);
        }

        public ActionResult UpdateRedis(string key, string value, int second = 10)
        {
            List<object> caches = new List<object>();
            var keys = RedisHelper.GetKeyList(string.IsNullOrEmpty(key) ? "" : key);

            foreach (var k in keys)
            {
                RedisHelper.StringSet(k, value, new TimeSpan(0, 0, second));
            }
            return Success("成功");
        }

        public ActionResult DeleteRedis(string key)
        {
            List<object> caches = new List<object>();
            var keys = RedisHelper.GetKeyList(string.IsNullOrEmpty(key) ? "" : key);

            long n = RedisHelper.KeysDelete(keys);
            return Success("成功", n);
        }

        public ActionResult GetAllCache()
        {
            System.Web.Caching.Cache cache = HttpRuntime.Cache;
            IDictionaryEnumerator cacheEnum = cache.GetEnumerator();
            List<cacheobj> caches = new List<cacheobj>();
            StringBuilder sb = new StringBuilder();
            while (cacheEnum.MoveNext())
            {

                Dictionary<string, string> dic = null;
                try
                {
                    dic = (Dictionary<string, string>)cacheEnum.Value;
                }
                catch
                {
                    continue;
                }

                sb.Append($"F_UserID={dic["F_UserID"]}, ");
                sb.Append($"F_UserCode={dic["F_UserCode"]}, ");
                sb.Append($"F_UserName={dic["F_UserName"]} ");

                caches.Add(new cacheobj
                {
                    key = cacheEnum.Key.ToString().Substring(0, 20),
                    value = sb.ToString()
                });
                sb.Clear();
            }
            return Success("", new
            {
                count = caches.Count(),

            });
        }

        //public ActionResult MakeCache()
        //{
        //    while (true)
        //    {
        //        Dictionary<string, string> Dic = new Dictionary<string, string>();
        //        Dic.Add("F_UserID", "1411");
        //        Dic.Add("F_UserCode", "8000");
        //        Dic.Add("F_DeptId", "1");
        //        Dic.Add("F_UserName", "系统管理员");
        //        Dic.Add("F_Telephone", "15537150907");
        //        Dic.Add("F_RoleID", "1");
        //        Dic.Add("F_SeatFlag", "1");

        //        new CallCenterApi.BLL.T_Sys_LoginLogs().Add(new Model.T_Sys_LoginLogs()
        //        {
        //            F_LoginName = "8000",
        //            F_LoginId = 1411,
        //            F_Result = "登录成功",
        //            F_LoginIP = Common.DTRequest.GetIP(),
        //            F_Hostname = Common.DTRequest.GetIP(),
        //            F_LoginDate = DateTime.Now,
        //            F_Remark = "",
        //            F_State = 0
        //        });
        //        var token = FormsPrincipal<Dictionary<string, string>>.GetCookieValue(Dic["F_UserCode"], Dic);

        //        //放入缓存
        //        CacheHelper.Insert(token, Dic, 2880, System.Web.Caching.CacheItemPriority.NotRemovable);
        //        Response.Write(token.Substring(0, 20) + "</n>");
        //    }
        //}

        public ActionResult TestCache()
        {
            int n = 0;
            while (n<100)
            {
                Dictionary<string, string> Dic = new Dictionary<string, string>();
                Dic.Add("F_UserID", (1000 + n).ToString());
                Dic.Add("F_UserCode", (8000+n).ToString());
                Dic.Add("F_DeptId", "1");
                Dic.Add("F_UserName", "系统管理员" + n);
                Dic.Add("F_Telephone", "15537150907");
                Dic.Add("F_RoleID", "1");
                Dic.Add("F_SeatFlag", "1");

                var token = FormsPrincipal<Dictionary<string, string>>.GetCookieValue(Dic["F_UserCode"], Dic);
                CacheItemRemovedCallback cacheItemRemovedCallback = new CacheItemRemovedCallback(onRemove);
                //放入缓存
                CacheHelper.Insert(token, Dic, 1, System.Web.Caching.CacheItemPriority.NotRemovable, cacheItemRemovedCallback);
                n++;
            }
            return Success(n.ToString());
        }

        /// <summary>
        /// 移除缓存后调用
        /// </summary>
        /// <param name="key"></param>
        /// <param name="val"></param>
        /// <param name="reason"></param>
        public void onRemove(string key, object val, CacheItemRemovedReason reason)
        {
            var obj = new
            {
                key = key,
                val = val,
                reason = reason
            };
            Error(obj.ToJson());
        }
    }


    public class cacheobj
    {
        public string key { get; set; }
        public string value { get; set; }

    }
}