C R E A T E   P r o c e d u r e   D e l e t e P r o d u c t 
 
 ( 
 
 @ i d   v a r c h a r ( 1 0 0 ) , @ u s e r i d   i n t 
 
 ) 
 
 a s 
 
 b e g i n 
 
   e x e c ( ' d e l e t e   f r o m   y x _ v o t e   w h e r e   y x _ v o i d t y p e = 1   a n d   y x _ s e l l u s e r = ' + @ u s e r i d + '   a n d   y x _ p r o i d   i n ( ' + @ i d + ' ) ' )     / *  RdYu h* / 
 
   e x e c ( ' d e l e t e   f r o m   y x _ p a i p a i   w h e r e   y x _ u s e r i d = ' + @ u s e r i d + '   a n d     y x _ p r o i d   i n   ( ' + @ i d + ' ) ' )     / *  RdzNh* / 
 
   e x e c ( ' d e l e t e   f r o m   y x _ o r d e r f o r m   w h e r e     y x _ u s e r i d = ' + @ u s e r i d + '   a n d   y x _ p r o i d   i n     ( ' + @ i d + ' ) ' )     / *  RdUSh* / 
 
   e x e c ( ' d e l e t e   f r o m   y x _ p r o d u c t   w h e r e     y x _ u s e r i d = ' + @ u s e r i d + '   a n d   y x _ i d   i n   ( ' + @ i d + ' ) ' )     / *  RdFUTh* / 
 
 e n d 
 
 
 
 
 
 ~ 
 
 
 
 C R E A T E   P r o c e d u r e   D e l e t e U s e r     / *  Rd(u7b* / 
 
 ( 
 
 @ i d   v a r c h a r ( 1 0 0 ) 
 
 ) 
 
 a s 
 
 b e g i n 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ U s e r I n f o   w h e r e   Y X _ U s e r I D = ' + @ i d + ' ' )     / *  RdOXT* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ S h o p   w h e r e   y x _ s h o p u s e r i d = ' + @ i d + ' ' )     / *  RdFU* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ P r o d u c t   w h e r e   y x _ u s e r i d = ' + @ i d + ' ' )     / *  RdFUT* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ t s   w h e r e   Y X _ u s e r i d = ' + @ i d + ' ' )     / *  Rdbh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ t s   w h e r e   Y X _ t s u s e r i d = ' + @ i d + ' ' )     / *  Rdbh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ O r d e r F o r m   w h e r e   Y X _ u s e r i d = ' + @ i d + ' ' )     / *  RdUSh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ O r d e r F o r m   w h e r e   Y X _ r e u s e r i d = ' + @ i d + ' ' )     / *  RdUSh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ S H O P C l a s s   w h e r e   Y X _ u s e r i d = ' + @ i d + ' ' )     / *  Rd(u7bꁚ[INR{|h* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ c o m m e n d   w h e r e   Y X _ u s e r i d = ' + @ i d + ' ' )     / *  RdcPFUTh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ L i n k   w h e r e   Y X _ l i n k U s e r I D = ' + @ i d + ' ' )     / *  RdS`ch* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ L i n k   w h e r e   Y X _ U s e r i d = ' + @ i d + ' ' )     / *  RdS`ch* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ O n l i n e p a y m e n t   w h e r e   y x _ u s e r i d = ' + @ i d + ' ' )     / *  Rd/eN[{h* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ p a i p a i   w h e r e   y x _ u s e r i d = ' + @ i d + ' ' )     / *  RdbpN4Neh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ p a i p a i   w h e r e   Y X _ r e u s e r i d = ' + @ i d + ' ' )     / *  RdbpN4Neh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ C o l l e c t i o n   w h e r e   Y X _ C o l l U s e r = ' + @ i d + ' ' )     / *  Rd6eυFUTh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y x _ M e s s a g e s   w h e r e   Y x _ S e n d I D = ' + @ i d + ' ' )     / *  RdOo`Yu h* / 
 
   e x e c ( ' d e l e t e   f r o m   Y x _ M e s s a g e s   w h e r e   Y x _ G e t I D = ' + @ i d + ' ' )     / *  RdOo`Yu h* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ P r o m a n g e r   w h e r e   Y X _ u s e r i d = ' + @ i d + ' ' )     / *  Rd6e'0W@Wh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ s e l l   w h e r e   Y X _ u s e r i d = ' + @ i d + ' ' )     / *  RdċNh* / 
 
   e x e c ( ' d e l e t e   f r o m   Y X _ s e l l   w h e r e   Y X _ s e l l u s e r i d = ' + @ i d + ' ' )     / *  RdċNh* / 
 
 
 
 e n d 
 
 
 
 
 
 
 
 ~ 
 
 
 
 
 
 c r e a t e   P r o c e d u r e   D o w n C l a s s 
 
 ( 
 
 @ Y X _ I D   i n t 
 
 ) 
 
 a s 
 
 d e c l a r e   @ F _ P a r e n t I D   v a r c h a r ( 1 0 0 ) / * 6r~R{|* / 
 
 d e c l a r e   @ F _ P a t h   v a r c h a r ( 1 0 0 ) / * 6r~R{|_* / 
 
 d e c l a r e   @ F _ C h i l d   i n t / * 6r~R{|vC h i l d * / 
 
 d e c l a r e   @ F _ P r e v I D   i n t / * 6r~R{|vTm^R{|
N*NI D * / 
 
 d e c l a r e   @ F _ N e x t I D   i n t / * 6r~R{|vTm^R{|N*NI D * / 
 
 d e c l a r e   @ F _ O r d e r I D   i n t   / * 6r~R{|vc^I D * / 
 
 d e c l a r e   @ T e m p P a t h   v a r c h a r ( 1 0 0 )   / * 4Ne_* / 
 
 d e c l a r e   @ T e m p N u m   i n t   / * 4Nei n t W* / 
 
 s e l e c t     @ F _ P a r e n t I D = Y X _ P a r e n t I D , @ F _ P a t h = Y X _ P a r e n t P a t h , @ F _ C h i l d = Y X _ C h i l d , @ F _ P r e v I D = Y X _ P r e v I D , @ F _ N e x t I D = Y X _ N e x t I D 
 
 , @ F _ O r d e r I D = Y X _ O r d e r I D   f r o m   Y X _ p r o d u c t c l a s s   w h e r e   Y X _ I D = @ Y X _ I D 
 
 	 
 
 	 i f   @ F _ N e x t I D > 0 
 
                 b e g i n 
 
                 	 e x e c   U p C l a s s   @ F _ N e x t I D 	 	 
 
 	 e n d 
 
 
 
 
 
 ~ 
 
 
 
 
 
 c r e a t e   P r o c e d u r e   D o w n N e w s C l a s s 
 
 ( 
 
 @ Y X _ I D   i n t 
 
 ) 
 
 a s 
 
 d e c l a r e   @ F _ P a r e n t I D   v a r c h a r ( 1 0 0 ) / * 6r~R{|* / 
 
 d e c l a r e   @ F _ P a t h   v a r c h a r ( 1 0 0 ) / * 6r~R{|_* / 
 
 d e c l a r e   @ F _ C h i l d   i n t / * 6r~R{|vC h i l d * / 
 
 d e c l a r e   @ F _ P r e v I D   i n t / * 6r~R{|vTm^R{|
N*NI D * / 
 
 d e c l a r e   @ F _ N e x t I D   i n t / * 6r~R{|vTm^R{|N*NI D * / 
 
 d e c l a r e   @ F _ O r d e r I D   i n t   / * 6r~R{|vc^I D * / 
 
 d e c l a r e   @ T e m p P a t h   v a r c h a r ( 1 0 0 )   / * 4Ne_* / 
 
 d e c l a r e   @ T e m p N u m   i n t   / * 4Nei n t W* / 
 
 s e l e c t     @ F _ P a r e n t I D = Y X _ P a r e n t I D , @ F _ P a t h = Y X _ P a r e n t P a t h , @ F _ C h i l d = Y X _ C h i l d , @ F _ P r e v I D = Y X _ P r e v I D , @ F _ N e x t I D = Y X _ N e x t I D 
 
 , @ F _ O r d e r I D = Y X _ O r d e r I D   f r o m   Y X _ N e w s C l a s s   w h e r e   Y X _ I D = @ Y X _ I D 
 
 	 
 
 	 i f   @ F _ N e x t I D > 0 
 
                 b e g i n 
 
                 	 e x e c   U p N e w s C l a s s   @ F _ N e x t I D 	 	 
 
 	 e n d 
 
 
 
 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c e d u r e   G e t M e n t L i s t 
 
 
 
 / * gQezSRh* / 
 
 @ T e m p I D   i n t 
 
 a s 
 
 s e l e c t   *   f r o m   Y X _ C h a n n e l   w h e r e   Y X _ T e m p l a t e = @ T e m p I D 
 
 
 
 
 
 ~ 
 
 
 
 c r e a t e   P r o c e d u r e   P r o _ A r t i c l e T e m p l t e 
 
 ( 
 
 @ Y X _ C M S M o d e l N a m e   v a r c h a r ( 5 0 ) , 
 
 @ C h a n n e l I D   i n t , 
 
 @ Y X _ T e m p l a t e T y p e   i n t 
 
 ) 
 
 a s 
 
 s e l e c t   *   f r o m   Y X _ C M S M o d e l   w h e r e   Y X _ C M S M o d e l N a m e = @ Y X _ C M S M o d e l N a m e   a n d   Y X _ T e m p l a t e T y p e = @ Y X _ T e m p l a t e T y p e   a n d   C h a n n e l I D = @ C h a n n e l I D 
 
 
 
 
 
 
 
 
 
 ~ 
 
 
 
 
 
 / * 9hncagNԏV NRpenc* / 
 
 C R E A T E   P r o c e d u r e   P r o _ G e t O b j ( 
 
 @ t a b   v a r c h a r ( 5 0 )   , / * h
T* / 
 
 @ c o l u n m   v a r c h a r ( 5 0 ) , / * g⋄vR* / 
 
 @ w h e r e _ c o l u n m   v a r c h a r ( 5 0 ) , / * $ReagN* / 
 
 @ w h _ v a l u e   v a r c h a r ( 5 0 ) , / * $ReagN<P* / 
 
 @ n u m b   i n t   / * $Re/fpeW[؏/fW[&{01 0peW[00 0W[&{* / 
 
 ) 
 
 a s 
 
 b e g i n 
 
 d e c l a r e   @ S q l s t r   v a r c h a r ( 5 0 0 ) 
 
 i f   @ n u m b = 0   / * agN/fW[&{* / 
 
 	 b e g i n 
 
 	 s e t   @ S q l s t r = ' s e l e c t   ' + @ c o l u n m + '   f r o m   [ ' + @ t a b + ' ]   w h e r e   ' + @ w h e r e _ c o l u n m + '   =   ' ' ' + @ w h _ v a l u e + ' ' ' ' 
 
 	 e n d 
 
 e l s e 
 
 	 b e g i n 
 
 	 s e t   @ S q l s t r = ' s e l e c t   ' + @ c o l u n m + '   f r o m   [ ' + @ t a b + ' ]   w h e r e   ' + @ w h e r e _ c o l u n m + '   =   ' + @ w h _ v a l u e + ' ' 
 
 	 e n d 
 
 
 
 e x e c ( @ S q l s t r ) 
 
 
 
 e n d 
 
 
 
 
 
 ~ 
 
 
 
 
 
 c r e a t e   P r o c e d u r e   P r o _ G e t T e m p l a t e 
 
 
 
 ( 
 
 @ m o d e n a m e   v a r c h a r ( 5 0 ) , 
 
 @ T e m p l a t e I D   i n t 
 
 ) 
 
 a s 
 
 s e l e c t   *   f r o m   Y X _ C M S M o d e l   w h e r e   Y X _ C M S M o d e l N a m e = @ m o d e n a m e   a n d   Y X _ T e m p l a t e T y p e = @ T e m p l a t e I D 
 
 
 
 
 
 ~ 
 
 
 
 
 
 c r e a t e   P r o c e d u r e   P r o _ S e l e c t 
 
 ( 
 
 @ Y X _ s q l s t r   v a r c h a r ( 8 0 0 0 ) 
 
 ) 
 
 a s 
 
 e x e c ( @ Y X _ s q l s t r ) 
 
 
 
 
 
 ~ 
 
 
 
 
 
 C r e a t e   P r o c e d u r e   P r o _ S h o p P r o C l a s s 
 
 ( 
 
 @ U i d   i n t 
 
 ) 
 
 a s 
 
 b e g i n 
 
   s e l e c t   *   f r o m   Y X _ S h o p C l a s s   w h e r e   Y X _ U s e r i d = @ U i d 
 
 e n d 
 
 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c e d u r e   P r o _ S h o w P r o d u c t 
 
 ( 
 
 @ i d   i n t 
 
 ) 
 
 a s 
 
 s e l e c t   *   f r o m   Y X _ P r o d u c t   w h e r e   Y X _ I D = @ i d   
 
 
 
 
 
 ~ 
 
 
 
 
 
 c r e a t e   p r o c   P r o _ U p d a t e S h o p b a s e _ p i c 
 
 ( 
 
 @ Y X _ S h o p N a m e   v a r c h a r ( 5 0 ) , 
 
 @ Y X _ S h o p C l a s s   i n t , 
 
 @ Y X _ S h o p p i c   v a r c h a r ( 5 0 ) , 
 
 @ Y X _ S h o p P r o j e c t   v a r c h a r ( 6 0 ) , 
 
 @ Y X _ S h o p C o n t e n t   v a r c h a r ( 3 0 0 0 ) , 
 
 @ Y X _ S H O P U s e r I D   i n t 
 
 
 
 ) 
 
   a s 
 
 u p d a t e   Y X _ S h o p   s e t   Y X _ S h o p N a m e = @ Y X _ S h o p N a m e , Y X _ S h o p C l a s s = @ Y X _ S h o p C l a s s , Y X _ S H O P L o g o = @ Y X _ S h o p p i c   , Y X _ S h o p P r o j e c t = @ Y X _ S h o p P r o j e c t , Y X _ S h o p C o n t e n t = @ Y X _ S h o p C o n t e n t   w h e r e   Y X _ S H O P U s e r I D = @ Y X _ S H O P U s e r I D 
 
 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c e d u r e   P r o _ d e l e t e A r t i c l e C M S c l a s s 
 
 ( 
 
 @ i d   i n t 
 
 ) 
 
 a s   
 
 u p d a t e   Y X _ A r t i c l e _ C M S C l a s s   s e t   y x _ n e x t i d = ( s e l e c t   y x _ n e x t i d   f r o m   Y X _ N e w s C l a s s   w h e r e   y x _ i d = @ i d )   w h e r e   y x _ n e x t i d = @ i d 
 
 u p d a t e   Y X _ A r t i c l e _ C M S C l a s s   s e t   y x _ p r e v i d = ( s e l e c t   y x _ p r e v i d   f r o m   Y X _ N e w s C l a s s   w h e r e   y x _ i d = @ i d   )   w h e r e   y x _ p r e v i d = @ i d 
 
 U p d a t e   Y X _ A r t i c l e _ C M S C l a s s   s e t   y x _ c h i l d = y x _ c h i l d - 1   w h e r e   y x _ i d = ( s e l e c t   y x _ p a r e n t i d   f r o m   Y X _ A r t i c l e _ C M S C l a s s   w h e r e   y x _ i d = @ i d ) 
 
 d e l e t e   f r o m   Y X _ C M S A r t i c l e   w h e r e   y x _ n e w s c l a s s = @ i d 
 
 d e l e t e   f r o m   Y X _ A r t i c l e _ C M S C l a s s   w h e r e   y x _ i d = @ i d 
 
 
 
 
 
 
 
 ~ 
 
 
 
 C R E A T E   P r o c e d u r e   P r o _ d e l e t e P r o c l a s s 
 
 ( 
 
 @ i d   i n t 
 
 ) 
 
 a s   
 
 
 
 u p d a t e   Y X _ P r o d u c t C l a s s   s e t   y x _ n e x t i d = ( s e l e c t   y x _ n e x t i d   f r o m   Y X _ P r o d u c t C l a s s   w h e r e   y x _ i d = @ i d )   w h e r e   y x _ n e x t i d = @ i d 
 
 u p d a t e   Y X _ P r o d u c t C l a s s   s e t   y x _ p r e v i d = ( s e l e c t   y x _ p r e v i d   f r o m   Y X _ P r o d u c t C l a s s   w h e r e   y x _ i d = @ i d   )   w h e r e   y x _ p r e v i d = @ i d 
 
 U p d a t e   Y X _ P r o d u c t C l a s s   s e t   y x _ c h i l d = y x _ c h i l d - 1   w h e r e   y x _ i d = ( s e l e c t   y x _ p a r e n t i d   f r o m   Y X _ P r o d u c t C l a s s   w h e r e   y x _ i d = @ i d ) 
 
 d e l e t e   f r o m   Y X _ P r o d u c t   w h e r e   y x _ c l a s s = @ i d 
 
 d e l e t e   f r o m   Y X _ P r o d u c t C l a s s   w h e r e   y x _ i d = @ i d 
 
 
 
 
 
 
 
 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c e d u r e   P r o _ d e l e t e c l a s s 
 
 ( 
 
 @ i d   i n t 
 
 ) 
 
 a s   
 
 
 
 u p d a t e   Y X _ N e w s C l a s s   s e t   y x _ n e x t i d = ( s e l e c t   y x _ n e x t i d   f r o m   Y X _ N e w s C l a s s   w h e r e   y x _ i d = @ i d )   w h e r e   y x _ n e x t i d = @ i d 
 
 u p d a t e   Y X _ N e w s C l a s s   s e t   y x _ p r e v i d = ( s e l e c t   y x _ p r e v i d   f r o m   Y X _ N e w s C l a s s   w h e r e   y x _ i d = @ i d   )   w h e r e   y x _ p r e v i d = @ i d 
 
 U p d a t e   Y X _ N e w s C l a s s   s e t   y x _ c h i l d = y x _ c h i l d - 1   w h e r e   y x _ i d = ( s e l e c t   y x _ p a r e n t i d   f r o m   Y X _ N e w s C l a s s   w h e r e   y x _ i d = @ i d ) 
 
 d e l e t e   f r o m   y x _ n e w s   w h e r e   y x _ n e w s c l a s s = @ i d 
 
 d e l e t e   f r o m   Y X _ N e w s C l a s s   w h e r e   y x _ i d = @ i d 
 
 
 
 
 
 
 
 
 
 
 
 ~ 
 
 
 
 
 
 c r e a t e   P r o c e d u r e   P r o c _ S h o p L i n k 
 
 ( 
 
 @ u i d   i n t 
 
 ) 
 
 a s 
 
 b e g i n 
 
   s e l e c t   *   f r o m   Y X _ L i n k   w h e r e   Y X _ U s e r i d = @ U i d 
 
 e n d 
 
 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   p r o c   S h o w C o r r e l a t i o n 
 
 @ P r o d u c t I D   i n t 
 
 
 
 a s 
 
 d e c l a r e   @ Y X _ K e y s W o r d   v a r c h a r ( 5 0 ) , @ Y X _ P r o d u c t N a m e   v a r c h a r ( 5 0 ) 
 
 s e l e c t   @ Y X _ K e y s W o r d = Y X _ K e y s W o r d , @ Y X _ P r o d u c t N a m e = Y X _ P r o d u c t N a m e   f r o m   Y X _ P r o d u c t   w h e r e   Y X _ I D   =   @ P r o d u c t I D 
 
 s e l e c t   t o p   8     Y X _ I D , Y X _ P r o d u c t N a m e , Y X _ S p i c       f r o m   Y X _ P r o d u c t   w h e r e   Y X _ P r o d u c t N a m e   l i k e   ' % ' +   @ Y X _ P r o d u c t N a m e   + ' % '   o r   Y X _ K e y s W o r d   l i k e   ' % ' +   @ Y X _ K e y s W o r d   + ' % '   o r d e r   b y   Y X _ A d d T i m e   d e s c 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c e d u r e   S h o w S q l 
 
 ( 
 
 @ s t r   v a r c h a r ( 5 0 0 ) 
 
 ) 
 
 a s 
 
 
 
 e x e c ( @ s t r ) 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c   S h o w V o t e 
 
 ( 
 
 @ U i d   i n t 
 
 ) 
 
 a s 
 
 b e g i n 
 
 s e l e c t   *   f r o m   Y X _ V o t e   w h e r e   y x _ v o i d t y p e = 0   a n d   Y X _ S e l l U s e r = @ U i d 
 
 e n d 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c e d u r e   U p C l a s s 
 
 ( 
 
 @ Y X _ I D   i n t 
 
 ) 
 
 a s 
 
 d e c l a r e   @ F _ P a r e n t I D   v a r c h a r ( 1 0 0 ) / * 6r~R{|* / 
 
 d e c l a r e   @ F _ P a t h   v a r c h a r ( 1 0 0 ) / * 6r~R{|_* / 
 
 d e c l a r e   @ F _ C h i l d   i n t / * 6r~R{|vC h i l d * / 
 
 d e c l a r e   @ F _ P r e v I D   i n t / * 6r~R{|vTm^R{|
N*NI D * / 
 
 d e c l a r e   @ F _ N e x t I D   i n t / * 6r~R{|vTm^R{|N*NI D * / 
 
 d e c l a r e   @ F _ O r d e r I D   i n t   / * 6r~R{|vc^I D * / 
 
 d e c l a r e   @ T e m p P a t h   v a r c h a r ( 1 0 0 )   / * 4Ne_* / 
 
 d e c l a r e   @ T e m p N u m   i n t   / * 4Nei n t W* / 
 
 d e c l a r e   @ F _ R o o t I D   i n t 
 
 s e l e c t     @ F _ P a r e n t I D = Y X _ P a r e n t I D , @ F _ P a t h = Y X _ P a r e n t P a t h , @ F _ C h i l d = Y X _ C h i l d , @ F _ R o o t I D = Y X _ R o o t I D , @ F _ P r e v I D = Y X _ P r e v I D , @ F _ N e x t I D = Y X _ N e x t I D 
 
 , @ F _ O r d e r I D = Y X _ O r d e r I D   f r o m   Y X _ p r o d u c t c l a s s   w h e r e   Y X _ I D = @ Y X _ I D 
 
 	 / * * ~b0R6r~R{|Nv@b	gR{|pev* * / 
 
                 d e c l a r e   @ F _ N e x t C l a s s P a t h   v a r c h a r ( 1 0 0 ) 
 
                 s e t   @ F _ N e x t C l a s s P a t h = @ F _ P a t h + ' , ' + C o n v e r t ( v a r c h a r ( 1 0 0 ) , @ Y X _ I D ) 
 
 	 d e c l a r e   @ F _ C h i l d N u m   i n t 
 
 	 s e l e c t   @ F _ C h i l d N u m = ( s e l e c t   c o u n t ( * )   f r o m   Y X _ P r o d u c t C l a s s   w h e r e   Y X _ P a r e n t P a t h   l i k e   @ F _ N e x t C l a s s P a t h + ' % '   a n d   Y X _ R o o t I D = @ F _ R o o t I D ) 
 
 	 s e t   @ F _ C h i l d N u m = @ F _ C h i l d N u m + 1 
 
 
 
 	 / * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * / 
 
 	 / * ~b0R6r~R{|vTm^R{|vOo`* / 
 
                 d e c l a r e   @ P r v _ P r e v I D   i n t 
 
                   d e c l a r e   @ P r v _ R o o t I D   i n t 
 
 i f   @ F _ P r e v I D > 0 
 
 	 b e g i n 
 
                                 / * R{|vvsQOo`* / 
 
                                 d e c l a r e   @ N e x t C l a s s P a t h   v a r c h a r ( 1 0 0 ) / * N^\R{|v_* / 
 
                         
 
                                 s e l e c t   @ N e x t C l a s s P a t h = Y X _ P a r e n t P a t h , @ P r v _ R o o t I D = Y X _ R o o t I D   f r o m   Y X _ P r o d u c t C l a s s   w h e r e   Y X _ I D = @ F _ P r e v I D 
 
                                 s e t   @ N e x t C l a s s P a t h = @ N e x t C l a s s P a t h + ' , ' + C o n v e r t ( v a r c h a r ( 1 0 0 ) , @ F _ P r e v I D ) 
 
 	 	 d e c l a r e   @ P r v _ C h i l d N u m   i n t   / * 
N*NR{|vpev* / 
 
 	 	 s e l e c t   @ P r v _ C h i l d N u m = ( s e l e c t   c o u n t ( * )   f r o m   Y X _ P r o d u c t C l a s s   w h e r e   Y X _ P a r e n t P a t h   l i k e   @ N e x t C l a s s P a t h + ' % '   a n d   Y X _ R o o t I D = @ P r v _ R o o t I D ) 
 
                                 / * BlQR{|v;`pe* / 
 
                                 s e t   @ P r v _ C h i l d N u m = @ P r v _ C h i l d N u m + 1 
 
                             
 
                                 ( s e l e c t   @ P r v _ P r e v I D = Y X _ P r e v I D   f r o m   Y X _ P r o d u c t C l a s s   w h e r e   Y X _ I D = @ F _ P r e v I D ) 
 
                                 
 
                                       / * O9eR{|vMOnT
NNvsQI D * / 
 
                                                 u p d a t e   Y X _ P r o d u c t C l a s s   s e t   Y X _ P r e v I D = @ Y X _ I D , Y X _ N e x t I D = @ F _ N e x t I D , 
 
                                                   Y X _ O r d e r I D = Y X _ O r d e r I D + @ F _ C h i l d N u m   w h e r e   Y X _ I D = @ F _ P r e v I D 
 
                                                         / * O9eR{|Nvc^I D * / 
 
                                                         u p d a t e   Y X _ P r o d u c t C l a s s   s e t   Y X _ O r d e r I D = Y X _ O r d e r I D + @ F _ C h i l d N u m   
 
                                                           w h e r e   Y X _ P a r e n t P a t h   l i k e   @ N e x t C l a s s P a t h + ' % '   a n d   Y X _ R o o t I D = @ P r v _ R o o t I D   
 
 	 	 	 / * * * * * * * * * * * * * * * * * * * * * * * * * / 
 
                                 / * * * * * * * * * * * * * * * * * / 
 
                                 / * * O9eR{|
N~R{|vn e x t I D * / 
 
                                 u p d a t e   Y X _ p r o d u c t c l a s s   s e t   Y X _ N e x t I D = @ Y X _ I D   w h e r e   Y X _ I D = @ P r v _ P r e v I D 
 
 
 
 	 	 	 / * O9enR{|I D * / 
 
 	 	 	 s e t   @ T e m p P a t h = @ F _ P a t h + ' , ' + C o n v e r t ( v a r c h a r ( 1 0 0 ) , @ Y X _ I D ) 
 
       	 	 	 u p d a t e   Y X _ P r o d u c t C l a s s   s e t   Y X _ P r e v I D = @ P r v _ P r e v I D , Y X _ N e x t I D = @ F _ P r e v I D , 
 
                                                 Y X _ O r d e r I D = Y X _ O r d e r I D - @ P r v _ C h i l d N u m   w h e r e   Y X _ I D = @ Y X _ I D 
 
                                                         / * O9eR{|Nvc^I D * / 
 
                                                 u p d a t e   Y X _ P r o d u c t C l a s s   s e t   Y X _ O r d e r I D = Y X _ O r d e r I D - @ P r v _ C h i l d N u m   
 
                                                 w h e r e   Y X _ P a r e n t P a t h   l i k e   @ T e m p P a t h + ' % '   a n d   Y X _ R o o t I D = @ F _ R o o t I D     
 
 	 	 	 / * * * * * * * * * * * * * / 
 
 	 	 i f   @ F _ N e x t I D   > 0 
 
 	 	 b e g i n 
 
                                     / * O9eN*Nv4N{|+RvP r e v I D * / 
 
                                 U p d a t e   Y X _ P r o d u c t C l a s s   s e t   Y X _ P r e v I D = @ F _ P r e v I D   w h e r e   Y X _ I D = @ F _ N e x t I D 
 
 
 
 	 	 e n d 
 
 	 	 
 
 	 e n d 
 
 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c e d u r e   U p N e w s C l a s s 
 
 ( 
 
 @ Y X _ I D   i n t 
 
 ) 
 
 a s 
 
 d e c l a r e   @ F _ P a r e n t I D   v a r c h a r ( 1 0 0 ) / * 6r~R{|* / 
 
 d e c l a r e   @ F _ P a t h   v a r c h a r ( 1 0 0 ) / * 6r~R{|_* / 
 
 d e c l a r e   @ F _ C h i l d   i n t / * 6r~R{|vC h i l d * / 
 
 d e c l a r e   @ F _ P r e v I D   i n t / * 6r~R{|vTm^R{|
N*NI D * / 
 
 d e c l a r e   @ F _ N e x t I D   i n t / * 6r~R{|vTm^R{|N*NI D * / 
 
 d e c l a r e   @ F _ O r d e r I D   i n t   / * 6r~R{|vc^I D * / 
 
 d e c l a r e   @ T e m p P a t h   v a r c h a r ( 1 0 0 )   / * 4Ne_* / 
 
 d e c l a r e   @ T e m p N u m   i n t   / * 4Nei n t W* / 
 
 d e c l a r e   @ F _ R o o t I D   i n t 
 
 s e l e c t     @ F _ P a r e n t I D = Y X _ P a r e n t I D , @ F _ P a t h = Y X _ P a r e n t P a t h , @ F _ C h i l d = Y X _ C h i l d , @ F _ R o o t I D = Y X _ R o o t I D , @ F _ P r e v I D = Y X _ P r e v I D , @ F _ N e x t I D = Y X _ N e x t I D 
 
 , @ F _ O r d e r I D = Y X _ O r d e r I D   f r o m   Y X _ N e w s C l a s s   w h e r e   Y X _ I D = @ Y X _ I D 
 
 	 / * * ~b0R6r~R{|Nv@b	gR{|pev* * / 
 
                 d e c l a r e   @ F _ N e x t C l a s s P a t h   v a r c h a r ( 1 0 0 ) 
 
                 s e t   @ F _ N e x t C l a s s P a t h = @ F _ P a t h + ' , ' + C o n v e r t ( v a r c h a r ( 1 0 0 ) , @ Y X _ I D ) 
 
 	 d e c l a r e   @ F _ C h i l d N u m   i n t 
 
 	 s e l e c t   @ F _ C h i l d N u m = ( s e l e c t   c o u n t ( * )   f r o m   Y X _ N e w s C l a s s   w h e r e   Y X _ P a r e n t P a t h   l i k e   @ F _ N e x t C l a s s P a t h + ' % '   a n d   Y X _ R o o t I D = @ F _ R o o t I D ) 
 
 	 s e t   @ F _ C h i l d N u m = @ F _ C h i l d N u m + 1 
 
 
 
 	 / * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * / 
 
 	 / * ~b0R6r~R{|vTm^R{|vOo`* / 
 
                 d e c l a r e   @ P r v _ P r e v I D   i n t 
 
                   d e c l a r e   @ P r v _ R o o t I D   i n t 
 
 i f   @ F _ P r e v I D > 0 
 
 	 b e g i n 
 
                                 / * R{|vvsQOo`* / 
 
                                 d e c l a r e   @ N e x t C l a s s P a t h   v a r c h a r ( 1 0 0 ) / * N^\R{|v_* / 
 
                         
 
                                 s e l e c t   @ N e x t C l a s s P a t h = Y X _ P a r e n t P a t h , @ P r v _ R o o t I D = Y X _ R o o t I D   f r o m   Y X _ N e w s C l a s s   w h e r e   Y X _ I D = @ F _ P r e v I D 
 
                                 s e t   @ N e x t C l a s s P a t h = @ N e x t C l a s s P a t h + ' , ' + C o n v e r t ( v a r c h a r ( 1 0 0 ) , @ F _ P r e v I D ) 
 
 	 	 d e c l a r e   @ P r v _ C h i l d N u m   i n t   / * 
N*NR{|vpev* / 
 
 	 	 s e l e c t   @ P r v _ C h i l d N u m = ( s e l e c t   c o u n t ( * )   f r o m   Y X _ N e w s C l a s s   w h e r e   Y X _ P a r e n t P a t h   l i k e   @ N e x t C l a s s P a t h + ' % '   a n d   Y X _ R o o t I D = @ P r v _ R o o t I D ) 
 
                                 / * BlQR{|v;`pe* / 
 
                                 s e t   @ P r v _ C h i l d N u m = @ P r v _ C h i l d N u m + 1 
 
                             
 
                                 ( s e l e c t   @ P r v _ P r e v I D = Y X _ P r e v I D   f r o m   Y X _ N e w s C l a s s   w h e r e   Y X _ I D = @ F _ P r e v I D ) 
 
                                 
 
                                       / * O9eR{|vMOnT
NNvsQI D * / 
 
                                                 u p d a t e   Y X _ N e w s C l a s s   s e t   Y X _ P r e v I D = @ Y X _ I D , Y X _ N e x t I D = @ F _ N e x t I D , 
 
                                                   Y X _ O r d e r I D = Y X _ O r d e r I D + @ F _ C h i l d N u m   w h e r e   Y X _ I D = @ F _ P r e v I D 
 
                                                         / * O9eR{|Nvc^I D * / 
 
                                                         u p d a t e   Y X _ N e w s C l a s s   s e t   Y X _ O r d e r I D = Y X _ O r d e r I D + @ F _ C h i l d N u m   
 
                                                           w h e r e   Y X _ P a r e n t P a t h   l i k e   @ N e x t C l a s s P a t h + ' % '   a n d   Y X _ R o o t I D = @ P r v _ R o o t I D   
 
 	 	 	 / * * * * * * * * * * * * * * * * * * * * * * * * * / 
 
                                 / * * * * * * * * * * * * * * * * * / 
 
                                 / * * O9eR{|
N~R{|vn e x t I D * / 
 
                                 u p d a t e   Y X _ N e w s C l a s s   s e t   Y X _ N e x t I D = @ Y X _ I D   w h e r e   Y X _ I D = @ P r v _ P r e v I D 
 
 
 
 	 	 	 / * O9enR{|I D * / 
 
 	 	 	 s e t   @ T e m p P a t h = @ F _ P a t h + ' , ' + C o n v e r t ( v a r c h a r ( 1 0 0 ) , @ Y X _ I D ) 
 
       	 	 	 u p d a t e   Y X _ N e w s C l a s s   s e t   Y X _ P r e v I D = @ P r v _ P r e v I D , Y X _ N e x t I D = @ F _ P r e v I D , 
 
                                                 Y X _ O r d e r I D = Y X _ O r d e r I D - @ P r v _ C h i l d N u m   w h e r e   Y X _ I D = @ Y X _ I D 
 
                                                         / * O9eR{|Nvc^I D * / 
 
                                                 u p d a t e   Y X _ N e w s C l a s s   s e t   Y X _ O r d e r I D = Y X _ O r d e r I D - @ P r v _ C h i l d N u m   
 
                                                 w h e r e   Y X _ P a r e n t P a t h   l i k e   @ T e m p P a t h + ' % '   a n d   Y X _ R o o t I D = @ F _ R o o t I D     
 
 	 	 	 / * * * * * * * * * * * * * / 
 
 	 	 i f   @ F _ N e x t I D   > 0 
 
 	 	 b e g i n 
 
                                     / * O9eN*Nv4N{|+RvP r e v I D * / 
 
                                 U p d a t e   Y X _ N e w s C l a s s   s e t   Y X _ P r e v I D = @ F _ P r e v I D   w h e r e   Y X _ I D = @ F _ N e x t I D 
 
 
 
 	 	 e n d 
 
 	 	 
 
 	 e n d 
 
 
 
 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   p r o c   U p P r o d u c t D Z 
 
 @ P r o _ D Z   v a r c h a r ( 5 0 ) 
 
 a s 
 
 u p d a t e   Y X _ P r o d u c t   s e t   Y X _ P r o D Z = ( Y X _ P r o D Z + ' , ' + @ P r o _ D Z ) 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   p r o c   U p d a t e S h o p b a s e 
 
 ( 
 
 @ Y X _ S h o p N a m e   v a r c h a r ( 5 0 ) , 
 
 @ Y X _ S h o p C l a s s   i n t , 
 
 @ Y X _ S h o p P r o j e c t   v a r c h a r ( 6 0 ) , 
 
 @ Y X _ S h o p C o n t e n t   v a r c h a r ( 3 0 0 0 ) , 
 
 @ Y X _ S H O P U s e r I D   i n t , 
 
 @ Y X _ S H O P P i n P a i     i n t 
 
 ) 
 
   a s 
 
 u p d a t e   Y X _ S h o p   s e t   Y X _ S h o p N a m e = @ Y X _ S h o p N a m e , Y X _ S h o p C l a s s = @ Y X _ S h o p C l a s s , Y X _ S h o p P r o j e c t = @ Y X _ S h o p P r o j e c t , Y X _ S h o p C o n t e n t = @ Y X _ S h o p C o n t e n t , Y X _ S H O P P i n P a i   = @ Y X _ S H O P P i n P a i     w h e r e   Y X _ S H O P U s e r I D = @ Y X _ S H O P U s e r I D 
 
 
 
 ~ 
 
 
 
 
 
 / * - - - - - - - - - - - mReS- - - - - - - - - - * / 
 
 C R E A T E   p r o c e d u r e   Y X _ C M S A d d C h a n n e l   
 
 @ Y X _ C h a n n e l N a m e     v a r c h a r ( 5 0 ) ,                         / * S
Ty* / 
 
 @ Y X _ C h a n n e l E x c     v a r c h a r ( 1 0 0 ) ,                       / * Slʑ* / 
 
 @ Y X _ C h a n n e l T y p e     i n t ,                                   / * S{|W* / 
 
 @ Y X _ C h a n n e l M o d e   i n t ,                                   / * SeHh* / 
 
 @ Y X _ C h a n n e l D i r   v a r c h a r ( 5 0 ) ,                 / * SeN9Y* / 
 
 @ Y X _ C h a n n e l S t a t   i n t ,                               / * Sr`* / 
 
 @ Y X _ C h a n n e l U r l   v a r c h a r ( 5 0 ) ,           / * Yޏc0W@W* / 
 
 @ Y X _ T e m p l a t e   i n t 
 
 a s 
 
 
 
 i n s e r t   i n t o   Y X _ C h a n n e l   ( Y X _ C h a n n e l N a m e , Y X _ C h a n n e l E x c , Y X _ C h a n n e l T y p e , Y X _ C h a n n e l M o d e , Y X _ C h a n n e l D i r , Y X _ C h a n n e l S t a t , Y X _ C h a n n e l U r l , Y X _ T e m p l a t e ) 
 
 v a l u e s   ( @ Y X _ C h a n n e l N a m e , @ Y X _ C h a n n e l E x c , @ Y X _ C h a n n e l T y p e , @ Y X _ C h a n n e l M o d e , @ Y X _ C h a n n e l D i r , @ Y X _ C h a n n e l S t a t , @ Y X _ C h a n n e l U r l , @ Y X _ T e m p l a t e ) 
 
 
 
 
 
 ~ 
 
 
 
 
 
 
 
 C R E A T E   p r o c e d u r e   Y X _ P a g e r L i s t 
 
 ( 
 
         @ t b l N a m e                   v a r c h a r ( 2 5 5 ) ,                             - -   h
T
 
         @ f l d N a m e                   v a r c h a r ( 2 5 5 ) ,                             - -   ;N.W[k
T
 
         @ P a g e S i z e                 i n t   =   1 0 ,                                           - -   u:\[
 
         @ P a g e I n d e x               i n t   =   1 ,                                               - -   ux
 
         @ I s R e C o u n t               i n t   =   0 ,                                               - -   ԏVU_;`pe,   ^0   <PRԏV
 
         @ O r d e r T y p e               i n t   =   0 ,                                               - -   nc^{|W,   ^0   <PRM^
 
         @ s t r W h e r e                 v a r c h a r ( 5 0 0 0 )   =   ' ' ,             - -   gagN( la:   
NRw h e r e ) 
 
         @ o r d e r f l d                 v a r c h a r ( 2 5 5 0 ) , 
 
         @ c o l n a m e                   v a r c h a r ( 5 0 0 0 ) = ' * '               - - gQegvW[k
 
 ) 
 
 A S 
 
 b e g i n 
 
                 d e c l a r e   @ s t r S Q L       v a r c h a r ( 5 0 0 0 )                 - -   ;NS
 
 	 d e c l a r e   @ s t r T m p       v a r c h a r ( 1 0 0 0 )                     - -   4NeSϑ
 
 	 d e c l a r e   @ s t r O r d e r   v a r c h a r ( 4 0 0 0 )                     - -   c^{|W
 
 	 d e c l a r e   @ s t r O r d e r 2   v a r c h a r ( 4 0 0 0 )                 - - - P[c^
 
 
 
 	 i f   @ O r d e r T y p e   ! =   0 
 
 	 b e g i n 
 
 	 	 i f   l e n ( @ o r d e r f l d )   =   0 
 
 	 	 	 b e g i n 
 
 	 	 	 	 s e t   @ o r d e r f l d   =   @ f l d N a m e 
 
 	 	 	 e n d 
 
 	 	 i f     @ o r d e r f l d = @ f l d N a m e 
 
 	 	 b e g i n 
 
 	 	 	 s e t   @ s t r T m p   =   ' < ( s e l e c t   m i n ' 
 
 	 	 	 s e t   @ s t r O r d e r   =   '   o r d e r   b y   [ '   +   @ o r d e r f l d   + ' ]   d e s c ' 
 
 	 	 e n d   
 
 	 	 e l s e 
 
 	 	 b e g i n 
 
 	 	 	 s e t   @ s t r T m p   =   ' < = ( s e l e c t   m i n ' 
 
 	 	 	 s e t   @ s t r O r d e r   =   '   o r d e r   b y   [ '   +   @ o r d e r f l d   + ' ]   d e s c , [ ' + @ f l d N a m e + ' ]   d e s c ' 
 
 	 	 e n d   
 
 	 	 s e t   @ s t r O r d e r 2   =   '   o r d e r   b y   [ '   +   @ o r d e r f l d   + ' ]   d e s c , [ ' + @ f l d N a m e + ' ]   a s c ' 
 
 	 e n d 
 
 	 e l s e 
 
 	 b e g i n 
 
 	 	 
 
 	 	 i f     @ o r d e r f l d = @ f l d N a m e 
 
 	 	 b e g i n 
 
 	 	           s e t   @ s t r T m p   =   ' > ( s e l e c t   m a x ' 
 
 	 	           s e t   @ s t r O r d e r   =   '   o r d e r   b y   [ '   +   @ o r d e r f l d   + ' ]   a s c ' 	 
 
 	 	 e n d     
 
 	 	 e l s e 
 
 	 	 b e g i n 
 
 	 	           s e t   @ s t r T m p   =   ' > = ( s e l e c t   m a x ' 
 
 	 	           s e t   @ s t r O r d e r   =   '   o r d e r   b y   [ '   +   @ o r d e r f l d   + ' ]   a s c , [ ' + @ f l d N a m e + ' ]   a s c ' 
 
 	 	 e n d   
 
 	 	 s e t   @ s t r O r d e r 2   =   '   o r d e r   b y   [ '   +   @ o r d e r f l d   + ' ]   a s c , [ ' + @ f l d N a m e + ' ]   d e s c ' 
 
 	 e n d 
 
             
 
 	 i f   @ c o l n a m e = ' ' 
 
 	 b e g i n 
 
 	 	 s e t   @ c o l n a m e = ' * ' 
 
 	 e n d   
 
 
 
 
 
 
 
 
 
 
 
 	 i f   @ o r d e r f l d ! = @ f l d N a m e   
 
 	 b e g i n 	 	 
 
 
 
 	 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   +   '     ' + @ c o l n a m e + '     f r o m   [ ' 
 
 	 	 +   @ t b l N a m e   +   ' ]   w h e r e   [ '   +   @ o r d e r f l d   +   ' ] '   +   @ s t r T m p   +   ' ( [ ' 
 
 	 	 +   @ o r d e r f l d   +   ' ] )   f r o m   ( s e l e c t   t o p   '   +   s t r ( ( @ P a g e I n d e x - 1 ) * @ P a g e S i z e )   +   '   [ ' 
 
 	 	 +   @ o r d e r f l d   +   ' ]   f r o m   [ '   +   @ t b l N a m e   +   ' ] '   +   @ s t r O r d e r   +   ' )   a s   t b l T m p ) ' 
 
 	 	 +   ' a n d     ' + @ f l d N a m e + '   n o t   i n ' 
 
 	 	 +   ' ( s e l e c t   t o p   '   +   s t r ( ( @ P a g e I n d e x - 1 ) * @ P a g e S i z e )   +   '   [ ' + @ f l d N a m e + ' ]   f r o m   [ ' + @ t b l N a m e + ' ]   ' + @ s t r O r d e r 2 + ' ) ' 
 
 	 	 +   @ s t r O r d e r 2 
 
 
 
 	 i f   @ s t r W h e r e   ! =   ' ' 
 
 	 	 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   +   '     ' + @ c o l n a m e + '     f r o m   [ ' 
 
 	 	 	 +   @ t b l N a m e   +   ' ]   w h e r e   [ '   +   @ f l d N a m e   +   ' ] '   +   @ s t r T m p   +   ' ( [ ' 
 
 	 	 	 +   @ f l d N a m e   +   ' ] )   f r o m   ( s e l e c t   t o p   '   +   s t r ( ( @ P a g e I n d e x - 1 ) * @ P a g e S i z e )   +   '   [ ' 
 
 	 	 	 +   @ f l d N a m e   +   ' ]   f r o m   [ '   +   @ t b l N a m e   +   ' ]   w h e r e   '   +   @ s t r W h e r e   +   '   ' 
 
 	 	 	 +   @ s t r O r d e r   +   ' )   a s   t b l T m p )   a n d   '   +   @ s t r W h e r e   +   '   '   +   @ s t r O r d e r 
 
 	 e n d   
 
 	 e l s e 
 
 	 b e g i n 
 
 	 	 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   +   '   *   f r o m   [ ' 
 
 	 	 +   @ t b l N a m e   +   ' ]   w h e r e   [ '   +   @ f l d N a m e   +   ' ] '   +   @ s t r T m p   +   ' ( [ ' 
 
 	 	 +   @ f l d N a m e   +   ' ] )   f r o m   ( s e l e c t   t o p   '   +   s t r ( ( @ P a g e I n d e x - 1 ) * @ P a g e S i z e )   +   '   [ ' 
 
 	 	 +   @ f l d N a m e   +   ' ]   f r o m   [ '   +   @ t b l N a m e   +   ' ] '   +   @ s t r O r d e r   +   ' )   a s   t b l T m p ) ' 
 
 	 	 +   @ s t r O r d e r 
 
 
 
 	 	 i f   @ s t r W h e r e   ! =   ' ' 
 
 	 	 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   +   '   *   f r o m   [ ' 
 
 	 	 	 +   @ t b l N a m e   +   ' ]   w h e r e   [ '   +   @ f l d N a m e   +   ' ] '   +   @ s t r T m p   +   ' ( [ ' 
 
 	 	 	 +   @ f l d N a m e   +   ' ] )   f r o m   ( s e l e c t   t o p   '   +   s t r ( ( @ P a g e I n d e x - 1 ) * @ P a g e S i z e )   +   '   [ ' 
 
 	 	 	 +   @ f l d N a m e   +   ' ]   f r o m   [ '   +   @ t b l N a m e   +   ' ]   w h e r e   '   +   @ s t r W h e r e   +   '   ' 
 
 	 	 	 +   @ s t r O r d e r   +   ' )   a s   t b l T m p )   a n d   '   +   @ s t r W h e r e   +   '   '   +   @ s t r O r d e r 
 
 
 
 	 e n d   
 
 
 
 	 s e t   @ s t r T m p   = ' ' 
 
 	 i f   @ s t r W h e r e   ! =   ' ' 
 
 	 	 s e t   @ s t r T m p   =   '   w h e r e   '   +   @ s t r W h e r e 
 
 
 
 	 i f   @ P a g e I n d e x   =   1 
 
 	 b e g i n 
 
 	 	 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   +   '     ' + @ c o l n a m e + '     f r o m   [ ' 
 
 	 	 	 +   @ t b l N a m e   +   ' ] '   +   @ s t r T m p   +   '   '   +   @ s t r O r d e r 
 
 	 e n d 
 
 
 
 	 i f   @ I s R e C o u n t   ! =   0 
 
 	 	 s e t   @ s t r S Q L   =   ' s e l e c t   c o u n t ( ' +   @ f l d N a m e   + ' )   a s   T o t a l   f r o m   [ '   +   @ t b l N a m e   +   ' ] ' +   @ s t r T m p 
 
 	 	 
 
 
 
 	   
 
 	 e x e c   ( @ s t r S Q L ) 
 
 p r i n t   @ s t r S Q L 
 
 e n d 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P R O C E D U R E   p a g i n a t i o n 
 
 @ t b l N a m e   v a r c h a r ( 2 5 5 ) ,   - -   h
T  
 
 @ s t r G e t F i e l d s   v a r c h a r ( 1 0 0 0 )   =   ' * ' ,   - -    ԏVvR  
 
 @ f l d N a m e   v a r c h a r ( 2 5 5 ) = ' ' ,   - -   I D vW[k
T  
 
 @ f l d o r d e r N a m e   v a r c h a r ( 2 5 5 ) = ' ' ,   - -   c^vW[k
T  
 
 @ P a g e S i z e   i n t   =   1 0 ,   - -   u:\[  
 
 @ P a g e I n d e x   i n t   =   1 ,   - -   ux  
 
 @ d o C o u n t   b i t   =   0 ,   - -   ԏVU_;`pe,   ^  0   <PRԏV  
 
 @ O r d e r T y p e   b i t   =   0 ,   - -   nc^{|W,   ^  0   <PRM^  
 
 @ s t r W h e r e   v a r c h a r ( 1 5 0 0 )   =   ' '   - -   gagN  ( la:   
NR  w h e r e )   
 
 A S   
 
 d e c l a r e   @ s t r S Q L   v a r c h a r ( 5 0 0 0 )   - -   ;NS  
 
 d e c l a r e   @ s t r T m p   v a r c h a r ( 1 1 0 )   - -   4NeSϑ  
 
 d e c l a r e   @ s t r O r d e r   v a r c h a r ( 4 0 0 )   - -   c^{|Wi d   
 
 d e c l a r e   @ s t r O r d e r n a m e   v a r c h a r ( 4 0 0 ) - -   c^W[k
 
 i f   @ d o C o u n t   ! =   0   
 
 b e g i n   
 
 i f   @ s t r W h e r e   ! = ' '   
 
 s e t   @ s t r S Q L   =   ' s e l e c t   c o u n t ( * )   a s   T o t a l   f r o m   [ '   +   @ t b l N a m e   +   ' ]   w h e r e   ' + @ s t r W h e r e   
 
 e l s e   
 
 s e t   @ s t r S Q L   =   ' s e l e c t   c o u n t ( * )   a s   T o t a l   f r o m   [ '   +   @ t b l N a m e   +   ' ] ' 
 
 e n d   
 
 - - N
NNxva`/fYg@ d o C o u n t  OǏegv
N/f0 1\gbL;`pe~0NNv@b	gNx/f@ d o C o u n t :N0 v`Q  
 
 
 
 e l s e   
 
 b e g i n   
 
 i f   @ O r d e r T y p e   ! =   0   
 
 b e g i n   
 
 s e t   @ s t r T m p   =   ' < ( s e l e c t   m i n '   
 
 s e t   @ s t r O r d e r   =   '   o r d e r   b y   [ '   +   @ f l d N a m e   + ' ]   d e s c '   
 
 - - Yg@ O r d e r T y p e 
N/f0 1\gbLM^ُS_͑  
 
 e n d   
 
 
 
 e l s e   
 
 b e g i n   
 
 s e t   @ s t r T m p   =   ' > ( s e l e c t   m a x '   
 
 s e t   @ s t r O r d e r   =   '   o r d e r   b y   [ '   +   @ f l d N a m e   + ' ]   a s c '   
 
 e n d   
 
 i f   @ P a g e I n d e x   =   1   
 
 b e g i n   
 
 i f   @ s t r W h e r e   ! =   ' '   
 
 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   + '   ' + @ s t r G e t F i e l d s +   '   f r o m   [ '   +   @ t b l N a m e   +   ' ]   w h e r e   '   +   @ s t r W h e r e   +   '   '   +   @ s t r O r d e r   
 
 e l s e   
 
 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   + '   ' + @ s t r G e t F i e l d s +   '   f r o m   [ ' +   @ t b l N a m e   +   ' ]   ' +   @ s t r O r d e r   
 
 - - Yg/f,{ Nu1\gbLN
NNxُ7hOR_gbL^  
 
 e n d   
 
 
 
 e l s e   
 
 b e g i n   
 
 - - NNNxKNN@ s t r S Q L NwckgbLvS Q L Nx  
 
 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   + '   ' + @ s t r G e t F i e l d s +   '   f r o m   [ '   
 
 +   @ t b l N a m e   +   ' ]   w h e r e   [ '   +   @ f l d N a m e   +   ' ] '   +   @ s t r T m p   +   ' ( [ ' +   @ f l d N a m e   +   ' ] )   f r o m   ( s e l e c t   t o p   '   +   s t r ( ( @ P a g e I n d e x - 1 ) * @ P a g e S i z e )   +   '   [ ' +   @ f l d N a m e   +   ' ]   f r o m   [ '   +   @ t b l N a m e   +   ' ] '   +   @ s t r O r d e r   +   ' )   a s   t b l T m p ) ' +   @ s t r O r d e r   
 
 i f   @ s t r W h e r e   ! =   ' '   
 
 s e t   @ s t r S Q L   =   ' s e l e c t   t o p   '   +   s t r ( @ P a g e S i z e )   + '   ' + @ s t r G e t F i e l d s +   '   f r o m   [ '   
 
 +   @ t b l N a m e   +   ' ]   w h e r e   [ '   +   @ f l d N a m e   +   ' ] '   +   @ s t r T m p   +   ' ( [ '   
 
 +   @ f l d N a m e   +   ' ] )   f r o m   ( s e l e c t   t o p   '   +   s t r ( ( @ P a g e I n d e x - 1 ) * @ P a g e S i z e )   +   '   [ '   
 
 +   @ f l d N a m e   +   ' ]   f r o m   [ '   +   @ t b l N a m e   +   ' ]   w h e r e   '   +   @ s t r W h e r e   +   '   '   
 
 +   @ s t r O r d e r   +   ' )   a s   t b l T m p )   a n d   '   +   @ s t r W h e r e   +   '   '   +   @ s t r O r d e r   
 
 e n d   
 
 e n d   
 
 p r i n t   @ s t r S Q L 
 
 e x e c   ( @ s t r S Q L ) 
 
 
 
 ~ 
 
 
 
 
 
 C R E A T E   P r o c e d u r e   u p d a t e p a i p a i 
 
 ( 
 
 @ y x _ p r o i d   i n t , 
 
 @ y x _ r e u s e r c j     f l o a t , 
 
 @ p a i p a i i d   i n t 
 
 ) 
 
 a s 
 
 b e g i n 
 
 d e c l a r e   @ s t r s q l   v a r c h a r ( 1 0 0 0 ) 
 
 d e c l a r e   @ s t r s q l 2   v a r c h a r ( 2 0 0 ) 
 
 d e c l a r e   @ s t r s q l 3   v a r c h a r ( 2 0 0 ) 
 
 
 
 s e t   @ s t r s q l = ' i n s e r t   i n t o   y x _ o r d e r f o r m ( y x _ o r d e r f o r m i d , y x _ p r o i d , y x _ p r o n a m e , y x _ u s e r i d , y x _ r e u s e r i d , y x _ s u m c o u n t , y x _ s u m p r i c e , y x _ o r d e r s t a r t , y x _ o r d e r d a t e , y x _ r g o o d s u s e r , y x _ u s e r p r o m o b l e , y x _ r g o o d s t e l , y x _ r g o o d s a d d r , y x _ r g o o d s c o d e , Y X _ D G o o d s T y p e , y x _ d g o o d s p r i c e )   s e l e c t   t o p   1     y x _ o r d e r f o r m i d , Y X _ p r o i d , Y X _ p r o n a m e , Y X _ u s e r i d , Y X _ r e u s e r i d , y x _ s u m c o u n t , Y X _ r e u s e r c j , y x _ o r d e r s t a r t , Y X _ a d d d a t e , Y X _ R G o o d s U s e r , y x _ u s e r p r o m o b l e , Y X _ R G o o d s T e l , Y X _ R G o o d s A d d r , Y X _ R G o o d s C o d e , Y X _ D G o o d s T y p e , Y X _ D G o o d s P r i c e   f r o m   y x _ p a i p a i   w h e r e   y x _ p r o i d = ' + s t r ( @ y x _ p r o i d ) + '   o r d e r   b y   y x _ r e u s e r c j   d e s c ' 
 
 e x e c ( @ s t r s q l ) 
 
 
 
 s e t   @ s t r s q l 2 = ' u p d a t e   y x _ p a i p a i   s e t   Y X _ o k = 1 , y x _ j s d a t e = g e t d a t e ( ) , y x _ p a i m a i z t = 2   w h e r e     y x _ p r o i d = ' + s t r ( @ y x _ p r o i d ) + '     a n d   y x _ i d = ' + s t r ( @ p a i p a i i d ) + ' ' 
 
 p r i n t   @ s t r s q l 2 
 
 e x e c ( @ s t r s q l 2 ) 
 
 
 
 s e t   @ s t r s q l 3 = ' u p d a t e   y x _ p a i p a i   s e t   Y X _ o k = 1 , y x _ j s d a t e = g e t d a t e ( ) , y x _ p a i m a i z t = 1   w h e r e     y x _ p r o i d = ' + s t r ( @ y x _ p r o i d ) + '   a n d   y x _ i d < > ' + s t r ( @ p a i p a i i d ) + ' ' 
 
 e x e c ( @ s t r s q l 3 ) 
 
 e n d 
 
 
 
 ~ 
 
 
 
 C R E A T E   P r o c e d u r e   P r o _ S h o w B u y P r o d u c t 
 
 ( 
 
 @ i d   i n t 
 
 ) 
 
 a s 
 
 s e l e c t   *   f r o m   y x _ b u y p r o d u c t   w h e r e   y x _ i d = @ i d 
 
 