{sdcms:rs field="id,orderid,(select top 1 username from sd_user where id=userid) as username,totalmoney,floatmoney,ispay,postway,createdate,isover,content,remark" table="sd_user_order" order="id desc" where="1=1 [sqlwhere][wherekey]" pagesize="20" isadminurl="0"} {rs:eof} {/rs:eof} {/sdcms:rs}

	订单编号	用户名	商品金额	浮动金额	付款状态	发货状态	下单日期	订单状态	管理
没有资料
	{$rs[orderid]}	{$rs[username]}	{sdcms.getmoney($rs[totalmoney])}	{sdcms.getmoney($rs[floatmoney])}	{if $rs[ispay]=0}未付款　[付款]{else}已付款{/if}	{sdcms.iif($rs[postway]=0,"未发货","已发货")}{if $rs[ispay]=1 and $rs[postway]=0}　[发货]{/if}	{$rs[createdate]}	{sdcms.iif($rs[isover]=0,"未完成","已完成")}	查看/编辑订单　删除

{showpage}