protected ProductBrowseQuery GetProductBrowseQuery()
{
ProductBrowseQuery entity = new ProductBrowseQuery();
entity.PageIndex = this.pager.PageIndex;
entity.PageSize = this.pager.PageSize;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["keywords"]))
{
entity.Keywords = Globals.UrlDecode(this.Page.Request.QueryString["keywords"]);
this.txtKeywords.Value = entity.Keywords;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["minSalePrice"]))
{
decimal result = 0M;
if (decimal.TryParse(Globals.UrlDecode(this.Page.Request.QueryString["minSalePrice"]), out result))
{
entity.MinSalePrice = new decimal?(result);
this.txtStartPrice.Value = result.ToString();
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["maxSalePrice"]))
{
decimal num2 = 0M;
if (decimal.TryParse(Globals.UrlDecode(this.Page.Request.QueryString["maxSalePrice"]), out num2))
{
entity.MaxSalePrice = new decimal?(num2);
this.txtEndPrice.Value = num2.ToString();
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["productCode"]))
{
entity.ProductCode = Globals.UrlDecode(this.Page.Request.QueryString["productCode"]);
this.txtSKU.Value = entity.ProductCode;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["sortOrderBy"]))
{
entity.SortBy = this.Page.Request.QueryString["sortOrderBy"];
}
else
{
entity.SortBy = "DisplaySequence";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["sortOrder"]))
{
entity.SortOrder = (SortAction) Enum.Parse(typeof(SortAction), this.Page.Request.QueryString["sortOrder"]);
}
else
{
entity.SortOrder = SortAction.Desc;
}
Globals.EntityCoding(entity, true);
return entity;
}
ProductBrowseQuery GetProductBrowseQuery()
{
ProductBrowseQuery query = new ProductBrowseQuery();
query.PageIndex = this.pager.PageIndex;
int result = 10;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["pageSize"]) && int.TryParse(this.Page.Request.QueryString["pageSize"], out result))
{
query.PageSize = result;
return query;
}
query.PageSize = 10;
return query;
}
ProductBrowseQuery GetProductBrowseQuery()
{
ProductBrowseQuery query = new ProductBrowseQuery();
query.IsCount = true;
query.PageIndex = this.pager.PageIndex;
query.SortBy = "DisplaySequence";
query.SortOrder = SortAction.Desc;
int result = 10;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["pageSize"]) && int.TryParse(this.Page.Request.QueryString["pageSize"], out result))
{
query.PageSize = result;
return query;
}
query.PageSize = 10;
return query;
}
protected void BindProducts(ProductBrowseQuery query)
{
DbQueryResult unSaleProductList = ProductBrowser.GetUnSaleProductList(query);
this.rptProducts.DataSource = unSaleProductList.Data;
this.rptProducts.DataBind();
int totalRecords = unSaleProductList.TotalRecords;
this.pager.TotalRecords = totalRecords;
int num2 = 0;
if ((totalRecords % this.pager.PageSize) > 0)
{
num2 = (totalRecords / this.pager.PageSize) + 1;
}
else
{
num2 = totalRecords / this.pager.PageSize;
}
this.litSearchResultPage.Text = string.Format("总共有{0}件商品,{1}件商品为一页,共{2}页第 {3}页", new object[] { totalRecords, this.pager.PageSize, num2, this.pager.PageIndex });
}
public override DbQueryResult GetBrowseProductList(ProductBrowseQuery query)
{
string filter = ProductMasterProvider.BuildProductBrowseQuerySearch(query);
string selectFields = "ProductId,ProductName,ProductCode, SaleCounts, ShortDescription, ThumbnailUrl60,ThumbnailUrl100,ThumbnailUrl160, ThumbnailUrl180,ThumbnailUrl220,MarketPrice, SalePrice,Stock";
if (HiContext.Current.User.UserRole == UserRole.Member)
{
Member user = HiContext.Current.User as Member;
int memberDiscount = MemberProvider.Instance().GetMemberDiscount(user.GradeId);
selectFields = selectFields + string.Format(",CASE WHEN (SELECT COUNT(*) FROM Hishop_SKUMemberPrice WHERE SkuId = p.SkuId AND GradeId = {0}) = 1 ", user.GradeId) + string.Format("THEN (SELECT MemberSalePrice FROM Hishop_SKUMemberPrice WHERE SkuId = p.SkuId AND GradeId = {0}) ELSE SalePrice*{1}/100 END AS RankPrice", user.GradeId, memberDiscount);
}
else
{
selectFields = selectFields + ",SalePrice as RankPrice";
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_BrowseProductList p", "ProductId", filter, selectFields);
}
public override DataSet GetGroupByProductList(ProductBrowseQuery query, out int TotalGroupBuyProducts)
{
DbCommand storedProcCommand = this.database.GetStoredProcCommand("ss_GroupBuyProducts_Get");
string str = string.Format("SELECT GroupBuyId,ProductId,EndDate FROM Hishop_GroupBuy WHERE EndDate>'{0}' AND Status={1}", DateTime.Now, 1) + string.Format(" AND ProductId IN(SELECT ProductId FROM Hishop_Products WHERE SaleStatus={0}) ORDER BY DisplaySequence DESC", 1);
this.database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, query.PageIndex);
this.database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, query.PageSize);
this.database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, query.IsCount);
this.database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, str);
this.database.AddOutParameter(storedProcCommand, "TotalGroupBuyProducts", DbType.Int32, 4);
DataSet set = this.database.ExecuteDataSet(storedProcCommand);
TotalGroupBuyProducts = (int) this.database.GetParameterValue(storedProcCommand, "TotalGroupBuyProducts");
return set;
}
public override DbQueryResult GetCountDownProductList(ProductBrowseQuery query)
{
string filter = string.Format(" EndDate>'{0}' AND ProductId IN(SELECT ProductId FROM Hishop_Products WHERE SaleStatus={1})", DateTime.Now, 1);
return DataHelper.PagingByTopsort(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_CountDown", "CountDownId", filter, "*");
}
protected static string BuildProductBrowseQuerySearch(ProductBrowseQuery query)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat("SaleStatus = {0}", 1);
if (!string.IsNullOrEmpty(query.ProductCode))
{
builder.AppendFormat(" AND LOWER(ProductCode) Like '%{0}%'", DataHelper.CleanSearchString(query.ProductCode).ToLower());
}
if (query.AttributeValues.Count > 0)
{
foreach (AttributeValueInfo info in query.AttributeValues)
{
builder.AppendFormat(" AND ProductId IN ( SELECT ProductId FROM Hishop_ProductAttributes WHERE AttributeId={0} And ValueId={1}) ", info.AttributeId, info.ValueId);
}
}
if (query.BrandId.HasValue)
{
if (query.BrandId.Value == 0)
{
builder.Append(" AND BrandId IS NOT NULL");
}
else
{
builder.AppendFormat(" AND BrandId = {0}", query.BrandId.Value);
}
}
if (query.MinSalePrice.HasValue)
{
builder.AppendFormat(" AND SalePrice >= {0}", query.MinSalePrice.Value);
}
if (query.MaxSalePrice.HasValue)
{
builder.AppendFormat(" AND SalePrice <= {0}", query.MaxSalePrice.Value);
}
if (!string.IsNullOrEmpty(query.Keywords) && (query.Keywords.Trim().Length > 0))
{
if (!query.IsPrecise)
{
query.Keywords = DataHelper.CleanSearchString(query.Keywords);
string[] strArray = Regex.Split(query.Keywords.Trim(), @"\s+");
StringBuilder builder2 = new StringBuilder();
builder2.AppendFormat(" OR (LOWER(ProductCode) LIKE '%{0}%'", DataHelper.CleanSearchString(strArray[0]));
builder.AppendFormat(" AND ((ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(strArray[0]));
for (int i = 1; (i < strArray.Length) && (i <= 4); i++)
{
builder.AppendFormat(" AND ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(strArray[i]));
builder2.AppendFormat(" AND LOWER(ProductCode) LIKE '%{0}%'", DataHelper.CleanSearchString(strArray[i]));
}
builder.Append(")" + builder2.ToString() + "))");
}
else
{
builder.AppendFormat(" AND (ProductName = '{0}' or LOWER(ProductCode)='{0}')", DataHelper.CleanSearchString(query.Keywords));
}
}
if (query.CategoryId.HasValue)
{
CategoryInfo category = CategoryBrowser.GetCategory(query.CategoryId.Value);
if (category != null)
{
builder.AppendFormat(" AND ( MainCategoryPath LIKE '{0}|%' OR ExtendCategoryPath LIKE '{0}|%') ", category.Path);
}
}
if (!string.IsNullOrEmpty(query.SubjectType))
{
builder.AppendFormat(" AND ProductId IN(SELECT ProductId FROM distro_SubjectProducts WHERE SubjectType = {0} AND DistributorUserId={1})", (int) Enum.Parse(typeof(SubjectType), query.SubjectType), HiContext.Current.SiteSettings.UserId);
}
return builder.ToString();
}
public override DbQueryResult GetBrowseProductList(ProductBrowseQuery query)
{
int num = HiContext.Current.SiteSettings.UserId.Value;
string filter = ProductSubsiteProvider.BuildProductBrowseQuerySearch(query) + string.Format(" AND DistributorUserId = {0} ", HiContext.Current.SiteSettings.UserId.Value);
string selectFields = "ProductId,ProductName,ProductCode,SaleCounts,ShortDescription,MarketPrice,ThumbnailUrl60,ThumbnailUrl100,ThumbnailUrl160, ThumbnailUrl180,ThumbnailUrl220,Stock";
if (HiContext.Current.User.UserRole == UserRole.Underling)
{
Member user = HiContext.Current.User as Member;
int memberDiscount = MemberProvider.Instance().GetMemberDiscount(user.GradeId);
selectFields = (selectFields + string.Format(",(SELECT SalePrice FROM vw_distro_SkuPrices WHERE SkuId = p.SkuId AND DistributoruserId = {0}) AS SalePrice", num) + string.Format(",CASE WHEN (SELECT COUNT(*) FROM distro_SKUMemberPrice WHERE SkuId = p.SkuId AND GradeId = {0} AND DistributoruserId = {1}) = 1 ", user.GradeId, num)) + string.Format(" THEN (SELECT MemberSalePrice FROM distro_SKUMemberPrice WHERE SkuId = p.SkuId AND GradeId = {0} AND DistributoruserId = {1})", user.GradeId, num) + string.Format(" ELSE (SELECT SalePrice FROM vw_distro_SkuPrices WHERE SkuId = p.SkuId AND DistributoruserId = {0})*{1}/100 END AS RankPrice", num, memberDiscount);
}
else
{
selectFields = selectFields + string.Format(",(SELECT SalePrice FROM vw_distro_SkuPrices WHERE SkuId = p.SkuId AND DistributoruserId = {0}) AS SalePrice", num) + " , 0 AS RankPrice";
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_distro_BrowseProductList p", "ProductId", filter, selectFields);
}
void SearchProducts()
{
decimal num;
decimal num2;
ProductBrowseQuery query = new ProductBrowseQuery();
if (!string.IsNullOrEmpty(this.txtKeywords.Value.Trim()))
{
query.Keywords = this.txtKeywords.Value.Trim().Replace("'", "").Replace("\"", "");
}
if (!string.IsNullOrEmpty(this.txtStartPrice.Value.Trim()) && decimal.TryParse(this.txtStartPrice.Value.Trim(), out num))
{
query.MinSalePrice = new decimal?(num);
}
if (!string.IsNullOrEmpty(this.txtEndPrice.Value.Trim()) && decimal.TryParse(this.txtEndPrice.Value.Trim(), out num2))
{
query.MaxSalePrice = new decimal?(num2);
}
if (!string.IsNullOrEmpty(this.txtSKU.Value.Trim()))
{
query.ProductCode = Globals.UrlEncode(this.txtSKU.Value);
}
query.PageIndex = 1;
query.PageSize = 10;
this.BindProducts(query);
}
public static DataSet GetGroupByProductList(ProductBrowseQuery query, out int count)
{
return ProductProvider.Instance().GetGroupByProductList(query, out count);
}
public abstract DbQueryResult GetUnSaleProductList(ProductBrowseQuery query);
public abstract DataSet GetGroupByProductList(ProductBrowseQuery query, out int count);
public abstract DbQueryResult GetCountDownProductList(ProductBrowseQuery query);
ProductBrowseQuery GetProductBrowseQuery()
{
ProductBrowseQuery entity = new ProductBrowseQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["keywords"]))
{
entity.Keywords = Globals.UrlDecode(this.Page.Request.QueryString["keywords"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["minSalePrice"]))
{
decimal num = 0M;
if (decimal.TryParse(Globals.UrlDecode(this.Page.Request.QueryString["minSalePrice"]), out num))
{
entity.MinSalePrice = new decimal?(num);
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["maxSalePrice"]))
{
decimal num2 = 0M;
if (decimal.TryParse(Globals.UrlDecode(this.Page.Request.QueryString["maxSalePrice"]), out num2))
{
entity.MaxSalePrice = new decimal?(num2);
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["productCode"]))
{
entity.ProductCode = Globals.UrlDecode(this.Page.Request.QueryString["productCode"]);
}
entity.PageIndex = this.pager.PageIndex;
int result = 20;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["pageSize"]) && int.TryParse(this.Page.Request.QueryString["pageSize"], out result))
{
entity.PageSize = result;
}
else
{
entity.PageSize = 20;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["sortOrderBy"]))
{
entity.SortBy = this.Page.Request.QueryString["sortOrderBy"];
}
else
{
entity.SortBy = "DisplaySequence";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["sortOrder"]))
{
entity.SortOrder = (SortAction) Enum.Parse(typeof(SortAction), this.Page.Request.QueryString["sortOrder"]);
}
else
{
entity.SortOrder = SortAction.Desc;
}
Globals.EntityCoding(entity, true);
return entity;
}
public static DbQueryResult GetCountDownProductList(ProductBrowseQuery query)
{
return ProductProvider.Instance().GetCountDownProductList(query);
}
public override DbQueryResult GetCountDownProductList(ProductBrowseQuery query)
{
string filter = string.Format(" EndDate>'{0}' AND DistributorUserId={1} AND ProductId IN(SELECT ProductId FROM distro_Products WHERE SaleStatus=1 AND DistributorUserId={2})", DateTime.Now, HiContext.Current.SiteSettings.UserId.Value, HiContext.Current.SiteSettings.UserId.Value);
return DataHelper.PagingByTopsort(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_distro_CountDown", "CountDownId", filter, "*");
}
protected ProductBrowseQuery GetProductBrowseQuery()
{
int num2;
ProductBrowseQuery entity = new ProductBrowseQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["categoryId"]))
{
int result = 0;
if (int.TryParse(this.Page.Request.QueryString["categoryId"], out result))
{
entity.CategoryId = new int?(result);
}
}
if (int.TryParse(this.Page.Request.QueryString["brand"], out num2))
{
entity.BrandId = new int?(num2);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["valueStr"]))
{
IList<AttributeValueInfo> list = new List<AttributeValueInfo>();
string str = Globals.HtmlEncode(Globals.UrlDecode(this.Page.Request.QueryString["valueStr"]));
string[] strArray = str.Split(new char[] { '-' });
if (!string.IsNullOrEmpty(str))
{
for (int i = 0; i < strArray.Length; i++)
{
string[] strArray2 = strArray[i].Split(new char[] { '_' });
if (((strArray2.Length > 0) && !string.IsNullOrEmpty(strArray2[1])) && (strArray2[1] != "0"))
{
AttributeValueInfo item = new AttributeValueInfo();
item.AttributeId = Convert.ToInt32(strArray2[0]);
item.ValueId = Convert.ToInt32(strArray2[1]);
list.Add(item);
}
}
}
entity.AttributeValues = list;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["isPrecise"]))
{
entity.IsPrecise = bool.Parse(Globals.UrlDecode(this.Page.Request.QueryString["isPrecise"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["keywords"]))
{
entity.Keywords = Globals.HtmlEncode(Globals.UrlDecode(this.Page.Request.QueryString["keywords"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["minSalePrice"]))
{
decimal num4 = 0M;
if (decimal.TryParse(Globals.UrlDecode(this.Page.Request.QueryString["minSalePrice"]), out num4))
{
entity.MinSalePrice = new decimal?(num4);
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["maxSalePrice"]))
{
decimal num5 = 0M;
if (decimal.TryParse(Globals.UrlDecode(this.Page.Request.QueryString["maxSalePrice"]), out num5))
{
entity.MaxSalePrice = new decimal?(num5);
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["productCode"]))
{
entity.ProductCode = Globals.HtmlEncode(Globals.UrlDecode(this.Page.Request.QueryString["productCode"]));
}
entity.PageIndex = this.pager.PageIndex;
entity.PageSize = this.rptProducts.PageSize;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["sortOrderBy"]))
{
entity.SortBy = Globals.HtmlEncode(this.Page.Request.QueryString["sortOrderBy"]);
}
else
{
entity.SortBy = "DisplaySequence";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["sortOrder"]))
{
entity.SortOrder = (SortAction) Enum.Parse(typeof(SortAction), Globals.HtmlEncode(this.Page.Request.QueryString["sortOrder"]));
}
else
{
entity.SortOrder = SortAction.Desc;
}
Globals.EntityCoding(entity, true);
return entity;
}
public override DataSet GetGroupByProductList(ProductBrowseQuery query, out int count)
{
DbCommand storedProcCommand = this.database.GetStoredProcCommand("ss_distro_GroupBuyProducts_Get");
string str = string.Format("SELECT GroupBuyId,ProductId,EndDate FROM distro_GroupBuy WHERE EndDate>'{0}' AND Status={1} AND DistributorUserId={2} AND ProductId IN(SELECT ProductId FROM distro_Products WHERE SaleStatus=1 AND DistributorUserId={2}) ORDER BY DisplaySequence DESC", DateTime.Now, 1, HiContext.Current.SiteSettings.UserId.Value);
this.database.AddInParameter(storedProcCommand, "DistributorUserId", DbType.Int32, HiContext.Current.SiteSettings.UserId.Value);
this.database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, query.PageIndex);
this.database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, query.PageSize);
this.database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, query.IsCount);
this.database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, str);
this.database.AddOutParameter(storedProcCommand, "TotalGroupBuyProducts", DbType.Int32, 4);
DataSet set = this.database.ExecuteDataSet(storedProcCommand);
count = (int) this.database.GetParameterValue(storedProcCommand, "TotalGroupBuyProducts");
return set;
}