Разработка базы данных "Кадры"

Дипломная работа - Компьютеры, программирование

Другие дипломы по предмету Компьютеры, программирование

PARAMETER org_num

org_num1=org_num

IF DELETED()=.t.

RECALL

SELECT b

RECALL FOR org_num=org_num1

SELECT c

RECALL FOR org_num=org_num1

SELECT d

RECALL FOR org_num=org_num1

SELECT e

RECALL FOR org_num=org_num1

SELECT f

RECALL FOR org_num=org_num1

SELECT g

RECALL FOR org_num=org_num1

SELECT h

RECALL FOR org_num=org_num1

SELECT i

RECALL FOR org_num=org_num1

SELECT j

RECALL FOR org_num=org_num1

SELECT 11

RECALL FOR org_num=org_num1

ELSE

DELETE

SELECT b

DELETE FOR org_num=org_num1

SELECT c

DELETE FOR org_num=org_num1

SELECT d

DELETE FOR org_num=org_num1

SELECT e

DELETE FOR org_num=org_num1

SELECT f

DELETE FOR org_num=org_num1

SELECT g

DELETE FOR org_num=org_num1

SELECT h

DELETE FOR org_num=org_num1

SELECT i

DELETE FOR org_num=org_num1

SELECT j

DELETE FOR org_num=org_num1

SELECT 11

DELETE FOR org_num=org_num1

ENDIF

SELECT a

RETURN

R_W.PRG

PARAMETER edit,type,up,down,next,previos,find,print,exit,eduadd,forlang, ;

conv,structfam,pass,bok,purpos,qualcateg,tripsbus,holid

list=1

exit=5

SET COLOR TO N/W+

SELECT A

IF RECCOUNT()=0

APPEND BLANK

ENDIF

DEFINE WINDOW win0 FROM 0, 0 TO 2, 79 NOGROW ;

NOFLOAT NOZOOM COLOR W+/N

DEFINE WINDOW win1 FROM 3, 0 TO 24, 79 NOGROW;

NOFLOAT NOZOOM COLOR GR+/B

DO WHILE exit<>1

ACTIVATE WINDOW win0

CLEAR

@ 0,8 SAY ALLTRIM(surname)+' '+ALLTRIM(name)+' '+ALLTRIM(patron)

IF type=1

@ 0,63 SAY 'ПРОСМОТР ДАННЫХ'

ENDIF

IF type=2

@ 0,57 SAY 'РЕДАКТИРОВАНИЕ ДАННЫХ'

ENDIF

IF type=3

@ 0,61 SAY 'ДОБАВЛЕНИЕ ДАННЫХ'

ENDIF

IF list=1

@ 0,0 SAY 'Экран 1'

DO wiev1.prg WITH edit

ENDIF

IF list=2

@ 0,0 SAY 'Экран 2'

DO wiev2.prg WITH edit

ENDIF

IF list=3

@ 0,0 SAY 'Экран 3'

DO wiev3.prg WITH edit

ENDIF

IF list=4

@ 0,0 SAY 'Экран 4'

DO wiev4.prg WITH edit

ENDIF

IF list=5

@ 0,0 SAY 'Экран 5'

DO wiev5.prg WITH edit

ENDIF

IF previos=1

SKIP -1

IF BOF()=.t.

GO BOTTOM

ENDIF

IF next=1

SKIP 1

IF EOF()=.t.

GO TOP

ENDIF

IF down=1

IF list<>1

list=list-1

ELSE

list=5

ENDIF

IF up=1

IF list<>5

list=list+1

ELSE

list=1

ENDIF

IF find=1

DO search.prg

ENDIF

org_num1=org_num

IF eduadd=1

DO educat.prg WITH org_num1,edit

ENDIF

IF forlang=1

DO language.prg WITH org_num1,edit

ENDIF

IF conv=1

DO convict.prg WITH org_num1,edit

ENDIF

IF structfam=1

DO family.prg WITH org_num1,edit

ENDIF

IF pass=1

DO passport.prg WITH org_num1,edit

ENDIF

IF bok=1

DO workcard.prg WITH org_num1,edit

ENDIF

IF purpos=1

DO move.prg WITH org_num1,edit

ENDIF

IF qualcateg=1

DO qualif.prg WITH org_num1,edit

ENDIF

IF tripsbus=1

DO bus_trip.prg WITH org_num1,edit

ENDIF

IF holid=1

DO holiday.prg WITH org_num1,edit

ENDIF

IF print=1

DO print.prg

ENDIF

ENDDO

RELEASE WINDOW win1

RELEASE WINDOW win0

RETURN

WIEV1.PRG

PARAMETER edit

ACTIVATE WINDOW win1

CLEAR

eduadd=5

forlang=5

conv=5

structfam=5

pass=5

bok=5

purpos=5

qualcateg=5

tripsbus=5

holid=5

org_n=org_num

@ 1,1 SAY'Таб. номер:__________________'

@ 2,1 SAY'Страховой номер:_____________'

@ 3,1 SAY'Фамилия:_____________________'

@ 4,1 SAY'Имя:_________________________'

@ 5,1 SAY'Отчество:____________________'

@ 6,1 SAY'Пол:_________________________'

@ 7,1 SAY'Дата рождения:_______________'

@ 8,1 SAY'Место рождения:______________'

@ 9,1 SAY'Национальность:______________'

@ 10,1 SAY'Социальное происхождение:____'

@ 11,1 SAY'Гражданство:_________________'

@ 12,1 SAY'Образование:_________________'

@ 13,1 SAY'Название учебного заведения:_'

@ 14,1 SAY'Форма обучения:______________'

@ 15,1 SAY'Год окончания:_______________'

@ 18,4 SAY'ЛИСТАТЬ'

@ 18,29 SAY'ЗАПИСЬ'

@ 16,0,16,77 BOX

@ 17,26,19,26 BOX

@ 17,52,19,52 BOX

STORE 6 TO org_num,ins_num,surname,name,up,down,next,;

previos,find,print,exit

@ 1,30 GET org_num VALID UN()=.t. ERROR ;

'Такой табельный номер уже существует'SIZE 1,6 WHEN edit=.t. COLOR SCHEME 2

@ 2,30 GET ins_num PICTURE 'NNN-NNN-NNN' SIZE 1,11 ;

WHEN edit=.t. COLOR SCHEME 2

@ 3,30 GET surname SIZE 1,15 WHEN edit=.t. COLOR SCHEME 2

@ 4,30 GET name SIZE 1,15 WHEN edit=.t. COLOR SCHEME 2

@ 5,30 GET patron SIZE 1,15 WHEN edit=.t. COLOR SCHEME 2

@ 6,30 GET sex VALID sex='М'OR sex='Ж'OR sex='м'OR sex='ж' ;

ERROR '[М]ужской или [Ж]енский' SIZE 1,1 ;

WHEN edit=.t. COLOR SCHEME 2

@ 7,30 GET birth_date SIZE 1,10 WHEN edit=.t. COLOR SCHEME 2

@ 8,30 GET birthplace SIZE 1,47 WHEN edit=.t. COLOR SCHEME 2

@ 9,30 GET national SIZE 1,15 WHEN edit=.t. COLOR SCHEME 2

@ 10,30 GET SOCIAL SIZE 1,47 WHEN edit=.t. COLOR SCHEME 2

@ 11,30 GET citizen SIZE 1,30 WHEN edit=.t. COLOR SCHEME 2

@ 12,30 GET educat SIZE 1,47 WHEN edit=.t. COLOR SCHEME 2

@ 13,30 GET NAME_EDU SIZE 1,47 WHEN edit=.t. COLOR SCHEME 2

@ 14,30 GET form_train SIZE 1,20 WHEN edit=.t. COLOR SCHEME 2

@ 15,30 GET year_end SIZE 1,10 WHEN edit=.t. COLOR SCHEME 2

STORE "* ВПЕРЕД" TO MPROMPTS

@ 17,14 GET up FUNCTION MPROMPTS SIZE 1, 8 COLOR SCHEME 11

STORE "* НАЗАД " TO MPROMPTS

@ 19,14 GET down FUNCTION MPROMPTS SIZE 1, 8 COLOR SCHEME 11

STORE "* СЛЕДУЮЩАЯ " TO MPROMPTS

@ 17,38 GET next FUNCTION MPROMPTS SIZE 1, 12 COLOR SCHEME 11

STORE "* ПРЕДЫДУЩАЯ" TO MPROMPTS

@ 18,38 GET previos FUNCTION MPROMPTS SIZE 1, 12 COLOR SCHEME 11

STORE "* НАЙТИ " TO MPROMPTS

@ 19,38 GET find FUNCTION MPROMPTS SIZE 1, 12 COLOR SCHEME 11

STORE "* ПЕЧАТЬ" TO MPROMPTS

@ 17,62 GET print FUNCTION MPROMPTS SIZE 1,5 COLOR SCHEME 11

STORE "* ВЫХОД" TO MPROMPTS

@ 19,62 GET exit FUNCTION MPROMPTS SIZE 1,5 COLOR SCHEME 11

READ CYCLE

IF org_n<>org_num

org_n1=org_num

SELECT 2