测试报告_RF盘点.docVIP

1．增加RF设备执行下列语句：/*rf设备*/ select * from RFDEVICE delete from RFDEVICE insert 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 output exec rf_PD_FirstCheckDetailUpload @RFFlowNo = 1108160001, @RFNo = 001, @GroupNo = G001, @Shelf = S001, @Num = 1, @Wh = 001, @EmployeeNo = hmf, @Gid = @Qty = 10, @Price = 100, @Total = 1000, @strErrMsg = @msg output exec rf_PD_FirstCheckDetailUpload @RFFlowNo = 1108160001, @RFNo = 001, @GroupNo = G001, @Shelf = S001, @Num = 2, @Wh = 001, @EmployeeNo = hmf, @Gid = @Qty = 10, @Price = 100, @Total = 1000, @strErrMsg = @msg output declare @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 output exec rf_PD_FirstCheckDetailUpload @RFFlowNo = 1108160001, @RFNo = 002, @GroupNo = G002, @Shelf = S001, @Num = 1, @Wh = 001, @EmployeeNo = hmf, @Gid = @Qty = 10, @Price = 100, @Total = 1000, @strErrMsg = @msg output exec rf_PD_FirstCheckDetailUpload @RFFlowNo = 1108160001, @RFNo = 002, @GroupNo = G002, @Shelf = S001, @Num = 2, @Wh = 001, @EmployeeNo = hmf, @Gid = @Qty = 10, @Price = 100, @Total = 1000, @strErrMsg = @msg output ******执行数据表查看插入的数据****** select * from RFCHECK_001 select * from RFCHECKDTL_001 select * from RFCHECK_002 select * from RFCHECKDTL_002