File:vip-invoice.html
Method:query.table(columns,*where,*order,*top)
关键字 'ORDER' 附近有语法错误。 select * FROM usinvoice WHERE UserId= ORDER BY InvoiceId desc
数据库执行错误
xmls/member.xmls
...lick="ChoiceAddress('{*Fullname}','{*Address}','{*PostCode}','{*Mobile}','{*Country}','{*InvoiceId}')">修改地址</i>
<i onclick="javascript:window.location.href='javascript:delinvoice({@Invoiced});'">删除地址</i></p>
<span class="vpadsp poa disn"><img src="images/vpadds.png" alt=""></span>
</a>
</li>
"];
}
$return(@uaddresslist);
}


//会员中心用户发票信息
$sub vipUserInvoicelist(){
@queryaddress=$query(invoice,user);
@formatadd=[#
{@uaddress}
#];
@queryaddress[UserId]=$http.getSession(UserID);
@
tablect=@queryaddress.table(*,['UserId={*UserId}'],['InvoiceId desc']);
@uaddresslist=@tablect.format(@formatadd){
@Province=$var[Province];
@City=$var[City];
@adstatus=$var[Status];
@Invoiced=$var[InvoiceId];
@intype=$var[InvoiceType];
$if(@intype==0){
@intype=Ordinary invoice;
}
$if(@intype==1){
@intype=Value added invoice;
}
$if(@adstatus==1){
@uaddress=["
<li class="pull-left">
<a class="disb por" href="javascript:;">
<p>{*Title}</p>
<p>{*Identifier}</p>
<p>{*Bank}</p>
<p...