Admin/system/Order/List.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

[UAP.Role]
public partial class Order_List : UAP.UI.ListPage
{
    public Order_List()
    {
        this.setFilter("code", "packname", "stated", "usermobile");   
    }

    protected override string Table
    {
        get
        {
            return string.Format(@"(
select 
o.*
,packname=(
	select stuff(
	(
		select 
		'['+p.name+']'  
		from 
		ec_order_detail d 
		left join ec_product p  on d.productid=p.id
		where d.oid =o.id
		for xml path('')
	),1,0,'')
)
,img=(select img from ec_product where id =(select top 1 productid from ec_order_detail where oid=o.id))
,statedname=case stated when 0 then '待支付' when 1 then '已支付' when 2 then '已发货' else '确认收货' end
,username=u.name
,usermobile=u.mobile
from ec_order o
left join ec_users u on o.userid=u.id)_");
        }
    }
}