| 123456789101112131415161718192021222324252627282930313233343536 |
- DECLARE @RC int
- DECLARE @Line varchar(30)
- DECLARE @Station varchar(30)
- DECLARE @TestDate date
- DECLARE @TestHour int
- DECLARE @TestTime datetime
- DECLARE @SN varchar(30)
- DECLARE @DSN varchar(30)
- DECLARE @ODF varchar(30)
- DECLARE @Model varchar(30)
- DECLARE @Dimension varchar(30)
- DECLARE @LastSN int
- DECLARE @Result int
- DECLARE @ErrMsg varchar(300)
- DECLARE @Remark varchar(100)
- -- TODO: 在此处设置参数值。
- SET @Line = 'Test'
- SET @Station = 'DataBurning'
- SET @TestDate = '2021-12-02'
- SET @TestHour = 10
- SET @TestTime = '2021-12-02 12:12:03'
- SET @SN = 'DGG75096992112000808'
- SET @DSN = ''
- SET @ODF = 'DGG7509699'
- SET @Model = '55D2010'
- SET @Dimension = '55'
- SET @LastSN = 1 -- 是否连续抄写: 0表示非连续抄写,1表示连续抄写;
- SET @Result = 1 -- 抄写结果:0表示抄写失败, 1表示抄写成功;
- SET @ErrMsg = ''
- SET @Remark = '测试数据'
- EXECUTE @RC = [MES].[dbo].[DealAMResult] @Line,@Station,@TestDate,@TestHour,@TestTime,@SN,@DSN,@ODF,@Model,@Dimension,@LastSN,@Result,@ErrMsg,@Remark
- SELECT * FROM AMResult WHERE Line=@Line AND Station=@Station AND SN=@SN
- --DELETE FROM AMResult WHERE Line=@Line AND Station=@Station AND SN=@SN
|
