<?xml version="1.0" encoding="utf-8" ?>
|
<configuration>
|
<connectionStrings>
|
<!--人脸识别系统数据库 -->
|
<!--
|
<add name="ConnectionString" connectionString="server=8.129.227.30;uid=admin;pwd=admin;database=FaceOpen3" providerName="System.Data.SqlClient"/>
|
-->
|
<!-- 数据类型：服务器引擎；服务器名：WIN-PPHJ26HT77K-->
|
<add name="ConnectionString" connectionString="server=127.0.0.1;uid=ZJsa;pwd=ZhangJun@2021;database=EastRiver" providerName="System.Data.SqlClient"/>
|
</connectionStrings>
|
<appSettings>
|
<!--掌骏后端接口配置值 -->
|
<!--主服务URL -->
|
<!--开发环境 -->
|
<!--<add key="mainServiceUrl" value="http://127.0.0.1:5088/api/data"/>-->
|
<!--测试环境 -->
|
<!--<add key="mainServiceUrl" value="https://dryadnet.izjun.com/api/data"/>-->
|
<!--生产环境参数 -->
|
<add key="mainServiceUrl" value="https://qwx.izjun.com/api/data"/>
|
|
<!-- 学生门禁记录推送企业微信-->
|
<add key="sendMsgByAccessControlRecordUrl" value="/sendMsgByAccessControlRecord"/>
|
<!-- 检查服务端门禁人脸图片文件前是否存在URL-->
|
<add key="checkDoorImageUrl" value="/checkDoorImage"/>
|
<!-- 上传门禁系统人脸图片URL-->
|
<add key="uploadDoorImageUrl" value="/uploadDoorImage"/>
|
<!-- 企业微信授权企业ID -->
|
<add key="CorpId" value="wwdb4edece850e2e52"/>
|
<!-- 定时服务轮循休眠时间（毫秒），默认2秒 -->
|
<add key="sleepTime" value="2000"/>
|
|
<!-- 延时10秒提交数据-->
|
<add key="timeDelay" value="10"/>
|
|
<!-- 获取近2小时（7200秒）的门禁学生进出记录，注意该值必须大于轮循休眠时间 -->
|
<add key="seconds" value="120"/>
|
|
<!-- 两次门禁考勤记录间相同方向在60秒(1分钟)内，不推送微信；为0时都推送。 -->
|
<add key="twoRecordSameTimes" value="60"/>
|
|
<!-- 两次门禁考勤记录间相反方向在60秒(1分钟)内，不推送微信；为0时都推送。 -->
|
<add key="twoRecordContraryTimes" value="60"/>
|
|
<!-- 两次门禁考勤记录间在60秒(5分钟)内，不推送短信；为0时都推送。 -->
|
<add key="twoRecordSMSTimes" value="300"/>
|
|
<!-- 请假签到有效时间内1800秒(30分钟) -->
|
<add key="validTimeLeave" value="1800"/>
|
|
<!-- 人脸识别照片路径 -->
|
<add key="frpicPath" value="D:/Program Files (x86)/EastRiver/Documents/FRPic"/>
|
|
<!-- 刷卡抓拍路径 -->
|
<add key="doorPicPath" value="D:/Program Files (x86)/EastRiver/Documents/DoorPic"/>
|
|
<!-- 温度控制不推送消息，由于门禁配置大于等于这个温度不开门。 -->
|
<add key="_temperature" value="37.3"/>
|
|
<!-- 走读生类型 -->
|
<add key="extern_student" value="66"/>
|
<!-- 住宿生类型 -->
|
<add key="boarder_student" value="55"/>
|
|
<!--时间段规则如下，时间跨度以连接符“~”连接，多个时间以分号“；”分隔如：value="11:00~14:00; 17:25~18:50; 21:00~23:59"-->
|
<!-- 走读生、进门、周一到周日推送消息时间段 -->
|
<add key="in_extern_monday" value="00:00~23:59"/>
|
<add key="in_extern_tuesday" value="00:00~23:59"/>
|
<add key="in_extern_wednesday" value="00:00~23:59"/>
|
<add key="in_extern_thursday" value="00:00~23:59"/>
|
<add key="in_extern_friday" value="00:00~23:59"/>
|
<add key="in_extern_saturday" value="00:00~23:59"/>
|
<add key="in_extern_sunday" value="00:00~23:59"/>
|
<!-- 住宿生、进门、周一到周日推送消息时间段 -->
|
<add key="in_boarder_monday" value="00:00~23:59"/>
|
<add key="in_boarder_tuesday" value="00:00~23:59"/>
|
<add key="in_boarder_wednesday" value="00:00~23:59"/>
|
<add key="in_boarder_thursday" value="00:00~23:59"/>
|
<add key="in_boarder_friday" value="00:00~23:59"/>
|
<add key="in_boarder_saturday" value="00:00~23:59"/>
|
<add key="in_boarder_sunday" value="00:00~23:59"/>
|
|
<!-- 走读生、出门、周一到周日推送消息时间段 -->
|
<add key="out_extern_monday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_extern_tuesday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_extern_wednesday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_extern_thursday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_extern_friday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_extern_saturday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_extern_sunday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<!-- 住宿生、出门、周一到周日推送消息时间段 -->
|
<add key="out_boarder_monday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_boarder_tuesday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_boarder_wednesday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_boarder_thursday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_boarder_friday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_boarder_saturday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
<add key="out_boarder_sunday" value="11:00~14:00; 17:25~18:50; 21:00~23:59"/>
|
|
<!--SQL语句-->
|
<add key ="SQL_One" value=" select aa.*, b.status_id "/>
|
<add key ="SQL_Two" value=" from ( "/>
|
<add key ="SQL_Three" value=" select a.id, a.card_id, a.emp_id, a.door_id, a.temperature, a.passTime, a.inOutFlag, a.evenFlag, a.subdeviceid "/>
|
<add key ="SQL_Four" value=" from eastRiver.dbo.PassTime a "/>
|
<add key ="SQL_Five" value=" where 1=1 and dataSycFlag = 0 "/>
|
|
<add key="SQL_IF_One" value=" and DATEDIFF(ss, a.passTime, GETDATE() ) >= "/>
|
<add key="SQL_IF_One_a" value=" and DATEDIFF(ss, a.passTime, GETDATE() ) <= "/>
|
<add key="SQL_IF_One_b" value=" "/>
|
|
|
<add key ="SQL_Six" value=" ) aa "/>
|
<add key ="SQL_Seven" value=" left join [EastRiver].[dbo].[Employee] b "/>
|
<add key ="SQL_Eight" value=" on aa.emp_id=b.emp_id "/>
|
<add key ="SQL_Nine" value=" order by aa.passTime "/>
|
|
|
<!--门禁记录SQL语句：微信-->
|
<add key="MJ_One" value=" select DISTINCT a.id, a.card_id, a.emp_id, a.door_id, a.passTime, a.inOutFlag, a.evenFlag "/>
|
<add key="MJ_Two" value=" from eastRiver.dbo.PassTime a where 1!=1 and a.emp_id = ' "/>
|
<add key="MJ_Three" value=" ' "/>
|
<!--相同方向-->
|
<add key="MJ_Same_one" value=" union all select DISTINCT a.id, a.card_id, a.emp_id, a.door_id, a.passTime, a.inOutFlag, a.evenFlag "/>
|
<add key="MJ_Same_two" value=" from eastRiver.dbo.PassTime a where 1=1 and a.emp_id = ' "/>
|
<add key="MJ_Same_three" value=" ' and a.inOutFlag = "/>
|
<add key="MJ_Same_four" value=" and DATEDIFF(ss, a.passTime, (select passTime from eastRiver.dbo.PassTime where id = "/>
|
<add key="MJ_Same_five" value=" ) ) < 0 "/>
|
<add key="MJ_Same_six" value=" and DATEDIFF(ss, a.passTime, (select passTime from eastRiver.dbo.PassTime where id = "/>
|
<add key="MJ_Same_seven" value=" ) ) >= "/>
|
<!--相同相反方向-->
|
<add key="MJ_Same_Contrary_one" value=" union all select DISTINCT a.id, a.card_id, a.emp_id, a.door_id, a.passTime, a.inOutFlag, a.evenFlag "/>
|
<add key="MJ_Same_Contrary_two" value=" from eastRiver.dbo.PassTime a where 1=1 and a.emp_id = ' "/>
|
<add key="MJ_Same_Contrary_three" value=" ' and a.inOutFlag != "/>
|
<add key="MJ_Same_Contrary_four" value=" and DATEDIFF(ss, a.passTime, (select passTime from eastRiver.dbo.PassTime where id = "/>
|
<add key="MJ_Same_Contrary_five" value=" ) ) < 0 "/>
|
<add key="MJ_Same_Contrary_six" value=" and DATEDIFF(ss, a.passTime, (select passTime from eastRiver.dbo.PassTime where id = "/>
|
<add key="MJ_Same_Contrary_seven" value=" ) ) >= "/>
|
|
<!--门禁记录SQL语句：短信-->
|
<add key="MJ_SMS_one" value=" select a.id, a.card_id, a.emp_id, a.door_id, a.passTime, a.inOutFlag, a.evenFlag from ( select top 2 id, card_id, emp_id, door_id, passTime, inOutFlag, evenFlag from eastRiver.dbo.PassTime where 1=1 and emp_id = '"/>
|
<add key="MJ_SMS_two" value="' and dataSycFlag <3 order by id desc ) a where 1=1 "/>
|
<!--相同&&相反方向-->
|
<add key="MJ_SMS_Same_Contrary_one" value=" and DATEDIFF(ss, a.passTime, (select passTime from eastRiver.dbo.PassTime where id = "/>
|
<add key="MJ_SMS_Same_Contrary_two" value=" ) ) > 0 "/>
|
<add key="MJ_SMS_Same_Contrary_three" value=" and DATEDIFF(ss, a.passTime, (select passTime from eastRiver.dbo.PassTime where id = "/>
|
<add key="MJ_SMS_Same_Contrary_four" value=" ) )<= "/>
|
|
|
|
<!--时间规则控制开关 1 为开启 0 为关闭-->
|
<add key="swichTime" value="1"/>
|
<!--门禁设备屏蔽 以 , 分隔-->
|
<add key="shieldDoor" value=""/>
|
|
<!--门禁设备屏蔽单个门，逗号,分割-->
|
<add key="doorSwitchList" value="8225:1" />
|
<!--人脸第二路径-->
|
<add key="FacePath" value="D:\Program Files (x86)\EastRiver\通讯前置\Documents\SnapPhoto"/>
|
<!--人脸第二路径设备号，以 , 分隔-->
|
<add key="FacePathDoor" value=""/>
|
|
<!--黑名单路径-->
|
<add key="blackPath" value="D:\智慧校园\新建文件夹\Debug"/>
|
|
</appSettings>
|
|
<startup>
|
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
|
</startup>
|
</configuration>
|
