MTE31Ty8

1USE [BIDIPHAR_SFA]
2GO
3
4/****** Object:  Table [dbo].[DMSAimLog]    Script Date: 5/23/2019 3:28:35 PM ******/
5SET ANSI_NULLS ON
6GO
7
8SET QUOTED_IDENTIFIER ON
9GO
10
11CREATE TABLE [dbo].[DMSAimLog](
12	[UserName] [nvarchar](50) NOT NULL,
13	[ID] [nvarchar](50) NOT NULL,
14	[IMEI] [nvarchar](50) NULL,
15	[ClassName] [nvarchar](50) NULL,
16	[MethodName] [nvarchar](50) NULL,
17	[Message] [text] NULL,
18	[Type] [char](1) NULL,
19	[LogDate] [datetime] NULL,
20PRIMARY KEY CLUSTERED 
21(
22	[UserName] ASC,
23	[ID] ASC
24)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
25) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
26GO
27
28
29
30USE [BIDIPHAR_SFA]
31GO
32/****** Object:  StoredProcedure [dbo].[sp_OES_DMSAimLog_Insert]    Script Date: 5/23/2019 3:29:41 PM ******/
33SET ANSI_NULLS ON
34GO
35SET QUOTED_IDENTIFIER ON
36GO
37ALTER PROCEDURE [dbo].[sp_OES_DMSAimLog_Insert]
38    @UserName NVARCHAR(50) ,
39    @ID NVARCHAR(50) ,
40    @IMEI NVARCHAR(50) ,
41    @ClassName NVARCHAR(50) ,
42    @MethodName NVARCHAR(50) ,
43    @Message NVARCHAR(500) ,
44    @Type CHAR(1) ,
45    @LogDate DATETIME
46AS
47    BEGIN
48        IF NOT EXISTS ( SELECT  *
49                        FROM    dbo.DMSAimLog
50                        WHERE   ID = @ID
51                                AND UserName = @UserName )
52            INSERT  INTO [dbo].DMSAimLog
53                    ( UserName ,
54                      ID ,
55                      IMEI ,
56                      ClassName ,
57                      MethodName ,
58                      [Message] ,
59                      [Type] ,
60                      LogDate
61                    )
62            VALUES  ( @UserName ,
63                      @ID ,
64                      @IMEI ,
65                      @ClassName ,
66                      @MethodName ,
67                      @Message ,
68                      @Type ,
69                      @LogDate
70                    );
71    END;