【正文】 ic](12, 2) NULL , [fxj] [numeric](12, 2) NULL , [lsj] [numeric](12, 2) NULL , [cj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [yxrq] [datetime] NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GO6．創(chuàng)建產(chǎn)品類別表CREATE TABLE [dbo].[dm_wzlb] ( [lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GO7．創(chuàng)建業(yè)務(wù)員表CREATE TABLE [dbo].[dm_ywy] ( [dm] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [sfz] [char] (18) COLLATE Chinese_PRC_CI_AS NULL , [lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[dm_ywylb] ( [lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[inh] ( [in_date] [datetime] NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [inh_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [gfdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [sl] [numeric](10, 0) NOT NULL , [in_danj] [numeric](12, 2) NULL , [i_zk] [numeric](5, 0) NULL , [i_zke] [numeric](12, 2) NULL , [jsfk] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [jz] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [yf] [numeric](5, 0) NULL , [bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL , [bz1] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[kucun] ( [update_date] [datetime] NULL , [kucun_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [sl] [numeric](10, 0) NOT NULL , [total_je] [numeric](12, 2) NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[outh] ( [out_date] [datetime] NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [outh_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [khdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [sl] [numeric](10, 0) NOT NULL , [out_danj] [numeric](12, 2) NULL , [o_zk] [numeric](5, 0) NULL , [o_zke] [numeric](12, 2) NULL , [jsfk] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [jz] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [yf] [numeric](5, 0) NULL , [bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL , [bz1] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[zc] ( [zc_no] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [zc_date] [datetime] NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [o_ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [i_ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [sl] [numeric](10, 0) NOT NULL , [total_je] [numeric](12, 2) NULL , [bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[xsdh] ( [out_date] [datetime] NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [xsdh_no] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [khdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [sl] [numeric](10, 0) NOT NULL , [out_danj] [numeric](12, 2) NULL , [o_zk] [numeric](5, 0) NULL , [o_zke] [numeric](12, 2) NULL , [bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[user_info] ( [user_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [user_pwd] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [user_des] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GO15．創(chuàng)建倉庫存儲過程CREATE PROCEDURE ck_setup(dm char (6),mc char (40),bz char (255)) AS　inserdm_ck(dm,mc,bz)values(dm,mcbz)GOCREATE PROCEDURE dh_setup(in_date datetime, ywman char (20),dh_no char (8),gfdm char (8),wzdm char (30),sl numeric (10),in_danj numeric (12, 2),i_zk numeric (5, 0),i_zke numeric (12, 2),bz char (100)) ASinsert dh(in_date,ywman,dh_no,gfdm,wzdmslin_danj,i_zk,i_zke,bz)values(in_date,ywman,dh_no,gfdm,wzdm,sl,in_danj,i_zk,i_zkebz)GOCREATE PROCEDURE gf_setup (dm char (8),mc char (40),addr char (40),yzbm char (6), tel char (40),itladd char (50), char (50),sui_no char (20),bank_no char (20),bank char (30),ywman char(8),bz char (255)) ASinsert dm_gf(dm,mc,addr,yzbm,tel,itladd,sui_no,bank_no,bank,ywman,bz)values(dm,mc,addr,yzbm,tel,itladd,sui_no,bank_no,bank,ywman,bz)GO(按業(yè)務(wù)員)CREATE PROCEDURE inh_inquire_ywy(ywman char (8),b_date datetime,e_date datetime)asselect , ,from inh inner join dm_gf on = inner join dm_ck on = inner join dm_wz on = where = ywman and in_date = b_dateand in_date = e_dateGOCREATE PROCEDURE inh_setup(in_date datetime,ywman char (20),inh_no char (8),gfdm char (8),ckdm char (6),wzdm char (30),sl numeric (10),in_danj numeric(12, 2),i_zk numeric(5, 0),i_zke numeric(12, 2),jsfk char (2),jz char (2) ,yf numeric (5,0),bz char (100)) ASinsert inh(in_date,ywman,inh_no,gfdm,ckdm,wzdm,sl,in_danj,i_zk,i_zke,jsfk,jz,yf,bz)values(in_date,ywman,inh_no,gfdm,ckdm,wzdm,sl,in_danj,i_zk,i_zke,jsfk,jz,yf,bz)GOCREATE PROCEDURE kh_setup (dm char (8),mc char (40),addr char (40),yzbm char (6), tel char (40),itladd char (50),ywman char (8), char (50),sui_no char (20),bank_no char (20),bank char (30),card_no