public void LoadPage() { LoadTheme(); PageSize = RequestTool.RequestInt("Count", 20); id = RequestTool.RequestInt("id", 0); tag = RequestTool.RequestString("tag"); tag = tag.Replace(",", ","); if (tag == "" || tag == null) { tag = "NO TAGS"; } string where = ""; if (tag.IndexOf(",") > -1) { string[] tagsArr; tagsArr = tag.Split(new char[1] { ',' }); foreach (string tags in tagsArr) { if (where == "") { where = "Name like lbsql{'%" + tags + "%'}"; } else { where += " or Name like lbsql{'%" + tags + "%'}"; } } } else { where = "Name like lbsql{'%" + tag + "%'}"; } where = " (" + where + ") and " + ProductWhere; //Response.Write(where); //Response.End(); //return; LB.DataAccess.SQLPara sp = new LB.DataAccess.SQLPara(where, " Sort desc,id desc", "*"); products = B_Lebi_Product.GetList(sp, PageSize, pageindex); }
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { LoadTheme(themecode, siteid, languagecode, pcode); CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_Search'"); keyword = Rstring_Para("0"); list = Rstring_Para("1"); sort = Rstring_Para("2"); pageindex = Rint_Para("3", 1); id = Rint_Para("4"); pid = Rint_Para("5"); path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a class=\"text\"><span>" + Tag("商品搜索") + "</span></a><em>»</em><a class=\"text\"><span>“" + keyword + "”</span></a>"; where = ProductWhere + " and Type_id_ProductType <> 323"; if (keyword != "") { //增加空格划词搜索 by kingdge 2013-09-18 string wherekeyword = ""; if (keyword.IndexOf(" ") > -1) { string[] keywordsArr; keywordsArr = keyword.Split(new char[1] { ' ' }); foreach (string keywords in keywordsArr) { if (keywords != "") { if (wherekeyword == "") { wherekeyword = "Name like lbsql{'%" + keywords + "%'}"; } else { wherekeyword += " and Name like lbsql{'%" + keywords + "%'}"; } } } } else { wherekeyword = "Name like lbsql{'%" + keyword + "%'}"; } where += " and ("; where += " (" + wherekeyword + ") or Number like lbsql{'%" + keyword + "%'} or Code like lbsql{'%" + keyword + "%'}"; if (keyword.Length >= 3) { List <Lebi_Product> parents = B_Lebi_Product.GetList("(IsDel!=1 or IsDel is null) and Product_id >0 and Name like lbsql{'%" + keyword + "%'} or Number like lbsql{'%" + keyword + "%'} or Code like lbsql{'%" + keyword + "%'}", ""); if (parents.Count > 0) { string ids = ""; foreach (Lebi_Product parent in parents) { ids += parent.Product_id + ","; } ids = ids.Substring(0, ids.Length - 1); if (ids != "") { where += " or id in(" + ids + ")"; } } } where += " )"; } if (id > 0) { where += " and " + CategoryWhere(id); } if (pid > 0) { where += " and Brand_id=" + pid + ""; } if (sort == "1") { order = " Count_Sales_Show desc"; ordertmp = "a"; } else if (sort == "1a") { order = " Count_Sales_Show asc"; ordertmp = ""; } else if (sort == "2") { order = " Price desc"; ordertmp = "a"; } else if (sort == "2a") { order = " Price asc"; ordertmp = ""; } else if (sort == "3") { order = " Count_Comment desc"; ordertmp = "a"; } else if (sort == "3a") { order = " Count_Comment asc"; ordertmp = ""; } else if (sort == "4") { order = " Time_Add desc"; ordertmp = "a"; } else if (sort == "4a") { order = " Time_Add asc"; ordertmp = ""; } else if (sort == "5") { order = " Count_Views_Show desc"; ordertmp = "a"; } else if (sort == "5a") { order = " Count_Views_Show asc"; ordertmp = ""; } else if (sort == "6") { order = " Count_Stock desc"; ordertmp = "a"; } else if (sort == "6a") { order = " Count_Stock asc"; ordertmp = ""; } else { order = " Sort desc,id desc"; ordertmp = ""; } LB.DataAccess.SQLPara sp = new LB.DataAccess.SQLPara(where, order, "*"); products = B_Lebi_Product.GetList(sp, PageSize, pageindex); recordCount = B_Lebi_Product.Counts(sp); string url = URL("P_Search", keyword + "," + list + "," + sort + ",{0}"); HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple(url, pageindex, PageSize, recordCount, CurrentLanguage); FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, pageindex, PageSize, recordCount, CurrentLanguage); NextPage = URL("P_Search", keyword + "," + list + "," + sort + "," + (pageindex + 1) + ""); }