public ActionResult UCNoReviewOrderProducts(int pageIndex, int pageSize)
{
LoginUser suer = UserMgr.ReadUserInfo();
var noReviewOrders = ReviewFacade.QueryCustomerNoReviewOrderProducts(suer.UserSysNo, pageIndex, pageSize);
return(PartialView("_NoReviewOrderProducts", noReviewOrders));
}
/// <summary>
/// Create the instance of Review Facade
/// Get all querystring values
/// </summary>
private void Initialize()
{
_reviewFacade = new ReviewFacade(Base.Classes.AppSettings.ConnectionString);
_questionId = Convert.ToInt32(GetValueFromQueryString<string>("QuestionID"));
_userId = new Guid(GetValueFromQueryString<string>("UserID"));
_isEnabled = GetValueFromQueryString<bool>("IsEnabled");
}
/// <summary>
/// 评论有用没有
/// </summary>
/// <returns></returns>
public JsonResult AjaxReviewVote()
{
int reviewSysNo = 0;
int isUsefull = 0;
int.TryParse(Request.Params["ReviewSysNo"], out reviewSysNo);
int.TryParse(Request.Params["IsUsefull"], out isUsefull);
LoginUser user = UserMgr.ReadUserInfo();
if (user == null || user.UserSysNo <= 0)
{
return(new JsonResult()
{
Data = BuildAjaxErrorObject("请先登录！")
});
}
//成功
if (ReviewFacade.UpdateReviewVote(user.UserSysNo, reviewSysNo, isUsefull))
{
return(new JsonResult()
{
Data = 1
});
}
//失败
return(new JsonResult()
{
Data = 0
});
}
public ActionResult UCProductReviewList(string PageIndex, string PageSize, string SearchType, string ProductSysNo, string ProductGroupSysNo)
{
Product_ReviewQueryInfo queryInfo = new Product_ReviewQueryInfo();
queryInfo.NeedReplyCount = 5;
queryInfo.PagingInfo = new PageInfo();
int tempIndex = 0;
if (int.TryParse(PageIndex, out tempIndex))
{
queryInfo.PagingInfo.PageIndex = tempIndex;
}
int tempSize = 0;
if (int.TryParse(PageSize, out tempSize))
{
queryInfo.PagingInfo.PageSize = tempSize;
}
int tempSearchType = 0;
if (!string.IsNullOrWhiteSpace(SearchType))
{
var searchTypeArray = SearchType.Split(new char[] { '+' }, StringSplitOptions.RemoveEmptyEntries);
queryInfo.SearchType.Clear();
foreach (string searchType in searchTypeArray)
{
if (int.TryParse(searchType, out tempSearchType))
{
queryInfo.SearchType.Add((ReviewScoreType)tempSearchType);
}
}
}
int tempProductSysNo = 0;
if (int.TryParse(ProductSysNo, out tempProductSysNo))
{
queryInfo.ProductSysNo = tempProductSysNo;
}
int tempProductGroupSysNo = 0;
if (int.TryParse(ProductGroupSysNo, out tempProductGroupSysNo))
{
queryInfo.ProductGroupSysNo = tempProductGroupSysNo;
}
Product_ReviewList list = ReviewFacade.GetProductReviewListByProductGroupSysNoForProduct(queryInfo);
ViewQueryResult <Product_ReviewDetail> result = new ViewQueryResult <Product_ReviewDetail>();
result.ResultList = list.ProductReviewDetailList.CurrentPageData;
result.PagingInfo.PageIndex = list.ProductReviewDetailList.PageNumber - 1;
result.PagingInfo.PageSize = list.ProductReviewDetailList.PageSize;
result.PagingInfo.TotalCount = list.ProductReviewDetailList.TotalRecords;
return((ActionResult)View(result));
}
public IEnumerable <ReviewDto> GetReviews(int refId, bool isPublished = true)
{
using (IUnitOfWork uow = UnitOfWorkFactory.Instance.Start(DataStoreResolver.CMSDataStoreKey))
{
ReviewFacade facade = new ReviewFacade(uow);
List <ReviewDto> result = facade.RetrieveReviewsByReference(refId, new ReviewConverter());
return(result.OrderByDescending(o => o.Id));
}
}
private IFacadeUpdateResult <ReviewData> SaveReview(ReviewInfoDto review)
{
using (IUnitOfWork uow = UnitOfWorkFactory.Instance.Start(DataStoreResolver.CRMDataStoreKey))
{
ReviewFacade facade = new ReviewFacade(uow);
IFacadeUpdateResult <ReviewData> result = facade.SaveSupplierReview(review);
return(result);
}
}
public IFacadeUpdateResult <ReviewData> SaveReview(ReviewDto instance, int refId)
{
using (IUnitOfWork uow = UnitOfWorkFactory.Instance.Start(DataStoreResolver.CMSDataStoreKey))
{
ReviewFacade facade = new ReviewFacade(uow);
IFacadeUpdateResult <ReviewData> result = facade.SaveReview(ReviewConverter.ConvertToData(instance), refId);
return(result);
}
}
private void RetrieveData(object instanceId)
{
using (IUnitOfWork uow = UnitOfWorkFactory.Instance.Start(DataStoreResolver.CRMDataStoreKey))
{
ProductFacade facade = new ProductFacade(uow);
CurrentInstance = facade.RetrieveProductInfo(instanceId, new ProductInfoConverter(CurrentUserContext.CurrentLanguage.Id));
// Get product reviews
ReviewFacade reviewFacade = new ReviewFacade(uow);
CurrentInstance.Reviews = reviewFacade.RetrieveReviewsByProduct(instanceId, new ReviewInfoConverter());
}
}
public void TestAll()
{
ReviewFacade facade = new ReviewFacade(UnitOfWork);
List <ReviewDto> result = facade.RetrieveAllReview(new ReviewConverter());
if (result != null)
{
}
List <ReviewDto> result2 = facade.RetrieveReviewsByReference(0, new ReviewConverter());
if (result2 != null)
{
}
}
private void RetrieveData()
{
using (IUnitOfWork uow = UnitOfWorkFactory.Instance.Start(DataStoreResolver.CRMDataStoreKey))
{
SupplierFacade facade = new SupplierFacade(uow);
CurrentInstance = facade.RetrieveSupplierInfo(InstanceId, new SupplierInfoConverter(CurrentUserContext.CurrentLanguage.Id));
// Get Supplier reviews
ReviewFacade reviewFacade = new ReviewFacade(uow);
CurrentInstance.Reviews = reviewFacade.RetrieveReviewsBySupplier(InstanceId, new ReviewInfoConverter());
// Get Supplier products
ProductFacade productFacade = new ProductFacade(uow);
CurrentInstance.Products = productFacade.RetrieveProductsBySupplier(InstanceId, new ProductInfoConverter(CurrentUserContext.CurrentLanguage.Id));
}
}
/// <summary>
/// 创建评论
/// </summary>
/// <returns></returns>
public JsonResult CreateReview()
{
Product_ReviewDetail info = new Product_ReviewDetail();
info.ProductSysNo = int.Parse(Request["ProductSysNo"].ToString());
info.Title = Request["Title"].ToString();
info.Prons = Request["Prons"].ToString();
//info.Cons = Request["Cons"].ToString();
//info.Service = Request["Service"].ToString();
info.Image = Request["Image"].ToString();
int tempso = int.Parse(Request["SoSysNo"].ToString());
if (tempso != 0 && tempso > 0)
{
info.SOSysno = tempso;
}
decimal s1 = Convert.ToDecimal(string.IsNullOrEmpty(Request["Score1"].ToString()) == true ? "5" : Request["Score1"].ToString());
decimal s2 = Convert.ToDecimal(string.IsNullOrEmpty(Request["Score2"].ToString()) == true ? "5" : Request["Score2"].ToString());
decimal s3 = Convert.ToDecimal(string.IsNullOrEmpty(Request["Score3"].ToString()) == true ? "5" : Request["Score3"].ToString());
decimal s4 = Convert.ToDecimal(string.IsNullOrEmpty(Request["Score4"].ToString()) == true ? "5" : Request["Score4"].ToString());
info.Score1 = Convert.ToInt32(s1);
info.Score2 = Convert.ToInt32(s2);
info.Score3 = Convert.ToInt32(s3);
info.Score4 = Convert.ToInt32(s4);
info.CustomerInfo.SysNo = this.CurrUser.UserSysNo;
info.ReviewType = ReviewType.Common;
bool IsSuccess = ReviewFacade.CreateProductReview(info);
if (IsSuccess)
{
return(new JsonResult()
{
Data = 1
});
}
else
{
return(new JsonResult()
{
Data = 0
});
}
}
public void SaveReview()
{
// Mock data
ReviewDto dto = new ReviewDto();
dto.Title = "test1";
dto.Content = "review 1 content";
dto.IssuedBy = "david";
dto.IssuedByEmail = "*****@*****.**";
dto.IsPublished = true;
ReviewData data = ReviewConverter.ConvertToData(dto);
ReviewFacade facade = new ReviewFacade(UnitOfWork);
IFacadeUpdateResult <ReviewData> result = facade.SaveReview(data, 0);
if (result.IsSuccessful)
{
}
}
public static ProductReviewListViewModel GetProductReviewList(int productSysNo, int productGroupSysNo, List <ReviewScoreType> searchType, int pageIndex, int pageSize)
{
Product_ReviewQueryInfo queryInfo = new Product_ReviewQueryInfo()
{
ProductSysNo = productSysNo, ProductGroupSysNo = productGroupSysNo, SearchType = searchType, PagingInfo = new PageInfo()
{
PageSize = pageSize, PageIndex = pageIndex
}
};
var originReviewResult = ReviewFacade.GetProductReviewListByProductGroupSysNoForProduct(queryInfo);
var result = EntityConverter <Product_ReviewList, ProductReviewListViewModel> .Convert(originReviewResult, (s, t) =>
{
t.ProductReviewDetailList.PageIndex = s.ProductReviewDetailList.PageNumber - 1;
t.ProductReviewDetailList.PageSize = s.ProductReviewDetailList.PageSize;
t.ProductReviewDetailList.TotalRecords = s.ProductReviewDetailList.TotalRecords;
t.ProductReviewDetailList.CurrentPageData = EntityConverter <List <Product_ReviewDetail>, List <ProductReviewDetailItemViewModel> > .Convert(s.ProductReviewDetailList.CurrentPageData);
t.TotalCount1 = s.TotalCount1 + s.TotalCount2;
t.TotalCount3 = s.TotalCount3 + s.TotalCount4;
if (t.ProductReviewDetailList != null && t.ProductReviewDetailList.CurrentPageData != null && t.ProductReviewDetailList.CurrentPageData.Count > 0)
{
for (int i = 0; i < t.ProductReviewDetailList.CurrentPageData.Count; i++)
{
t.ProductReviewDetailList.CurrentPageData[i].NickName = s.ProductReviewDetailList.CurrentPageData[i].CustomerInfo.NickName;
}
}
t.ProductReviewDetailList.PageIndex = pageIndex - 1;
t.ProductReviewDetailList.PageSize = pageSize;
t.ProductReviewDetailList.TotalRecords = searchType.Contains(ReviewScoreType.ScoreType11) ? t.TotalCount1 : (searchType.Contains(ReviewScoreType.ScoreType13) ? t.TotalCount3 : (searchType.Contains(ReviewScoreType.ScoreType15) ? t.TotalCount5 : t.TotalCount1));
t.ProductReviewDetailList.TotalPages = t.ProductReviewDetailList.TotalRecords <= 0 ? 0 : (t.ProductReviewDetailList.TotalRecords % t.ProductReviewDetailList.PageSize == 0 ? t.ProductReviewDetailList.TotalRecords / t.ProductReviewDetailList.PageSize : t.ProductReviewDetailList.TotalRecords / t.ProductReviewDetailList.PageSize + 1);
if (null != t.ProductReviewScore && t.ProductReviewScore.ProductSysNo == 0)
{
t.ProductReviewScore.ProductSysNo = productSysNo;
}
});
return(result);
}
/// <summary>
/// 发表回复
/// </summary>
/// <param name="replyInfo"></param>
/// <returns></returns>
public JsonResult CreateProductReviewReply()
{
Product_ReplyDetail replyInfo = new Product_ReplyDetail();
replyInfo.ReviewSysNo = int.Parse(Request["ReviewSysNo"].ToString());
replyInfo.Content = Request["Content"].ToString();
replyInfo.Customer.SysNo = this.CurrUser.UserSysNo;
int ProductSysNo = int.Parse(Request["ProductSysNo"].ToString());
replyInfo.Customer.CustomerID = this.CurrUser.UserID;
int SoSysNo = int.Parse(Request["SOSysNo"].ToString());
replyInfo.Customer.Email = Request["Mail"].ToString();
bool IsSuccess = ReviewFacade.CreateProductReviewReply(replyInfo, SoSysNo);
if (IsSuccess)
{
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("发表评论失败！", JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 评论列表页获取评论列表
/// </summary>
/// <returns></returns>
public PartialViewResult GetProudctReviewList()
{
int productGroupSysNo = int.Parse(Request["ProductGroupSysNo"].ToString());
int serchType = int.Parse(Request["SearchType"].ToString());
int productSysNo = int.Parse(Request["ProductSysNo"].ToString());
int pageIndex = 1;
int.TryParse(Request.QueryString["page"], out pageIndex);
Product_ReviewQueryInfo queryInfo = new Product_ReviewQueryInfo();
queryInfo.ProductGroupSysNo = productGroupSysNo;
queryInfo.SearchType.Clear();
queryInfo.SearchType.Add((ReviewScoreType)serchType);
queryInfo.NeedReplyCount = 5;
queryInfo.ProductSysNo = productSysNo;
queryInfo.PagingInfo = new PageInfo()
{
PageIndex = pageIndex == 0 ? 1 : pageIndex, PageSize = 10
};
//ViewBag.ProductSysNo = productSysNo;
Product_ReviewList list = ReviewFacade.GetProductReviewListByProductGroupSysNoForProduct(queryInfo);
return(PartialView("~/Views/UserControl/Product/UCProductReview.cshtml", list));
}
protected void ucReviewList_ReviewSaving(object sender, ObjectSavingEventArgs e)
{
ReviewInfoDto review = e.Instance as ReviewInfoDto;
review.ObjectId = CurrentSupplier.SupplierId;
review.IssuedById = CurrentUserContext.User.UserId;
IFacadeUpdateResult <ReviewData> result = SaveReview(review);
if (result.IsSuccessful)
{
using (IUnitOfWork uow = UnitOfWorkFactory.Instance.Start(DataStoreResolver.CRMDataStoreKey))
{
// Get product reviews
ReviewFacade reviewFacade = new ReviewFacade(uow);
ucReviewList.Instances = reviewFacade.RetrieveReviewsBySupplier(CurrentSupplier.SupplierId, new ReviewInfoConverter());
ucReviewList.ListDataBind();
}
}
else
{
ProcUpdateResult(result.ValidationResult, result.Exception);
}
}
protected new void Page_Init(object sender, EventArgs e)
{
base.Page_Init(sender, e);
_reviewFacade = new ReviewFacade(AppSettings.ConnectionString);
}
/// <summary>
/// Initialize the respective variables
/// </summary>
private void Initialize()
{
_reviewFacade = new ReviewFacade(Base.Classes.AppSettings.ConnectionString);
}
/// <summary>
/// 获取商品评论
/// </summary>
/// <returns></returns>
public PartialViewResult AjaxGetProudctReview()
{
int productGroupSysNo = int.Parse(Request["ProductGroupSysNo"].ToString());
//int serchType = int.Parse(Request["SearchType"].ToString());
int productSysNo = int.Parse(Request["ProductSysNo"].ToString());
Product_ReviewQueryInfo queryInfo = new Product_ReviewQueryInfo();
queryInfo.ProductGroupSysNo = productGroupSysNo;
//queryInfo.SearchType.Clear();
//queryInfo.SearchType.Add((ReviewScoreType)serchType);
string SearchType = Request["SearchType"];
int tempSearchType;
if (!string.IsNullOrWhiteSpace(SearchType))
{
var searchTypeArray = SearchType.Split(new char[] { '+' }, StringSplitOptions.RemoveEmptyEntries);
queryInfo.SearchType.Clear();
foreach (string searchType in searchTypeArray)
{
if (int.TryParse(searchType, out tempSearchType))
{
queryInfo.SearchType.Add((ReviewScoreType)tempSearchType);
}
}
}
queryInfo.NeedReplyCount = 5;
queryInfo.ProductSysNo = productSysNo;
queryInfo.PagingInfo = new PageInfo()
{
PageIndex = 0, PageSize = 5
};
ViewBag.ProductSysNo = productSysNo;
return(PartialView("~/Views/UserControl/Product/UCProductReviewItem.cshtml", ReviewFacade.GetProductReviewListByProductGroupSysNoForProduct(queryInfo)));
}
/// <summary>
/// Initialize the instances and get the respective itemId from query string
/// </summary>
private void Initialize()
{
_reviewFacade = new ReviewFacade(Base.Classes.AppSettings.ConnectionString);
_questionId = GetValueFromQueryString<int>("ItemID");
_source = GetValueFromQueryString<string>("Source");
_actionId = GetValueFromQueryString<string>("ActionID");
}
/// <summary>
/// Initialize the instances and get the respective itemId from query string
/// </summary>
private void Initialize()
{
_reviewFacade = new ReviewFacade(Base.Classes.AppSettings.ConnectionString);
_questionId = GetValueFromQueryString<int>("ItemID");
SetHiddenFieldClientId(btnShowAll.ClientID.ToString(CultureInfo.InvariantCulture));
}
