{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["功能测试","界面测试","安全测试","性能测试","接口测试"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"功能测试","index":0,"n_rows":102,"n_cols":11,"rows_kept":102,"cut":false,"hidden":false,"merged":[[2,1,6,1],[7,1,9,1],[10,1,34,1],[35,1,42,1],[43,1,59,1],[60,1,74,1],[75,1,85,1],[86,1,101,1],[2,2,3,2],[4,2,6,2],[7,2,9,2],[10,2,16,2],[17,2,23,2],[24,2,25,2],[26,2,27,2],[28,2,34,2],[35,2,36,2],[37,2,38,2],[43,2,48,2],[49,2,51,2],[52,2,56,2],[57,2,59,2],[60,2,62,2],[63,2,65,2],[66,2,68,2],[69,2,71,2],[72,2,74,2],[75,2,76,2],[77,2,80,2],[81,2,85,2],[86,2,89,2],[90,2,92,2],[93,2,99,2],[100,2,101,2]]}
["用例编号","所属模块","功能","用例名称","用例描述","用例类型","测试步骤","预期结果","设计者","设计日期","用例评审状态"]
["001","用户登录","登录认证","登录验证","系统登录是否正常","正例","打开系统登录页，分别输入正确或错误的账密","账密和验证码正确能登录，否则提示错误","HNZ","2024-05-20","已评审"]
["002","后台首页","消息提醒","消息提醒","有未读消息，右上角闪烁提醒","正例","模拟新的提醒消息，查看右上角消息图标","系统右上角图标显示未读消息数并闪烁显示","HNZ","2024-05-20","已评审"]
["003",null,null,"消息查看","查看未读消息是否正常","正例","点击消息提醒图标","打开未读消息列表","HNZ","2024-05-20","已评审"]
["004",null,"数据概览","作业中的集拼单","未完结的集拼单数据统计是否准确","正例","打开首页，点刷新","各环节的单量与实际相符","HNZ","2024-05-20","已评审"]
["005",null,null,"待处理的预警","待处理的预警数据统计是否准确","正例","打开首页，点刷新","各环节的单量与实际相符","HNZ","2024-05-20","已评审"]
["006",null,null,"最近15天集拼单","最近15天集拼单量统计是否准确","正例","打开首页，点刷新","各天的集拼单量与实际相符","HNZ","2024-05-20","已评审"]
["007","理货管理","理货数据查询","数据同步","是否正常接收来自辅助系统的理货数据","正例","辅助系统推送理货数据","数据列表查看到同步的数据","HNZ","2024-05-20","已评审"]
["008",null,null,"数据列表","是否按查询条件正常查询数据","正例","输入查询条件，点击查询","查询结果正确","HNZ","2024-05-20","已评审"]
["009",null,null,"数据详情","查看详情功能正常","正例","点击“详情”链接","可查看详情数据","HNZ","2024-05-20","已评审"]
["010"," 集拼管理","集拼订单分布","按状态分布显示订单","能正常显示各环节的未完结集拼单","正例","点击各环节Tab","正常显示各环节的集拼单列表","HNZ","2024-05-20","已评审"]
["011",null,null,"集拼单详情","查看详情功能正常","正例","点击“详情”链接","可查看详情数据","HNZ","2024-05-20","已评审"]
["012",null,null,"重新发起AI分析","能人为发起A阶段AI分析","正例","点击“AI分析(a)”链接","能发起A阶段的AI分析，结果推送给辅助系统","HNZ","2024-05-20","已评审"]
["013",null,null,"重新发起AI分析","能人为发起B阶段AI分析","正例","点击“AI分析(b)”链接","能发起B阶段的AI分析，结果推送给辅助系统","HNZ","2024-05-20","已评审"]
["014",null,null,"控制机械臂","机械臂控制功能正常","正例","点击“异常处理”链接，点击机械臂停止、上升、下降","如果库位有机械臂，可以正常操作","HNZ","2024-05-20","已评审"]
["015",null,null,"A阶段结果反馈","能人为向辅助系统反馈A阶段分析结果","正例","点击“异常处理”链接，点击【A阶段结果反馈】","选定结果反馈辅助系统","HNZ","2024-05-20","已评审"]
["016",null,null,"B阶段结果反馈","能人为向辅助系统反馈B阶段分析结果","正例","点击“异常处理”链接，点击【B阶段结果反馈】","选定结果反馈辅助系统","HNZ","2024-05-20","已评审"]
["017",null,"集拼订单查询","按状态分布显示订单","能正常显示各环节的未完结集拼单","正例","点击各环节Tab","正常显示各环节的集拼单列表","HNZ","2024-05-20","已评审"]
["018",null,null,"集拼单详情","查看详情功能正常","正例","点击“详情”链接","可查看详情数据","HNZ","2024-05-20","已评审"]
["019",null,null,"重新发起AI分析","能人为发起A阶段AI分析","正例","点击“AI分析(a)”链接","能发起A阶段的AI分析，结果推送给辅助系统","HNZ","2024-05-20","已评审"]
["020",null,null,"重新发起AI分析","能人为发起B阶段AI分析","正例","点击“AI分析(b)”链接","能发起B阶段的AI分析，结果推送给辅助系统","HNZ","2024-05-20","已评审"]
["021",null,null,"控制机械臂","机械臂控制功能正常","正例","点击“异常处理”链接，点击机械臂停止、上升、下降","如果库位有机械臂，可以正常操作","HNZ","2024-05-20","已评审"]
["022",null,null,"A阶段结果反馈","能人为向辅助系统反馈A阶段分析结果","正例","点击“异常处理”链接，点击【A阶段结果反馈】","选定结果反馈辅助系统","HNZ","2024-05-20","已评审"]
["023",null,null,"B阶段结果反馈","能人为向辅助系统反馈B阶段分析结果","正例","点击“异常处理”链接，点击【B阶段结果反馈】","选定结果反馈辅助系统","HNZ","2024-05-20","已评审"]
["024",null,"集拼核放单","数据同步","是否正常接收来自辅助系统的核放单数据","正例","辅助系统推送核放单数据","数据列表查看到同步的数据","HNZ","2024-05-20","已评审"]
["025",null,null,"数据列表","是否按查询条件正常查询数据","正例","输入查询条件，点击查询","查询结果正确","HNZ","2024-05-20","已评审"]
["026",null,"集拼过卡记录","数据同步","是否正常接收来自辅助系统的过卡记录","正例","辅助系统推送过卡记录数据","数据列表查看到同步的数据","HNZ","2024-05-20","已评审"]
["027",null,null,"数据列表","是否按查询条件正常查询数据","正例","输入查询条件，点击查询","查询结果正确","HNZ","2024-05-20","已评审"]
["028",null,"异常报警","设备异常报警","设备由在线变为离线时能触发报警","正例","人为故意让相机、机械臂等硬件设备离线","前端能查看到设备异常报警记录","HNZ","2024-05-20","已评审"]
["029",null,null,"应用接口异常报警","应用接口由访问正常变为访问异常时能触发报警","正例","人为停接口服务","前端能查看到应用异常报警记录","HNZ","2024-05-20","已评审"]
["030",null,null,"AI分析异常报警","AI分析结果异常时能触发报警","正例","AI反馈分析结果异常","前端能查看到异常报警记录","HNZ","2024-05-20","已评审"]
["031",null,null,"入库车辆异常报警","停靠车位的车辆车牌与到货通知的车牌不一致时能触发报警","正例","收到辅助系统到货通知，其它车牌的车辆驶入车位","正常应触发异常报警","HNZ","2024-05-20","已评审"]
["032",null,null,"去卡口超时异常报警","收到华东辅助系统接口反馈的超时信息时触发报警","正例","收到辅助系统的出卡超时预警","正常应触发异常报警","HNZ","2024-05-20","已评审"]
["033",null,null,"报警记录查询","能正常查看各类型的异常预警信息","正例","点击各标签页查看报警记录","查询结果正确","HNZ","2024-05-20","已评审"]
["034",null,null,"报警记录处理","能正常更新报警处理状态","正例","点击“处理”链接，选择处理状态，保存","更新处理状态","HNZ","2024-05-20","已评审"]
["035","AI分析相关","车辆入库识别","车牌识别","能接收号牌识别事件","正例","车辆驶入车位","按流程处理事件","HNZ","2024-05-20","已评审"]
["036",null,null,"出入库事件","能接收车辆进出事件","正例","车辆驶入车位","按流程处理事件","HNZ","2024-05-20","已评审"]
["037",null,"A阶段AI分析","围网密闭分析","验证是否按流程发起围网密闭分析","正例"," 收到到货通知且车辆已到达车位","AI系统收到抓拍图片和请求分析指令","HNZ","2024-05-20","已评审"]
["038",null,null,"空箱分析","验证是否按流程发起空箱分析","正例"," 收到到货通知且车辆已到达车位","AI系统收到抓拍图片和请求分析指令","HNZ","2024-05-20","已评审"]
["039",null,"B阶段AI分析","空箱分析","验证是否按流程发起空箱分析","正例"," 收到准装通知","AI系统收到抓拍图片和请求分析指令","HNZ","2024-05-20","已评审"]
["040",null,"抓拍分析记录","AI分析记录","确认AI分析记录完整性与查询有效性","正例","输入查询条件，点击查询","查询结果正确","HNZ","2024-05-20","已评审"]
["041",null,"分析结果确认","分析结果确认","能人工确认分析结果","正例","勾选分析记录，批量确认结果","正常保存，更新状态","HNZ","2024-05-20","已评审"]
["042",null,"AI分析统计","AI分析统计","验证统计结果与实际是否一致","正例","打开页面，点刷新","统计结果与实际一致","HNZ","2024-05-20","已评审"]
["043","基础数据管理","监控设备管理","设备查询","验证条件查询设备是否正常","正例","输入查询条件查询设备","设备查询结果与实际一致","HNZ","2024-05-20","已评审"]
["044",null,null,"设备导出","验证导出功能是否正常","正例","按条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["045",null,null,"设备维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存","HNZ","2024-05-20","已评审"]
["046",null,null,"区域绑定","验证设备能否正常绑定区域","正例","点击绑定链接，选择区域保存","正常保存，显示绑定区域","HNZ","2024-05-20","已评审"]
["047",null,null,"区域解绑","验证设备能否正常解绑区域","正例","点击解绑链接","区域解绑成功","HNZ","2024-05-20","已评审"]
["048",null,null,"设备启停","验证设备能否正常启停","正例","点击启停按钮","正常保存，状态更新","HNZ","2024-05-20","已评审"]
["049",null,"监控区域管理","区域查询","验证条件查询区域是否正常","正例","输入查询条件查询区域","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["050",null,null,"区域导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["051",null,null,"区域维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存","HNZ","2024-05-20","已评审"]
["052",null,"接入应用管理","应用查询","验证条件查询应用是否正常","正例","输入查询条件查询应用","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["053",null,null,"应用导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["054",null,null,"应用维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["055",null,null,"秘钥对生成","验证生成RSA秘钥对是否正常","正例","点击“生成”链接","可以生成新的RSA秘钥对","HNZ","2024-05-20","已评审"]
["056",null,null,"秘钥对下载","验证生成的RSA秘钥对是否能下载","正例","点击“下载”链接","正常下载到本地","HNZ","2024-05-20","已评审"]
["057",null,"接入企业管理","应用查询","验证条件查询应用是否正常","正例","输入查询条件查询应用","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["058",null,null,"应用导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["059",null,null,"应用维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["060","仓库管理","仓库设置","仓库查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["061",null,null,"仓库导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["062",null,null,"仓库维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["063",null,"库区管理","库区查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["064",null,null,"库区导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["065",null,null,"库区维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["066",null,"库位管理","库位查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["067",null,null,"库位导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["068",null,null,"库位维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["069",null,"货架管理","货架查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["070",null,null,"货架导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["071",null,null,"货架维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["072",null,"托盘管理","托盘查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["073",null,null,"托盘导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["074",null,null,"托盘维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["075","权限管理","部门管理","部门查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["076",null,null,"部门维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["077",null,"角色管理","角色查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["078",null,null,"角色导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["079",null,null,"角色维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["080",null,null,"分配用户","验证添加角色用户是否正常","正例","点击“分配用户”，选择用户并确定","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["081",null,"用户管理","角色查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["082",null,null,"角色导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["083",null,null,"角色维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["084",null,null,"分配角色","验证添加角色用户是否正常","正例","点击“分配角色”，选择角色并确定","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["085",null,null,"重置密码","验证密码重置功能是否正常","正例","点击“重置密码”链接，输入新密码然后确定","密码重置成功，新密码能登录","HNZ","2024-05-20","已评审"]
["086","系统管理","消息提醒","未读消息列表","未读消息列表显示是否正常","正例","点击未读消息标签","显示正常","HNZ","2024-05-20","已评审"]
["087",null,null,"已读消息列表","已读消息列表显示是否正常","正例","点击已读消息标签","显示正常","HNZ","2024-05-20","已评审"]
["088",null,null,"删除消息","验证消息删除功能是否正常","正例","勾选消息，点击删除按钮","删除成功，列表更新","HNZ","2024-05-20","已评审"]
["089",null,null,"标识为已读","验证消息已读功能是否正常","正例","勾选消息，点击已读按钮","消息变为已读并归到已读消息列表","HNZ","2024-05-20","已评审"]
["090",null,"消息提醒设置","配置查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["091",null,null,"配置修改","验证配置修改功能是否正常","正例","修改配置、保存","正常保存，数据更新，新消息按新提醒范围提醒","HNZ","2024-05-20","已评审"]
["092",null,null,"提醒开关","验证提醒开关功能是否正常","正例","分别操作开关提醒，看有新消息时是否会提醒","1、如果某类消息开且登录用户在提醒范围内，则提醒；\n2、如果某类消息提醒关则不提醒。","HNZ","2024-05-20","已评审"]
["093",null,"字典管理","字典类型查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["094",null,null,"字典类型导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["095",null,null,"字典类型维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["096",null,null,"字典缓存更新","验证缓存更新功能是否正常","正例","新增或修改字段数据后点击缓存更新按钮","缓存更新","HNZ","2024-05-20","已评审"]
["097",null,null,"字典数据查询","验证条件查询是否正常","正例","输入查询条件查询数据","查询结果与实际一致","HNZ","2024-05-20","已评审"]
["098",null,null,"字典数据导出","验证导出功能是否正常","正例","按查询条件查询后点击导出按钮","导出结果与查询结果一致","HNZ","2024-05-20","已评审"]
["099",null,null,"字典数据维护","验证增删改功能是否正常","正例","点击增删改操作","正常保存，数据更新","HNZ","2024-05-20","已评审"]
["100",null,"系统运维","操作日志","业务操作记录日志是否正常","正例","业务模块进行增删改操作后查看日志","日志记录与业务操作一致","HNZ","2024-05-20","已评审"]
["101",null,null,"登录日志","登录操作记录日志是否正常","正例","登录、登出操作后查看日志","登录日志正常记录","HNZ","2024-05-20","已评审"]

{"sheet":"界面测试","index":1,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,1,3,1],[5,1,9,1],[10,1,12,1],[13,1,16,1],[17,1,21,1],[22,1,24,1],[25,1,29,1]]}
["用例编号","所属模块","用例名称","用例描述","用例类型","测试步骤","预期结果","设计者","设计日期","用例评审状态"]
["102","用户登录","登录认证","页面功能在约定的浏览上全部兼容","正例","打开系统登录页，分别输入正确或错误的账密","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["103","后台首页","消息提醒","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.查看右上角消息提醒","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["104",null,"数据概览","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开首页","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["105","理货管理","理货数据查询","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开理货数据查询菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["106"," 集拼管理","集拼订单分布","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开集拼订单分布菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["107",null,"集拼订单查询","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开集拼订单查询菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["108",null,"集拼核放单","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开集拼核放单菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["109",null,"集拼过卡记录","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开集拼过卡记录菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["110",null,"异常报警","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开异常报警记录菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["111","AI分析","抓拍分析记录","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开抓拍分析记录菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["112",null,"分析结果确认","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开分析结果确认菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["113",null,"AI分析统计","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开AI分析统计菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["114","基础数据管理","监控设备管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开监控设备管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["115",null,"监控区域管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开监控区域管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["116",null,"接入应用管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开接入用印管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["117",null,"接入企业管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开接入企业管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["118","仓库管理","仓库设置","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开仓库设置菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["119",null,"库区管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开库区管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["120",null,"库位管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开库位管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["121",null,"货架管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开货架管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["122",null,"托盘管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开托盘管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["123","权限管理","部门管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开部门管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["124",null,"角色管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开角色管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["125",null,"用户管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开用户管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["126","系统管理","消息提醒","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开消息提醒菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["127",null,"消息提醒设置","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开提醒设置菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["128",null,"字典管理","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开字典管理菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["129",null,"操作日志","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开操作日志菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]
["130",null,"登录日志","页面功能在约定的浏览上全部兼容","正例","1.用户登录系统\n2.打开登录日志菜单","360、谷歌浏览器都可以正常使用","HNZ","2024-05-20","已评审"]

{"sheet":"安全测试","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["用例编号","所属模块","用例名称","用例描述","用例类型","测试步骤","预期结果","设计者","设计日期","用例评审状态"]
["131","安全","登录界面","登录界面安全测试","正例","登录页面输入正确的用户名和密码","成功登录","HNZ","2024-05-20","已评审"]
["132","安全","密码为*","密码为*","正例","登录页面中密码输入*","密码显示*","HNZ","2024-05-20","已评审"]
["133","安全","不匹配的用户名和密码","不匹配的用户名和密码","正例","登录页面输入不匹配的用户名和密码","登录失败","HNZ","2024-05-20","已评审"]
["134","安全","密码为空","密码为空","正例","登录页面密码为空","不允许密码为空","HNZ","2024-05-20","已评审"]
["135","安全","验证码错误","验证码错误","反例","输错验证码","验证码错误","HNZ","2024-05-20","已评审"]
["136","安全","多次登录失败","多次登录失败","正例","错误密码登录多次","密码输入错误5次，帐户锁定10分钟","HNZ","2024-05-20","已评审"]
["137","安全","防SQL注入","防SQL注入","正例","登录页面输入框输入SQL","没有出现SQL注入漏洞","HNZ","2024-05-20","已评审"]
["138","安全","访问脚本根目录","访问脚本根目录","正例","尝试访问脚本根目录","不允许访问","HNZ","2024-05-20","已评审"]
["139","安全","访问未授权url","直接访问未授权url","正例","尝试直接访问未授权url","不允许访问","HNZ","2024-05-20","已评审"]
["140","安全","备份数据","备份数据","正例","对所有的数据都有备份机制","有备份机制","HNZ","2024-05-20","已评审"]
["141","安全","数据库访问限制","数据库访问限制","正例","对访问数据库的用户进行限制","授权用户才能访问数据库","HNZ","2024-05-20","已评审"]
["142","安全","敏感数据加密存储","敏感数据加密存储","正例","查看用户数据表，确认用户密码字段是否加密","密码加密存储","HNZ","2024-05-20","已评审"]
["143","安全","敏感数据加密传输","敏感数据加密传输","正例","相机抓拍接口，查看传递的相机登录密码是否加密","传递的密码信息经过RSA加密","HNZ","2024-05-20","已评审"]

{"sheet":"性能测试","index":3,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["用例编号","所属模块","用例名称","用例描述","用例类型","测试步骤","预期结果","设计者","设计日期","用例评审状态"]
["144","性能","测试打开系统的响应时间符合标准","测试打开系统的响应时间符合标准","正例","打开浏览器，输入系统网址，点击转到","打开系统的响应时间小于3s","HNZ","2024-05-20","已评审"]
["145","性能","测试登陆的响应时间符合标准","测试登陆的响应时间符合标准","正例","打开登录页面，输入用户名和密码，点击登录","登录系统的响应时间小于3s","HNZ","2024-05-20","已评审"]
["146","性能","测试基础数据的维护功能响应时间符合标准","测试增删改查功能的响应时间符合标准","正例","打开基础数据管理模块，分别增删改一条数据，点击确定","处理响应时间小于3s","HNZ","2024-05-20","已评审"]
["147","性能","测试导出的响应时间符合标准","测试导出记录的响应时间符合标准","正例","打开功能页面，点击导出","提交的响应时间小于6s","HNZ","2024-05-20","已评审"]
["148","性能","测试批量处理的响应时间符合标准","测试个人入住费用录入的响应时间符合标准","正例","打开消息提醒，勾选多条信息， 批量已读","提交的响应时间小于3s","HNZ","2024-05-20","已评审"]
["149","性能","测试多个账号同时登陆系统的性能情况","测试多人同时登陆系统的性能情况","正例","测试20人同时登陆系统的情况","20人同时登陆系统，登录响应时间小于5s","HNZ","2024-05-20","已评审"]
["150","性能","测试多人同时对系统操作，系统的性能情况","测试多人同时对系统操作，系统的性能情况","正例","测试50人同时操作：20人登录，10人新增信息，15人更新，5人查询导出数据","测试50人同时操作，系统的响应时间小于5s","HNZ","2024-05-20","已评审"]

{"sheet":"接口测试","index":4,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,12,1],[13,1,14,1],[15,1,18,1]]}
["用例编号","所属模块","用例名称","用例描述","用例类型","测试步骤","预期结果","设计者","设计日期","用例评审状态"]
["151","辅助系统接口","接口鉴权认证接口","测试接口鉴权响应是否正常","正例","辅助系统发起接口鉴权，集拼系统打开菜单“接口调用记录”查看接口调用信息","验证成功，接口返回token\n验证失败，则接口返回错误信息","HNZ","2024-05-20","已评审"]
["152",null,"理货数据同步接口","测试数据接收响应是否正常","正例","辅助系统推送理货数据，集拼系统打开菜单“理货数据查询”查看数据","能查到推送过来的理货数据","HNZ","2024-05-20","已评审"]
["153",null,"装货计划接口","测试数据接收响应是否正常","正例","辅助系统推送装货计划，集拼系统打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["154",null,"到货通知接口","测试数据接收响应是否正常","正例","辅助系统推送到货通知，集拼系统打开菜单“接口调用记录”和“集拼订单查询”","能查到接口调用记录和集拼单数据\n此时，如果车位有停靠车辆，集拼会发起围网和空箱分析","HNZ","2024-05-20","已评审"]
["155",null,"识别结果发送（A阶段）","测试数据反馈是否正常","正例","打开菜单“集拼订单查询”，点击链接“Ai分析(a)”,发起后，打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["156",null,"运抵结果通知接口","测试数据接收响应是否正常","正例","辅助系统推送装货计划，集拼系统打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["157",null,"识别结果发送（B阶段）","测试数据反馈是否正常","正例","打开菜单“集拼订单查询”，点击链接“Ai分析(b)”,发起后，打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["158",null,"准装信息通知接口","测试数据接收响应是否正常","正例","辅助系统推送准装信息，集拼系统打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录\n同时，集拼会发起空箱分析","HNZ","2024-05-20","已评审"]
["159",null,"集拼核放单接口","测试数据接收响应是否正常","正例","辅助系统推送集拼核放单，集拼系统打开菜单“接口调用记录”和“集拼核放单”","能查到接口调用记录和集拼核放单数据","HNZ","2024-05-20","已评审"]
["160",null,"集拼过卡记录接口","测试数据接收响应是否正常","正例","辅助系统推送过卡记录，集拼系统打开菜单“接口调用记录”和“集拼过卡记录”","能查到接口调用记录和集拼过卡记录数据","HNZ","2024-05-20","已评审"]
["161",null,"车辆离仓通知接口","测试数据反馈是否正常","正例","车辆从车位驶出仓库，集拼系统打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["162",null,"从仓库出卡口超时反馈","测试数据接收响应是否正常","正例","辅助系统推送出卡超时预警信息，集拼系统打开菜单“接口调用记录”和“异常报警记录”","能查到接口调用记录和异常报警记录","HNZ","2024-05-20","已评审"]
["163","Ai系统接口","下发AI分析指令接口","测试AI分析指令下发及响应是否正常","正例","打开菜单“集拼订单查询”，点击链接“Ai分析(a)”,发起后，打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["164",null,"AI分析结果反馈接口","测试Ai分析结果接收响应是否正常","正例","打开菜单“集拼订单查询”，点击链接“Ai分析(a)”,发起后，打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["165","硬件系统接口","车辆号牌识别通知","测试号牌识别通知接口是否正常","正例","车辆驶入车位，集拼系统打开菜单“接口调用记录”查看接口日志","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["166",null,"车辆进出月台通知","测试进出月台通知接口是否正常","正例","车辆驶入驶出车位，集拼系统打开菜单“接口调用记录”查看接口日志","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["167",null,"下发机械臂控制指令","测试机械臂控制接口是否正常","正例","集拼系统打开菜单“集拼订单查询”，点击异常处理链接， 下发控制指令，查看接口日志","能查到接口调用记录","HNZ","2024-05-20","已评审"]
["168",null,"下发相机抓拍指令","测试相机抓拍接口是否正常","正例","打开菜单“集拼订单查询”，点击链接“Ai分析(a)”,发起后，打开菜单“接口调用记录”查看接口调用信息","能查到接口调用记录","HNZ","2024-05-20","已评审"]