文件名称:gongzhiguanli
介绍说明--下载内容均来自于网络,请自行研究使用
简单的工资发放管理软件,Delphi 7下开发-/* Table: SALARY_SET, Owner: MISDBA*/
CREATE TABLE SALARY_SET (PERSON CHAR(6) NOT NULL,
SALARY FLOAT,
CONSTRAINT SALARY_SET_PEROSN PRIMARY KEY (PERSON))
/* Table: SALARY_OTHER, Owner: MISDBA*/
CREATE TABLE SALARY_OTHER (ID INTEGER NOT NULL,
YEARMONTH CHAR(7) NOT NULL,
PERSON CHAR(6) NOT NULL,
OTHER_TYPE CHAR(1) NOT NULL,
NAME VARCHAR(10) NOT NULL,
MONEY FLOAT,
DEscr iptION VARCHAR(200),
CONSTRAINT SALARY_OTHER_ID PRIMARY KEY (ID))
/* Table: OTHER_TYPE, Owner: MISDBA*/
CREATE TABLE OTHER_TYPE (CODE CHAR(1) NOT NULL,
DEscr iptION VARCHAR(10) NOT NULL,
CONSTRAINT TYPE_CODE PRIMARY KEY (CODE))
/* Table: SALARY, Owner: MISDBA*/
CREATE TABLE SALARY (ID INTEGER NOT NULL,
YEARMONTH CHAR(7) NOT NULL,
PERSON CHAR(6) NOT NULL,
BASIC FLOAT,
BONUS FLOAT,
ADD_DETAIL VARCHAR(200),
ADD_TOTAL FLOAT,
SUB_DETAIL VARCHAR(200),
SUB_TOTAL FLOAT,
CREATE TABLE SALARY_SET (PERSON CHAR(6) NOT NULL,
SALARY FLOAT,
CONSTRAINT SALARY_SET_PEROSN PRIMARY KEY (PERSON))
/* Table: SALARY_OTHER, Owner: MISDBA*/
CREATE TABLE SALARY_OTHER (ID INTEGER NOT NULL,
YEARMONTH CHAR(7) NOT NULL,
PERSON CHAR(6) NOT NULL,
OTHER_TYPE CHAR(1) NOT NULL,
NAME VARCHAR(10) NOT NULL,
MONEY FLOAT,
DEscr iptION VARCHAR(200),
CONSTRAINT SALARY_OTHER_ID PRIMARY KEY (ID))
/* Table: OTHER_TYPE, Owner: MISDBA*/
CREATE TABLE OTHER_TYPE (CODE CHAR(1) NOT NULL,
DEscr iptION VARCHAR(10) NOT NULL,
CONSTRAINT TYPE_CODE PRIMARY KEY (CODE))
/* Table: SALARY, Owner: MISDBA*/
CREATE TABLE SALARY (ID INTEGER NOT NULL,
YEARMONTH CHAR(7) NOT NULL,
PERSON CHAR(6) NOT NULL,
BASIC FLOAT,
BONUS FLOAT,
ADD_DETAIL VARCHAR(200),
ADD_TOTAL FLOAT,
SUB_DETAIL VARCHAR(200),
SUB_TOTAL FLOAT,
(系统自动生成,下载前可以参看下载内容)
下载文件列表
Delphi版工资发放管理系统\source_code\crypt.dcu
........................\...........\crypt.pas
........................\...........\formula.ini
........................\...........\Salary.cfg
........................\...........\Salary.dof
........................\...........\Salary.dpr
........................\...........\Salary.res
........................\...........\u_datamodule.dcu
........................\...........\u_datamodule.ddp
........................\...........\u_datamodule.dfm
........................\...........\u_datamodule.dti
........................\...........\u_datamodule.pas
........................\...........\u_formula.dcu
........................\...........\u_formula.dfm
........................\...........\u_formula.pas
........................\...........\u_login.dcu
........................\...........\u_login.ddp
........................\...........\u_login.dfm
........................\...........\u_login.pas
........................\...........\u_main.dcu
........................\...........\u_main.ddp
........................\...........\u_main.dfm
........................\...........\u_main.pas
........................\...........\u_report.dcu
........................\...........\u_report.ddp
........................\...........\u_report.dfm
........................\...........\u_report.pas
........................\SQL7.txt
........................\source_code
Delphi版工资发放管理系统