level 1
hz__0571
楼主
Provider 错误 '80020005'
类型不匹配。
/user_addrepair.asp，行 43
代码如下
<!--#include file="conn.asp"-->
<%call admintop()
if request("action")="add" then
nowp_bianhao=request("p_bianhao")
nowp_reportman=request("p_reportman")
nowp_reportmanphone=request("p_reportmanphone")
nowp_reportdept=request("p_reportdept")
nowp_sort=checkifnum(request("p_sort"))
nowp_pinpai=checkifnum(request("p_pinpai"))
nowp_xinghao=checkifnum(request("p_xinghao"))
nowp_sbbianhao=trim(request("p_sbbianhao"))
nowp_repairtype=checkifnum(request("p_repairtype"))
nowp_priority=checkifnum(request("p_priority"))
nowp_detail=trim(request("p_detail"))
nowp_btime=trim(request("p_btime"))
moreinfo=""
set rs=conn.execute("select * from admin_repair where p_bianhao='"&nowp_bianhao&"'") '防止报修单号重复
if not rs.eof then
Randomize
newFreeMember=Int((99 * Rnd) + 1)
nowp_bianhao=left(nowp_bianhao,len(nowp_bianhao)-2)&germorezero(newFreeMember)
moreinfo="\n\n由于报修编号重复，您的报修编号更新为 "&nowp_bianhao& "！"
end if
rs.close
set rs=nothing
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from admin_repair", conn, 1, 3
rs.AddNew
rs("p_bianhao")=nowp_bianhao
rs("p_reportman")=nowp_reportman
rs("p_reportmanphone")=nowp_reportmanphone
rs("p_reportdept")=nowp_reportdept
rs("p_sort")=nowp_sort
rs("p_pinpai")=nowp_pinpai
rs("p_xinghao")=nowp_xinghao
rs("p_sbbianhao")=nowp_sbbianhao
rs("p_repairtype")=nowp_repairtype
rs("p_priority")=nowp_priority
rs("p_detail")=nowp_detail
rs("p_btime")=nowp_btime
rs("p_statue")=-1
rs.Update
rs.Close
set rs=nothing
response.write "<script language='javascript'>alert('报修单添加成功！"&moreinfo&"');"
response.write "window.location.href='index.asp';</script>"
response.end
end if
%>
<title>填写报修单</title>
<script type="text/javascript" charset="utf-8" src="edit/kindeditor.js"></script>
<script type="text/javascript">
KE.show({
id : 'content1',
cssPath : 'edit/index.css',
items : [
'undo', 'redo', 'fontname', 'fontsize', 'textcolor', 'bgcolor', 'bold', 'italic', 'underline',
'removeformat', 'justifyleft', 'justifycenter', 'justifyright', 'insertorderedlist',
'insertunorderedlist', 'subscript', 'superscript']
});
function check1()
{
if (document.form1.p_reportman.value=="")
{
alert("请填写报修人！");
form1.p_reportman.focus();
return false;
}
if (document.form1.content1.value=="")
{
alert("请填写报修详情！");
return false;
}
if (document.form1.p_pinpai.value=="")
{
alert("请选择设备品牌！");
form1.p_pinpai.focus();
return false;
}
if (document.form1.p_xinghao.value=="")
{
alert("请选择设备型号！");
form1.p_xinghao.focus();
return false;
}
}
var onecount;
var twocount;
onecount=0;
twocount=0;
subcat = new Array();
<%
set rsss=server.createobject("adodb.recordset")
rsss.open "select * from admin_pinpai order by j_paixu",conn,1,1
count = 0
do while not rsss.eof
%>
subcat[<%=count%>] = new Array("<%=trim(rsss("j_name"))%>","<%=rsss("j_sort_id")%>","<%=rsss("j_id")%>");
<%
count = count + 1
rsss.movenext
loop
rsss.close
%>
onecount=<%=count%>;
subcat2 = new Array();
<%
set rsss=server.createobject("adodb.recordset")
rsss.open "select * from admin_xinghao order by j_paixu",conn,1,1
count = 0
do while not rsss.eof
%>
subcat2[<%=count%>] = new Array("<%=trim(rsss("j_name"))%>","<%=rsss("j_pinpai_id")%>","<%=rsss("j_id")%>");
<%
count = count + 1
rsss.movenext
loop
rsss.close
%>
twocount=<%=count%>;
function changelocation(locationid)
{
document.form1.p_pinpai.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.form1.p_pinpai.options[document.form1.p_pinpai.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
changelocation2(document.form1.p_pinpai.options[document.form1.p_pinpai.selectedIndex].value);
}
function changelocation2(locationid)
{
document.form1.p_xinghao.length = 0;
var locationid=locationid;
var i;
for (i=0;i < twocount; i++)
{
if (subcat2[i][1] == locationid)
{
document.form1.p_xinghao.options[document.form1.p_xinghao.length] = new Option(subcat2[i][0], subcat2[i][2]);
}
}
}
</SCRIPT>
<SCRIPT src="admin/js/birthday.js"></SCRIPT>
<table border="0" cellspacing="1" cellpadding="0" height="0" align="center" width="98%" bgcolor="#183789">
<tr>
<td width="100%" align="center" bgcolor="#006F68"><img src="images/top_b.gif" border="0"></td>
</tr>
<tr>
<td>
<table border="0" cellspacing="1" cellpadding="4" bgcolor="#FFFFFF" align="center" width="100%">
<tr>
<td height="25" align="center" colspan="17" class="classtop">
<%if session("admin_name")="" then%>
<input type="button" name="button1" value="返回首页" class="button" onClick="window.location.href='index.asp';">
<input type="button" name="button2" value="报修审核" class="button1" onClick="window.location.href='admin/default.asp';">
<%end if%>
<%if session("admin_name")<>"" then
response.write session("admin_realname")&" 你好! 您可以进行 "%>
<input type="button" name="button1" value="返回首页" class="button" onClick="window.location.href='index.asp';">
<input type="button" name="button2" value="报修审核" class="button1" onClick="window.location.href='admin/manage.asp';">
<input type="button" name="button3" value="退 出" class="button2" onClick="window.location.href='loginout.asp';">
<%end if%></td>
</tr>
<form name="form1">
<input type="hidden" name="action" value="add">
<%Randomize
FreeMember=Int((99 * Rnd) + 1)
djh="BX"&year(now())&germorezero(month(now()))&germorezero(day(now()))&germorezero(hour(now()))&germorezero(minute(now()))&germorezero(FreeMember)%>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000"><strong> 报修编号:</strong></font></td>
<td><font color="#FF0000"><strong><%=djh%></strong></font><input type="hidden" name="p_bianhao" id="p_bianhao" value="<%=djh%>"></td>
</tr>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000">*</font> 报 修 人:</td>
<td><input type="text" name="p_reportman" id="p_reportman"></td>
</tr>
<tr class="classtd">
<td height="25" align="center"> 联系电话:</td>
<td><input type="text" name="p_reportmanphone" id="p_reportmanphone"></td>
</tr>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000">*</font> 报修部门:</td>
<td><select name="p_reportdept">
<%set rsa=server.CreateObject("adodb.recordset")
rsa.open "select * from admin_dept order by j_paixu", conn, 1, 1
if rsa.eof and rsa.bof then
response.write "还没有数据，请添加！"
else
do while not rsa.eof
response.write "<option value="&rsa("j_id")&">"&rsa("j_name")&"</option>"
rsa.movenext
loop
end if
rsa.close
set rsa=nothing%>
</select></td>
</tr>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000">*</font> 设备名称:</td>
<td><select name="p_sort" id="p_sort" onChange="changelocation(document.form1.p_sort.options[document.form1.p_sort.selectedIndex].value)">
<option value="">选择设备名称</option>
<%set rsa=server.CreateObject("adodb.recordset")
rsa.open "select * from admin_sort order by s_paixu", conn, 1, 1
if rsa.eof and rsa.bof then
response.write "还没有数据，请添加！"
else
do while not rsa.eof
response.write "<option value="&rsa("s_id")&">"&rsa("s_name")&"</option>"
rsa.movenext
loop
end if
rsa.close
set rsa=nothing%>
</select>
—>
<select name="p_pinpai" id="p_pinpai" onChange="changelocation2(document.form1.p_pinpai.options[document.form1.p_pinpai.selectedIndex].value)">
<option value="">选择设备品牌</option>
</select>
—>
<select name="p_xinghao" id="p_xinghao">
<option value="">选择设备型号</option>
</select></td>
</tr>
<tr class="classtd">
<td height="25" align="center"> 设备编号:</td>
<td><input type="text" name="p_sbbianhao" id="p_sbbianhao"></td>
</tr>
<tr class="classtd">
<td height="25" align="center" class="classtd"><font color="#FF0000">*</font> 维修种类:</td>
<td><select name="p_repairtype">
<%set rsa=server.CreateObject("adodb.recordset")
rsa.open "select * from admin_repairtype order by y_paixu", conn, 1, 1
if rsa.eof and rsa.bof then
response.write "还没有数据，请添加！"
else
do while not rsa.eof
response.write "<option value="&rsa("y_id")&">"&rsa("y_name")&"</option>"
rsa.movenext
loop
end if
rsa.close
set rsa=nothing%>
</select></td>
</tr>
<tr class="classtd">
<td height="25" align="center" class="classtd"><font color="#FF0000">*</font> 缓急程度:</td>
<td><select name="p_priority">
<%set rsa=server.CreateObject("adodb.recordset")
rsa.open "select * from admin_priority order by y_paixu", conn, 1, 1
if rsa.eof and rsa.bof then
response.write "还没有数据，请添加！"
else
do while not rsa.eof
response.write "<option value="&rsa("y_id")&">"&rsa("y_name")&"</option>"
rsa.movenext
loop
end if
rsa.close
set rsa=nothing%>
</select></td>
</tr>
<tr class="classtd">
<td align="center"><font color="#FF0000">*</font> 报修详情:</td>
<td><textarea id="content1" name="p_detail" style="width:600px;height:120px;visibility:hidden;"></textarea></td>
</tr>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000">*</font> 报修时间:</td>
<td><input type="text" name="p_btime" id="date" onfocus="calendar()" value="<%=date()%>"></td>
</tr>
<tr class="classtd">
<td class="classtd" align="center" colspan="6"><input type="submit" value="报 修" onClick="return check1();" class="button"></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
请大神帮忙看看
2017年03月21日 13点03分
1
类型不匹配。
/user_addrepair.asp，行 43
代码如下
<!--#include file="conn.asp"-->
<%call admintop()
if request("action")="add" then
nowp_bianhao=request("p_bianhao")
nowp_reportman=request("p_reportman")
nowp_reportmanphone=request("p_reportmanphone")
nowp_reportdept=request("p_reportdept")
nowp_sort=checkifnum(request("p_sort"))
nowp_pinpai=checkifnum(request("p_pinpai"))
nowp_xinghao=checkifnum(request("p_xinghao"))
nowp_sbbianhao=trim(request("p_sbbianhao"))
nowp_repairtype=checkifnum(request("p_repairtype"))
nowp_priority=checkifnum(request("p_priority"))
nowp_detail=trim(request("p_detail"))
nowp_btime=trim(request("p_btime"))
moreinfo=""
set rs=conn.execute("select * from admin_repair where p_bianhao='"&nowp_bianhao&"'") '防止报修单号重复
if not rs.eof then
Randomize
newFreeMember=Int((99 * Rnd) + 1)
nowp_bianhao=left(nowp_bianhao,len(nowp_bianhao)-2)&germorezero(newFreeMember)
moreinfo="\n\n由于报修编号重复，您的报修编号更新为 "&nowp_bianhao& "！"
end if
rs.close
set rs=nothing
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from admin_repair", conn, 1, 3
rs.AddNew
rs("p_bianhao")=nowp_bianhao
rs("p_reportman")=nowp_reportman
rs("p_reportmanphone")=nowp_reportmanphone
rs("p_reportdept")=nowp_reportdept
rs("p_sort")=nowp_sort
rs("p_pinpai")=nowp_pinpai
rs("p_xinghao")=nowp_xinghao
rs("p_sbbianhao")=nowp_sbbianhao
rs("p_repairtype")=nowp_repairtype
rs("p_priority")=nowp_priority
rs("p_detail")=nowp_detail
rs("p_btime")=nowp_btime
rs("p_statue")=-1
rs.Update
rs.Close
set rs=nothing
response.write "<script language='javascript'>alert('报修单添加成功！"&moreinfo&"');"
response.write "window.location.href='index.asp';</script>"
response.end
end if
%>
<title>填写报修单</title>
<script type="text/javascript" charset="utf-8" src="edit/kindeditor.js"></script>
<script type="text/javascript">
KE.show({
id : 'content1',
cssPath : 'edit/index.css',
items : [
'undo', 'redo', 'fontname', 'fontsize', 'textcolor', 'bgcolor', 'bold', 'italic', 'underline',
'removeformat', 'justifyleft', 'justifycenter', 'justifyright', 'insertorderedlist',
'insertunorderedlist', 'subscript', 'superscript']
});
function check1()
{
if (document.form1.p_reportman.value=="")
{
alert("请填写报修人！");
form1.p_reportman.focus();
return false;
}
if (document.form1.content1.value=="")
{
alert("请填写报修详情！");
return false;
}
if (document.form1.p_pinpai.value=="")
{
alert("请选择设备品牌！");
form1.p_pinpai.focus();
return false;
}
if (document.form1.p_xinghao.value=="")
{
alert("请选择设备型号！");
form1.p_xinghao.focus();
return false;
}
}
var onecount;
var twocount;
onecount=0;
twocount=0;
subcat = new Array();
<%
set rsss=server.createobject("adodb.recordset")
rsss.open "select * from admin_pinpai order by j_paixu",conn,1,1
count = 0
do while not rsss.eof
%>
subcat[<%=count%>] = new Array("<%=trim(rsss("j_name"))%>","<%=rsss("j_sort_id")%>","<%=rsss("j_id")%>");
<%
count = count + 1
rsss.movenext
loop
rsss.close
%>
onecount=<%=count%>;
subcat2 = new Array();
<%
set rsss=server.createobject("adodb.recordset")
rsss.open "select * from admin_xinghao order by j_paixu",conn,1,1
count = 0
do while not rsss.eof
%>
subcat2[<%=count%>] = new Array("<%=trim(rsss("j_name"))%>","<%=rsss("j_pinpai_id")%>","<%=rsss("j_id")%>");
<%
count = count + 1
rsss.movenext
loop
rsss.close
%>
twocount=<%=count%>;
function changelocation(locationid)
{
document.form1.p_pinpai.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.form1.p_pinpai.options[document.form1.p_pinpai.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
changelocation2(document.form1.p_pinpai.options[document.form1.p_pinpai.selectedIndex].value);
}
function changelocation2(locationid)
{
document.form1.p_xinghao.length = 0;
var locationid=locationid;
var i;
for (i=0;i < twocount; i++)
{
if (subcat2[i][1] == locationid)
{
document.form1.p_xinghao.options[document.form1.p_xinghao.length] = new Option(subcat2[i][0], subcat2[i][2]);
}
}
}
</SCRIPT>
<SCRIPT src="admin/js/birthday.js"></SCRIPT>
<table border="0" cellspacing="1" cellpadding="0" height="0" align="center" width="98%" bgcolor="#183789">
<tr>
<td width="100%" align="center" bgcolor="#006F68"><img src="images/top_b.gif" border="0"></td>
</tr>
<tr>
<td>
<table border="0" cellspacing="1" cellpadding="4" bgcolor="#FFFFFF" align="center" width="100%">
<tr>
<td height="25" align="center" colspan="17" class="classtop">
<%if session("admin_name")="" then%>
<input type="button" name="button1" value="返回首页" class="button" onClick="window.location.href='index.asp';">
<input type="button" name="button2" value="报修审核" class="button1" onClick="window.location.href='admin/default.asp';">
<%end if%>
<%if session("admin_name")<>"" then
response.write session("admin_realname")&" 你好! 您可以进行 "%>
<input type="button" name="button1" value="返回首页" class="button" onClick="window.location.href='index.asp';">
<input type="button" name="button2" value="报修审核" class="button1" onClick="window.location.href='admin/manage.asp';">
<input type="button" name="button3" value="退 出" class="button2" onClick="window.location.href='loginout.asp';">
<%end if%></td>
</tr>
<form name="form1">
<input type="hidden" name="action" value="add">
<%Randomize
FreeMember=Int((99 * Rnd) + 1)
djh="BX"&year(now())&germorezero(month(now()))&germorezero(day(now()))&germorezero(hour(now()))&germorezero(minute(now()))&germorezero(FreeMember)%>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000"><strong> 报修编号:</strong></font></td>
<td><font color="#FF0000"><strong><%=djh%></strong></font><input type="hidden" name="p_bianhao" id="p_bianhao" value="<%=djh%>"></td>
</tr>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000">*</font> 报 修 人:</td>
<td><input type="text" name="p_reportman" id="p_reportman"></td>
</tr>
<tr class="classtd">
<td height="25" align="center"> 联系电话:</td>
<td><input type="text" name="p_reportmanphone" id="p_reportmanphone"></td>
</tr>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000">*</font> 报修部门:</td>
<td><select name="p_reportdept">
<%set rsa=server.CreateObject("adodb.recordset")
rsa.open "select * from admin_dept order by j_paixu", conn, 1, 1
if rsa.eof and rsa.bof then
response.write "还没有数据，请添加！"
else
do while not rsa.eof
response.write "<option value="&rsa("j_id")&">"&rsa("j_name")&"</option>"
rsa.movenext
loop
end if
rsa.close
set rsa=nothing%>
</select></td>
</tr>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000">*</font> 设备名称:</td>
<td><select name="p_sort" id="p_sort" onChange="changelocation(document.form1.p_sort.options[document.form1.p_sort.selectedIndex].value)">
<option value="">选择设备名称</option>
<%set rsa=server.CreateObject("adodb.recordset")
rsa.open "select * from admin_sort order by s_paixu", conn, 1, 1
if rsa.eof and rsa.bof then
response.write "还没有数据，请添加！"
else
do while not rsa.eof
response.write "<option value="&rsa("s_id")&">"&rsa("s_name")&"</option>"
rsa.movenext
loop
end if
rsa.close
set rsa=nothing%>
</select>
—>
<select name="p_pinpai" id="p_pinpai" onChange="changelocation2(document.form1.p_pinpai.options[document.form1.p_pinpai.selectedIndex].value)">
<option value="">选择设备品牌</option>
</select>
—>
<select name="p_xinghao" id="p_xinghao">
<option value="">选择设备型号</option>
</select></td>
</tr>
<tr class="classtd">
<td height="25" align="center"> 设备编号:</td>
<td><input type="text" name="p_sbbianhao" id="p_sbbianhao"></td>
</tr>
<tr class="classtd">
<td height="25" align="center" class="classtd"><font color="#FF0000">*</font> 维修种类:</td>
<td><select name="p_repairtype">
<%set rsa=server.CreateObject("adodb.recordset")
rsa.open "select * from admin_repairtype order by y_paixu", conn, 1, 1
if rsa.eof and rsa.bof then
response.write "还没有数据，请添加！"
else
do while not rsa.eof
response.write "<option value="&rsa("y_id")&">"&rsa("y_name")&"</option>"
rsa.movenext
loop
end if
rsa.close
set rsa=nothing%>
</select></td>
</tr>
<tr class="classtd">
<td height="25" align="center" class="classtd"><font color="#FF0000">*</font> 缓急程度:</td>
<td><select name="p_priority">
<%set rsa=server.CreateObject("adodb.recordset")
rsa.open "select * from admin_priority order by y_paixu", conn, 1, 1
if rsa.eof and rsa.bof then
response.write "还没有数据，请添加！"
else
do while not rsa.eof
response.write "<option value="&rsa("y_id")&">"&rsa("y_name")&"</option>"
rsa.movenext
loop
end if
rsa.close
set rsa=nothing%>
</select></td>
</tr>
<tr class="classtd">
<td align="center"><font color="#FF0000">*</font> 报修详情:</td>
<td><textarea id="content1" name="p_detail" style="width:600px;height:120px;visibility:hidden;"></textarea></td>
</tr>
<tr class="classtd">
<td height="25" align="center"><font color="#FF0000">*</font> 报修时间:</td>
<td><input type="text" name="p_btime" id="date" onfocus="calendar()" value="<%=date()%>"></td>
</tr>
<tr class="classtd">
<td class="classtd" align="center" colspan="6"><input type="submit" value="报 修" onClick="return check1();" class="button"></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
请大神帮忙看看
