/// <summary>
/// 检查购物车是否满足代金券使用条件
/// </summary>
/// <param name="basket"></param>
/// <param name="card"></param>
/// <returns></returns>
public static bool CheckCard(Basket basket, Lebi_Card card)
{
if (card.Time_Begin > System.DateTime.Now)
{
return(false);
}
if (card.Time_End <= System.DateTime.Now)
{
card.Type_id_CardStatus = 204;
B_Lebi_Card.Update(card);
return(false);
}
if ((basket.Money_Product - basket.Money_Cut) < card.Money_Buy)
{
return(false);
}
if (card.Pro_Type_ids == "")
{
return(true);
}
foreach (Lebi_User_Product p in basket.Products)
{
Lebi_Product pro = B_Lebi_Product.GetModel(p.Product_id);
Lebi_Pro_Type type = EX_Product.TopProductType(pro);
if (("," + card.Pro_Type_ids + ",").Contains("," + type.id + ","))
{
return(true);
}
}
return(false);
}
private string CreateProductTypeSelect(int id)
{
string str = "<select id=\"ProductType_" + id + "\" name=\"ProductType_" + id + "\" shop=\"true\" onchange=\"SelectProductType('ProductType_" + id + "');\">";
Lebi_Pro_Type area = B_Lebi_Pro_Type.GetModel(id);
if (area == null)
{
return("");
}
List <Lebi_Pro_Type> models = B_Lebi_Pro_Type.GetList("Parentid=" + area.Parentid + "", "Sort desc");
if (models.Count == 0)
{
return("");
}
foreach (Lebi_Pro_Type model in models)
{
if (id == model.id)
{
str += "<option value=\"" + model.id + "\" selected>" + Lang(model.Name) + "</option>";
}
else
{
str += "<option value=\"" + model.id + "\">" + Lang(model.Name) + "</option>";
}
}
str += "</select> ";
str = CreateProductTypeSelect(area.Parentid) + str;
return(str);
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
int id = Rint_Para("0");
product = GetProduct(id);
if (product.id == 0)
{
Response.Redirect(URL("P_404", ""));
Response.End();
}
PageSize = 20;
pro_type = B_Lebi_Pro_Type.GetModel(product.Pro_Type_id);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em>";
if (pro_type != null)
{
string[,] parr = Categorypath(pro_type.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", product.id) + "\"><span>" + Lang(product.Name) + "</span></a><em>»</em>";
path += "<a><span>" + Tag("商品咨询") + "</span></a>";
}
/// <summary>
/// 下载商品分类
/// </summary>
public void Taobao_category()
{
List <Lebi_Pro_Type> ts = Shop.LebiAPI.Service.Instanse.Taobao_ProType();
if (ts == null)
{
Response.Write("{\"msg\":\"系统异常\"}");
}
else
{
List <Lebi_Pro_Type> parents = (from m in ts
where m.Parentid == 0
select m).ToList();
foreach (Lebi_Pro_Type t in parents)
{
int pid = t.id;
Lebi_Pro_Type model = DoOneCategory(t);
List <Lebi_Pro_Type> sons = (from m in ts
where m.Parentid == pid
select m).ToList();
foreach (Lebi_Pro_Type sont in sons)
{
sont.Parentid = model.id;
DoOneCategory(sont);
}
}
ShopCache.SetProductType();
Response.Write("{\"msg\":\"OK\"}");
}
}
/// <summary>
/// 某个商品分类的路径
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string Categorypath(int id)
{
Shop.Model.Lebi_Pro_Type pro_type = Shop.Bussiness.B_Lebi_Pro_Type.GetModel(id);
if (pro_type == null)
{
pro_type = new Shop.Model.Lebi_Pro_Type();
}
string str = EX_Product.TypePath(pro_type, id.ToString());
string[] arr = str.Split(',');
string res = "";
for (int i = 0; i < arr.Length; i++)
{
Lebi_Pro_Type model = B_Lebi_Pro_Type.GetModel("id = " + int.Parse(arr[i]) + " and IsShow = 1");
if (model == null)
{
continue;
}
res += Lang(model.Name);
if (i < arr.Length - 1)
{
res += " » ";
}
}
return(res);
}
public string tabname(int id)
{
Lebi_Pro_Type t = B_Lebi_Pro_Type.GetModel(id);
if (t == null)
{
return("");
}
return(Language.Content(t.Name, CurrentLanguage.Code));
}
public string Categorypath_ids(int id)
{
Lebi_Pro_Type model = B_Lebi_Pro_Type.GetModel(id);
string str = model.id.ToString();
if (model.Parentid > 0)
{
str += "," + Categorypath_ids(model.Parentid);
}
return(str);
}
/// <summary>
/// 处理一个商品分类
/// </summary>
private Lebi_Pro_Type DoOneCategory(Lebi_Pro_Type t)
{
Lebi_Pro_Type model = B_Lebi_Pro_Type.GetModel("taobaoid='" + t.taobaoid + "'");
if (model == null)
{
model = t;
if (t.ProPerty131 != "")
{
List <Lebi_ProPerty> ps131 = B_Lebi_ProPerty.GetList("taobaoid in (" + t.ProPerty131 + ")", "");
if (ps131 != null)
{
string pid131 = "";
foreach (Lebi_ProPerty p131 in ps131)
{
if (pid131 == "")
{
pid131 = p131.id.ToString();
}
else
{
pid131 += "," + p131.id.ToString();
};
}
model.ProPerty131 = pid131;
}
}
if (t.ProPerty132 != "")
{
List <Lebi_ProPerty> ps132 = B_Lebi_ProPerty.GetList("taobaoid in (" + t.ProPerty132 + ")", "");
if (ps132 != null)
{
string pid132 = "";
foreach (Lebi_ProPerty p132 in ps132)
{
if (pid132 == "")
{
pid132 = p132.id.ToString();
}
else
{
pid132 += "," + p132.id.ToString();
};
}
model.ProPerty132 = pid132;
}
}
B_Lebi_Pro_Type.Add(model);
model.id = B_Lebi_Pro_Type.GetMaxId();
}
return(model);
}
/// <summary>
/// 返回子分类
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <Lebi_Pro_Type> Cateporys(int id)
{
List <Lebi_Pro_Type> models = EX_Product.ShowTypes(id, CurrentSite.id);
if (models.Count == 0)
{
Lebi_Pro_Type m = B_Lebi_Pro_Type.GetModel(id);
if (m.Parentid > 0)
{
return(Cateporys(m.Parentid));
}
}
return(models);
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
int id = Rint_Para("0");
comment = B_Lebi_Comment.GetModel(id);
if (comment.id == 0)
{
Response.Redirect(URL("P_404", ""));
Response.End();
}
product = GetProduct(comment.Keyid);
string where = "Parentid =" + id;
comments = B_Lebi_Comment.GetList(where, "id desc", PageSize, pageindex);
int recordCount = B_Lebi_Comment.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&id=" + id, pageindex, PageSize, recordCount, CurrentLanguage);
ProductStar = Convert.ToInt32(product.Star_Comment);
if (ProductStar > 5)
{
ProductStar = 5;
}
if (ProductStar < 0)
{
ProductStar = 0;
}
pro_type = B_Lebi_Pro_Type.GetModel(product.Pro_Type_id);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em>";
if (pro_type != null)
{
string[,] parr = Categorypath(pro_type.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", product.id) + "\"><span>" + Lang(product.Name) + "</span></a><em>»</em>";
path += "<a><span>" + Tag("晒单") + "</span></a>";
//path += "<a href=\"" + URL("P_Product", id) + "\"><span>" + Lang(product.Name) + "</span></a>";
smalls = comment.ImagesSmall.Split('@');
bigs = comment.Images.Split('@');
if (bigs.Count() > 1)
{
DefaultImage = bigs[1];
}
productcomments = B_Lebi_Comment.GetList("TableName='Product' and Keyid=" + comment.Keyid + " and id!=" + comment.id + "", "id desc", 5, 1);
}
/// <summary>
/// 某个商品分类的路径
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string[,] Categorypath(int id)
{
string str = Categorypath_ids(id);
string[] arr = str.Split(',');
string[,] res = new string[arr.Length, 2];
for (int i = 0; i < arr.Length; i++)
{
Lebi_Pro_Type model = B_Lebi_Pro_Type.GetModel(int.Parse(arr[i]));
int j = arr.Length - i - 1;
res[j, 0] = model.id.ToString();
res[j, 1] = Lang(model.Name);
}
return(res);
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
int id = Rint_Para("0");
product = GetProduct(id);
if (product.id == 0)
{
Response.Redirect(URL("P_404", ""));
Response.End();
}
string where = "Parentid = 0 and TableName = 'Product' and (Keyid = " + id + "";
if (product.Product_id != 0)
{
where += " or Product_id = " + product.Product_id + "";
}
where += ") and (Status = 281 or User_id = " + CurrentUser.id + ")";
comments = B_Lebi_Comment.GetList(where, "id desc", PageSize, pageindex);
int recordCount = B_Lebi_Comment.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&id=" + id, pageindex, PageSize, recordCount, CurrentLanguage);
NextPage = "?page=" + (pageindex + 1) + "&id=" + id + "";
ProductStar = Convert.ToInt32(product.Star_Comment);
if (ProductStar > 5)
{
ProductStar = 5;
}
if (ProductStar < 0)
{
ProductStar = 0;
}
pro_type = B_Lebi_Pro_Type.GetModel(product.Pro_Type_id);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em>";
if (pro_type != null)
{
string[,] parr = Categorypath(pro_type.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", product.id) + "\"><span>" + Lang(product.Name) + "</span></a><em>»</em>";
path += "<a><span>" + Tag("商品评论") + "</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;
}
/// <summary>
/// 某个商品分类的路径
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string[,] Categorypath(int id)
{
string str = Categorypath_ids(id);
string[] arr = str.Split(',');
string[,] res = new string[arr.Length, 3];
for (int i = 0; i < arr.Length; i++)
{
Lebi_Pro_Type model = B_Lebi_Pro_Type.GetModel("id = " + int.Parse(arr[i]) + " and IsShow = 1");
if (model == null)
{
continue;
}
int j = arr.Length - i - 1;
res[j, 0] = model.id.ToString();
res[j, 1] = Lang(model.Name);
res[j, 2] = Lang(model.Url);
}
return(res);
}
/// <summary>
/// 生成商品分类选择框
/// </summary>
public void GetProductTypeList()
{
int id = RequestTool.RequestInt("id", 0);
int Parentid = 0;
List <Lebi_Pro_Type> models = B_Lebi_Pro_Type.GetList("Parentid=" + id + "", "Sort desc");
Lebi_Pro_Type area = B_Lebi_Pro_Type.GetModel(id);
if (models.Count == 0)
{
if (area == null)
{
Parentid = 0;
}
else
{
Parentid = area.Parentid;
}
models = B_Lebi_Pro_Type.GetList("Parentid=" + Parentid + "", "Sort desc");
}
else
{
Parentid = id;
}
string str = "<select id=\"Pro_Type_id\" name=\"Pro_Type_id\" shop=\"true\" onchange=\"SelectProductType('Pro_Type_id');\">";
str += "<option value=\"0\" selected>" + Tag(" 请选择 ") + "</option>";
foreach (Lebi_Pro_Type model in models)
{
if (id == model.id)
{
str += "<option value=\"" + model.id + "\" selected>" + Lang(model.Name) + "</option>";
}
else
{
str += "<option value=\"" + model.id + "\">" + Lang(model.Name) + "</option>";
}
}
str += "</select>";
str = CreateProductTypeSelect(Parentid) + str;
Response.Write(str);
}
public string ThreadGetProductTypeList(int id, int Parentid)
{
List <Lebi_Pro_Type> models = B_Lebi_Pro_Type.GetList("Parentid=" + id + "", "Sort desc");
Lebi_Pro_Type area = B_Lebi_Pro_Type.GetModel(id);
if (models.Count == 0)
{
if (area == null)
{
Parentid = 0;
}
else
{
Parentid = area.Parentid;
}
models = B_Lebi_Pro_Type.GetList("Parentid=" + Parentid + "", "Sort desc");
}
else
{
Parentid = id;
}
string str = "<select id=\"Pro_Type_id\" name=\"Pro_Type_id\" shop=\"true\" onchange=\"SelectProductType('Pro_Type_id');\" class=\"form-control\">";
str += "<option value=\"0\" selected>" + Tag(" 请选择 ") + "</option>";
foreach (Lebi_Pro_Type model in models)
{
if (id == model.id)
{
str += "<option value=\"" + model.id + "\" selected>" + Lang(model.Name) + "</option>";
}
else
{
str += "<option value=\"" + model.id + "\">" + Lang(model.Name) + "</option>";
}
}
str += "</select>";
str = CreateProductTypeSelect(Parentid) + str;
return(str);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = RequestTool.RequestInt("id", 0);
if (id == 0)
{
if (!EX_Admin.Power("pro_type_add", "添加商品分类"))
{
PageNoPower();
}
}
else
{
if (!EX_Admin.Power("pro_type_edit", "编辑商品分类"))
{
PageNoPower();
}
}
int pid = RequestTool.RequestInt("pid", 0);
model = B_Lebi_Pro_Type.GetModel(id);
if (model == null)
{
model = new Lebi_Pro_Type();
model.IsIndexShow = 1;
model.IsShow = 1;
model.Site_ids = site.Sitesid();
}
else
{
pid = model.Parentid;
}
pmodel = B_Lebi_Pro_Type.GetModel(pid);
if (pmodel == null)
{
pmodel = new Lebi_Pro_Type();
}
}
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;
}
}
/// <summary>
/// 处理添加一个商品
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
private Lebi_Product DoOneProduct(Lebi_Product pro)
{
Lebi_Pro_Type t = new Lebi_Pro_Type();
string ids = pro.taobaoid_type;
if (ids != "")
{
ids = "'0" + ids.Replace(",", "','") + "0'";
List <Lebi_Pro_Type> models = B_Lebi_Pro_Type.GetList("taobaoid in (lbsql{" + ids + "})", "");
t = models.FirstOrDefault();
}
if (t == null)
{
t = new Lebi_Pro_Type();
}
string p131ids = pro.ProPerty131;
string p132ids = pro.ProPerty132;
if (p131ids != "")
{
p131ids = "'" + p131ids.Replace(",", "','") + "'";
List <Lebi_ProPerty> p131s = B_Lebi_ProPerty.GetList("taobaoid in (" + p131ids + ")", "");
p131ids = "";
foreach (Lebi_ProPerty p in p131s)
{
if (p131ids == "")
{
p131ids = p.id.ToString();
}
else
{
p131ids += "," + p.id.ToString();
}
}
}
if (p132ids != "")
{
p132ids = "'" + p132ids.Replace(",", "','") + "'";
List <Lebi_ProPerty> p132s = B_Lebi_ProPerty.GetList("taobaoid in (" + p132ids + ")", "");
p132ids = "";
foreach (Lebi_ProPerty p in p132s)
{
if (p132ids == "")
{
p132ids = p.id.ToString();
}
else
{
p132ids += "," + p.id.ToString();
}
}
}
pro.ProPerty131 = p131ids;
pro.ProPerty132 = p132ids;
pro.Pro_Type_id = t.id;
B_Lebi_Product.Add(pro);
pro.id = B_Lebi_Product.GetMaxId();
return(pro);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static void Update(Lebi_Pro_Type model)
{
D_Lebi_Pro_Type.Instance.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(Lebi_Pro_Type model)
{
return(D_Lebi_Pro_Type.Instance.Add(model));
}
/// <summary>
/// 安全方式绑定表单数据
/// </summary>
public static Lebi_Pro_Type SafeBindForm(Lebi_Pro_Type model)
{
return(D_Lebi_Pro_Type.Instance.SafeBindForm(model));
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
id = Rint_Para("0"); //商品分类
pid = Rint_Para("1"); //品牌
cid = Rstring_Para("2"); //属性
list = Rstring_Para("3"); //列表或网格
sort = Rstring_Para("4"); //排序
tid = Rint_Para("5"); //商品标签
transport = Rint_Para("7"); //配送 0全部 1商城 2商家
stock = Rint_Para("8"); //是否有库存 1只显示有货
pageindex = RequestTool.RequestInt("page", 1);
pro_type = B_Lebi_Pro_Type.GetModel(id);
if (pro_type == null)
{
pro_type = new Lebi_Pro_Type();
}
if (Lang(pro_type.Url) != "") //如果存在自定义URL 跳转至自定义URL by kingdge 2014-10-30
{
Response.Redirect(Lang(pro_type.Url));
Response.End();
return;
}
property = EX_Product.ProductType_ProPerty(pro_type);
if (property == null)
{
property = new Lebi_Pro_Type(); property.ProPerty132 = "0";
}
if (property.ProPerty132 == "")
{
property.ProPerty132 = "0";
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em>";
if (pro_type.id > 0)
{
CategoryPath = Categorypath(id);
for (int i = 0; i <= CategoryPath.GetUpperBound(0); i++)
{
path += "<a href=\"" + URL("P_ProductCategory", "" + CategoryPath[i, 0] + "", CategoryPath[i, 2]) + "\"><span>" + CategoryPath[i, 1] + "</span></a>";
if (i < CategoryPath.GetUpperBound(0))
{
path += "<em>»</em>";
}
}
}
else if (tid == 0)
{
path += "<a href=\"" + URL("P_ProductCategory", "0") + "\"><span>" + Tag("商品列表") + "</span></a>";
}
if (tid > 0)
{
tag = B_Lebi_Pro_Tag.GetModel(tid);
path += "<em>»</em><a href=\"" + URL("P_ProductCategory", "" + id + ",$,$,$,$," + tid + "") + "\"><span>" + Lang(tag.Name) + "</span></a>";
}
where = ProductWhere + " and Type_id_ProductType <> 323";
if (pid > 0)
{
where += " and Brand_id=" + pid + "";
brand = B_Lebi_Brand.GetModel(pid);
path += "<em>»</em><a href=\"" + URL("P_ProductCategory", "" + id + "," + pid + ",$,$,$,$") + "\"><span>" + Lang(brand.Name) + "</span></a>";
}
if (cid != "")
{
where += " and " + Categorywhere(cid);
string _cidlast = "";
if (cid.IndexOf("$") > -1)
{
string[] cidarr = cid.Split('$');
for (int i = 0; i < cidarr.Count(); i++)
{
if (cidarr[i].IndexOf("|") > -1)
{
string[] _cids = cidarr[i].Split('|');
_cidlast = _cids[1];
Lebi_ProPerty ProPerty = B_Lebi_ProPerty.GetModel(int.Parse(_cidlast));
if (ProPerty != null)
{
path += "<em>»</em><a href=\"" + URL("P_ProductCategory", "" + id + "," + pid + "," + ProPerty.parentid + "|" + ProPerty.id + ",$,$,$") + "\"><span>" + Lang(ProPerty.Name) + "</span></a>";
}
}
}
}
else
{
if (cid.IndexOf("|") > -1)
{
string[] _cids = cid.Split('|');
_cidlast = _cids[1];
Lebi_ProPerty ProPerty = B_Lebi_ProPerty.GetModel(int.Parse(_cidlast));
if (ProPerty != null)
{
path += "<em>»</em><a href=\"" + URL("P_ProductCategory", "" + id + "," + pid + "," + ProPerty.parentid + "|" + ProPerty.id + ",$,$,$") + "\"><span>" + Lang(ProPerty.Name) + "</span></a>";
}
}
}
}
if (id > 0)
{
where += " and " + CategoryWhere(id);
//where += " and (Pro_Type_id in (" + Categorywhereforid(id) + ")";
//if (DataBase.DBType == "sqlserver")
//{
// where += " or Charindex('," + id + ",',','+Pro_Type_id_other+',')>0)";
//}
//if (DataBase.DBType == "access")
//{
// where += " or Instr(','+Pro_Type_id_other+',','," + id + ",')>0)";
//}
}
if (tid > 0)
{
if (DataBase.DBType == "sqlserver")
{
where += " and Charindex('," + tid + ",',','+Pro_Tag_id+',')>0";
}
if (DataBase.DBType == "access")
{
where += " and Instr(','+Pro_Tag_id+',','," + tid + ",')>0";
}
}
if (transport == 1)
{
where += " and IsSupplierTransport = 0";
}
else if (transport == 2)
{
where += " and IsSupplierTransport = 1";
}
if (stock == 1)
{
where += " and Count_Stock > 0";
}
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);
//id={0}&pid={1}&cid={2}&list={3}&sort={4}&tid={5}&page={6}
string url = URL("P_ProductCategory", id + "," + pid + "," + cid + "," + list + "," + sort + "," + tid + ",{0}," + transport + "," + stock + "", Lang(pro_type.Url));
HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple(url, pageindex, PageSize, recordCount, CurrentLanguage);
FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, pageindex, PageSize, recordCount, CurrentLanguage);
}
