测试报告_RF盘点

1．增加RF设备执行下列语句：/*rf设备*/select * from RFDEVICEdelete from RFDEVICEinsert into RFDEVICE(NO, NAME) values('001', 'RF_001')insert into RFDEVICE(NO, NAME) values('002', 'RF_002')insert into RFDEVICE(NO, NAME) values('003', 'RF_003')insert into RFDEVICE(NO, NAME) values('004', 'RF_004')2．模拟导入的数据(A、B俩组的盘点数据相同)：数据表：Rfcheck_001、Rfcheckdtl_001; Rfcheck_002、Rfcheckdtl_002给表中添加数据declare@msg varchar(255)exec rf_PD_FirstCheckMainUpload@RFFlowNo = '1108160001',@RFNo = '001',@GroupNo = 'G001',@FilDate = '2011.8.17 11:11:11',@EmployeeNo = 'hmf',@Wh = '001',@Shelf = 'S001',@Record = 2,@SubState = 0,@SubTime = '2011.8.17 11:11:11',@Note = 'FUCK OFF!',@strErrMsg = @msg outputexec rf_PD_FirstCheckDetailUpload@RFFlowNo = '1108160001',@RFNo = '001',@GroupNo = 'G001',@Shelf = 'S001',@Num = '1',@Wh = '001',@EmployeeNo = 'hmf',@Gid = 33253990,@Qty = 10,@Price = 100,@Total = 1000,@strErrMsg = @msg outputexec rf_PD_FirstCheckDetailUpload@RFFlowNo = '1108160001',@RFNo = '001',@GroupNo = 'G001',@Shelf = 'S001',@Num = '2',@Wh = '001',@EmployeeNo = 'hmf',@Gid = 33253998,@Qty = 10,@Price = 100,@Total = 1000,@strErrMsg = @msg outputdeclare@msg varchar(255)exec rf_PD_FirstCheckMainUpload @RFFlowNo = '1108160001',@RFNo = '002',@GroupNo = 'G002',@FilDate = '2011.8.17 11:11:11',@EmployeeNo = 'hmf',@Wh = '001',@Shelf = 'S001',@Record = 2,@SubState = 0,@SubTime = '2011.8.17 11:11:11', @Note = 'Going down!',@strErrMsg = @msg outputexec rf_PD_FirstCheckDetailUpload @RFFlowNo = '1108160001',@RFNo = '002',@GroupNo = 'G002',@Shelf = 'S001',@Num = '1',@Wh = '001',@EmployeeNo = 'hmf',@Gid = 33253990,@Qty = 10,@Price = 100,@Total = 1000,@strErrMsg = @msg outputexec rf_PD_FirstCheckDetailUpload @RFFlowNo = '1108160001',@RFNo = '002',@GroupNo = 'G002',@Shelf = 'S001',@Num = '2',@Wh = '001',@EmployeeNo = 'hmf',@Gid = 33253998,@Qty = 10,@Price = 100,@Total = 1000,@strErrMsg = @msg output******执行数据表查看插入的数据******select * from RFCHECK_001select * from RFCHECKDTL_001select * from RFCHECK_002select * from RFCHECKDTL_002盘点数据导入—RF设备界面相关操作及界面布局1．进入盘点数据导入—RF设备模块，查看界面中显示出本次盘点的：RF设备编号、盘点小组、货架号等信息，提交状态和导入状态显示：0，且显示的数据和插入的数据相同。

1.a．点击功能按钮，选择全选(默认的状态为全选)，界面中的勾选框被选中选择不全选，界面中的勾选框全部被取消，可以手动的进行勾选1.b．点击功能按钮，选择删除未导入的数据：删除提交状态为0或1、删除导入状态<>1 1.c．点击功能按钮，选择完成提交状态后，界面的”提交状态”显示为：1RF盘点数据对比界面，相关操作及界面布局1．进入盘点数据对比界面，分三部分：俩个显示数据信息界面和一个操作界面2．点击刷新按钮，数据显示到相应的界面3．点击对比按钮，有相应的提示录入没有差异的数据，执行步骤1．做本次盘点数据的”库存记录”2．执行模拟的盘点数据select * from RFCHECK_001select * from RFCHECKDTL_001select * from RFCHECK_002select * from RFCHECKDTL_0023．进入盘点数据导入—RF设置模块：点击功能按钮→完成提交状态→点击导入按钮后提示→是否开始从选中的记录导入盘点数据→点击是提示：对指定数据的导入操作执行完成。

操作完成提交状态前：RFCHECK_001.SUBSTATE = 0操作完成提交状态后：RFCHECK_001.SUBSTATE = 1操作确定导入前：RFCHECK_001.IMPORTSTATE = 0操作确定导入后：RFCHECK_001.IMPORTSTATE = 1导入完成后查看数据表中记录本次需要对比的数据select * from RFCHECKCOMPAREselect * from RFCHECKCOMPAREDTL4．进入盘点数据对比模块：点击刷新按钮→刷新出本次盘点导入的数据，根据“货架号”不同区分显示的位置。

点击对比按钮→有提示信息：对比完成，有盘点单生成，进入盘点单模块查看本次生成的盘点单数据执行对比前：RFCHECKCOMPARE.STAT= 0执行对比后：RFCHECKCOMPARE.STAT= 1查看盘点单：汇总界面中备注栏中显示，货架号和盘点对比生成明细界面中显示本次盘点对比后没有差异的商品相应的盘点信息查看数据表：select * from pckdtl、select * from pckd5．RF盘点数据清楚模块：清除盘点的所有数据信息被清除的数据信息表/*select * from RFCHECK_001select * from RFCHECKDTL_001select * from RFCHECK_002select * from RFCHECKDTL_002select * from RFCHECKCOMPAREselect * from RFCHECKCOMPAREDTLselect * from RFCHECKDIFselect * from RFDIFCHKUPLOADselect * from RFDIFCHKUPLOADDTL*/录入有差异的数据，执行步骤修改@RFNo = '002'的@Qty = 15及相应的金额信息1、2俩个环节没有发生变化1．执行模拟的盘点数据2．进入盘点数据导入—RF设置模块4．进入盘点数据对比模块：点击刷新按钮→刷新出本次盘点导入的数据，根据“货架号”不同区分显示的位置。

点击对比按钮→有提示信息：对比完成，有盘点单生成。

有差异数据生成执行对比前：RFCHECKCOMPARE.STAT= 0执行对比后：RFCHECKCOMPARE.STAT= 1查看盘点单：汇总界面中备注栏中显示，货架号和盘点对比生成明细界面中显示本次盘点对比后没有差异的商品相应的盘点信息查看数据表：select * from pckdtl、select * from pckd查看差异数据select * from RFCHECKDIF，数据表下载状态状态RFCHECKDIF.STAT = 0执行下载(下载的数据只能执行一次)：declare@RFNo char(10),@Shelf char(10),@strErrMsg varchar(255)set @RFNo = '002'set @Shelf = 'S001'exec rf_PD_DifDataDownload @RFNo, @Shelf, @strErrMsg outputselect @strErrMsgselect * from RFCHECKDIF，数据表下载状态状态RFCHECKDIF.STAT = 1/*上传差异数据(主表)*/declare@RFNo char(10),@Shelf char(10),@FilDate datetime,@EmployeeNo char(13),@Wh char(10),@Stat smallint,@Record int,@Note varchar(50),@strErrMsg varchar(255)set @RFNo = '003'set @Shelf = 'S001'set @FilDate = GetDate()set @EmployeeNo = '0'set @Wh = '001'set @Stat = 0set @Record = 2set @Note = 'God bless you!'exec rf_PD_DifMainUpload @RFNo, @Shelf, @FilDate, @EmployeeNo, @Wh, @Stat, @Record, @Note, @strErrMsg output/*上传差异表(明细)*/declare@RFNo char(10),@Shelf char(10),@Num char(5),@Stat smallint,@Gid int,@Qty decimal(12,4),@Total decimal(12,4),@Wh char(10),@strErrMsg varchar(255)set @RFNo = '003'set @Shelf = 'S001'set @Num = '1'set @Stat = 0set @Gid = 33253998set @Qty = 15set @Total = 1500set @Wh = '001'exec rf_PD_DifDetailUpload @RFNo, @Shelf, @Num, @Stat, @Gid, @Qty, @Total, @Wh, @strErrMsg output执行上载差异后，查看数据表记录重新盘点的数据select * from RFDIFCHKUPLOADselect * from RFDIFCHKUPLOADDTL/*生成差异重盘盘点单*/begin trandeclare@RFNo char(10),@Shelf char(10),@EmployeeNo char(13),@strErrMsg varchar(255)set @RFNo = '002'set @Shelf = 'S002'set @EmployeeNo = '0'exec rf_PD_ImportPDOrder @RFNo, @Shelf, @EmployeeNo, @strErrMsg outputselect @strErrMsgcommit或rollback导入数据存在异常时(同组货架号已存在盘点数据)同一货架号已存在盘点数据时：数据表RFCHECK_002(***)中importstate不等于1时在”盘点数据导入—RF设备”界面中。