34,576
社区成员
发帖
与我相关
我的任务
分享
create procedure HardWare_add_p
@deviceNumber varchar(64), --0.设备流水号
@deviceName varchar(64), --1.设备名称
@deviceType varchar(64), --2.设备类型
@cpu varchar(64), --3.CPU
@hardDiskSize varchar(16), --4.硬盘容量
@memorySize varchar(16), --5.内存容量
@buyDate varchar(16), --6.购买日期
@stallPosition varchar(64), --7.安装位置
@operatingSystem varchar(64), --8.操作系统
@dataBase varchar(64), --9.数据库
@ipAddress1 varchar(20), --10.IP地址一
@ipAddress2 varchar(20), --11.IP地址二
@macAddress1 varchar(20), --12.macAddress1
@macAddress2 varchar(20), --13.macAddress1
@sqlServer char(5000) output
as
begin tran
begin try
declare @sql_0 varchar(5000)
declare @sql_1 varchar(5000)
declare @sql_2 varchar(5000)
set @sql_0='insert into HardWareRecord_t(deviceNumber, deviceName,deviceType,cpu,hardDiskSize, memorySize,stallPosition,buyDate,deviceInstallOperateSystem,deviceInstallDataBase)
values ('''+@deviceNumber+''','''+@deviceName+''','''+@deviceType+''','''+@cpu+''','''+@hardDiskSize+''','''+@memorySize+''','''+@buyDate+''','''+@stallPosition+''','''+@operatingSystem+''','''+@dataBase+''')'
exec (@sql_0)
-- set @sqlServer=@ipAddress1
if @ipAddress1 <> '' or @macAddress1 <> ''
begin
set @sql_1='insert into MacIpAddress_t(deviceNumber,ipAddress,macAddress) values('''+@deviceNumber+''','''+@ipAddress1+''','''+@macAddress1+''')'
exec(@sql_1)
end
if @ipAddress2 <> '' or @macAddress2 <> ''
begin
set @sql_2='insert into MacIpAddress_t(deviceNumber,ipAddress,macAddress) values('''+@deviceNumber+''','''+@ipAddress2+''','''+@macAddress2+''')'
exec(@sql_2)
end
end try
begin catch
if @@trancount>0
begin
rollback tran
end
end catch
if @@trancount>0
begin
commit tran
end