请选择 进入手机版 | 继续访问电脑版
搜索
猜你喜欢
查看: 3690|回复: 5

学位数据处理常用dbf替换命令

[复制链接]
being 发表于 2011-9-27 10:00:41 | 显示全部楼层 |阅读模式
购买主题 本主题需向作者支付 30 块医元 才能浏览
 楼主| being 发表于 2011-9-27 10:25:16 | 显示全部楼层

学位数据处理常用dbf替换命令

sele 1
; P" s) q% j1 |9 }$ Y9 e7 Euse dm
$ u5 ~" f, [: I" Dindex on xh tag xh" l+ u  o3 V/ Q9 J2 l% n9 K
sele 2
0 W/ |9 u, ~6 p- |9 Z" Ause mb) U- w  X) e+ S. }
index on xh tag xh
0 ]% P% d- ^3 R1 t2 }* y% `8 vset rela to xh into a/ W* J9 I# w: W* B1 B. A
repl all b.lwlxm with a.lwlxm for b.xh=a.xh
5 V( G5 \) k2 _' D7 a
 楼主| being 发表于 2013-3-19 15:08:47 | 显示全部楼层

学位数据处理常用dbf替换命令

repl all zzmmm with '13'
! M2 \; }7 G9 w% T# A1 F) \MODIFY STRUCTURE1 n- j* |. Y9 ~% z+ U
repl all ZYDM with '100701' for zymc='护理学'# p' T$ S. T- d) x
MODIFY STRUCTURE
( I) c% _7 \9 T) r2 O" W' Vrepl all ZYDM with '100701' for zymc='护理学'
& f1 M$ [6 \/ z7 {' r repl all ZYDM with '100201' for zymc='预防医学'% W+ w( q$ \' C" H8 L1 V
repl all ZYDM with '071502' for zymc='应用心理学'8 b8 V$ M% f3 i: z* E0 Q
repl all ZYDM with '100304' for zymc='医学检验'% U. l9 [2 h) D7 N( i  p
repl all ZYDM with '100401' for zymc='口腔医学'
4 `7 H: o. q8 }% F3 E# ~  f repl all ZYDM with '100801' for zymc='药学'# U0 t# v8 }  l5 d' H
repl all ZYDM with '100301' for zymc='临床医学'
' h8 @* W2 F8 o1 N+ I- Bbrow
* Q: q/ v( X+ SMODIFY STRUCTURE
" |! C8 s3 t# I0 x* P9 G- krepl all XXXSM with '02' for xxxs='业余'
; l% L, B7 o* ?; ^% _; Z  cbrow& k  d9 z5 ]( b% C# R1 {7 X% N# Y
MODIFY STRUCTURE
+ A! K, L) e0 a' q  c0 Z- xrepl all HXWRQ with '20121226'! J# J+ N8 q5 ?
repl all ZJLXM with "01"; Z  W' [: ?2 F# v$ H; Z3 z
repl all XWSYDWM with '10366'% n2 k. Y% V- Y6 o1 X
MODIFY STRUCTURE9 n2 c& S) R. c% Q$ h
repl all ZXXM with '张学军'
; |" k! z7 G9 l) VMODIFY STRUCTURE
" r2 D/ z/ C' |# F( p4 z$ srepl all ZP with allt(sfzh)+'.jpg'0 T2 L( I9 O9 O6 E3 c
brow9 o$ N, E/ f* L7 i
MODIFY STRUCTURE
" v6 {; P7 K& s: d! Wrepl all XZXM with '张学军'
+ ?% p+ ]. S9 S3 Y5 R& @MODIFY STRUCTURE& Y/ L" l1 M3 \! [
repl all PYDWM with '10366'% M2 A4 k, c- w. |5 T" s
 楼主| being 发表于 2013-6-4 15:25:59 | 显示全部楼层

学位数据处理常用dbf替换命令

repl all xwlb with '医学'2 c' @( {/ v+ @8 F5 @$ Y) x7 G
repl all xwlb with '理学' for xz='4'
& l8 U. _. {8 g' F2 A) E% i5 Trepl all xwlb with '工学' for xz='4' and zymc='生物医学工程'4 P; ]" _' Y- h$ d
repl all xwlb with '法学' for xz='4' and zymc='法学'
 楼主| being 发表于 2015-7-28 18:05:26 | 显示全部楼层

学位数据处理常用dbf替换命令

COPY TO c:\users\administrator\desktop\13.xls TYPE XL5# \! q- W2 i! x; E( Q
COPY TO c:\users\administrator\desktop\14.xls TYPE XL5
# t- j* w0 S: n: vCOPY TO "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012学位报送\12届毕业生学位授予名单.xls" TYPE XL5$ O! S5 |( M% J3 ]+ |/ N) o
COPY TO  q FOR sfzh='340211198012081018'
1 B( G$ y9 w/ _) M) E+ _( DAPPEND FROM  q8 B4 |1 b0 [# }2 S
. Y0 ^# }" D, F) A
BROWSE$ P8 O# R& i( N- Z4 J
APPEND FROM w
# V) J% g: }. S
$ m2 }8 }" [  q* L( lBROWSE. {% _5 r( o6 O; p: F
APPEND FROM w
9 S5 {0 X% c4 B% eBROWSE
, p0 |, W+ B" b& E( `/ ZAPPEND FROM w
- y+ {9 |- ?- sBROWSE
7 V/ ~" _( _/ d( _) U, HAPPEND FROM w
+ q8 Y3 ^8 U$ h: ^/ O. V5 {BROWSE& U% k8 ~2 Y( r, H' f
APPEND FROM 16 C' h8 F! Q; j7 T7 }) v
APPEND FROM 2
! g& R$ w  s7 kBROWSE
3 m' U; v7 }  n$ eAPPEND FROM 3  g0 {$ |; E9 S
BROWSE
3 L. P9 d0 X, r4 y2 `& Q6 y' CAPPEND FROM 12 Z# }& u7 i; L8 Q3 D6 J4 f* a
APPEND FROM 2
% T! v) V% H% c1 x  s5 }8 g# NAPPEND FROM 3' G: @2 h$ k) @7 R
BROWSE, n" ?8 ]) E# c6 a
MODIFY STRUCTURE
/ ]7 V' f7 ]+ E% ^8 l5 F' CBROWSE
& A$ q$ R! r! g5 |3 j0 |MODIFY STRUCTURE
5 Y# d" ]# s4 f" u0 l& W& e0 SBROWSE
9 K' s. L% n5 N* ^  ^# aAPPEND FROM 4
, J0 I, ?0 k; S' B7 QBROWSE
/ P* Y& t& g( g% W/ G9 Z+ jREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 68,68
; a' p; f" B5 A& q( G' i- D" {2 t6 nREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 69,71
1 T5 }6 N8 A9 Z5 Z5 [7 }' {3 GREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 69,69$ D, U, n- V! q% Q& p
REPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 39,397 @  I  S, v$ V. a2 G
REPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 40,447 c$ O) ~( O7 n  g. S$ a
REPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 46,46
1 @! L" d3 Q* `. v- `6 m8 C0 _3 AREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 45,45
: \) D2 A1 d1 `7 a& nDELETE ALL
2 _5 R3 ~; C' j0 V" f" Y* C' r# E[acl& Y5 ?0 N& z% {8 B
PACK
# x. Z+ n  V8 e8 ]
0 B, d* _7 t5 Y# `9 B1 fBROWSE
" w* B4 V$ f0 _* H( f5 pMODIFY STRUCTURE$ r* U% s- H7 M, x' T
REPLACE ALL ZXXM WITH '曹云霞'' F+ J+ H3 A8 u* o
BROWSE
& A. z5 A* J4 f: N& {$ yREPLACE ALL xbm WITH ALLTRIM(xbm)
/ {4 u1 v7 w9 k6 ~6 A* u/ u5 o9 c- HREPLACE ALL zzmm WITH ALLTRIM(zzmm)
4 V$ U  h6 J4 H0 |/ D9 ^REPLACE ALL zzmmm WITH ALLTRIM(zzmmm)/ K+ }0 }9 `+ ~& O( q8 Y+ r" C( Z0 j
REPLACE ALL xwsydwm WITH ALLTRIM(xwsydwm)
! H/ N. W: N' SREPLACE ALL pydwm WITH ALLTRIM(pydwm)( C$ Y4 ]+ s5 n( r3 C
MODIFY STRUCTURE
+ R* F! T6 f) d( [* f) {7 b, s6 G; YREPLACE ALL pydwm WITH ALLTRIM(pydwm)
' M1 c3 [; V: K: Z- G/ N6 s+ _) fBROWSE! }6 Y* Y% L, l$ s& Y  V5 q5 Z7 p! E
REPLACE ALL xwlbm WITH ALLTRIM(xwlbm)9 Z  T1 P; X) Z4 g* I, b
DELETE ALL
3 P9 }- q: U7 W5 X* h# B+ k* `* B4 c
PACK/ K* ^! ]: u$ ^: O
) r6 {) l7 \  y. y; T
APPEND FROM 1
+ o' D7 L# l  p. e# pBROWSE
9 h# o) @& Z  ~9 L" KMODIFY STRUCTURE4 B6 L4 P9 i' S; w6 R
COPY TO c:\users\administrator\desktop\1.xls TYPE XL5' j# y# n* T( Q; [  X* }/ v
DELETE ALL
4 K, D; F3 l; F- n8 t; o6 m7 f5 `& K* H) v0 T
PACK0 M" Q2 i# [* @# R, |
app
2 ]8 q* G5 g, ~9 P+ Q0 x, eREPLACE ALL hxwrq WITH ALLTRIM(hxwrq)
8 J2 S8 o( ^, v9 }REPLACE ALL byny WITH ALLTRIM(byny)
& m% H3 n3 m3 m! AREPLACE ALL wyksny WITH ALLTRIM(wyksny)
4 O6 S8 x: t, }- kREPLACE ALL rxny WITH ALLTRIM(rxny)* ?1 A9 Q5 h' S: \  O2 _
REPLACE ALL zydm WITH ALLTRIM(zydm)
/ `2 w; k4 x! C! SREPLACE ALL xz WITH ALLTRIM(xz)+ [. |, t3 q7 w4 e
REPLACE ALL xwlbm WITH ALLTRIM(xwlbm)  P- x' e$ C7 z' k
MODIFY STRUCTURE: K( X; b. ^$ I9 r1 J
REPLACE ALL xwlbm WITH ALLTRIM(xwlbm)
! R6 p6 u6 L1 sBROWSE
! R$ {) T* G/ V! Y2 `. K" IREPLACE ALL zp WITH ALLTRIM(zp)+'.jpg'
+ X" P! \# ?) lREPLACE ALL zp WITH ALLT(zp)+'.jpg'
( y; X# {9 q4 b9 n, BREPLACE ALL zp WITH ALLT(sfzh)+'.jpg'3 |% V% v* L, y( n) j+ m
REPLACE ALL zp WITH ALLT(zjhm)+'.jpg'
: F- u0 f+ ?9 d1 \/ v/ m0 R, ZMODIFY STRUCTURE% `1 i5 ^4 a# v, W% @" G
REPLACE ALL zp WITH ALLT(zjhm)+'.jpg'( {$ A; A! g4 f
BROWSE
2 S) v- X" f% q$ z0 V4 _REPLACE ALL xh WITH ALLTRIM(xh)
" a3 E! ~2 s1 wAPPEND FROM 1! v% J/ x8 \2 S5 k4 g
BROWSE0 B8 H& k1 H' E
REPLACE ALL xwzsbh WITH 'Z103663201420'+ RIGHT('0000'+ALLTRIM(STR(RECNO())),4)
; s9 h" Z9 f7 b6 q' q1 V  l% y( TREPLACE ALL xwzsbh WITH '103663201420'+ RIGHT('0000'+ALLTRIM(STR(RECNO())),4)
8 H2 ]1 s' _& u- l1 S& Fsort on zymc,zyfx,xh to 38 k. Y# w6 C9 w
sort on zymc,xh to 3
/ H" z0 ?/ s: B* J* pDELETE ALL
  e! g! @( h" IPACK* o7 Z8 V! J$ U+ Y+ t4 T1 y  X" @) ~

" _- O9 E5 e, F2 mAPPEND FROM 3) |2 m( {% g2 @' x6 u
BROWSE
$ L$ _) v( I* n1 d! `. ~3 j: Asort on zymc,xh to 1
+ ~# j' Q& u7 Y" P- q( _sort on zymc,xh to 11
' V7 `) i8 S9 l! v/ RDELETE ALL+ q( m& e! ^9 m) Y( _
PACK
6 u) B  e6 V, l, c: ~1 A
/ Q3 n! O2 d9 wAPPEND FROM 119 k; {# {9 Q4 k% v& ^
BROWSE
% j+ C" O9 @2 ?' yREPLACE ALL hxwrq WITH '20141226'$ a1 I2 E- C5 n
REPLACE ALL SUBSTR(xwzsbh,6,1) WITH '4'7 i4 N2 j9 ]+ v/ B2 ~) {
sort on zymc,xh to 33 ?8 i! |( \% q, p
sort on zymc,xm to 3
' h& a, q2 P, j$ u2 Y2 K* M6 xREPLACE ALL xwzsbh WITH '103664201420'+ RIGHT('0000'+ALLTRIM(STR(RECNO())),4)) A, D: _3 y# k
DELETE ALL& C' F$ w7 Q# q" _
PACK
2 e  |, a$ b2 m+ O& a0 I; [5 z4 {/ o7 FAPPEND FROM 3
3 K; l' t2 T1 \7 G) z6 l, D1 aBROWSE
! H$ X" E1 e+ d  m7 Wsort on zymc,xh to 3* g+ M- @: o0 T: d7 ^4 e# h2 l$ I
REPLACE ALL csrq
) n% {& O" m, A) WREPLACE ALL csrq WITH SUBSTR(sfzh,7,8)
/ N5 Y8 ^! Y; g2 AREPLACE ALL csrq WITH SUBSTR(zjhm,7,8); P% B- [. {  W  ^: s' T* s
COPY TO c:\users\administrator\desktop\14学位.xls TYPE XL5
5 ^/ `. r* O) k: ~: QCOPY TO l FOR xm='刘芳侠'
* ^) U0 \, C. y  v% c- ?APPEND FROM l, s; s9 n$ \7 C  J- f
BROWSE
% P% m9 K# ~$ T. ?$ WREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 72,72
! ~' w! K* r' n3 S- I7 g% R7 sCOPY TO h FOR hbs='h'
. [( K% n& E3 j/ @" fCOPY TO h FOR hbs='H') a' z% a4 S2 }8 `
COPY TO Y FOR XM='杨绽青'/ D7 I3 {6 o! ?$ `0 G5 J
COPY TO l FOR xm='李亚奎'1 }- b# A9 S+ C3 z1 r
APPEND FROM l- k4 c; M9 Q- {  ?% y7 a* H
. G4 L; j/ P! z  q& z
BROWSE, F0 Y# L3 t. c
MODIFY STRUCTURE
+ E3 ?- C2 j* z/ i) b- \BROWSE6 X5 h; \$ r8 f) Z
MODIFY STRUCTURE
( ?. |! |. K4 s5 O) w/ dBROWSE! P: ~" k* l: y2 D2 b0 u( a3 B* M8 H
sort on zymc,xm to 3
5 T: Z( E3 U# M; mREPLACE ALL xwzsbh WITH '103664201421'+ RIGHT('0000'+ALLTRIM(STR(RECNO())),4)) w* N# [6 B  {& _# `0 i0 t8 V0 v& ^- d
sort on zymc,xh to 3' G% q$ T! U. v
sort on zymc,xh to 33  r4 J# |1 U5 I" o" l% t$ b
COPY TO b FOR bz='2007本硕连读硕士阶段'
% Q; `* D7 L5 R( k( d$ HREPORT FORM "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012证书打印\学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 55,55
" T# K: Z5 _& q6 O# K# d7 }) L7 UREPORT FORM "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012证书打印\毕业证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 55,55
- c; v  M; u7 c; [. P* `! TCOPY To
2 ?$ E4 ?! u. L3 h% nCOPY TO w FOR xm='王良华'
. ]" C  L+ E4 B( o  M$ J5 YAPPEND FROM w3 U4 F' b# A$ ~* H3 k" [
BROWSE
; h) x8 `) t" Q/ C% D& cAPPEND FROM l: t# L! _4 V) k8 m5 m# H( C
BROWSE
: T) V; D0 \( d, g! V  y6 wCOPY TO x
! }( T4 t& ?" \  r5 HCOPY TO x FOR xm='肖俏'/ I) ]5 M( E2 k! G; y9 k1 v
APPEND FROM  x9 o. J( d  S1 ^+ t1 g& g
BROWSE
$ Q1 f- I+ m$ zAPPEND FROM  x- l1 |1 E2 w" K% C2 m
COPY TO l FOR xm='刘星'
5 Q7 }$ T7 n# v  \/ G1 |6 WPACK% u' m1 y$ V/ E: \0 K+ |% }/ H1 j
APPEND FROM l, ^$ T7 [$ |5 ^* i4 m+ @
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 73,75
, A1 V9 S" d; W+ s7 S2 w, J; MREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 73,73
: p& X: w5 y8 ]3 T  xREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 47,486 j1 J, n" ?- I4 ^$ j
REPORT FORM "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012证书打印\毕业证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 55,55( |, S2 T; S; u0 ^. d  i
REPORT FORM "d:\工作文件\08-09\08092\学籍\2009届毕业生\证书打印\09毕业证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 574,574
  G6 A) D+ V/ N2 O5 zREPORT FORM "d:\工作文件\14-15\14151\2015年第一次学位报送(20150130已报送)\学位证书打印2014\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 7,8
/ p, G# J; u/ C4 v" GREPORT FORM "d:\工作文件\14-15\14151\2015年第一次学位报送(20150130已报送)\学位证书打印2014\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1,10 U# Z  e/ |# ]9 O" A0 l2 Q+ X
REPORT FORM "d:\工作文件\14-15\14151\2015年第一次学位报送(20150130已报送)\学位证书打印2014\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 7,8
. Q. @4 k6 [2 F) y; R8 o* I8 WMODIFY STRUCTURE; r; T" ]8 N4 F, F9 j% {/ S! h! a
sele 1
1 W" \+ ]7 p8 ]) D2 Z% k; o! wuse dm: ]4 m$ }1 H0 }! A0 C) c9 t# N
index on xh tag xh1 c0 R0 |+ ?$ r/ D
sele 24 D6 M2 M* S" Q. M5 e1 O$ W& q
use mb9 c+ c, I0 t% B# G8 a& f  C
index on xh tag xh
0 W& n/ b& V( I; H; }/ jset rela to xh into a& B* {  D  m% V& q- ?
repl all b.xz with 'x' for a.xh=b.xh9 A7 U8 t9 c; V, Z3 ]6 m
COPY TO xzxk FOR xz='x'; @) C0 R' v7 s+ ~
PACK5 `! v4 x% l; k) K& F
MODIFY STRUCTURE4 J8 d9 w! P7 F6 b4 l9 i
COPY TO "d:\工作文件\重修\2014-2015-2\重修证打印\xx.xls" TYPE XL59 |: J: ~/ X2 K' N
REPORT FORM "d:\工作文件\重修\2014-2015-2\重修证打印\xwzmsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1,10 p9 c; \- n6 n; {! Q1 u
REPORT FORM "d:\工作文件\重修\2014-2015-2\重修证打印\xwzmsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 2,2
, x0 @# p. F# {/ C5 C$ eREPORT FORM "d:\工作文件\重修\2014-2015-2\重修证打印\xwzmsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 3,65534
1 V/ z' _2 t/ qREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 76,76
! [' z& c# \/ Q  Z9 k/ [( N2 Q3 UREPLACE ALL  zymc WITH ALLTRIM(zymc)
% `' P5 J. N# _; d% P& x3 tREPLACE ALL  xzbdm WITH ALLTRIM(xzbdm)
* z. F# T1 z6 _0 h) mREPLACE ALL  xbbdm WITH ALLTRIM(xbbdm)' q1 T$ `6 l7 `' }5 f' L! W  X
MODIFY STRUCTURE
% q7 k; Y: Y0 S, j; nREPLACE ALL  xbbdm WITH ALLTRIM(xbbdm)" {/ _: \8 o2 r% m' R( I5 {- S
BROWSE
3 a7 I8 K, e& k8 H: v# y! WCOPY TO d:\22.dbf* D5 h( ~; _. s" u! S; d
COPY TO l FOR xz='4'
2 \; Y# _/ o3 YDELETE ALL FOR SUBSTR(csrq,1,4)='2004'1 S# [% U- x3 U/ u" r$ |! w6 N" v1 {
DELETE ALL FOR SUBS(rxrq,1,4)='2004'+ u8 @% z. z$ s* T/ d
DELETE ALL FOR SUBS(rxrq,1,4)='2005'0 J& r* _- w+ ?) _
COPY TO lll FOR SUBS(rxrq,1,4)='2004'# W  ~6 Q* p/ s9 d: C9 J+ m5 x
COPY TO c:\users\administrator\desktop\xl_2009_10\111.xls TYPE XL55 w+ {4 |6 L& S2 k7 J# h9 {" D
COPY TO 4 FOR xz='4' OR xz =' '
7 k7 t- @4 U' o9 v4 ICOPY TO 4 FOR xz =' '
$ ^" p$ O. v5 K# W" H7 [COPY TO 5 FOR xz =' ': d+ T8 f5 ^3 ^& s( Y. L) {
COPY TO 5 FOR xz ='4'
  ^0 y2 o+ L2 ACOPY TO "d:\工作文件\13-14\13142\学籍\2014毕业班\14.xls" TYPE XL5
9 n- I; g- \: r9 U2 c" w$ G8 w3 n0 YCOPY TO c FOR xm='常晶晶'/ d2 G4 a: T. U2 ]
APPEND FROM c
+ M! S" |# \3 p  S
9 z$ o: T- o  O- F5 NBROWSE1 x( ~  [  l3 u5 `
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 77,775 F& ?$ C8 i& N
DELETE ALL
7 G& h1 W- d$ H/ ]0 QPACK$ Y' @, ^. ]) @7 q% z- }
BROWSE
# }1 Q7 ?; H2 J6 wCOPY TO y FOR xm='杨洋'$ f# j" v0 l1 ~; n8 S3 r
APPEND FROM y6 _3 @8 e& D! e+ q% X( j
BROWSE
$ P  d1 {3 ~* v# AREPORT FORM c:\users\administrator\desktop\学位证书\xwzsdy.frx NOEJECT NOCONSOLE TO PRINTER
* x$ r) r" N6 l( Y/ U- JMODIFY STRUCTURE
' L) a4 F2 ]8 B( C$ LCOPY TO 62 FOR yy>=62 AND zyk>=72 AND zf>=140
! [' e7 g" W8 B: i; N3 yCOPY TO 62 FOR yy>=61 AND zyk>=72 AND zf>=140
5 [" D/ O, j. t5 q4 X# aCOPY TO 61 FOR yy>=61 AND zyk>=72 AND zf>=140( p2 K) \, F% n# }$ p, w
COPY TO 63 FOR yy>=63 AND zyk>=72 AND zf>=140' v) Z, A8 t! y9 I- Z: g  C3 y( w, d
COPY TO w FOR xm='汪伟'
) K$ o/ t9 M5 Z, H3 Z9 o" G! J0 BAPPEND FROM w+ s1 a  D0 ]. I6 P
BROWSE, A) j9 Z8 B! D
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 78,78& R# t9 l1 i' F+ w7 p3 m: Z
COPY TO s FOR xm='孙陈国': F- l; O9 J$ c" R5 V
APPEND FROM s
6 c8 J. d, \0 n2 g$ R9 ^BROWSE! e7 m1 y0 K! ]' I  F# x
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 79,79
8 h- _$ j3 k+ P- c$ mREPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1,1
; z1 ]+ ?2 v! R' U* U5 ~( UREPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 2,2
- ]; {' V0 i0 f0 H' @: lREPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1,1% i1 a. W! d  w. ]8 L# U
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 2,100' ?$ P& W0 ~2 ?5 j* T6 {& S
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 101,2001 Q8 ^1 y' b; e/ N- w. L
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 201,500
3 u% `& W* y4 P% jREPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 496,5004 |8 e' q/ K/ n- F
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 501,600
+ {. A3 `3 E8 d0 C! ?7 ]. xCOPY TO c:\users\administrator\desktop\bs.xls TYPE XL5
. u  E& ~  Q# l5 o$ xREPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 601,65534# R, W8 i- c+ T
APPEND FROM y
7 j( \& g8 R6 d5 BBROWSE
" G. s# {  v3 e" |6 N( K1 a6 n5 n. R  dAPPEND FROM y
; ~& q* u. c, L" F# VREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 49,49
( S3 y  e# N* k4 Q0 f8 K% ZREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 80,80. l! O. s" u# i; w
COPY TO c:\users\administrator\desktop\15届毕业生信息.xls TYPE XL5
& s1 c; G" ^0 XCOPY TO c:\users\administrator\desktop\2015届本硕连读预计毕业生信息.xls TYPE XL5
, m# a. ?! S; ?) vCOPY TO c:\users\administrator\desktop\10本硕本科阶段毕业生信息.xls TYPE XL5
9 q1 ]3 j4 f* S% vCOPY TO c:\users\administrator\desktop\10本硕本科阶段毕业生信息2.xls TYPE XL5
# y8 b! M0 b/ h, d+ bCOPY TO c:\users\administrator\desktop\qx.xls TYPE XL5
+ r1 m. t  l# E) i* [APPEND FROM 2" R: a5 S. a3 g5 b6 a& L
APPEND FROM 3
/ w1 i* M3 H$ c5 `/ `+ L; w  dBROWSE
9 u& T2 u# E$ O1 D; u! c0 Z& qAPPEND FROM 35 l( u" t7 n. Q4 a5 r0 r* J5 l6 A
BROWSE$ p. e: X  s+ k0 `3 M
SORT TO 2 ON
. @+ c5 m( V3 U0 P% Q5 \5 DCOPY TO c:\users\administrator\desktop\2015毕业班\15毕业信息初稿20150526.xls TYPE XL5
- T$ Z% Y5 U; ?4 m, s0 HDELETE ALL
8 X" r) _& j" zPACK
3 Y" a7 n- b  B% XAPPEND FROM 1
* r7 L" k* t7 S7 y: ~' s4 o' D! CBROWSE8 ~. Q: [. w. ^8 y4 Z
COPY TO c:\users\administrator\desktop\2015毕业班\15毕业信息初稿20150526.xls TYPE XL57 R0 i! ?- s7 b6 C; B. s
DELETE ALL. X( M- H6 W' V
PACK
! C( ?% T) ]- j8 D( lAPPEND FROM 22
0 h. P( c' K; v! l/ fBROWSE
, t+ n& }7 S& ~$ N1 Y! t5 PCOPY TO l FOR zymc='临床医学' AND xz='4'
0 _$ T: j8 Z; G9 F1 b$ H; fDELETE ALL FOR zymc='临床医学' AND xz='4'/ J: |- \4 O2 ?7 P$ m' j
PACK
5 S# R. k% M6 R# j  ADELETE ALL FOR ksh='11340881151043'; S( i# b5 W% n9 a# L% i; E
PACK
& `$ S  q1 {) {BROWSE
6 N9 ^0 l5 c& \: {$ yCOPY TO 10bs FOR bz<>''( n: v. y9 p& y" B% ]7 C
COPY TO 10bs FOR bz<>' '6 |5 B* T4 k- p
COPY TO c:\users\administrator\desktop\2015毕业班\10bs.xls TYPE XL5
# E8 M& k, F: w# h+ H3 Z) v  h& ZREPLACE ALL xz='5'0 T9 J' K, r; A) [
REPLACE xz='5'7 f. c; X+ u  M$ }  X8 E3 G
REPLACE all xz WITH '5'
! X1 A; z2 ~" _" f& e% P- pBROWSE$ R. L( \1 o5 M9 ]/ U9 L
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 76,78
! i6 K. x0 {$ n. _" U7 |REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 28,41% y# K  b6 b' V0 o" K$ [2 I
COPY 头3 x$ M. c2 Y4 D1 b0 q  q) \9 Q+ S  f+ n
COPY TO 08bs FOR cc='研究生', \7 t1 M: h$ h% {- `% ]1 C
COPY TO 08bs FOR cc='硕士研究生'
5 D7 f! B" B+ e" X  MCOPY TO c:\users\administrator\desktop\2015毕业班\08bs.xls TYPE XL5
6 `3 i7 {9 G" a2 eMODIFY STRUCTURE6 S0 f+ \+ n: Y- N( _. R
REPLACE ALL xh WITH ALLTRIM(xh)
1 I( O6 A' Z# A5 BBROWSE; A+ l; P0 _) M1 [6 l8 ~  A
MODIFY STRUCTURE0 }  v) V' I2 M6 n9 h
REPLACE ALL xh WITH ALLTRIM(xh): R. Y2 N8 h  h, h7 b& N
MODIFY STRUCTURE
7 A. ?. h# m' q  EUSE 1" _$ T% ^/ R# h! }% `. P9 R, \6 X
SELECT 1; s4 p$ U4 v( ~
USE c:\users\administrator\desktop\dm.dbf1 z. j) J% n, f: Z6 k

, G' ~# j; G, Y# ^$ FSET RELATION TO xh INTO dm
) @! @: t( f8 ?1 g+ C0 W3 {USE c:\users\administrator\desktop\dm.dbf4 y/ n. B3 o% H4 J  l7 N) A
INDEX on xh TAG xh1 I# [( c4 y( f" f9 ~# M( |
SET RELATION TO xh INTO a5 O; i. ~; L$ w( N5 w
SELECT 2- y6 H3 o9 e6 u  z1 P$ ]4 _8 V
USE mb
, C1 u9 M) u; l. bINDEX on xh TAG xh
0 n1 x% m. y0 }& R5 u. X  xSET RELATION TO xh INTO a$ e5 C1 a* U' a# A" W8 H
REPLACE ALL b.jn WITH a.jn FOR b.xh=a.xh
4 J7 w  a7 O7 T4 f. DCOPY TO k FOR jn=' '
$ T- J8 V) q' `% p$ N" K4 MCOPY TO k FOR jn=''9 Z6 l* ^& E7 n, w5 F
COPY TO k FOR jn is null
% N$ j9 ^* S; V$ D9 dCOPY TO k FOR jn=' '
1 k1 e( u6 i1 y7 Q3 D0 U# _- k: r# xCOPY TO c:\users\administrator\desktop\zp.xls TYPE XL53 ~( a& e( s$ i# I/ H
COPY TO c:\users\administrator\desktop\2015届毕业班实习成绩处理.xls TYPE XL5
3 Q7 k5 ~' R, {2 JMODIFY STRUCTURE7 d. e8 ?3 }8 Y* y0 N3 @
REPLACE ALL xkkh WITH '(2014-2015-2)-30000002-00000000-'
. S& d- u; Q8 U9 B. D% j& {3 iBROWSE
% y! M6 x  Z3 W4 R: d( E# q% Q* Bsele 12 D+ M: E3 L7 c4 G- D
use dm9 J, s* `! P/ G

; I+ H4 _0 k. q- X8 q  Q7 usele 1& y, a5 c- `( l& |& y9 i: q! V
use dm
8 m9 ?8 M! y! Q4 m/ C; Xindex on ksh tag ksh
# ]9 W' P$ T! Q2 t# }sele 2% {/ ~! @+ y' @1 u- S5 _; D$ ~3 {( E
use mb3 m8 B) [3 W( @% _9 I) y' U) _- N; H2 ~
index on ksh tag ksh1 f! v& R- n9 K/ n  N8 V( y! Q
set rela to ksh into a# U; h" u  [7 d/ T. L% \
repl all b.zymc with a.zymc for b.ksh=a.ksh) Z(3 B5 Q6 d5 L) y8 @0 @$ ]
MODIFY STRUCTURE
$ t& n- N7 L7 x$ Isele 1
; i! v3 m% J! o8 ouse dm
* k4 Z; M3 M9 `4 z4 oREPLACE ALL xh WITH ALLTRIM(xh)7 t) w  x6 x5 e% D/ c6 _# \8 M
sele 1
% \! D( S2 \( u( h$ Puse dm
1 \( j9 w+ O9 A. g& A/ Oindex on xh tag xh
; C' O! w/ ?- A) wsele 2
6 n+ R4 o* h, y: ^use mb. |" Y. U1 ?* x
index on xh tag xh& M# P8 l# @3 q! t
set rela to xh into a
! Q3 F# m# a; {+ Qrepl all b.erji with a.erji for b.xh=a.xh9 K& H6 s3 O  Z) b/ W0 \, o
repl all b.siji with a.siji for b.xh=a.xh( L- ~. M' G5 X8 c) k
repl all b.liuji with a.liuji for b.xh=a.xh
$ B& \: W* D: E$ m8 T0 ?COPY TO sijierji FOR erji<'60'0 v! a9 G' D. c* x
COPY TO sijierji FOR erji<'60' OR siji<'400'- B3 `! y6 }' B
COPY TO liuji FOR liuji<'400' AND cc='硕士'8 H* k9 e  v# s3 @9 n0 X: x4 O
COPY TO c:\users\administrator\desktop\2015毕业班\六级未过400名单.xls TYPE XL5
; B5 _1 R- d  i" k4 ]7 O+ aCOPY TO c:\users\administrator\desktop\2015毕业班\四级二级未过名单.xls TYPE XL5
( x# }" n9 ]  I5 O( yCOPY TO "d:\工作文件\14-15\14152\成教学位证书打印\2014年成人教育学位.xls" TYPE XL5; i: {3 d8 E9 n7 w7 W$ d% x% E1 J
COPY TO c:\users\administrator\desktop\毕业班名单.xls TYPE XL5! @) T1 f# d  _
COPY TO c:\users\administrator\desktop\预审.xls TYPE XL5
' y) H* ]" e. n: }REPLACE ALL xz WITH '5' FOR xz='7'
- ^; z) ?5 x4 ]6 Q5 t) G/ WCOPY TO bs FOR bz='10'& n9 q. V' L5 r2 _. v5 ~  d& K% i
COPY TO bs FOR bz='10本硕'! Q6 M8 l: ]' r+ r. W6 I
COPY TO bs FOR bz='本硕'
8 j' [- s- }( KCOPY TO bs FOR bz='2010本硕本科阶'6 Q# R9 {; i9 ^& f
sort on ksh to 17 e8 J3 ?- b* S) m4 J7 ~
REPLACE ALL byrq WITH '20150701'* N( v. ]9 [: t4 x8 W
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 1,1
1 m3 R; o( i( [! V0 J- iREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER0 Z2 a4 Q! j  v1 h
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 2,100; o! i" Y* G3 ]3 ^4 g" |+ M
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 101,458
, u% f/ |: l# O/ x2 Crepl all xwlb with '理学' for zymc='生物技术'
! }2 Y% h1 o$ j) C" L) erepl all xwlb with '法学' for zymc='法学'
5 q- d/ `* ^, v- d: j) orepl all xwlb with '理学' for zymc='卫生检验') f& F# e6 y: ~, @6 ]- z
repl all xwlb with '理学' for zyfx='药品监督与管理'
% a% \1 {* ?; Z' A. s* Yrepl all xwlb with '理学' for zyfx='药品营销'
- o1 W& v9 l8 P0 w8 X2 H% w7 {repl all xwlb with '理学' for zymc='中药学'
/ A, R4 y/ F! S6 V6 F, wrepl all xwlb with '医学' for xwlb=' '
0 z- ^1 O! e6 }/ A- _' O/ q2 s( erepl all xwlb with '管理学' for zyfx='劳动与社会保障'. U7 x4 K  g. R& N
repl all xwlb with '管理学' for zymc='劳动与社会保障'/ N, P% |4 o( b
repl all zymc2 WITH ALLTRIM(zymc)+"(ALLTRIM(zyfx))"
: O( l3 |' R4 H: |* z- C6 Wrepl all zymc2 WITH ALLTRIM(zymc)+"("+ALLTRIM(zyfx)+"+"9 E) j+ f$ S- u3 ?  k, w6 j
repl all zymc2 WITH ALLTRIM(zymc)+"("+ALLTRIM(zyfx)+")"
) l3 K1 J* C' v3 a) y% \/ urepl all zymc2 WITH ALLTRIM(zymc)+"("+ALLTRIM(zyfx)+")" FOR zyfx<>' '; D5 {- s- W9 z5 l. C
repl all zymc2 WITH ' ' FOR zyfx=' '
. B1 O$ |- M- d& t: ~5 Erepl all xwlb with '理学' for zymc='食品质量与安全'
. u: l* D2 D" Vrepl all xwlb with '工学' for zymc='生物医学工程'4 h0 E1 o1 T1 i1 n* ^1 i: d( c
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 671,10006 u+ l8 S( d* F& p2 N/ i
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 1001,1500
: C2 T& _# b1 t# |+ SCOPY TO fxz FOR zyfx<>' '  G" Y9 j9 R0 |( f
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 1501,65534
, ]& Z* w* x% b% IREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\08本硕毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 459,670
  H8 s5 D2 }, _7 M, iREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\专升本毕业证书打印2014\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 353,353
% d2 R; b: x& H$ n1 d, TREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\专升本毕业证书打印2014\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 354,380
  d- L* w$ {$ M  b2 H- A( kREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\专升本毕业证书打印2014\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 356,3802 K- }5 r4 U5 r( Y+ U" P! I
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 1748,1748
5 j$ s& M0 n& l0 k7 \* S* kREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 353,353$ p' N- t  \9 Y6 a) E* j; s" F
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 380,380" x7 S. J$ c8 i6 r# }& B; H7 n6 s
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\08本硕专业学位证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 481,670
1 W5 O1 F) P* O3 f8 E+ AMODIFY STRUCTURE
2 h+ f8 f9 _) X: ]( w9 bREPLACE ALL xh WITH ALLTRIM(xh)* U) s* Y. {  p' d% r
sele 1
1 D9 h" p" @. Wuse dm
! \# r  A8 W0 Sindex on xh tag xh" s$ h6 k% @2 _4 l" |6 |1 K2 S& R
sele 2: Q  h1 K0 }" t
use mb
8 X" n+ y) w+ d4 d; G! U/ i7 zindex on xh tag xh. k- a% C9 {$ w( r) R7 g1 o& b
set rela to xh into a0 i: S# z- @1 B# O; C' ]
repl all b.jd with a.jd for b.xh=a.xh( @% e6 S+ o: `
BROWSE
; {2 [- N, E* J+ p* q" uCOPY TO 2 FOR jd<>' '
/ p2 ]9 Y( d6 b7 r: ^( K6 {COPY TO 2 FOR jd<>''
6 x4 V6 M# l1 A* eCOPY TO 2 FOR jd<> ' '
+ y0 t8 M( O* QCOPY TO c:\users\administrator\desktop\222.xls TYPE XL5
! k, h, x: x3 V# |/ k6 v$ U; k3 uCOPY TO 2 FOR jd<'2', {, t6 t# l  }. A9 K0 A
c6 _3 p# a8 Q; P: U
REPLACE ALL  jd WITH ALLTRIM(jd)0 u( t) R4 G4 Z
COPY TO 2 FOR jd<>' '0 D) K  O& f5 z6 a, ~
COPY TO 2 FOR jd<>' ' OR siji<'400'9 `; B# Y+ n8 |* v) ~3 B# H- Y
COPY TO 2 FOR jd<>' ' OR siji<'400' OR erji<'60' " V" w. x$ [" ~. a" z% A! v
COPY TO c:\users\administrator\desktop\绩点2.0和四六级计算机二级名单.xls TYPE XL5
/ D  a: j* h5 i5 g, c" {2 q% K# VREPLACE ALL zyfx WITH '医疗保险' FOR zymc='劳动与社会保障'
) ~# e1 U% L7 z/ x+ q% z5 UREPLACE ALL zymc2 WITH ALLTRIM(zymc)+ALLTRIM(zyfx) FOR zymc='劳动与社会保障'
" |% g( S: @8 n2 jREPLACE ALL zymc2 WITH ALLTRIM(zymc)+ALLTRIM(zyfx) FOR zyfx<>' '
8 h7 i* z2 z* g' {, f" {( Y) QREPLACE ALL zymc2 WITH ALLTRIM(zymc) FOR zyfx=' '4 t. }: H( q4 L
REPLACE ALL zymc2 WITH ALLTRIM(zymc)+'('+ALLTRIM(zyfx)+')' FOR zyfx<>' '6 p$ C) G. U. |1 y5 l  X
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\方向证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 439,458; n7 ^( e1 ^8 p# K% [
COPY TO fxz FOR zyfx<>' '! I! ~9 ^+ ^7 E+ c
REPLACE ALL zyfxzh WITH 'FX103662015'+ RIGHT('0564'+ALLTRIM(STR(RECNO())),4) for zymc='劳动与社会保障'
% L' [' }" d- K, }3 c: hSORT TO 2 ON zyfxzh
/ u4 ^6 ], W( g6 z9 H* k" X3 S+ ^COPY TO c:\users\administrator\desktop\2015毕业班\2222.xls TYPE XL5
& A$ w! D; N& f7 G( r: w5 fREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\方向证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 439,458
) ^  Y$ u' k+ X" w7 M* Q6 u% ~REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\方向证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 439,4398 ^; }+ q6 c% @
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\学位证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 252,252
1 l! _; @) ~0 Q+ S, {% NCOPY TO c:\users\administrator\desktop\2015毕业班\2015届毕业班证书发放表.xls TYPE XL5+ y+ z/ ?6 R9 F# a9 [1 o
APPEND FROM p
# x5 F- A9 s8 q; e( \8 dBROWSE3 t3 U3 E0 x; W5 e% Z$ J7 ]. S$ {
REPLACE ALL bjyjl WITh& O# p+ x0 l# k; L0 f9 s
REPLACE ALL bjyjl WITH '毕业'4 |, s2 X" P* b" K' O! T. S
APPEND FROM p/ R' e( w6 Y$ w& g
REPLACE ALL xzm WITH '曹云霞'
6 r8 M, _- \$ `" W/ l3 D' Vsele 1: t( @2 a. m0 y- Y: o2 V
use dm2 i  v2 l+ X# W  b- {8 |2 S  i" J
index on xh tag xh
; Y4 N7 g% q# }3 A7 {6 i" ~1 O3 nsele 2. D+ B2 ]; J2 q7 A; F* b. I/ }
use mb" j" K; V( w8 F' \! m7 ~
index on xh tag xh
4 \+ y5 ]! n  oset rela to xh into a
% N6 n9 Y) R( Q" wrepl all b.bk with a.bk for b.xh=a.xh
$ Y+ Z6 [% O8 Q! Q0 b( G4 X5 \. wsele 1
. W8 W' }1 p% y+ U5 ]! d+ Quse dm  s& E7 n2 e' J3 }
index on xh tag xh5 m: y" A& P8 m( [4 L3 h/ k
sele 2
) s$ F* ^9 p, L  P6 fuse mb4 F2 y. @7 Y. H& V4 z- o
index on xh tag xh7 _* J$ b/ o- Z; B; ?7 r
set rela to xh into a$ z3 H  y! {& @& ]1 z/ P
repl all b.bz with 'bb'for b.xh=a.xh; b  a0 k2 r. {1 ]# [/ H
repl all b.xh with 'bb'for b.xh=a.xh
/ ^0 M: b6 m3 v8 h8 p# ECOPY TO xx FOR xh<>'bb'
( V  @, |6 O7 u# i. |$ ~REPLACE ALL xzm WITH '曹云霞'
& @) P( v  m3 r/ y9 [MODIFY STRUCTURE
; p3 Z6 o. y' d; |3 w: rsele 1
! ^$ ~, d# `; C$ Huse dm% i- G4 |# `( j6 p' Y
sele 1
' t4 s3 R" d) L" n* c9 Guse dm% r; U/ }+ b/ [8 X$ a( E$ w
index on xh tag xh
2 |) e4 A, F6 u% j' L  zsele 2
! I/ O" g1 H6 v4 vuse mb
# N4 S  F/ L9 b( C* g: Y5 D# zindex on xh tag xh
+ Q0 g% ~8 J% d8 Y3 yset rela to xh into a9 [1 C3 S6 t3 ~8 h+ j
repl all b.hbs with 'H'for b.xh=a.xh
9 e* Q7 K8 ^& n' @COPY TO c:\users\administrator\desktop\2015毕业班\毕业名单.xls TYPE XL51 j$ x6 {& a& N' ?/ Q9 S- ~$ _
DELETE ALL FOR bz='2010本硕'0 ?% m' P. J9 R2 y8 [) R4 H
PACK/ D2 I! K9 Q% f# A* K
COPY TO n FOR xb='男'
5 o1 d& Q! Z3 Q9 i& z$ dCOPY TO z FOR xm='朱振丹'& a6 _" m& v# K
( \' Y0 Y$ P/ \& f4 c$ e+ X2 t
APPEND FROM z
8 `& p3 B8 b+ BBROWSE
. x+ ]& ]8 d1 L+ m" m' G" _/ lAPPEND FROM z
( Q& h0 [: [8 J) l- W2 \BROWSE* `/ |% d4 h" m! x- T& H
COPY TO c FOR xm='陈海瑞', Z8 s3 m8 H" a, D( {% U
COPY TO h FOR xm='胡文'1 v" s( s$ h2 w; \( o% T* S
COPY TO h FOR xm='李永琴' OR xm='张杰'6 @% r/ G) t7 v5 s* W% F- y
APPEND FROM h% K0 V* d, r" W2 W* x+ b
BROWSE( N) }8 x8 F! A2 j" v- X, D
COPY TO c FOR xm='储剑虹'2 D+ f3 b7 K7 G3 J8 q: V
BROWSE5 T! @; P: a1 g' O2 K
APPEND FROM c$ `' a, N  B! c4 v/ F8 o9 {
APPEND FROM s
0 N* D/ f( Y7 J; x. N! NBROWSE. k1 E. X+ G; Y- W" }' j
COPY TO w FOR xm='王永林'
0 o# r; B& ]1 y: S" @# |+ AAPPEND FROM w; H( o: B- |$ L  c" ?6 r$ r
COPY TO h FOR xm='胡一平'
( h; a- {0 P3 s( F  A& @2 OCOPY TO g FOR xm='高昌进'1 o  F8 y* g5 U9 v) ?$ T; M
APPEND FROM g
! P8 X6 m; c+ j: q( S( jBROWSE- {! \) q( c$ m
COPY TO w FOR xm='王永林' OR xm='胡一平' OR xm='高昌进'
% G! T( k5 {* t( B8 m8 uDELETE ALL FOR xm='王永林' OR xm='胡一平' OR xm='高昌进'  N8 H7 @8 s0 ^
PACK
! K/ j% ]# V! q1 ~APPEND  FROM w  h# ]6 `' O+ Z( Z- N3 E+ g
BROWSE0 d; y8 }; e' l3 k0 X  m/ Z9 b! e$ r
COPY TO h FOR xm='胡一平'
6 d( Y: a# p5 m: K0 UAPPEND FROM h4 J) c* P) `; @5 W$ U8 v
PACK
2 c* d! H. r) r  F/ B% pBROWSE
: K) F% V' B% ?: t% F) }! o; w, cCOPY TO y FOR xm='杨学红'
- z( H1 k2 R5 S' [) Q0 |# aAPPEND  FROM y& k0 v2 ]" ]5 U7 T1 _9 u% y- [+ B
COPY TO w FOR xm='汪颀'" H' _. s. q  V+ X! U
APPEND  FROM w3 q  Y- l0 K, a* K  P
BROWSE
% W7 E+ O8 k) v' g2 [APPEND  FROM w
2 \9 |4 b, L( x# Q3 u& a% X% jCOPY TO y FOR xm='姚玮'
  K" N( p8 ^( S+ T& h, q- DCOPY TO y FOR xm='姚  玮'! ^: P; G6 f1 W5 r; A: @
APPEND FROM y7 K8 E1 u5 S# H9 u
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 81,93
& H# _; x# M( d+ y% E' Q3 kREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 50,655344 ]: i  J$ O' @5 i# I! t
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 90,65534
! }; w8 s9 \/ Q0 |# [7 T% x* `" xCOPY TO w FOR SUBSTR(ksh,10,1)='1'+ f! o* ?* w/ U: h; p
REPORT FORM "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012证书打印\方向证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1262,1262* k7 E& ~+ ~! K7 S/ P* F2 C! o
COPY TO bs FOR bz='2008本硕'
1 m; g5 A5 |7 r; ?' g, ?+ o7 b. Q7 ICOPY TO bs FOR bz='2008级本硕'
$ F4 r; K0 o! B" kCOPY TO bs FOR cc='硕士'/ \1 ~# ?, B) H* U
COPY TO bk FOR cc<>'硕士' AND hbs<>'H'7 K/ L4 {+ T# a, w) W7 ~
MODIFY STRUCTURE
4 c% H  X+ @/ L9 p5 MAPPEND FROM bk
0 s# a1 x( @$ w% m2 o: eBROWSE  f, R& r$ ]) }! ~9 ^
MODIFY STRUCTURE
. G0 r$ H: ~# q1 gBROWSE! C3 P' t' m1 E! Z4 p2 |8 e1 X/ [
MODIFY STRUCTURE
& |7 k# n! b- m& s& IBROWSE  l1 d+ l' J. R0 }
COPY TO c:\users\administrator\desktop\exm.xls TYPE XL5
; K7 b  X: g6 |  V) {MODIFY STRUCTURE
) d) t/ R# N/ n, Asele 15 |4 s* X% A! P, z, n- b* h0 b
use dm6 z& Q, X9 c3 o6 @
index on xh tag xh
) u! o; ]1 B! s6 ?) r/ s( V; f1 bsele 2
9 U. @% `- q+ ]! d  D! t' Euse mb
9 O. ]+ f0 m( y& J7 ?+ Windex on xh tag xh, o5 u3 p( M* ~& l2 u6 g; ^9 j
set rela to xh into a- S  U' N& l: I: j& O
repl all b.xmpy with a.xmpy for b.xh=a.xh' Y' o0 P+ f* v: E4 E9 g2 L
REPLACE ALL  zp WITH ALLTRIM(sfzh)+'.jpg'
7 Q; e& @& F: _+ C* pREPLACE ALL  zjhm WITH ALLTRIM(zjhm)5 J) x* r& w! F$ d
REPLACE ALL  zjhm WITH ALLTRIM(sfzh)
! A8 @" \& s$ [! t; w. [repl all zjlxm with '01'& ?; l; h5 W* i
repl all PYDWM with '10366'
# j: r6 p! U' A# G9 `5 m3 J) rrepl all XWLBM with '410'
; k! |: G. b5 jrepl all XWLBM with '407' for xwlb='理学': s+ Y. z. ~$ \8 K3 m! b9 s# E8 u
repl all XWLBM with '403' for xwlb='法学'  t& `& G& t9 E9 h, y; D
repl all XWLBM with '412' for xwlb='管理学'
$ L6 h% _0 z( {6 l& C+ Jrepl all XWLBM with '408' for xwlb='工学'  m0 Z9 Z" A$ s9 L4 _
repl all rxny with subs(rxrq,1,6). c, b$ n4 q& x' C* a: `% N
repl all BYNY with subs(byrq,1,6)
9 @/ D% T/ ]+ v( p/ ^  I- rrepl all HXWRQ with subs(byrq,1,8)  y  L1 F, Z5 ~% B; Y7 W# A) m
repl all SFFXXW with '否'
2 |) k3 P2 U& `- T9 L  D* _repl all SFDEXW with '否'
$ _& Q; A% z) b2 Erepl all zzmmm with '01 ' for zzmmm='中共党员'
# A3 [& r. B+ G, S; _repl all zzmmm with '02 ' for zzmmm='中共预备党员'; A4 d* B+ `9 S/ i9 I0 f
repl all zzmmm with '01 ' for zzmm='中共党员'
8 e7 G$ g7 F% W! e& x% Grepl all zzmmm with '02 ' for zzmm='中共预备党员'* I" h8 L) e& [3 ]2 C/ z' b8 f+ R
repl all zzmmm with '03 ' for zzmm='共青团员'
; ^( I5 h4 B3 T" V3 x) frepl all zzmmm with '13 ' for zzmm='群众'
! n& r4 f6 c  h1 [$ _2 g3 rrepl all mzm with '01 ' for mz='汉族'* }3 E0 C. \( I. [
repl all mzm with '02 ' for mz='蒙古族'
- Y7 m5 O( }; v$ Lrepl all mzm with '03 ' for mz='回族'( d# f- P0 G6 p) {8 W2 J
repl all mzm with '04 ' for mz='藏族'' W; G% {8 T( l0 C/ M9 h# \
repl all mzm with '06 ' for mz='苗族'
# B4 t4 p# [5 K% D3 W; T! q5 U! f7 jrepl all mzm with '15 ' for mz='土家族'. d# @0 L1 r. X5 M) t* }
repl all mzm with '11 ' for mz='满族'! t, R1 _2 r" q3 U  ~2 P( j
repl all zxxm with '曹云霞'9 ~2 X2 u% ~% Q$ i" W
repl all xzxm with '曹云霞'% x8 r7 g) m; v+ c
DELETE ALL FOR cc<>'硕士研究生'
2 H1 f& g" Z7 i! {PACK/ H( o' ^2 d0 T* V
BROWSE
% @) }! B0 `2 E0 }) DMODIFY STRUCTURE6 q- Y# M  q; ?5 X8 ^: c' X
sele 1. v4 ~# X) u9 Q- _' F! P5 v! F
use dm
7 F  d- y: V  Windex on xh tag xh* M! o. d! e# M0 H, }4 T+ E3 \
sele 2- C5 {( [4 d! w# a. p
use mb
2 E* X, ]9 Y/ y, |4 oindex on xh tag xh
1 z; y" E+ G2 h) rset rela to xh into a
, i  l7 n1 _' H2 t: y- s& `9 nrepl all b.LWTM with a.LWTM for b.xh=a.xh3 o( t$ G4 x3 Z- U3 P: O( l
repl all b.LWGJC with a.LWGJC for b.xh=a.xh8 c7 s: c6 g# V7 u1 K1 Q6 u) R, J
repl all b.LWLXM with a.LWLXM for b.xh=a.xh
: ^7 Q* s& X# g% c" Erepl all b.LWXTLYM with a.LWXTLYM for b.xh=a.xh
; e$ }) k1 g' \, t7 |6 A) lrepl all b.DSXM with a.DSXM for b.xh=a.xh/ t8 p, O1 |5 w" P8 |8 h
repl all xwsydwm with '10366'
* \" r8 V9 f* [' m5 y2 b2 j6 I3 nCOPY TO bs FOR cc='硕士'
4 ?, u/ \0 _  ACOPY TO bk FOR cc<>'硕士' AND hbs<>'H'
5 ~0 J9 ^  K9 `7 C7 X- {REPLACE ALL xwlbm WITH '31051'
+ s7 G; T( l- c" O& l8 WCOPY TO bk FOR cc='本科' AND bz='2010级本硕'3 _) G/ ~6 G4 e- a6 ^
COPY TO bk FOR cc='本科' AND bz='2010本硕') g  W' f; I& W9 c( c
REPLACE ALL xwzsbh WITH ' ' FOR hbs='h'
; T) w$ ]" h' wREPLACE ALL xwzsbh WITH ' ' FOR hbs='H'1 A4 W% n7 ?% K. J% J
repl all xbm with '2' for xb='女'6 q; e# b( n8 t' O$ Y: y
repl all xbm with '1' for xb='男'
# J8 W0 N6 `6 u. w( \6 TCOPY TO k FOR mzm is null
& t0 m7 O) R% K7 m* e* b1 jCOPY TO k FOR mzm=' '5 g; V$ k6 k; ^( C. p
R( Z4 w- G/ n: G8 `; ^- R
EPLACE ALL mzm='19' FOR mz='黎族'
' i" ]. W, I2 T/ q. gREPLACE ALL mzm WITH '19' FOR mz='黎族'- G! r" |7 b9 E* C2 b
repl all gbm with '156'
# W% \; C- j/ X6 R' L' irepl all zyxwlym with '105199' for cc='硕士研究生'; d7 q; C; T* \: u$ S$ T) j% O
repl all ksfsm with '01' for cc='硕士研究生'8 B3 u( `- |& ?' k: c
repl all qzxwm with '410' for cc=‘硕士研究生’* v! Q: T% B$ |
repl all qzxwm with '410' for cc='硕士研究生'
, Y& e8 \: X8 [repl all qzxlm with '3' for cc='硕士研究生'
7 v! |+ Q7 i0 p! r; Hrepl all hqzxwny with '201307' FOR cc='硕士研究生'* E: ~2 |7 q. H) r- K
repl all qzxwdwm with '10366' for cc='硕士研究生'
. r; x$ L* P2 {5 S1 |repl all qxm with '01' for  cc='硕士研究生'
8 @3 p8 i2 F! \2 `; wrepl all gzdwxzm with '24' for cc='硕士研究生'
( U* ]/ S* H0 _repl all gzdwssm with '34' for cc='硕士研究生'; l4 H5 ?% X; U9 n
COPY TO bs FOR cc='硕士'
; F) T" M$ C$ c0 `COPY TO bk FOR cc<>'硕士' AND hbs<>'H'
3 p% u; H1 ^' t- B( w* d* l6 yrepl all HKSZSSM with '34' for cc='硕士研究生'
- h' Q" Q6 C" t6 q, W$ xrepl all gzxzm with '9' for cc='硕士研究生'
' `8 L7 L; D( Y1 V9 I: l2 a" YCOPY TO bs FOR cc='硕士' AND hbs<>'H'
3 H: O; _2 j+ ?COPY TO bk FOR cc<>'硕士' AND hbs<>'H'
/ x; \4 N9 k5 c1 W$ [  @COPY TO bs FOR cc='硕士' AND hbs<>'H'
, U" [6 o2 H- P, }# D: J" ~  WCOPY TO h FOR xm='王正' OR xm='程旭' OR xm='朱全伟' OR xm='陈峰'
) ^) v0 [4 u0 J# t. m7 uPACK! F2 f4 j9 b0 B3 \/ X! \- i9 g
BROWSE
9 g: f7 _( p7 u. rREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\学位证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER$ W* P4 x; R0 M! b9 s
 楼主| being 发表于 2017-3-16 10:46:53 | 显示全部楼层
本帖为密码帖 ,请输入密码 
您需要登录后才可以回帖 登录 | 入住

本版积分规则

客服电话

400-0000-0000

工作时间 周一至周六 8:00-17:30

微信公众号

APP客户端

Copyright © 2015-2016 nvbing5.net All Rights Reserved. Discuz!X3.2 @技术支持:草根吧 皖ICP备13000339号-6

皖公网安备 34010402700108号

快速回复 返回顶部 返回列表