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
该系统分为管理员、客户、保养人员和维修人员四种角色。管理员负责用户、配件、员工信息及财务管理；维修人员处理销售和预约；客户可管理个人资料、预约服务并进行评价。系统提供全面的角色定制化功能，确保高效运营。
扫一扫
849
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
