BLL/Views/Product/Search.cs

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

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

namespace BLL.Views.Product
{
    public class Search : UAP.Razor.Page
    {
        /// <summary>
        /// 搜索关键字
        /// </summary>
        protected string key = string.Empty;
        protected JSON[] Products = null;
        public override void OnLoad()
        {
            key = Request.QueryString.Get("key");
            Products = DataBase.getJson(string.Format(@"
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 and p.name like '%{0}%'", key));

            base.OnLoad();
        }
    }
}