汽车维护与保养管理系统
5星
- 浏览量: 0
- 大小:None
- 文件类型：ZIP
简介：
汽车维护与保养管理系统是一款专为车主设计的应用程序，它能帮助用户有效地规划和管理车辆的各项维修及保养任务，确保爱车始终保持最佳状态。
IF
```sql
IF EXISTS (SELECT 1 FROM sys.procedures WHERE name = ck_setup)
DROP PROCEDURE ck_setup;
GO
CREATE PROCEDURE ck_setup
(
@dm char(6),
@mc char(40),
@bz char(255)
)
AS
BEGIN
INSERT INTO dm_ck(dm, mc, bz) VALUES (@dm, @mc, @bz);
END;
GO
```
```sql
IF EXISTS (SELECT 1 FROM sys.procedures WHERE name = gf_setup)
DROP PROCEDURE gf_setup;
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
BEGIN
INSERT INTO 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 );
END;
GO
```
```sql
IF EXISTS (SELECT 1 FROM sys.procedures WHERE name = inh_setup)
DROP PROCEDURE inh_setup;
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
BEGIN
INSERT INTO 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);
END;
GO
```
```sql
IF EXISTS (SELECT 1 FROM sys.procedures WHERE name = kh_setup)
DROP PROCEDURE kh_setup;
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
BEGIN
INSERT INTO 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);
END;
GO
```
```sql
IF EXISTS (SELECT 1 FROM sys.procedures WHERE name = kucun_setup)
DROP PROCEDURE kucun_setup;
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
BEGIN
INSERT INTO kucun(update_date,kucun_no,ckdm,wzdm,qihao,sl,total_je) VALUES (@update_date,@kucun_no,@ckdm,@wzdm,@q
全部评论 (0)
