标题:请教一下如何修改放弃维修后返回原报修人,不再在等待受理里面
取消只看楼主
skygg
Rank: 1
等 级:新手上路
帖 子:4
专家分:0
注 册:2012-2-2
结帖率:0
 问题点数:0 回复次数:0 
请教一下如何修改放弃维修后返回原报修人,不再在等待受理里面
更新记录到数据库
rs2.addnew
rs2("wxry")=realname
rs2("bxid")=request("bxid")
rs2("wxfk")=request("wxfk")
rs2("weixiu")=request("wxfk")
rs2("wxly")=request("wxly")
rs2("wxtime")=now()

rs2.update
rs2.close
conn.close
response.write"<script>alert('成功放弃维修! ');location.replace('index.asp?T=shouli)')</script>"
end if
end if
else
<%if userid="" then
      response.write"<script>alert('请先登录! ');location.replace('index.asp')</script>"
      end if%>
      <DIV class="mframe mR">
      <DIV class=tl></DIV>
      <DIV class=tr></DIV>
      <DIV class=tm>
      <SPAN class=tt>正在受理的工单</SPAN> </DIV>
      <DIV class=wrapper>
      <DIV class=ml></DIV>
      <DIV class=mr></DIV>
      <DIV class=mm><%call BWS_wxliebiao(wxlb,wxqy,realname,2)%>
</DIV></DIV>
      <DIV class=bl></DIV>
      <DIV class=br></DIV>
      <DIV class=bm></DIV></DIV>
      <DIV class="mframe mR">
      <DIV class=tl></DIV>
      <DIV class=tr></DIV>
      <DIV class=tm>
      <SPAN class=tt>等待受理的工单</SPAN> </DIV>
      <DIV class=wrapper>
      <DIV class=ml></DIV>
      <DIV class=mr></DIV>
      <DIV class=mm><%call BWS_wxliebiao(wxlb,wxqy,0,0)%>
</DIV></DIV>
      <DIV class=bl></DIV>
      <DIV class=br></DIV>
      <DIV class=bm></DIV></DIV>
    '//放弃维修
    Sub BWS_fangqi(j)
    If Not post_chk() Then
    Response.write "不许外部提交数据!"
    else
    if shenfen=1 or shenfen=3 then
    response.write "<div align=center>"
    Set rs = Server.CreateObject("ADODB.Recordset")
    sql="select * from baoxiu where id="&j&""
    set rs=conn.execute(sql)
    response.write "<form action=weixiu.asp?action=fq method=post><table width=""60%"" border=""0"" align=""center"" cellpadding=""0"" cellspacing=""0"">"
    response.write "<tr>"
    response.write "<td height=""35"" colspan=""2""><div align=""center""></div></td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td width=""40%"" height=""30""><div align=""center"">维修工单</div></td>"
    response.write "<td width=""60%""><div align=""center"">"&rs("bxid")&"</div></td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td width=""40%"" height=""30""><div align=""center"">维修人员</div></td>"
    response.write "<td width=""60%""><div align=""center"">"&rs("wxry")&"</div></td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td height=""30""><div align=""center"">放弃原因</div></td>"
    response.write "<td height=""50"">"
    response.write "<textarea name=""wxly"" id=""wxly"" cols=""45"" rows=""5""></textarea> <input type=""hidden"" name=""id"" value="""&j&""" />"
    response.write "<input type=""hidden"" name=""bxid"" value="""&rs("bxid")&""" />"
    response.write "<input type=""hidden"" name=""wxfk"" value=""0"" /></td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td height=""10"" colspan=""2""><div align=""center""></div></td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td colspan=""2"">"
    response.write "<div align=""center"">"
    response.write "<input type=""submit"" value=""提交"">"  
    response.write "</div></td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td height=""10"" colspan=""2""><div align=""center""></div></td>"
    response.write "</tr>"
    response.write "</table>"
    response.write "</form>"
    conn.close
    set conn=nothing
    response.write "</div>"
    else
    Response.write "没有权限!"
    end if
    end if
    end Sub
搜索更多相关主题的帖子: 维修 数据库 request 如何 
2012-03-01 23:00



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-362004-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.059653 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved