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;
SQLDataAccess.SQLPara sp = new SQLDataAccess.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");
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 ((" + wherekeyword + ") or Number like lbsql{'%" + keyword + "%'} or Code like lbsql{'%" + keyword + "%'})";
}
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 = "";
}
SQLDataAccess.SQLPara sp = new SQLDataAccess.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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("product_batch_edit", "批量编辑"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
key = RequestTool.RequestString("key");
Pro_Type_id = RequestTool.RequestString("Pro_Type_id");
status = RequestTool.RequestInt("status", 0);
brand = RequestTool.RequestInt("brand", 0);
tag = RequestTool.RequestInt("tag", 0);
dateFrom = RequestTool.RequestString("dateFrom");
dateTo = RequestTool.RequestString("dateTo");
OrderBy = RequestTool.RequestString("OrderBy");
lang = RequestTool.RequestString("lang");
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
Type_id_ProductType = RequestTool.RequestInt("Type_id_ProductType", 320);
if (lang == "")
{
lang = "CN";
}
string where = "Product_id=0";
if (Pro_Type_id != "")
{
where += " and Pro_Type_id in (" + Shop.Bussiness.EX_Product.Categoryid(Pro_Type_id) + ")";
}
if (status > 0)
{
where += " and Type_id_ProductStatus=" + status + "";
}
if (Type_id_ProductType > 0)
{
where += " and Type_id_ProductType=" + Type_id_ProductType + "";
}
if (tag > 0)
{
if (DataBase.DBType == "sqlserver")
{
where += " and Charindex('" + tag + "',Pro_Tag_id)>0";
}
if (DataBase.DBType == "access")
{
where += " and Instr(Pro_Tag_id,'" + tag + "')>0";
}
}
if (brand > 0)
{
where += " and Brand_id=" + brand + "";
}
if (key != "")
{
where += " and (Name like lbsql{'%" + key + "%'} or Number like lbsql{'%" + key + "%'})";
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)";
}
if (CurrentAdmin.Pro_Type_ids != "")
{
string[] ids = CurrentAdmin.Pro_Type_ids.Split(',');
string sonwhere = "";
foreach (string id in ids)
{
sonwhere += " or Path like '%," + id + ",%'";
}
sonwhere = "select id from Lebi_Pro_Type where id in (" + CurrentAdmin.Pro_Type_ids + ")" + sonwhere;
where += " and Pro_Type_id in (" + sonwhere + ")";
}
if (OrderBy == "StatusDesc")
{
orderstr = " Type_id_ProductStatus desc";
}
else if (OrderBy == "StatusAsc")
{
orderstr = " Type_id_ProductStatus asc";
}
else if (OrderBy == "ViewsDesc")
{
orderstr = " Count_Views desc";
}
else if (OrderBy == "ViewsAsc")
{
orderstr = " Count_Views asc";
}
else if (OrderBy == "SalesDesc")
{
orderstr = " Count_Sales desc";
}
else if (OrderBy == "SalesAsc")
{
orderstr = " Count_Sales asc";
}
else if (OrderBy == "CountDesc")
{
orderstr = " Count_Stock desc";
}
else if (OrderBy == "CountAsc")
{
orderstr = " Count_Stock asc";
}
else if (OrderBy == "Price_CostDesc")
{
orderstr = " Price_Cost desc";
}
else if (OrderBy == "Price_CostAsc")
{
orderstr = " Price_Cost asc";
}
else if (OrderBy == "PriceDesc")
{
orderstr = " Price desc";
}
else if (OrderBy == "PriceAsc")
{
orderstr = " Price asc";
}
else if (OrderBy == "FreezeDesc")
{
orderstr = " Count_Freeze desc";
}
else if (OrderBy == "FreezeAsc")
{
orderstr = " Count_Freeze asc";
}
else if (OrderBy == "SortDesc")
{
orderstr = " Sort desc";
}
else if (OrderBy == "SortAsc")
{
orderstr = " Sort asc";
}
else
{
orderstr = " id desc";
}
SQLDataAccess.SQLPara sp = new SQLDataAccess.SQLPara(where, orderstr, "*");
models = B_Lebi_Product.GetList(sp, PageSize, page);
int recordCount = B_Lebi_Product.Counts(sp);
PageString = Pager.GetPaginationString("?page={0}&brand=" + brand + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&key=" + key + "&lang=" + lang + "&OrderBy=" + OrderBy + "&Pro_Type_id=" + Pro_Type_id + "&status=" + status + "&Type_id_ProductType=" + Type_id_ProductType + "&tag=" + tag, page, PageSize, recordCount);
userlevels = B_Lebi_UserLevel.GetList("", "Grade asc");
}
