dimtester_rs,tester_sql,data_choice,beizhu,hidden,tester_choice
settester_rs=server.CreateObject("adodb.recordset")
tester_sql="select*frompersonainnerjoinperson2positioncona.uid_person_id=c.uid_person_idinnerjoinpositionbonc.uid_position_id=b.uid_position_idwherevarchar_position_name='试验员'"
tester_rs.opentester_sql,conn,1,1
data_choice=trim(all_content_rs.fields("uid_all_content_id")&"date_choice")
beizhu=trim(all_content_rs.fields("uid_all_content_id")&"beizhu")
hidden=trim(all_content_rs.fields("uid_all_content_id")&"hidden")
tester_choice=trim(all_content_rs.fields("uid_all_content_id")&"tester_choice")
%>
[td]
"class="dh_text"id="tester_confirm">
请选择试验员
true%>
">
[/td]
"type="hidden"value="">
[td]"type="text"class="dh_text"id="publish_date"onClick="JTC.setday({format:'yyyy-MM-dd',readOnly:true})"size="16"/>[/td]
[td]"type="text"class="dh_text"id="beizhu"/>[/td]
[/tr]
这是前一个页面的代码
""then
test_choice_check=split(test_choice,",")
fori=0toubound(test_choice_check)
setconfirmed_content_rs=server.CreateObject("adodb.recordset")'打开表confirmed_content，创建记录集
confirmed_content_sql="SELECT*FROMdbo.confirmed_content"
confirmed_content_rs.openconfirmed_content_sql,conn,1,3
setperson2test_rs=server.CreateObject("adodb.recordset")'打开表person2test，创建记录集
person2test_sql="SELECT*FROMdbo.person2test"
person2test_rs.openperson2test_sql,conn,1,3
settest_rs=server.CreateObject("adodb.recordset")'打开表test创建记录集
test_sql="SELECT*FROMdbo.test"
test_rs.opentest_sql,conn,1,3
confirmed_content_rs.addnew
confirmed_content_rs("uid_All_Content_ID")=test_choice_check(i)
confirmed_content_rs("uid_orders_id")=request("uid_orders_id")
confirmed_content_rs("bit_confirmed_content_is_finished")=0
confirmed_content_rs("varchar_confirmed_content_name")=request.form(""&test_choice_check(i)&""&("hidden"))
confirmed_content_rs.update
confirmed_content_rs.movelast
uid_confirmed_content_id=confirmed_content_rs("uid_confirmed_content_id")
test_rs.addnew
test_rs.fields("bit_test_is_done")=0
test_rs.fields("bit_test_is_verified")=0
response.Write(""&test_choice_check(i)&""&"beizhu")
test_rs.fields("varchar_test_remark")=request.form(""&test_choice_check(i)&""&("beizhu"))
test_rs.fields("uid_confirmed_content_id")=uid_confirmed_content_id
test_rs.update
test_rs.movelast
test_id=test_rs("uid_test_id")
person2test_rs.addnew
person2test_rs.fields("varchar_person2test_deadline")=request.form(""&test_choice_check(i)&""&("data_choice"))
person2test_rs.fields("uid_person_id")=request.form(""&test_choice_check(i)&""&("tester_choice"))
person2test_rs.fields("uid_test_id")=test_id
person2test_rs.update
confirmed_content_rs.close
setconfirmed_content_rs=nothing
test_rs.close
settest_rs=nothing
person2test_rs.close
setperson2test_rs=nothing
next
endif
%>
这是后一个页面的代码
分 -->
|
