文件名称：汽车维修保养管理系统
文件大小：605KB
文件格式：ZIP
更新时间：2013-04-02 04:47:19
汽车管理
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'My_vehicle') DROP DATABASE [My_vehicle] GO CREATE DATABASE [My_vehicle] ON (NAME = N'My_vehicle_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\My_vehicle_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'My_vehicle_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\My_vehicle_Log.LDF' , SIZE = 1, FILEGROWTH = 10%) COLLATE Chinese_PRC_CI_AS GO exec sp_dboption N'My_vehicle', N'autoclose', N'true' GO exec sp_dboption N'My_vehicle', N'bulkcopy', N'false' GO exec sp_dboption N'My_vehicle', N'trunc. log', N'true' GO exec sp_dboption N'My_vehicle', N'torn page detection', N'true' GO exec sp_dboption N'My_vehicle', N'read only', N'false' GO exec sp_dboption N'My_vehicle', N'dbo use', N'false' GO exec sp_dboption N'My_vehicle', N'single', N'false' GO exec sp_dboption N'My_vehicle', N'autoshrink', N'true' GO exec sp_dboption N'My_vehicle', N'ANSI null default', N'false' GO exec sp_dboption N'My_vehicle', N'recursive triggers', N'false' GO exec sp_dboption N'My_vehicle', N'ANSI nulls', N'false' GO exec sp_dboption N'My_vehicle', N'concat null yields null', N'false' GO exec sp_dboption N'My_vehicle', N'cursor close on commit', N'false' GO exec sp_dboption N'My_vehicle', N'default to local cursor', N'false' GO exec sp_dboption N'My_vehicle', N'quoted identifier', N'false' GO exec sp_dboption N'My_vehicle', N'ANSI warnings', N'false' GO exec sp_dboption N'My_vehicle', N'auto create statistics', N'true' GO exec sp_dboption N'My_vehicle', N'auto update statistics', N'true' GO use [My_vehicle] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ck_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ck_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gf_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[gf_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[inh_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[inh_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kh_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[kh_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kucun_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[kucun_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[outh_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[outh_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[wz_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[wz_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ywy_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ywy_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_ck]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_ck] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_gf]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_gf] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_kh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_kh] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_wz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_wz] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_wzlb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_wzlb] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_ywy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_ywy] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_ywylb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_ywylb] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[inh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[inh] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kucun]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[kucun] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[outh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[outh] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[zc] GO CREATE TABLE [dbo].[dm_ck] ( [dm] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_gf] ( [dm] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [yzbm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [itladd] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [email] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [sui_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [bank_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [bank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_kh] ( [dm] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [lbdm] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [yzbm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [itladd] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [email] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [sui_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [bank_no] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [card_no] [char] (13) COLLATE Chinese_PRC_CI_AS NULL , [mb_reb] [numeric](12, 2) NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_wz] ( [dm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [jldw] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [lbdm] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [rkj] [numeric](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] GO CREATE TABLE [dbo].[dm_wzlb] ( [lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [lbcode1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [lb1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO 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] GO CREATE 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] GO CREATE 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 , [qihao] [char] (8) COLLATE Chinese_PRC_CI_AS 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] GO CREATE 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 , [qihao] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [sl] [numeric](10, 0) NOT NULL , [total_je] [numeric](12, 2) NULL ) ON [PRIMARY] GO CREATE 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 , [qihao] [char] (8) COLLATE Chinese_PRC_CI_AS 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] GO CREATE 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 , [qihao] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [sl] [numeric](10, 0) NOT NULL , [total_je] [numeric](12, 2) NULL , [bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE ck_setup ( @dm char (6), @mc char (40), @bz char (255) ) AS insert dm_ck ( dm, mc, bz ) values ( @dm, @mc, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE gf_setup ( @dm char (8), @mc char (40), @addr char (40), @yzbm char (6), @tel char (40), @itladd char (50), @email char (50), @sui_no char (20), @bank_no char (20), @bank char (30), @ywman char(8), @bz char (255) ) AS insert dm_gf ( dm,mc,addr,yzbm,tel,itladd,email,sui_no,bank_no,bank,ywman,bz ) values ( @dm, @mc, @addr, @yzbm, @tel, @itladd, @email, @sui_no, @bank_no, @bank, @ywman, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE inh_setup ( @in_date datetime, @ywman char (20), @inh_no char (8), @gfdm char (8), @ckdm char (6), @wzdm char (30), @qihao char (8), @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) ) AS insert inh ( in_date, ywman, inh_no, gfdm, ckdm, wzdm, qihao, sl, in_danj, i_zk, i_zke, jsfk, jz, yf, bz ) values ( @in_date, @ywman, @inh_no, @gfdm, @ckdm, @wzdm, @qihao, @sl, @in_danj, @i_zk, @i_zke, @jsfk, @jz, @yf, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE kh_setup ( @dm char (8), @mc char (40), @lbdm char(30), @addr char (40), @yzbm char (6), @tel char (40), @itladd char (50), @ywman char (8), @email 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) ) AS insert dm_kh ( dm,mc,lbdm,addr,yzbm,tel,itladd,ywman,email,sui_no,bank_no,bank,card_no,mb_reb,bz ) values ( @dm, @mc, @lbdm, @addr, @yzbm, @tel, @itladd, @ywman, @email, @sui_no, @bank_no, @bank, @card_no, @mb_reb, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE kucun_setup ( @update_date datetime, @kucun_no char (14), @ckdm char (6), @wzdm char (30), @qihao char (8), @sl numeric (10), @total_je numeric(12, 2) ) AS insert kucun ( update_date, kucun_no, ckdm, wzdm, qihao, sl, total_je ) values ( @update_date, @kucun_no, @ckdm, @wzdm, @qihao, @sl, @total_je ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE outh_setup ( @out_date datetime, @ywman char (20), @outh_no char (8), @khdm char (8), @ckdm char (6), @wzdm char (30), @qihao char (8), @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) ) AS insert outh ( out_date, ywman, outh_no, khdm, ckdm, wzdm, qihao, sl, out_danj, o_zk, o_zke, jsfk, jz, yf, bz ) values ( @out_date, @ywman, @outh_no, @khdm, @ckdm, @wzdm, @qihao, @sl, @out_danj, @o_zk, @o_zke, @jsfk, @jz, @yf, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE wz_setup ( @dm char(30), @mc char(40), @jldw char(8), @lbdm char(30), @rkj numeric(12,2), @fxj numeric(12,2), @lsj numeric(12,2), @cj char(20), @yxrq datetime, @bz char(255) ) AS insert dm_wz ( dm,mc,jldw,lbdm,rkj,fxj,lsj,cj,yxrq,bz ) values ( @dm,@mc,@jldw,@lbdm,@rkj,@fxj,@lsj,@cj,@yxrq,@bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE ywy_setup ( @dm char (6), @mc char (20), @lb char (30), @tel char (40), @addr char (40), @sfz char (18), @lbcode char (30), @bz char (255) ) AS insert dm_ywy ( dm, mc, lb, tel, addr, sfz, lbcode, bz ) values ( @dm, @mc, @lb, @tel, @addr, @sfz, @lbcode, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
【文件预览】：
汽车维修保养管理系统
----frmInquireOYWY.frm(7KB)
----frmInquireOZC2.frm(9KB)
----frmLogin.frm(6KB)
----frmPreview.frm(3KB)
----frmKHSetup1.frm(16KB)
----frmInquireGF.frm(7KB)
----My_Vehicle.vbw(3KB)
----Module1.bas(8KB)
----frmInquireOYWY2.frm(10KB)
----frmInquireIZC2.frm(9KB)
----frmWZLB1.frm(7KB)
----frmYWYSetup1.frm(11KB)
----frmGET1.frm(9KB)
----frmDH.frm(10KB)
----frmInquireIOZC2.frm(10KB)
----Form1.frm(6KB)
----frmOUTH.frm(11KB)
----frmZC1.frm(29KB)
----frmInquireCK.frm(7KB)
----frmYWYLB.frm(8KB)
----frmWXLIST.frm(8KB)
----frmWZLBS.frm(6KB)
----frmINH1.frm(32KB)
----frmInquireIOZC.frm(6KB)
----frmInquireOCK2.frm(9KB)
----frmXSDH1.frm(21KB)
----frmWX1.frm(18KB)
----frmInquireOZC.frm(6KB)
----rpt()
--------inquireMINGXI.rpt(21KB)
--------inquireZC.rpt(21KB)
--------Report1.rpt(18KB)
--------inquireINH.rpt(22KB)
--------inquireOCK.rpt(22KB)
----frmYWYSetup.frm(9KB)
----frmWZLB.frm(7KB)
----frmInquireGF2.frm(9KB)
----frmWX.frm(24KB)
----frmInquireOCK.frm(7KB)
----sql()
--------myVehicle.sql(30KB)
----frmCKSetup1.frm(7KB)
----frmOFFER.frm(8KB)
----frmGET.frm(8KB)
----frmGF1.frm(13KB)
----frmXSDH.frm(7KB)
----frmMain.frm(22KB)
----frmInquireOKH.frm(6KB)
----frmInquireMINGXI2.frm(7KB)
----frmInquireIZC.frm(6KB)
----frmInquireYWY2.frm(9KB)
----frmZC.frm(11KB)
----frmInquireMINGXI.frm(6KB)
----frmOFFER1.frm(11KB)
----frmInquireOKH2.frm(11KB)
----frmINH.frm(11KB)
----frmYWYLB1.frm(7KB)
----frmWZSetup1.frm(13KB)
----光盘使用必读_LIU.doc(432KB)
----frmOUTH1.frm(34KB)
----frmCKSetup.frm(9KB)
----frmInquireCK2.frm(9KB)
----frmKHSetup.frm(9KB)
----frmWZSetup.frm(9KB)
----frmMain.frx(11KB)
----frmDH1.frm(21KB)
----My_Vehicle.vbp(2KB)
----frmInquireYWY.frm(7KB)
----frmGF.frm(8KB)