/// <summary>
/// 获得品牌商品的一个1个三类商品
/// </summary>
/// <param name="startIndex"></param>
/// <param name="pagedCount"></param>
/// <param name="c3SysNo"></param>
/// <param name="orderByOption"></param>
/// <param name="attribution2IdStr"></param>
/// <returns></returns>
public static List<FrontDsiplayProduct> GetBrandProductsList2(int c3SysNo, YoeJoyEnum.ProductListSortedOrder orderByOption, string attribution2IdStr, int bId, string order = "DESC")
{
string orderByStr = YoeJoySystemDic.ProductListSortedOrderDic[orderByOption];
string orderByStr1 = orderByStr;
string arrtibutionFilterSqlCmd = String.Empty;
if (attribution2IdStr != null)
{
arrtibutionFilterSqlCmd = "and pa2.Attribute2OptionSysNo in ( " + attribution2IdStr + " )";
}
switch (orderByOption)
{
case YoeJoyEnum.ProductListSortedOrder.Default:
{
break;
}
case YoeJoyEnum.ProductListSortedOrder.Price:
{
orderByStr1 = orderByStr1.Replace("price", "pp.CurrentPrice");
break;
}
default:
{
break;
}
}
string sqlCmd = String.Format(geBrandProducts2SqlCmdTemplate, arrtibutionFilterSqlCmd, bId, c3SysNo, orderByStr, order);
try
{
DataTable data = new SqlDBHelper().ExecuteQuery(sqlCmd);
int rowCount = data.Rows.Count;
if (rowCount > 0)
{
List<FrontDsiplayProduct> products = new List<FrontDsiplayProduct>();
for (int i = 0; i < rowCount; i++)
{
products.Add(new FrontDsiplayProduct()
{
C1SysNo = int.Parse(data.Rows[i]["C1SysNo"].ToString().Trim()),
C2SysNo = int.Parse(data.Rows[i]["C2SysNo"].ToString().Trim()),
C3SysNo = int.Parse(data.Rows[i]["C3SysNo"].ToString().Trim()),
ImgPath = data.Rows[i]["product_limg"].ToString().Trim(),
Price = data.Rows[i]["price"].ToString().Trim(),
ProductSysNo = data.Rows[i]["SysNo"].ToString().Trim(),
ProductPromotionWord = data.Rows[i]["PromotionWord"].ToString().Trim(),
ProductBriefName = data.Rows[i]["BriefName"].ToString().Trim(),
BaiscPrice = data.Rows[i]["baiscPrice"].ToString().Trim(),
IsCanPurchase = (int.Parse(data.Rows[i]["IsCanPurchase"].ToString().Trim()) == 1) ? true : false,
LimitQty = int.Parse(data.Rows[i]["LimitedQty"].ToString().Trim()),
});
}
return products;
}
else
{
return null;
}
}
catch
{
return null;
}
}
/// <summary>
/// 获得商品列表
/// </summary>
/// <param name="orderOption"></param>
/// <param name="startIndex"></param>
/// <param name="pagedCount"></param>
/// <param name="c3SysNo"></param>
/// <param name="c1SysNo"></param>
/// <param name="c2SysNo"></param>
/// <returns></returns>
public static string GetC3PageProductListHTML(YoeJoyEnum.ProductListSortedOrder orderOption, int startIndex, int c3SysNo, int c1SysNo, int c2SysNo, string attribution2Ids, string order)
{
string productListHTML = String.Empty;
StringBuilder strb = new StringBuilder("<ul>");
string baseURL = YoeJoyConfig.SiteBaseURL;
int pagedCount = int.Parse(YoeJoyConfig.ProductListPagedCount);
List<FrontDsiplayProduct> products = C3ProductListSerivice.GetPagedProductList((startIndex - 1), pagedCount, c3SysNo, orderOption, attribution2Ids, order);
if (products != null)
{
string imageBaseURL = YoeJoyConfig.ImgVirtualPathBase;
string productListItemHTMLTemplate1 = @"<li class='show1'>
<div class='group'>
<div class='photo'><a href='{0}' target='_parent'><img class='photo' alt='{1}' src='{2}' width='190' height='190'></a></div>
<a class='name' title='{3}' href='{4}' target='_parent'>{5}</a>
<span class='adText'>{6}</span>
<div class='mem0'>
<p class='price'><b>¥{7}</b><span>¥{8}</span></p>
<p align='right'>评论:1000条</p>
</div>
<div class='botton'><a class='ck' href='{9}' target='_parent'>查看详情</a></div>
</div>
</li>";
string productListItemHTMLTemplate2 = @"<li class='show2'>
<div class='group'>
<div class='photo'><a href='{0}' target='_parent'><img class='photo' alt='{1}' src='{2}' width='190' height='190'></a></div>
<a class='name' title='{3}' href='{4}' target='_parent'>{5}</a>
<span class='adText'>{6}</span>
<div class='mem0'>
<p class='price'><b>¥{7}</b><span>¥{8}</span></p>
<p align='right'>评论:1000条</p>
</div>
<div class='botton'>
<p><a class='sub' href='javascript:void(0)'>-</a>
<input class='num' maxLength='3' value='1' type='text'>
<a class='add' href='javascript:void(0)'>+</a></p>
<a class='ck' href='process1.html'>直接购买</a></div>
</div>
</li>";
foreach (FrontDsiplayProduct product in products)
{
string imgPath = YoeJoyConfig.ImgVirtualPathBase + product.ImgPath;
string deeplink = YoeJoyConfig.SiteBaseURL + "pages/product.aspx?c1=" + c1SysNo + "&c2=" + c2SysNo + "&c3=" + c3SysNo + "&pid=" + product.ProductSysNo;
if (product.IsCanPurchase)
{
strb.Append(String.Format(productListItemHTMLTemplate2, deeplink, product.ProductBriefName, imgPath, product.ProductBriefName, deeplink, product.ProductBriefName, product.ProductPromotionWord, product.Price, product.BaiscPrice));
}
else
{
strb.Append(String.Format(productListItemHTMLTemplate1, deeplink, product.ProductBriefName, imgPath, product.ProductBriefName, deeplink, product.ProductBriefName, product.ProductPromotionWord, product.Price, product.BaiscPrice, deeplink));
}
}
}
strb.Append("</ul>");
productListHTML = strb.ToString();
return productListHTML;
}
/// <summary>
/// 获得满足search2条件的分页的商品
/// </summary>
/// <param name="startIndex"></param>
/// <param name="pagedCount"></param>
/// <param name="c3SysNo"></param>
/// <param name="orderByOption"></param>
/// <param name="attribution2IdStr"></param>
/// <returns></returns>
public static List<FrontDsiplayProduct> GetPagedProductList(int c3SysNo, YoeJoyEnum.ProductListSortedOrder orderByOption, string attribution2IdStr, string keyWords, string order = "DESC")
{
string orderByStr = YoeJoySystemDic.ProductListSortedOrderDic[orderByOption];
string orderByStr1 = orderByStr;
string arrtibutionFilterSqlCmd = String.Empty;
if (attribution2IdStr != null)
{
arrtibutionFilterSqlCmd = " Attribute2OptionSysNo in ( " + attribution2IdStr + " )";
}
string sqlcom = getSysno(arrtibutionFilterSqlCmd, attribution2IdStr);
string childSearchSqlCmd = String.Empty;
//string[] keyWordsArray = keyWords.Split(' ');
//if (keyWordsArray.Length > 1)
//{
// for (int i = 1; i < keyWordsArray.Length; i++)
// {
// childSearchSqlCmd += String.Format(" or p.PromotionWord like ('%{0}%') or p.BriefName like ('%{1}%')", keyWordsArray[i].Trim(), keyWordsArray[i].Trim());
// }
//}
switch (orderByOption)
{
case YoeJoyEnum.ProductListSortedOrder.Default:
{
break;
}
case YoeJoyEnum.ProductListSortedOrder.Price:
{
orderByStr1 = orderByStr1.Replace("price", "pp.CurrentPrice");
break;
}
default:
{
break;
}
}
string sqlCmd = String.Format(getSearch2C3ProductsSqlCmdTemplate, sqlcom, c3SysNo, orderByStr);
try
{
DataTable data = new SqlDBHelper().ExecuteQuery(sqlCmd);
int rowCount = data.Rows.Count;
if (rowCount > 0)
{
List<FrontDsiplayProduct> products = new List<FrontDsiplayProduct>();
for (int i = 0; i < rowCount; i++)
{
products.Add(new FrontDsiplayProduct()
{
C1SysNo = int.Parse(data.Rows[i]["C1SysNo"].ToString().Trim()),
C2SysNo = int.Parse(data.Rows[i]["C2SysNo"].ToString().Trim()),
C3SysNo = int.Parse(data.Rows[i]["C3SysNo"].ToString().Trim()),
ImgPath = data.Rows[i]["product_limg"].ToString().Trim(),
Price = data.Rows[i]["price"].ToString().Trim(),
ProductSysNo = data.Rows[i]["SysNo"].ToString().Trim(),
ProductPromotionWord = data.Rows[i]["PromotionWord"].ToString().Trim(),
ProductBriefName = data.Rows[i]["BriefName"].ToString().Trim(),
BaiscPrice = data.Rows[i]["baiscPrice"].ToString().Trim(),
IsCanPurchase = (int.Parse(data.Rows[i]["IsCanPurchase"].ToString().Trim()) == 1) ? true : false,
LimitQty = int.Parse(data.Rows[i]["LimitedQty"].ToString().Trim()),
});
}
return products;
}
else
{
return null;
}
}
catch
{
return null;
}
}
