protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
LoadTheme(themecode, siteid, languagecode, pcode);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserMessage'");
type = Rint_Para("0");
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em>";
if (type == 0)
{
path += "<a href=\"" + URL("P_UserMessage", "0") + "\"><span>" + Tag("收件箱") + "</span></a>";
}
else
{
path += "<a href=\"" + URL("P_UserMessage", "1") + "\"><span>" + Tag("发件箱") + "</span></a>";
}
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserMessage'");
key = Rstring("key");
type_id = Rstring("type_id");
dateFrom = Rstring("dateFrom");
dateTo = Rstring("dateTo");
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
pageindex = RequestTool.RequestInt("page", 1);
if (type == 0)
{
where = "User_id_To=" + CurrentUser.id + "";
}
if (type == 1)
{
where = "User_id_From=" + CurrentUser.id + "";
}
if (key != "")
{
where += " and (Title like lbsql{'%" + key + "%'})";
}
if (type_id != "")
{
where += " and Message_Type_id = " + type_id;
}
if (dateFrom != "" && dateTo != "")
{
where += " and Time_Add>='" + FormatDate(lbsql_dateFrom) + "' and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'";
}
messages = B_Lebi_Message.GetList(where, "id desc", PageSize, pageindex);
int recordCount = B_Lebi_Message.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&type=" + type + "&type_id=" + type_id + "&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage);
NextPage = "?page=" + (pageindex + 1) + "&type=" + type + "&type_id=" + type_id + "&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "";
message_types = B_Lebi_Message_Type.GetList("Type_id_MessageTypeClass = 350", "id desc");
}
public override string ThemePageMeta(string code, string tag)
{
string str = "";
Lebi_Theme_Page theme_page = B_Lebi_Theme_Page.GetModel("Code='" + code + "'");
if (theme_page == null)
{
return("");
}
switch (tag.ToLower())
{
case "description":
if (Lang(theme_page.SEO_Description) == "")
{
str = Lang(SYS.Description);
}
else
{
str = Lang(theme_page.SEO_Description);
}
break;
case "keywords":
if (Lang(theme_page.SEO_Keywords) == "")
{
str = Lang(SYS.Keywords);
}
else
{
str = Lang(theme_page.SEO_Keywords);
}
break;
default:
if (Lang(theme_page.SEO_Title) == "")
{
if (keyword != "")
{
str = keyword + " - " + Tag("品牌列表");
}
else
{
str = Tag("品牌列表");
}
}
else
{
str = Lang(theme_page.SEO_Title);
}
break;
}
return(ThemePageMeta(code, tag, str));
}
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_SendFriend'");
id = Rint_Para("0");
product = GetProduct(id);
if (product.id == 0)
{
Response.Redirect(URL("P_404", ""));
Response.End();
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_Product", id) + "\"><span>" + Lang(product.Name) + "</span></a><em>»</em><a class=\"text\"><span>" + Tag("邮件分享") + "</span></a>";
}
/// <summary>
/// 编辑页面
/// </summary>
public void ThemePage_Edit()
{
int id = RequestTool.RequestInt("id", 0);
Lebi_Theme_Page model = B_Lebi_Theme_Page.GetModel(id);
if (model == null)
{
model = new Lebi_Theme_Page();
}
B_Lebi_Theme_Page.BindForm(model);
//model.Name = Language.RequestString("Name");
model.StaticPath = "/" + model.StaticPath;
model.StaticPath = ThemeUrl.CheckURL(model.StaticPath).TrimEnd('/');
if (model.id == 0)
{
if (!EX_Admin.Power("themepage_add", "添加页面"))
{
AjaxNoPower();
return;
}
B_Lebi_Theme_Page.Add(model);
id = B_Lebi_Theme_Page.GetMaxId();
string action = Tag("添加页面");
Log.Add(action, "ThemePage", model.id.ToString(), CurrentAdmin);
}
else
{
if (!EX_Admin.Power("themepage_edit", "编辑页面"))
{
AjaxNoPower();
return;
}
B_Lebi_Theme_Page.Update(model);
string action = Tag("编辑页面");
Log.Add(action, "ThemePage", model.id.ToString(), CurrentAdmin);
}
//更新模板中的生成路径
List <Lebi_Theme_Skin> pages = B_Lebi_Theme_Skin.GetList("Code='" + model.Code + "'", "");
foreach (Lebi_Theme_Skin page in pages)
{
page.PageName = model.PageName;
page.PageParameter = model.PageParameter;
page.StaticPageName = model.StaticPageName;
B_Lebi_Theme_Skin.Update(page);
}
//处理静态
ThemeUrl.CreateURLRewrite();
ShopCache.SetThemePage();
Response.Write("{\"msg\":\"OK\",\"id\":\"" + id + "\"}");
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
pageindex = RequestTool.RequestInt("page", 1);
LoadTheme(themecode, siteid, languagecode, pcode);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_News'");
node = Node("News");
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("Ê×Ò³") + "\"><span>" + Tag("Ê×Ò³") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_News", "") + "\"><span>" + Tag(node.Name) + "</span></a>";
string where = "Node_id=" + node.id + " and ','+Language_ids+',' like '%," + CurrentLanguage.id + ",%'";
pages = B_Lebi_Page.GetList(where, "Sort desc,id desc", PageSize, pageindex);
recordCount = B_Lebi_Page.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}", pageindex, PageSize, recordCount, CurrentLanguage);
FootPage = PageString;
NextPage = "?page=" + (pageindex + 1) + "";
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
LoadTheme(themecode, siteid, languagecode, pcode);
if (SYS.IsClosetuihuo == "1")
{
PageError();
}
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnApply'");
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturn", "" + id + "") + "\"><span>" + Tag("退货订单") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturnApply", "") + "\"><span>" + Tag("退货申请") + "</span></a>";
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnApply'");
id = Rint_Para("0");
order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + "");
if (order == null)
{
PageError();
}
if (order.User_id != CurrentUser.id)
{
PageError();
}
where = "Order_id=" + order.id + "";
order_products = B_Lebi_Order_Product.GetList(where, "id desc");
if (order.Supplier_id > 0)
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel(order.Supplier_id);
if (supplier != null)
{
shouhuoren = supplier.RealName;
shouhuodizhi = supplier.Address;
shouhuodianhua = supplier.Phone;
shouhuoyoubian = supplier.Postalcode;
}
}
else
{
Lebi_Express_Shipper shipper = B_Lebi_Express_Shipper.GetList("", "Sort desc", 1, 1).FirstOrDefault();
if (shipper != null)
{
shouhuoren = shipper.UserName;
shouhuodizhi = shipper.Address;
shouhuodianhua = shipper.Tel;
shouhuoyoubian = shipper.ZipCode;
}
}
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
LoadTheme(themecode, siteid, languagecode, pcode);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserQuestion'");
type = Rint_Para("0");
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a class=\"text\"><span>" + Tag("安全问题") + "</span></a>";
user_questions = B_Lebi_User_Question.GetList("", "Sort desc");
where = "User_id=" + CurrentUser.id + "";
user_answers = B_Lebi_User_Answer.GetList(where, "id asc", 20, 1);
recordCount = B_Lebi_User_Answer.Counts(where);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("seo_edit", "SEO设置"))
{
PageReturnMsg = PageNoPowerMsg();
}
key = RequestTool.RequestString("key");
string where = "";
if (key != "")
{
where = " (Code like lbsql{'%" + key + "%'} or Name like lbsql{'%" + key + "%'} or PageName like lbsql{'%" + key + "%'})";
}
models = B_Lebi_Theme_Page.GetList(where, "Sort desc,Code asc");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("seo_edit", "SEO设置"))
{
WindowNoPower();
}
int id = RequestTool.RequestInt("id", 0);
model = B_Lebi_Theme_Page.GetModel(id);
if (model == null)
{
model = new Lebi_Theme_Page();
model.Type_id_PublishType = 120;
}
}
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_BrandList'");
keyword = Rstring_Para("0");
pageindex = RequestTool.RequestInt("page", 1);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em>";
if (keyword == "")
{
path += "<a class=\"text\">" + Tag("品牌列表") + "</span></a>";
}
else
{
path += "<a href=\"" + URL("P_BrandList", "") + "\"><span>" + Tag("品牌列表") + "</span></a><em>»</em><a class=\"text\">" + keyword + "</span></a>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
int tid = RequestTool.RequestInt("tid", 0);
int id = RequestTool.RequestInt("id", 0);
if (RequestTool.GetConfigKey("OnlineFileEdit").Trim() != "1")
{
PageReturnMsg = PageNoEditMsg();
}
if (id == 0)
{
if (!EX_Admin.Power("theme_skin_add", "添加模板页面"))
{
PageReturnMsg = PageNoPowerMsg();
}
}
else
{
if (!EX_Admin.Power("theme_skin_edit", "编辑模板页面"))
{
PageReturnMsg = PageNoPowerMsg();
}
}
model = B_Lebi_Theme_Skin.GetModel(id);
if (model != null)
{
tid = model.Theme_id;
}
else
{
model = new Lebi_Theme_Skin();
}
theme = B_Lebi_Theme.GetModel(tid);
if (theme == null)
{
theme = new Lebi_Theme();
}
SkinContent = GetSkinStr(theme, model);
tpage = B_Lebi_Theme_Page.GetModel("Code='" + model.Code + "'");
if (tpage == null)
{
tpage = new Lebi_Theme_Page();
model.IsPage = 1;
}
}
override public string ThemePageMeta(string code, string tag)
{
string str = "";
Lebi_Theme_Page theme_page = B_Lebi_Theme_Page.GetModel("Code='" + code + "'");
if (theme_page == null)
{
return("");
}
switch (tag.ToLower())
{
case "description":
if (theme_page.SEO_Description != "")
{
str = theme_page.SEO_Description;
}
else
{
str = Lang(SYS.Description);
}
break;
case "keywords":
if (theme_page.SEO_Keywords != "")
{
str = theme_page.SEO_Keywords;
}
else
{
str = Lang(SYS.Keywords);
}
break;
default:
if (theme_page.SEO_Title != "")
{
str = theme_page.SEO_Title;
}
else
{
str = Tag(node.Name);
}
break;
}
return(ThemePageMeta(code, tag, str));
}
protected void Page_Load(object sender, EventArgs e)
{
key = RequestTool.RequestString("key");
string where = "";
if (key != "")
{
where = " (Code like lbsql{'%" + key + "%'} or Name like lbsql{'%" + key + "%'} or PageName like lbsql{'%" + key + "%'})";
}
models = B_Lebi_Theme_Page.GetList(where, "Sort desc,Code asc");
foreach (Lebi_Theme_Page p in models)
{
if (p.Name.Contains("[{\"") && Language.Content(p.Name, "CN") != "")
{
p.Name = Language.Content(p.Name, "CN");
B_Lebi_Theme_Page.Update(p);
}
}
}
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_NewsDetails'");
int id = Rint_Para("0");
node = Node("News");
page = B_Lebi_Page.GetModel(id);
if (page == null)
{
PageError();
}
else
{
page.Count_Views += 1;
B_Lebi_Page.Update(page);
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("Ê×Ò³") + "\"><span>" + Tag("Ê×Ò³") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_News", "") + "\"><span>" + Tag(node.Name) + "</span></a><em>»</em><a href=\"" + URL("P_NewsDetails", page.id) + "\"><span>" + page.Name + "</span></a>";
}
public void LoadPage()
{
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_Product'");
int id = Rint("id");
product = EX_Product.GetProduct(id);
if (product.id == 0)
{
Response.End();
}
Protype = B_Lebi_Pro_Type.GetModel(product.Pro_Type_id);
GetProWords();
supplier = B_Lebi_Supplier.GetModel(product.Supplier_id);
if (supplier == null)
{
supplier = new Lebi_Supplier();
}
product.IsSupplierTransport = supplier.IsSupplierTransport;
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
LoadTheme(themecode, siteid, languagecode, pcode);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserOrderDetails'");
id = Rint("id");
order = B_Lebi_Order.GetModel("(IsDel!=1 or IsDel is null) and User_id = " + CurrentUser.id + " and id = " + id + "");
if (order == null)
{
PageError();
}
if (order.User_id != CurrentUser.id)
{
PageError();
}
if (order.Type_id_OrderType == 212)
{
Response.Redirect(URL("P_UserReturnDetails", id));
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserOrders", "") + "\"><span>" + Tag("我的订单") + "</span></a><em>»</em><a href=\"" + URL("P_UserOrderDetails", id) + "\"><span>" + Tag("订单") + "：" + order.Code + "</span></a>";
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserOrderDetails'");
id = Rint_Para("0");
comments = B_Lebi_Comment.GetList("TableName='Order' and Keyid=" + order.id, "id desc");
transport_orders = B_Lebi_Transport_Order.GetList("Order_id=" + order.id, "id desc");
bills = B_Lebi_Bill.GetList("Order_id=" + order.id, "id desc");
order_products = B_Lebi_Order_Product.GetList("Order_id=" + order.id, "id desc");
pay = B_Lebi_Pay.GetModel(order.Pay_id);
if (pay == null)
{
pay = new Lebi_Pay();
}
if (order.OnlinePay_id > 0)
{
pay.Code = "OnlinePay";
}
}
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_ArticleDetails'");
id = Rint_Para("0");
parentnode = Node("Info");
nodes = B_Lebi_Node.GetList("Parentid=" + parentnode.id + " and ','+Language_ids+',' like '%," + CurrentLanguage.id + ",%'", "Sort desc");
page = B_Lebi_Page.GetModel(id);
if (page == null)
{
node = nodes.FirstOrDefault();
page = NodePage.GetPageByNode(node);
if (page == null)
{
PageError();
}
}
else
{
page.Count_Views += 1;
B_Lebi_Page.Update(page);
node = B_Lebi_Node.GetModel(page.Node_id);
}
string where = "Node_id=" + node.id + " and ','+Language_ids+',' like '%," + CurrentLanguage.id + ",%'";
PreviousPage = B_Lebi_Page.GetModel(where + " and Sort>=" + page.Sort + " and id>" + page.id + " order by Sort asc,id asc");
NextPage = B_Lebi_Page.GetModel(where + " and Sort<=" + page.Sort + " and id<" + page.id + " order by Sort desc,id desc");
if (PreviousPage == null)
{
PreviousPage = new Lebi_Page();
}
if (NextPage == null)
{
NextPage = new Lebi_Page();
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("Ê×Ò³") + "\"><span>" + Tag("Ê×Ò³") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_Article", "") + "\"><span>" + Tag(parentnode.Name) + "</span></a><em>»</em><a href=\"" + URL("P_Article", node.id) + "\"><span>" + node.Name + "</span></a><em>»</em><a href=\"" + URL("P_ArticleDetails", page.id) + "\"><span>" + page.Name + "</span></a>";
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
PageError();
}
LoadTheme(themecode, siteid, languagecode, pcode);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserOrderCancel'");
id = Rint("id");
order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + "");
if (order == null)
{
PageError();
}
if (order.User_id != CurrentUser.id)
{
PageError();
}
if (!Shop.Bussiness.Order.CancelOrder(order))
{
Response.Redirect(URL("P_UserOrders", ""));
}
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
LoadTheme(themecode, siteid, languagecode, pcode);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnShip'");
id = Rint("id");
tid = Rint("id");
order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + "");
if (order == null)
{
PageError();
}
if (order.User_id != CurrentUser.id)
{
PageError();
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturn", "" + id + "") + "\"><span>" + Tag("退货订单") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturnDetails", "" + id + "") + "\"><span>" + Tag("订单") + "：" + order.Code + "</span></a><em>»</em><a href=\"" + URL("P_UserReturnShip", "") + "\"><span>" + Tag("发货") + "</span></a>";
where = "Order_id=" + order.id + "";
order_products = B_Lebi_Order_Product.GetList(where, "id desc");
}
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_ShopSearch'");
keyword = RequestTool.RequestSafeString("keyword");
string key = RequestTool.RequestSafeString("key");
if (keyword == "" && key != "")
{
keyword = key;
}
sort = Rstring_Para("1");
area_id = RequestTool.RequestInt("area_id", 0);
id = 0;
where = "Supplier_Group_id in (select w.id from [Lebi_Supplier_Group] as w where w.type='supplier' or w.type='')";
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>";
if (keyword != "")
{
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 + "%'} or SubName like lbsql{'%" + keywords + "%'})";
}
else
{
wherekeyword += " and (Name like lbsql{'%" + keywords + "%'} or SubName like lbsql{'%" + keywords + "%'})";
}
}
}
}
else
{
wherekeyword = "(Name like lbsql{'%" + keyword + "%'} or SubName like lbsql{'%" + keyword + "%'})";
}
where = wherekeyword;
}
if (area_id > 0)
{
where += " and area_id in (" + EX_Area.Area_ids(area_id) + ")";
}
//SQLDataAccess.SQLPara sp = new SQLDataAccess.SQLPara(where, "id desc", "*");
shops = B_Lebi_Supplier.GetList(where, "id desc", PageSize, pageindex);
recordCount = B_Lebi_Supplier.Counts(where);
string url = URL("P_ShopSearch", keyword + "," + 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_ShopSearch", keyword + "," + sort + "," + (pageindex + 1) + "");
}
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) + "");
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
pageindex = RequestTool.RequestInt("page", 1);
LoadTheme(themecode, siteid, languagecode, pcode);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_Product'");
int id = Rint_Para("0");
product = EX_Product.GetProduct(id);
if (product.id == 0)
{
Response.Redirect(URL("P_404", ""));
Response.End();
}
int num = 0;
int Count_Views_Show = 0;
if (SYS.ClickFlag == "0")
{
int.TryParse(SYS.ClickNum1, out num);
Count_Views_Show = num;
}
else
{
int.TryParse(SYS.ClickNum2, out num);
Random r = new Random();
int c = r.Next(1, num);
Count_Views_Show = c;
}
string sql = "update [Lebi_Product] set Count_Views=Count_Views+1,Count_Views_Show=Count_Views_Show+" + Count_Views_Show + " where id=" + id + "";
Common.ExecuteSql(sql);
if (product.Product_id > 0)
{
sql = "update [Lebi_Product] set Count_Views=Count_Views+1,Count_Views_Show=Count_Views_Show+" + Count_Views_Show + " where Product_id=" + product.Product_id + "";
Common.ExecuteSql(sql);
}
int DT_id = ShopPage.GetDT();
if (DT_id > 0)
{
sql = "update [Lebi_DT_Product] set Count_Views=Count_Views+1,Count_Views_Show=Count_Views_Show+" + Count_Views_Show + " where DT_id = " + DT_id + " and Product_id=" + id + "";
Common.ExecuteSql(sql);
if (product.Product_id > 0)
{
Common.ExecuteSql("update [Lebi_DT_Product] set Count_Views=Count_Views+1,Count_Views_Show=Count_Views_Show+" + Count_Views_Show + " where DT_id = " + DT_id + " and Product_id=" + product.Product_id + "");
}
}
Protype = B_Lebi_Pro_Type.GetModel(product.Pro_Type_id);
images = EX_Product.ProductImages(product, CurrentTheme);
//===============================================================
//处理规格选项
//ProductProperty = Get_guige(product);
//处理规格选项结束
//==================================================================
//添加访问记录
int Product_id = product.Product_id == 0 ? product.id : product.Product_id;
EX_User.UserProduct_Edit(CurrentUser, Product_id, 1, 143, "", 0, "");
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em>";
if (product.Type_id_ProductType == 321)
{
path += "<a href=\"" + URL("P_LimitBuy", "") + "\"><span>" + Tag("限时抢购") + "</span></a><em>»</em>";
}
else if (product.Type_id_ProductType == 322)
{
path += "<a href=\"" + URL("P_GroupPurchase", "") + "\"><span>" + Tag("团购") + "</span></a><em>»</em>";
}
else if (product.Type_id_ProductType == 323)
{
path += "<a href=\"" + URL("P_Exchange", "") + "\"><span>" + Tag("积分换购") + "</span></a><em>»</em>";
}
else
{
if (Protype != null)
{
string[,] parr = Categorypath(Protype.id);
for (int i = 0; i <= parr.GetUpperBound(0); i++)
{
path += "<a href=\"" + URL("P_ProductCategory", "" + parr[i, 0] + "") + "\"><span>" + parr[i, 1] + "</span></a><em>»</em>";
}
}
}
path += "<a href=\"" + URL("P_Product", id) + "\"><span>" + Lang(product.Name) + "</span></a>";
GetProWords();
ProductStar = Convert.ToInt32(product.Star_Comment);
if (ProductStar > 5)
{
ProductStar = 5;
}
if (ProductStar < 0)
{
ProductStar = 0;
}
}
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_Exchange'");
list = Rstring_Para("0");
sort = Rstring_Para("1");
pageindex = RequestTool.RequestInt("page", 1);
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>";
where = ProductWhere + " and Type_id_ProductType = 323 and (Time_Start < '" + FormatTime(System.DateTime.Now) + "' and Time_Expired > '" + FormatTime(System.DateTime.Now) + "')";
if (sort == "1")
{
order = " Count_Sales desc"; ordertmp = "a";
}
else if (sort == "1a")
{
order = " Count_Sales 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 = " Count_Sales desc"; ordertmp = "a";
}
products = B_Lebi_Product.GetList(where, order, PageSize, pageindex);
recordCount = B_Lebi_Product.Counts(where);
HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple("?page={0}&sort=" + sort + "&list=" + list + "", pageindex, PageSize, recordCount, CurrentLanguage);
FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&sort=" + sort + "&list=" + list + "", pageindex, PageSize, recordCount, CurrentLanguage);
NextPage = "?page=" + (pageindex + 1) + "&sort=" + sort + "&list=" + list + "";
}
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_Brand'");
id = Rint_Para("0");
cid = Rstring_Para("1");
list = Rstring_Para("2");
sort = Rstring_Para("3");
pageindex = RequestTool.RequestInt("page", 1);
brand = B_Lebi_Brand.GetModel(id);
if (brand == null)
{
Response.Redirect(URL("P_BrandList", ""));
Response.End();
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_BrandList", "") + "\"><span>" + Tag("品牌列表") + "</span></a><em>»</em><a class=\"text\"><span>" + Lang(brand.Name) + "</span></a>";
//where = "Type_id_ProductStatus = 101 and Product_id=0 and Type_id_ProductType <> 323";
where = ProductWhere + " and Type_id_ProductType <> 323";
if (id > 0)
{
where += " and Brand_id = " + id + "";
}
if (cid != "")
{
where += " and " + Categorywhere(cid);
}
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 = "";
}
products = B_Lebi_Product.GetList(where, order, PageSize, pageindex);
recordCount = B_Lebi_Product.Counts(where);
HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple("?page={0}&id=" + id + "&cid=" + cid + "&sort=" + sort + "&list=" + list + "", pageindex, PageSize, recordCount, CurrentLanguage);
FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&id=" + id + "&cid=" + cid + "&sort=" + sort + "&list=" + list + "", pageindex, PageSize, recordCount, CurrentLanguage);
NextPage = "?page=" + (pageindex + 1) + "&id=" + id + "&cid=" + cid + "&sort=" + sort + "&list=" + list + "";
}
/// <summary>
/// 编辑页面
/// </summary>
public void Page_Edit()
{
int id = RequestTool.RequestInt("id", 0);
Lebi_Page model = B_Lebi_Page.GetModel(id);
if (model == null)
{
model = new Lebi_Page();
}
B_Lebi_Page.BindForm(model);
model.Language_ids = RequestTool.RequestSafeString("Language_ids");
model.Language = Language.LanuageidsToCodes(model.Language_ids);
if (model.id == 0)
{
if (!EX_Admin.Power("page_add", "添加结点内容"))
{
AjaxNoPower();
return;
}
B_Lebi_Page.Add(model);
id = B_Lebi_Page.GetMaxId();
string action = Tag("添加结点内容");
string description = model.Name;
Log.Add(action, "Page", id.ToString(), CurrentAdmin, description);
}
else
{
if (!EX_Admin.Power("page_edit", "编辑结点内容"))
{
AjaxNoPower();
return;
}
B_Lebi_Page.Update(model);
string action = Tag("编辑结点内容");
string description = model.Name;
Log.Add(action, "Page", id.ToString(), CurrentAdmin, description);
}
//=========================================
//处理静态页面
Lebi_Node node = B_Lebi_Node.GetModel(model.Node_id);
Lebi_Theme_Page themepage;
if (node.Code == "About")
{
themepage = B_Lebi_Theme_Page.GetModel("Code='P_About'");
}
else if (node.Code == "News")
{
themepage = B_Lebi_Theme_Page.GetModel("Code='P_NewsDetails'");
}
else if (node.Code == "Help")
{
themepage = B_Lebi_Theme_Page.GetModel("Code='P_Help'");
}
else
{
themepage = B_Lebi_Theme_Page.GetModel("Code='P_ArticleDetails'");
}
if (themepage.Type_id_PublishType == 122)//静态发布页面
{
if (node.Code == "Help")
{
PageStatic.Greate_Help(themepage);
}
else
{
PageStatic.Greate_InfoPage(model, themepage);
}
}
ImageHelper.LebiImagesUsed(model.ImageOriginal, "page", id);
Response.Write("{\"msg\":\"OK\",\"id\":\"" + id + "\"}");
}
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_Help'");
id = Rint_Para("0");
pageid = Rint_Para("1");
type = Rstring("type");
parentnode = Node("Help");
nodes = B_Lebi_Node.GetList("Parentid=" + parentnode.id + " and ','+Language_ids+',' like '%," + CurrentLanguage.id + ",%'", "Sort desc");
if (id == 0 && type != "")
{
node = new Lebi_Node();
if (type == "agreement")
{
Name = Tag("注册协议");
Content = Lang(SYS.ServiceP).Replace("\n", "<br/>");
}
node.Name = Name;
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_Help", "") + "\"><span>" + Tag(parentnode.Name) + "</span></a><em>»</em><a class=\"text\"><span>" + Tag(Name) + "</span></a>";
}
else
{
node = B_Lebi_Node.GetModel(id);
if (node == null)
{
node = nodes.FirstOrDefault();
if (node == null)
{
node = new Lebi_Node();
//PageError();
}
else
{
id = node.id;
}
}
//else
//{
// if (node.id == id)
// {
// node = nodes.FirstOrDefault();
// }
//}
pages = B_Lebi_Page.GetList("Node_id=" + node.id + "", "id desc");
if (pages == null)
{
pages = new List <Lebi_Page>();
}
path = "<a href=\"" + CurrentLanguage.Path + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_Help", "") + "\"><span>" + Tag(parentnode.Name) + "</span></a>";
page = B_Lebi_Page.GetModel("id=" + pageid + "");
if (page == null)
{
page = pages.FirstOrDefault();
if (pages.FirstOrDefault() == null)
{
pageid = 0;
}
else
{
pageid = page.id;
}
}
else
{
path += "<em>»</em><a href=\"" + URL("P_Help", node.id) + "\"><span>" + node.Name + "</span></a><em>»</em><a class=\"text\"><span>" + page.Name + "</span></a>";
}
//Help_Content.pages = pages;
}
}
public void CreatePage()
{
int id = RequestTool.RequestInt("id", 0);
string languageid = RequestTool.RequestString("Language");
Lebi_Theme_Page model = B_Lebi_Theme_Page.GetModel(id);
string Path = "";
if (model == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
Path = model.StaticPath;
string urlpath = "http://" + HttpContext.Current.Request.Url.Authority + WebPath;
//string port=
List <Lebi_Language> langs;
if (languageid == "")
{
langs = Language.AllLanguages();
}
else
{
langs = B_Lebi_Language.GetList("id in (lbsql{" + languageid + "})", "");
}
foreach (Lebi_Language lang in langs)
{
Lebi_Theme theme = B_Lebi_Theme.GetModel(lang.Theme_id);
if (theme == null)
{
Response.Write("{\"msg\":\"" + Tag("语言与模板关联错误") + "\"}");
return;
}
}
switch (model.Code)
{
case "P_About":
P_About(langs, model, urlpath);
break;
case "P_ArticleDetails":
P_ArticleDetails(langs, model, urlpath);
break;
case "P_Help":
P_Help(langs, model, urlpath);
break;
case "P_NewsDetails":
P_NewsDetails(langs, model, urlpath);
break;
case "P_Product":
P_Product(langs, model, urlpath);
break;
default:
OnePage(langs, model, urlpath);
break;
}
}