- smc_source_1.zip
- SMC_Source
- Smc.jar
- SMC_Demo
- DataAccess
- DataAccess
- Domain
- Domain
- ServicesProvider
- ServicesProvider
- SMC_Demo
- SMCWebsite
- SQL Database Script
- SMC_Source.zip
|
��U S E [ C a r A u t o m a t i o n ]
G O
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ i s p _ W o r k F l o w S t a t e P e r s i s t e n c e ] S c r i p t D a t e : 1 0 / 2 0 / 2 0 0 8 1 8 : 5 5 : 5 1 * * * * * * /
S E T A N S I _ N U L L S O N
G O
S E T Q U O T E D _ I D E N T I F I E R O N
G O
C R E A T E P R O C E D U R E [ d b o ] . [ i s p _ W o r k F l o w S t a t e P e r s i s t e n c e ]
- - A d d t h e p a r a m e t e r s f o r t h e s t o r e d p r o c e d u r e h e r e
@ C a r _ I D i n t ,
@ U p d a t e d _ B y i n t ,
@ C u r r e n t _ S t a t e _ I D i n t ,
@ P r e v i o u s _ S t a t e _ I D i n t ,
@ R e m a r k s V A R C H A R ( m a x )
A S
i f E x i s t s ( s e l e c t C a r _ I D F r o m C a r w h e r e C a r _ I D = @ C a r _ I D
a n d C u r r e n t _ S t a t e _ I D = @ P r e v i o u s _ S t a t e _ I D )
B E G I N
- - A u d i t L o g
B E G I N T R A N
I N S E R T I N T O [ C a r A u t o m a t i o n ] . [ d b o ] . [ S t a t e A u d i t L o g ]
( [ C a r _ I D ]
, [ S t a t e _ I D ]
, [ R e m a r k s ]
, [ L a s t _ U p d a t e d _ B y ]
, [ L a s t _ U p d a t e d _ D a t e ] )
V A L U E S
( @ C a r _ I D
, @ C u r r e n t _ S t a t e _ I D
, @ R e m a r k s
, @ U p d a t e d _ B y
, G e t D a t e ( ) )
- - U p d a t e S t a t e D e m a n d T a b l e
U P D A T E C a r
S E T [ C u r r e n t _ S t a t e _ I D ] = @ C u r r e n t _ S t a t e _ I D ,
[ P r e v i o u s _ S t a t e _ I D ] = @ P r e v i o u s _ S t a t e _ I D ,
[ L a s t _ U p d a t e d _ B y ] = @ U p d a t e d _ B y
W H E R E [ C a r _ I D ] = @ C a r _ I D
i f ( @ @ e r r o r = 0 )
c o m m i t
e l s e
R o l l b a c k
E N D
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.