汽车零部件查询系统设计说明书

汽车配件管理系统项目需求说明书CarManager System第一部分引言 (3)1。

1编写目的 (3)1.2适用范围 (3)1。

3背景 (3)1。

4术语、定义和缩写 (3)1.5文档概述 (3)1。

6参考资料 (4)第二部分任务概述 (4)2.1目标 (4)2.2用户的特点 (5)2。

3假定和约束 (5)第三部分问题分析 (5)3.1技术架构 (5)第四部分需求规定 (6)4.1系统流程图 (6)4。

2对功能的规定 (6)4。

2。

1 对所有授权用户功能的概述 (6)4.2.2系统管理员功能的概述 (10)4。

2.3 仓库管理员的功能概述 (13)4.2.3 仓库管理员的功能概述 (14)新建订购单反馈信息 (16)4.2.3.4新建出库单 (17)4.2。

3。

5查询总表 (18)4。

2。

3。

6 新建零件信息 (19)4。

2。

3.7 更新采购单 (19)4。

2.3.8 新建入库单 (20)4.2.3。

9 打印出库单 (20)4。

2。

4 系统管理员功能的概述 (21)4.2.4。

2新建采购单 (23)4.2.4。

3 更新采购申请的状态为已处理 (24)4。

2.4.4查询处于未处理状态的采购单 (24)4。

2.4。

5 查询处于仓管或经理未同意的采购单 (25)4.2.4。

6 修改采购单 (25)4。

2。

4.7 将采购单的采购建议改为建议已采纳 (26)4。

2。

4。

8 查询已被经理同意的采购单 (27)4.2.4。

9 统计指定时间内各种零件的采购总量 (27)4。

2。

4。

10打印预执行的采购单 (28)4。

2.4.11 定期删除无效的采购单 (28)4。

2。

5 普通销售人员的功能概述 (29)4。

2.6 销售管理人员的功能概述 (37)4。

2.6.1 统计部门指定时间段的零件销售总量 (38)4。

2.7 经理的功能概述 (40)4。

2。

8 人事部管理员的功能概述 (47)4。

2。

5 精度 (51)4.2.6 时间特性要求 (51)4.2.7 灵活性 (52)4.3系统容量 (52)4.4故障处理要求 (52)4.5其它专门要求 (53)4。

特约店管理系统Dealer Management System中国版DMS用户操作手册零部件管理系统版本2.0广汽本田汽车有限公司2009年7月Copyright Guangqi Honda Automobile Co., Ltd.All Rights Reserved目录1系统概述： (15)2零部件销售管理 (17)2.1报价单 (19)2.1.1查询 (20)2.1.2高级查询 (20)2.1.3新增 (20)2.1.4修改 (25)2.1.5删除 (25)2.1.6转入订单 (25)2.1.7打印报价单 (25)2.2订单 (26)2.2.1查询 (27)2.2.2高级查询 (28)2.2.3新增订单 (28)2.2.4修改订单 (29)2.2.5删除订单 (30)2.2.6复制订单 (30)2.2.7计划 (31)2.2.8按批出库 (32)2.2.9按单出库 (34)2.2.10订单返回 (34)2.2.11打印 (35)2.2.12缺货取消 (35)2.2.13存为模板 (36)2.2.14导出明细 (36)2.2.15操作日志 (36)2.3出库 (37)2.3.2高级查询 (38)2.3.3出库 (39)2.3.4导出 (40)2.3.5打印指示单 (40)2.3.6打印发货单 (40)2.4维修退件 (40)2.4.1退件入库 (41)2.4.2关闭 (41)2.5销售退货 (41)2.5.1退货入库 (42)2.5.2导出 (43)2.6应收查询 (43)2.6.1未结算零件查询 (43)2.6.2未结算出库单查询 (45)2.7退货历史 (46)2.7.1退货零件查询 (47)2.7.2退货单查询 (49)3快修管理 (51)3.1快修业务 (51)3.1.1导出 (52)3.1.2领用 (53)3.1.3返还 (54)3.1.4高级查询 (55)3.2快修历史 (55)3.2.1查询 (56)3.2.2打印领用单 (56)3.2.3打印返还单 (56)3.3每日汇总 (56)3.3.2快修出库单 (58)4采购管理 (61)4.1需求分析 (61)4.1.1查询 (62)4.1.2详情 (62)4.1.3计算 (63)4.1.4询价 (67)4.1.5采购 (68)4.1.6作废 (69)4.2询价 (70)4.2.1查询 (71)4.2.2高级查询 (71)4.2.3新增 (71)4.2.4修改 (73)4.2.5复制 (73)4.2.6删除 (74)4.2.7转采购单 (74)4.2.8打印 (74)4.2.9导出明细 (74)4.3采购单 (75)4.3.1查询 (76)4.3.2高级查询 (77)4.3.3新增 (77)4.4火急采购单 (79)4.4.1采购类型选择 (79)4.4.2客户选择 (80)4.4.3后续操作 (81)4.4.4查看火急单客户资料 (81)4.4.6修改 (84)4.4.7复制 (84)4.4.8取消采购 (84)4.4.9采购确认 (84)4.4.10DCS传送 (85)4.4.11打印 (85)4.4.12缺货取消（B/O） (85)4.4.13存为模板 (86)4.4.14采购单导出 (87)4.4.15导出明细 (87)4.4.16操作日志 (87)4.5广本确认 (88)4.5.1查询 (89)4.5.2高级查询 (89)4.5.3导出 (89)4.5.4确认 (89)4.6到货 (89)4.6.1查询 (90)4.6.2高级查询 (91)4.6.3手工到货 (91)4.6.4DCS到货 (97)4.6.5修改 (99)4.6.6删除 (99)4.6.7开箱清点 (99)4.7到货时间录入 (100)4.7.1入库 (101)4.7.2打印开箱清单 (102)4.7.3导出 (102)4.9采购退货 (103)4.9.1查询 (104)4.9.2导出 (104)4.9.3退货出库 (104)4.10采购退货历史 (104)4.10.1采购退货零件查询 (105)4.10.2采购退货单查询 (106)5例外与索赔 (108)5.1例外入库 (108)5.1.1查询 (109)5.1.2高级查询 (109)5.1.3新增入库 (110)5.1.4修改 (113)5.1.5删除 (113)5.1.6入库 (113)5.1.7打印 (113)5.1.8导出 (114)5.2例外出库 (114)5.2.1查询 (115)5.2.2高级查询 (115)5.2.3新增出库 (116)5.2.4修改 (117)5.2.5删除 (117)5.2.6出库 (118)5.2.7打印 (118)5.2.8导出 (118)5.3到货索赔 (118)5.3.1查询 (119)5.3.3新增 (120)5.3.4修改 (123)5.3.5删除 (123)5.3.6查看 (124)5.3.7DCS传送 (124)5.3.8打印 (124)5.3.9导出 (124)5.4品质索赔 (124)5.4.1修改 (126)5.4.2删除 (127)5.4.3查看 (127)5.4.4DCS传送 (127)5.4.5打印 (127)5.4.6导出 (128)5.5到货索赔统计 (128)5.5.1查询 (129)5.5.2导出 (129)5.5.3打印 (129)5.6品质索赔统计 (130)5.6.1查询 (130)5.6.2导出 (131)5.6.3打印 (131)6库存管理 (132)6.1盘点 (132)6.1.1查询 (133)6.1.2盘点指示 (133)6.1.3盘点取消 (136)6.1.4打印指示 (136)6.1.6审核过帐 (138)6.1.7打印误差 (138)6.1.8打印盈亏 (138)6.1.9导出 (138)6.2仓储管理 (139)6.2.1查询 (139)6.2.2导出 (140)6.2.3保存 (140)6.2.4撤消 (140)6.3缺货管理 (140)6.3.1导出 (140)6.3.2生成采购单 (141)6.4库存清单 (141)6.4.1查询 (142)6.4.2导出 (142)6.4.3打印 (143)6.5库存金额 (143)6.5.1查询 (143)6.5.2导出 (144)6.5.3打印 (144)6.6库存警戒 (145)6.6.1查询 (145)6.6.2导出 (146)6.7呆滞管理 (146)6.7.1查询 (147)6.7.2导出 (147)6.7.3打印 (147)6.7.4安全库存清零 (147)6.9临时日结 (148)6.10月结 (149)6.11库存参数 (150)6.11.1季节指数 (150)6.11.2加重指数 (153)6.11.3在库基准参数 (157)7价格管理 (160)7.1价格参数 (160)7.1.1价格带 (160)7.1.2加价系数 (162)7.1.3使用性质 (165)7.2价格设定 (167)7.2.1查询 (168)7.2.2导出 (168)7.2.3变更历史 (168)7.2.4更新销售价 (169)7.2.5修改选中价格 (170)7.2.6修改单个零件价格 (172)8统计报表 (174)8.1入库查询统计 (174)8.1.1查询 (174)8.1.2导出 (175)8.1.3打印 (175)8.2出库查询统计 (177)8.2.1查询 (177)8.2.2导出 (178)8.2.3打印 (178)8.3进销存查询统计 (179)8.3.1查询 (179)8.3.2导出 (180)8.3.3打印 (180)8.4存货分类帐 (181)8.4.1查询 (181)8.4.2导出 (181)8.4.3打印 (182)8.5销售统计 (183)8.5.1查询 (183)8.5.2导出 (184)8.5.3打印 (184)8.6销售明细查询 (185)8.6.1查询 (185)8.6.2导出 (186)8.6.3打印 (186)8.7按使用性质查询 (187)8.7.1查询 (187)8.7.2导出 (188)8.7.3打印 (188)8.8采购查询统计 (189)8.8.1查询 (189)8.8.2导出 (190)8.8.3打印 (190)8.9供货查询统计 (191)8.9.1查询 (191)8.9.2定期采购导出 (192)8.9.3紧急采购导出 (192)8.10外销维修退货统计 (193)8.10.1查询 (193)8.10.2导出 (194)8.10.3打印 (194)8.11采购退货查询统计 (195)8.11.1查询 (195)8.11.2导出 (196)8.11.3打印 (196)8.12零件排行榜 (197)8.12.1查询 (197)8.12.2导出 (198)8.12.3打印 (198)8.13库存报表 (199)8.13.1查询 (199)8.13.2导出 (199)8.13.3打印 (200)8.14价格报表 (201)8.14.1查询 (201)8.14.2导出 (201)8.14.3打印 (202)8.15按月统计报表 (203)8.15.1库存分析明细报表 (204)8.15.2零件服务率 (205)8.15.3零部件退货月报 (206)8.15.4零部件管理月报 (207)8.15.5零部件管理月报（图表） (208)8.15.6销售推移表（含税成本金额） (209)8.15.7销售推移表（销售金额） (210)8.15.9库存度推移表 (212)9资料管理 (213)9.1零件管理 (213)9.1.1查询 (213)9.1.2新增 (214)9.1.3修改 (215)9.1.4查看 (215)9.1.5删除 (215)9.1.6复制 (215)9.1.7口座导入 (215)9.1.8生成拼音码 (218)9.1.9更正错误零件代码 (218)9.2零件模板 (219)9.2.1新增模板 (219)9.2.2修改模板 (220)9.2.3删除模板 (220)9.3客户管理 (221)9.3.1查询 (221)9.3.2新增 (221)9.3.3修改 (222)9.3.4删除 (222)9.4供应商 (223)9.4.1查询 (223)9.4.2新增 (223)9.4.3修改 (224)9.4.4删除 (224)9.5仓库管理 (225)9.5.1新增 (225)9.5.3删除 (226)9.6发货仓库 (226)9.7商品区分 (227)9.7.1新增 (227)9.7.2修改 (228)9.7.3删除 (228)9.8销售代码 (228)9.9例外代码 (228)9.9.1新增 (229)9.9.2修改 (230)9.9.3删除 (230)9.10原因代码 (230)10高级查询 (231)10.1字段过滤 (232)10.2选取显示字段 (232)10.3删除显示字段 (233)10.4选取条件字段 (233)10.5新增查询条件 (233)10.6修改查询条件 (233)10.7删除查询条件 (234)10.8高级查询 (234)10.9读取查询条件集 (235)10.10保存查询条件集 (235)附录二级店新增功能 (237)系统概述 (238)1二级店零件库存调拨 (238)1.1库存调拨主界面 (240)1.3新增 (242)1.3.1选取零件 (244)1.3.2删除 (246)1.3.3零件登录 (246)1.3.4保存 (247)1.3.5申请确认 (248)1.4修改 (248)1.5删除 (249)1.6申请确认 (249)1.7发货确认 (251)1.8开箱清点 (252)1.9收货确认 (253)1.10打印 (254)1.11复制 (255)1.11.1导出明细 (256)1.11.2操作日志 (257)2二级店零件领用业务 (257)2.1待处理零件 (260)2.2领用 (261)2.3返还 (263)2.4领用返还历史 (264)2.4.1领用单历史 (264)2.4.2返还单历史 (266)3二级店仓位管理 (267)3.1二级店仓位管理修改零件仓位 (267)4二级店库存清单（查询二级店的调拨结存） (268)5二级店缺货管理 (271)6零件管理 (273)1系统概述：广州本田中国版DMS零部件子系统主要管理特约店零部件管理部门的零件销售、零件采购、零件仓库管理等日常业务，分为销售管理、采购管理、库存管理、例外管理、资料管理、报表查询统计等六部分。

汽车配件系统汽车配件系统数据库详细设计说明页8共页1第v1.0汽配汽车配件系统文档属性及版本页8共页2第v1.0汽配汽车配件系统录目.............................................................4.数据库设计的基本规范1 4................................................................................................................................................1.1开发规范................................................................................................................................................41.2命名规范...................................................................42.基本表及其说明用户表 2.14t_user.....................................................................................................................................4t_type.................................................................................................................................2.2商家分类表商家信息表 2.3t_bussiness (5)客户信息表t_customer..........................................................................................................................52.4 ...................................................................................................................................62.5关于我们t_about t_explain.............................................................................................................................62.6软件说明表 6...................................................................................................................2.7意见管理t_leave_message信息推送表 2.8 6.........................................................................................................t_push_message62.9广告管理t_ads.......................................................................................................................................7会员表t_user_info...............................................................................................................................2.107t_collection.............................................................................................................................2.11收藏表存储过程的使用.....................................................................73. ................................................................................84.总结.........................................................8数据库中总共用到11张基本表。

保修及保养手册重要信息 (1)包修部分 (3)整车质量担保 (3)易损件质量担保 (6)保养部分 (8)保养目的 (8)保养计划 (9)车辆常规保养检修记录 (17)车辆非常规保养检修记录 (31)安全带预张紧器、安全气囊更换记录 (35)用户变更记录 (37)附件：上汽集团授权售后服务中心名单 (39)重要信息对您的建议我们建议您前往上汽集团授权售后服务中心保养和维修您的车辆。

因为只有上汽集团授权售后服务中心最了解您的汽车，并且在这里您可以得到上汽集团纯正的零部件和专业的技术。

我们的质量担保(车辆包修)也只有在上汽集团授权售后服务中心才能实现。

车辆的使用和注意事项我们的汽车使用了很多最先进的技术，因此请您在使用车辆前务必认真阅读《用户手册》，并遵从本手册和《用户手册》的要求进行保养和包修。

如果您对于如何使用、保养和包修本车存有疑问，请询问上汽集团授权售后服务中心。

请使用符合上汽集团技术规范和质量标准要求并适用本车的附件、零部件和车用油液，并按正确的操作程序保养和维修您的车辆，详情可咨询当地授权售后服务中心。

并请您尊重知识产权，使用正版的附件、零部件等，如果使用了侵犯知识产权的附件、零部件等，您将有可能承担相应的法律风险和法律后果。

免费更换发动机机油和机油滤清器服务上汽集团授权售后服务中心将为您提供一次免费的发动机机油和机油滤清器的更换服务，免费服务将包括材料和工时费用，免费服务的有效期同整车的包修期，免费更换服务只在上汽集团授权售后服务中心进行。

保养检修记录本手册中有两种保养检修记录表，分别记录“常规保养”和“非常规保养”的保养检修情况。

请务必保留保养检修记录表，它将为您和上汽集团授权售后服务中心提供分析失效原因的依据。

包修部分整车质量担保上汽集团将根据以下条款、条件和限制对整车提供包修服务。

除中国法律的强制性规定外，本手册规定了上汽集团对用户承担的包修责任。

■包修期上汽集团为新车提供了3年或10万公里（两者以先到达者为准）的包修期。

CONTINUEDBatteryCharging System...........................Indicator . 56, 260............................Jump Starting .256..............................Maintenance .244....................Specifications . 275, 277..............................Before Driving .159....................................Belts,Seat .8,17...........................Beverage Holders .96..................................Booster Seats .46Brakes...........Anti-lock System (ABS).185.............Break-in,New Linings .160....................Bulb Replacement .232...........................................Fluid .225.........................................Parking .94..........................System Design .184.................System Indicator . 57, 262........................Wear Indicators .184.............................Braking System .184.................Break-in,New Vehicle .160..Brightness Control,Instruments .70........................Brights,Headlights .68Bulb Replacement..........................Back-up Lights .232..............................Brake Lights .232................Front Parking Lights .231.................................Headlights .228.........High-mount Brake Light .233....................Specifications . 275, 277....................Turn Signal Lights .231..............................Bulbs,Halogen .228....................................Accessories .167ACCESSORY (Ignition Key.......................................Position).75..............Accessory Power Sockets .99................Adding Engine Coolant .217Additional Information About Your .........................................Airbags .20....................Additives,Engine Oil .214.......Adjusting the Steering Wheel .72...........................Advanced Airbags .24.........Advice for Pregnant Women .15...............................Airbag (SRS) . 9, 20..............Air Conditioning System age . 109, 111...............Air Pressure, Tires . 238, 239.......................Alcohol in Gasoline .160All Children Should Sit in a.....................................Back Seat .32......................................Antifreeze .217Anti-lock Brakes (ABS)...............................Indicator . 58, 185...................................Operation .185..............Anti-theft,Audio System .149.Anti-theft Steering Column Lock .75............................................Armrest .84................................Audio System .116...Automatic Lighting Off Feature .69...Automatic Seat Belt Tensioners .18..........Automatic Climate Control .111.............Automatic Speed Control .152..............Automatic Transmission .179..................Capacity, Fluid . 274, 276.......Checking Fluid Level . 221, 222.......................................Shifting .179Shift Lever Position...............................Indicators .179................Shift Lever Positions .180....................Shift Lock Release .182ABI...................Capacities Chart . 274, 276.............Carbon Monoxide Hazard .49....................Cargo,How to Carry .169......................................Cargo Net .172.............................Carrying Cargo .169..............CAUTION,Explanation of .ii .........................................CD Care .138....................................CD Changer .133......CD Changer Error Messages .140.......................................CD Player .130.........CD Player Error Messages .139...........................Center CD Pocket .97........................Certification Label .272.................................Chains,Tires .243....................Changing a Flat Tire .249Changing Oil........................................How to .214.............................When to . 201, 206...Charging System Indicator . 56, 260..............Check Fuel Cap Indicator .65............Checklist,Before Driving .174.....................................Child Safety .31..............................Booster Seats .46.............................Child Seats . 31, 38Important Safety.........................Reminders . 31, 36..........................................Infants rger Children TCH .40......................Risks with Airbags .32.............................Small Children .37.........................................Tethers .44.........Where Should a Child Sit?.32.......................................Child Seats .38......................................Installing TCH .40......................................Selecting .38................Tether Anchor Points .44Cleaning...................................Seat Belts .234...............Climate Control System .111..............................................Clock .150...................................Clutch Fluid .226........................CO in the Exhaust .281.....................................Coin Pocket .98............Cold Weather,Starting in pact Spare Tire .248...................Console Compartment .97.................Consumer Information .286.............Controls,Instruments and .53Coolant........................................Adding .217....................................Checking .165.........................Proper Solution .217...................Temperature Gauge .65Crankcase Emissions Control........................................System .281................Cruise Control Indicator .61............Cruise Control Operation .152....................Cruise Main Indicator .61.....................................Cup Holders .96....Customer Service Information .286................DANGER,Explanation of .ii ...................................Dashboard . 3, 54............Daytime Running Lights .69Daytime Running Lights...................................Indicator .61.................................Dead Battery .256............Defects,Reporting Safety .288................Defogger,Rear Window .71Defrosting the....................................Windows .110............................Dimensions . 274, 276DCIICONTINUED..............................Economy,Fuel .166..................................Emergencies .247.............Battery,Jump Starting .256...........Brake System Indicator .262................Changing a Flat Tire .249.....Charging System Indicator .260..................Checking the Fuses .264.........Hazard Warning Flashers .70............................Jump Starting .256.....Low Oil Pressure Indicator .260...Malfunction Indicator Lamp .261...Manually Closing Moonroof .263..................Overheated Engine .258.......................................Towing .269...........................Emergency Brake .94......................Emergency Flashers .70......................Emergency Towing .269............Emergency Trunk Opener .80.......................Emissions Controls .281.............Emissions Testing,State .284Engine............Adding Engine Coolant .217....................................Additives .214.....Changing the Oil and Filter .214....Coolant Temperature Gauge .65.........................If It Won’t Start .254Malfunction Indicatormp .261........Oil Pressure Indicator . 56, 260.............................Oil,Synthetic .214..............Oil,What Kind to Use .213...............................Overheating .258....................Specifications . 275, 277....................Speed Limiter . 178, 181.......................................Starting .175..........Engine Speed Limiter . 178, 181......................Ethanol in Gasoline .160.Evaporative Emissions Controls .281...............................Exhaust Fumes .49Expectant Mothers,Use of Seat........................................Belts by .15.........Dimming the Headlights . 68, 69Dipstick.Automatic Transmission . 221, 222..................................Engine Oil .164..........................Directional Signals .68........Disc Brake Wear Indicators .184.....................Disposal of Used Oil .216Doors..............Locking and Unlocking .76......................Power Door Locks .76........DOT Tire Quality Grading .278Downshifting,Manual.............................Transmission .176...........Driver and Passenger Safety .5...........................................Driving .173....................................Economy .166..........Dual Temperature Control .113..................Dust and Pollen Filter .235....................................Fan Control .106.........................................Features .103....................Filling the Fuel Tank .161Filters.........................Dust and Pollen .235...............................................Oil .214.............Flashers,Hazard Warning .70...................Flat Tire,Changing a .249Fluids.Automatic Transmission . 221, 222..........................................Brake .225.........................................Clutch .226EFIII............... Gas Mileage,Improving.166 .......................................... Gasohol.160.........................................Gasoline.160...........................................Gauge.65.....................Low Fuel Indicator.60................Octane Requirement.160........................Tank,Refueling.161................Gas Station Procedures.161Gauges...Engine Coolant Temperature.65...............................................Fuel.65Gearshift Lever Positions..........Automatic Transmission.179..............Manual Transmission.176........................................Glove Box.96Gross Axle Weight Rating.....................................(GAWR).191Gross Vehicle Weight Rating.....................................(GVWR).191...Identification Number,Vehicle.272..............If the Engine Overheats.258.............If the Engine Won’t Start.254Ignition..............................................Keys.73...........................................Switch.75............Timing Control System.282........................Immobilizer System.74..............Manual Transmission.223..........................Power Steering.226..................Windshield Washer.220...........................Folding Rear Seat.87..........................Four-way Flashers.70........................Front Airbags . 9, 20,22..................................Front Seat . 81,83................................Adjusting . 81,83.........................................Heaters.88.....................................Airbags.9,22.................................................Fuel.160..........Check Fuel Cap Indicator.65......................Fill Door and Cap.161...........................................Gauge.65.....................Low Fuel Indicator.60................Octane Requirement.160...............................Oxygenated.160........................Tank,Refueling.161...............................Fuel Economy.166..............................Fuse Locations.267.....................Fuses,Checking the.264.............Halogen Headlight Bulbs.228..............Hazard Warning Flashers.70........................................Headlights.68........................................Aiming.228..............Automatic Lighting Off.69.......Daytime Running Lights.69.................. High Beam Indicator.61.................... Lights On Indicator.60............ Low Beams,Turning on.68......................... Reminder Chime.68........ Replacing Halogen Bulbs.228................................... Turning on.68.............................. Head Restraints.86..................... Heating and Cooling.104........................... Heated Mirrors.94..................................... Heater,Seat.88............. High Altitude,Starting at.175 HomeLink Universal................................ Transceiver.155.. Hood,Opening and Closing the.162........................... Hydraulic Clutch.226G HIIVCONTINUED.................Jacking up the Vehicle .251.......................................Jack,Tire .250................................Jump Starting .256..................................................Keys .73bel,Certification ne Change,Signaling p/Shoulder Belts . 14, TCH Anchorage System .40..Lighting Off Feature,Automatic .69Lights....................Bulb Replacement .228.......................................Indicator .55.........................................Parking .68..................................Turn Signal .68....................................Load Limits .170......LOCK (Ignition Key Position).75Locks.......Anti-theft Steering Column .75............................Fuel Fill Door .161....................................Glove Box .96.................................Power Door .76...........................................Trunk .80................Low Coolant Level . 165, 217.........................Low Fuel Indicator .60...Low Oil Pressure Indicator . 56, 260................................Lower Anchors .40.........Important Safety Precautions .6.........................................Indicators .55.......ABS (Anti-lock Brake) . 58, 185Brake (Parking and Brake ............................System) . 57, 262................Charging System . 56, 260...........................Check Fuel Cap .65.............................Cruise Control .61................Door and Trunk Open .59DRL (Daytime Running ......................................Lights).61...................................High Beam .61........Key (Immobilizer System).59.....................................Lights On .60......................................Low Fuel .60................Low Oil Pressure . 56, 260....................Malfunction Lamp .261.................Passenger Airbag Off .28..........................Security System .60...........................Side Airbag Off .57...............................................SRS .57TCS (Traction Control.............................System) .58, 187Turn Signal and Hazard...................................Warning .59..........................Washer Level .61.........Indicators,Instrument Panel .56...............................Infant Restraint .36................................Infant Seats . 36, 38......................................Installing .39................Tether Anchor Points .44...................Inflation,Proper Tire .238........Recommended Pressures .239...................................Inside Mirror .93.............................Inspection,Tire .240....................Installing a Child Seat .39............................Instrument Panel .55........Instrument Panel Brightness .70..............Instruments and Controls .53...............................Interior Lights .100........................................Introduction .iLJKV。

汽车配件系统数据库详细设计说明文档属性及版本目录1.数据库设计的基本规范 (4)1.1开发规范 (4)1.2命名规范 (4)2.基本表及其说明 (4)2.1用户表t_user (4)2.2商家分类表t_type (4)2.3商家信息表 t_bussiness (5)2.4客户信息表t_customer (5)2.5关于我们t_about (6)2.6软件说明表t_explain (6)2.7意见管理t_leave_message (6)2.8信息推送表 t_push_message (6)2.9广告管理t_ads (6)2.10会员表t_user_info (7)2.11 收藏表t_collection (7)3. 存储过程的使用 (7)4.总结 (8)数据库中总共用到11张基本表。

(8)1.数据库设计的基本规范1.1开发规范1）遵守数据的设计规范3NF 规定2）一行记录必须表内唯一，表必须有主键。

3）金额类型使用Money4）时间使用Time5）在主外键的选择上应注意：为关联字段创建外键、所有的键都必须唯一、避免使用复合键、外键总是关联唯一的键字段。

1.2命名规范1）对象名称应当准确完整地描述了对象的含义。

2）数据库对象的命名应当避免和系统原有的对象名称（如：系统表、系统存储过程等）混淆。

3）对象名称中不同的单词间应当能够方便的区分开。

4）使用Pascal 命名规则2.基本表及其说明2.1用户表t_user2.2商家分类表t_type2.3商家信息表 t_bussiness2.4客户信息表t_customer2.5关于我们t_about2.6软件说明表t_explain2.7意见管理t_leave_message2.8信息推送表 t_push_message2.9广告管理t_ads2.10会员表t_user_info2.11 收藏表t_collection3. 存储过程的使用4.总结数据库中总共用到11张基本表。

交通与汽车工程学院课程设计说明书课程名称: 计算机应用根底课程设计课程代码: 6011339题目: 汽车零部件查询系统设计年级/专业/班:学生姓名:学号:开始时间:2021 年 4 月 1 日完成时间:2021 年 4 月12 日课程设计成绩：学习态度及平时成绩〔30〕技术水平与实际能力〔20〕创新〔5〕说明书〔计算书、图纸、分析报告〕撰写质量〔45〕总分〔100〕指导教师签名：年月日目录摘要 (2)1 引言 (3)2 本程序主要功能 (3)3 本程序结构设计 (4)4 程序设计界面 (4)5 程序代码 (10)结论 (30)致谢 (31)参考文献 (32)摘要随着计算机的普及程序的应用也越来越受到重视，本次课程设计使用Visual Basic 作为开发工具，进行了汽车零部件查询系统设计的程序设计，本系统主要完成对汽车零部件的管理，包括库存的添加、删除等。

系统可以完成对各类信息的追加、浏览、修改、查询和计算等功能。

汽车零部件查询系统广泛应用于4S店汽车零部件的库存与销售管理工作中，要求其具有实用性强、使用方便、效率高和平安可靠等特点。

本管理系统正是围绕以上几个方面进行开发的，在开发过程中充分考虑到本系统的应用特点，并进行了大量的检验，证明其确实到达了设计的要求，是一个已具备了实际应用能力的软件。

关键词：汽车零部件销售库存销售1 引言1.1 问题的提出为适合现代企业开展的需要,汽车零部件管理已经成为困扰销售的一个难题,由于其费时和繁琐性，企业迫切需要一种专门为零部件管理而效劳的工具。

为此,简单的汽车零部件管理系统为此而制造出来。

本简单程序是为汽车零部件管理而设计的,内容简单，使用方便。

程序稍加变更可以适合对资源分配方面的杂事加以处理。

作为当代大学生，熟练的操作计算机是一种必备的素质。

本次设计会让我们更加熟悉VB编程，把以前学过的一些东西又重新复习了一遍，并与实际结合起来，对我们能力的提升有了很大的帮助，还能促使我们在以后的实际应用中更好的应用VB编程来设计一些数据库管理系统。

交通与汽车工程学院课程设计说明书课程名称: 计算机应用根底课程设计课程代码: 6011339 题目: 汽车零部件查询系统设计年级/专业/班: 学生姓名: 学号:开始时间: 2021 年 4 月 1 日完成时间: 2021 年 4 月 12 日课程设计成绩：学习态度及平时成绩〔30〕技术水平与实际能力〔20〕创新〔5〕说明书〔计算书、图纸、分析报告〕撰写质量〔45〕总分〔100〕指导教师签名：年月日目录摘要 (1)1 引言…………………………………………………………………………………………2 方案设计 (5)系统功能描述 (5)系统结构分析 (5)系统流程分析 (5) (6)系统工程设计框架 (6)系统各界面设计及代码设计 (8)3 结果分析 (33)结论 (45)致谢 (46)参考文献 (47)摘要随着计算机的普及,计算机高级语言已经运用到生活中的各个方面，本次课程设计使用VB语言作为开发工具，进行了汽车零部件查询系统的程序设计，该程序能实现汽车零部件查询模拟功能，进行汽车零部件的查询，修改，添加等操作，查询结果简便明了，运行界面清晰实用，操作方便，易于实际处理。

关键词：网络化计算机对策 VB语言汽车零部件查询程序1 引言1.1 问题的提出随着计算机的普及，网络进入群众的家庭。

VB一种可视化的、面向对象和采用事件驱动方式的高级程序设计语言，可用于开发Windows环境下的各类应用程序。

本次课程设计主要内容就是使用VB编制简单、实用的小程序，以稳固我们所学的计算机VB语言知识，提高分析问题和解决问题的能力，锻炼我们独立动手的能力。

1.2任务与分析本课题主要的目的是为了检测步进电机步距角误差，并把误差进行分析计算，最终得到一份误差数据，用误差曲线的方式在坐标上面把误差和步数结果表现出来，方便日后对误差的分析、误差的减少讨论出相应的方案…2 设计方案首先根据题目要求设计合理界面，确定哪些控件会用到，要考虑到操作的方便性和美观性。

CONTINUEDAccessories.................................Installation .105...............Accessory Power Socket .70ACCESSORY (Ignition Key.......................................Position).53....................Additives,Engine Oil .130...............................Airbag (SRS).9,18..............................Air Conditioning .74.......................Air Pressure,Tires .146.............................Alarm,Anti-theft .53......................................Antifreeze .132Anti-lock Brakes (ABS)....................Indicator Light .41,118...................................Operation .117.Anti-theft Steering Column Lock .53............................Anti-theft System .94......................................Audio Panel .71..................................Audio System .78...............Automatic Speed Control .95............................Capacities Chart .180.............Carbon Monoxide Hazard .34........................Cargo,.107..............CAUTION,Explanation of .ii ...........................................CD Care .85........................CD Error Messages .86.....................................CD Changer .84.......CD Changer Error Messages .87.........................................CD Player .83........................Certification Label .178...................................Chains,.150Changing Oil........................................How to .130......................................When to .121....................Changing a Flat Tire .155...Charging System Indicator .40,166............Checklist,Before Driving .112........Back-up Light Replacement .141BatteryCharging System...........................Indicator .40,166............................Jump Starting .162..............................Maintenance .151............................Specifications .181................................Before Driving .99....................................Belts,Seat . 8 ,15.............................Beverage Holder .70..................................Booster Seats .31............................................Brakes .116...........Anti-lock System (ABS).117.............Break-in,New Linings .100...........................................Fluid .136.........................................Parking .67.................System Indicator .40,168..............Wear Indicators,Disc .117.............................Braking System .116.................Break-in,New Vehicle .100..Brightness Control,Instruments .49........................Brights,Headlights .48.........................Bulb Replacement .137..........................Back-up Lights .141.................................Headlights .137...........Side Turn Signal Lights .139............................Specifications .181............Turn Signal Lights .139,141..............................Bulbs, Halogen . 137how to carry tires IndexBACI..............................Economy,Fuel .104............Emergencies on the Road .153.............Battery,Jump Starting .162................Changing a Flat Tire .155.....Charging System Indicator .166..................Checking the Fuses .170.........Hazard Warning Flashers .49.....Low Oil Pressure Indicator .166...Malfunction Indicator Lamp .167..................Overheated Engine .163...........................Emergency Brake .67......................Emergency Flashers .49............Emergency Trunk Opener .55.......................Emissions Controls .185.....................................Child Safety .22..............................Booster Seats .31...................................Child Seats .26.....Important Safety Reminders rger Children .30......................Risk With Airbags .23.............................Small Children .26.......................................Child Seats .26Cleaning.................................Floor Mats .143...................................Seat Belts .143...................................Clutch Fluid .136........................CO in the Exhaust pact .154.............Controls,Instruments and .70..............................Convertible Top .61...............Convertible Top Cover .63..Lowering the Convertible Top .61................................Maintenance .65.....Raising the Convertible Top .64Coolant........................................Adding .132....................................Checking .103.........................Proper Solution .132...................Temperature Gauge .45Crankcase Emission Control........................................System .185..............Cruise Control Operation .95................Cruise Control Indicator .42......................................Cup Holder .70Customer Relationsrmation .192................DANGER,Explanation of .ii .......................................Dashboard .38................Daytime Running Lights .48Daytime Running Lights.......................................Indicator .42.................................Dead Battery .162............Defects,Reporting Safety .194................Defrosting the Windows .77....................................Dimensions .180...............Dimming the Headlights .48Dipstick..................................Engine Oil .103..........................Directional Signals .48........Disc Brake Wear Indicators .117.....................Disposal of Used Oil .132...................Do Not Tow a Trailer .118Doors..............Locking and Unlocking .54..............................Monitor Light .41......................Power Door Locks .54..........DOT Tire Quality Grading .182Downshifting,6-speed Manual.............................Transmission .114...........................................Driving .111....................................Economy .104spare tire IndexDEIICONTINUED.............Halogen Headlight Bulbs .137..............Hazard Warning Flashers .49Headlights............Daytime Running Lights .48..................High Beam Indicator .42...........................Reminder Tone .48........Replacing Halogen Bulbs .137...................................Turning on .48.........Heating and Cooling System .74.................High-Low Beam Switch .48................High Speed,Shifting at .115.............Emissions Testing,State .188Engine.......................................Coolant .132....Coolant Temperature Gauge .45Malfunction Indicatormp .41,167........Oil Pressure Indicator .40,166..............Oil,What Kind to Use .129...............................Overheating .163............................Specifications .180............................Speed Limiter .115.......................................Starting .113...................Engine,.160......................Ethanol in Gasoline .100...Evaporative Emission Controls .185...............................Exhaust Fumes .34Expectant Mothers,Use of Seat........................................Belts by .14.....................................Fan,Interior .75Features,Comfort and................................Convenience .73....................Filling the Fuel Tank .101Filters...............................................Oil .130.............Flashers,Hazard Warning .49...................Flat Tire,Changing a .155Fluids..........................................Brake .136.........................................Clutch .136..............Manual Transmission .134..................Windshield Washer .134..........FM Stereo Radio Reception .81..........................Four-way Flashers .49.................................................Fuel .100......................Fill Door and Cap .101...........................................Gauge .45................Octane Requirement .100........................Reserve Indicator .42........................Tank,Filling the .101..............Fuel Mileage,Improving .104..............Fuel Station Procedures .101.....................Fuses,Checking the .170.........................................Gasoline .100...............Fuel Reserve Indicator .42...........................................Gauge .45................Octane Requirement .100........................Tank,Filling the .101.............................................Gauges .44...Engine Coolant Temperature .45...............................................Fuel .45...............................Speedometer .44.................................Tachometer .44Gearshift Lever Positions 6-speed Manual.........................Transmission .114if it won’t start IndexFGHIII.................................... Hood Latch.135.......................Hood,Opening the.102...........................Hydraulic Clutch.136................Jacking Up the Vehicle.156.......................................Jack,Tire.155................................Jump Starting.162..................................................Keys.51......................... Label,Certification.78................. Lane Change,Signaling.48..................Lap/Shoulder Belts.12,15 Lights.................... Bulb Replacement.137....................................... Indicator.40.................................. Turn Signal.48..................................... Load Limit.108............................... Loading Cargo.107...... LOCK(Ignition Key Position).53 Locks....... Anti-theft Steering Column.53............................ Fuel Fill Door.101................................. Power Door.54 ........................................... Trunk.54........................ Low Coolant Level.103... Lower Gear,Downshifting to a.114......................... Low Fuel Indicator.42...Low Oil Pressure Indicator.40,166... Lubricant Specifications Chart.180............... Luggage,.107Identification Number,....................................... Vehicle.178 Ignition.............................................. Keys.51 ........................................... Switch.53............ Timing Control System.186 Indicator Lights,Instrument.........................................Panel.40.............. ABS(Anti-Lock Brake).41 Brake(Parking and Brake....................................System).40........................ Charging System.40............................. Cruise Control.42.................................... Door-open.41 DRL(Daytime Running......................................Lights).42 EPS(Electrical Power..................................Steering).41................................... High Beam.42........ Key(Immobilizer System).42......................................Low Fuel.42........................Low Oil Pressure.40...............Maintenance Required.43.......................................Seat Belt.40...............................................SRS.41..................................Trunk-open.41Turn Signal and Hazard...................................Warning.42...................Inflation,Proper Tire.146...................................Inside Mirror.66.............................Inspection,Tire.147............................Instrument Panel.39........Instrument Panel Brightness.49.................................Interior Lights.68........................................Introduction.istoring(cargo)IndexIJK LIVCONTINUED..............Panel Brightness Control .49.................................Parking Brake .67.................................Parking Lights .48.............................PGM-FI System .186Power..................................Door Locks .54..............Engine,Specifications .180.........................................Mirrors .66......................................Windows .59..........................Power Door Locks .54..................Power Socket Location .70..............................Power Windows .59.........Pregnancy,Using Seat Belts .14.........Protecting Adults and Teens .10...Additional Safety Precautions .15.....Advice for Pregnant Women .14........................Protecting Children .22.....................General Guidelines .22.......Protecting Larger Children .30.........Protecting Small Children .26..................................Maintenance .119Owner’s Maintenance...................................Checks .122........................................Record .125....................................Schedule .121..Maintenance Required Indicator .43.Malfunction Indicator Lamp .41,167...................Manual Transmission .114........Manual Transmission Fluid .134...............................Meters,Gauges .44..........................Mirrors,Adjusting .66...............Modifying Your Vehicle .106..................New Vehicle Break-in .100.....................Normal Shift Speeds .115..................NOTICE,Explanation of .ii ...............Numbers,Identification .178...Octane Requirement,Gasoline .100.........................................Odometer .44...............................Odometer,Trip .44Oil........................Change,How to .130......................Change,When to .121......................Checking Engine .103..............Pressure Indicator .40,166Selecting Proper Viscosity......................................Chart .130...........ON (Ignition Key Position).53.........................Opening the Trunk .54..............................Outside Mirrors .66....................Overheating,Engine .163...................Radiator Overheating .163.......................Radio Sound System .78...................Readiness Codes .167,188..Rear Lights,Bulb Replacement .141............................Rear View Mirror .66................Reclining the Seat-backs .58.......Recommended Shift Speeds .115Recovery Vehicle,Emergency.......................................Towing .176.............................Reminder Lights .40.......................Remote Transmitter .56IndexMNOPRVReplacement Information................ Engine Oil and Filter.130 .......................................... Fuses.170................................ Light Bulbs.137.................................... Schedule.121 ........................................... Tires.148............................. Wiper Blades.144 Replacing Seat Belts After a............................................ Crash.17............................... Restraint,Child.22................................ Rotation,Tire.148........................................ Safety Belts.8............ Safety Defects,Reporting.194............. Safety Labels,Location of.35............................... Safety Messages.ii.................................. Satellite Radio.88........................................... Seat Belts.8............... Additional Information.15..... Advice for Pregnant Women.14..................................... Cleaning.143...................... Lap/Shoulder Belt.16................................ Maintenance.17...... Reminder Light and Beeper.40...................System Components.15...............Use During Pregnancy.14........................Seats,Adjusting the.58...............................Serial Number.178...........................Service Intervals.121.............................Service Manual.195.........Service Station Procedures.101ShiftingThe6-speed Manual.........................Transmission.114Side Turn Signal,Bulb.........................Replacement in.140...............................Signaling Turns.486-speed Manual Transmission...............Checking Fluid Level.134................................Shifting the.114.....................................Snow Tires.149..................................Sound System.78Spare Tire......................................Inflating.154............................Specifications.181....................Specifications Charts.180..................................Speed Control.95...................................Speedometer.44..........SRS,Additional Information.18...Additional Safety Precautions.21....................Airbag Components.18.............................Airbag Service.21How the SRS Indicator.......................................Works.20...........How Your Airbags Work.18..................SRS Indicator Light.20,41.......................Starting the Engine.113................With a Dead Battery.162..............State Emissions Testing.188........Steam Coming from Engine.163Steering Wheel.............Anti-theft Column Lock.53.....................Stereo Sound System.78....................Storing Your Vehicle.152................................Stuck Vehicle.174Supplemental Restraint System......................................Servicing.21.........................SRS Indicator.20,41...............Tensioners,Seat Belts.16.....................................Tachometer.44......Taillights,Changing Bulbs in.141.Taking Care of the Unexpected.153IndexSTVICONTINUEDTechnical Descriptions......DOT Tire Quality Grading .182.....Emissions Control Systems .185Three Way Catalytic...............................Converter .187.......................Temperature Gauge .45...................Tensioners,Seat Belts .16..Three Way Catalytic Converter .187....................................Tire Chains .150.........Tire,How to Change a Flat .155.................................Tire Labeling .184...............................................Tires .145..............................Air Pressure .146...................................Balancing .148.........................Checking Wear pact Spare Tire .154......DOT Tire Quality Grading .182......................................Inflation .146..................................Inspection .147...................................Replacing .148......................................Rotating .148...........................................Snow .149............................Specifications .181...................Tools,Tire Changing .155Towing......................A Trailer,Do Not .118................Emergency Wrecker .176..................Trailer,Do Not Tow a .118TransmissionChecking Fluid Level,6-speed..........Manual Transmission .134...........................Fluid Selection .134..............Identification Number .178Shifting the 6-speed Manual.........................Transmission .114.....................................Treadwear .182.......................................Trip Meter .44................................................Trunk .54........Emergency Trunk Opener .55.................................Opening the .54...................Open Monitor Light .41....................................Turn Signals .48Unexpected,Taking Care..........................................of the .153....Uniform Tire Quality Grading .182........................Unleaded Gasoline ed Oil,How to Dispose of .132......................Vehicle Dimensions .180....Vehicle Identification Number .178.............................Vehicle Storage .152.................................................VIN .178..................................Viscosity,Oil .130.............WARNING,Explanation of .i i .........Warning Labels,Location of .35....................Warranty Coverages .193Washer,Windshield........Checking the Fluid Level .134.....................................Operation .47...........................................Wheels .149............Alignment and Balance .148......................................Wrench .155....Windows,Operating the Power .59Windshield.....................................Defroster .77.......................................Washers .47IndexUVWVIIWipers,Windshield.......................Changing Blades . 144.....................................Operation .47....................................Worn Tires .148.....Wrecker,Emergency Towing .176..........................XM Satellite Radio .88IndexXVIIIIX。

GLOBAL PARTSLOOKUPUSER GUIDERev.00Connecting to global parts lookupLaunch your internet browser and connect to https:///en/engines then select Partners tab.NOTE: Guest Login available under Service&Parts, Global Parts LookupEnter your username and password in the proper boxes under the Partner TabLogin Credentials located in the upper right hand cornerReturn to the Partners home page by clicking on the KOHLER logo located in the upper left hand Click on “ORDER FULLFILLMENT PROCESS” sectionUnder SERVICE PARTS, click on “Global Parts Lookup”Now you have access to the GLOBAL PARTS LOOKUPGlobal Parts Lookup User Interface1.Gasoline Documents:Container of documents related to Gasoline products. By default, the list option is usedClick on to view the contents in grid or click on to view the contents in listSearch for a document by typing keywords into “Find” box and hit search icon2.Diesel Documents:This is a link to I-Service portal which is a container of documents related to Diesel products3.My cart:View the list of components added to the cart. You can change the component quantity or remove the component.Note: You can download a *.csv file (similar to an Excel file) to create an order and send it to servicenetwork. (Diesel only)4.Searching Options:“Search for Engine” there are 4 search options: (serial number, spec number, model, or OEM): Enter a serial numberExamples of engine labels where to find the engine serial numberEnter a specification and/or Engine Model and/or OEM (only for gasoline products)Examples of engine labels where to find the engine specification or engine modelNOTE: OEM search only available for Gasoline products“Search for Part” it is possible to enter a Part Number or Part Description. In addition, you can search by Engine type (diesel/gas/marine/generator) and/or model and/or OEM (gas only).5. InstructionsYou can view or download this Global Parts Lookup user guideUsing Global Parts LookupSearching Features:Enter a serial number and click on “Search”or enter a specification, click on one in the list and click on “Search”or enter an engine model, click on one in the list and click on “Search”in the next page a list of engine specifications will appear, choose one in the list and the catalog will open. or search by model and OEM (Gasoline only), engine sold to selected OEM will showSpecification AttributesAttributes of the engine you are searching on•the serial number you have entered if search by serial number was used •the engine specification•the engine description (engine model)•Engine Power•Engine Speed•Status (Active = the engine is currently valid for production)•OEM (gas engines)•Governor spring hole location (gas engines)•Emission code (gas engines)Diesel Attributes:Gas AttributesDocuments for Engine SpecificationDocuments tied to the engine you are searching for would be found under Specification attributes Catalog Exporting:Click on the Excel icon to export the entire catalog as an Excel file.Click on the PDF icon to export the entire catalog as a PDF file.Manufacturer Notes: Ability to view notes is user role based for gas enginesUser notes:User can type notes about the engine and save for future viewingNOTE: Users notes are only visible by person logged in - not visible for other users.Find a part inside the catalogueEnter a part number or its description to find part inside the entire cataloge.g.: entering “cartridge” the catalog shows all groups where cartridge description is locatedand selecting “Engine Block” section the catalog opens directly the page where the cartridge is listedSections ViewsSection Views give a visual aid to the group name to determine which group to search for components.E.G. Looking for an oil cartridge, the user could find it in the Oil Circuit section or Engine Block section because the Oil Cartridge is fitted on the Crank Case, in both cases the user will find the component they are looking for.Selecting a section for a diesel engine, the user can open it and see subpages related to the selected section and select a page to see its part list.Selecting a portable generator product gasoline (or Lombardini Marine and EcoWind branded diesel products), the user will open the one page illustration with parts listing. If you want to see the engine used on this application you click on “see engine spec” and it goes to the illustrations and parts listing for the engine – in this case CH440-3140.Selecting a section for a gas engine, the user can open it and see the group illustration and parts listingExploded Views:The exploded view shows all the components fitted on the engine, it is possible to zoom in by clicking on “enlarge icon”Part ListShows all components related to the exploded view, each position on the exploded view is listed in the Parts List as per below image.Parts List includes the following columns:•Pos: it is the position of the component referred to the exploded view.•KIT: a letter in this column determines if the component is a KIT (includes other components)•Included in: determines the components included in the KIT which have the same letter of the KIT component.E.G. the component in Pos. 1 includes the components in Pos. 5, 6, 7 and 8.•Part#: indicates the service part number of the component.•Picture icon: User can open a picture to see component in detail•Substitution: “replaces” indicates older part number - “replaced by” indicates newer part number•Description: component description•Note: a note icon gives important information for a part•QTY: shows the quantity of the component fitted on the engine.•MSRP: shows list price based off of user role for Gas engines only.•Tech info: a “PDF icon ” or a “warning icon ” indicates that a technical information is related to the component (Installation instruction, Parts bulletins, Service bulletins, Kit contents for Gasoline products).NOTE: the technical information can be opened only by clicking on “PDF icon”.•Cart Icon : under the cart icon, the user can add to cart components by clicking on ADD button.Diesel Engine parts listingGas Engine parts listingPage Exporting: like Catalog exporting, it exports the group/page that the user is consultingClick on the Excel icon to export the group as an Excel file.Click on the PDF icon to export the group as a PDF fileNOTE: The user can go back to search page clicking on the “NEW SEARCH” button.Search for a part numberYou can search by part number, description, engine type (gas/diesel), model or OEM (gas only).As you start typing a part number, the system auto populates the possible results.Click on the part to select it and then click on the search buttonThe system shows the part and all engine specification where it is used and exploded view/part list related.Click on “Search for Parts” tab, type a key word in the Description box, optionally some filters could be selected to have better results and click on “Search”.In the example below the key word is “cartridge” and the filter selected is an engine modelResults page will show all parts which only contain “cartridge” in their description.Clicking on one of the results will show all engine specifications where used and the exploded view/part list related.NOTE: The user can go back to search page clicking on the “NEW SEARCH” button.。

汽配汽修管理系统技术参数及功能说明A．属性定义本模块是系统的核心模块，其他模块中调用的数据大部分取决于该模块的定义。

比如销售、报价单中的零件属性、零件代码、客户资料等信息，都是从这里提取的。

一般初次使用本系统，应先在该模块中对零件属性、代码进行定义，以及客户资料的输入，方便以后的模块调用。

[1] 零件属性定义用途：即定义零件的各种基本信息，如编码，中文名称，产地，车型，外币价,库存上下限等。

同时可定义零件之间的通用，互换等各种关系，可以在进库，订货等中调用。

使用：选择【属性定义→零件属性定义】即进入【零件属性定义】窗口。

[2] 零件代码定义用途：将系统中的所有零件的中文名称自动生成拼音码及五笔码，大大提高了使用过程中输入中文零件名称时的速度。

使用：按【属性定义→零件代码定义】即可进入【零件代码定义】子窗口。

[3] 属性传递用途：当零件属性修改之后，运行该模块可以将库存中对应的零件的属性一并更新。

使用：按【属性定义→属性传递】即可进入【属性传递】子窗口。

在【选择字段进行传递】窗口中选择所要传递的字段，并在【选择目的表名】窗口中选择对应的目的表，然后按【确定】即可更新属性。

[4] 套件管理用途：与零件属性定义相似，不过该功能是定义套件，一个套件可以包括多个零件。

在进库、订货模块中提取一个套件，即可将其包含的多个零件提取过来。

使用：按【属性定义→套件管理】即可进入【套件管理】子窗口。

[5] 售价公式用途：售价公式主要是满足针对不同客户，不同零件属性，而给出不同的售价。

售价公式涉及三个模块：1、售价公式定义模块：用于定义售价公式；2、客户资料管理模块：用于为不同客户指定适用的售价公式；3、销售模块，开新单时输入不同的客户名，系统会自动根据公式计算出不同的售价。

[6] 客户资料管理用途：这里储存的是与您发生过进货，销售关系所有客户的资料，同时可统计所有客户每月与您的成交量，方便您对客户进行管理。

使用：按【属性定义→客户资料管理】即可进入【客户资料管理】子窗口。

汽车配件系统汽车配件系统数据库详细设计说明页8共页1第v1.0汽配汽车配件系统文档属性及版本页8共页2第v1.0汽配汽车配件系统录目.............................................................4.数据库设计的基本规范1 4................................................................................................................................................1.1开发规范................................................................................................................................................41.2命名规范...................................................................42.基本表及其说明用户表 2.14t_user.....................................................................................................................................4t_type.................................................................................................................................2.2商家分类表商家信息表 2.3t_bussiness (5)客户信息表t_customer..........................................................................................................................52.4 ...................................................................................................................................62.5关于我们t_about t_explain.............................................................................................................................62.6软件说明表 6...................................................................................................................2.7意见管理t_leave_message信息推送表 2.8 6.........................................................................................................t_push_message62.9广告管理t_ads.......................................................................................................................................7会员表t_user_info...............................................................................................................................2.107t_collection.............................................................................................................................2.11收藏表存储过程的使用.....................................................................73. ................................................................................84.总结.........................................................8数据库中总共用到11张基本表。

中国汽车材料数据系统（CAMDS）一、引言1.1编写目的本文档为中国汽车材料数据系统（CAMDS）概要设计说明书，为软件开发人员进行系统的详细设计和编程实现的主要依据。

1.2项目背景1997年，为响应在汽车环保方面的法规要求，世界范围内的汽车制造厂商们希望汽车行业能够提供一个在整个供应链中跟踪零部件及组件的化学成份的解决方案。

从1997年至1998年6月，美国EDS公司受企业委托，对汽车行业进行调研，并开始研发IMDS（国际材料数据系统）。

2001年，IMDS开发完毕并投入正式使用。

经过今年来的发展，IMDS 用户中已包括国际范围内众多的大型汽车生产厂商以及零部件供应商，成为汽车行业最具影响力的材料数据系统。

CAMDS的初期目标是以IMDS（/index.jsp）为主要原型对象，取其精华，去其糟粕，实现其中的主要核心功能，并去除其中设计、实现不合理，或不符合中国用户习惯的环节，开发为符合中国企业特点的、成功的材料数据系统，并将其在国内与国际汽车行业进行大范围推广。

二、总体设计2.1用户管理1.角色分类。

CAMDS系统中的用户按照权限类别划分为3中角色：用户管理员、CAMDS用户、只读用户。

各种用户的相应权限请见需求分析说明书。

用户管理员具有以下权限：1.为本企业创建新的用户。

2.删除本企业用户。

3.修改本企业用户的基本信息。

4.修改本企业用户的密码。

5.修改本企业除“企业名称”以外的基本信息。

（企业注册之后，“企业名称”只能由CAMDS管理委员会进行修改。

）6.设置普通用户的有效状态。

处于无效状态的用户将不能登陆系统，也不能进行创建和查询MDS等操作。

2.用户注册CAMDS的用户注册过程首先需要进行企业注册，在注册企业时，将同时注册该企业的第一个客户管理员（每个企业至少需要一名客户管理员），客户管理员的职责是创建和管理本企业的所有用户（包括其它客户管理员），同时负责回答业务方面的问题。

填写注册信息时，企业信息部分包括如下内容：1) DUNS编码：变长字符串，选填项，最多可填写30个字符。