查看: 2080|回复: 5

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

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

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

sele 1. L7 k) @" D4 a& W- v
use dm+ w6 }1 p. g3 |6 x! R! \
index on xh tag xh/ O$ l7 e$ ]9 m8 ?& M
sele 2% {% B4 s8 G, R/ {  F+ Q
use mb0 ^/ K7 Y0 ~+ ~7 M& t' W1 p
index on xh tag xh
1 s# q0 K5 ~9 h" h) j' \set rela to xh into a
1 X4 y5 m1 i/ q) c! urepl all b.lwlxm with a.lwlxm for b.xh=a.xh& n: d8 q! N- R" O
 楼主| being 发表于 2013-3-19 15:08:47 | 显示全部楼层

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

repl all zzmmm with '13'' C. n, I. T+ T4 a4 S+ T
MODIFY STRUCTURE- ~/ ^9 }2 y& Z. _
repl all ZYDM with '100701' for zymc='护理学'
3 i( R+ p3 n% X! O- |) o1 Q) WMODIFY STRUCTURE; W4 b- _6 F1 o2 A  j5 Z* i
repl all ZYDM with '100701' for zymc='护理学'& K+ N. G0 v/ V
repl all ZYDM with '100201' for zymc='预防医学'
/ Q: N9 @2 T3 j repl all ZYDM with '071502' for zymc='应用心理学'
  t& e1 k! N, t; K3 Z9 T8 n repl all ZYDM with '100304' for zymc='医学检验'2 w, y2 M9 k# l, z
repl all ZYDM with '100401' for zymc='口腔医学'6 e5 a4 V. k" H% X* G
repl all ZYDM with '100801' for zymc='药学'
3 O. t4 c; C" M repl all ZYDM with '100301' for zymc='临床医学'
* o: p- L: M  u7 s& v2 e3 Cbrow) _. J0 u8 t/ }# O7 r
MODIFY STRUCTURE' \6 c1 O* V5 f8 D1 `9 B! [3 L
repl all XXXSM with '02' for xxxs='业余'
2 ~4 }$ S4 |7 C! z" R  }2 ^brow) W: w9 ^$ m6 v2 @4 v7 h
MODIFY STRUCTURE7 R  e/ `  f3 \8 `' e
repl all HXWRQ with '20121226'
: m# _+ Y  d( F2 D# drepl all ZJLXM with "01": g7 o2 v7 Y  x  n+ o) |2 G# _- C1 l
repl all XWSYDWM with '10366'
0 S  B) ]- j% B6 X- YMODIFY STRUCTURE
4 `$ h$ |" o4 L% S' g" V4 X0 ?repl all ZXXM with '张学军'
' l6 d; ~4 ^3 h" ~& d% CMODIFY STRUCTURE7 s5 R8 P; \& t6 f. X
repl all ZP with allt(sfzh)+'.jpg'
  k) R0 ?6 t  x3 Z- B8 `brow
8 z- j4 M: m+ `2 `3 A3 ]) ?MODIFY STRUCTURE
% V) q+ G& D; T, w5 srepl all XZXM with '张学军'" e$ G0 l% [3 e' m# ^: M5 z
MODIFY STRUCTURE
/ s" }& {; r2 ~# l1 n5 w0 v: Grepl all PYDWM with '10366'8 S; O. X% ~0 T4 g0 ~2 {  q
 楼主| being 发表于 2013-6-4 15:25:59 | 显示全部楼层

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

repl all xwlb with '医学'* L& N2 q9 x' r6 L- j
repl all xwlb with '理学' for xz='4'
+ m5 h' K2 @# i- d- R4 `' E4 C- srepl all xwlb with '工学' for xz='4' and zymc='生物医学工程'% Z; [* g7 [3 l/ s+ H% e2 a2 W; {7 C! ]
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
* W1 T, N- }5 T' mCOPY TO c:\users\administrator\desktop\14.xls TYPE XL55 N2 J! x6 V$ `: s$ N) s  O4 W4 i
COPY TO "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012学位报送\12届毕业生学位授予名单.xls" TYPE XL51 ~& b1 e: }$ ^: a' O
COPY TO  q FOR sfzh='340211198012081018'
+ _* R  M8 z% i* LAPPEND FROM  q
3 q! J  L% I9 Y( Z5 d
' `' J" q# c% ?- J  q; [) f7 NBROWSE
" J( P. X! K5 ~2 W& }0 l- b. k! fAPPEND FROM w
# _6 Z* @) u& f; V9 N: p+ S8 C. B1 |, N5 L: C, J
BROWSE
+ e) Q/ J7 C0 W# Y  f$ ?( ]# BAPPEND FROM w5 L" p/ w7 c6 a' s- E
BROWSE
7 B3 r7 Q2 X* E4 o2 f1 [$ WAPPEND FROM w3 u$ K* T; c/ s
BROWSE
- d$ Z, ~3 v: gAPPEND FROM w
- r4 ]+ y" f8 C7 y! a2 uBROWSE
+ i# `4 o2 t+ U/ }7 o0 [6 yAPPEND FROM 10 i, }# ]  O; B3 K" g; C  p- D
APPEND FROM 2( E! A" @8 y" c1 p
BROWSE9 y+ ?' p; z) a8 g/ j
APPEND FROM 3; h8 ]; j# u) Q+ b3 h
BROWSE7 Z+ ]4 J* f9 f+ P8 U
APPEND FROM 1
( A- g6 S. B" A  y! G# o: rAPPEND FROM 2
& \7 z: P4 b0 ]6 M0 \APPEND FROM 3) X. K4 H8 R% t- v- f
BROWSE& A& I4 U: h; g  I7 ~! s0 M( N0 h
MODIFY STRUCTURE: w% z0 Z2 S: ~+ ?' l( g
BROWSE
3 H- e2 T  ~' vMODIFY STRUCTURE
7 r$ g( |0 i' xBROWSE
& w7 m2 j5 P& c2 aAPPEND FROM 4
, G% p7 g7 s, r( b  N& B$ D  iBROWSE
0 g0 i) R$ h, r  xREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 68,68
0 m' j! ?# ?( v7 F4 wREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 69,71' d: V8 F: y1 H
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 69,69* i1 U7 q: T( V4 p
REPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 39,39
5 f2 b7 L5 o; s2 OREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 40,44
  ?3 ]4 P2 {5 {0 W; o* L0 tREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 46,46
) g  M2 d$ l( _( Y. T0 EREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 45,45
/ o! y; ?0 P. D5 t4 XDELETE ALL1 D6 Z/ J. L# X3 r  h% x2 x
[acl
; E% U' r' p* w0 @/ m+ oPACK/ F# J, Y; P* N0 Y* x6 [* d/ F$ }
- }. U8 t9 ?7 H
BROWSE
: D/ Z; [7 U, g( R8 J- r5 `8 R6 pMODIFY STRUCTURE5 J5 ~/ d+ s) S+ W5 g' T/ M
REPLACE ALL ZXXM WITH '曹云霞', s' w) r; i4 G6 f: b
BROWSE* t! u8 v( m& m- T$ n
REPLACE ALL xbm WITH ALLTRIM(xbm)$ Z9 z6 i& k% `" @& Q& p
REPLACE ALL zzmm WITH ALLTRIM(zzmm)! W- v2 s' Y6 h! r) N$ C) m) ?
REPLACE ALL zzmmm WITH ALLTRIM(zzmmm)3 S% u/ Q$ b9 m$ z9 L2 G* T
REPLACE ALL xwsydwm WITH ALLTRIM(xwsydwm)0 R3 X9 B  k% \" S; `! E3 F
REPLACE ALL pydwm WITH ALLTRIM(pydwm)2 _/ I! Q! ?0 |* p$ t5 A
MODIFY STRUCTURE% f3 f3 V( P  I4 y' ~1 l2 N
REPLACE ALL pydwm WITH ALLTRIM(pydwm)
$ m% r2 M+ X, m( C2 E9 Y5 O, j! QBROWSE( B: @8 R# l( q- _  t
REPLACE ALL xwlbm WITH ALLTRIM(xwlbm)1 a+ Y& E+ x# U4 G* ]# u: M  q
DELETE ALL
2 c8 F: V; p( S
7 G* n% S# M1 f- H+ a3 oPACK
3 r: A3 ]9 f7 e* @9 Q5 U" C. B. I" ?! `# l# h+ T& K
APPEND FROM 1
5 H: L+ r  ]# o- ^2 n* H! YBROWSE+ A2 n2 l, W6 i6 b7 P
MODIFY STRUCTURE' i5 \% p* l9 M+ o. L9 l
COPY TO c:\users\administrator\desktop\1.xls TYPE XL5
4 J6 q- ]3 @0 n) t* hDELETE ALL
# W7 u4 p* ^6 y/ q% S
  q' |6 u& e; i' G7 Q2 O( kPACK
* ]9 V: v# r1 U' X7 o: aapp7 `3 s% F% \2 A, Z
REPLACE ALL hxwrq WITH ALLTRIM(hxwrq)
# ?. t9 F# ]/ ?: C8 @2 VREPLACE ALL byny WITH ALLTRIM(byny)
) `0 I9 T* }8 T) B. k) GREPLACE ALL wyksny WITH ALLTRIM(wyksny): ~1 l# x! C$ }' a. Q( |( {
REPLACE ALL rxny WITH ALLTRIM(rxny)5 k( v- B. ]  W5 p5 q
REPLACE ALL zydm WITH ALLTRIM(zydm)
- _/ I1 J! c# J" k/ G+ j: @REPLACE ALL xz WITH ALLTRIM(xz): s5 S' T3 V+ \; `+ i8 B3 r
REPLACE ALL xwlbm WITH ALLTRIM(xwlbm). Q: A3 @: Q. j1 ~% x: i
MODIFY STRUCTURE
5 F8 M% u; U4 Z" [& O! \4 QREPLACE ALL xwlbm WITH ALLTRIM(xwlbm)( h3 u# K) K, h2 u" ]
BROWSE8 k2 x0 h; ~& \1 z8 z5 L& d
REPLACE ALL zp WITH ALLTRIM(zp)+'.jpg'
7 _' k+ E% e( V8 o1 R' K5 `REPLACE ALL zp WITH ALLT(zp)+'.jpg'
2 b  W- [, w  Z9 eREPLACE ALL zp WITH ALLT(sfzh)+'.jpg'
' a3 f* P4 ~, h8 |6 _. u! h3 ZREPLACE ALL zp WITH ALLT(zjhm)+'.jpg'8 @. r& ]$ p; c$ U4 X  E0 f% O
MODIFY STRUCTURE9 ]  o  |5 ^  i& d$ S- q
REPLACE ALL zp WITH ALLT(zjhm)+'.jpg'
6 Q$ E' _8 Q* T" x3 Z" i2 l  pBROWSE
7 r' l) A& V# O$ M( q4 hREPLACE ALL xh WITH ALLTRIM(xh)
  B, t5 f3 W0 r1 O; \APPEND FROM 1
0 C* L6 a7 j2 E6 v8 k, ABROWSE
) Q- q  Q& v( N) {4 b) i. EREPLACE ALL xwzsbh WITH 'Z103663201420'+ RIGHT('0000'+ALLTRIM(STR(RECNO())),4)8 v4 l$ ?  b+ C! b9 I0 o$ n2 D
REPLACE ALL xwzsbh WITH '103663201420'+ RIGHT('0000'+ALLTRIM(STR(RECNO())),4)
6 j2 O/ F4 V8 h: m6 b* fsort on zymc,zyfx,xh to 3
+ Q# Y6 E/ R' w, W" _! z& esort on zymc,xh to 3
% Z; e: X) E5 A/ w4 V" Z" b6 n3 N- MDELETE ALL
7 ~' m3 E$ h( g3 T1 `PACK
$ ]& q3 q3 x, B4 R& I# z, i% |" u/ A- i# M- @1 i
APPEND FROM 3
  F, u) L" F  \# u1 Z2 qBROWSE
0 J' B  V' w* _0 U6 Lsort on zymc,xh to 1: Z& h) `, K* F( B5 L8 H1 Z5 p
sort on zymc,xh to 11
, H9 g( i( h1 N  i9 s# a: BDELETE ALL
6 H0 d9 y) |  A# _+ @PACK
3 ], Z: s( M7 {/ K0 W3 F$ s4 g0 ~; b: X
APPEND FROM 11# ^. _4 X9 [  z
BROWSE- e( z* L# B' W
REPLACE ALL hxwrq WITH '20141226'  N6 `  X* R5 w4 G( y! b
REPLACE ALL SUBSTR(xwzsbh,6,1) WITH '4'
: U3 `2 S. a# u+ k5 u/ Lsort on zymc,xh to 3  ?0 u& |$ h: C: u9 s
sort on zymc,xm to 33 G0 f7 l) X1 T2 p
REPLACE ALL xwzsbh WITH '103664201420'+ RIGHT('0000'+ALLTRIM(STR(RECNO())),4)
' i+ _% h! x2 r: \- g8 ZDELETE ALL
' t* f0 n/ P! z; M/ n, D& tPACK8 [1 N- R2 k! i% o6 y- j
APPEND FROM 38 X+ k$ r- F( M8 a: t
BROWSE: }+ t4 E" p, V+ ^3 s1 i
sort on zymc,xh to 3
: {8 b8 }: `$ ~6 j' v7 n1 TREPLACE ALL csrq
0 h% r1 Y5 W% E0 r7 W% KREPLACE ALL csrq WITH SUBSTR(sfzh,7,8)
( n& n5 x& c, V( O6 YREPLACE ALL csrq WITH SUBSTR(zjhm,7,8)
% U0 i0 ~) u5 b' R2 @7 W& d4 \COPY TO c:\users\administrator\desktop\14学位.xls TYPE XL5
! u; k+ `$ A) Z. j$ N9 [# E7 }. f$ X# SCOPY TO l FOR xm='刘芳侠'. X8 t% _0 x6 {" V) J; v, y
APPEND FROM l* R' D7 ~2 J; C& i. D
BROWSE
5 S7 V/ ^) y/ [1 w9 p: _% pREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 72,72- W- G5 d4 \8 N1 Q% b) @5 Z7 H0 k9 J
COPY TO h FOR hbs='h'
9 C, t' o9 ]  W1 ZCOPY TO h FOR hbs='H'+ \2 D( y0 Y4 L
COPY TO Y FOR XM='杨绽青'
. j- m& X! {9 J6 h# @9 kCOPY TO l FOR xm='李亚奎'
& h: z+ e9 Q- z. SAPPEND FROM l  X. e1 R" a3 y4 O' L5 a' z

0 x2 `( W: o% v' H9 k. iBROWSE
' j2 l: e7 ~1 t$ e* w5 W/ W+ GMODIFY STRUCTURE
" U$ k2 b2 L# z! n6 W) s4 ?" z" E  _BROWSE4 }; e! D  {3 R6 o! t4 e# y
MODIFY STRUCTURE
3 ^# `) H! K4 WBROWSE
: r- v5 ^* T# c  B) c- Y1 Esort on zymc,xm to 32 T9 H: l, z' n) O# r9 e
REPLACE ALL xwzsbh WITH '103664201421'+ RIGHT('0000'+ALLTRIM(STR(RECNO())),4)% u# T' s2 [& {) d( V2 ]$ x. M! S
sort on zymc,xh to 3
% A- `2 `$ {) p* K* L! Xsort on zymc,xh to 33
: i% f0 D: f, a) e3 R& H& ?COPY TO b FOR bz='2007本硕连读硕士阶段'
: D1 r4 l4 s- R9 W% GREPORT FORM "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012证书打印\学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 55,55) ^  v4 s! D- X& P4 {$ @* ~% Y; K/ f
REPORT FORM "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012证书打印\毕业证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 55,559 ~9 P$ Y: X' c
COPY To( q8 h8 r2 a* m" G( T1 C
COPY TO w FOR xm='王良华'% {4 m. q) T* @9 R* y
APPEND FROM w
' w* ~. ]  e0 V3 j, vBROWSE/ B9 |6 x7 f; s/ d# G0 W
APPEND FROM l6 X8 k# r+ t; m9 ~7 I; q. `
BROWSE  Z" _3 l8 N) q7 ^6 j* s( p8 v
COPY TO x
- ^  m7 P+ o' D! HCOPY TO x FOR xm='肖俏'
) c3 v$ }# w  ^" KAPPEND FROM  x
3 A9 F0 p- T) b& e8 G& XBROWSE% x$ r8 C, P( v; X' f" ?
APPEND FROM  x& o" i3 ?: f  s9 K
COPY TO l FOR xm='刘星'
( H1 x* f" k9 e: t" Q; L! ]PACK6 V4 S) K9 e( o6 f2 [' ?1 o% c
APPEND FROM l
0 e# @9 w9 N  I0 lREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 73,75+ e' h" l0 Y2 }( p
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 73,73
9 Q: T9 Q/ n1 @! v$ T  xREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 47,48, M5 l9 f8 Q, @4 P
REPORT FORM "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012证书打印\毕业证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 55,55# X( t% T) E  v, D3 l
REPORT FORM "d:\工作文件\08-09\08092\学籍\2009届毕业生\证书打印\09毕业证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 574,5746 a" _+ z' Z4 B& \$ D
REPORT FORM "d:\工作文件\14-15\14151\2015年第一次学位报送(20150130已报送)\学位证书打印2014\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 7,8$ P; h5 D' u' D* t
REPORT FORM "d:\工作文件\14-15\14151\2015年第一次学位报送(20150130已报送)\学位证书打印2014\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1,1
) w3 Q" N4 V7 Z! ZREPORT FORM "d:\工作文件\14-15\14151\2015年第一次学位报送(20150130已报送)\学位证书打印2014\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 7,8, g+ T% j3 d4 e( L% f) X3 a( R
MODIFY STRUCTURE! L: w" ?8 e: P) O! @/ N; X! g
sele 1
1 U; D3 ]( y2 ~* Y0 a0 V( d8 fuse dm" E4 e0 p2 t) ~2 g5 }
index on xh tag xh
4 k) g8 o; J2 t2 T1 @. }- }/ usele 2; N* k, t4 B. J, p) r
use mb- J) a4 l0 _' N$ O- O
index on xh tag xh0 A6 _5 K: P& t: o/ U
set rela to xh into a' B( P3 U- H' V
repl all b.xz with 'x' for a.xh=b.xh+ G6 k( v$ P" t, Q1 R! l# q
COPY TO xzxk FOR xz='x'+ _$ w2 ]1 B; u4 o2 A
PACK
; Q& P" ~1 ?2 h! ]  T5 \' Q( hMODIFY STRUCTURE; }2 F) u2 m: S; K  e: q4 {
COPY TO "d:\工作文件\重修\2014-2015-2\重修证打印\xx.xls" TYPE XL5" B  J2 A* X& y% ]
REPORT FORM "d:\工作文件\重修\2014-2015-2\重修证打印\xwzmsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1,1
1 o3 L* @  L) gREPORT FORM "d:\工作文件\重修\2014-2015-2\重修证打印\xwzmsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 2,2# j& m2 n8 B3 W, \' m
REPORT FORM "d:\工作文件\重修\2014-2015-2\重修证打印\xwzmsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 3,655347 i/ [8 Z  U+ u7 C, u
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 76,76
  D0 x7 y+ x* d- @  G. QREPLACE ALL  zymc WITH ALLTRIM(zymc)8 ^' h* g$ v, ]6 W. j1 |% \
REPLACE ALL  xzbdm WITH ALLTRIM(xzbdm)$ `2 Z5 Z- l* O; O9 _& {
REPLACE ALL  xbbdm WITH ALLTRIM(xbbdm)3 T. ?) I) o" _! o. A' P2 q
MODIFY STRUCTURE9 f9 S3 u3 R, ?' i
REPLACE ALL  xbbdm WITH ALLTRIM(xbbdm)
; \! o5 ~1 y7 F4 y$ LBROWSE" L+ s$ t# l7 M) s5 w$ F" i
COPY TO d:\22.dbf9 a. X1 T, T( [, ]0 ~
COPY TO l FOR xz='4') R5 a$ j9 ]9 {( s4 P2 E
DELETE ALL FOR SUBSTR(csrq,1,4)='2004'
2 B4 D' x& u& ~2 ?DELETE ALL FOR SUBS(rxrq,1,4)='2004'* T% ?4 M; x& v4 f! G$ R
DELETE ALL FOR SUBS(rxrq,1,4)='2005'& {* b( v& J6 H) V- F- G' y
COPY TO lll FOR SUBS(rxrq,1,4)='2004'
7 m3 e) m, N, O% `9 [COPY TO c:\users\administrator\desktop\xl_2009_10\111.xls TYPE XL5
) }' M/ @/ y. [- {, ~! ?COPY TO 4 FOR xz='4' OR xz =' '4 u' |- x  U3 q- U
COPY TO 4 FOR xz =' '
- Y* f) r7 ]" e, u8 ECOPY TO 5 FOR xz =' '( ~0 v7 p1 K) g' K9 g( E) S
COPY TO 5 FOR xz ='4'$ O5 P3 M" Y5 w0 o1 D3 P
COPY TO "d:\工作文件\13-14\13142\学籍\2014毕业班\14.xls" TYPE XL51 _$ M- y4 J( e( U
COPY TO c FOR xm='常晶晶'8 E0 m4 `1 D* p5 ~2 A0 w
APPEND FROM c- Z& P$ S6 P* c2 w2 M
+ d, C  a, F+ F' ]
BROWSE
3 S& F& [- Q8 b- N8 QREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 77,77
3 ~" d2 L1 k% I0 W) _DELETE ALL
7 N$ }$ w2 c- ?' jPACK' h3 m; |2 {5 `- ~1 D4 Z+ t  w
BROWSE: V" I. a1 T: p
COPY TO y FOR xm='杨洋'
# Z% Q7 Y; Z; G3 ]0 y2 yAPPEND FROM y
7 K# H0 O; ^' v# WBROWSE
2 r$ S% o  |- u3 T8 ^REPORT FORM c:\users\administrator\desktop\学位证书\xwzsdy.frx NOEJECT NOCONSOLE TO PRINTER
! U2 m6 {% H" \1 r; ?MODIFY STRUCTURE
* Y6 E/ x0 Y- a/ g9 R& U* m4 c0 XCOPY TO 62 FOR yy>=62 AND zyk>=72 AND zf>=1407 K1 a% J/ b6 {
COPY TO 62 FOR yy>=61 AND zyk>=72 AND zf>=140
" l; J! Z; k, [& ?4 V: ECOPY TO 61 FOR yy>=61 AND zyk>=72 AND zf>=140
7 H# S7 ^$ T+ t; C) OCOPY TO 63 FOR yy>=63 AND zyk>=72 AND zf>=140* t2 H# y4 O0 S/ x! H" p, [
COPY TO w FOR xm='汪伟'
. H0 ?& W0 e0 P7 I4 [* g/ nAPPEND FROM w1 W  x. J8 _3 k! f2 d6 x- }
BROWSE
! G* u# I1 j! L6 ^+ {& i' jREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 78,78
7 S6 V1 a' y& D% RCOPY TO s FOR xm='孙陈国', H4 l) `6 j0 Z" q
APPEND FROM s/ s& z; ?9 e+ o) c& w& ?" ]7 i
BROWSE
1 a8 ~& v* u4 M( p3 [REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 79,799 W) P0 g* [) }7 ~
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1,1* w% \2 y- R/ N! N& ~# K7 U: q! ~
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 2,2* v& U5 F4 F8 H# {* ~" ?( D1 S
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1,1! g! i: |! i% D  z" n
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 2,100+ |  P- J* j0 a! W; y
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 101,200! c3 Z" I$ A2 O2 }
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 201,500
, s7 c" m1 q# L$ JREPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 496,5005 E3 a) ^; G, D3 E7 k& c
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 501,600- v; o8 D8 y$ ?/ @: b& {- s
COPY TO c:\users\administrator\desktop\bs.xls TYPE XL58 y/ v  w" n+ I- @/ \5 d
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 601,65534$ {$ J$ G  s: X
APPEND FROM y$ c) D% P2 a8 n- c8 d
BROWSE
* y9 B8 t$ U8 X# ]9 {' jAPPEND FROM y, q  ~9 P6 n4 c& {! ?
REPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 49,49* ^4 Z7 V- n! W+ X; I5 C* @
REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 80,80
7 _, ]2 g* m) R8 X" q/ S6 FCOPY TO c:\users\administrator\desktop\15届毕业生信息.xls TYPE XL5- ]& J7 T$ v, |  K* V& ?& v
COPY TO c:\users\administrator\desktop\2015届本硕连读预计毕业生信息.xls TYPE XL5
4 B0 B: X; A& \% O6 p; [COPY TO c:\users\administrator\desktop\10本硕本科阶段毕业生信息.xls TYPE XL5
$ a1 `) V/ ?; z! O6 t1 d. NCOPY TO c:\users\administrator\desktop\10本硕本科阶段毕业生信息2.xls TYPE XL5
% k: E9 f& d  p$ I! k8 m  x% XCOPY TO c:\users\administrator\desktop\qx.xls TYPE XL5# G( R1 U% L# U1 e! l: J) t: f
APPEND FROM 2
- n. D, o3 A; O) EAPPEND FROM 3* j7 e* E3 U4 [& t4 h& p4 ]
BROWSE( h; m4 z3 S% J6 \2 R
APPEND FROM 38 U. q  i. ^9 y) B
BROWSE
/ ^- J5 F4 a& O  U4 k# sSORT TO 2 ON
+ ~, g. C1 g7 w1 v6 _COPY TO c:\users\administrator\desktop\2015毕业班\15毕业信息初稿20150526.xls TYPE XL52 M& }8 u( D" J- [* u
DELETE ALL
/ t8 ^! P  D3 \6 |1 d5 c& _PACK
8 j) g& F, q4 M5 @! }& QAPPEND FROM 1
( Z4 [! T2 l5 e9 e& g+ K. l+ `BROWSE  D5 l, k3 d  M4 l# P4 ], `) E
COPY TO c:\users\administrator\desktop\2015毕业班\15毕业信息初稿20150526.xls TYPE XL5
  A' Q! W+ R% s, ]* g+ f4 CDELETE ALL
' @  ^+ [# V. ?: ]; }3 y9 n! m  B/ gPACK1 Z: W- }+ N: h" O
APPEND FROM 22
9 J, |" k+ m- n9 d1 ]0 r, ~BROWSE
) u/ [) E1 h# ~0 @3 ?/ t4 wCOPY TO l FOR zymc='临床医学' AND xz='4'
% q+ ^- v+ W- l8 SDELETE ALL FOR zymc='临床医学' AND xz='4'
1 d0 s+ u1 G& K7 k2 GPACK0 G( \' q% @8 l' Q& o
DELETE ALL FOR ksh='11340881151043'" _. [7 }, E. p' K
PACK
. _6 z- Y6 Q* w1 z4 gBROWSE
8 w! r( b( _+ |' {8 b8 cCOPY TO 10bs FOR bz<>''
) q, X7 H2 ?# J2 `) DCOPY TO 10bs FOR bz<>' '- h* I9 K  P$ m$ l% D+ e
COPY TO c:\users\administrator\desktop\2015毕业班\10bs.xls TYPE XL56 ^: T  ~* L% A
REPLACE ALL xz='5'; Q% W4 ?/ u  T* e
REPLACE xz='5', u3 q3 W# V  G3 a, J
REPLACE all xz WITH '5'
. z" n4 ~7 u( B; c, K& v1 M- T7 ~BROWSE
$ k9 s1 `( b. o$ f2 l7 QREPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 76,78) o9 i: u! V' E; I% L! F+ p
REPORT FORM "d:\工作文件\14-15\14152\成教学位证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 28,41
/ T' ]4 E/ i9 A# `3 C  }COPY 头
3 h* h1 i2 r. P2 _( h% @" a. TCOPY TO 08bs FOR cc='研究生'1 T& f' `5 s( x1 Q+ J9 V) s# A, j- r
COPY TO 08bs FOR cc='硕士研究生'
8 b6 S4 ~3 e! s6 c% Q" xCOPY TO c:\users\administrator\desktop\2015毕业班\08bs.xls TYPE XL59 x* o1 h$ k0 g
MODIFY STRUCTURE# z; Y( T+ S2 y5 T" w/ w" }
REPLACE ALL xh WITH ALLTRIM(xh)
5 t4 k7 y9 Y: f; q) X: gBROWSE
- B) F. q3 W1 J- \; X6 ]6 PMODIFY STRUCTURE4 z0 b, t/ `* F  o# @
REPLACE ALL xh WITH ALLTRIM(xh)7 i3 g3 S2 s2 t9 O& T0 m" H
MODIFY STRUCTURE1 g' X* f9 r' n6 j6 p# f$ Y* N3 {
USE 1
( Y, {: J& Q" a# T: n2 A. X2 {SELECT 1
1 Y. E* F  _% r( k' DUSE c:\users\administrator\desktop\dm.dbf
8 D9 W2 M0 l: m+ v* _* d8 |% {
6 o4 F# Q- ~. x, M. N$ C# HSET RELATION TO xh INTO dm9 U! p, G7 F3 d7 _3 Z
USE c:\users\administrator\desktop\dm.dbf
% R. @. N5 [  F5 \$ C1 QINDEX on xh TAG xh6 O5 l. L, z# V. ~: c# }+ x% A1 F
SET RELATION TO xh INTO a
+ n' _8 o6 m8 Y) s( Q) B' KSELECT 2
+ ^. k. X* `" w! a! ?USE mb
9 J9 f6 v" G, b, T( p) LINDEX on xh TAG xh3 w' ^! }: e+ l- U8 C) f9 A
SET RELATION TO xh INTO a' G/ z% V- ]4 X# J& o( K: R4 V
REPLACE ALL b.jn WITH a.jn FOR b.xh=a.xh9 E; a3 ~1 E) b2 _# N+ [3 \" H
COPY TO k FOR jn=' '& J$ D- U$ n6 y$ t
COPY TO k FOR jn=''
- Y( b6 Y& J* A9 L( o# b, M  wCOPY TO k FOR jn is null
: z( G+ C3 {# RCOPY TO k FOR jn=' '* L5 r3 e/ |/ ?$ v  Z5 ~' h
COPY TO c:\users\administrator\desktop\zp.xls TYPE XL5
; m3 }: V9 N- h7 ZCOPY TO c:\users\administrator\desktop\2015届毕业班实习成绩处理.xls TYPE XL5* B6 R* ^2 O3 Q
MODIFY STRUCTURE
% }! ~3 Y+ y$ |REPLACE ALL xkkh WITH '(2014-2015-2)-30000002-00000000-'5 W0 Y- [+ V& V5 o7 k, m
BROWSE5 A+ j+ K% W$ w, N4 x
sele 1
* ~9 K6 ]4 C! M4 K0 u- k& U6 w, Quse dm
/ g3 n; v2 j9 s2 ]$ F
6 u; y; X5 g# b# ?sele 19 l$ N: N4 `# q+ v! \  p: K7 t
use dm
2 w+ A1 o' o, sindex on ksh tag ksh" ~, N8 f( E, t% y$ v- h- }
sele 2% {/ ~! @+ y' @1 u- S
. h* Y" T  q: k6 @! E, Fuse mb3 m8 B) [3 W( @% _9 I) y
& z9 ?0 L2 F$ Q8 ~+ U& c: Lindex on ksh tag ksh) a  l. e5 e& @9 t, e, {, G
set rela to ksh into a% `( y% z. h" Y# s9 K9 k' i, v
repl all b.zymc with a.zymc for b.ksh=a.ksh) Z(! P6 k8 j0 G) G! G* T
MODIFY STRUCTURE9 P, M4 M1 |9 q4 X4 \+ L9 \/ V
sele 1
6 Z! ?5 s. y; Z6 k; p( cuse dm. x# o4 m/ ^3 `+ p
REPLACE ALL xh WITH ALLTRIM(xh)
5 m' y5 X% c, k1 j- W% M4 asele 1$ @" s8 b1 a$ Y/ l) |
use dm/ q0 P2 |0 F8 G5 e2 L# Y
index on xh tag xh
1 N  Y- J" k* b7 W; _( \sele 28 j" ~0 P1 S4 {5 z# ?; F+ x
use mb( y/ R1 e+ _0 _9 P) T
index on xh tag xh
* t9 R% x8 @* J: Z. wset rela to xh into a. h2 z* x( f- J
repl all b.erji with a.erji for b.xh=a.xh6 N- {$ i) o& U; j2 ~6 S8 }4 [
repl all b.siji with a.siji for b.xh=a.xh
# h* T; i$ J$ |2 t; k. lrepl all b.liuji with a.liuji for b.xh=a.xh! ~! ?/ J  j+ }
COPY TO sijierji FOR erji<'60'
# r( j7 J4 e0 E0 U/ rCOPY TO sijierji FOR erji<'60' OR siji<'400'" ]7 f- y: V. W' C( F
COPY TO liuji FOR liuji<'400' AND cc='硕士'
- t' V7 _& d3 ~8 K: yCOPY TO c:\users\administrator\desktop\2015毕业班\六级未过400名单.xls TYPE XL5$ ~5 F) D6 r; i5 m( G" \5 f1 ~! u$ Z
COPY TO c:\users\administrator\desktop\2015毕业班\四级二级未过名单.xls TYPE XL5
( [5 `3 H! t4 g0 bCOPY TO "d:\工作文件\14-15\14152\成教学位证书打印\2014年成人教育学位.xls" TYPE XL5
, y1 [/ \) O0 M' o) t( b% z% lCOPY TO c:\users\administrator\desktop\毕业班名单.xls TYPE XL5
. W/ X6 @2 B6 q! E" X* e' t( ]: QCOPY TO c:\users\administrator\desktop\预审.xls TYPE XL5
0 P8 B; p) P, t0 \REPLACE ALL xz WITH '5' FOR xz='7'
% _/ T  h, U5 Z2 D! `0 @COPY TO bs FOR bz='10': w! E( g- I) u( C9 V# F
COPY TO bs FOR bz='10本硕'9 M* g1 ~" n* c0 L( b
COPY TO bs FOR bz='本硕': W4 j0 E( r( p; h0 f+ r
COPY TO bs FOR bz='2010本硕本科阶'* e5 G8 I% d1 Z+ o2 k
sort on ksh to 1
+ a7 R: |- e7 _, n- ^# Z/ ]3 fREPLACE ALL byrq WITH '20150701'
, U3 Q% G2 J' [: ?8 [REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 1,1
9 h( [: j1 C7 j( E# C- X& K9 ZREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER
6 c: Q, f, \0 S4 }7 `2 BREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 2,100* s/ c9 F! n1 V0 d4 ^
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 101,458* l& s  {' R) U7 A* Q
repl all xwlb with '理学' for zymc='生物技术', Y3 q* z6 D* c# w7 {
repl all xwlb with '法学' for zymc='法学'
5 Z# P% S$ k- A+ ~7 y% R8 v$ n) Trepl all xwlb with '理学' for zymc='卫生检验'
3 C1 T- P4 s' D8 S+ z- g5 ]repl all xwlb with '理学' for zyfx='药品监督与管理'
  A- P( h7 m2 |9 K! crepl all xwlb with '理学' for zyfx='药品营销'
& Q3 T* a: m+ }" P* m9 l( wrepl all xwlb with '理学' for zymc='中药学': o8 j) \; y' c; i* B
repl all xwlb with '医学' for xwlb=' '
8 o) Y) R9 p, g  t- c% srepl all xwlb with '管理学' for zyfx='劳动与社会保障'3 t" G& i9 A: U5 ^2 [, L
repl all xwlb with '管理学' for zymc='劳动与社会保障'. `' a' a* q) y3 O
repl all zymc2 WITH ALLTRIM(zymc)+"(ALLTRIM(zyfx))"
5 l  m* t0 H" D% k8 @repl all zymc2 WITH ALLTRIM(zymc)+"("+ALLTRIM(zyfx)+"+"! ]1 x$ A2 ]" |! A/ `
repl all zymc2 WITH ALLTRIM(zymc)+"("+ALLTRIM(zyfx)+")"
) e- ]3 s. F# q, \- F- a4 @repl all zymc2 WITH ALLTRIM(zymc)+"("+ALLTRIM(zyfx)+")" FOR zyfx<>' '
5 m7 i% Q9 j' }" p  N9 grepl all zymc2 WITH ' ' FOR zyfx=' '6 j7 w- E1 `4 W1 U6 m
repl all xwlb with '理学' for zymc='食品质量与安全'
. J4 w; G5 I+ E6 l# a  orepl all xwlb with '工学' for zymc='生物医学工程'- ^' {/ H; ^, Z* d# ^8 p
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 671,1000
) P+ @9 G! {6 u" {1 D# J8 yREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 1001,1500
, a, z- p8 b& F1 VCOPY TO fxz FOR zyfx<>' '
/ G* K% M# X: YREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 1501,65534
& F: @7 L: ^! o0 l# TREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\08本硕毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 459,6706 K% _# m) l9 O% t
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\专升本毕业证书打印2014\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 353,353
' @( V3 L  \6 R4 h( C2 H" a3 @3 yREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\专升本毕业证书打印2014\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 354,380
% W6 k6 |7 [& A9 i$ l3 x* ~REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\专升本毕业证书打印2014\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 356,380- e7 v+ n; }" P; v' Z. y, h
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 1748,1748! O$ g6 X; {! k) C. M
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 353,3530 E0 ]9 y4 w$ }
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\毕业证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 380,380# h3 J4 T1 ?+ ^  ]
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\08本硕专业学位证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 481,670+ p1 m0 \$ `9 Y3 s' Z! A& l
MODIFY STRUCTURE; @; R3 G; f/ l5 `9 l. L! g
REPLACE ALL xh WITH ALLTRIM(xh)
7 D1 y3 w' S* F8 O/ G. esele 10 a9 x+ w" I1 u8 V8 I- k
use dm* z* ?- C1 x+ A) a9 q$ @
index on xh tag xh  O$ u- B! N! a+ W. M
sele 2
2 S) ^# J9 `6 S# n2 i9 e" tuse mb
. x3 d5 e5 z- J. P) ~  @/ `0 hindex on xh tag xh4 [( J5 c2 M4 E$ z
set rela to xh into a
' j0 K6 P- \3 w( Mrepl all b.jd with a.jd for b.xh=a.xh8 v1 a. ?1 z2 @
BROWSE
+ ?6 x  ]! r& c& h- R1 K5 }COPY TO 2 FOR jd<>' '
; i8 t8 W1 p- I6 ACOPY TO 2 FOR jd<>''9 o& Y; ?7 R* E9 _
COPY TO 2 FOR jd<> ' '. }  b. Q& j) g* _( Y
COPY TO c:\users\administrator\desktop\222.xls TYPE XL5
7 H- B9 @: l) m! y) h& pCOPY TO 2 FOR jd<'2'
2 {+ C$ s- c# e$ ]  Ic. M- C- A# p5 W, k1 b7 _' `
REPLACE ALL  jd WITH ALLTRIM(jd)
% ~2 t. s/ H/ ^& ^4 ?COPY TO 2 FOR jd<>' '& S" e' z) A4 G, B1 C, w3 k
COPY TO 2 FOR jd<>' ' OR siji<'400'
# I/ }, T7 v0 K% {5 J+ kCOPY TO 2 FOR jd<>' ' OR siji<'400' OR erji<'60' " t" e" W5 T* r" g# |& Z
COPY TO c:\users\administrator\desktop\绩点2.0和四六级计算机二级名单.xls TYPE XL5* z7 b" l/ y8 Q' j
REPLACE ALL zyfx WITH '医疗保险' FOR zymc='劳动与社会保障'
; H) k0 T: D7 Q! t1 HREPLACE ALL zymc2 WITH ALLTRIM(zymc)+ALLTRIM(zyfx) FOR zymc='劳动与社会保障'* k. w% n% V7 F8 N  `& }
REPLACE ALL zymc2 WITH ALLTRIM(zymc)+ALLTRIM(zyfx) FOR zyfx<>' '7 X7 S1 V" v9 e7 |
REPLACE ALL zymc2 WITH ALLTRIM(zymc) FOR zyfx=' '
2 N$ E' H8 T% z: @) b$ y; m7 |REPLACE ALL zymc2 WITH ALLTRIM(zymc)+'('+ALLTRIM(zyfx)+')' FOR zyfx<>' '
. r: {# M+ i6 B% F; H0 S# T; hREPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\方向证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 439,4581 f& A3 Q0 \/ d7 w: r) J$ O1 ^
COPY TO fxz FOR zyfx<>' ', s% G5 d1 l, f, C( M- Z
REPLACE ALL zyfxzh WITH 'FX103662015'+ RIGHT('0564'+ALLTRIM(STR(RECNO())),4) for zymc='劳动与社会保障'
) D+ \9 v, U5 v% }$ L" Z6 mSORT TO 2 ON zyfxzh9 H( J( T& h! E7 f& ?( x
COPY TO c:\users\administrator\desktop\2015毕业班\2222.xls TYPE XL53 d; `0 B: z, S; o% x2 z2 q3 ]# r, b, v
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\方向证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 439,4584 [! A" f: ?) x/ }- _
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\方向证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 439,439+ ]6 C! J5 X$ a9 D4 E. P! H. V& b3 i
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\学位证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 252,252. H: S! t1 q# s1 T4 ~( F; A2 C
COPY TO c:\users\administrator\desktop\2015毕业班\2015届毕业班证书发放表.xls TYPE XL5
" D" b3 [7 \$ |% l# H. h( d% t! zAPPEND FROM p0 L9 A( ]# q- B7 T0 q& D
BROWSE
1 C( ^! \; t) ~# s2 Q4 g6 pREPLACE ALL bjyjl WITh% S& ~& g, F- v% G; X
REPLACE ALL bjyjl WITH '毕业'5 ]5 y, A3 `0 M! a7 N, Z7 I2 U
APPEND FROM p5 z! f6 e" Q; B( o
REPLACE ALL xzm WITH '曹云霞') Z1 M* T+ c2 J+ l5 N7 u
sele 1
1 x" O! A/ _' @2 u* O' quse dm* R2 N; z& l+ W0 F
index on xh tag xh2 `# w: e( B8 B1 K$ j+ L, }
sele 25 b' r& \7 q5 m0 y$ i
use mb4 T8 w; y, M/ c# e8 m
index on xh tag xh
5 ~6 P+ O1 y8 qset rela to xh into a4 A4 l) T9 Z% u1 ~. G$ |6 R+ d7 k
repl all b.bk with a.bk for b.xh=a.xh
' s  y) S& u: l2 [* m$ msele 1( ^5 M! _- O' q. C. y
use dm
( O) b4 `$ w+ o% ^index on xh tag xh
% Z% a1 a9 ?1 p2 T- A( osele 27 I; K+ Z- [% s- `" q! u
use mb
- Z5 I$ }. T" s, d1 \8 Kindex on xh tag xh
3 j0 T! {8 Z/ O. |- \set rela to xh into a( l3 W. f8 O" C& ~" ^
repl all b.bz with 'bb'for b.xh=a.xh
" A& X) N# I" u) A$ brepl all b.xh with 'bb'for b.xh=a.xh* ?! Y* i1 l% k) r; K
COPY TO xx FOR xh<>'bb'1 W5 y4 a% Z( A0 p6 H7 y. c9 W
REPLACE ALL xzm WITH '曹云霞'
% _$ p4 f: H, \) RMODIFY STRUCTURE: T8 ?0 u( h- H
sele 18 q1 o9 t2 P0 I+ b0 f* Z
use dm& c* A5 W4 B9 a. i4 P
sele 1+ q3 F6 ?( [( o
use dm
% D& T" q7 l0 D0 M3 F; o3 uindex on xh tag xh
6 X9 k1 R& o1 o/ Q% X% _" d5 B; asele 2
; h& M! F# X: P/ v  L. t# |7 ^5 Vuse mb# K! }1 d$ T! K# p
index on xh tag xh
8 a4 a  @; e1 ~6 n; M+ |& vset rela to xh into a, P2 ]. k3 I6 ~/ S$ i; f
repl all b.hbs with 'H'for b.xh=a.xh( s+ z/ r0 \0 z9 _/ [5 \9 z( p1 L+ x
COPY TO c:\users\administrator\desktop\2015毕业班\毕业名单.xls TYPE XL5
! J  t- G1 P: O3 E) I2 rDELETE ALL FOR bz='2010本硕'( y+ z" W  `% O7 i+ R
PACK. d* q) e: m- ^  _0 ^
COPY TO n FOR xb='男', s' W! x2 d/ m$ x) ~
COPY TO z FOR xm='朱振丹'
" A) U1 n1 ~& j$ }7 l# r
5 I& u0 N% ]' d: hAPPEND FROM z
0 N( c) q4 H# c# i( p6 cBROWSE! g9 r/ g: L$ c; p; D' O+ s: n
APPEND FROM z
3 T: |( k9 d. \& v- Z  R/ lBROWSE
" Y9 t3 g: f9 R$ c' h/ d4 nCOPY TO c FOR xm='陈海瑞'! G9 y0 [: Z1 z; f1 L: }& o$ A
COPY TO h FOR xm='胡文'% m. C2 g8 U9 m  [7 C6 M. ?' I( r- n1 B
COPY TO h FOR xm='李永琴' OR xm='张杰'
* T+ {1 C& {3 V0 y3 m1 }' s# xAPPEND FROM h
2 J2 w0 Y! {5 C, l* ~! KBROWSE* n# x- u% p) G' U
COPY TO c FOR xm='储剑虹'! @6 [! F4 h* H; m: R
BROWSE
1 Z# d# D! @0 e( Q/ {3 TAPPEND FROM c
, Z7 c  U1 }& _! t; ?APPEND FROM s' L1 V2 W' h, X. I
BROWSE
) g5 j8 H+ W; N( r/ r, LCOPY TO w FOR xm='王永林'
7 V/ O% G& \: l* j( `, Q1 L% c2 KAPPEND FROM w3 e" x! E- z& n& x( u
COPY TO h FOR xm='胡一平'
2 Q% _. h7 A4 ?COPY TO g FOR xm='高昌进'
6 V/ a' |$ ^% [6 x9 s* BAPPEND FROM g
) r) v2 ]& t& d; o8 {. JBROWSE) [1 u- b6 b5 ?  J
COPY TO w FOR xm='王永林' OR xm='胡一平' OR xm='高昌进'$ ?* ~4 A" D! |( I
DELETE ALL FOR xm='王永林' OR xm='胡一平' OR xm='高昌进'
0 c; b3 A  N' p% E5 ?PACK
/ t# e" j- h4 w, ?  FAPPEND  FROM w' _! f, V% f$ j" v* L
BROWSE
6 _2 G) `: a: o$ u7 C: g7 Y; JCOPY TO h FOR xm='胡一平'
$ ^6 s4 h+ Y! _5 iAPPEND FROM h$ h* N5 I2 P7 j# \; c; k" [
PACK9 }$ R. m/ l6 ^9 q2 b; H/ E2 [
BROWSE
$ C3 `( D6 g/ OCOPY TO y FOR xm='杨学红'
- J9 f3 ?8 d/ U# K, m- T" @+ P( HAPPEND  FROM y
  o/ i0 I! J5 E* P" }COPY TO w FOR xm='汪颀': f) [$ E) C  \6 W; h( u" _
APPEND  FROM w( H* ~) q3 C& `4 u3 Y- @6 f( x( n
BROWSE
! s- d; m  s' E: i! D# A& B* jAPPEND  FROM w9 Y* ?4 g2 t2 u7 f
COPY TO y FOR xm='姚玮'
4 R! [" ]0 K: S  s6 ]1 P' c) qCOPY TO y FOR xm='姚  玮'1 o6 F7 {8 l6 c$ Q  ^/ l+ K8 C
APPEND FROM y
- e& u/ h9 @/ b% p& W2 ~REPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 81,93
& {& H0 ]5 D! X* r- k; A3 OREPORT FORM d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\学位证明书打印\xwzmsdy.frx NOEJECT NOCONSOLE TO PRINTER RANGE 50,65534
' _: h, N5 s$ GREPORT FORM "d:\工作文件\补办毕业证明书、学位证明书打印\毕业学位补办登记打印\毕业证明书打印\复件 byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 90,65534
6 H: H0 S  P6 O0 Y, ACOPY TO w FOR SUBSTR(ksh,10,1)='1', _8 m% d. o- d8 s1 t. R6 W
REPORT FORM "d:\工作文件\11-12\11122\学籍\2012届毕业班\2012证书打印\方向证书打印\byzsdy.frx" NOEJECT NOCONSOLE TO PRINTER RANGE 1262,12621 f# @3 }6 n# s' }8 V6 ]
COPY TO bs FOR bz='2008本硕'
5 Z# }( x- ?. \3 oCOPY TO bs FOR bz='2008级本硕'* Y, {1 o, i0 y2 Z2 c6 U" S; [
COPY TO bs FOR cc='硕士'
0 u) j2 t" P: R. P; d8 NCOPY TO bk FOR cc<>'硕士' AND hbs<>'H'
* _$ e5 w6 L" s: W2 X; s) FMODIFY STRUCTURE
! w$ p8 x  x7 PAPPEND FROM bk* g6 S$ c6 F3 D$ ^, j0 |- O) f
BROWSE
% x' a* M( c( z: U5 \MODIFY STRUCTURE
7 J( ^3 o  X. H8 m# U) O# kBROWSE
" @& v6 h8 |% l1 [, {MODIFY STRUCTURE$ n# ~, J1 X8 p. A* Y
BROWSE
9 u, U+ W/ U: [6 {3 Q/ vCOPY TO c:\users\administrator\desktop\exm.xls TYPE XL56 ]% q8 C  h. S8 f- S' s
MODIFY STRUCTURE
; |: Y* y, M! B, c+ ~sele 12 W, m3 R$ _, D( n- t! ]6 h; ?
use dm* d9 b' q2 a+ i  R
index on xh tag xh6 W  _+ z) d9 {- [$ M, ^; D
sele 2" t+ h$ _( P% ^& Z4 M
use mb" u* _- T# N! w+ n4 C8 i
index on xh tag xh
: V, _+ U) T" k# t/ m# `. [set rela to xh into a0 B+ |1 l6 w/ _* l
repl all b.xmpy with a.xmpy for b.xh=a.xh
$ E; l' v8 e: c( g5 ]REPLACE ALL  zp WITH ALLTRIM(sfzh)+'.jpg'
% c3 i$ J- ?5 o3 uREPLACE ALL  zjhm WITH ALLTRIM(zjhm)( s2 @8 @& C+ B' i
REPLACE ALL  zjhm WITH ALLTRIM(sfzh)7 M; Q. [# U' F; p9 Q
repl all zjlxm with '01'
' I7 j7 i5 `2 D3 k( Lrepl all PYDWM with '10366'
; G1 a5 W7 X# @, @5 U/ A( c; A9 Grepl all XWLBM with '410'' v4 k+ q, {. m
repl all XWLBM with '407' for xwlb='理学'$ D. [! o6 e7 N' h' f7 f8 u) K
repl all XWLBM with '403' for xwlb='法学': Q4 e( ?! Z* I+ A3 T. R1 g& E
repl all XWLBM with '412' for xwlb='管理学'. Q) @9 u8 g' ?8 S0 n/ E
repl all XWLBM with '408' for xwlb='工学'
& K8 F) p: v: b/ ]* Yrepl all rxny with subs(rxrq,1,6)& ^4 t8 k6 f2 N2 A5 S: v' C
repl all BYNY with subs(byrq,1,6)
* {5 d8 u7 C! E/ d0 o9 o& srepl all HXWRQ with subs(byrq,1,8)
) f8 x8 H8 B# t6 ]& L0 V( Vrepl all SFFXXW with '否'
4 f! `% h/ b, ?. vrepl all SFDEXW with '否'
. c* U6 X  C# h2 v0 qrepl all zzmmm with '01 ' for zzmmm='中共党员'
4 y3 b2 ]3 _) srepl all zzmmm with '02 ' for zzmmm='中共预备党员'
# v6 e. e% Y& k) b+ e9 |; rrepl all zzmmm with '01 ' for zzmm='中共党员'# ~3 w8 }- d6 \; w; t: a) q9 b
repl all zzmmm with '02 ' for zzmm='中共预备党员'
, n* G& g+ R" w$ mrepl all zzmmm with '03 ' for zzmm='共青团员'( v2 e. ~% F! @: u/ p* b7 Q! V, U
repl all zzmmm with '13 ' for zzmm='群众'3 @  B6 M( K- T1 F% \: i  s
repl all mzm with '01 ' for mz='汉族'# I" }* _; W5 Q; T- q5 G* V- C
repl all mzm with '02 ' for mz='蒙古族'
  h' [' v3 F$ ]' v% Qrepl all mzm with '03 ' for mz='回族'
3 c/ J1 E! E; i/ Brepl all mzm with '04 ' for mz='藏族'
& h  Z' ~$ U+ b7 \& C+ erepl all mzm with '06 ' for mz='苗族'
4 v; d  o+ s* p4 \repl all mzm with '15 ' for mz='土家族'
2 |$ V& |5 I* C/ jrepl all mzm with '11 ' for mz='满族'
" g  }8 {; H. y* R. {/ vrepl all zxxm with '曹云霞'2 X# q. O. y$ R, C
repl all xzxm with '曹云霞'
/ b0 m6 u5 C2 A6 D0 @1 ]; @DELETE ALL FOR cc<>'硕士研究生'
4 T, h  @: j0 z8 F0 F9 ~PACK  c. a7 {5 T$ w7 C! W; l
BROWSE7 E1 b6 ]/ a( A
MODIFY STRUCTURE) b1 `* Y' {  _4 \5 ~
sele 1
& G! P+ |6 v" \! Fuse dm
) D  D- \: T5 i3 r9 |: @9 E+ Cindex on xh tag xh9 [% I, E5 }, }% s9 x) h! ~
sele 2
1 F. \9 M! J% o- ~* n' @) t" @, nuse mb: M; f, k$ f/ D, \
index on xh tag xh
" \" D+ |5 ~- i) i: Jset rela to xh into a0 [/ b. `# x8 b$ B0 ^
repl all b.LWTM with a.LWTM for b.xh=a.xh
8 ]9 {0 x- u) p' Nrepl all b.LWGJC with a.LWGJC for b.xh=a.xh5 V9 c  \$ s$ L$ y( I% N4 ^0 @
repl all b.LWLXM with a.LWLXM for b.xh=a.xh7 p# s; q' P6 _1 o+ ~
repl all b.LWXTLYM with a.LWXTLYM for b.xh=a.xh
) n: l( X! o$ erepl all b.DSXM with a.DSXM for b.xh=a.xh
2 Q7 Y7 [7 X: M4 C' n, x7 r6 O' C6 }repl all xwsydwm with '10366'
: Z9 I2 @2 B, Z. sCOPY TO bs FOR cc='硕士'
$ N; f' r3 {( d* J0 tCOPY TO bk FOR cc<>'硕士' AND hbs<>'H'5 z9 ?6 ^' S% s* g  c
REPLACE ALL xwlbm WITH '31051'
( N' s0 q' S/ b1 `COPY TO bk FOR cc='本科' AND bz='2010级本硕'
. i8 o7 ~* g/ }0 M% @' {( |COPY TO bk FOR cc='本科' AND bz='2010本硕'0 C  l' q6 }1 C
REPLACE ALL xwzsbh WITH ' ' FOR hbs='h'- }( F; E1 |8 i6 L5 K7 z1 f
REPLACE ALL xwzsbh WITH ' ' FOR hbs='H'  ~, R8 L! K& s% f  I8 I
repl all xbm with '2' for xb='女': S6 T0 y  L" E; F
repl all xbm with '1' for xb='男'" X7 p2 X, W# c
COPY TO k FOR mzm is null
' E: l% p7 p3 u2 v2 o& \COPY TO k FOR mzm=' '! G8 ?6 |  J, @( ?
R
- ?) y& J- b' b3 ?EPLACE ALL mzm='19' FOR mz='黎族'$ S0 J# L! S. S2 f5 y! k
REPLACE ALL mzm WITH '19' FOR mz='黎族'
: a5 B+ z; x4 W: trepl all gbm with '156': ~  B  Q) I9 E# i
repl all zyxwlym with '105199' for cc='硕士研究生'
: E6 G( S+ s# Q; Frepl all ksfsm with '01' for cc='硕士研究生'2 l7 w- C4 W, G- v( i% Y+ r- @
repl all qzxwm with '410' for cc=‘硕士研究生’  G/ q3 G) I% t$ T7 g
repl all qzxwm with '410' for cc='硕士研究生'% P7 M+ D& s* z+ S6 A
repl all qzxlm with '3' for cc='硕士研究生'
3 S# M/ r% J8 B6 A) z9 qrepl all hqzxwny with '201307' FOR cc='硕士研究生'7 ?! E# g! d# {
repl all qzxwdwm with '10366' for cc='硕士研究生'* C4 N( t+ q4 Z3 d/ o
repl all qxm with '01' for  cc='硕士研究生'
' V! Q9 F7 ]" ~+ }repl all gzdwxzm with '24' for cc='硕士研究生'8 L: x* F- F/ \% }# d2 z) z
repl all gzdwssm with '34' for cc='硕士研究生'
+ Z  |0 b1 [/ V& ACOPY TO bs FOR cc='硕士': C5 f- p) y- R4 r2 j. c
COPY TO bk FOR cc<>'硕士' AND hbs<>'H'
' p/ B; z7 C0 s  A  B, vrepl all HKSZSSM with '34' for cc='硕士研究生'0 M. _# V3 a& p* i
repl all gzxzm with '9' for cc='硕士研究生'0 J' u/ E, h' g- Y! H8 c3 x3 V
COPY TO bs FOR cc='硕士' AND hbs<>'H'
( ?" W: Q& Z, G! pCOPY TO bk FOR cc<>'硕士' AND hbs<>'H'% ~2 w1 p( @) r! y3 e8 G$ y
COPY TO bs FOR cc='硕士' AND hbs<>'H'
% h. \' e2 E# vCOPY TO h FOR xm='王正' OR xm='程旭' OR xm='朱全伟' OR xm='陈峰'* z: L4 t$ ?7 S" h% a9 F
PACK
& P9 J. H' x5 u2 f8 j3 gBROWSE1 x$ h: N  T3 a1 l
REPORT FORM c:\users\administrator\desktop\2015毕业班\2015证书打印\学位证书打印2015\byzsdy.frx NOEJECT NOCONSOLE TO PRINTER
  C+ z$ d' ?- Z  h% F# M; r
 楼主| being 发表于 2017-3-16 10:46:53 | 显示全部楼层
本帖为密码帖 ,请输入密码 
您需要登录后才可以回帖 登录 | 入住

本版积分规则