1059 lines
47 KiB
C#
1059 lines
47 KiB
C#
|
using Face.Domain.Entities;
|
|||
|
|
using Face.Web.Areas.App.Models;
|
|||
|
|
using Newtonsoft.Json;
|
|||
|
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Runtime.Remoting.Messaging;
|
|||
|
|
using System.Web;
|
|||
|
|
using System.Web.Mvc;
|
|||
|
|
using static Face.Web.Areas.App.Controllers.GeneratePasswordController;
|
|||
|
|
|
|||
|
|
namespace Face.Web.Areas.App.Controllers
|
|||
|
|
{
|
|||
|
|
public class GroupController : Controller
|
|||
|
|
{
|
|||
|
|
// GET: App/Group
|
|||
|
|
/// <summary>
|
|||
|
|
/// 分配人脸机key api
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="jsondata"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
|
|||
|
|
[HttpPost]
|
|||
|
|
public ActionResult SetPassword(string jsondata)
|
|||
|
|
{
|
|||
|
|
//var host = request.Host.Value; // 获取域名
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
//var requestPath = HttpContext.Request.Path;
|
|||
|
|
var request = HttpContext.Request;
|
|||
|
|
string apiUrl = request.Url.ToString();
|
|||
|
|
Uri uri = new Uri(apiUrl);
|
|||
|
|
string domain = uri.GetLeftPart(UriPartial.Authority);
|
|||
|
|
|
|||
|
|
Alldata alldata = JsonConvert.DeserializeObject<Alldata>(jsondata);
|
|||
|
|
Returnmessage rm = new Returnmessage();
|
|||
|
|
string ip = AesEncryptionExample.Getip();
|
|||
|
|
tbl_face_white_list tfwl = SqlSugarBase.GesmartDb().Queryable<tbl_face_white_list>().First(x => x.ip == ip);
|
|||
|
|
tbl_face_key_assign_log tfksls = new tbl_face_key_assign_log();
|
|||
|
|
//ip地址在白名单里面
|
|||
|
|
if (tfwl != null)
|
|||
|
|
{
|
|||
|
|
//ip地址在白名单里面并且有效
|
|||
|
|
if (tfwl.Is_Avalable == 1)
|
|||
|
|
{
|
|||
|
|
rm = inspectdomain.returnmessage(domain, ip, alldata);
|
|||
|
|
return Json(rm);
|
|||
|
|
}
|
|||
|
|
//ip地址在白名单里面但是无效
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
string json = JsonConvert.SerializeObject(rm, Formatting.Indented);
|
|||
|
|
tfksls.AppKey = alldata.AppKey;
|
|||
|
|
tfksls.IP = ip;
|
|||
|
|
tfksls.SN = alldata.Content.SN;
|
|||
|
|
tfksls.ReqType = alldata.Content.ReqType;
|
|||
|
|
tfksls.TimeStamp = alldata.Timestamp;
|
|||
|
|
tfksls.MsgID = alldata.MsgID;
|
|||
|
|
tfksls.CreateDateTime = DateTime.Now;
|
|||
|
|
tfksls.Key = "";
|
|||
|
|
|
|||
|
|
tfksls.Return = json;
|
|||
|
|
tfksls.Result = "false";
|
|||
|
|
tfksls.Remark = "分配key api调用失败";
|
|||
|
|
tfksls.RequstCnt = 1;
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfksls).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return Json(rm);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return Json(rm);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//IP地址不在白名单里面
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm = inspectdomain.returnmessage(domain, ip, alldata);
|
|||
|
|
return Json(rm);
|
|||
|
|
|
|||
|
|
//string json = JsonConvert.SerializeObject(rm, Formatting.Indented);
|
|||
|
|
//tfksls.AppKey = alldata.AppKey;
|
|||
|
|
//tfksls.IP = ip;
|
|||
|
|
//tfksls.SN = alldata.Content.SN;
|
|||
|
|
//tfksls.ReqType = alldata.Content.ReqType;
|
|||
|
|
//tfksls.TimeStamp = alldata.Timestamp;
|
|||
|
|
//tfksls.MsgID = alldata.MsgID;
|
|||
|
|
//tfksls.CreateDateTime = DateTime.Now;
|
|||
|
|
//tfksls.Key = "";
|
|||
|
|
|
|||
|
|
//tfksls.Return = json;
|
|||
|
|
//tfksls.Result = "false";
|
|||
|
|
//tfksls.Remark = "分配key api调用失败";
|
|||
|
|
//tfksls.RequstCnt = 1;
|
|||
|
|
//int count = SqlSugarBase.GesmartDb().Insertable(tfksls).ExecuteCommand();
|
|||
|
|
//if (count > 0)
|
|||
|
|
//{
|
|||
|
|
// return Json(rm);
|
|||
|
|
//}
|
|||
|
|
//else
|
|||
|
|
//{
|
|||
|
|
// return Json(rm);
|
|||
|
|
//}
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
Returnmessage rm = new Returnmessage();
|
|||
|
|
rm.MsgID = "";
|
|||
|
|
rm.ErrCode = "3002";
|
|||
|
|
rm.ErrMsg = ex.ToString();
|
|||
|
|
rm.Contents.SN = "";
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return Json(rm);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 小程序查看人脸机key api
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="jsondata"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
[HttpPost]
|
|||
|
|
public ActionResult GetPasswordKey(string jsondata)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
Getdata gd = JsonConvert.DeserializeObject<Getdata>(jsondata);
|
|||
|
|
var requestPath = HttpContext.Request.Path;
|
|||
|
|
var request = HttpContext.Request;
|
|||
|
|
|
|||
|
|
string apiUrl = request.Url.ToString();
|
|||
|
|
Uri uri = new Uri(apiUrl);
|
|||
|
|
|
|||
|
|
string domain = uri.GetLeftPart(UriPartial.Authority);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
string ip = AesEncryptionExample.Getip();
|
|||
|
|
tbl_face_white_list tfwl = SqlSugarBase.GesmartDb().Queryable<tbl_face_white_list>().First(x => x.ip == ip);
|
|||
|
|
//List<Domain.Entities.DeviceManage> dm = SqlSugarBase.GesmartDb().Queryable<Domain.Entities.DeviceManage>().Where(x => x.HotelCode == gd.Content.HotelID).ToList();
|
|||
|
|
returnminfo ri = new returnminfo();
|
|||
|
|
//Domain.Entities.DeviceManage dms = dm.Find(x => x.RoomId == gd.Content.RoomID);
|
|||
|
|
tbl_face_key_request_log tfkrl = new tbl_face_key_request_log();
|
|||
|
|
//ip地址在白名单里面
|
|||
|
|
if (tfwl != null)
|
|||
|
|
{
|
|||
|
|
//ip地址在白名单里面并且有效
|
|||
|
|
if (tfwl.Is_Avalable == 1)
|
|||
|
|
{
|
|||
|
|
ri = inspectdomain.setreturnmessage(domain, ip, gd);
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
//ip地址在白名单里面但是无有效
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = "";
|
|||
|
|
tfkrl.DeviceBrand = "";
|
|||
|
|
tfkrl.Key = "";
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
tfkrl.Result = "false";
|
|||
|
|
tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//ip地址没有在白名单里面
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri = inspectdomain.setreturnmessage(domain, ip, gd);
|
|||
|
|
return Json(ri);
|
|||
|
|
//tfkrl.AppKey = gd.AppKey;
|
|||
|
|
//tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
//tfkrl.IP = ip;
|
|||
|
|
//tfkrl.MsgID = gd.MsgID;
|
|||
|
|
//tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
//tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
//tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
//tfkrl.DeviceSN = "";
|
|||
|
|
//tfkrl.DeviceBrand = "";
|
|||
|
|
//tfkrl.Key = "";
|
|||
|
|
//tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
//tfkrl.Result = "false";
|
|||
|
|
//tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
//tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
//tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
//int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
//if (count > 0)
|
|||
|
|
//{
|
|||
|
|
// return Json(ri);
|
|||
|
|
//}
|
|||
|
|
//else
|
|||
|
|
//{
|
|||
|
|
// return Json(ri);
|
|||
|
|
//}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
returnminfo ri = new returnminfo();
|
|||
|
|
ri.MsgID = "";
|
|||
|
|
ri.ErrCode = "3002";
|
|||
|
|
ri.ErrMsg = ex.ToString();
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = "";
|
|||
|
|
ri.Contents.RoomID = 0;
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
[HttpPost]
|
|||
|
|
public ActionResult Gethotelandroom(string jsondata)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
Getdata gd = JsonConvert.DeserializeObject<Getdata>(jsondata);
|
|||
|
|
var requestPath = HttpContext.Request.Path;
|
|||
|
|
var request = HttpContext.Request;
|
|||
|
|
|
|||
|
|
string apiUrl = request.Url.ToString();
|
|||
|
|
Uri uri = new Uri(apiUrl);
|
|||
|
|
|
|||
|
|
string domain = uri.GetLeftPart(UriPartial.Authority);
|
|||
|
|
string ip = AesEncryptionExample.Getip();
|
|||
|
|
tbl_face_white_list tfwl = SqlSugarBase.GesmartDb().Queryable<tbl_face_white_list>().First(x => x.ip == ip);
|
|||
|
|
//List<Domain.Entities.DeviceManage> dm = SqlSugarBase.GesmartDb().Queryable<Domain.Entities.DeviceManage>().Where(x => x.HotelCode == gd.Content.HotelID).ToList();
|
|||
|
|
returnminfo ri = new returnminfo();
|
|||
|
|
//Domain.Entities.DeviceManage dms = dm.Find(x => x.RoomId == gd.Content.RoomID);
|
|||
|
|
tbl_face_key_request_log tfkrl = new tbl_face_key_request_log();
|
|||
|
|
//ip地址在白名单里面
|
|||
|
|
if (gd.AppKey=="BLW888")
|
|||
|
|
{
|
|||
|
|
//string s= Guid.NewGuid().ToString();
|
|||
|
|
|
|||
|
|
if (tfwl != null)
|
|||
|
|
{
|
|||
|
|
//ip地址在白名单里面并且有效
|
|||
|
|
if (tfwl.Is_Avalable == 1)
|
|||
|
|
{
|
|||
|
|
ri = inspectdomain.Gethotelandroominfo(domain, ip, gd);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
//ip地址在白名单里面但是无有效
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = "";
|
|||
|
|
tfkrl.DeviceBrand = "";
|
|||
|
|
tfkrl.Key = "";
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
tfkrl.Result = "false";
|
|||
|
|
tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//ip地址没有在白名单里面
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri = inspectdomain.Gethotelandroominfo(domain, ip, gd);
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "4000";
|
|||
|
|
ri.ErrMsg = "AppKey is wrong";
|
|||
|
|
ri.Contents.DeviceBrand ="";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN ="";
|
|||
|
|
ri.Contents.HotelID = "";
|
|||
|
|
ri.Contents.RoomID = 0;
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
returnminfo ri = new returnminfo();
|
|||
|
|
ri.MsgID = "";
|
|||
|
|
ri.ErrCode = "3002";
|
|||
|
|
ri.ErrMsg = ex.ToString();
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = "";
|
|||
|
|
ri.Contents.RoomID = 0;
|
|||
|
|
return Json(ri);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
public static class inspectdomain
|
|||
|
|
{
|
|||
|
|
public static Returnmessage returnmessage(string domainname, string ip, Alldata alldata)
|
|||
|
|
{
|
|||
|
|
Returnmessage rm = new Returnmessage();
|
|||
|
|
//tbl_face_white_list tblFWList = new tbl_face_white_list();
|
|||
|
|
|
|||
|
|
tbl_face_key tfk = SqlSugarBase.GesmartDb().Queryable<tbl_face_key>().First(x => x.SN == alldata.Content.SN);
|
|||
|
|
List<tbl_face_key_assign_log> tfksl = SqlSugarBase.GesmartDb().Queryable<tbl_face_key_assign_log>().Where(x => x.SN == alldata.Content.SN).ToList();
|
|||
|
|
tbl_face_key tfks = new tbl_face_key();
|
|||
|
|
tbl_face_key_assign_log tfksls = new tbl_face_key_assign_log();
|
|||
|
|
//http://localhost:55151本地测试使用
|
|||
|
|
if (domainname == "http://face.blv-oa.com")
|
|||
|
|
{
|
|||
|
|
//数据库里面有这个sn信息
|
|||
|
|
if (tfk != null)
|
|||
|
|
{
|
|||
|
|
//如果已存在密钥则直接下发密钥
|
|||
|
|
if (alldata.Content.ReqType == 0)
|
|||
|
|
{
|
|||
|
|
// 数据有这个sn的数据并且有key值
|
|||
|
|
if (!string.IsNullOrEmpty(tfk.Key))
|
|||
|
|
{
|
|||
|
|
tfksls.AppKey = alldata.AppKey;
|
|||
|
|
tfksls.IP = ip;
|
|||
|
|
tfksls.SN = alldata.Content.SN;
|
|||
|
|
tfksls.ReqType = alldata.Content.ReqType;
|
|||
|
|
tfksls.TimeStamp = alldata.Timestamp;
|
|||
|
|
tfksls.MsgID = alldata.MsgID;
|
|||
|
|
tfksls.CreateDateTime = DateTime.Now;
|
|||
|
|
tfksls.Key = tfk.Key;
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "200";
|
|||
|
|
rm.ErrMsg = "ok";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = tfk.Key;
|
|||
|
|
string json = JsonConvert.SerializeObject(rm, Formatting.Indented);
|
|||
|
|
tfksls.Return = json;
|
|||
|
|
tfksls.Result = "true";
|
|||
|
|
tfksls.Remark = "分配key api调用成功";
|
|||
|
|
tfksls.RequstCnt = tfksl[tfksl.Count - 1].RequstCnt + 1;
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfksls).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "3004";
|
|||
|
|
rm.ErrMsg = "insert log database wrong";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//数据有这个sn的数据没有key值
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
string key = AesEncryptionExample.Randomnumber();
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "200";
|
|||
|
|
rm.ErrMsg = "ok";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = key;
|
|||
|
|
|
|||
|
|
|
|||
|
|
tfks.AppKey = alldata.AppKey;
|
|||
|
|
tfks.CreateDateTime = DateTime.Now;
|
|||
|
|
tfks.MsgID = alldata.MsgID;
|
|||
|
|
tfks.TimeStamp = alldata.Timestamp;
|
|||
|
|
tfks.SN = alldata.Content.SN;
|
|||
|
|
tfks.Key = key;
|
|||
|
|
tfks.ReqType = alldata.Content.ReqType;
|
|||
|
|
tfks.RequstCnt = tfk.RequstCnt + 1;
|
|||
|
|
string json = JsonConvert.SerializeObject(rm, Formatting.Indented);
|
|||
|
|
tfks.Return = json;
|
|||
|
|
tfks.AppKey = alldata.AppKey;
|
|||
|
|
tfks.Result = "true";
|
|||
|
|
tfks.Remark = "分配key api调用成功";
|
|||
|
|
tfks.Id = tfk.Id;
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
tfksls.AppKey = alldata.AppKey;
|
|||
|
|
tfksls.IP = ip;
|
|||
|
|
tfksls.SN = alldata.Content.SN;
|
|||
|
|
tfksls.ReqType = alldata.Content.ReqType;
|
|||
|
|
tfksls.TimeStamp = alldata.Timestamp;
|
|||
|
|
tfksls.MsgID = alldata.MsgID;
|
|||
|
|
tfksls.CreateDateTime = DateTime.Now;
|
|||
|
|
tfksls.Key = key;
|
|||
|
|
|
|||
|
|
tfksls.Return = json;
|
|||
|
|
tfksls.Result = "true";
|
|||
|
|
tfksls.Remark = "分配key api调用成功";
|
|||
|
|
tfksls.RequstCnt = tfksl[tfksl.Count - 1].RequstCnt + 1;
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfksls).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
int counts = SqlSugarBase.GesmartDb().Updateable(tfks).Where(x => x.Id == tfks.Id).ExecuteCommand();
|
|||
|
|
if (counts > 0)
|
|||
|
|
{
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "3005";
|
|||
|
|
rm.ErrMsg = "Updatea database wrong";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "3004";
|
|||
|
|
rm.ErrMsg = "insert log database wrong";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//无论是否存在密钥都重新生成新的密钥
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
string key = AesEncryptionExample.Randomnumber();
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "200";
|
|||
|
|
rm.ErrMsg = "ok";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = key;
|
|||
|
|
|
|||
|
|
|
|||
|
|
string json = JsonConvert.SerializeObject(rm, Formatting.Indented);
|
|||
|
|
tfks.AppKey = alldata.AppKey;
|
|||
|
|
tfks.CreateDateTime = DateTime.Now;
|
|||
|
|
tfks.MsgID = alldata.MsgID;
|
|||
|
|
tfks.TimeStamp = alldata.Timestamp;
|
|||
|
|
tfks.SN = alldata.Content.SN;
|
|||
|
|
tfks.Key = key;
|
|||
|
|
tfks.ReqType = alldata.Content.ReqType;
|
|||
|
|
tfks.RequstCnt = tfk.RequstCnt + 1;
|
|||
|
|
tfks.Return = json;
|
|||
|
|
tfks.AppKey = alldata.AppKey;
|
|||
|
|
tfks.Result = "true";
|
|||
|
|
tfks.Remark = "分配key api调用成功";
|
|||
|
|
tfks.Id = tfk.Id;
|
|||
|
|
|
|||
|
|
tfksls.AppKey = alldata.AppKey;
|
|||
|
|
tfksls.IP = ip;
|
|||
|
|
tfksls.SN = alldata.Content.SN;
|
|||
|
|
tfksls.ReqType = alldata.Content.ReqType;
|
|||
|
|
tfksls.TimeStamp = alldata.Timestamp;
|
|||
|
|
tfksls.MsgID = alldata.MsgID;
|
|||
|
|
tfksls.CreateDateTime = DateTime.Now;
|
|||
|
|
tfksls.Key = key;
|
|||
|
|
|
|||
|
|
tfksls.Return = json;
|
|||
|
|
tfksls.Result = "true";
|
|||
|
|
tfksls.Remark = "分配key api调用成功";
|
|||
|
|
tfksls.RequstCnt = tfksl[tfksl.Count - 1].RequstCnt + 1;
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfksls).ExecuteCommand();
|
|||
|
|
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
int counts = SqlSugarBase.GesmartDb().Updateable(tfks).Where(x => x.Id == tfks.Id).ExecuteCommand();
|
|||
|
|
if (counts > 0)
|
|||
|
|
{
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "3005";
|
|||
|
|
rm.ErrMsg = "Updatea database wrong";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "3004";
|
|||
|
|
rm.ErrMsg = "insert log database wrong";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
string key = AesEncryptionExample.Randomnumber();
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "200";
|
|||
|
|
rm.ErrMsg = "ok";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = key;
|
|||
|
|
string json = JsonConvert.SerializeObject(rm, Formatting.Indented);
|
|||
|
|
|
|||
|
|
tfks.AppKey = alldata.AppKey;
|
|||
|
|
tfks.CreateDateTime = DateTime.Now;
|
|||
|
|
tfks.MsgID = alldata.MsgID;
|
|||
|
|
tfks.TimeStamp = alldata.Timestamp;
|
|||
|
|
tfks.SN = alldata.Content.SN;
|
|||
|
|
tfks.Key = key;
|
|||
|
|
tfks.ReqType = alldata.Content.ReqType;
|
|||
|
|
tfks.RequstCnt = tfks.RequstCnt + 1;
|
|||
|
|
|
|||
|
|
//tfksls.Return = json;
|
|||
|
|
tfks.Return = json;
|
|||
|
|
tfks.AppKey = alldata.AppKey;
|
|||
|
|
tfks.Result = "true";
|
|||
|
|
tfks.Remark = "分配key api调用成功";
|
|||
|
|
tfksls.AppKey = alldata.AppKey;
|
|||
|
|
tfksls.IP = ip;
|
|||
|
|
tfksls.SN = alldata.Content.SN;
|
|||
|
|
tfksls.ReqType = alldata.Content.ReqType;
|
|||
|
|
tfksls.TimeStamp = alldata.Timestamp;
|
|||
|
|
tfksls.MsgID = alldata.MsgID;
|
|||
|
|
tfksls.CreateDateTime = DateTime.Now;
|
|||
|
|
tfksls.Key = key;
|
|||
|
|
tfksls.Return = json;
|
|||
|
|
tfksls.Result = "true";
|
|||
|
|
tfksls.Remark = "分配key api调用成功";
|
|||
|
|
tfksls.RequstCnt = tfksls.RequstCnt + 1;
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfksls).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
int counts = SqlSugarBase.GesmartDb().Insertable(tfks).ExecuteCommand();
|
|||
|
|
if (counts > 0)
|
|||
|
|
{
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "3003";
|
|||
|
|
rm.ErrMsg = "insert database wrong";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "3004";
|
|||
|
|
rm.ErrMsg = "insert log database wrong";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//return rm;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
rm.MsgID = alldata.MsgID;
|
|||
|
|
rm.ErrCode = "3009";
|
|||
|
|
rm.ErrMsg = "Domain Name Error";
|
|||
|
|
rm.Contents.SN = alldata.Content.SN;
|
|||
|
|
rm.Contents.Key = "";
|
|||
|
|
return rm;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
public static returnminfo setreturnmessage(string domainname, string ip, Getdata gd)
|
|||
|
|
{
|
|||
|
|
List<Domain.Entities.DeviceManage> dm = SqlSugarBase.GesmartDb().Queryable<Domain.Entities.DeviceManage>().Where(x => x.HotelCode == gd.Content.HotelID).ToList();
|
|||
|
|
returnminfo ri = new returnminfo();
|
|||
|
|
Domain.Entities.DeviceManage dms = dm.Find(x => x.RoomId == gd.Content.RoomID);
|
|||
|
|
tbl_face_key_request_log tfkrl = new tbl_face_key_request_log();
|
|||
|
|
// http://localhost:55151
|
|||
|
|
if (domainname == "http://face.blv-oa.com")
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
//有酒店
|
|||
|
|
if (dm.Count != 0)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
//有酒店房间号码酒店房间号码对应
|
|||
|
|
if (dms != null)
|
|||
|
|
{
|
|||
|
|
tbl_face_key tfk = SqlSugarBase.GesmartDb().Queryable<tbl_face_key>().First(x => x.SN == dms.SerialNo);
|
|||
|
|
//有key的人脸机
|
|||
|
|
if (tfk != null)
|
|||
|
|
{
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = tfk.SN;
|
|||
|
|
tfkrl.DeviceBrand = dms.Factory;
|
|||
|
|
tfkrl.Key = tfk.Key;
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
tfkrl.Result = "true";
|
|||
|
|
tfkrl.Remark = "key查询api调用成功";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "200";
|
|||
|
|
ri.ErrMsg = "ok";
|
|||
|
|
ri.Contents.DeviceBrand = dms.Factory;
|
|||
|
|
ri.Contents.Key = tfk.Key;
|
|||
|
|
ri.Contents.DeviceSN = tfk.SN;
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3004";
|
|||
|
|
ri.ErrMsg = "insert log database wrong";
|
|||
|
|
ri.Contents.DeviceBrand = dms.Factory;
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = tfk.SN;
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
//没有key的人脸机
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = tfk.SN;
|
|||
|
|
tfkrl.DeviceBrand = dms.Factory;
|
|||
|
|
tfkrl.Key = "";
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
|
|||
|
|
tfkrl.Result = "false";
|
|||
|
|
tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3006";
|
|||
|
|
ri.ErrMsg = "Face machine does not have key!";
|
|||
|
|
ri.Contents.DeviceBrand = dms.Factory;
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = tfk.SN;
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3004";
|
|||
|
|
ri.ErrMsg = "insert log database wrong";
|
|||
|
|
ri.Contents.DeviceBrand = dms.Factory;
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = tfk.SN;
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//有酒店房间号码与酒店房间号码不对应
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = "";
|
|||
|
|
tfkrl.DeviceBrand = "";
|
|||
|
|
tfkrl.Key = "";
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
tfkrl.Result = "false";
|
|||
|
|
tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3007";
|
|||
|
|
ri.ErrMsg = "the hotel does not have a room for it!";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3004";
|
|||
|
|
ri.ErrMsg = "insert log database wrong";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//无酒店
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = "";
|
|||
|
|
tfkrl.DeviceBrand = "";
|
|||
|
|
tfkrl.Key = "";
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
tfkrl.Result = "false";
|
|||
|
|
tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3008";
|
|||
|
|
ri.ErrMsg = "there is no such hotel!";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3004";
|
|||
|
|
ri.ErrMsg = "insert log database wrong";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3009";
|
|||
|
|
ri.ErrMsg = "Domain Name Error";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
public static returnminfo Gethotelandroominfo(string domainname, string ip, Getdata gd)
|
|||
|
|
{
|
|||
|
|
List<Domain.Entities.DeviceManage> dm = SqlSugarBase.GesmartDb().Queryable<Domain.Entities.DeviceManage>().Where(x => x.HotelCode == gd.Content.HotelID).ToList();
|
|||
|
|
returnminfo ri = new returnminfo();
|
|||
|
|
Domain.Entities.DeviceManage dms = dm.Find(x => x.RoomId == gd.Content.RoomID);
|
|||
|
|
tbl_face_key_request_log tfkrl = new tbl_face_key_request_log();
|
|||
|
|
// http://localhost:55151
|
|||
|
|
// domainname http://face.blv-oa.com
|
|||
|
|
if (domainname == "http://face.blv-oa.com")
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
//有酒店
|
|||
|
|
if (dm.Count != 0)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
//有酒店房间号码酒店房间号码对应
|
|||
|
|
if (dms != null)
|
|||
|
|
{
|
|||
|
|
//tbl_face_key tfk = SqlSugarBase.GesmartDb().Queryable<tbl_face_key>().First(x => x.SN == dms.SerialNo);
|
|||
|
|
////有key的人脸机
|
|||
|
|
//if (tfk != null)
|
|||
|
|
//{
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = dms.SerialNo;
|
|||
|
|
tfkrl.DeviceBrand = dms.Factory;
|
|||
|
|
//tfkrl.Key = tfk.Key;
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
tfkrl.Result = "true";
|
|||
|
|
tfkrl.Remark = "key查询api调用成功";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "200";
|
|||
|
|
ri.ErrMsg = "ok";
|
|||
|
|
ri.Contents.DeviceBrand = dms.Factory;
|
|||
|
|
//ri.Contents.Key = tfk.Key;
|
|||
|
|
ri.Contents.DeviceSN = dms.SerialNo;
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3004";
|
|||
|
|
ri.ErrMsg = "insert log database wrong";
|
|||
|
|
ri.Contents.DeviceBrand = dms.Factory;
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = dms.SerialNo;
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
//}
|
|||
|
|
//没有key的人脸机
|
|||
|
|
//else
|
|||
|
|
//{
|
|||
|
|
// tfkrl.AppKey = gd.AppKey;
|
|||
|
|
// tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
// tfkrl.IP = ip;
|
|||
|
|
// tfkrl.MsgID = gd.MsgID;
|
|||
|
|
// tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
// tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
// tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
// tfkrl.DeviceSN = tfk.SN;
|
|||
|
|
// tfkrl.DeviceBrand = dms.Factory;
|
|||
|
|
// tfkrl.Key = "";
|
|||
|
|
// tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
|
|||
|
|
// tfkrl.Result = "false";
|
|||
|
|
// tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
// tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
// ri.MsgID = gd.MsgID;
|
|||
|
|
// ri.ErrCode = "3006";
|
|||
|
|
// ri.ErrMsg = "Face machine does not have key!";
|
|||
|
|
// ri.Contents.DeviceBrand = dms.Factory;
|
|||
|
|
// ri.Contents.Key = "";
|
|||
|
|
// ri.Contents.DeviceSN = tfk.SN;
|
|||
|
|
// ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
// ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
// tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
// int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
// if (count > 0)
|
|||
|
|
// {
|
|||
|
|
// return ri;
|
|||
|
|
// }
|
|||
|
|
// else
|
|||
|
|
// {
|
|||
|
|
// ri.MsgID = gd.MsgID;
|
|||
|
|
// ri.ErrCode = "3004";
|
|||
|
|
// ri.ErrMsg = "insert log database wrong";
|
|||
|
|
// ri.Contents.DeviceBrand = dms.Factory;
|
|||
|
|
// ri.Contents.Key = "";
|
|||
|
|
// ri.Contents.DeviceSN = tfk.SN;
|
|||
|
|
// ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
// ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
// return ri;
|
|||
|
|
// }
|
|||
|
|
|
|||
|
|
//}
|
|||
|
|
}
|
|||
|
|
//有酒店房间号码与酒店房间号码不对应
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = "";
|
|||
|
|
tfkrl.DeviceBrand = "";
|
|||
|
|
tfkrl.Key = "";
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
tfkrl.Result = "false";
|
|||
|
|
tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3007";
|
|||
|
|
ri.ErrMsg = "the hotel does not have a room for it!";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3004";
|
|||
|
|
ri.ErrMsg = "insert log database wrong";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
//无酒店
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
tfkrl.AppKey = gd.AppKey;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.IP = ip;
|
|||
|
|
tfkrl.MsgID = gd.MsgID;
|
|||
|
|
tfkrl.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.TimeStamp = gd.Timestamp;
|
|||
|
|
tfkrl.HotelID = gd.Content.HotelID;
|
|||
|
|
tfkrl.DeviceSN = "";
|
|||
|
|
tfkrl.DeviceBrand = "";
|
|||
|
|
tfkrl.Key = "";
|
|||
|
|
tfkrl.CreateDateTime = DateTime.Now;
|
|||
|
|
tfkrl.Result = "false";
|
|||
|
|
tfkrl.Remark = "key查询api调用失败";
|
|||
|
|
tfkrl.RequstCnt = tfkrl.RequstCnt + 1;
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3008";
|
|||
|
|
ri.ErrMsg = "there is no such hotel!";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
tfkrl.Return = JsonConvert.SerializeObject(ri, Formatting.Indented);
|
|||
|
|
int count = SqlSugarBase.GesmartDb().Insertable(tfkrl).ExecuteCommand();
|
|||
|
|
if (count > 0)
|
|||
|
|
{
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3004";
|
|||
|
|
ri.ErrMsg = "insert log database wrong";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ri.MsgID = gd.MsgID;
|
|||
|
|
ri.ErrCode = "3009";
|
|||
|
|
ri.ErrMsg = "Domain Name Error";
|
|||
|
|
ri.Contents.DeviceBrand = "";
|
|||
|
|
ri.Contents.Key = "";
|
|||
|
|
ri.Contents.DeviceSN = "";
|
|||
|
|
ri.Contents.HotelID = gd.Content.HotelID;
|
|||
|
|
ri.Contents.RoomID = gd.Content.RoomID;
|
|||
|
|
return ri;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|