《和炭化室数量相关的储存过程.doc》由会员分享,可在线阅读,更多相关《和炭化室数量相关的储存过程.doc(12页珍藏版)》请在金锄头文库上搜索。
1、修改名称SP_GetMplcData修改位置第15行原代码Select * from T_MPLCTestData WHERE LEAK = 泄漏 OR ID 200 Order By (Case When (id=201 or id = 202) Then 1 Else 0 End),testtime修改后代码Select * from T_MPLCTestData WHERE LEAK = 泄漏 OR ID CharRoomCount*2 Order By (Case When (id=CharRoomCount*2+1 or id = CharRoomCount*2+2) Then 1
2、Else 0 End),testtime测试结果用代码exec SP_GetMplcData调用此存储过程,得到与预期结果相符的数据,测试成功。修改名称SP_GetOutCharRoom修改位置第23行原代码IF ID 100 SET ID = ID -100修改后代码IF ID CharRoomCount SET ID = ID - CharRoomCount测试结果定义输出变量i,用代码exec SP_GetOutCharRoom i output, 调用此存储过程,测试第1个与最后一个炭化室号,再随机抽取一个,得到与预期结果相符的数据,测试成功。修改名称SP_GetPreOutNo修改位
3、置第19行原代码IF ID = 0 SET ID = 100修改后代码 IF ID = 0 SET ID = CharRoomCount测试结果定义输出变量i,用代码exec SP_GetPreOutNo , i output调用此存储过程,测试第1个与最后一个炭化室号,再随机抽取一个,得到与预期结果相符的数据,测试成功。修改名称SP_GetStandardCharRoom修改位置第19行原代码IF ID 100 SET ID = ID - 100修改后代码 IF ID CharRoomCount SET ID = ID - CharRoomCount测试结果定义输出变量i,用代码exec S
4、P_GetStandardCharRoom , i output调用此存储过程,测试第1个与最后一个炭化室号,再随机抽取一个,得到与预期结果相符的数据,测试成功。修改名称SP_GetStoveLidData修改位置第13行原代码SELECT * FROM T_StoveLidTestData WHERE LEAK = 泄漏 OR ID 400 Order By (Case When (id=401 or id = 402) Then 1 Else 0 End),testtime修改后代码SELECT * FROM T_StoveLidTestData WHERE LEAK = 泄漏 OR ID
5、 CharRoomCount*4 Order By (Case When (id=CharRoomCount * 4 + 1 or id = CharRoomCount * 4 + 2) Then 1 Else 0 End),testtime测试结果用代码exec SP_GetStoveLidData调用此存储过程,得到与预期结果相符的数据,测试成功。修改名称SP_GetTestCharRoom修改位置第19行原代码IF ID = 0 SET ID = ID +100修改后代码IF ID = 0 SET ID = ID + CharRoomCount测试结果定义输出变量i,用代码exec SP
6、_GetTestCharRoom , i output调用此存储过程,测试第1个与最后一个炭化室号,再随机抽取一个,得到与预期结果相符的数据,测试成功。修改名称SP_LostDataMakeupCPLC修改位置1第131行原代码SELECT PCMUCOUNT = COUNT(*) FROM T_CPLCTestData WHERE PCAppraise = 达标 AND ID 101修改后代码 SELECT PCMUCOUNT = COUNT(*) FROM T_CPLCTestData WHERE PCAppraise = 达标 AND ID = CharRoomCount修改位置2第13
7、4行原代码SELECT PCCOUNT = COUNT(*)-3 FROM T_CPLCTestData修改后代码SELECT PCCOUNT = CharRoomCount 修改位置3第136行原代码SELECT SO2MUCOUNT = COUNT(*) FROM T_CPLCTestData WHERE SO2Appraise = 达标 AND ID 101修改后代码SELECT SO2MUCOUNT = COUNT(*) FROM T_CPLCTestData WHERE SO2Appraise = 达标 AND ID = CharRoomCount修改位置5第143行原代码UPDAT
8、E T_CPLCTestData SET PcAppraise = PCMU, SO2Appraise = SO2MU WHERE ID = 103修改后代码 UPDATE T_CPLCTestData SET PcAppraise = PCMU, SO2Appraise = SO2MU WHERE ID = CharRoomCount+3修改位置6第148行原代码SELECT MAXVALUE = MAX(PCValue), AVGVALUE = AVG(PCValue) FROM T_CPLCTestData WHERE ID = 100修改后代码 UPDATE T_CPLCTestDat
9、a SET PcAppraise = PCMU, SO2Appraise = SO2MU WHERE ID = CharRoomCount+3修改位置7第151行原代码UPDATE T_CPLCTestData SET PCValue = MAXVALUE WHERE ID = 101 UPDATE T_CPLCTestData SET PCValue = AVGVALUE WHERE ID = 102修改后代码UPDATE T_CPLCTestData SET PCValue = MAXVALUE WHERE ID = CharRoomCount+1 UPDATE T_CPLCTestDat
10、a SET PCValue = AVGVALUE WHERE ID = CharRoomCount+2修改位置8第 156行原代码SELECT MAXVALUE = MAX(SO2Value), AVGVALUE = AVG(SO2Value) FROM T_CPLCTestData WHERE ID = 100修改后代码 SELECT MAXVALUE = MAX(SO2Value), AVGVALUE = AVG(SO2Value) FROM T_CPLCTestData WHERE ID = CharRoomCount修改位置9第159行原代码 UPDATE T_CPLCTestData
11、 SET SO2Value = MAXVALUE WHERE ID = 101 UPDATE T_CPLCTestData SET SO2Value = AVGVALUE WHERE ID = 102修改后代码UPDATE T_CPLCTestData SET SO2Value = MAXVALUE WHERE ID = CharRoomCount+1 UPDATE T_CPLCTestData SET SO2Value = AVGVALUE WHERE ID = CharRoomCount+2测试结果修改名称SP_LostDataMakeupHPLC修改位置1第192行原代码IF ChrRm
12、No = 3 OR ChrRmNo = 27 OR ChrRmNo = 53 OR ChrRmNo = 58 OR ChrRmNo = 83 OR ChrRmNo = 108修改后代码IF ChrRmNo = 3 OR ChrRmNo = dbo.F_OrderToPhy(CharRoomCount/4) OR ChrRmNo = dbo.F_OrderToPhy(CharRoomCount/2-2) OR ChrRmNo = dbo.F_OrderToPhy(CharRoomCount/2+2) OR ChrRmNo = dbo.F_OrderToPhy(CharRoomCount*3/4)
13、 OR ChrRmNo = dbo.F_OrderToPhy(CharRoomCount-2)修改位置2第285行原代码IF (PLCCODE = SB03 AND TestCharRoomNo = 55 AND NOT EXISTS(SELECT * FROM T_StoveLidTestDataHistory WHERE CHARROOMNO = TestCharRoomNo AND ABS(DATEDIFF(MINUTE, TESTTIME, CurTestTime)= 56 AND NOT EXISTS(SELECT * FROM T_StoveLidTestDataHistory WHERE CHARROOMNO = TestCharRoomNo AND ABS(DATEDIFF(MINUTE, TESTTIME, CurTestTime)=5)修改后代码IF (PLCCODE = SB03 AND TestCharRoomNo = DBO.F_OrderToPhy(CharRoomCount/2) AND NOT EXISTS(SELECT * FROM T_St