ASP.NET动态属性筛选和分页绑定

2019-11-14 15:47:51

字体：大中小

来源：转载

供稿：网友

分页控件为：aspNetPager.dll

我们先建立一个产品属性名称表

CREATE TABLE PRoductAttr(    [ID] [int] IDENTITY(1,1) NOT NULL primary key,    [ParentID] [int] NULL,    [Kind] [int] NULL,    [CNName] [nvarchar](50) NOT NULL,    [ENName] [nvarchar](50) NOT NULL,    [Sort] [int] NOT NULL,    [AddTime] [datetime],)

再建一个属性内容表

CREATE TABLE ProductAttrInfo(    [ID] [int] IDENTITY(1,1) NOT NULL primary key,    [ParentID] [int] NULL,    [CNName] [nvarchar](50) NOT NULL,    [Sort] [int] NOT NULL,    [AddTime] [datetime] NOT NULL,    [Color] [nvarchar](50) NULL,)

产品表叫Product

页面呈现效果为：

其中的产品分类、形状、其他为动态的产品属性名称，对象相关的属性内容。

我们首页要把相关的内容绑定，然后再根据传参，把相关的属性编号和内容编号，通过正则的方式找出来，然后把当前也是和属性内容的ID找出来，方便我们查询产品。

/// <summary>/// 通过正则，把相关的属性ID拿到，然后判断属性名称ID的值即为属性值的ID值/// </summary>/// <param name="ids"></param>/// <returns></returns>protected int getAttrSql(int ids){    int value = 0;    string url = Request.Url.ToString().ToLower();    if (url.IndexOf("?") >= 0)    {        string index = url.Remove(0, url.IndexOf("?") + 1);        string para = index.Replace("?", "");        //切割成一个一个的参数并转换成SQL语句        string[] ps = para.Split('&');        string sql = "";        for (int i = 0; i < ps.Length; i++)        {            string s = ps[i];            //检查参数是否是p/d*=/d*开头的，如果是则认为这个参数是属性的参数            if (System.Text.RegularExpressions.Regex.IsMatch(s, @"p/d{1,}=/d{1,}"))            {                //去掉p切割成数字                string[] pp = s.Replace("p", "").Split('=');                int c = int.Parse(pp[0].ToString());                if (c == ids)                {                    value = int.Parse(pp[1].ToString());                    break;                }            }        }    }    return value;}

/// <summary>/// 绑定相关属性名称和内容，其中参数one和two，我这里是一级二级产品编号，可以忽略，ParentID为一级产品分类的ID，Kind为二级产品分类的ID/// </summary>/// <param name="one"></param>/// <param name="two"></param>public void BindAttrInfo(Model.ProductType one, Model.ProductType two){    StringBuilder sb = new StringBuilder();    //if (two != null)    //{    //    List<Model.ProductAttr> list = new BLL.ProductAttr().GetList(0, "CNName,ID", "ParentID=" + one.ID + " and Kind=" + two.ID + "", "Sort desc,AddTime desc");    //    foreach (Model.ProductAttr l in list)    //    {    //        sb.AppendFormat("<dl class=/"clearfix/"><dt>{0}</dt>", l.CNName);    //        List<Model.ProductAttrInfo> list2 = new BLL.ProductAttrInfo().GetList(0, "CNName,ID", "Pid=" + l.ID + "", "Sort desc,AddTime desc");    //        if (list2.Count > 0)    //        {    //            sb.AppendFormat("<dd><a href=/"{0}/" {1}>全部</a>", getUrl("p" + l.ID.Value, ""), getAttrSql(l.ID.Value) <= 0 ? "class=/"cur/"" : "");    //            foreach (Model.ProductAttrInfo l2 in list2)    //            {    //                sb.AppendFormat("<a href=/"{0}/" {1}>{2}</a>", getUrl("p" + l.ID.Value, l2.ID.Value.ToString()), getAttrSql(l.ID.Value) == l2.ID.Value ? "class=/"cur/"" : "", l2.CNName);    //            }    //            sb.AppendFormat("</dd>");    //        }    //        sb.Append("</dl>");    //    }    //}    //else    //{    List<Model.ProductType> twoType = new BLL.ProductType().GetList(0, "CNName,ID", "IsPass=1 and Kind=" + one.ID + "", "Sort desc,AddTime desc");    if (twoType.Count > 0)    {        sb.AppendFormat("<dl class=/"clearfix/"><dt>产品分类</dt><dd>");        sb.AppendFormat("<a {1} href=/"/products/?ParentID={0}/">全部</a>", one.ID, Kind <= 0 ? "class=/"cur/"" : "");        foreach (Model.ProductType l in twoType)        {            sb.AppendFormat("<a href=/"/products/?ParentID={0}&Kind={1}/" {3}>{2}</a>", one.ID.Value, l.ID.Value, l.CNName, Kind == l.ID.Value ? "class=/"cur/"" : "");        }        sb.AppendFormat("</dd></dl>");    }    List<Model.ProductAttr> list = new BLL.ProductAttr().GetList(0, "CNName,ID", "ParentID=" + one.ID + " and Kind=0", "Sort desc,AddTime desc");    foreach (Model.ProductAttr l in list)    {        sb.AppendFormat("<dl class=/"clearfix/"><dt>{0}</dt>", l.CNName);        List<Model.ProductAttrInfo> list2 = new BLL.ProductAttrInfo().GetList(0, "CNName,ID", "Pid=" + l.ID + "", "Sort desc,AddTime desc");        if (list2.Count > 0)        {            sb.AppendFormat("<dd><a href=/"{0}/" {1}>全部</a>", getUrl("p" + l.ID.Value, ""), getAttrSql(l.ID.Value) <= 0 ? "class=/"cur/"" : "");            foreach (Model.ProductAttrInfo l2 in list2)            {                sb.AppendFormat("<a href=/"{0}/" {1}>{2}</a>", getUrl("p" + l.ID.Value, l2.ID.Value.ToString()), getAttrSql(l.ID.Value) == l2.ID.Value ? "class=/"cur/"" : "", l2.CNName);            }            sb.AppendFormat("</dd>");        }        sb.Append("</dl>");    }    // }    Lit_ProductAttrList.Text = sb.ToString();}

/// <summary>/// 绑定产品/// </summary>public void BindProducts(){    string where = "ParentID=" + ParentID + "";    if (Kind > 0)    {        where += " and Kind=" + Kind + "";        where += GetWhereAttr();    }    else    {
                where += GetWhereAttr();    }    string strOrder = "Sort desc,AddTime desc";    if (OrderBy == 1)    {        strOrder = "SaleNum desc,Sort desc,AddTime desc";    }    else if (OrderBy == 2)    {        strOrder = "SalPrice,Sort desc,AddTime desc";    }    Model.PageData<Model.Product> data = new BLL.Product().GetList(20, base.PageIndex, "", where, strOrder);    repList.DataSource = data.DataSoure;    repList.DataBind();    pgServer.RecordCount = data.Count;    pgServer.UrlRewritePattern = getUrl("1", "1").Replace("#pro-list", "") + "&page={0}#pro-list";    pgServer.PageSize = 20;    AllCount = data.Count;    AllPage = data.PageCount;    ThisPage = base.PageIndex;    if (ThisPage < 1)    {        ThisPage = 1;    }    if (AllPage == 0)    {        ThisPage = 0;    }    pgServer.DataBind();}

/// <summary>/// 获取Url/// </summary>/// <param name="name"></param>/// <param name="value"></param>/// <returns></returns>protected string getUrl(string name, string value){    string url = System.Text.RegularExpressions.Regex.Replace(Request.Url.Query.Trim(), @"^/?", "");    url = System.Text.RegularExpressions.Regex.Replace(url, "^" + name + "=.*?&|" + name + "=.*?&", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase);    url = System.Text.RegularExpressions.Regex.Replace(url, "&{0,1}" + name + "=.*", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase);    url = System.Text.RegularExpressions.Regex.Replace(url, "^page=.*?&|page=.*?&", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase);    url = System.Text.RegularExpressions.Regex.Replace(url, "&{0,1}page=.*", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase);    if (url.Trim() == "")    {        return "/products/?" + name + "=" + value + "#pro-list";    }    return getReplaceUrl("/products/?" + name + "=" + value + "&" + url.Replace("#pro-list", "") + "#pro-list", "key");}/// <summary>/// 获取Url/// </summary>/// <param name="name"></param>/// <param name="value"></param>/// <returns></returns>protected string getReplaceUrl(string url, string name){    url = System.Text.RegularExpressions.Regex.Replace(url, "^" + name + "=.*?&|" + name + "=.*?&", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase);    url = System.Text.RegularExpressions.Regex.Replace(url, "^page=.*?&|page=.*?&", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase);    url = System.Text.RegularExpressions.Regex.Replace(url, "&{0,1}page=.*", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase);    return url;}

/// <summary>/// 获取属性条件-绑定/// </summary>/// <returns></returns>protected string GetWhereAttr(string where){    string value = "";    string url = Request.Url.ToString().ToLower();    if (url.IndexOf("?") >= 0)    {        string index = url.Remove(0, url.IndexOf("?") + 1);        string para = index.Replace("?", "");        //切割成一个一个的参数并转换成SQL语句        string[] ps = para.Split('&');        string sql = "";        for (int i = 0; i < ps.Length; i++)        {            string s = ps[i];            //检查参数是否是p/d*=/d*开头的，如果是则认为这个参数是属性的参数            if (System.Text.RegularExpressions.Regex.IsMatch(s, @"p/d{1,}=/d{1,}"))            {                //去掉p切割成数字                string[] pp = s.Replace("p", "").Split('=');                int c = int.Parse(pp[1].ToString());                //c为属性内容的编号，根据程序自己做判断            }        }    }    return value;}