BLL/Views/Product/Detail.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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


namespace BLL.Views.Product
{
    public class Detail : UAP.Razor.Page
    {

        protected JSON Product = null;
        protected JSON[] Product_Carousel = null
                        , Commends = null
                        , Attr_Groups = null
                        , Sigle_Attr_Groups = null;


        protected string A = "";
        public override void OnLoad()
        {

            Product = DataBase.Parameterization
                              .Include(Request.Params, "$")
                              .CheckNotNull("$")
                              .CheckType<int>("$")
                              .Rename("$", "productid")
                              .db_Query("select p.*,typename=t.name from ec_product p left join ec_product_type t on p.itype=t.id where p.id=@productid").getJson(0);

            Product_Carousel = DataBase.Parameterization
                              .Include(Request.Params, "$")
                              .CheckNotNull("$")
                              .CheckType<int>("$")
                              .Rename("$", "productid")
                              .db_Query("select * from ec_product_carousel where productid=@productid").getJson();

            Commends = DataBase.Parameterization
                               .Include(Request.Params, "$")
                               .CheckNotNull("$")
                               .CheckType<int>("$")
                               .Rename("$", "productid")
                               .db_Query(@"
select 
p.*
from ec_product p
left join ec_product_type t on p.itype=t.id
where t.id=(select itype from ec_product where id=@productid)").getJson();

            Attr_Groups = DataBase.getJson(string.Format(@"
select 
 attrid
,attrname=attr.name
,rel.productid
from ec_product_attr_rel  rel
left join ec_attr_type	  attr on rel.attrid=attr.id
where productid={0}  and isactive=1 group by attrid,attr.name,rel.productid", Request.QueryString.Get("$")));

            base.OnLoad();
        }