KesionEshop V9.0x 订单查询(shop/myorder.asp)无法查询团购订单的修正。-领先建站CMS提供服务商我们专注于CMS建站产品的研发

2191 查看	1 回复

主题：KesionEshop V9.0x 订单查询(shop/myorder.asp)无法查询团购订单的修正。 [收藏主题]

科汛官方当前离线

47268 主题	145 广播	405 粉丝

级别:管理员

用户积分:101604 分
登录次数:7935 次
注册时间:2006/12/7
最后登录:2023/12/14
创始人

科汛官方发表于：2013/5/13 11:04:08 | 只看该作者查看该作者主题楼主

有课程找生源就上科汛课堂街

出错提示：

错误 '80020009'

/shop/myorder.asp，行 274

解决方法：

打开 shop/myorder.asp 找到 274 行,如下代码

OrderDetailStr=OrderDetailStr & " <td width='*'><a href='" & KS.Setting(3) & "item/show.asp?m=5&d=" & RSi("proid") & "' target='_blank'>" & Conn.execute("select top 1 title from ks_product where id=" & rsi("proid"))(0)

修改为：

If rs("OrderType")=1 Then
  OrderDetailStr=OrderDetailStr & " <td width='*'><a href='" & KS.Setting(3) & "shop/groupbuyshow.asp?id=" & RSi("proid") & "' target='_blank'>" & Conn.execute("select top 1 subject from ks_groupbuy where id=" & rsi("proid"))(0)
  Else
  OrderDetailStr=OrderDetailStr & " <td width='*'><a href='" & KS.Setting(3) & "item/show.asp?m=5&d=" & RSi("proid") & "' target='_blank'>" & Conn.execute("select top 1 title from ks_product where id=" & rsi("proid"))(0)
  End If

再往下找到306行左右，如下代码：

OrderDetailStr=OrderDetailStr & " <td width='45' align=center>"& Conn.execute("select unit from ks_product where id=" & rsi("proid"))(0) & "</td> <td width='55' align='center'>" & rsi("amount") &"</td> "

修改为

  If RS("OrderType")="1" Then
  OrderDetailStr=OrderDetailStr & " <td width='45' align=center>件</td>"
  Else
  OrderDetailStr=OrderDetailStr & " <td width='45' align=center>"& Conn.execute("select unit from ks_product where id=" & rsi("proid"))(0) & "</td>"
   End If
  OrderDetailStr=OrderDetailStr & "<td width='55' align='center'>" & rsi("amount") &"</td>"

KesionCMS,,

做官网就用科汛智能建站系统!