# fs-e7

**Repository Path**: truing/fs-e7

## Basic Information

- **Project Name**: fs-e7
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-10-12
- **Last Updated**: 2023-09-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 富士智能数据库触发器
```
## 禁用和启用触发器
disable trigger tgr_DmsOpenRecord_B_insert on DmsOpenRecord_B;
enable trigger tgr_DmsOpenRecord_B_insert on DmsOpenRecord_B;


## 定义触发器
if (object_id('tgr_DmsOpenRecord_B_insert', 'tr') is not null)
    drop trigger tgr_DmsOpenRecord_B_insert
go
create trigger tgr_DmsOpenRecord_B_insert
on DmsOpenRecord_B
    for insert 
as 
 declare @id int,@DevNo int,@DoorNo int, @doorId varchar(100),@TcmName VARCHAR(20),@doorName VARCHAR(20), @type int,@url nchar(4000),@object int,@responseText varchar(4000),@params varchar(2000);
 select @id=id, @DevNo = DevNo, @DoorNo = DoorNo from inserted;
 select @doorId=RID FROM DmsDeviceRead WHERE DevNo = @DevNo AND DoorNo =@DoorNo;
 SELECT @TcmName=CASE TcmName
	WHEN '远程开门' THEN '1'
	WHEN '普通用户卡' THEN '2'
	WHEN '非法卡' THEN '3'
	WHEN '按钮开门' THEN '4'
	WHEN '无效卡类' THEN '5'
	ELSE '0'
END FROM DmsOpenRecord_A WHERE id= @id
 set @url = concat('http://192.168.3.221:10660/excute?doorId=',@doorId,'&type=',@TcmName,'&id=',@id)
 exec sp_OACreate'MSXML2.XMLHTTP',@object out
 exec sp_OAMethod @object,'open',null,'get',@url,'false'
 exec sp_OAMethod @object,'send'
 exec sp_OAMethod @object,'responseText',@responseText output
 print @responseText
 exec sp_OADestroy @object
 SET NOCOUNT ON;
go
	
```