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")); } }