Web_Faces_Prod/Face.Web/Areas/App/Controllers/PublicAreaSettingController.cs

using Face.Domain.Entities;
using Face.Web.Areas.App.Models;
using Microsoft.Ajax.Utilities;
using SqlSugar;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Helpers;
using System.Web.Mvc;
using static Face.Web.Areas.App.Models.Roominfo;

namespace Face.Web.Areas.App.Controllers
{
    public class PublicAreaSettingController : Controller
    {
        // GET: App/PublicAreaSetting
        public ActionResult AreaSetting()
        {
            ViewData["Hotelsp"] = SqlSugarBase.authoriydb.Queryable<Hotels>().ToList();
            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>().Where(x => x.IsDel == 0 && arrlist.Contains(x.HOTEL_OLD_ID)).ToList();

                return Json(tbl_room_basic_info);
            }
        }
        public ActionResult getPublicArea(int RoomId)
        {
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                //DeviceManage rljilistm = db.Queryable<DeviceManage>().First(x => x.RoomId == RoomId);
                tbl_room_basic_info tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().First(x=>x.ROOM_OLD_ID== RoomId);
                //rljilistm.isPublicArea = 1;
                tbl_room_basic_info.isPublicArea = 1;
                //int upint = db.Updateable(rljilistm).Where(x => x.RoomId == RoomId).ExecuteCommand();
                int uproom = SqlSugarBase.Gesmartblv_rcu_db().Updateable(tbl_room_basic_info).Where(x => x.ROOM_OLD_ID == RoomId).ExecuteCommand();
                bool folge = false;
                if (uproom > 0)
                {
                    folge = true;
                    return Json(folge);
                }
                else
                {
                    return Json(folge);
                }
                   
            }

        }

        public ActionResult CanclPublicArea(int RoomId)
        {
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                //DeviceManage rljilistm = db.Queryable<DeviceManage>().First(x => x.RoomId == RoomId);
                tbl_room_basic_info tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().First(x => x.ROOM_OLD_ID == RoomId);
                //rljilistm.isPublicArea = 0;
                tbl_room_basic_info.isPublicArea = 0;
                //int upint = db.Updateable(rljilistm).Where(x => x.RoomId == RoomId).ExecuteCommand();
                int uproom = SqlSugarBase.Gesmartblv_rcu_db().Updateable(tbl_room_basic_info).Where(x => x.ROOM_OLD_ID == RoomId).ExecuteCommand();
                bool folge = false;
                if (uproom > 0)
                {
                    folge = true;
                    return Json(folge);
                }
                else
                {
                    return Json(folge);
                }
            }
        }
        public ActionResult RelevancePublicArea()
        {
            ViewData["Hotelsp"] = SqlSugarBase.authoriydb.Queryable<Hotels>().ToList();
            return View();
        }
        public ActionResult getHotel(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>().Where(x => x.IsDel == 0 && arrlist.Contains(x.HOTEL_OLD_ID)).ToList();
                var isok = tbl_room_basic_info.Where(x => x.isPublicArea == 1);
                var isno = tbl_room_basic_info.Where(x => x.isPublicArea != 1);
                var json = new
                {
                    isokPublicArea = isok,
                    isnoPublicArea = isno
                };
                return Json(json);
                //if (rljilistm.Count() > 0)
                //{
                //    var isok = from s in tbl_room_basic_info
                //               join d in rljilistm on s.ROOM_OLD_ID equals d.RoomId
                //               where d.isPublicArea == 1
                //               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,
                //                   isPublicArea = d.isPublicArea
                //               };
                //    var isno = from s in tbl_room_basic_info
                //               join d in rljilistm on s.ROOM_OLD_ID equals d.RoomId
                //               where d.isPublicArea != 1
                //               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,
                //                   isPublicArea = d.isPublicArea
                //               };
                //    var json = new
                //    {
                //        isokPublicArea = isok,
                //        isnoPublicArea = isno
                //    };
                //    return Json(json);
                //}
                //else
                //{
                //    var isok = tbl_room_basic_info.Where(x => x.isPublicArea == 1);
                //    var isno = tbl_room_basic_info.Where(x => x.isPublicArea != 1);
                //    var json = new
                //    {
                //        isokPublicArea = isok,
                //        isnoPublicArea = isno
                //    };
                //    return Json(json);
                //}
            }
        }
        public ActionResult setHotel(int RoomId, string RoomidList)
        {
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                //DeviceManage rljilistm = db.Queryable<DeviceManage>().First(x => x.RoomId == RoomId);
                tbl_room_basic_info tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().First(x => x.ROOM_OLD_ID == RoomId);
                //rljilistm.AssociatedPublicArea = RoomidList;
                tbl_room_basic_info.AssociatedPublicArea = RoomidList;
                //int upint = db.Updateable(rljilistm).Where(x => x.RoomId == RoomId).ExecuteCommand();
                int uproom = SqlSugarBase.Gesmartblv_rcu_db().Updateable(tbl_room_basic_info).Where(x => x.ROOM_OLD_ID == RoomId).ExecuteCommand();
                bool folge = false;
                if (uproom > 0)
                {
                    folge = true;
                    return Json(folge);
                }
                else
                {
                    return Json(folge);
                }
            }
            //return Json("ok");
        }

        public ActionResult quxHotel(int RoomId)
        {
            using (SqlSugarClient db = SqlSugarBase.GesmartDb())
            {
                //DeviceManage rljilistm = db.Queryable<DeviceManage>().First(x => x.RoomId == RoomId);
                tbl_room_basic_info tbl_room_basic_info = SqlSugarBase.Gesmartblv_rcu_db().Queryable<tbl_room_basic_info>().First(x => x.ROOM_OLD_ID == RoomId);
                //rljilistm.AssociatedPublicArea = RoomidList;
                tbl_room_basic_info.AssociatedPublicArea = "";
                //int upint = db.Updateable(rljilistm).Where(x => x.RoomId == RoomId).ExecuteCommand();
                int uproom = SqlSugarBase.Gesmartblv_rcu_db().Updateable(tbl_room_basic_info).Where(x => x.ROOM_OLD_ID == RoomId).ExecuteCommand();
                bool folge = false;
                if (uproom > 0)
                {
                    folge = true;
                    return Json(folge);
                }
                else
                {
                    return Json(folge);
                }

            }
        }
    }
}