丽升网络阅卷选做题说明文档 - 图文(3)

(2)、反面模板制作如下：

选做题定义如下：

(3)、模板做完，识别分割裁切之后，运行以下正反面选作题替换路径命令(修改后)命令：

DECLARE @LessonID nvarchar(10) Declare @DestQuesID int declare @SourceQuesID int

SET @LessonID='212' ---科目代码

set @DestQuesID=7 ----需要替换的模板上定义的裁切块号 不是 题块 set @SourceQuesID=80 ----实际模板上定义的裁切块

----获取需要替换的裁切块信息(只在选作题的情况下执行)

Select RowID , SUBSTRING(PaperID,1,LEN(PaperID)-1) AS PID into #1 From PaperStore Where LessonID=@LessonID And BaseQuesID=@DestQuesID And ChoiceQ=1

--

Select SUBSTRING(PaperID,1,LEN(PaperID)-1) AS PID,PaperImagePath,PaperID into #2 From PaperStore

Where LessonID=@LessonID And BaseQuesID=@SourceQuesID

Select A.RowID,A.PID,B.PaperImagePath,B.PaperID Into #R From #1 A,#2 B Where A.PID=B.PID

----更新裁切库中题块路径

Update PaperStore Set PaperImagePath =B.PaperImagePath,PaperID=B.PaperID From #R B Where

PaperStore.RowID=B.RowID

---更新分发库中题块路径

Update PaperDis Set PaperImagePath =B.PaperImagePath,PaperID=B.PaperID From #R B Where

PaperDis.RowID=B.RowID

Drop table #1 drop table #2 Drop table #R

----你自己查看可以验证

Select RowID,PaperID,QuesID,PaperImagePath,BaseQuesID From PaperStore where LessonID=@LessonID and BaseQuesID=@DestQuesID

四、一页答题卡分为A、B、C卡解决方法

(1)、模板定义方法与常规一样定义；

(2)、在识别分割里面的课程管理建立相同课程的A、B、C课程项目，如下图所示：

(3)、在总课程里面进行识别分割，单科校验，选项校正，考号校验； (4)、执行以下命令语句： Declare @LessonID nvarchar(30)

set @LessonID='105'

Select PID ,PaperType,CAST(ascii(PaperType)-64 +CAST(@LessonID AS NUMERIC) AS NVARCHAR) AS DestLessonID INTO #1 From tblScan

Where LessonID=@LessonID and PageID=1 And PaperType>='A' order by

papertype asc

----更新裁切库

update PaperStore Set LessonID=B.DestLessonID From #1 B Where PaperStore.LessonID=@LessonID and

substring(PaperID,1,LEN(PaperID)-1)=B.PID

---更新分发库

update PaperDis Set LessonID=B.DestLessonID From #1 B Where PaperDis.LessonID=@LessonID and

substring(PaperID,1,LEN(PaperID)-1)=B.PID

---更新识别库

update tblScan Set LessonID=B.DestLessonID From #1 B

Where tblScan.LessonID=@LessonID and tblScan.PID=B.PID

----统计结果

DROP TABLE #1

---select lessonid,count(*) from tblscan where lessonid between '105' and '108' and pageid=1 group by lessonid

(5)、处理完之后，在建立A、B、C课程项目里面做各课程的评分细则，如下面三个图

所示：

(A课程)

(B课程)

(C课程)