labmis_zlgl.sql

十分完善地实现了实验室管理系统

create table dbo.labmis_zlgl
       (zlbh char(4) not null,
       zlmc nvarchar(60) null,
       dj numeric(12,2) null,
       gmrq datetime null,
       zksl int null,
       cbdw nvarchar(60) null,
       jyqk char(1) null,
       jyr nvarchar(10) null,
       jcsl int null) ;
 
alter table dbo.labmis_zlgl
       add constraint zlbh primary key  nonclustered
       (zlbh) ;
 
insert into dbo.pbcattbl
        (pbt_tnam, pbt_tid, 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  ( 'labmis_zlgl',
       object_id('dbo.labmis_zlgl'),
        'dbo',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
        -9,  400,  'N',  'N',  134,  2,
        '宋体',
       ' ') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'zlbh', 1,
        'Zlbh:', 0 ,
        'Zlbh', 0,
       23 , '',
       0 , 77 , 161 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'zlmc', 2,
        'Zlmc:', 0 ,
        'Zlmc', 0,
       23 , '',
       0 , 77 , 1441 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'dj', 3,
        'Dj:', 0 ,
        'Dj', 0,
       24 , '[General]',
       0 , 77 , 389 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'gmrq', 4,
        'Gmrq:', 0 ,
        'Gmrq', 0,
       23 , '',
       0 , 77 , 481 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'zksl', 5,
        'Zksl:', 0 ,
        'Zksl', 0,
       24 , '[General]',
       0 , 77 , 206 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'cbdw', 6,
        'Cbdw:', 0 ,
        'Cbdw', 0,
       23 , '',
       0 , 77 , 1441 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'jyqk', 7,
        'Jyqk:', 0 ,
        'Jyqk', 0,
       23 , '',
       0 , 77 , 87 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'jyr', 8,
        'Jyr:', 0 ,
        'Jyr', 0,
       23 , '',
       0 , 77 , 293 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_zlgl',
        object_id('dbo.labmis_zlgl'),
        'dbo',  'jcsl', 9,
        'Jcsl:', 0 ,
        'Jcsl', 0,
       24 , '[General]',
       0 , 77 , 206 ,
        '', 'N',
        '',
        ' ',
        '', '') ;