þÿ
|
# i n c l u d e < w o b j e c t / x s t r i n g . h p p >
|
# i n c l u d e < x c o n t r o l / x t r e e v i e w . h p p >
|
# i n c l u d e < x c o n t r o l / x d w g r i d . h p p >
|
# i n c l u d e < x c o n t r o l / x e x c e l . h p p >
|
# i n c l u d e < a d t / x a r r a y . h p p >
|
|
# i n c l u d e " v b u s i n e s s / v f r a m e / l i s t w i n . v f r a m e . v b u s i n e s s . h p p "
|
# i n c l u d e " v i e w o b j e c t / v i e w . b a s e . h p p "
|
# i n c l u d e < w i n 3 2 / x f i l e . h p p >
|
|
# i n c l u d e < m a p >
|
# i n c l u d e < s t r i n g >
|
# i n c l u d e < v e c t o r >
|
|
u s i n g x m l = K X M L D O M D o c u m e n t ;
|
c l a s s _ _ d e c l s p e c ( d l l e x p o r t ) S a l a r y s l i p I m p V i e w : p u b l i c x f r a m e
|
{
|
p u b l i c :
|
x d w g r i d d w _ l i s t ;
|
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
|
x s t r i n g p a t h ;
|
s t d : : m a p < s t d : : w s t r i n g , s t d : : w s t r i n g > m a p H e a d ;
|
p u b l i c :
|
S a l a r y s l i p I m p V i e w ( v o i d * i m p l P t r , H W N D h W n d ) : x f r a m e ( i m p l P t r , h W n d ) { }
|
p u b l i c :
|
s t a t i c S a l a r y s l i p I m p V i e w * C r e a t e I n s t a n c e ( v o i d * i m p l P t r , v o i d * h W n d )
|
{
|
S a l a r y s l i p I m p V i e w * p W i n = n e w S a l a r y s l i p I m p V i e w ( i m p l P t r , ( H W N D ) h W n d ) ;
|
r e t u r n p W i n ;
|
}
|
i n t S e t A g e n t ( )
|
{
|
x s t r i n g x f N o d e A g e n t A r e a = L " 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 ( a n o d e , m _ a g e n t N o d e ) ;
|
}
|
e l s e
|
{
|
K 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 ( ) ;
|
K 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 ( L " a g e n t / " + x f N o d e A g e n t A r e a + L " [ 1 ] / * " ) ;
|
i f ( a g e n t )
|
{
|
x 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 ( a n o d e , s ) ;
|
}
|
}
|
r e t u r n 1 ;
|
}
|
|
|
/ /q&p¹oÀm;YtQýep
|
i n t O n S e t F o c u s ( T E v e n t * e v t , L P A R A M p a r a m )
|
{
|
/ /Ín]åQwga
|
S e t A g e n t ( ) ;
|
r e t u r n 1 ;
|
}
|
|
i n t O n D e l e t e R o w ( )
|
{
|
d w _ l i s t . D e l e t e R o w ( 0 ) ;
|
r e t u r n 1 ;
|
}
|
|
i n t O n I n s e r t R o w ( )
|
{
|
i n t r o w = d w _ l i s t . I n s e r t R o w ( 0 ) ;
|
x 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 ( ) ;
|
d w _ l i s t . S e t I t e m S t r i n g ( r o w , L " C r e a t e D a t e " , s d a t e ) ;
|
x s t r i n g s u s e r i d = p u b l i c c o d e : : G e t U s e r ( ) . i d ;
|
x s t r i n g s u s e r n a m e = p u b l i c c o d e : : G e t U s e r ( ) . n a m e ;
|
d w _ l i s t . S e t I t e m S t r i n g ( r o w , L " C r e a t o r I D " , s u s e r i d ) ;
|
d w _ l i s t . S e t I t e m D i s p l a y S t r i n g ( r o w , L " C r e a t o r I D " , s u s e r n a m e ) ;
|
|
r e t u r n 1 ;
|
}
|
|
i n t G e t H e a d R o w ( x e x c e l & e x c e l )
|
{
|
i n t c o l s = e x c e l . G e t V a l i d C o l u m n ( ) ;
|
i n t r o w s = e x c e l . G e t V a l i d R o w ( ) ;
|
|
i n t c o u n t C o l u m n = 5 ;
|
i n t c o u n t = 0 ;
|
i n t h e a d r o w = 0 ;
|
x s t r i n g v a l ;
|
f o r ( i n t r o w = 1 ; r o w < = r o w s ; r o w + + )
|
{
|
c o u n t = 0 ;
|
f o r ( i n t c o l = 1 ; c o l < = c o l s ; c o l + + )
|
{
|
v a l = e x c e l . G e t C e l l S t r i n g ( r o w , c o l ) ;
|
i f ( v a l ! = L " " ) c o u n t + + ;
|
i f ( c o u n t > c o u n t C o l u m n ) b r e a k ;
|
}
|
i f ( c o u n t > c o u n t C o l u m n )
|
{
|
h e a d r o w = r o w ;
|
b r e a k ;
|
}
|
}
|
r e t u r n h e a d r o w ;
|
}
|
|
i n t O n T r a n ( x e x c e l & e x c e l )
|
{
|
/ / g e t h e a d
|
x s t r i n g h e a d = L " " ;
|
x s t r i n g h e a d c o l s = L " " ;
|
|
x s t r i n g v a l = L " " ;
|
|
i n t c o l s = e x c e l . G e t V a l i d C o l u m n ( ) ;
|
i n t r o w s = e x c e l . G e t V a l i d R o w ( ) ;
|
|
i n t h e a d r o w = G e t H e a d R o w ( e x c e l ) ;
|
i f ( h e a d r o w < 1 )
|
{
|
a l e r t ( L "g*b~R0TvhY4 " ) ;
|
r e t u r n 1 ;
|
}
|
|
f o r ( i n t c o l = 1 ; c o l < = c o l s ; + + c o l )
|
{
|
v a l = e x c e l . G e t C e l l S t r i n g ( h e a d r o w , c o l ) ;
|
v a l = v a l . t r i m ( ) ;
|
i f ( v a l = = L " " ) c o n t i n u e ;
|
i f ( v a l . f i n d ( L " ( " ) > = 0 ) v a l = v a l . l e f t ( v a l . f i n d ( L " ( " ) ) ;
|
i f ( v a l . f i n d ( L "ÿ " ) > = 0 ) v a l = v a l . l e f t ( v a l . f i n d ( L "ÿ " ) ) ;
|
i f ( v a l . f i n d ( L " [ " ) > = 0 ) v a l = v a l . l e f t ( v a l . f i n d ( L " [ " ) ) ;
|
i f ( v a l . f i n d ( L "0 " ) > = 0 ) v a l = v a l . l e f t ( v a l . f i n d ( L "0 " ) ) ;
|
i f ( v a l . f i n d ( L " / " ) > = 0 ) v a l = v a l . l e f t ( v a l . f i n d ( L " / " ) ) ;
|
i f ( v a l . f i n d ( L " \ r " ) > = 0 ) v a l = v a l . l e f t ( v a l . f i n d ( L " \ r " ) ) ;
|
i f ( v a l . f i n d ( L " \ n " ) > = 0 ) v a l = v a l . l e f t ( v a l . f i n d ( L " \ n " ) ) ;
|
i f ( h e a d = = L " " ) h e a d = v a l ; e l s e h e a d + = L " , " + v a l ;
|
i f ( h e a d c o l s = = L " " ) h e a d c o l s = x s t r i n g ( c o l ) ; e l s e h e a d c o l s + = L " , " + x s t r i n g ( c o l ) ;
|
}
|
|
x m l x ;
|
x a s e r v e r a r g a r g ;
|
a r g . A d d A r g ( L " p a t h " , p a t h ) ;
|
a r g . A d d A r g ( L " h e a d " , h e a d ) ;
|
a r g . A d d A r g ( L " c o l u m n s " , h e a d c o l s ) ;
|
/ / a l e r t ( h e a d ) ;
|
i f ( g e t U r l ( L " / s a l e / d a t a / T h i n g / c o n t e n t / m a t c h h e a d " , a r g . G e t S t r i n g ( ) , x ) ! = 1 ) r e t u r n 1 ;
|
c o n s t w c h a r _ t * s t r = x . x m l ( ) ;
|
K X M L D O M N o d e n = x . s e l e c t S i n g l e N o d e ( L " d a t a / T y p e " ) ;
|
i f ( ! n )
|
{
|
a l e r t ( L "g*S9MR0TvlQe|{Wÿ ÷QHMnepcnlcbOá`o " ) ;
|
r e t u r n 1 ;
|
}
|
|
K X M L D O M N o d e L i s t i t e m s = n . s e l e c t N o d e s ( L " I t e m " ) ;
|
i n t l e n = i t e m s . l e n g t h ( ) ;
|
s t d : : v e c t o r < i n t > i n d e x s ;
|
s t d : : v e c t o r < s t d : : w s t r i n g > c o l u m n h e a d s ;
|
s t d : : v e c t o r < s t d : : w s t r i n g > c o l u m n s ;
|
|
x s t r i n g b a n k = n . s e l e c t S i n g l e N o d e ( L " @ n a m e " ) . t e x t ( ) ;
|
f o r ( i n t i = 0 ; i < l e n ; i + + )
|
{
|
K X M L D O M E l e m e n t e = i t e m s . i t e m ( i ) ;
|
x s t r i n g s t r = e . g e t A t t r i b u t e ( L " i n d e x " ) ;
|
|
c o n s t w c h a r _ t * c o l h e a d = e . s e l e c t S i n g l e N o d e ( L " D a t a C o l u m n " ) . t e x t ( ) ;
|
i f ( m a p H e a d . f i n d ( c o l h e a d ) ! = m a p H e a d . e n d ( ) )
|
{
|
i n d e x s . p u s h _ b a c k ( s t r . t o I n t ( ) ) ;
|
c o l u m n h e a d s . p u s h _ b a c k ( c o l h e a d ) ;
|
c o l u m n s . p u s h _ b a c k ( m a p H e a d [ c o l h e a d ] ) ;
|
}
|
}
|
|
i f ( M e s s a g e B o x ( G e t H W N D ( ) , L "f/T&}Qe " + b a n k + L "epcn ! " , L "cÐy: " , 1 ) = = 2 ) r e t u r n 1 ;
|
|
/ / c l e a r d a t a
|
/ / f o r ( i n t m = d w _ l i s t . G e t R o w C o u n t ( ) ; m > 0 ; m - - ) d w _ l i s t . D e l e t e R o w ( m ) ;
|
d w _ l i s t . R e s e t ( ) ;
|
|
|
/ /ûSÖ[¢b7lcbOá`o
|
x m l x c ;
|
/ *
|
i f ( g e t U r l ( L " / s a l e / d a t a / A R / t r a n / c u s t o m e r " , L " " , x c ) ! = 1 )
|
{
|
t r a c e ( x c . t e x t ( ) ) ;
|
r e t u r n - 1 ;
|
}
|
* /
|
|
H C U R S O R 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 ( ) ;
|
K X M L D O M D o c u m e n t x d o c = x c ;
|
|
x s t r i n g n a m e s = L " " ;
|
x s t r i n g r o w n o s = L " " ;
|
f o r ( i n t r o w = h e a d r o w + 1 ; r o w < = r o w s ; r o w + + )
|
{
|
v a l = e x c e l . G e t C e l l S t r i n g ( r o w , i n d e x s [ 0 ] ) ;
|
i f ( v a l . t r i m ( ) = = L "T¡ " ) b r e a k ;
|
i n t c u r R o w = d w _ l i s t . I n s e r t R o w ( 0 ) ;
|
i f ( r o w n o s = = L " " )
|
r o w n o s = x s t r i n g ( c u r R o w ) ;
|
e l s e
|
r o w n o s + = L " , " + x s t r i n g ( c u r R o w ) ;
|
|
/ / i n i t
|
x 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 ( ) ;
|
d w _ l i s t . S e t I t e m S t r i n g ( c u r R o w , L " C r e a t e D a t e " , s d a t e ) ;
|
x s t r i n g s u s e r i d = p u b l i c c o d e : : G e t U s e r ( ) . i d ;
|
x s t r i n g s u s e r n a m e = p u b l i c c o d e : : G e t U s e r ( ) . n a m e ;
|
d w _ l i s t . S e t I t e m S t r i n g ( c u r R o w , L " C r e a t o r I D " , s u s e r i d ) ;
|
d w _ l i s t . S e t I t e m D i s p l a y S t r i n g ( c u r R o w , L " C r e a t o r I D " , s u s e r n a m e ) ;
|
d w _ l i s t . S e t I t e m S t r i n g ( c u r R o w , L " S a l a r y s l i p I D " , p u b l i c c o d e : : G e t G u i d ( ) ) ;
|
f o r ( i n t k = 0 ; k < i n d e x s . s i z e ( ) ; k + + )
|
{
|
v a l = e x c e l . G e t C e l l S t r i n g ( r o w , i n d e x s [ k ] ) ;
|
/ *
|
i f ( c o l u m n s . i t e m ( k ) = = L " C u s t o m e r I D " )
|
{
|
i f ( x d o c )
|
{
|
K X M L D O M N o d e n 1 = x d o c . s e l e c t S i n g l e N o d e ( L " / d a t a / I t e m [ c o n t a i n s ( \ " " + v a l + L " \ " , R a w C o l u m n ) ] " ) ;
|
i f ( n 1 )
|
{
|
/ / a l e r t ( n 1 . x m l ) ;
|
i f ( n 1 . s e l e c t S i n g l e N o d e ( L " D a t a C o l u m n " ) ) d w _ l i s t . S e t I t e m S t r i n g ( c u r R o w , c o l u m n s . i t e m ( k ) . c _ s t r ( ) , n 1 . s e l e c t S i n g l e N o d e ( L " D a t a C o l u m n " ) . t e x t ( ) ) ;
|
i f ( n 1 . s e l e c t S i n g l e N o d e ( L " D a t a C o l u m n / @ _ d i s p l a y s t r i n g " ) ) d w _ l i s t . S e t I t e m D i s p l a y S t r i n g ( c u r R o w , c o l u m n s . i t e m ( k ) . c _ s t r ( ) , n 1 . s e l e c t S i n g l e N o d e ( L " D a t a C o l u m n / @ _ d i s p l a y s t r i n g " ) . t e x t ( ) ) ;
|
}
|
}
|
}
|
e l s e * /
|
i f ( c o l u m n h e a d s [ k ] = = L "TX]å " )
|
{
|
i f ( n a m e s = = L " " )
|
n a m e s = v a l ;
|
e l s e
|
n a m e s + = ( x s t r i n g ) L " , " + v a l ;
|
d w _ l i s t . S e t I t e m D i s p l a y S t r i n g ( c u r R o w , c o l u m n s [ k ] . c _ s t r ( ) , v a l ) ;
|
} e l s e
|
d w _ l i s t . S e t I t e m S t r i n g ( c u r R o w , c o l u m n s [ k ] . c _ s t r ( ) , v a l ) ;
|
}
|
}
|
V i e w O b j e c t : : R e t r i e v e D a t a ( L " G e t P e r s o n s I n f o " ) ;
|
x m l x 1 = V i e w O b j e c t : : R e t r i e v e D a t a ( L " / s a l e / d a t a / e x p e n s e 3 / G e t P e r s o n s I n f o " , L " n a m e s " , n a m e s , L " r o w s " , r o w n o s ) ;
|
K X M L D O M N o d e L i s t i t e m p = x 1 . s e l e c t N o d e s ( L " d a t a / I t e m " ) ;
|
c o n s t w c h a r _ t * s t r 1 = x 1 . x m l ( ) ;
|
i n t c n t = i t e m p . l e n g t h ( ) ;
|
f o r ( i n t i = 0 ; i < c n t ; i + + )
|
{
|
K X M L D O M N o d e t p = i t e m p . i t e m ( i ) ;
|
x s t r i n g r o w n o = t p . s e l e c t S i n g l e N o d e ( L " r o w " ) . t e x t ( ) ;
|
i n t r o w = r o w n o . t o I n t ( ) ;
|
i f ( r o w n o ! = L " " )
|
{
|
i f ( t p . s e l e c t S i n g l e N o d e ( L " S p e c i a l D e d u c t F e e A m o u t " ) )
|
{
|
/ * d o u b l e S p e c i a l D e d u c t F e e A m o u t E x = 0 . 0 0 ;
|
x s t r i n g S p e c i a l D e d u c t F e e A m o u t = ;
|
S p e c i a l D e d u c t F e e A m o u t E x = S p e c i a l D e d u c t F e e A m o u t . t o D o u b l e ( ) ; * /
|
d w _ l i s t . S e t I t e m S t r i n g ( r o w , L " S p e c i a l D e d u c t F e e " , t p . s e l e c t S i n g l e N o d e ( L " S p e c i a l D e d u c t F e e A m o u t " ) . t e x t ( ) ) ;
|
}
|
i f ( t p . s e l e c t S i n g l e N o d e ( L " D e p t N a m e " ) )
|
{
|
d w _ l i s t . S e t I t e m S t r i n g ( r o w , L " D e p t N a m e " , t p . s e l e c t S i n g l e N o d e ( L " D e p t N a m e " ) . t e x t ( ) ) ;
|
d w _ l i s t . S e t I t e m D i s p l a y S t r i n g ( r o w , L " D e p t N a m e " , t p . s e l e c t S i n g l e N o d e ( L " D e p t N a m e " ) . t e x t ( ) ) ;
|
}
|
i f ( t p . s e l e c t S i n g l e N o d e ( L " G r o u p N a m e " ) )
|
{
|
d w _ l i s t . S e t I t e m S t r i n g ( r o w , L " G r o u p N a m e " , t p . s e l e c t S i n g l e N o d e ( L " G r o u p N a m e " ) . t e x t ( ) ) ;
|
d w _ l i s t . S e t I t e m D i s p l a y S t r i n g ( r o w , L " G r o u p N a m e " , t p . s e l e c t S i n g l e N o d e ( L " G r o u p N a m e " ) . t e x t ( ) ) ;
|
}
|
d w _ l i s t . S e t I t e m S t r i n g ( r o w , L " P e r s o n I D " , t p . s e l e c t S i n g l e N o d e ( L " P e r s o n I D " ) . t e x t ( ) ) ;
|
}
|
}
|
/ / G e t P e r s o n s I n f o
|
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 ) ;
|
d w _ l i s t . R e d r a w ( ) ;
|
a l e r t ( L "lcb[b ! " ) ;
|
|
r e t u r n 1 ;
|
}
|
|
i n t O n S a v e D a t a ( )
|
{
|
x m l x ;
|
|
d w _ l i s t . A c c e p t T e x t ( ) ;
|
d w _ l i s t . D w U p d a t e A l l T o E x ( x ) ;
|
x a s e r v e r a r g a r g ;
|
|
x s t r i n g c o n t e n t = x . x m l ( ) ;
|
a r g . A d d A r g ( L " c o n t e n t " , c o n t e n t ) ;
|
|
/ / t r a c e ( x . x m l ( ) ) ;
|
i f ( x u r l : : g e t ( L " / s a l e / d a t a / e x p e n s e 3 / u p d a t e / s a l a r y s l i p / i m p " , a r g . G e t S t r i n g ( ) , x ) ! = 1 )
|
{
|
x s t r i n g e r r o r = x . t e x t ( ) ;
|
a l e r t ( L " e r r : " + e r r o r ) ;
|
r e t u r n 1 ;
|
}
|
x s t r i n g s t r = x . d o c u m e n t E l e m e n t ( ) . g e t A t t r i b u t e ( L " t e x t " ) ;
|
i f ( s t r = = L " t r u e " )
|
{
|
d w _ l i s t . R e s e t U p d a t e S t a t u s ( ) ;
|
a l e r t ( L "OÝ[XbR ! " ) ;
|
}
|
e l s e
|
{
|
a l e r t ( L "OÝ[XY1% ! " ) ;
|
}
|
r e t u r n 1 ;
|
}
|
|
|
i n t S e n d C t r l C m d ( x c o n t r o l x c , x s t r i n g c m d )
|
{
|
S e n d M e s s a g e ( x c . G e t H W N D ( ) , 0 x 4 0 1 , ( W P A R A M ) c m d . c _ s t r ( ) , 0 ) ;
|
r e t u r n 1 ;
|
}
|
|
x s t r i n g G e t O p e n F i l e N a m e ( x s t r i n g i n i t F i l e N a m e , c o n s t s t r i n g f i l t e r , x s t r i n g e x t )
|
{
|
/ / x s t r i n g p a t h = G e t O p e n F i l e N a m e ( L " " ,
|
/ / " J P E G eNö ( * . j p g ) \ 0 * . j p g ; * . j p e g ; * . p n g ; * . g i f ; * . b m p \ 0QhèeNö ( * . * ) \ 0 * . * \ 0 " ,
|
/ / " j p g " ) ;
|
|
w c h a r _ t s z F i l e N a m e [ 4 0 9 6 ] ;
|
w c h a r _ t s z P a t h [ 4 0 9 6 ] ;
|
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 ! = L " " )
|
{
|
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 o n s t w c h a r _ t * t m p = i n i t F i l e N a m e . c _ s t r ( ) ;
|
f o r ( i n t i = 0 ; i < l e n + 1 ; 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 ;
|
O P E N F I L E N A M E W o f n ;
|
|
o f n . l S t r u c t S i z e = 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 eNö ( * . j p g ) \ 0 * . j p g ; * . j p e g ; * . p n g ; * . g i f ; * . b m p \ 0QhèeNö ( * . * ) \ 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 = 4 0 9 6 ;
|
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 = 4 0 9 6 ;
|
o f n . l p s t r T i t l e = L "÷c[eNö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 1 0 0 0 / * O F N _ F I L E M U S T E X I S T * / | 0 x 0 0 0 8 0 0 0 0 / * O F N _ E X P L O R E R * / ;
|
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 ;
|
|
o f n . n F i l e O f f s e t = 0 ;
|
o f n . n F i l e E x t e n s i o n = 0 ;
|
|
/ / d e b u g b r e a k ( ) ;
|
i f ( x f i l e : : G e t O p e n F i l e N a m 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 L " " ;
|
}
|
|
i n t O n I m p o r t ( )
|
{
|
x e x c e l e x c e l ;
|
i f ( ! e x c e l . g e t N a t i v e P o i n t e r ( ) )
|
{
|
a l e r t ( "N ýÞc¥u5[Phh< " ) ;
|
r e t u r n 1 ;
|
}
|
x s t r i n g f i l e = G e t O p e n F i l e N a m e ( L " " , L " E x c e l 1eNö ( * . x l s x ) \ 0 * . x l s x ; * . x l s \ 0 E x c e l 9 7eNö ( * . x l s ) \ 0 * . x l s \ 0 P D FeNö ( * . p d f ) \ 0 * . p d f \ 0 " ,
|
L " x l s x " ) ;
|
i f ( f i l e ! = L " " )
|
{
|
e x c e l . O p e n D o c u m e n t ( f i l e ) ;
|
/ / e x c e l . p u t _ V i s i b l e ( t r u e ) ;
|
|
O n T r a n ( e x c e l ) ;
|
e x c e l . Q u i t ( ) ;
|
}
|
|
|
r e t u r n 1 ;
|
}
|
|
|
/ /T}NäSÑ^Qýep
|
i n t O n C m d D i s p a t c h ( x s t r i n g c o m d i d )
|
{
|
|
i f ( c o m d i d = = L " x m A d d R o w " )
|
{
|
r e t u r n O n I n s e r t R o w ( ) ;
|
}
|
e l s e i f ( c o m d i d = = L " x m D e l e t e R o w " )
|
{
|
r e t u r n O n D e l e t e R o w ( ) ;
|
}
|
e l s e i f ( c o m d i d = = L " x m I m p o r t " )
|
{
|
r e t u r n O n I m p o r t ( ) ;
|
}
|
e l s e i f ( c o m d i d = = L " x m S a v e " )
|
{
|
r e t u r n O n S a v e D a t a ( ) ;
|
}
|
|
e l s e i f ( c o m d i d = = L " x m T r a n s " )
|
{
|
x a s e r v e r a r g a r g ;
|
a r g . A d d A r g ( L " p a t h " , p a t h ) ;
|
O p e n W i n d o w ( L " d e v : x p a g e [ c o l u m n . t r a n s . v x ] " , a r g ) ;
|
r e t u r n 1 ;
|
}
|
r e t u r n 0 ;
|
}
|
|
/ /T}NäYtNNö
|
i n t O n X C o m m a n d ( T E v e n t * e v t , L P A R A M 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 - > x c o m m a n d . p S t r I D ) ;
|
}
|
|
i n t O n A t t a c h E v e n t ( )
|
{
|
/ /~Ñ[]åQwgap¹QûNNö
|
A t t a c h E v e n t ( L " W M _ X C O M M A N D " , ( F E v e n t ) & S a l a r y s l i p I m p V i e w : : O n X C o m m a n d ) ;
|
/ /·SÖq&p¹NNöÿ u(NÍn]åQwga
|
A t t a c h E v e n t ( L " W M _ S E T F O C U S " , ( F E v e n t ) & S a l a r y s l i p I m p V i e w : : O n S e t F o c u s ) ;
|
r e t u r n 1 ;
|
}
|
|
i n t S e t H e a d M a p ( x m l & x )
|
{
|
K X M L D O M E l e m e n t c o l u m n s = x . s e l e c t S i n g l e N o d e ( L " / / c e l l s / r o w [ @ r o w i n d e x = ' 5 ' ] " ) ;
|
K X M L D O M E l e m e n t h e a d s = x . s e l e c t S i n g l e N o d e ( L " / / c e l l s / r o w [ @ r o w i n d e x = ' 3 ' ] " ) ;
|
|
K X M L D O M N o d e L i s t n o d e s = c o l u m n s . s e l e c t N o d e s ( L " c e l l [ @ c o l u m n ] " ) ;
|
l o n g l e n s = n o d e s . l e n g t h ( ) ;
|
f o r ( i n t i = 0 ; i < l e n s ; i + + )
|
{
|
K X M L D O M E l e m e n t e l e = n o d e s . i t e m ( i ) ;
|
x s t r i n g c o l u m n = e l e . g e t A t t r i b u t e ( L " c o l u m n " ) ;
|
x s t r i n g c o l i n d e x = e l e . g e t A t t r i b u t e ( L " c o l i n d e x " ) ;
|
K X M L D O M N o d e n o d e = h e a d s . s e l e c t S i n g l e N o d e ( L " c e l l [ @ c o l i n d e x = ' " + c o l i n d e x + L " ' ] / t e x t " ) ;
|
i f ( n o d e )
|
{
|
x s t r i n g h e a d = n o d e . t e x t ( ) ;
|
m a p H e a d [ h e a d . c _ s t r ( ) ] = c o l u m n . c _ s t r ( ) ;
|
}
|
}
|
|
r e t u r n 1 ;
|
}
|
|
i n t o n l o a d ( )
|
{
|
p a t h = L " s a l a r y s l i p / t r a n s / h e a d " ;
|
|
d w _ l i s t = G e t C o n t r o l ( L " d w _ l i s t " ) ;
|
|
x m l x ;
|
i f ( x u r l : : g e t ( L " / s a l e / v i e w / e x p e n s e 3 / S a l a r y s l i p / l i s t " , L " " , x ) = = 1 )
|
{
|
d w _ l i s t . S e t D a t a O b j e c t ( x ) ;
|
S e t H e a d M a p ( x ) ;
|
}
|
/ / d w _ l i s t . o p e n U r l ( L " / s a l e / v i e w / e x p e n s e 3 / S a l a r y s l i p / l i s t " ) ;
|
|
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 ( ) ;
|
O n I m p o r t ( ) ;
|
|
r e t u r n 1 ;
|
}
|
} ;
|
|
