using AUTS.Services.Extensions;
using Face.Domain.Application;
using Face.Domain.Entities;
using Face.Domain.ViewModels;
using Face.Services.Cache;
using Face.Services.DBUtility.Common;
using Face.Services.DBUtility.Custom;
using Face.Services.Manager;
using Face.Web.Areas.App.Models;
using PagedList;
using SqlSugar;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data.Entity.Core.Metadata.Edm;
using System.Data.Entity.Validation;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.NetworkInformation;
using System.Net.Security;
using System.Net.Sockets;
using System.Net.WebSockets;
using System.Reflection;
using System.Reflection.Emit;
using System.Security.Cryptography.X509Certificates;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Web.Hosting;
using System.Web.Mvc;
using WebSocketToolsConsole;

using static Face.Web.Areas.App.Models.Roominfo;
using static WebSocketToolsConsole.Entity;

namespace Face.Web.Areas.App.Controllers
{
    public class FaceController : BaseController
    {
        List<DeviceManage> li = new List<DeviceManage>();


        public List<DeviceManage> GetFace//人脸机缓存
        {
            get { return CacheHelp.GetFaceList(); }
        }
        public List<Hotels> GetHotel//酒店缓存
        {
            get { return CacheHelp.GetHotelslist(); }
        }

        public List<Hosts> GetRoom//房间缓存
        {
            get { return CacheHelp.GetRoomGroup(); }
        }
        //***********************************************
        // GET: App/Face


        public ActionResult Facetest(obje data)//人脸机测试  
        {
            Session["sn"] = data.faceNo;
            Session["hotelCode"] = data.hotel;
            return View();
        }

        public ActionResult TestFaceall(string Sn)
        {
            ViewData["SnDing"] = Sn;
            return View();
        }


        [HttpPost]
        public ActionResult InquireFaceall(Condition data)
        {
            List<int> lit = (List<int>)Session["list"];
            List<AuthItem> authItem = (List<AuthItem>)Session["authItems"];

            string strSql = "";

            strSql += ("select * ");

            strSql += (" from devicemanage  where 0=0 and (");


            for (int i = 0; i < lit.Count; i++)
            {
                strSql += (" HotelCode=" + lit[i] + " or");
            }

            strSql = strSql.Substring(0, strSql.Length - 2);
            if (authItem[0].AuthorityId == 3)
            {
                strSql += " or HotelCode=0 or HotelCode is null ";
            }
            strSql += ")";
            if (data.HotelID == -1)
            {
                strSql += " and (HotelCode=0 or HotelCode is null) ";
            }
            //酒店id判断
            else if (data.HotelID != 0)
            {
                strSql += " and HotelCode=" + data.HotelID;
            }
            //-1代表全部房间
            if (data.Notbing != -1)
            {
                strSql += " and bindingStatus=" + data.Notbing;
            }
            //-1代表全部
            if (data.Status != -1)
            {
                strSql += " and Status=" + data.Status;
            }
            //人脸机名称
            if (data.FaceName != "" && data.FaceName != null)
            {
                strSql += "  and SerialNo  like  '%" + data.FaceName + "%' ";
            }
            string sqlnumber = strSql;
            strSql += "  ORDER BY `Status` DESC  LIMIT " + (data.dataMin) + ",8;";
            //分页后
            var countNum = new DALHelperCustom<DeviceManage>("DeviceManage").SqlQueryGetList(strSql.ToString());

            //一共多少页
            var countNumCount = new DALHelperCustom<DeviceManage>("DeviceManage").SqlQueryGetList(sqlnumber.ToString());
            if (countNumCount != null && countNumCount.Count != 0)
            {
                ViewBag.count = countNumCount.Count;
                ViewBag.allpage = (countNumCount.Count + 8 - 1) / 8;
            }
            else
            {
                countNum = null;
            }
            DateTime dt = Convert.ToDateTime("2000-01-01");
            var sd = SqlSugarBase.GesmartDb().Queryable<CheckInInfo>().Where(s => s.checkOutTime == dt).ToList();
            ViewData["sungo"] = sd;
            return PartialView("InquireFaceall", countNum);
        }
        public ActionResult unbundle(int? page, string skip = null)//解绑人脸机
        {
            List<int> lit = (List<int>)Session["list"];
            List<TBL_ROOM_BASIC_INFO> ZongRoominfo = (List<TBL_ROOM_BASIC_INFO>)Session["ZongRoominfo"];
            List<Hotel> hotellist = new List<Hotel>();
            try
            {
                using (SqlSugarClient db = SqlSugarBase.GesmartDb())
                {
                    hotellist = db.Queryable<Hotel>().ToList();
                    ViewBag.Orgs = hotellist;
                    var userList = db.Queryable<DeviceManage>().ToList();
                    //第几页  
                    int pageNumber = page ?? 1;

                    //每页显示多少条  
                    int pageSize = 8;

                    //根据ID升序排序  
                    userList = userList.OrderByDescending(x => x.Status).ToList();

                    for (int i = 0; i < lit.Count; i++)
                    {
                        var id = Convert.ToInt32(lit[i]);
                        li.AddRange(userList.Where(x => x.HotelCode == id.ToString()).ToList());
                    }
                    //绑定状态为true
                    li = li.Where(x => x.bindingStatus == true).ToList();

                    if (skip != "" && skip != null)
                    {

                        //var ro = from s in Authority.Hotels where s.Name == skip select s.Id;
                        ViewData["ho"] = SqlSugarBase.authoriydb.Queryable<Hotels>().ToList();

                        ViewData["skip"] = skip;
                        //li = li.Where(x => x.RoomNumber.Contains(skip)).ToList();

                    }

                    //通过ToPagedList扩展方法进行分页  
                    IPagedList<DeviceManage> userPagedList = li.ToPagedList(pageNumber, pageSize);

                    //将分页处理后的列表传给View 
                    return View(userPagedList);
                }
            }
            catch (Exception ex)
            {
                LogHelp.WriteExceptionLog(ex);
                throw;
            }

        }
        /// <summary>
        /// 解绑房间人脸机操作
        /// </summary>
        /// <param name="sn"></param>
        /// <returns></returns>
        public ActionResult unbundleoperate(obje hotelno)
        {
            ReturnResult result = new ReturnResult();
            try
            {
                if (SqlOperationsData.unbundleoperateRoom(hotelno.faceNo) != 0)
                {
                    FaceBinding binding = new FaceBinding
                    {
                        bindingDate = DateTime.Now,
                        HotelCode = int.Parse(hotelno.hotel),
                        OperatorType = false,
                        RoomId = hotelno.romm,
                        SerialNo = hotelno.faceNo,
                        Operator = Session["username"].ToString()

                    };
                    if (SqlOperationsData.bindingState(binding) != 0)
                        result.Status = 200;
                }
                else
                {
                    result.Status = 500;
                }

            }
            catch (Exception ex)
            {
                LogHelp.WriteExceptionLog(ex, Session["username"].ToString());
                result.Status = 100;

            }
            return Json(result);
        }
        /// <summary>
        /// 解绑酒店人脸机操作
        /// </summary>
        /// <param name="sn"></param>
        /// <returns></returns>
        public ActionResult unbundlehotel(obje hotelno)
        {
            ReturnResult result = new ReturnResult();
            try
            {
                if (SqlOperationsData.unbundleoperatehotel(hotelno.faceNo) != 0)
                {
                    FaceBinding binding = new FaceBinding
                    {
                        bindingDate = DateTime.Now,
                        HotelCode = int.Parse(hotelno.hotel),
                        OperatorType = false,
                        RoomId = hotelno.romm,
                        SerialNo = hotelno.faceNo,
                        Operator = Session["username"].ToString()

                    };
                    if (SqlOperationsData.bindingState(binding) != 0)
                        result.Status = 200;
                }
                else
                {
                    result.Status = 500;
                }

            }
            catch (Exception ex)
            {
                LogHelp.WriteExceptionLog(ex, Session["username"].ToString());
                result.Status = 100;

            }
            return Json(result);
        }
        /// <summary>
        /// 绑定房间
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        public ActionResult bindingRoom(int? page, string sun = null)
        {

            ViewData["hw"] = SqlSugarBase.authoriydb.Queryable<Hotels>().ToList();

            List<Hotel> hotellist = new List<Hotel>();
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                hotellist = db.Queryable<Hotel>().ToList();
                ViewBag.Orgs = hotellist;
                var userList = db.Queryable<DeviceManage>().ToList();
                //第几页  
                int pageNumber = page ?? 1;

                //每页显示多少条  
                int pageSize = 8;

                //根据ID升序排序  
                li = li.OrderByDescending(x => x.Status).ToList();

                List<int> lit = (List<int>)Session["list"];
                List<TBL_ROOM_BASIC_INFO> ZongRoominfo = (List<TBL_ROOM_BASIC_INFO>)Session["ZongRoominfo"];
                for (int i = 0; i < lit.Count; i++)
                {
                    var id = Convert.ToInt32(lit[i]);
                    li.AddRange(userList.Where(x => x.HotelCode == id.ToString()).ToList());
                }

                //绑定状态为false
                li = li.Where(x => x.bindingStatus == false).ToList();
                if (sun != "" && sun != null)
                {
                    ViewData["sun"] = sun;
                    li = li.Where(x => x.SerialNo.Contains(sun)).ToList();
                }
                //通过ToPagedList扩展方法进行分页  
                IPagedList<DeviceManage> userPagedList = li.ToPagedList(pageNumber, pageSize);

                //将分页处理后的列表传给View 
                return View(userPagedList);
            }

        }
        public ActionResult BingInfo(obje ob)//绑定房间操作
        {
            ViewData["hh"] = SqlSugarBase.authoriydb.Queryable<Hotels>().ToList();
            List<Hotel> hotellist = new List<Hotel>();
            Session["SnoNO"] = ob.faceNo;
            Session["hotelcode"] = ob.hotel;
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                hotellist = db.Queryable<Hotel>().ToList();
                ViewBag.Orgs = hotellist;
            }
            return View();
        }
        public ActionResult addfaceroom(obje obje)//房间绑定人脸机操作
        {
            ReturnResult result = new ReturnResult();
            try
            {
                if (SqlOperationsData.reviseRommFace(obje.hotel, obje.romm, obje.faceNo) != 0)
                {
                    FaceBinding binding = new FaceBinding
                    {
                        bindingDate = DateTime.Now,
                        HotelCode = int.Parse(obje.hotel),
                        OperatorType = true,
                        RoomId = obje.romm,
                        SerialNo = obje.faceNo,
                        Operator = Session["username"].ToString()
                    };
                    if (SqlOperationsData.bindingState(binding) != 0)
                    {
                        result.Status = 200;
                        result.Message = "为房间添加人脸机成功";
                    }
                }
                else
                {
                    result.Status = 500;
                }
            }
            catch (Exception ex)
            {
                LogHelp.WriteExceptionLog(ex, Session["username"].ToString());
                result.Status = 100;
            }
            return Json(result);
        }
        public ActionResult addfacehotel(obje obje)//酒店绑定人脸机操作
        {
            ReturnResult result = new ReturnResult();
            try
            {
                if (SqlOperationsData.reviseHotelFace(obje.hotel, obje.faceNo) != 0)
                {
                    result.Status = 200;
                    result.Message = "为酒店添加人脸机成功";
                }
                else
                {
                    result.Status = 500;
                }
            }
            catch (Exception ex)
            {
                LogHelp.WriteExceptionLog(ex, Session["username"].ToString());
                result.Status = 100;
            }

            return Json(result);
        }
        #region 人脸机操作
        public ActionResult IssuedPeople()//下发人员
        {
            return View();
        }
        public ActionResult selectpeople()//查询人员信息
        {
            return View();
        }

        public ActionResult DeletePeople(string name)//根据名字删除人员
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Session["sn"].ToString();
            msgx.cmd = "removePerson";
            StringBuilder builder = new StringBuilder();
            builder.Append("key=abc");
            builder.Append("&id=" + name);
            msgx.msg = System.Web.HttpUtility.HtmlDecode(builder.ToString());
            info.pmsid = -1;
            info.msgx = msgx;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            string sn = Session["sn"].ToString();
            int dbt = SqlSugarBase.Db.Queryable<DeviceManage>().First(x => x.SerialNo == sn).RoomId.Value;
            ULog uLog = new ULog
            {
                Uname = Session["username"].ToString(),
                faceSN = Session["sn"].ToString(),
                operatetype = "删除操作",
                hotelcode = int.Parse(Session["hotelCode"].ToString()),
                roomid = dbt,
                Creationtime = DateTime.Now
            };
            //SqlOperationsData.writeLog(uLog);
            SqlSugarBase.Db.Insertable(uLog).ExecuteCommand();
            return Json("成功", JsonRequestBehavior.AllowGet);
        }
        public ActionResult SelectPople(string name)//根据id查询人员信息
        {
            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Session["sn"].ToString();
            msgx.cmd = "getPerson";
            StringBuilder builder = new StringBuilder();
            builder.Append("key=abc");
            builder.Append("&id=" + name);
            msgx.msg = System.Web.HttpUtility.HtmlDecode(builder.ToString());
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(msgx);
            UdpCommunication.UdpState2(sendMsg);
            //var seta = UdpCommunication.UdpStateinfo2();
            return Json(true);
        }



        /// <summary>
        /// 下发固件
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public ActionResult SetAPKSand(string ApkName)
        {
            Entity.Rootinfo rootinfo = new Entity.Rootinfo();
            Entity.msgx msgx = new Entity.msgx();

            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Session["sn"].ToString();
            msgx.cmd = "updateAPK";//操作
            StringBuilder sbperson = new StringBuilder();
            sbperson.Append("key=abc");
            sbperson.Append(@"&url=yh/fw/" + ApkName);
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
            rootinfo.msgx = msgx;
            rootinfo.pmsid = -1;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(rootinfo);
            UdpCommunication.QueueSend(sendMsg);
            using (var db = SqlSugarBase.GesmartDb())
            {
                string sn = Session["sn"].ToString();
                var dbt = db.Queryable<DeviceManage>().First(x => x.SerialNo == sn);
                ULog uLog = new ULog
                {
                    Uname = Session["username"].ToString(),
                    faceSN = Session["sn"].ToString(),
                    operatetype = "升级固件",
                    hotelcode = int.Parse(Session["hotelCode"].ToString()),
                    roomid = dbt.RoomId,
                    Creationtime = DateTime.Now
                };
                SqlSugarBase.Db.Insertable(uLog).ExecuteCommand();

            }
            return Json(true);
        }

        /// <summary>
        /// 测试下发固件
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public ActionResult TestSetAPKSandWithProgress()
        {
            Entity.Rootinfo rootinfo = new Entity.Rootinfo();
            Entity.msgx msgx = new Entity.msgx();

            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Session["sn"].ToString();
            msgx.cmd = "updateAPK";//操作
            StringBuilder sbperson = new StringBuilder();
            sbperson.Append("key=abc");
            //sbperson.Append(@"&url=yh/fw/EUPGRADE-v1.9.9-ce7d1577424a3759b1c2302ac565287e.pkg"); //移海2023-10-12版本测试
            sbperson.Append(@"&url=yh/fw/EUPGRADE-v1.3.7-d1c0d1b86b7a4ec24d679ae93a41f1db.pkg"); //移海2023-10-12版本测试

            msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
            rootinfo.msgx = msgx;
            rootinfo.pmsid = -1;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(rootinfo);
            UdpCommunication.QueueSend(sendMsg);
            using (var db = SqlSugarBase.GesmartDb())
            {
                string sn = Session["sn"].ToString();
                var dbt = db.Queryable<DeviceManage>().First(x => x.SerialNo == sn);
                ULog uLog = new ULog
                {
                    Uname = Session["username"].ToString(),
                    faceSN = Session["sn"].ToString(),
                    operatetype = "升级固件",
                    hotelcode = int.Parse(Session["hotelCode"].ToString()),
                    roomid = dbt.RoomId,
                    Creationtime = DateTime.Now
                };
                SqlSugarBase.Db.Insertable(uLog).ExecuteCommand();

            }
            return Json(new { result = true, msgid = msgx.msgid });
        }

        public ActionResult GetSetAPKSandProgressData(List<String> msgidList)
        {
            //In future, will return percentage directly.
            //Dictionary<String, int> listdevprog = new Dictionary<string, int>();
            Dictionary<String, List<Face.Domain.Application.FaceAll.facedevicerxtxinfo>> listdevprog = new Dictionary<String, List<Face.Domain.Application.FaceAll.facedevicerxtxinfo>>();

            using (var db = SqlSugarBase.GesmartDb())
            {
                List<Face.Domain.Application.FaceAll.facedevicerxtxinfo> matchedList = db.Queryable<Face.Domain.Application.FaceAll.facedevicerxtxinfo>()
                    .Where(x => msgidList.Contains(x.msgid) && x.direction == "Rx")
                    .ToList();

                foreach (string msgid in msgidList)
                {
                    List<Face.Domain.Application.FaceAll.facedevicerxtxinfo> currMsgList = matchedList.Where(x => x.msgid == msgid).ToList();
                    listdevprog.Add(msgid, currMsgList);
                    //if (currMsgList.Count <= 0)
                    //{
                    //    //listdevprog.Add(msgid, 0); //no record, 0%
                    //}
                    //else
                    //{
                    //    //found the max value as percentage
                    //    //need analysis the format
                    //}
                }
            }

            return Json(listdevprog);
        }


        /// <summary>
        /// 批量下发固件
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public ActionResult BatchSetAPKSand(string ApkName, string RoomidList)
        {
            List<string> Roomidlist = RoomidList.Split(',').ToList();
            string sql = "SELECT * from devicemanage where ";
            for (int i = 0; i < Roomidlist.Count; i++)
            {
                sql += "RoomId=" + Roomidlist[i] + " or ";
            }
            sql = sql.Substring(0, sql.Length - 3);
            var countNum = new DALHelperCustom<DeviceManage>("DeviceManage").SqlQueryGetList(sql.ToString());
            List<string> arrlist = new List<string>();
            try
            {
                for (int i = 0; i < countNum.Count; i++)
                {
                    //Entity.Rootinfo rootinfo = new Entity.Rootinfo();
                    //Entity.msgx msgx = new Entity.msgx();
                    //msgx.msgid = Guid.NewGuid().ToString();
                    //msgx.sn = Session["sn"].ToString();
                    //msgx.cmd = "updateAPK";//操作
                    //StringBuilder sbperson = new StringBuilder();
                    //sbperson.Append("key=abc");
                    //sbperson.Append(@"&url=yh/fw/" + ApkName);
                    //msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
                    //rootinfo.msgx = msgx;
                    //rootinfo.pmsid = -1;
                    //string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(rootinfo);
                    //UdpCommunication.QueueSend(sendMsg);


                    Entity.Rootinfo rootinfo = new Entity.Rootinfo();
                    Entity.msgx msgx = new Entity.msgx();
                     msgx.msgid = Guid.NewGuid().ToString();
                    if (!arrlist.Contains(msgx.msgid)) { arrlist.Add(msgx.msgid); }
                    msgx.sn = countNum[i].SerialNo;
                    msgx.cmd = "updateAPK";//操作
                    StringBuilder sbperson = new StringBuilder();
                    sbperson.Append("key=abc");
                    sbperson.Append(@"&url=yh/fw/" + ApkName);
                    msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
                    rootinfo.msgx = msgx;
                    rootinfo.pmsid = -1;
                    string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(rootinfo);
                    UdpCommunication.QueueSend(sendMsg);




                }
                return Json(new { isok = true, arr = arrlist });
            }
            catch (Exception)
            {
                return Json(false);

            }
        }



        /// <summary>
        /// 创建过闸人员
        /// </summary>
        /// <param name="ib"></param>
        /// 
        public ActionResult IssuedSandShow(InfoBody ib)
        {
            string returninfo = "";
            if (string.IsNullOrEmpty(ib.name) | string.IsNullOrEmpty(ib.id_no))
            {
                string info = "不可为空";
                return Json(info, JsonRequestBehavior.AllowGet);
            }
            else if (string.IsNullOrEmpty(ib.photo))
            {
                string info = "请选择图片，点击上传";
                return Json(info, JsonRequestBehavior.AllowGet);
            }
            try
            {
                StringBuilder sbperson = new StringBuilder();
                sbperson.Append("key=abc");
                sbperson.Append("&id=" + ib.id_no);
                sbperson.Append("&name=" + ib.name);
                sbperson.Append("&IC_NO=0001");
                sbperson.Append("&ID_NO=" + ib.id_no);
                sbperson.Append("&photo=<" + ib.photo + ">");
                sbperson.Append("&startTs=" + ib.startTs);
                sbperson.Append("&endTs=-1");
                sbperson.Append("&passCount=10000");
                sbperson.Append("&visitor=true");
                Entity.msgx msgx = new Entity.msgx();
                msgx.msgid = Guid.NewGuid().ToString();
                msgx.sn = Session["sn"].ToString();
                msgx.cmd = "setPerson)";
                msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
                string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(msgx);
                UdpCommunication.QueueSend(sendMsg);

                ULog uLog = new ULog
                {
                    Uname = Session["username"].ToString(),
                    faceSN = Session["sn"].ToString(),
                    operatetype = "创建过闸人员操作",
                    hotelcode = int.Parse(Session["hotelCode"].ToString())
                };
                SqlOperationsData.writeLog(uLog);
            }
            catch (CustomException ex)
            {
                LogHelp.WriteExceptionLog(ex);
            }
            catch (DbEntityValidationException ex)
            {
                LogHelp.WriteExceptionLog(ex);
            }
            return Json(returninfo, JsonRequestBehavior.AllowGet);
        }
        public ActionResult rebootSand(string Serial)//命令人脸机重启
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "reboot";//操作
            msgx.msg = "key=abc";
            info.msgx = msgx;
            info.pmsid = -1;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            using (var db = SqlSugarBase.GesmartDb())
            {
                var dbt = db.Queryable<DeviceManage>().First(x => x.SerialNo == Serial);
                ULog uLog = new ULog
                {
                    Uname = Session["username"].ToString(),
                    faceSN = Serial,
                    operatetype = "重启操作",
                    hotelcode = int.Parse(Session["hotelCode"].ToString()),
                    roomid = dbt.RoomId,
                    Creationtime = DateTime.Now
                };
                //SqlOperationsData.writeLog(uLog);
                SqlSugarBase.Db.Insertable(uLog).ExecuteCommand();

            }
            string s = "重启成功";
            return Json(s, JsonRequestBehavior.AllowGet);
        }


        public ActionResult GetRebootSandResult(string Serial)//取到命令人脸机重启设备端上报信息。。root重启了。所有没有记录。
        {
            if (!String.IsNullOrWhiteSpace(Serial))
            {
                List<pmsLog> matchedPmsLog = SqlSugarBase.Db.Queryable<pmsLog>().Where(it => it.pmsid == 0 && it.message.Contains(Serial)).ToList();
                if (matchedPmsLog.Count > 0)
                {
                    return Json(matchedPmsLog[0], JsonRequestBehavior.AllowGet);
                }
            }

            return Json("取人脸机响应失败", JsonRequestBehavior.AllowGet);
        }

        public ActionResult openTheDoor(string Serial)//命令人脸机开门
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();
            StringBuilder sbperson = new StringBuilder();
            sbperson.Append("key=abc");
            sbperson.Append("&id=1123");
            sbperson.Append("&name=2323");
            sbperson.Append("&IC_NO=0001");
            sbperson.Append("&ID_NO=23");
            sbperson.Append("&photo=34");
            sbperson.Append("&startTs=234");
            sbperson.Append("&endTs=-1");
            sbperson.Append("&passCount=345");
            sbperson.Append("&visitor=true");

            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "open";//操作
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
            info.msgx = msgx;
            info.pmsid = -1;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            using (var db = SqlSugarBase.GesmartDb())
            {
                string sn = Serial;
                var dbt = db.Queryable<DeviceManage>().First(x => x.SerialNo == sn);
                ULog uLog = new ULog
                {
                    Uname = Session["username"].ToString(),
                    faceSN = Serial,
                    operatetype = "开门操作",
                    hotelcode = int.Parse(Session["hotelCode"].ToString()),
                    roomid = dbt.RoomId,
                    Creationtime = DateTime.Now
                };

                //SqlOperationsData.writeLog(uLog);
                SqlSugarBase.Db.Insertable(uLog).ExecuteCommand();

            }

            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult GetOpenTheDoorResult(string Serial)//取到命令人脸机开门设备端回复消息
        {
            List<pmsLog> matchedPmsLog = new List<pmsLog>();
            if (!String.IsNullOrWhiteSpace(Serial))
            {
                matchedPmsLog = SqlSugarBase.Db.Queryable<pmsLog>()
                    .Where(it => it.pmsid == 0 && it.message.Contains(Serial) && (it.step == 5 || it.step == 3))
                    .OrderBy(it => it.Creationtime, OrderByType.Desc)
                    .ToList();
            }

            return PartialView("DeviceResponseResultView", matchedPmsLog);
        }

        public ActionResult ActionOpenDoorToDevice(string Serial)//命令人脸机开门
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;

            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "open";//操作
            msgx.msg = "key=abc";
            info.msgx = msgx;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult ActionResetToDevice(string Serial)//命令人脸机重启
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;

            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "reboot";//操作
            msgx.msg = "key=abc";
            info.msgx = msgx;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult UpdateKeepLiveInterval(string Serial, int NewInt)
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;

            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "updateKeepAliveInterval";//操作
            msgx.msg = "key=abc&interval=" + NewInt;
            info.msgx = msgx;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult SetOnePeopleToDevice(string Serial, string npeople, bool isNew1Point6 = false)
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "setPerson";
            StringBuilder sb = new StringBuilder();
            sb.Append("key=abc");
            if (npeople == "1")
            {
                if (isNew1Point6)
                    sb.Append("&datatype=2");
                sb.Append("&id=432156782341123429");
                sb.Append("&name=KevinLu");
                sb.Append("&IC_NO=0001");
                sb.Append("&ID_NO=432156782341123429");
                sb.Append("&photo=<http://face.blv-oa.com/upload/testimages/432156782341123429_661497.png>");
                //sb.Append("&photo=<http://localhost:55151/upload/testimages/432156782341123429_661497.png>");
            }
            else
            {
                if (isNew1Point6)
                    sb.Append("&datatype=2");
                sb.Append("&id=123456782341127777");
                sb.Append("&name=VellaLiu");
                sb.Append("&IC_NO=0002");
                sb.Append("&ID_NO=123456782341127777");
                sb.Append("&photo=<http://face.blv-oa.com/upload/testimages/123456782341127777_612497.jpg>");
                //sb.Append("&photo=<http://localhost:55151/upload/testimages/123456782341127777_612497.jpg>");
            }

            if (!isNew1Point6)
            {
                sb.Append("&startTs=-1");
                sb.Append("&endTs=-1");
                sb.Append("&passCount=10000");
            }

            msgx.msg = System.Web.HttpUtility.HtmlDecode(sb.ToString());
            info.msgx = msgx;


            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult GetOnePeopleFromDevice(string Serial, string npeople)
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "getPerson";
            StringBuilder sb = new StringBuilder();
            sb.Append("key=abc");
            if (npeople == "1")
            {
                sb.Append("&id=432156782341123429");
            }
            else
            {
                sb.Append("&id=123456782341127777");
            }
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sb.ToString());
            info.msgx = msgx;


            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult DeletePeopleFromDevice(string Serial, string npeople, bool isNew1Point6 = false)//根据名字删除人员
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;

            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "removePerson";
            StringBuilder builder = new StringBuilder();
            builder.Append("key=abc");
            if (isNew1Point6)
            {
                if (npeople == "1")
                {
                    builder.Append("&id=[432156782341123429]");
                }
                else
                {
                    builder.Append("&id=[123456782341127777]");
                }
            }
            else
            {
                if (npeople == "1")
                {
                    builder.Append("&id=432156782341123429");
                }
                else
                {
                    builder.Append("&id=123456782341127777");
                }
            }

            msgx.msg = System.Web.HttpUtility.HtmlDecode(builder.ToString());
            info.msgx = msgx;

            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult DeletePeopleFromDeviceByGroup(string Serial, string GroupId = "1")//根据名字删除人员
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;

            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "removeGroup";
            StringBuilder builder = new StringBuilder();
            builder.Append("key=abc");
            builder.Append("&Group=" + GroupId);
            msgx.msg = System.Web.HttpUtility.HtmlDecode(builder.ToString());
            info.msgx = msgx;

            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }
        public ActionResult GetThePeopleListOfDevice(string Serial, int TotalNumber)//命令人脸机开门
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();
            StringBuilder sbperson = new StringBuilder();
            sbperson.Append("key=abc");
            sbperson.Append("&number=" + TotalNumber);
            sbperson.Append("&offset=0");

            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "listPersonByNumber";//获取人员列表
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
            info.msgx = msgx;
            info.pmsid = -1;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            using (var db = SqlSugarBase.GesmartDb())
            {
                string sn = Serial;
                var dbt = db.Queryable<DeviceManage>().First(x => x.SerialNo == sn);
                ULog uLog = new ULog
                {
                    Uname = Session["username"].ToString(),
                    faceSN = Serial,
                    operatetype = "获取人员列表",
                    hotelcode = int.Parse(Session["hotelCode"].ToString()),
                    roomid = dbt.RoomId,
                    Creationtime = DateTime.Now
                };
                SqlSugarBase.Db.Insertable(uLog).ExecuteCommand();
            }

            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult GetDeviceInfo(string Serial)//命令人脸机开门
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();

            StringBuilder sbperson = new StringBuilder();
            sbperson.Append("key=abc");
            //sbperson.Append("&number=50");
            //sbperson.Append("&offset=0");

            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "getDeviceInfo";//得到设备信息
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
            info.msgx = msgx;
            info.pmsid = -1;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            using (var db = SqlSugarBase.GesmartDb())
            {
                string sn = Serial;
                var dbt = db.Queryable<DeviceManage>().First(x => x.SerialNo == sn);
                ULog uLog = new ULog
                {
                    Uname = Session["username"].ToString(),
                    faceSN = Serial,
                    operatetype = "得到设备基本信息",
                    hotelcode = int.Parse(Session["hotelCode"].ToString()),
                    roomid = dbt.RoomId,
                    Creationtime = DateTime.Now
                };
                SqlSugarBase.Db.Insertable(uLog).ExecuteCommand();
            }

            return Json("成功", JsonRequestBehavior.AllowGet);
        }
        /// <summary>
        /// 获取websocket服务器
        /// </summary>
        /// <param name="Serial">人脸机序号</param>
        /// <returns></returns>
        public ActionResult GetWebsktServerAddr(string Serial)
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();

            StringBuilder sbperson = new StringBuilder();
            sbperson.Append("key=abc");

            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "getWebSocketBaseURL";//得到设备信息
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
            info.msgx = msgx;
            info.pmsid = -1;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);

            return Json("成功", JsonRequestBehavior.AllowGet);
        }
        /// <summary>
        /// 设置websocket服务器
        /// </summary>
        /// <param name="Serial"></param>
        /// <returns></returns>
        public ActionResult setWebsktServerAddr(string Serial)
        {


            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "setWebSocketBaseURL";
            StringBuilder sb = new StringBuilder();
            sb.Append("key=abc");
            sb.Append("&url=ws://47.119.147.104:82");
            sb.Append("&auth=ZGV2OjEyMw==");
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sb.ToString());
            info.msgx = msgx;


            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }
        /// <summary>
        /// 设置设备信息
        /// </summary>
        /// <param name="Serial"></param>
        /// <returns></returns>
        public ActionResult setDeviceInfo(string Serial)
        {
            Entity.Rootinfo info = new Entity.Rootinfo();
            info.pmsid = -1;
            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Serial;
            msgx.cmd = "setDeviceInfo";
            StringBuilder sb = new StringBuilder();
            sb.Append("key=abc");
            sb.Append("&cameraDetectType=0");
            sb.Append("&faceFeaturePairNumber=0.50");
            sb.Append("&faceFeaturePairSuccessOrFailWaitTime=2000");
            sb.Append("&openDoorType=2");
            sb.Append("&openDoorContinueTime=1000");
            sb.Append("&doorType=340");
            sb.Append("&idCardFaceFeaturePairNumber=0.50");
            sb.Append("&appWelcomeMsg=识别成功了吗。");
            sb.Append("&deviceSoundSize=100");
            sb.Append("&deviceDefendTime=00:00-00:0Boonlive");
            sb.Append("&deviceName=Boonlive");
            sb.Append("&tipsPairFail=Fail");
            sb.Append("&picQualityRate = 0.72000002861022949");
            sb.Append("&beginRecoDistance = 0");
            sb.Append("&pairSuccessOpenDoor=0");
            sb.Append("&fillLightTimes=06:06-07:00");
            sb.Append("&lowPowerTimes=00:00-00:0\u0001");
            sb.Append("&recognitionSwitch=1");
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sb.ToString());
            info.msgx = msgx;
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(info);
            UdpCommunication.QueueSend(sendMsg);
            return Json("成功", JsonRequestBehavior.AllowGet);
        }
        public ActionResult ClearFaceDeviceResult(string Serial)//命令人脸机开门
        {
            List<pmsLog> matchedPmsLog = new List<pmsLog>();
            if (!String.IsNullOrWhiteSpace(Serial))
            {
                SqlSugarBase.Db.Deleteable<pmsLog>().Where(it => it.pmsid == 0 && it.message.Contains(Serial)).ExecuteCommand();
            }

            return Json("成功", JsonRequestBehavior.AllowGet);
        }

        public ActionResult selectinfoShow(string name)//查询客户信息
        {
            StringBuilder sbperson = new StringBuilder();
            sbperson.Append("key=abc");
            sbperson.Append("&id=" + name);
            Entity.msgx msgx = new Entity.msgx();
            msgx.msgid = Guid.NewGuid().ToString();
            msgx.sn = Session["sn"].ToString();
            msgx.msg = System.Web.HttpUtility.HtmlDecode(sbperson.ToString());
            string sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(msgx);
            UdpCommunication.QueueSend(sendMsg);
            return View();
        }
        /// <summary>
        /// 实时控制人脸机状态
        /// </summary>
        /// <returns></returns>
        public ActionResult Status()
        {
            //SqlOperationsData.Monitor();
            List<DeviceManage> facelist = new List<DeviceManage>();
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                facelist = db.Queryable<DeviceManage>().ToList();
            }
            return Json(facelist);
        }
        #endregion
        public ActionResult adminjurisdiction(int? page, string location = null, string Sno = null)//无绑定酒店人脸机
        {
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                var userList = db.Queryable<DeviceManage>().ToList();
                //var groups = from p in db.DeviceManage group p by p.faceAddress;
                ViewData["groups"] = SqlOperationsData.facelocation();
                int pageNumber = page ?? 1;

                //每页显示多少条  
                int pageSize = 8;

                //根据ID升序排序  
                userList = userList.OrderByDescending(x => x.Status).ToList();

                userList = userList.Where(x => x.HotelCode == "").ToList();
                if (location != null && location != "")
                {
                    ViewData["location"] = location;
                    userList = userList.Where(x => x.faceAddress == location).ToList();
                }
                if (Sno != null && Sno != "")
                {
                    ViewData["Snos"] = Sno;
                    userList = userList.Where(x => x.SerialNo.Contains(location)).ToList();
                }
                IPagedList<DeviceManage> userPagedList = userList.ToPagedList(pageNumber, pageSize);
                //将分页处理后的列表传给View 
                return View(userPagedList);
            }
        }
        public ActionResult Bing(string StrNo)//绑定酒店操作
        {
            Session["StrNo"] = StrNo;
            return View();
        }
        public ActionResult officialHotel(int hotelId)//根据酒店id有人脸机的房间下拉框
        {
            List<Result> relist = null;
            Hotels hotel = new Hotels();

            hotel = SqlSugarBase.authoriydb.Queryable<Hotels>().First(x => x.Id == hotelId);
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                var dm = db.Queryable<DeviceManage>().Where(x => x.RoomId != null).Select(x => x.RoomId).ToList();
                GetRoomInterface.test te = new GetRoomInterface.test();
                if (hotel != null)
                {
                    te = new GetRoomInterface.test
                    {
                        code = hotel.Code.ToString(),
                        creatDate = hotel.CreateTime.ToString("yyyy-MM-dd")
                    };
                }

                var geiRoomShow = GetRoomInterface.Roomport(te);
                if (geiRoomShow.IsSuccess == true)
                {
                    //酒店对应的所有房间
                    relist = geiRoomShow.Result;
                    //relist = relist./*Where(s => s.RoomStatusID == 16).*/Where(j => dm.IndexOf(j.ID) < 0).ToList();
                }
                string[] arrlist = new string[relist.Count];
                for (int i = 0; i < relist.Count; i++)
                {
                    arrlist[i] = relist[i].HotelID;

                }
                var rljilistm = db.Queryable<DeviceManage>().Where(x => arrlist.Contains(x.HotelCode)).ToList();
                var tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().ToList();
                var rljfsis = from s in tbl_room_basic_info
                              join d in rljilistm on s.ROOM_OLD_ID equals d.RoomId
                              select new roominfo
                              {
                                  Facelid = d.Facelid,
                                  SerialNo = d.SerialNo,
                                  CreatedDate = d.CreatedDate,
                                  HotelCode = d.HotelCode,
                                  RoomId = d.RoomId,
                                  Factory = d.Factory,
                                  Status = d.Status,
                                  bindingDate = d.bindingDate,
                                  bindingStatus = d.bindingStatus,
                                  faceIp = d.faceIp,
                                  faceAddress = d.faceAddress,
                                  maintainStatus = d.maintainStatus,
                                  ROOM_NUMBER = s.ROOM_NUMBER
                              };
       
                return Json(rljfsis);
                //return Json(rljilistm);

            }
        }
       
        public ActionResult RoomIdbyRoom(int Roomid, int ApkName)
        {
            List<Result> relist = null;
            Hotels hotel = new Hotels();

            if (ApkName != 0)
            {
                hotel = SqlSugarBase.authoriydb.Queryable<Hotels>().First(x => x.Id == ApkName);
            }
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                var dm = db.Queryable<DeviceManage>().Where(x => x.RoomId != null).Select(x => x.RoomId).ToList();
                GetRoomInterface.test te = new GetRoomInterface.test();
                if (hotel != null)
                {
                    te = new GetRoomInterface.test
                    {
                        code = hotel.Code.ToString(),
                        creatDate = hotel.CreateTime.ToString("yyyy-MM-dd")
                    };
                }

                var geiRoomShow = GetRoomInterface.Roomport(te);
                if (geiRoomShow.IsSuccess == true)
                {
                    relist = geiRoomShow.Result;
                    relist = relist.Where(j => dm.IndexOf(j.ID) >= 0).ToList();
                }
                string[] arrlist = new string[relist.Count];
                for (int i = 0; i < relist.Count; i++)
                {
                    arrlist[i] = relist[i].HotelID;

                }
                var rljilistm = db.Queryable<DeviceManage>().Where(x => arrlist.Contains(x.HotelCode)).ToList();
                if (Roomid != 0)
                {
                    rljilistm = rljilistm.Where(x => x.RoomId == Roomid).ToList();
                }
                var tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().ToList();
                //var rljilistm = db.Queryable<DeviceManage>().Where(x => arrlist.Contains(x.HotelCode)).ToList();
                var rljfsis = from s in tbl_room_basic_info
                              join d in rljilistm on s.ROOM_OLD_ID equals d.RoomId
                              select new roominfo
                              {
                                  Facelid = d.Facelid,
                                  SerialNo = d.SerialNo,
                                  CreatedDate = d.CreatedDate,
                                  HotelCode = d.HotelCode,
                                  RoomId = d.RoomId,
                                  Factory = d.Factory,
                                  Status = d.Status,
                                  bindingDate = d.bindingDate,
                                  bindingStatus = d.bindingStatus,
                                  faceIp = d.faceIp,
                                  faceAddress = d.faceAddress,
                                  maintainStatus = d.maintainStatus,
                                  ROOM_NUMBER = s.ROOM_NUMBER
                              };
                //Dictionary<int, roominfo> _testDic = new Dictionary<int, roominfo>();
                //roominfo infos = new roominfo();
                //for (int i = 0; i < rljilistm.Count; i++)
                //{
                //    if (_testDic.Keys[i] == rljilistm[i].RoomId)
                //    {

                //    }
                //}
                return Json(rljfsis);
                //return Json(rljilistm);

            }
        }

        public ActionResult RoomIdbybrandid(int brandid, int ApkName)
        {
            string brandname = "";
            if (brandid == 2)
            {
                brandname = "实义德";
            }
            else
            {
                brandname = "移海";
            }
            List<Result> relist = null;
            Hotels hotel = new Hotels();


            if (ApkName != 0)
            {
                hotel = SqlSugarBase.authoriydb.Queryable<Hotels>().First(x => x.Id == ApkName);
            }
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                var dm = db.Queryable<DeviceManage>().Where(x => x.RoomId != null).Select(x => x.RoomId).ToList();
                GetRoomInterface.test te = new GetRoomInterface.test();
                if (hotel == null)
                {
                    te = new GetRoomInterface.test
                    {
                        code = hotel.Code.ToString(),
                        creatDate = hotel.CreateTime.ToString("yyyy-MM-dd")
                    };
                }

                var geiRoomShow = GetRoomInterface.Roomport(te);
                if (geiRoomShow.IsSuccess == true)
                {
                    relist = geiRoomShow.Result;
                    relist = relist.Where(j => dm.IndexOf(j.ID) >= 0).ToList();
                }
                string[] arrlist = new string[relist.Count];
                for (int i = 0; i < relist.Count; i++)
                {
                    arrlist[i] = relist[i].HotelID;

                }
                var rljilistm = db.Queryable<DeviceManage>().Where(x => arrlist.Contains(x.HotelCode)).ToList();
                if (brandid != 0)
                {
                    rljilistm = rljilistm.Where(x => x.Factory == brandname).ToList();
                }
                var tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().ToList();
                //var rljilistm = db.Queryable<DeviceManage>().Where(x => arrlist.Contains(x.HotelCode)).ToList();
                var rljfsis = from s in tbl_room_basic_info
                              join d in rljilistm on s.ROOM_OLD_ID equals d.RoomId
                              select new roominfo
                              {
                                  Facelid = d.Facelid,
                                  SerialNo = d.SerialNo,
                                  CreatedDate = d.CreatedDate,
                                  HotelCode = d.HotelCode,
                                  RoomId = d.RoomId,
                                  Factory = d.Factory,
                                  Status = d.Status,
                                  bindingDate = d.bindingDate,
                                  bindingStatus = d.bindingStatus,
                                  faceIp = d.faceIp,
                                  faceAddress = d.faceAddress,
                                  maintainStatus = d.maintainStatus,
                                  ROOM_NUMBER = s.ROOM_NUMBER
                              };
                //Dictionary<int, roominfo> _testDic = new Dictionary<int, roominfo>();
                //roominfo infos = new roominfo();
                //for (int i = 0; i < rljilistm.Count; i++)
                //{
                //    if (_testDic.Keys[i] == rljilistm[i].RoomId)
                //    {

                //    }
                //}
                return Json(rljfsis);

                //return Json(rljilistm);
            }
        }
        public ActionResult RoomIdbysn(string sn, int ApkName)
        {

            List<Result> relist = null;
            Hotels hotel = new Hotels();

            if (ApkName != 0)
            {
                hotel = SqlSugarBase.authoriydb.Queryable<Hotels>().First(x => x.Id == ApkName);
            }
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                var dm = db.Queryable<DeviceManage>().Where(x => x.RoomId != null).Select(x => x.RoomId).ToList();
                GetRoomInterface.test te = new GetRoomInterface.test();
                if (hotel != null)
                {
                    te = new GetRoomInterface.test
                    {
                        code = hotel.Code.ToString(),
                        creatDate = hotel.CreateTime.ToString("yyyy-MM-dd")
                    };
                }

                var geiRoomShow = GetRoomInterface.Roomport(te);
                if (geiRoomShow.IsSuccess == true)
                {
                    relist = geiRoomShow.Result;
                    relist = relist.Where(j => dm.IndexOf(j.ID) >= 0).ToList();
                }
                string[] arrlist = new string[relist.Count];
                for (int i = 0; i < relist.Count; i++)
                {
                    arrlist[i] = relist[i].HotelID;

                }
                var rljilistm = db.Queryable<DeviceManage>().Where(x => arrlist.Contains(x.HotelCode)).ToList();
                if (!string.IsNullOrEmpty(sn))
                {
                    rljilistm = rljilistm.Where(x => x.SerialNo.Contains(sn)).ToList();
                }
                var tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().ToList();
                //var rljilistm = db.Queryable<DeviceManage>().Where(x => arrlist.Contains(x.HotelCode)).ToList();
                var rljfsis = from s in tbl_room_basic_info
                              join d in rljilistm on s.ROOM_OLD_ID equals d.RoomId
                              select new roominfo
                              {
                                  Facelid = d.Facelid,
                                  SerialNo = d.SerialNo,
                                  CreatedDate = d.CreatedDate,
                                  HotelCode = d.HotelCode,
                                  RoomId = d.RoomId,
                                  Factory = d.Factory,
                                  Status = d.Status,
                                  bindingDate = d.bindingDate,
                                  bindingStatus = d.bindingStatus,
                                  faceIp = d.faceIp,
                                  faceAddress = d.faceAddress,
                                  maintainStatus = d.maintainStatus,
                                  ROOM_NUMBER = s.ROOM_NUMBER
                              };
                //Dictionary<int, roominfo> _testDic = new Dictionary<int, roominfo>();
                //roominfo infos = new roominfo();
                //for (int i = 0; i < rljilistm.Count; i++)
                //{
                //    if (_testDic.Keys[i] == rljilistm[i].RoomId)
                //    {

                //    }
                //}
                return Json(rljfsis);
                //return Json(rljilistm);
            }
        }
        public ActionResult officialHotels(int hotelId)//根据酒店id无人脸机房间下拉框
        {
            List<Result> relist = null;
            Hotels hotel = new Hotels();

            hotel = SqlSugarBase.authoriydb.Queryable<Hotels>().First(x => x.Id == hotelId);
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                var dm = db.Queryable<DeviceManage>().Where(x => x.RoomId != null).Select(x => x.RoomId).ToList();
                GetRoomInterface.test te = new GetRoomInterface.test();
                if (hotel != null)
                {
                    te = new GetRoomInterface.test
                    {
                        code = hotel.Code.ToString(),
                        creatDate = hotel.CreateTime.ToString("yyyy-MM-dd")
                    };
                }

                var geiRoomShow = GetRoomInterface.Roomport(te);
                if (geiRoomShow.IsSuccess == true)
                {
                    relist = geiRoomShow.Result;
                    //relist = relist.Where(j => dm.IndexOf(j.ID) >= 0).ToList();
                }
                string[] arrlist;
                if (relist == null)
                { arrlist = new string[0]; }
                else
                {
                    arrlist = new string[relist.Count];
                    for (int i = 0; i < relist.Count; i++)
                    {
                        arrlist[i] = relist[i].HotelID;

                    }
                }

                var tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().ToList();

                var rljilistm = db.Queryable<DeviceManage>().Where(x => arrlist.Contains(x.HotelCode)).ToList();
                var rljfsis = from s in tbl_room_basic_info
                              join d in rljilistm on s.ROOM_OLD_ID equals d.RoomId
                              select new roominfo
                              {
                                  Facelid =d.Facelid,
                                  SerialNo = d.SerialNo,
                                  CreatedDate = d.CreatedDate,
                                  HotelCode = d.HotelCode,
                                  RoomId = d.RoomId,
                                  Factory = d.Factory,
                                  Status = d.Status,
                                  bindingDate = d.bindingDate,
                                  bindingStatus = d.bindingStatus,
                                  faceIp = d.faceIp,
                                  faceAddress = d.faceAddress,
                                  maintainStatus = d.maintainStatus,
                                  ROOM_NUMBER=s.ROOM_NUMBER
                              };
                //Dictionary<int, roominfo> _testDic = new Dictionary<int, roominfo>();
                //roominfo infos = new roominfo();
                //for (int i = 0; i < rljilistm.Count; i++)
                //{
                //    if (_testDic.Keys[i] == rljilistm[i].RoomId)
                //    {

                             //    }
                             //}
                return Json(rljfsis);
            }
        }

        //public ActionResult bingHotel(string no)//绑定酒店
        //{
        //    Session["no"] = no;

        //    return View();
        //}
        /// <summary>   
        /// 接收类
        /// </summary>
        public class obje
        {
            public string hotel { get; set; }
            public int romm { get; set; }
            public string faceNo { get; set; }
        }
        public ActionResult Roomselect(int? page, string hotel = "", string room = "")
        {

            ViewData["he"] = SqlSugarBase.authoriydb.Queryable<Hotels>().ToList();

            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                if (hotel != "")
                {
                    Session["hoteloperation"] = hotel;
                }
                if (room != "")
                {
                    Session["roll"] = room;
                }
                var userList = db.Queryable<DeviceManage>().Where(it => it.HotelCode == hotel).ToList();
                userList = userList.Where(s => s.RoomId == null || s.RoomId ==0).ToList();
                //第几页  
                int pageNumber = page ?? 1;

                //每页显示多少条  
                int pageSize = 8;
                //根据ID升序排序  
                userList = userList.OrderByDescending(x => x.Status).ToList();

                //通过ToPagedList扩展方法进行分页  
                IPagedList<DeviceManage> userPagedList = userList.ToPagedList(pageNumber, pageSize);

                //将分页处理后的列表传给View 
                return View(userPagedList);
            }

        }
        public ActionResult bingdingRoomoperate(obje ob)
        {
            ReturnResult result = new ReturnResult();
            if (SqlOperationsData.reviseRommFace(ob.hotel, ob.romm, ob.faceNo) != 0)
            {
                result.Status = 200;
                result.Message = "添加成功";
            }
            else
            {
                result.Status = 100;
                result.Message = "添加失败";
            }
            return Json(result);
        }

        public ActionResult faultmaintain(string id)//故障维修
        {
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                int did = int.Parse(id);
                var dst = db.Updateable<DeviceManage>().SetColumns(it => it.maintainStatus == 0).Where(it => it.Facelid == did).ExecuteCommand();
                return Json(dst);
            }
        }
        public ActionResult updateAkp()
        {
            ImgServerController imgServer = new ImgServerController();
            ViewData["Akplist"] = imgServer.GetFilesList("FW");
            return View();
        }
        public ActionResult updateAkps(int type = 1)
        {
            string FTP = "";
            if (type == 1)
            {
                FTP = "FW";
            }
            else if (type == 2)
            {
                FTP = "BkgPng";
            }
            else if (type == 3)
            {
                FTP = "Logo";
            }
            ImgServerController imgServer = new ImgServerController();
            ViewData["Akplists"] = imgServer.GetFilesList(FTP);
            return View();
        }
        public ActionResult updateBkgPngLogo(int type = 1)
        {
            string FTP = "";
            if (type == 1)
            {
                FTP = "FW";
            }
            else if (type == 2)
            {
                FTP = "BkgPng";
            }
            else if (type == 3)
            {
                FTP = "Logo";
            }
            ImgServerController imgServer = new ImgServerController();
            ViewData["Akplists"] = imgServer.GetFilesList(FTP);
            return View();
        }
        public ActionResult updateLogo(int type = 1)
        {
            string FTP = "";
            if (type == 1)
            {
                FTP = "FW";
            }
            else if (type == 2)
            {
                FTP = "BkgPng";
            }
            else if (type == 3)
            {
                FTP = "Logo";
            }
            ImgServerController imgServer = new ImgServerController();
            ViewData["Akplists"] = imgServer.GetFilesList(FTP);
            return View();
        }
        public ActionResult TestFaceLogsAll()
        {
            return View();
        }

        public ActionResult InquireFaceLogAll(Condition data)
        {
            string strSql = "";

            strSql += ("select * ");

            strSql += (" from facedevicerxtxinfo  where 1=1 ");

            //人脸机序列号
            if (data.FaceName != "" && data.FaceName != null)
            {
                strSql += "  and sn  like  '%" + data.FaceName + "%' ";
            }

            //时间范围
            if (
                (data.RoomMinDate != null && data.RoomMinDate.ToString() != "0001/1/1 0:00:00")
                && (data.RoomMaxDate != null && data.RoomMinDate.ToString() != "0001/1/1 0:00:00")
                   )
            {
                strSql += " and datatime>='"
                    + data.RoomMinDate.ToString("yyyy/MM/dd")
                    + " 00:00:00' and datatime<'"
                    + data.RoomMaxDate.ToString("yyyy/MM/dd") + " 23:59:59'";
            }

            string sqlnumber = strSql;
            strSql += "  ORDER BY `datatime` DESC  LIMIT " + (data.dataMin) + ",16;";
            //分页后
            var countNum = new DALHelperCustom<Face.Domain.Application.FaceAll.facedevicerxtxinfo>("facedevicerxtxinfo").SqlQueryGetList(strSql.ToString());

            //一共多少页
            var countNumCount = new DALHelperCustom<Face.Domain.Application.FaceAll.facedevicerxtxinfo>("facedevicerxtxinfo").SqlQueryGetList(sqlnumber.ToString());
            if (countNumCount != null && countNumCount.Count != 0)
            {
                ViewBag.count = countNumCount.Count;
                ViewBag.allpage = (countNumCount.Count + 16 - 1) / 16;
            }
            else
            {
                countNum = null;
            }
            return PartialView("InquireFaceLogAll", countNum);
        }
   
    
    }
    public class tbl_room_basic_info
    {
        public int ROOM_OLD_ID { get; set; }
        public string ROOM_NUMBER { get; set; }
        public int IsDel { get; set; }
        public int isPublicArea { get; set; }
        public string AssociatedPublicArea { get; set; }
        public string HOTEL_OLD_ID { get; set; }
    }

    //public class setpassword
    //{
    //    public int id { get; set; }
    //    public string sn { get; set; }

    //    public string password  { get; set; }
    //    public DateTime creationtime { get; set; }
    //}






    public class roominfo: DeviceManage
    {
        public string ROOM_NUMBER { get; set; }
    }

}