1.前期管理.sql

一个很不错的实验室设备管理系统,用PB作为开发工具,具有一定的代表性.

        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'yfqzr',
        '乙方签字人',
       0 ,
        '乙方签字人',
       0,
       23 ,
       0 ,
       77 ,
       293 ,
       'N',
        '乙方签字人' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'sbmc',
        '设备名称',
       0 ,
        '设备名称',
       0,
       23 ,
       0 ,
       77 ,
       983 ,
       'N',
        '设备名称' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'ggxh',
        '规格型号',
       0 ,
        '规格型号',
       0,
       23 ,
       0 ,
       77 ,
       293 ,
       'N',
        '规格型号' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'zzc',
        '制造厂',
       0 ,
        '制造厂',
       0,
       23 ,
       0 ,
       77 ,
       1207 ,
       'N',
        '制造厂' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'dj',
        '单价',
       0 ,
        '单价',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       389 ,
       'N',
        '单价' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'sl',
        '数量',
       0 ,
        '数量',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       389 ,
       'N',
        '数量' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'je',
        '金额',
       0 ,
        '金额',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       389 ,
       'N',
        '金额' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'fkfs',
        '付款方式',
       0 ,
        '付款方式',
       0,
       23 ,
       0 ,
       77 ,
       1207 ,
       'N',
        '付款方式' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('cght',
       'dba',
       'httk',
        '合同条款',
       0 ,
        '合同条款',
       0,
       23 ,
       0 ,
       77 ,
       4641 ,
       'N',
        '合同条款' ) ;
 
CREATE TABLE "dba"."kxys"
        ("id" char(22) NOT NULL ,
       "kxdh" varchar(20)  ,
       "kxrq" date  ,
       "sbmc" varchar(40)  ,
       "ggxh" varchar(20)  ,
       "zzc" varchar(40)  ,
       "ccny" varchar(10)  ,
       "ccbh" varchar(20)  ,
       "sybm" varchar(40)  ,
       "dcny" varchar(10)  ,
       "hth" varchar(10)  ,
       "zxs" integer  ,
       "sbjg" numeric(12,2)  ,
       "ghdw" varchar(40)  ,
       "ghfdb" varchar(10)  ,
       "ysbm" varchar(40)  ,
       "ysry" varchar(10)  ,
       "ysjl" varchar(200)  ) ;
 
CREATE UNIQUE INDEX "kxys"
        ON "dba"."kxys"
        ("id" ) ;
 
insert into "dba".pbcattbl
       (pbt_tnam,
        pbt_ownr,
        pbd_fhgt,
        pbd_fwgt,
        pbd_fitl,
        pbd_funl,
        pbd_fchr,
        pbd_fptc,
        pbd_ffce,
        pbh_fhgt,
        pbh_fwgt,
        pbh_fitl,
        pbh_funl,
        pbh_fchr,
        pbh_fptc,
        pbh_ffce,
        pbl_fhgt,
        pbl_fwgt,
        pbl_fitl,
        pbl_funl,
        pbl_fchr,
        pbl_fptc,
        pbl_ffce,
        pbt_cmnt)
       values
       ('kxys',
        'dba',
        -9,
        400,
        'N',
        'N',
        0,
        34,
        'Arial',
        -9,
        400,
        'N',
        'N',
        134,
        2,
        '宋体',
        -9,
        400 ,
        'N',
        'N',
        134,
        2,
        '宋体',
        '开箱验收') ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'id',
        '序列号',
       0 ,
        '序列号',
       0,
       23 ,
       0 ,
       77 ,
       567 ,
       'N',
        '序列号' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'kxdh',
        '开箱单号',
       0 ,
        '开箱单号',
       0,
       23 ,
       0 ,
       77 ,
       526 ,
       'N',
        '开箱单号' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'kxrq',
        '开箱日期',
       0 ,
        '开箱日期',
       0,
       23 ,
       0 ,
       77 ,
       247 ,
       'N',
        '开箱日期' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'sbmc',
        '设备名称',
       0 ,
        '设备名称',
       0,
       23 ,
       0 ,
       77 ,
       983 ,
       'N',
        '设备名称' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'ggxh',
        '规格型号',
       0 ,
        '规格型号',
       0,
       23 ,
       0 ,
       77 ,
       526 ,
       'N',
        '规格型号' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'zzc',
        '制造厂',
       0 ,
        '制造厂',
       0,
       23 ,
       0 ,
       77 ,
       983 ,
       'N',
        '制造厂' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'ccny',
        '出厂年月',
       0 ,
        '出厂年月',
       0,
       23 ,
       0 ,
       77 ,
       293 ,
       'N',
        '出厂年月' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'ccbh',
        '出厂编号',
       0 ,
        '出厂编号',
       0,
       23 ,
       0 ,
       77 ,
       526 ,
       'N',
        '出厂编号' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'sybm',
        '使用部门',
       0 ,
        '使用部门',
       0,
       23 ,
       0 ,
       77 ,
       983 ,
       'N',
        '使用部门' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'dcny',
        '到厂年月',
       0 ,
        '到厂年月',
       0,
       23 ,
       0 ,
       77 ,
       293 ,
       'N',
        '到厂年月' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'hth',
        '合同号',
       0 ,
        '合同号',
       0,
       23 ,
       0 ,
       77 ,
       293 ,
       'N',
        '合同号' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'zxs',
        '装箱数',
       0 ,
        '装箱数',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       206 ,
       'N',
        '装箱数' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,
        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('kxys',
       'dba',
       'sbjg',
        '设备价格',
       0 ,
        '设备价格',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       389 ,
       'N',
        '设备价格' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,