/// <summary>
/// 用于ProductSearch页面的几个字段的AutoCompleted用(新需求：Millie,Mike)2014年3月7日
/// </summary>
/// <param name="term"></param>
/// <param name="type"></param>
/// <returns></returns>
public ActionResult GetAutoCompeltedInfo(string term, int type)
{
var pss = new ProductSearchServices();
return(Json(new NBCMSResultJson
{
Status = StatusType.OK,
Data = pss.GetAutoCompeltedInfo(term, type)
}));
}
public JsonResult List(Guid?categoryId, List <Guid> categoryIds, string keywords,
int?skip, int?take, string sortField, string orderBy)
{
var xtake = 10;
var xskip = 0;
long total = 0;
if (skip != null)
{
xskip = skip.Value;
}
if (take != null)
{
xtake = take.Value;
}
if (string.IsNullOrEmpty(sortField))
{
sortField = nameof(FeNews.CreatedDate);
}
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "desc";
}
List <FeProduct> rows = new List <FeProduct>();
List <ContentLanguage> contentLanguages = null;
categoryIds = categoryIds ?? new List <Guid>();
if (categoryId != null && categoryId.Value != Guid.Empty)
{
categoryIds.Add(categoryId.Value);
}
var producs = ProductSearchServices.Search(keywords, LanguageId, categoryIds, null, xskip, xtake,
out contentLanguages, out total);
foreach (var p in producs)
{
var i = new FeProduct();
i.CreatedDate = p.CreatedDate;
i.Id = p.Id;
i.Price = p.Price;
i.ProductCode = p.ProductCode;
i.Published = p.Published;
i.AllowComment = p.AllowComment;
i.Title = contentLanguages.GetValue(i.Id, "Title");
i.UrlImage = contentLanguages.GetValue(i.Id, "UrlImage");
i.SeoUrlFriendly = contentLanguages.GetValue(i.Id, "SeoUrlFriendly");
rows.Add(i);
}
return(Json(new { total, rows, success = true }, JsonRequestBehavior.AllowGet));
}
public FileResult ExportToExcel(string postData, User_Profile_Model useInfo)
{
try
{
//反序列化客户端传递上来的数据
var serializer = new JavaScriptSerializer();
var model = serializer.Deserialize(postData, typeof(SKU_Query_Model)) as SKU_Query_Model;
var pcSvr = new ProductSearchServices();
var fileName = pcSvr.ExoprtedSKUDataToServer(model, useInfo);
var exportPath = System.Web.HttpContext.Current.Server.MapPath("~/MediaLib/");
var path = exportPath + fileName;
return(File(path, "application/ms-txt", fileName));
}
catch (Exception ex)
{
NBCMSLoggerManager.Error("Message:" + ex.Message);
NBCMSLoggerManager.Error("Source:" + ex.Source);
NBCMSLoggerManager.Error("StackTrace:" + ex.StackTrace);
return(null);
// return this.ExcelCSV("There is a error has been occur please contact administrator".ToString(), "Product_Search_Result_Error.csv", "application/ms-txt");
}
}
public JsonResult ListResult(string keywords,
int?skip, int?take, string sortField, string orderBy)
{
var xtake = 10;
var xskip = 0;
long total = 0;
if (skip != null)
{
xskip = skip.Value;
}
if (take != null)
{
xtake = take.Value;
}
if (string.IsNullOrEmpty(sortField))
{
sortField = nameof(FeProduct.CreatedDate);
}
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "desc";
}
List <FeProduct> rows = new List <FeProduct>();
if (!string.IsNullOrEmpty(keywords))
{
List <ContentLanguage> contentLanguages = null;
var tempProduct = ProductSearchServices.Search(keywords, LanguageId, new List <Guid>()
{
}, true, xskip, xtake,
out contentLanguages, out total);
if (tempProduct.Count == 0)
{
rows.Add(new FeProduct()
{
Title = "Not found any content match with keywords"
});
}
else
{
foreach (var p in tempProduct)
{
var i = new FeProduct();
i.CreatedDate = p.CreatedDate;
i.Id = p.Id;
i.ProductCode = p.ProductCode;
i.Price = p.Price;
i.Quantity = p.Quantity;
i.Published = p.Published;
i.Title = contentLanguages.GetValue(p.Id, "Title");
i.ShortDescription = contentLanguages.GetValue(p.Id, "ShortDescription");
i.UrlImage = contentLanguages.GetValue(p.Id, "UrlImage");
i.SeoUrlFriendly = contentLanguages.GetValue(p.Id, "SeoUrlFriendly");
rows.Add(i);
}
}
}
else
{
rows.Add(new FeProduct()
{
Title = "No keywords to search"
});
}
return(Json(new { total, rows, success = true }, JsonRequestBehavior.AllowGet));
}