labmis_rygl.sql

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

create table dbo.labmis_rygl
       (rybh char(4) not null,
       xm nvarchar(10) null,
       csny datetime null,
       xb char(1) null,
       jg nvarchar(60) null,
       zzmm char(2) null,
       xl char(2) null,
       zw nvarchar(10) null,
       qt text null,
       llfs text null) ;
 
alter table dbo.labmis_rygl
       add constraint rybh primary key  nonclustered
       (rybh) ;
 
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_rygl',
       object_id('dbo.labmis_rygl'),
        'dbo',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
       ' ') ;
 
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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'rybh', 1,
        'Rybh:', 0 ,
        'Rybh', 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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'xm', 2,
        'Xm:', 0 ,
        'Xm', 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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'csny', 3,
        'Csny:', 0 ,
        'Csny', 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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'xb', 4,
        'Xb:', 0 ,
        'Xb', 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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'jg', 5,
        'Jg:', 0 ,
        'Jg', 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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'zzmm', 6,
        'Zzmm:', 0 ,
        'Zzmm', 0,
       23 , '',
       0 , 77 , 110 ,
        '', '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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'xl', 7,
        'Xl:', 0 ,
        'Xl', 0,
       23 , '',
       0 , 77 , 110 ,
        '', '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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'zw', 8,
        'Zw:', 0 ,
        'Zw', 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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'qt', 9,
        'Qt:', 0 ,
        'Qt', 0,
       23 , '',
       0 , 77 , 5893 ,
        '', '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_rygl',
        object_id('dbo.labmis_rygl'),
        'dbo',  'llfs', 10,
        'Llfs:', 0 ,
        'Llfs', 0,
       23 , '',
       0 , 77 , 5893 ,
        '', 'N',
        '',
        ' ',
        '', '') ;