Admin/system/Logistics/shipping_temp.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 Logistics_shipping_temp : UAP.UI.ListPage
{

    public Logistics_shipping_temp()
    {
        this.setFilter("name");
    }

    protected override string Table
    {
        get
        {
            return string.Format(@"(
select 
t.*
,areas=(select stuff((select ','+a.name from ec_shipping_temp_area ta  left join uap_area a on ta.areaid=a.id where tempid=t.id for xml path('')),1,1,''))
,opname=r.name 
from ec_shipping_temp t 
left join uap_role r on t.opid=r.id)_");
        }
    }
}