private void BindProducts()
{
LoadParameters();
ProductQuery entity = new ProductQuery();
entity.Keywords = productName;
entity.ProductCode = productCode;
entity.CategoryId = categoryId;
entity.ProductLineId = lineId;
entity.PublishStatus = publishStatus;
entity.PageSize = pager.PageSize;
entity.PageIndex = pager.PageIndex;
entity.SortOrder = SortAction.Desc;
entity.SortBy = "DisplaySequence";
entity.StartDate = startDate;
entity.EndDate = endDate;
if (categoryId.HasValue)
{
entity.MaiCategoryPath = SubsiteCatalogHelper.GetCategory(categoryId.Value).Path;
}
Globals.EntityCoding(entity, true);
DbQueryResult toTaobaoProducts = SubSiteProducthelper.GetToTaobaoProducts(entity);
grdProducts.DataSource = toTaobaoProducts.Data;
grdProducts.DataBind();
txtSearchText.Text = entity.Keywords;
txtSKU.Text = entity.ProductCode;
dropCategories.SelectedValue = entity.CategoryId;
dropLines.SelectedValue = entity.ProductLineId;
pager1.TotalRecords = pager.TotalRecords = toTaobaoProducts.TotalRecords;
}
private void ProcessProductSearch(System.Web.HttpContext context)
{
string str = "http://" + System.Web.HttpContext.Current.Request.Url.Host + ((System.Web.HttpContext.Current.Request.Url.Port == 80) ? "" : (":" + System.Web.HttpContext.Current.Request.Url.Port));
ProductQuery productQuery = new ProductQuery();
productQuery.UserId = new int?(int.Parse(context.Request["distributorUserId"]));
productQuery.PageIndex = int.Parse(context.Request["pageIndex"]);
productQuery.PageSize = int.Parse(context.Request["pageSize"]);
productQuery.Keywords = context.Request["productName"];
productQuery.ProductCode = context.Request["productCode"];
if (!string.IsNullOrEmpty(context.Request["publishStatus"]))
{
productQuery.PublishStatus = (PublishStatus)int.Parse(context.Request["publishStatus"]);
}
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
productQuery.StartDate = new System.DateTime?(System.DateTime.Parse(context.Request["startDate"]));
}
if (!string.IsNullOrEmpty(context.Request["endDate"]))
{
productQuery.EndDate = new System.DateTime?(System.DateTime.Parse(context.Request["endDate"]));
}
Globals.EntityCoding(productQuery, true);
DbQueryResult toTaobaoProducts = SubSiteProducthelper.GetToTaobaoProducts(productQuery);
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("{");
stringBuilder.Append("\"Products\":[");
System.Data.DataTable dataTable = (System.Data.DataTable)toTaobaoProducts.Data;
if (dataTable.Rows.Count > 0)
{
foreach (System.Data.DataRow dataRow in dataTable.Rows)
{
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"ProductId\":{0},", dataRow["ProductId"]);
stringBuilder.AppendFormat("\"ProductDetailLink\":\"{0}\",", str + Globals.GetSiteUrls().UrlData.FormatUrl("productDetails", new object[]
{
dataRow["ProductId"]
}));
stringBuilder.AppendFormat("\"DisplaySequence\":{0},", dataRow["DisplaySequence"]);
stringBuilder.AppendFormat("\"ThumbnailUrl40\":\"{0}\",", (dataRow["ThumbnailUrl40"] != System.DBNull.Value) ? (str + Globals.ApplicationPath + (string)dataRow["ThumbnailUrl40"]) : "");
stringBuilder.AppendFormat("\"ProductName\":\"{0}\",", dataRow["ProductName"]);
stringBuilder.AppendFormat("\"ProductCode\":\"{0}\",", dataRow["ProductCode"]);
stringBuilder.AppendFormat("\"Stock\":{0},", dataRow["Stock"]);
stringBuilder.AppendFormat("\"MarketPrice\":{0},", (dataRow["MarketPrice"] != System.DBNull.Value) ? ((decimal)dataRow["MarketPrice"]).ToString("F2") : "0");
stringBuilder.AppendFormat("\"SalePrice\":{0},", (dataRow["SalePrice"] != System.DBNull.Value) ? ((decimal)dataRow["SalePrice"]).ToString("F2") : "0");
stringBuilder.AppendFormat("\"PurchasePrice\":{0},", (dataRow["PurchasePrice"] != System.DBNull.Value) ? ((decimal)dataRow["PurchasePrice"]).ToString("F2") : "0");
stringBuilder.AppendFormat("\"IsPublish\":{0}", (dataRow["IsPublish"] != System.DBNull.Value) ? ((int)dataRow["IsPublish"]) : -1);
stringBuilder.Append("},");
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
}
stringBuilder.Append("],");
stringBuilder.AppendFormat("\"TotalResults\":{0}", toTaobaoProducts.TotalRecords);
stringBuilder.Append("}");
context.Response.Write(stringBuilder.ToString());
}
