BLL/Views/Index.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using UAP;


namespace BLL.Views
{
    public class Index : UAP.Razor.Page
    {
        protected JSON[] NewProducts = null, Product_FirstTypes = null, Products = null;
        public override void OnLoad()
        {
            NewProducts = DataBase.getJson(@"
select  
 n.* 
,typename=t.name
from ec_product n
left join ec_product_type t on n.itype=t.id
where n.isnew=1  and n.isactive=1");
            Product_FirstTypes = DataBase.getJson("select * from ec_product_type where itype=1 and isactive=1");
            Products = DataBase.getJson(@"
select 
 p.* 
,typename=t.name
,t._sysid_
from ec_product p
left join ec_product_type t on p.itype=t.id
where p.isactive=1");



            base.OnLoad();
        }

        public void logout()
        {
            UAP.User.Logout();
        }

    }
}