【文章內(nèi)容簡介】 o].[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,@mc@bz)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_zke@bz)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 char (13),@mb_reb numeric (12,2),@bz char (255)) ASinsert dm_kh(dm,mc,addr,yzbm,tel,itladd,ywman,,sui_no,bank_no,bank,card_no,mb_reb,bz)values(@dm,@mc,@addr,@yzbm,@tel,@itladd,@ywman,@,@sui_no,@bank_no,@bank,@card_no,@mb_reb,@bz)GOCREATE PROCEDURE kucun_setup(@update_date datetime,@kucun_no char (14),@ckdm char (6),@wzdm char (30),@sl numeric (10),@total_je numeric(12, 2) ASinsert kucun(update_date,kucun_no,ckdm,wzdm,sl,total_je)values(@update_date,@kucun_no,@ckdm,@wzdm,@sl,@total_je)GOCREATE PROCEDURE outh_setup(@out_date datetime,@ywman char (20),@outh_no char (8),@khdm char (8),@ckdm char (6),@wzdm char (30),@sl numeric (10),@out_danj numeric(12, 2),@o_zk numeric(5, 0),@o_zke numeric(12, 2),@jsfk char (2),@jz char (2) ,@yf numeric (5,0),@bz char (100)) ASinsert outh(out_date,ywman,outh_no,khdm,ckdm,wzdm,sl,out_danj,o_zk,o_z