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;}