| | |
|---|
| | | |
|---|
| | | //时间段及屏蔽机号 |
|---|
| | | public static string[] shieldDoor = System.Configuration.ConfigurationManager.AppSettings["shieldDoor"].Split(','); |
|---|
| | | public static string shieldDoorStr = System.Configuration.ConfigurationManager.AppSettings["shieldDoor"]; |
|---|
| | | public static string swichTime = System.Configuration.ConfigurationManager.AppSettings["swichTime"]; |
|---|
| | | //人脸图片第二路径 |
|---|
| | | public static string[] FacePathDoor = System.Configuration.ConfigurationManager.AppSettings["FacePathDoor"].Split(','); |
|---|
| | |
|---|
| | | { |
|---|
| | | sql += SQL_IF_One + timeDelay + SQL_IF_One_a + _seconds + SQL_IF_One_b; |
|---|
| | | } |
|---|
| | | sql += SQL_Six + SQL_Seven + SQL_Eight + SQL_Nine; |
|---|
| | | |
|---|
| | | //sql += SQL_Six + SQL_Seven + SQL_Eight + SQL_Nine; |
|---|
| | | |
|---|
| | | //直接屏蔽宿舍号，不获取宿舍的记录 |
|---|
| | | string sqlWhere = $" where aa.door_id not in({shieldDoorStr})"; |
|---|
| | | |
|---|
| | | sql += SQL_Six + SQL_Seven + SQL_Eight + sqlWhere + SQL_Nine; |
|---|
| | | |
|---|
| | | //log4netService.Debug("_seconds" + _seconds); |
|---|
| | | //log4netService.Debug("sql：" + sql); |
|---|
| | | //log4netService.Debug($"测试SQL={sql}"); |
|---|
