帮我翻译下这几条ASP代码

来源:百度知道 编辑:UC知道 时间:2024/05/16 12:55:02
<%
user_id=request("user_id")
order_number=request("order_number")
sql="select * from 56770_orders where order_zt=false or order_zf=false and user_id<>'' "
if user_id<>"" then sql=sql + " and user_id='"&user_id&"'"
if order_number<>"" then sql=sql + " and order_number like '%"&order_number&"%'"
sql=sql + " order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open sql, conn, 3, 3
if rs.eof then
%>



<!--#include file="conn.asp"-->

if session("admin_name")="" then
response.redirect "default.asp"
end if

<form name="searchorders" method="post" action="orders_oldlist.asp">
<input type="text"

1、user_id=request("user_id")获取会员ID
order_number=request("order_number")获取订单号 再根据SQL语句进行查询,查询条件是状态为false、支付为false、还有会员id不能为空。
2、session("admin_name")="" 首先判断用户是否已经登陆没,没救跳转首页。下面那是个表单,一个text,还有个Submit提交按钮,要是点提交就跳转到orders_oldlist.asp这个页面进行处理。
基本先这些,有什么编程疑难问题都可以一起探讨!

翻译是个打字的累活儿 呵呵
<%
user_id=request("user_id") '获取参数userid
order_number=request("order_number") '获取订单号
sql="select * from 56770_orders where order_zt=false or order_zf=false and user_id<>'' " '构造查询sql语句开始
if user_id<>"" then sql=sql + " and user_id='"&user_id&"'" '如果user_id不为空 则继续构造sql语句 增加user_id条件
if order_number<>"" then sql=sql + " and order_number like '%"&order_number&"%'" '如果订单好不为空则继续构造sql语句 增加订单号条件
sql=sql + " order by id desc" '继续构造sql语句,增加排序规则 以id降序排列