public virtual IList <ProductReviewInfo> GetProductReviews(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ProductReviewInfo> entitys = null;
ProductReviewInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Product_Review";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ProductReviewInfo>();
while (RdrList.Read())
{
entity = new ProductReviewInfo();
entity.Product_Review_ID = Tools.NullInt(RdrList["Product_Review_ID"]);
entity.Product_Review_ProductID = Tools.NullInt(RdrList["Product_Review_ProductID"]);
entity.Product_Review_MemberID = Tools.NullInt(RdrList["Product_Review_MemberID"]);
entity.Product_Review_Star = Tools.NullInt(RdrList["Product_Review_Star"]);
entity.Product_Review_Subject = Tools.NullStr(RdrList["Product_Review_Subject"]);
entity.Product_Review_Content = Tools.NullStr(RdrList["Product_Review_Content"]);
entity.Product_Review_Useful = Tools.NullInt(RdrList["Product_Review_Useful"]);
entity.Product_Review_Useless = Tools.NullInt(RdrList["Product_Review_Useless"]);
entity.Product_Review_Addtime = Tools.NullDate(RdrList["Product_Review_Addtime"]);
entity.Product_Review_IsShow = Tools.NullInt(RdrList["Product_Review_IsShow"]);
entity.Product_Review_IsBuy = Tools.NullInt(RdrList["Product_Review_IsBuy"]);
entity.Product_Review_IsGift = Tools.NullInt(RdrList["Product_Review_IsGift"]);
entity.Product_Review_IsView = Tools.NullInt(RdrList["Product_Review_IsView"]);
entity.Product_Review_IsRecommend = Tools.NullInt(RdrList["Product_Review_IsRecommend"]);
entity.Product_Review_Site = Tools.NullStr(RdrList["Product_Review_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
/// <summary>
/// 保存备注
/// </summary>
/// <param name="item">The item.</param>
public static void SaveProductReviewRemark(ProductReviewInfo item)
{
using (ITransaction transaction = TransactionManager.Create())
{
if (item.IsIndexHotReview == "Y")//操作首页热评，更新或新建
{
ProductReviewDA.UpdateHomepageForProductReview(item.SysNo.Value, "H");
}
else
{
ProductReviewDA.DeleteHomepageForProductReview(item.SysNo.Value, "H");
}
if (item.IsServiceHotReview == "Y")//操作首页服务热评，更新或新建
{
ProductReviewDA.UpdateHomepageForProductReview(item.SysNo.Value, "S");
}
else
{
ProductReviewDA.DeleteHomepageForProductReview(item.SysNo.Value, "S");
}
ProductReviewDA.UpdateProductReview(item);
transaction.Complete();
}
}
public void DelProductReview()
{
int review_id = tools.CheckInt(Request.QueryString["review_id"]);
if (review_id > 0)
{
ProductReviewInfo entity = Myreview.GetProductReviewByID(review_id, Public.GetUserPrivilege());
if (entity != null)
{
if (entity.Product_Review_IsShow == 0)
{
if (Myreview.DelProductReview(review_id, Public.GetUserPrivilege()) > 0)
{
Public.Msg("positive", "操作成功", "操作成功", true, "Product_Review_list.aspx");
}
else
{
Public.Msg("error", "错误信息", "删除失败", true, "Product_Review_list.aspx");
}
}
else
{
Public.Msg("error", "错误信息", "请先取消审核该评论！", true, "Product_Review_list.aspx");
}
}
else
{
Public.Msg("error", "错误信息", "评论信息不存在", true, "Product_Review_list.aspx");
}
}
else
{
Public.Msg("error", "错误信息", "请选择要删除的评论信息", true, "Product_Review_list.aspx");
}
}
/// <summary>
/// 添加评论
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void grdProducts_ItemCommand(object sender, GridViewDeleteEventArgs e)
{
this.grdProducts.DataKeys[e.RowIndex].Value.ToString();
//object o = this.grdProducts.Rows[e.RowIndex].Cells;
TextBox tbox = (TextBox)this.grdProducts.Rows[e.RowIndex].Cells[1].Controls[1];
string str = tbox.Text.Trim();
if (!string.IsNullOrEmpty(str))
{
ProductReviewInfo review = new ProductReviewInfo
{
ReviewDate = System.DateTime.Now,
ReviewText = str,
ProductId = Convert.ToInt32(this.grdProducts.DataKeys[e.RowIndex].Value.ToString()),
UserEmail = "",
UserId = 0,
UserName = "******"
};
if (ProductBrowser.InsertProductReview(review))
{
this.ShowMsg("修改成功!", true);
}
else
{
this.ShowMsg("修改失败!", false);
}
}
else
{
this.ShowMsg("请填写回复信息!", false);
}
}
/// <summary>
/// 更新评论相关的信息
/// </summary>
/// <param name="item">The item.</param>
public static void UpdateProductReview(ProductReviewInfo item)
{
DataCommand dataCommand = DataCommandManager.GetDataCommand("ProductReview_UpdateProductReview");
dataCommand.SetParameterValue <ProductReviewInfo>(item);
dataCommand.ExecuteNonQuery();
}
/// <summary>
/// 评价商品
/// </summary>
public static void ReviewProduct(ProductReviewInfo productReviewInfo)
{
BrnShop.Core.BSPData.RDBS.ReviewProduct(productReviewInfo);
if (_ordernosql != null)
{
_ordernosql.ReviewProduct(productReviewInfo.Oid, productReviewInfo.ReviewId);
}
}
public void btnRefer_Click(object sender, EventArgs e)
{
if (this.ValidateConvert())
{
ProductReviewInfo target = new ProductReviewInfo();
target.ReviewDate = DateTime.Now;
target.ProductId = this.productId;
target.UserId = HiContext.Current.User.UserId;
target.UserName = this.txtUserName.Text;
target.UserEmail = this.txtEmail.Text;
target.ReviewText = this.txtContent.Text;
ValidationResults results = Hishop.Components.Validation.Validation.Validate <ProductReviewInfo>(target, new string[] { "Refer" });
string msg = string.Empty;
if (!results.IsValid)
{
foreach (ValidationResult result in (IEnumerable <ValidationResult>)results)
{
msg = msg + Formatter.FormatErrorMessage(result.Message);
}
this.ShowMessage(msg, false);
}
else if (((HiContext.Current.User.UserRole == UserRole.Member) || (HiContext.Current.User.UserRole == UserRole.Underling)) || this.userRegion(this.txtReviewUserName.Value, this.txtReviewPsw.Value))
{
if (string.IsNullOrEmpty(this.txtReviewCode.Value))
{
this.ShowMessage("请输入验证码", false);
}
else if (!HiContext.Current.CheckVerifyCode(this.txtReviewCode.Value.Trim()))
{
this.ShowMessage("验证码不正确", false);
}
else
{
int buyNum = 0;
int reviewNum = 0;
ProductBrowser.LoadProductReview(this.productId, out buyNum, out reviewNum);
if (buyNum == 0)
{
this.ShowMessage("您没有购买此商品，因此不能进行评论", false);
}
else if (reviewNum >= buyNum)
{
this.ShowMessage("您已经对此商品进行了评论，请再次购买后方能再进行评论", false);
}
else if (ProductProcessor.InsertProductReview(target))
{
this.Page.ClientScript.RegisterClientScriptBlock(base.GetType(), "success", string.Format("<script>alert(\"{0}\");window.location.href=\"{1}\"</script>", "评论成功", Globals.GetSiteUrls().UrlData.FormatUrl("productReviews", new object[] { this.productId })));
}
else
{
this.ShowMessage("评论失败，请重试", false);
}
}
}
}
}
public static bool ReplyProductReview(int reviewId, string replyText)
{
Globals.EntityCoding(replyText, true);
ProductReviewDao productReviewDao = new ProductReviewDao();
ProductReviewInfo productReviewInfo = productReviewDao.Get <ProductReviewInfo>(reviewId);
productReviewInfo.ReplyDate = DateTime.Now;
productReviewInfo.ReplyText = replyText;
return(productReviewDao.Update(productReviewInfo, null));
}
public virtual bool AddProductReview(ProductReviewInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "0b385bc8-aea0-4792-afb6-935e96a8aa3c"))
{
return(MyDAL.AddProductReview(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：0b385bc8-aea0-4792-afb6-935e96a8aa3c错误");
}
}
public override bool InsertProductReview(ProductReviewInfo review)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Hishop_ProductReviews (ProductId, UserId, ReviewText, UserName, UserEmail, ReviewDate) VALUES(@ProductId, @UserId, @ReviewText, @UserName, @UserEmail, @ReviewDate)");
this.database.AddInParameter(sqlStringCommand, "ProductId", System.Data.DbType.Int32, review.ProductId);
this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, HiContext.Current.User.UserId);
this.database.AddInParameter(sqlStringCommand, "ReviewText", System.Data.DbType.String, review.ReviewText);
this.database.AddInParameter(sqlStringCommand, "UserName", System.Data.DbType.String, review.UserName);
this.database.AddInParameter(sqlStringCommand, "UserEmail", System.Data.DbType.String, review.UserEmail);
this.database.AddInParameter(sqlStringCommand, "ReviewDate", System.Data.DbType.DateTime, DateTime.Now);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public virtual bool EditProductReview(ProductReviewInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "cb1e9c33-7ac5-4939-8520-a0e192cb0129"))
{
return(MyDAL.EditProductReview(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：cb1e9c33-7ac5-4939-8520-a0e192cb0129错误");
}
}
/// <summary>
/// Loads the product review with reply.
/// </summary>
/// <param name="sysNo">The system no.</param>
/// <returns></returns>
public static ProductReviewInfo LoadProductReviewWithReply(int sysNo)
{
ProductReviewInfo item = ProductReviewDA.LoadProductReview(sysNo);//评论主题
if (item != null)
{
item.ProductReviewReplyList = ProductReviewDA.GetProductReviewReplyList(sysNo); //评论回复列表
item.VendorReplyList = ProductReviewDA.GetProductReviewFactoryReply(sysNo); //厂商回复
}
return(item);
}
/// <summary>
/// 获得商品评价
/// </summary>
/// <param name="reviewId">评价id</param>
/// <returns></returns>
public static ProductReviewInfo GetProductReviewById(int reviewId)
{
ProductReviewInfo productReviewInfo = null;
IDataReader reader = NStore.Core.BMAData.RDBS.GetProductReviewById(reviewId);
if (reader.Read())
{
productReviewInfo = BuildProductReviewFromReader(reader);
}
reader.Close();
return(productReviewInfo);
}
/// <summary>
/// 后台获得商品评价
/// </summary>
/// <param name="reviewId">评价id</param>
/// <returns></returns>
public static ProductReviewInfo AdminGetProductReviewById(int reviewId)
{
ProductReviewInfo productReviewInfo = null;
IDataReader reader = BrnShop.Core.BSPData.RDBS.AdminGetProductReviewById(reviewId);
if (reader.Read())
{
productReviewInfo = BuildProductReviewFromReader(reader);
}
reader.Close();
return(productReviewInfo);
}
public override bool InsertProductReview(ProductReviewInfo review)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO distro_ProductReviews (ProductId, UserId,DistributorUserId, ReviewText, UserName, UserEmail, ReviewDate) VALUES(@ProductId, @UserId,@DistributorUserId, @ReviewText, @UserName, @UserEmail, @ReviewDate)");
this.database.AddInParameter(sqlStringCommand, "ProductId", DbType.Int32, review.ProductId);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, HiContext.Current.User.UserId);
this.database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.SiteSettings.UserId.Value);
this.database.AddInParameter(sqlStringCommand, "ReviewText", DbType.String, review.ReviewText);
this.database.AddInParameter(sqlStringCommand, "UserName", DbType.String, review.UserName);
this.database.AddInParameter(sqlStringCommand, "UserEmail", DbType.String, review.UserEmail);
this.database.AddInParameter(sqlStringCommand, "ReviewDate", DbType.DateTime, DateTime.Now);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
/// <summary>
/// 获得用户商品评价列表
/// </summary>
/// <param name="uid">用户id</param>
/// <returns></returns>
public static List <ProductReviewInfo> GetUserProductReviewList(int uid, int pageSize, int pageNumber)
{
List <ProductReviewInfo> productReviewList = new List <ProductReviewInfo>();
IDataReader reader = BrnShop.Core.BSPData.RDBS.GetUserProductReviewList(uid, pageSize, pageNumber);
while (reader.Read())
{
ProductReviewInfo productReviewInfo = BuildProductReviewFromReader(reader);
productReviewList.Add(productReviewInfo);
}
reader.Close();
return(productReviewList);
}
public bool InsertProductReview(ProductReviewInfo review)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Hishop_ProductReviews (ProductId, UserId, ReviewText, UserName, UserEmail, ReviewDate,OrderID,SkuID,OrderItemID) VALUES(@ProductId, @UserId, @ReviewText, @UserName, @UserEmail, @ReviewDate,@OrderID,@SkuID,@OrderItemID)");
this.database.AddInParameter(sqlStringCommand, "ProductId", System.Data.DbType.Int32, review.ProductId);
this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, review.UserId);
this.database.AddInParameter(sqlStringCommand, "ReviewText", System.Data.DbType.String, review.ReviewText);
this.database.AddInParameter(sqlStringCommand, "UserName", System.Data.DbType.String, review.UserName);
this.database.AddInParameter(sqlStringCommand, "UserEmail", System.Data.DbType.String, review.UserEmail);
this.database.AddInParameter(sqlStringCommand, "ReviewDate", System.Data.DbType.DateTime, DateTime.Now);
this.database.AddInParameter(sqlStringCommand, "OrderID", System.Data.DbType.String, review.OrderId);
this.database.AddInParameter(sqlStringCommand, "SkuID", System.Data.DbType.String, review.SkuId);
this.database.AddInParameter(sqlStringCommand, "OrderItemID", System.Data.DbType.Int32, review.OrderItemID);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public ProductReviewInfo GetProductReview(int reviewId)
{
ProductReviewInfo result = new ProductReviewInfo();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Ecshop_ProductReviews WHERE ReviewId=@ReviewId");
this.database.AddInParameter(sqlStringCommand, "ReviewId", DbType.Int32, reviewId);
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = ReaderConvert.ReaderToModel <ProductReviewInfo>(dataReader);
}
}
return(result);
}
/// <summary>
/// 获取商品明细
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public List <ProductReviewInfo> GetProductReviewAll(string orderid)
{
List <ProductReviewInfo> list = new List <ProductReviewInfo>();
try
{
ErrorLog.Write("执行了OrderReviewsJob-->GetProductReviewAll：" + DateTime.Now + "\n");
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"select Productid,SkuId from Ecshop_OrderItems AS a
WHERE not EXISTS (SELECT 1 FROM Ecshop_ProductReviews AS b WHERE (a.Productid=b.productId OR a.SKuid=b.SKuId) AND b.OrderId=@OrderId)
and OrderId=@OrderId");
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
this.database.AddInParameter(sqlStringCommand, "OrderId", DbType.String, orderid);
ProductReviewInfo info = null;
using (IDbConnection conn = this.database.CreateConnection())
{
conn.Open();
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
info = new ProductReviewInfo();
if (dataReader["SkuId"] != System.DBNull.Value)
{
info.SkuId = (string)dataReader["SkuId"];
}
if (dataReader["ProductId"] != System.DBNull.Value)
{
info.ProductId = (int)dataReader["ProductId"];
}
list.Add(info);
}
dataReader.Dispose();
dataReader.Close();
}
conn.Dispose();
conn.Close();
}
System.Threading.Thread.Sleep(new System.TimeSpan(0, 0, 0, 3, 0));
}
catch (Exception ee)
{
ErrorLog.Write("执行了OrderReviewsJob-->GetProductReviewAll:异常：" + ee.Message, ee);
}
return(list);
}
public bool InsertProductReview(ProductReviewInfo review)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Ecshop_ProductReviews (ProductId, UserId, ReviewText, UserName, UserEmail, ReviewDate,OrderId,SkuId,Score,IsAnonymous) VALUES(@ProductId, @UserId, @ReviewText, @UserName, @UserEmail, @ReviewDate,@OrderId,@SkuId,@Score,@IsAnonymous)");
this.database.AddInParameter(sqlStringCommand, "ProductId", DbType.Int32, review.ProductId);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, review.UserId);
this.database.AddInParameter(sqlStringCommand, "ReviewText", DbType.String, review.ReviewText);
this.database.AddInParameter(sqlStringCommand, "UserName", DbType.String, (string.IsNullOrEmpty(review.UserName) ? "" : review.UserName));
this.database.AddInParameter(sqlStringCommand, "UserEmail", DbType.String, (string.IsNullOrEmpty(review.UserEmail) ? "" : review.UserEmail));
this.database.AddInParameter(sqlStringCommand, "ReviewDate", DbType.DateTime, DateTime.Now);
this.database.AddInParameter(sqlStringCommand, "OrderId", DbType.String, review.OrderID);
this.database.AddInParameter(sqlStringCommand, "SkuId", DbType.String, review.SkuId);
this.database.AddInParameter(sqlStringCommand, "Score", DbType.Int32, review.Score);
this.database.AddInParameter(sqlStringCommand, "IsAnonymous", DbType.Boolean, review.IsAnonymous);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public override ProductReviewInfo GetProductReview(int reviewId)
{
ProductReviewInfo info = new ProductReviewInfo();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_ProductReviews WHERE ReviewId=@ReviewId AND DistributorUserId=@DistributorUserId");
this.database.AddInParameter(sqlStringCommand, "ReviewId", DbType.Int32, reviewId);
this.database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.User.UserId);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
info = DataMapper.PopulateProductReview(reader);
}
}
return(info);
}
/// <summary>
/// 删除商品评价
/// </summary>
public ActionResult DelProductReview(int reviewId)
{
ProductReviewInfo productReviewInfo = AdminProductReviews.AdminGetProductReviewById(reviewId);
if (productReviewInfo == null)
{
return(PromptView("商品评价不存在"));
}
if (productReviewInfo.StoreId != WorkContext.StoreId)
{
return(PromptView("不能删除其它店铺的商品评价"));
}
AdminProductReviews.DeleteProductReviewById(reviewId);
AddStoreAdminLog("删除商品评价", "删除商品评价,商品评价ID为:" + reviewId);
return(PromptView("商品评价删除成功"));
}
/// <summary>
/// 商品评价回复列表
/// </summary>
public ActionResult ProductReviewReplyList(int reviewId = -1)
{
ProductReviewInfo productReviewInfo = AdminProductReviews.AdminGetProductReviewById(reviewId);
if (productReviewInfo == null)
{
return(PromptView("商品评价不存在"));
}
ProductReviewReplyListModel model = new ProductReviewReplyListModel()
{
ProductReviewReplyList = AdminProductReviews.AdminGetProductReviewReplyList(reviewId),
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?reviewId={1}", Url.Action("productreviewreplylist"), reviewId));
return(View(model));
}
public virtual ProductReviewInfo GetProductReviewByID(int ID)
{
ProductReviewInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Product_Review WHERE Product_Review_ID = " + ID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new ProductReviewInfo();
entity.Product_Review_ID = Tools.NullInt(RdrList["Product_Review_ID"]);
entity.Product_Review_ProductID = Tools.NullInt(RdrList["Product_Review_ProductID"]);
entity.Product_Review_MemberID = Tools.NullInt(RdrList["Product_Review_MemberID"]);
entity.Product_Review_Star = Tools.NullInt(RdrList["Product_Review_Star"]);
entity.Product_Review_Subject = Tools.NullStr(RdrList["Product_Review_Subject"]);
entity.Product_Review_Content = Tools.NullStr(RdrList["Product_Review_Content"]);
entity.Product_Review_Useful = Tools.NullInt(RdrList["Product_Review_Useful"]);
entity.Product_Review_Useless = Tools.NullInt(RdrList["Product_Review_Useless"]);
entity.Product_Review_Addtime = Tools.NullDate(RdrList["Product_Review_Addtime"]);
entity.Product_Review_IsShow = Tools.NullInt(RdrList["Product_Review_IsShow"]);
entity.Product_Review_IsBuy = Tools.NullInt(RdrList["Product_Review_IsBuy"]);
entity.Product_Review_IsGift = Tools.NullInt(RdrList["Product_Review_IsGift"]);
entity.Product_Review_IsView = Tools.NullInt(RdrList["Product_Review_IsView"]);
entity.Product_Review_IsRecommend = Tools.NullInt(RdrList["Product_Review_IsRecommend"]);
entity.Product_Review_Site = Tools.NullStr(RdrList["Product_Review_Site"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(ProductReviewQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult productReviews = ProductCommentHelper.GetProductReviews(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(productReviews.Data);
dataGridViewModel.total = productReviews.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
ProductInfo productById = ProductHelper.GetProductById(row["ProductId"].ToInt(0));
ProductReviewInfo productReviewInfo = row.ToObject <ProductReviewInfo>();
row.Add("Type", query.havedReply);
if (productById.ProductName.Trim().Length > 22)
{
row.Add("ProductNameStr", productById.ProductName.Trim().Substring(0, 22) + "...");
}
else
{
row.Add("ProductNameStr", productById.ProductName.Trim());
}
if (productReviewInfo.ReviewText.Trim().Length >= 50)
{
row.Add("ReviewTextStr", productReviewInfo.ReviewText.Trim().Substring(0, 50) + "...");
}
else
{
row.Add("ReviewTextStr", productReviewInfo.ReviewText.Trim());
}
if (query.havedReply.ToBool())
{
if (productReviewInfo.ReplyText.Trim().Length >= 50)
{
row.Add("ReplyTextStr", productReviewInfo.ReplyText.Trim().Substring(0, 50) + "...");
}
else
{
row.Add("ReplyTextStr", productReviewInfo.ReplyText.Trim());
}
}
}
}
return(dataGridViewModel);
}
public virtual bool EditProductReview(ProductReviewInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Product_Review WHERE Product_Review_ID = " + entity.Product_Review_ID;
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Product_Review_ID"] = entity.Product_Review_ID;
DrAdd["Product_Review_ProductID"] = entity.Product_Review_ProductID;
DrAdd["Product_Review_MemberID"] = entity.Product_Review_MemberID;
DrAdd["Product_Review_Star"] = entity.Product_Review_Star;
DrAdd["Product_Review_Subject"] = entity.Product_Review_Subject;
DrAdd["Product_Review_Content"] = entity.Product_Review_Content;
DrAdd["Product_Review_Useful"] = entity.Product_Review_Useful;
DrAdd["Product_Review_Useless"] = entity.Product_Review_Useless;
DrAdd["Product_Review_IsShow"] = entity.Product_Review_IsShow;
DrAdd["Product_Review_IsBuy"] = entity.Product_Review_IsBuy;
DrAdd["Product_Review_IsGift"] = entity.Product_Review_IsGift;
DrAdd["Product_Review_IsView"] = entity.Product_Review_IsView;
DrAdd["Product_Review_IsRecommend"] = entity.Product_Review_IsRecommend;
DrAdd["Product_Review_Site"] = entity.Product_Review_Site;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
/// <summary>
/// 获取用户对该商品的评论
/// </summary>
/// <param name="productId"></param>
/// <param name="skuId"></param>
/// <param name="orderId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public ProductReviewInfo GetProductReview(int productId, string skuId, string orderId, int userId)
{
ProductReviewInfo result = new ProductReviewInfo();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT top 1 * FROM Ecshop_ProductReviews WHERE ProductId=@ProductId AND OrderId=@OrderId AND SkuId=@SkuId AND UserId=@UserId ");
this.database.AddInParameter(sqlStringCommand, "ProductId", DbType.Int32, productId);
this.database.AddInParameter(sqlStringCommand, "OrderId", DbType.String, orderId);
this.database.AddInParameter(sqlStringCommand, "SkuId", DbType.String, skuId);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, userId);
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = DataMapper.PopulateProductReview(dataReader);
}
}
return(result);
}
public static bool InsertProductReview(ProductReviewInfo review)
{
try
{
Globals.EntityCoding(review, true);
long num = new ProductReviewDao().Add(review, null);
if (num > 0)
{
ProductHelper.ClearProductCahe(review.ProductId);
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public virtual bool AddProductReview(ProductReviewInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Product_Review";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Product_Review_ID"] = entity.Product_Review_ID;
DrAdd["Product_Review_ProductID"] = entity.Product_Review_ProductID;
DrAdd["Product_Review_MemberID"] = entity.Product_Review_MemberID;
DrAdd["Product_Review_Star"] = entity.Product_Review_Star;
DrAdd["Product_Review_Subject"] = entity.Product_Review_Subject;
DrAdd["Product_Review_Content"] = entity.Product_Review_Content;
DrAdd["Product_Review_Useful"] = entity.Product_Review_Useful;
DrAdd["Product_Review_Useless"] = entity.Product_Review_Useless;
DrAdd["Product_Review_Addtime"] = entity.Product_Review_Addtime;
DrAdd["Product_Review_IsShow"] = entity.Product_Review_IsShow;
DrAdd["Product_Review_IsBuy"] = entity.Product_Review_IsBuy;
DrAdd["Product_Review_IsGift"] = entity.Product_Review_IsGift;
DrAdd["Product_Review_IsView"] = 0;
DrAdd["Product_Review_IsRecommend"] = entity.Product_Review_IsRecommend;
DrAdd["Product_Review_Site"] = entity.Product_Review_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
/// <summary>
/// 改变商品评价的状态
/// </summary>
public ActionResult ChangeProductReviewState(int reviewId = -1, int state = -1)
{
ProductReviewInfo productReviewInfo = AdminProductReviews.AdminGetProductReviewById(reviewId);
if (productReviewInfo == null || productReviewInfo.StoreId != WorkContext.StoreId)
{
return(Content("0"));
}
bool result = AdminProductReviews.ChangeProductReviewState(reviewId, state);
if (result)
{
AddStoreAdminLog("修改商品评价状态", "修改商品评价状态,商品评价ID和状态为:" + reviewId + "_" + state);
return(Content("1"));
}
else
{
return(Content("0"));
}
}
