ÿþu s e " x c o n t r o l . v f r a m e . v b u s i n e s s . v d "
|
u s e " x b a s e . v f r a m e . v b u s i n e s s . v d "
|
u s e " b a s e . v i e w . v d "
|
u s e " p u b l i c c o d e . v u t i l . v b u s i n e s s . v d "
|
|
u n i t t r a d e
|
[
|
n a m e s p a c e _ e x c e l f o r o l e " E x c e l . A p p l i c a t i o n , { 0 0 0 2 0 8 1 3 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } " ;
|
|
c l a s s c e x c e l : p u b l i c x n a t i v e n a t i v e f r o m " X C o n t r o l . d l l "
|
{
|
v o i d R e l e a s e ( i n t t ) a l i a s " ? R e l e a s e @ C E x c e l A p p l i c a t i o n @ @ Q A E X P A V 1 @ @ Z " ;
|
s t a t i c i n t C r e a t e I n s t a n c e ( ) a l i a s " ? C r e a t e I n s t a n c e @ C E x c e l A p p l i c a t i o n @ @ S A P A V 1 @ X Z " ;
|
v o i d p u t _ V i s i b l e ( b o o l t ) a l i a s " ? p u t _ V i s i b l e @ C E x c e l A p p l i c a t i o n @ @ Q A E X H @ Z " ;
|
b o o l g e t _ V i s i b l e ( ) a l i a s " ? g e t _ V i s i b l e @ C E x c e l A p p l i c a t i o n @ @ Q A E H X Z " ;
|
v o i d O p e n D o c u m e n t ( c o n s t s t r i n g f i l e n a m e ) a l i a s " ? O p e n D o c u m e n t @ C E x c e l A p p l i c a t i o n @ @ Q A E X Q A _ W @ Z " ;
|
v o i d T r a n s S h a p e ( ) a l i a s " ? T r a n s S h a p e @ C E x c e l A p p l i c a t i o n @ @ Q A E X X Z " ;
|
v o i d S a v e T o F i l e ( s t r i n g f i l e n a m e ) a l i a s " ? S a v e T o F i l e @ C E x c e l A p p l i c a t i o n @ @ Q A E X Q A _ W @ Z " ;
|
v o i d Q u i t ( ) a l i a s " ? Q u i t @ C E x c e l A p p l i c a t i o n @ @ Q A E X X Z " ;
|
} ;
|
|
s t r u c t O P E N F I L E N A M E W
|
{
|
u n s i g n e d i n t l S t r u c t S i z e ;
|
u n s i g n e d i n t h w n d O w n e r ;
|
u n s i g n e d i n t h I n s t a n c e ;
|
s t r i n g l p s t r F i l t e r ;
|
|
s t r i n g l p s t r C u s t o m F i l t e r ;
|
u n s i g n e d i n t n M a x C u s t F i l t e r ;
|
u n s i g n e d i n t n F i l t e r I n d e x ;
|
s t r i n g l p s t r F i l e ;
|
|
u n s i g n e d i n t n M a x F i l e ;
|
s t r i n g l p s t r F i l e T i t l e ;
|
u n s i g n e d i n t n M a x F i l e T i t l e ;
|
s t r i n g l p s t r I n i t i a l D i r ;
|
|
s t r i n g l p s t r T i t l e ;
|
u n s i g n e d i n t F l a g s ;
|
u n s i g n e d s h o r t n F i l e O f f s e t ;
|
u n s i g n e d s h o r t n F i l e E x t e n s i o n ;
|
s t r i n g l p s t r D e f E x t ;
|
|
u n s i g n e d i n t l C u s t D a t a ;
|
u n s i g n e d i n t l p f n H o o k ;
|
s t r i n g l p T e m p l a t e N a m e ;
|
|
/ / _ W I N 3 2 _ W I N N T > = 0 x 0 5 0 0
|
u n s i g n e d i n t p v R e s e r v e d ;
|
u n s i g n e d i n t d w R e s e r v e d ;
|
u n s i g n e d i n t F l a g s E x ;
|
/ / ( _ W I N 3 2 _ W I N N T > = 0 x 0 5 0 0 )
|
} ;
|
|
c l a s s E x p o r t e r
|
{
|
c e x c e l e x c e l ;
|
|
|
s t a t i c s t d c a l l i n t G e t M o d u l e F i l e N a m e ( i n t h M o d u l e , s t r i n g l p F i l e N a m e , i n t n S i z e ) n a t i v e f r o m " k e r n e l 3 2 . d l l " a l i a s " G e t M o d u l e F i l e N a m e W " ;
|
s t a t i c s t d c a l l i n t P a t h R e m o v e F i l e S p e c ( s t r i n g l p F i l e N a m e ) n a t i v e f r o m " s h l w a p i . d l l " a l i a s " P a t h R e m o v e F i l e S p e c W " ;
|
s t a t i c s t d c a l l i n t D e l e t e F i l e ( s t r i n g l p F i l e N a m e ) n a t i v e f r o m " k e r n e l 3 2 . d l l " a l i a s " D e l e t e F i l e W " ;
|
s t a t i c s t d c a l l b o o l G e t S a v e F i l e N a m e ( r e f O P E N F I L E N A M E W ) n a t i v e f r o m " c o m d l g 3 2 . d l l " a l i a s " G e t S a v e F i l e N a m e W " ;
|
|
s t r i n g G e t M o d u l e P a t h ( )
|
{
|
s t r i n g s t r = " " ;
|
s t r = s t r . s p a c e ( 2 5 5 ) ;
|
G e t M o d u l e F i l e N a m e ( 0 , s t r , 2 5 0 ) ;
|
P a t h R e m o v e F i l e S p e c ( s t r ) ;
|
r e t u r n s t r ;
|
}
|
s t r i n g G e t M o d u l e T m p P a t h ( )
|
{
|
s t r i n g s t r = " " ;
|
s t r = s t r . s p a c e ( 2 5 5 ) ;
|
G e t M o d u l e F i l e N a m e ( 0 , s t r , 2 5 0 ) ;
|
P a t h R e m o v e F i l e S p e c ( s t r ) ;
|
s t r i n g t m p = s t r + " \ \ T e m p " ;
|
x a s e r v e r : : C r e a t e D i r e c t o r y ( t m p ) ;
|
r e t u r n t m p ;
|
}
|
|
s t r i n g G e t S a v e F i l e N a m e ( s t r i n g i n i t F i l e N a m e , s t r i n g f i l t e r , s t r i n g e x t )
|
{
|
c h a r [ ] s z F i l e N a m e = n e w c h a r [ 2 5 5 ] ;
|
c h a r [ ] s z P a t h = n e w c h a r [ 2 5 5 ] ;
|
s z F i l e N a m e [ 0 ] = 0 ;
|
s z P a t h [ 0 ] = 0 ;
|
|
i f ( i n i t F i l e N a m e ! = " " )
|
{
|
i n t l e n = i n i t F i l e N a m e . l e n g t h ( ) ;
|
c h a r [ ] t m p = i n i t F i l e N a m e ;
|
f o r ( i n t i = 0 ; i < l e n + 1 ; i + + )
|
{
|
/ / s z F i l e N a m e [ i ] = t m p [ i ] ;
|
s z P a t h [ i ] = t m p [ i ] ;
|
}
|
}
|
|
i n t n F i l t e r I n d e x = 1 ;
|
r e f O P E N F I L E N A M E W o f n = n e w O P E N F I L E N A M E W ;
|
|
o f n . l S t r u c t S i z e = 8 8 ; / / s i z e o f ( o f n ) ;
|
o f n . h w n d O w n e r = 0 ;
|
o f n . h I n s t a n c e = 0 ;
|
o f n . l p s t r F i l t e r = f i l t e r ;
|
/ / " J P E G eöN( * . j p g ) \ 0 * . j p g ; * . j p e g ; * . p n g ; * . g i f ; * . b m p \ 0 hQèeöN( * . * ) \ 0 * . * \ 0 " ;
|
o f n . l p s t r C u s t o m F i l t e r = 0 ;
|
o f n . n M a x C u s t F i l t e r = 0 ;
|
o f n . n F i l t e r I n d e x = n F i l t e r I n d e x ;
|
o f n . l p s t r F i l e = s z P a t h ;
|
o f n . n M a x F i l e = 2 5 5 ;
|
o f n . l p s t r F i l e T i t l e = s z F i l e N a m e ;
|
o f n . n M a x F i l e T i t l e = 2 5 5 ;
|
o f n . l p s t r T i t l e = " ÷c[eöN T" ;
|
o f n . l p s t r D e f E x t = e x t ;
|
/ / " j p g " ;
|
o f n . l p s t r I n i t i a l D i r = 0 ;
|
o f n . F l a g s = 0 x 0 0 0 0 0 0 1 0 / * O F N _ S H O W H E L P * / | 0 x 0 0 0 0 1 0 0 0 / * O F N _ F I L E M U S T E X I S T * / ;
|
o f n . l C u s t D a t a = 0 ;
|
o f n . l p f n H o o k = 0 ;
|
o f n . l p T e m p l a t e N a m e = 0 ;
|
|
/ / d e b u g b r e a k ( ) ;
|
i f ( G e t S a v e F i l e N a m e ( o f n ) )
|
{
|
d e l e t e o f n ;
|
r e t u r n s z P a t h ;
|
}
|
e l s e
|
{
|
r e t u r n " " ;
|
}
|
}
|
|
s t r i n g g e t f i l e P a t h ( )
|
{
|
s t r i n g p a t h = G e t M o d u l e P a t h ( ) + " \ \ r e s o u r c e \ \ i m a g e " ;
|
r e t u r n p a t h ;
|
}
|
|
i n t O n E x p o r t ( i n t h W n d , s t r i n g h t m l S t r )
|
{
|
s t r i n g p r e = " !kúQ'°eÁTß~¡h" ;
|
s t r i n g f i l e = G e t S a v e F i l e N a m e ( p r e + " . x l s x " ,
|
" E x c e l eöN( * . x l s x ) \ 0 * . x l s x ; * . x l s \ 0 E x c e l 9 7 eöN( * . x l s ) \ 0 * . x l s \ 0 P D F eöN( * . p d f ) \ 0 * . p d f \ 0 " ,
|
" x l s x " ) ;
|
i f ( f i l e = = " " ) r e t u r n 1 ;
|
|
i f ( w i n 3 2 : : P a t h F i l e E x i s t s ( f i l e ) )
|
{
|
i n t r e s = w i n 3 2 : : M e s s a g e B o x ( h W n d , " eöNò]Ï~X[(W ÿ/f&TÖv? " , " Ðc:y" , 4 ) ;
|
i f ( r e s ! = 6 ) r e t u r n 1 ;
|
}
|
|
x u t i l : : S a v e T o F i l e ( f i l e , h t m l S t r , " " , " " , " " ) ;
|
|
r e t u r n 1 ;
|
|
t r a c e ( " \ r \ n l i n k e x c e l " ) ;
|
e x c e l = n e w c e x c e l ;
|
i n t h e x c e l = c e x c e l : : C r e a t e I n s t a n c e ( ) ;
|
e x c e l . s e t N a t i v e P o i n t e r ( h e x c e l ) ;
|
i f ( h e x c e l = = 0 )
|
{
|
w i n 3 2 : : a l e r t ( " NýÞ¥cE x c e l " ) ;
|
r e t u r n 1 ;
|
}
|
|
s t r i n g g i d = p u b l i c c o d e : : G e t G u i d ( ) ;
|
s t r i n g f i l e n a m e = p r e + " _ . h t m " ;
|
x u t i l : : S a v e T o F i l e ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + f i l e n a m e , h t m l S t r , " " , " " , " " ) ;
|
t r a c e ( " \ r \ n e x c e l t o o p e n " ) ;
|
e x c e l . O p e n D o c u m e n t ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + f i l e n a m e ) ;
|
t r a c e ( " \ r \ n t r a n s s h a p e " ) ;
|
/ / e x c e l . p u t _ V i s i b l e ( t r u e ) ;
|
/ / e x c e l . T r a n s S h a p e ( ) ;
|
t r a c e ( " \ r \ n s a v e t o t m p e x c e l f i l e " ) ;
|
i f ( f i l e . f i n d ( " . x l s " ) )
|
{
|
i f ( w i n 3 2 : : P a t h F i l e E x i s t s ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + p r e + " _ . x l s " ) )
|
D e l e t e F i l e ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + p r e + " _ . x l s " ) ;
|
e x c e l . S a v e T o F i l e ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + p r e + " _ . x l s " ) ;
|
/ / a l e r t ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + p r e + m _ E n t i t y N o + " _ . x l s " ) ;
|
}
|
e l s e
|
{
|
i f ( w i n 3 2 : : P a t h F i l e E x i s t s ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + p r e + " _ . x l s x " ) )
|
D e l e t e F i l e ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + p r e + " _ . x l s x " ) ;
|
e x c e l . S a v e T o F i l e ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + p r e + " _ . x l s x " ) ;
|
}
|
|
t r a c e ( " \ r \ n s a v e t o e x c e l f i l e " ) ;
|
i f ( w i n 3 2 : : P a t h F i l e E x i s t s ( f i l e ) ) / / G e t M o d u l e T m p P a t h ( ) + " \ \ " + p r e + m _ E n t i t y N o + " _ . x l s x " ) )
|
D e l e t e F i l e ( f i l e ) ;
|
e x c e l . S a v e T o F i l e ( f i l e ) ;
|
|
e x c e l . Q u i t ( ) ;
|
e x c e l . R e l e a s e ( e x c e l . p t r _ n a t i v e _ ) ;
|
r e t u r n 1 ;
|
}
|
|
i n t O n t o E x c e l ( s t r i n g h t m l S t r ) / / l:NE x c e l
|
{
|
e x c e l = n e w c e x c e l ;
|
e x c e l . s e t N a t i v e P o i n t e r ( c e x c e l : : C r e a t e I n s t a n c e ( ) ) ;
|
|
s t r i n g g i d = p u b l i c c o d e : : G e t G u i d ( ) ;
|
s t r i n g p r e = " !kúQ'°eÁTß~¡h" ;
|
s t r i n g f i l e n a m e = p r e + " . h t m " ;
|
s t r i n g f i l e n a m e e x = p r e + " . x l s x " ;
|
x u t i l : : S a v e T o F i l e ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + f i l e n a m e , h t m l S t r , " " , " " , " " ) ;
|
e x c e l . O p e n D o c u m e n t ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + f i l e n a m e ) ;
|
/ / e x c e l . p u t _ V i s i b l e ( t r u e ) ;
|
/ / e x c e l . T r a n s S h a p e ( ) ;
|
i f ( w i n 3 2 : : P a t h F i l e E x i s t s ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + f i l e n a m e e x ) )
|
D e l e t e F i l e ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + f i l e n a m e e x ) ;
|
e x c e l . S a v e T o F i l e ( G e t M o d u l e T m p P a t h ( ) + " \ \ " + f i l e n a m e e x ) ;
|
e x c e l . p u t _ V i s i b l e ( t r u e ) ;
|
|
e x c e l . R e l e a s e ( e x c e l . p t r _ n a t i v e _ ) ;
|
r e t u r n 1 ;
|
}
|
|
s t r i n g r e p l a c e I n n e r E l e m e n t ( s t r i n g h t m l )
|
{
|
s t r i n g s t r = h t m l ;
|
i f ( s t r . f i n d ( " [ $ e l e m e n t : " ) < 0 ) r e t u r n s t r ;
|
|
i n t l e n = 0 ;
|
i n t p o s = 0 ;
|
i n t p o s 1 = 0 ;
|
s t r i n g p r e = " " ;
|
s t r i n g l e f t = " " ;
|
s t r i n g r i g h t = " " ;
|
s t r i n g t a g = " " ;
|
|
l e n = " [ $ e l e m e n t : " . l e n g t h ( ) ;
|
w h i l e ( t r u e )
|
{
|
p o s = s t r . f i n d ( " [ $ e l e m e n t : " ) ;
|
i f ( p o s < 0 ) b r e a k ;
|
l e f t = s t r . l e f t ( p o s ) ;
|
r i g h t = s t r . m i d ( p o s + l e n , 9 9 9 9 9 9 ) ;
|
|
p o s 1 = r i g h t . f i n d ( " ] " ) ;
|
i f ( p o s 1 > = 0 )
|
{
|
t a g = r i g h t . l e f t ( p o s 1 ) ;
|
i f ( t a g . r i g h t ( 1 ) = = " $ " ) t a g = t a g . l e f t ( t a g . l e n g t h ( ) - 1 ) ;
|
p r e = p r e + l e f t + " < " + t a g + " > " ;
|
s t r = r i g h t . m i d ( p o s 1 + 1 , 9 9 9 9 9 9 ) ;
|
} e l s e
|
{
|
p r e = p r e + l e f t + " < " ;
|
s t r = r i g h t ;
|
}
|
}
|
|
s t r = p r e + s t r ;
|
p r e = " " ;
|
l e n = " [ / $ e l e m e n t : " . l e n g t h ( ) ;
|
w h i l e ( t r u e )
|
{
|
p o s = s t r . f i n d ( " [ / $ e l e m e n t : " ) ;
|
i f ( p o s < 0 ) b r e a k ;
|
l e f t = s t r . l e f t ( p o s ) ;
|
r i g h t = s t r . m i d ( p o s + l e n , 9 9 9 9 9 9 ) ;
|
p o s 1 = r i g h t . f i n d ( " ] " ) ;
|
i f ( p o s 1 > = 0 )
|
{
|
t a g = r i g h t . l e f t ( p o s 1 ) ;
|
i f ( t a g . r i g h t ( 1 ) = = " $ " ) t a g = t a g . l e f t ( t a g . l e n g t h ( ) - 1 ) ;
|
p r e = p r e + l e f t + " < / " + t a g + " > " ;
|
s t r = r i g h t . m i d ( p o s 1 + 1 , 9 9 9 9 9 9 ) ;
|
} e l s e
|
{
|
p r e = p r e + l e f t + " < / " ;
|
s t r = r i g h t ;
|
}
|
}
|
s t r = p r e + s t r ;
|
r e t u r n s t r ;
|
}
|
|
s t r i n g a d j u s t X s l ( s t r i n g s t r , s t r i n g l o c a l P a t h )
|
{
|
/ / i f ( s t r . f i n d ( " % " ) > = 0 ) s t r = s t r . r e p l a c e ( " % " , " " ) ;
|
i f ( s t r . f i n d ( " [ $ p a t h ] / r p t t e m p l a t e " ) > = 0 ) s t r = s t r . r e p l a c e ( " [ $ p a t h ] / r p t t e m p l a t e " , l o c a l P a t h ) ;
|
s t r = r e p l a c e I n n e r E l e m e n t ( s t r ) ;
|
r e t u r n s t r ;
|
}
|
|
s t r i n g D o w n L o a d S K U N o P i c ( s t r i n g s e r v e r U r l , s t r i n g S K U N o , s t r i n g C u s t o m e r I D , s t r i n g C u s t o m e r I t e m N o )
|
{
|
x m l x = n e w x m l ;
|
x . s e t N a t i v e P o i n t e r ( x m l : : C r e a t e I n s t a n c e ( ) ) ;
|
x a s e r v e r a r g a r g = n e w x a s e r v e r a r g ;
|
a r g . s e t N a t i v e P o i n t e r ( a r g . C r e a t e I n s t a n c e ( ) ) ;
|
a r g . A d d A r g ( " S K U N o " , S K U N o ) ;
|
t r a c e ( " \ n \ t * * * * * * * " + S K U N o + " * * * * * * * " + C u s t o m e r I D + " * * * * * * * " + C u s t o m e r I t e m N o ) ;
|
|
s t r i n g s r c = " / s a l e / d a t a / P r o d u c t L i b r a r y 3 / p r e f / p i c t u r e / i m a g e l i s t S K U N o " ;
|
i f ( C u s t o m e r I D ! = " " )
|
{
|
a r g . A d d A r g ( " C u s t o m e r I D " , C u s t o m e r I D ) ;
|
a r g . A d d A r g ( " C u s t o m e r I t e m N o " , C u s t o m e r I t e m N o ) ;
|
s r c = " / s a l e / d a t a / P r o d u c t L i b r a r y 3 / p r e f / p i c t u r e / c u s t o m e r / i m a g e l i s t S K U N o " ;
|
}
|
/ / t r a c e ( " S K U N o = " + S K U N o ) ; / / gU\:yþVGrågâagöN
QÅ_[s k u n o
|
i f ( u r l : : g e t ( s r c , a r g . G e t S t r i n g ( ) , x ) ! = 1 )
|
{
|
t r a c e ( " e r r o r f o r d o w n l o a d s k u n o p i c ! " ) ;
|
r e t u r n " " ;
|
}
|
|
s t r i n g s p a t h = " " ;
|
s t r i n g p a t h = G e t M o d u l e T m p P a t h ( ) ;
|
s t r i n g e x t = " j p g " ;
|
i f ( x . G e t X m l D o c ( ) . s e l e c t S i n g l e N o d e ( " / / F i l e E x t [ 1 ] " ) )
|
{
|
e x t = x . G e t X m l D o c ( ) . s e l e c t S i n g l e N o d e ( " / / F i l e E x t [ 1 ] " ) . t e x t ;
|
} e l s e i f ( C u s t o m e r I D ! = " " )
|
{
|
s r c = " / s a l e / d a t a / P r o d u c t L i b r a r y 3 / p r e f / p i c t u r e / i m a g e l i s t S K U N o " ;
|
i f ( u r l : : g e t ( s r c , a r g . G e t S t r i n g ( ) , x ) ! = 1 )
|
{
|
t r a c e ( " e r r o r f o r d o w n l o a d s k u n o p i c ! " ) ;
|
r e t u r n " " ;
|
}
|
i f ( x . G e t X m l D o c ( ) . s e l e c t S i n g l e N o d e ( " / / F i l e E x t [ 1 ] " ) )
|
e x t = x . G e t X m l D o c ( ) . s e l e c t S i n g l e N o d e ( " / / F i l e E x t [ 1 ] " ) . t e x t ;
|
}
|
|
s t r i n g f i l e n a m e = S K U N o + " . " + e x t ;
|
i f ( x . G e t X m l D o c ( ) . s e l e c t S i n g l e N o d e ( " / / P i c P a t h [ 1 ] " ) )
|
s p a t h = x . G e t X m l D o c ( ) . s e l e c t S i n g l e N o d e ( " / / P i c P a t h [ 1 ] " ) . t e x t ;
|
i f ( s p a t h ! = " " )
|
{
|
x a s e r v e r : : D o w n L o a d F i l e ( s e r v e r U r l , s p a t h , " " , p a t h + " / " + f i l e n a m e ) ;
|
}
|
r e t u r n " f i l e : / / " + p a t h + " / " + f i l e n a m e ;
|
}
|
|
s t r i n g D o w n L o a d P a p e r P i c ( s t r i n g g u i d , s t r i n g s e r v e r U r l )
|
{
|
|
s t r i n g p a t h = G e t M o d u l e T m p P a t h ( ) ;
|
s t r i n g e x t = " j p g " ;
|
s t r i n g f i l e n a m e = g u i d + " . " + e x t ;
|
s t r i n g s t r = g u i d . m i d ( 0 , 2 ) ;
|
s t r i n g s p a t h = " / b u s i n e s s / p r o d u c t s / c h a n p i n / " + s t r + " / " + g u i d + " . j p g " ;
|
x a s e r v e r : : D o w n L o a d F i l e ( s e r v e r U r l , s p a t h , " " , p a t h + " / " + f i l e n a m e ) ;
|
r e t u r n " f i l e : / / " + p a t h + " / " + f i l e n a m e ;
|
}
|
|
s t r i n g G e t H t m l ( x d w g r i d d w _ o b j , s t r i n g x s l P a t h , s t r i n g s e r v e r U r l )
|
{
|
i n t h C u r s o r = x u t i l : : S e t C u r s o r W a i t ( ) ;
|
|
x m l m _ d a t a s e t = n e w x m l ;
|
m _ d a t a s e t . s e t N a t i v e P o i n t e r ( x m l : : C r e a t e I n s t a n c e ( ) ) ;
|
d w _ o b j . D w U p d a t e A l l T o ( m _ d a t a s e t . G e t X m l D o c ( ) ) ;
|
|
s t r i n g a r g s t r = " < a r g s > < a r g n a m e = ' x s l ' v a l u e = ' / b u s i n e s s / " + x s l P a t h + " ' t y p e = ' ' / > < / a r g s > " ;
|
x m l x s l = n e w x m l ;
|
x s l . s e t N a t i v e P o i n t e r ( x m l : : C r e a t e I n s t a n c e ( ) ) ;
|
i f ( u r l : : g e t ( " / s a l e / d a t a / S y s P r i n t T e m p l a t e / g e t x s l " , a r g s t r , x s l ) ! = 1 )
|
{
|
w i n 3 2 : : a l e r t ( " penc!jgï! " ) ;
|
r e t u r n " " ;
|
}
|
|
s t r i n g x s l S t r = x s l . G e t X m l ( ) ;
|
x s l S t r = x s l S t r . r e p l a c e ( " d a t a / r o w " , " d a t a " ) ;
|
x s l S t r = x s l S t r . r e p l a c e ( " / / ÁT T1 / Ä<hy1 " , " I t e m " ) ;
|
|
s t r i n g s d a t e = p u b l i c c o d e : : G e t C u r r e n t D a t e ( ) ;
|
|
x s l S t r = x s l S t r . r e p l a c e ( " < x s l : v a l u e - o f s e l e c t = \ " C r e a t e D a t e \ " / > " , s d a t e ) ;
|
x s l S t r = a d j u s t X s l ( x s l S t r , g e t f i l e P a t h ( ) ) ;
|
t r a c e ( " - - - - - " + x s l S t r + " - - - - - - - " ) ;
|
x s l . L o a d X m l ( x s l S t r ) ;
|
|
s t r i n g h t m l S t r = m _ d a t a s e t . G e t X m l D o c ( ) . t r a n s f o r m N o d e ( x s l . G e t X m l D o c ( ) ) ;
|
|
s t r i n g a s p a c e = h t m l S t r . r e p l a c e ( " [ zz] " , " & n b s p ; " , 0 ) ;
|
a s p a c e = a s p a c e . r e p l a c e ( " [ l i n e ] " , " < b r / > " , 0 ) ;
|
s t r i n g s c o n t e n t = a s p a c e . r e p l a c e ( " < ? x m l v e r s i o n = \ " 1 . 0 \ " ? > " , " " , 0 ) ;
|
|
s t r i n g h e a d = " " ;
|
s t r i n g t a i l = s c o n t e n t ;
|
|
i n t p o s = t a i l . f i n d ( " s r c = \ " i t e m - p i c t u r e : " ) ;
|
w h i l e ( p o s > 0 )
|
{
|
i n t s p o s = p o s + " s r c = \ " i t e m - p i c t u r e : " . l e n g t h ( ) ;
|
i n t p o s 1 = t a i l . f i n d ( " \ " " , s p o s + 1 ) ;
|
s t r i n g s k u n o = t a i l . m i d ( s p o s , p o s 1 - s p o s ) . t r i m ( ) ;
|
/ / s t r i n g s k u n o E x = " 2 4 4 E 9 F F 3 - B F B D - 4 9 C F - 9 4 3 7 - 8 8 7 A D 1 3 4 A A F 7 , 3 8 2 8 4 6 , C 1 0 6 7 9 2 " ;
|
s t r i n g C u s t o m e r I D = " " ;
|
s t r i n g C u s t o m e r I t e m N o = " " ;
|
/ / t r a c e ( " \ n \ t * * * * * * * s k u n o E x : " + s k u n o E x ) ;
|
t r a c e ( " \ n \ t * * * * * * * s k u n o : " + s k u n o ) ;
|
i f ( s k u n o . f i n d ( " , " ) > 0 )
|
{
|
C u s t o m e r I D = s k u n o . l e f t ( s k u n o . f i n d ( " , " ) ) . t r i m ( ) ;
|
s k u n o = s k u n o . m i d ( s k u n o . f i n d ( " , " ) + 1 , 2 5 6 ) . t r i m ( ) ;
|
t r a c e ( " \ n \ t * * * * * * * C u s t o m e r I D : " + C u s t o m e r I D ) ;
|
t r a c e ( " \ n \ t * * * * * * * s k u n o : " + s k u n o ) ;
|
}
|
i f ( s k u n o . f i n d ( " , " ) > 0 )
|
{
|
C u s t o m e r I t e m N o = s k u n o . l e f t ( s k u n o . f i n d ( " , " ) ) . t r i m ( ) ;
|
s k u n o = s k u n o . m i d ( s k u n o . f i n d ( " , " ) + 1 , 2 5 6 ) . t r i m ( ) ;
|
t r a c e ( " \ n \ t * * * * * * * C u s t o m e r I t e m N o : " + C u s t o m e r I t e m N o ) ;
|
t r a c e ( " \ n \ t * * * * * * * s k u n o : " + s k u n o ) ;
|
}
|
s t r i n g s r c = D o w n L o a d S K U N o P i c ( s e r v e r U r l , s k u n o , C u s t o m e r I D , C u s t o m e r I t e m N o ) ;
|
|
h e a d + = t a i l . l e f t ( p o s ) + " s r c = \ " " + s r c ;
|
t a i l = t a i l . m i d ( p o s 1 , 9 9 9 9 9 9 9 9 9 ) ;
|
p o s = t a i l . f i n d ( " s r c = \ " i t e m - p i c t u r e : " ) ;
|
}
|
s c o n t e n t = h e a d + t a i l ;
|
|
h e a d = " " ;
|
t a i l = s c o n t e n t ;
|
i n t p o s i t i o n = t a i l . f i n d ( " s r c = \ " p a p e r - p i c t u r e : " ) ;
|
w h i l e ( p o s i t i o n > 0 )
|
{
|
i n t s p o s i t i o n = p o s i t i o n + " s r c = \ " p a p e r - p i c t u r e : " . l e n g t h ( ) ;
|
i n t p o s i t i o n 1 = t a i l . f i n d ( " \ " " , s p o s i t i o n + 1 ) ;
|
s t r i n g g u i d = t a i l . m i d ( s p o s i t i o n , p o s i t i o n 1 - s p o s i t i o n ) . t r i m ( ) ;
|
s t r i n g s r c 2 = D o w n L o a d P a p e r P i c ( g u i d , s e r v e r U r l ) ;
|
h e a d + = t a i l . l e f t ( p o s i t i o n ) + " s r c = \ " " + s r c 2 ;
|
t a i l = t a i l . m i d ( p o s i t i o n 1 , 9 9 9 9 9 9 9 9 9 ) ;
|
p o s i t i o n = t a i l . f i n d ( " s r c = \ " p a p e r - p i c t u r e : " ) ;
|
}
|
s c o n t e n t = h e a d + t a i l ;
|
|
/ / s c o n t e n t = a d j u s t X s l ( s c o n t e n t , s P a t h ) ;
|
h t m l S t r = s c o n t e n t ;
|
|
|
/ *
|
s t r i n g x c o n t e n t = h t m l S t r . r e p l a c e ( " [ zz] " , " " , 0 ) ;
|
i n t p o s 0 = x c o n t e n t . f i n d ( " < x m l " ) ;
|
i n t p o s 2 = x c o n t e n t . f i n d ( " < / x m l > " ) ;
|
i f ( p o s 0 > = 0 )
|
{
|
s t r i n g s t r = x c o n t e n t . l e f t ( p o s 0 ) + x c o n t e n t . m i d ( p o s 2 + 6 , 9 9 9 9 9 9 9 ) ;
|
x c o n t e n t = s t r ;
|
} * /
|
|
r e t u r n h t m l S t r ;
|
}
|
} ;
|
]
|
|
u n i t t r a d e
|
[
|
c l a s s S h i p m e n t N e w S a m p l e 3 : p u b l i c x f r a m e
|
{
|
x d w g r i d d w _ l i s t ;
|
x d w t a b l e d w _ a r g ;
|
x n o d e m _ a g e n t N o d e ; / / A g e n t C o n d i t i o n
|
|
i n t S e t A g e n t ( )
|
{
|
s t r i n g x f N o d e A g e n t A r e a = " a g e n t a r e a " ;
|
x n o d e a n o d e = G e t A g e n t N o d e ( x f N o d e A g e n t A r e a ) ;
|
i f ( m _ a g e n t N o d e )
|
{
|
S e t A g e n t N o d e C o n t e n t ( a n o d e , m _ a g e n t N o d e ) ;
|
}
|
e l s e
|
{
|
m s x m l : : I X M L D O M E l e m e n t x f r a m e E l e m e n t = G e t E l e m e n t ( ) ;
|
m s x m l : : I X M L D O M E l e m e n t a g e n t = x f r a m e E l e m e n t . s e l e c t S i n g l e N o d e ( " a g e n t / " + x f N o d e A g e n t A r e a + " [ 1 ] / * " ) ;
|
i f ( a g e n t )
|
{
|
s t r i n g s = a g e n t . x m l ;
|
m _ a g e n t N o d e = S e t A g e n t N o d e C o n t e n t ( a n o d e , s ) ;
|
}
|
}
|
r e t u r n 1 ;
|
}
|
|
/ / &q¹pÀo;mYtýQpe
|
i n t O n S e t F o c u s ( r e f T E v e n t e v t , i n t p a r a m )
|
{
|
/ / Ínå]wQag
|
S e t A g e n t ( ) ;
|
r e t u r n 1 ;
|
}
|
|
|
|
i n t O n L o o k I m a g e ( s t r i n g s k u i d , s t r i n g C u s t o m e r I D , s t r i n g C u s t o m e r I t e m N o )
|
{
|
i n t h C u r s o r = x u t i l : : S e t C u r s o r W a i t ( ) ;
|
x a s e r v e r a r g a r g = V i e w O b j e c t : : M a k e A r g ( ) ;
|
a r g . A d d A r g ( " g u i d " , s k u i d ) ;
|
a r g . A d d A r g ( " C u s t o m e r I D " , C u s t o m e r I D ) ;
|
a r g . A d d A r g ( " C u s t o m e r I t e m N o " , C u s t o m e r I t e m N o ) ;
|
O p e n W i n d o w ( " d e v : x p a g e [ V i e w P i c t u r e s E x . v x ] " , a r g . g e t N a t i v e P o i n t e r ( ) ) ;
|
x u t i l : : R e s t o r e C u r s o r ( h C u r s o r ) ;
|
r e t u r n 1 ;
|
}
|
|
i n t O n P r i n t ( )
|
{
|
|
x a s e r v e r a r g a r g = n e w x a s e r v e r a r g ;
|
a r g . s e t N a t i v e P o i n t e r ( a r g . C r e a t e I n s t a n c e ( ) ) ;
|
a r g . A d d A r g ( " E n t i t y N a m e " , " Q u o t e " , " " ) ;
|
a r g . A d d A r g ( " E n t i t y I D " , " " , " " ) ;
|
a r g . A d d A r g ( " E n t i t y N o " , " 2 2 J R 0 0 8 9 " , " " ) ;
|
i n t p = a r g . p t r _ n a t i v e _ ;
|
o p e n U r l ( " / s a l e / v i e w / v i e w . b a s e / x p a g e / T e m p l a t e / P r i n t V i e w E x " , p ) ;
|
r e t u r n 1 ;
|
}
|
|
/ / }TäNÑS^ýQpe
|
i n t O n C m d D i s p a t c h ( s t r i n g c o m d i d )
|
{
|
i n t h C u r s o r = 0 ;
|
i f ( c o m d i d = = " x m R e f r e s h " )
|
{
|
O n R e t r i e v e ( ) ;
|
}
|
i f ( c o m d i d = = " x m L o o k I m a g e " )
|
{
|
i n t r o w = d w _ l i s t . G e t R o w ( ) ;
|
s t r i n g s k u i d = d w _ l i s t . G e t G u i d ( r o w ) ;
|
s t r i n g C u s t o m e r I D = d w _ l i s t . G e t I t e m S t r i n g ( r o w , " C u s t o m e r I D " ) ;
|
s t r i n g C u s t o m e r I t e m N o = d w _ l i s t . G e t I t e m S t r i n g ( r o w , " C u s t o m e r I t e m N o " ) ;
|
O n L o o k I m a g e ( s k u i d , C u s t o m e r I D , C u s t o m e r I t e m N o ) ;
|
r e t u r n 1 ;
|
}
|
i f ( c o m d i d = = " x m A n a l y s i s " )
|
{
|
h C u r s o r = x u t i l : : S e t C u r s o r W a i t ( ) ;
|
s t r i n g s t r = d w _ l i s t . D a t a A n a l y s i s ( " " ) ;
|
x a s e r v e r a r g a r g = n e w x a s e r v e r a r g ;
|
a r g . s e t N a t i v e P o i n t e r ( a r g . C r e a t e I n s t a n c e ( ) ) ;
|
a r g . A d d A r g ( " h t m l " , s t r ) ;
|
i n t o b j = c a s t ( d w _ l i s t a s i n t ) ;
|
a r g . A d d A r g ( " o b j " , o b j . t o S t r i n g ( ) ) ;
|
O p e n W i n d o w ( " d e v : x p a g e [ d a t a . v a n a l y s i s . v x ] " , c a s t ( a r g a s i n t ) ) ;
|
x u t i l : : R e s t o r e C u r s o r ( h C u r s o r ) ;
|
r e t u r n 1 ;
|
}
|
e l s e i f ( c o m d i d = = " x m E x c e l " )
|
{
|
E x p o r t e r e x p o r t e r 1 = n e w E x p o r t e r ;
|
e x p o r t e r 1 . O n t o E x c e l ( e x p o r t e r 1 . G e t H t m l ( d w _ l i s t , " r p t t e m p l a t e / Q u o t e / 4 5 4 4 F 9 8 B - 6 0 D 1 - 4 7 8 7 - 8 0 9 2 - D F E 5 E D 9 3 0 5 6 0 . x s l " , G e t S e r v e r U r l ( ) ) ) ;
|
r e t u r n 1 ;
|
}
|
e l s e i f ( c o m d i d = = " x m S a v e A s " )
|
{
|
E x p o r t e r e x p o r t e r = n e w E x p o r t e r ;
|
/ * s t r i n g f i l e = e x p o r t e r . G e t S a v e F i l e N a m e ( " eQ^°eÁTß~¡h" + " . x l s x " ,
|
" E x c e l eöN( * . x l s x ) \ 0 * . x l s x ; * . x l s \ 0 E x c e l 9 7 eöN( * . x l s ) \ 0 * . x l s \ 0 P D F eöN( * . p d f ) \ 0 * . p d f \ 0 " ,
|
" x l s x " ) ;
|
* /
|
|
/ / d w _ l i s t . S a v e A s ( " " ) ;
|
s t r i n g h t m l S t r = e x p o r t e r . G e t H t m l ( d w _ l i s t , " r p t t e m p l a t e / Q u o t e / 4 5 4 4 F 9 8 B - 6 0 D 1 - 4 7 8 7 - 8 0 9 2 - D F E 5 E D 9 3 0 5 6 0 . x s l " , G e t S e r v e r U r l ( ) ) ;
|
e x p o r t e r . O n E x p o r t ( G e t H W N D ( ) , h t m l S t r ) ;
|
|
r e t u r n 1 ;
|
}
|
e l s e i f ( c o m d i d = = " x m P r i n t " )
|
{
|
O n P r i n t ( ) ;
|
r e t u r n 1 ;
|
}
|
|
r e t u r n 0 ;
|
}
|
|
/ / æÑS h»y _Tt r a n NöN ÿÇåg~bÐg*NÂSpe_0Rù[^vR
|
i n t O n B a s e I t e m C h a n g e d ( r e f T N o t i f y E v e n t e v t , i n t p )
|
{
|
r e f D W N M H D R h d r = t r u s t ( e v t . p n m h a s r e f D W N M H D R ) ;
|
s t r i n g c o l n a m e = h d r . c o l n a m e ;
|
s t r i n g v a l u e = h d r . d a t a ;
|
|
s t r i n g d w n a m e = " d w _ l i s t " ;
|
i f ( v a l u e ! = " " )
|
{
|
m s x m l : : I X M L D O M N o d e L i s t n l i s t = G e t E l e m e n t ( ) . s e l e c t N o d e s ( " / / * [ @ n a m e = ' " + d w n a m e + " ' ] / t r a n s [ @ f o r = ' " + c o l n a m e + " ' ] " ) ;
|
V i e w O b j e c t : : T r a n s D a t a ( n l i s t , d w _ l i s t , h d r . r o w , c o l n a m e , v a l u e ) ;
|
}
|
r e t u r n 1 ;
|
}
|
|
|
/ / }TäNYtNöN
|
i n t O n X C o m m a n d ( r e f T X C o m m a n d E v e n t e v t , i n t p a r a m )
|
{
|
r e t u r n O n C m d D i s p a t c h ( e v t . p S t r I D ) ;
|
}
|
|
i n t O n A t t a c h E v e n t ( )
|
{
|
/ / Ñ~[å]wQag¹pûQNöN
|
A t t a c h E v e n t ( " W M _ X C O M M A N D " , O n X C o m m a n d ) ;
|
/ / ·ÖS&q¹pNöN ÿ(uNÍnå]wQag
|
A t t a c h E v e n t ( " W M _ S E T F O C U S " , O n S e t F o c u s ) ;
|
A t t a c h E v e n t ( " d w _ l i s t " , " D W V _ I T E M C H A N G E D " , O n B a s e I t e m C h a n g e d ) ;
|
}
|
|
s t r i n g G e t Q u e r y A r g ( )
|
{
|
d w _ a r g . A c c e p t T e x t ( ) ;
|
x m l x = n e w x m l ;
|
x . s e t N a t i v e P o i n t e r ( x m l : : C r e a t e I n s t a n c e ( ) ) ;
|
d w _ a r g . D w U p d a t e A l l T o ( x . G e t X m l D o c ( ) ) ;
|
r e t u r n x . G e t X m l ( ) ;
|
}
|
|
i n t O n R e t r i e v e ( )
|
{
|
x m l x = n e w x m l ;
|
x . s e t N a t i v e P o i n t e r ( x m l : : C r e a t e I n s t a n c e ( ) ) ;
|
x a s e r v e r a r g a r g = n e w x a s e r v e r a r g ;
|
a r g . s e t N a t i v e P o i n t e r ( a r g . C r e a t e I n s t a n c e ( ) ) ;
|
a r g . A d d A r g ( " Q u e r y T x t " , G e t C o n t r o l ( " s e a r c h " ) . G e t T e x t ( ) ) ;
|
a r g . A d d A r g ( " Q u e r y A r g " , G e t Q u e r y A r g ( ) ) ;
|
t r a c e ( G e t Q u e r y A r g ( ) ) ;
|
i f ( g e t U r l ( " / s a l e / d a t a / S a m p l e / e n t i t y / S h i p m e n t N e w L s i t " , a r g . G e t S t r i n g ( ) , x ) ! = 1 )
|
{
|
a l e r t ( x . G e t X m l ( ) ) ;
|
t r a c e ( x . G e t X m l D o c ( ) . t e x t ) ;
|
r e t u r n - 1 ;
|
} e l s e
|
{
|
|
d w _ l i s t . R e t r i e v e ( x ) ;
|
d w _ l i s t . R e d r a w ( ) ;
|
}
|
d w _ l i s t . S e t S e l e c t i o n M o d e ( 1 ) ;
|
d w _ l i s t . S e t R e a d O n l y ( t r u e ) ;
|
r e t u r n 1 ;
|
}
|
|
i n t o n l o a d ( )
|
{
|
d w _ l i s t = G e t C o n t r o l ( " d w _ l i s t " ) ;
|
d w _ l i s t . o p e n U r l ( " / s a l e / v i e w / S a m p l e / t e m p l a t e / S a m p l e / !kúQ'°eÁT" ) ;
|
d w _ l i s t . S e t C o l u m n S t a t e ( " S K U N o " , f a l s e ) ;
|
d w _ l i s t . S e t C o l u m n S t a t e ( " C u s t o m e r I D " , f a l s e ) ;
|
d w _ l i s t . S e t C o l u m n S t a t e ( " C u s t o m e r I t e m N o " , f a l s e ) ;
|
d w _ l i s t . S e t C o l u m n S t a t e ( " S K U N o E x " , f a l s e ) ;
|
|
d w _ a r g = G e t C o n t r o l ( " d w _ a r g " ) ;
|
d w _ a r g . o p e n U r l ( " / s a l e / v i e w / A R / t e m p l a t e / q u e r y a r g " ) ;
|
d w _ a r g . S e t C o l H e a d e r H e i g h t ( 0 ) ;
|
d w _ a r g . S e t R o w S e l e c t o r W i d t h ( 0 ) ;
|
d w _ a r g . S e t H S c r o l l S t a t e ( f a l s e ) ;
|
d w _ a r g . S e t V S c r o l l S t a t e ( f a l s e ) ;
|
d w _ a r g . S e t I t e m S t r i n g ( 1 , " D a t e T y p e " , " ,gt^" ) ;
|
|
O n R e t r i e v e ( ) ;
|
|
O n A t t a c h E v e n t ( ) ;
|
|
r e t u r n 1 ;
|
}
|
|
i n t o n l o a d e d ( )
|
{
|
S e t A g e n t ( ) ;
|
r e t u r n 1 ;
|
}
|
} ;
|
]
|
