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