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 bool InsertProductReview(ProductReviewInfo review) { 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", 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, 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); }
public ProductReviewInfo GetProductReview(int reviewId) { ProductReviewInfo info = new ProductReviewInfo(); DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_ProductReviews WHERE ReviewId=@ReviewId"); this.database.AddInParameter(sqlStringCommand, "ReviewId", DbType.Int32, reviewId); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { info = ReaderConvert.ReaderToModel<ProductReviewInfo>(reader); } } return info; }
private void AddProductReview(HttpContext context) { int num2; int num3; context.Response.ContentType = "application/json"; MemberInfo currentMember = MemberProcessor.GetCurrentMember(); int productId = Convert.ToInt32(context.Request["ProductId"]); ProductBrowser.LoadProductReview(productId, currentMember.UserId, out num2, out num3); if (num2 == 0) { context.Response.Write("{\"success\":false, \"msg\":\"您没有购买此商品(或此商品的订单尚未完成),因此不能进行评论\"}"); } else if (num3 >= num2) { context.Response.Write("{\"success\":false, \"msg\":\"您已经对此商品进行过评论(或此商品的订单尚未完成),因此不能再次进行评论\"}"); } else { ProductReviewInfo review = new ProductReviewInfo { ReviewDate = DateTime.Now, ReviewText = context.Request["ReviewText"], ProductId = productId, UserEmail = currentMember.Email, UserId = currentMember.UserId, UserName = currentMember.UserName }; if (ProductBrowser.InsertProductReview(review)) { context.Response.Write("{\"success\":true}"); } else { context.Response.Write("{\"success\":false, \"msg\":\"提交失败\"}"); } } }
public override ProductReviewInfo GetProductReview(int reviewId) { ProductReviewInfo info = new ProductReviewInfo(); DbCommand sqlStringCommand = database.GetSqlStringCommand("SELECT * FROM Hishop_ProductReviews WHERE ReviewId=@ReviewId"); database.AddInParameter(sqlStringCommand, "ReviewId", DbType.Int32, reviewId); using (IDataReader reader = database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { info = DataMapper.PopulateProductReview(reader); } } return info; }
public static ProductReviewInfo PopulateProductReview(IDataRecord reader) { if (null == reader) { return null; } ProductReviewInfo info = new ProductReviewInfo(); info.ReviewId = (long) reader["ReviewId"]; info.ProductId = (int) reader["ProductId"]; info.UserId = (int) reader["UserId"]; info.ReviewText = (string) reader["ReviewText"]; info.UserName = (string) reader["UserName"]; info.UserEmail = (string) reader["UserEmail"]; info.ReviewDate = (DateTime) reader["ReviewDate"]; return info; }
public static bool InsertProductReview(ProductReviewInfo review) { Globals.EntityCoding(review, true); return ProductProvider.Instance().InsertProductReview(review); }
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); }
public abstract bool InsertProductReview(ProductReviewInfo review);
public static bool InsertProductReview(ProductReviewInfo review) { return new ProductReviewDao().InsertProductReview(review); }
public void btnRefer_Click(object sender, EventArgs e) { if (this.ValidateConvert()) { bool flag = true; Dictionary<string, string> dictionary = new Dictionary<string, string>(); foreach (RepeaterItem item in this.orderItems.Items) { HtmlTextArea area = item.FindControl("txtcontent") as HtmlTextArea; HtmlInputHidden hidden = item.FindControl("hdproductId") as HtmlInputHidden; if (string.IsNullOrEmpty(area.Value.Trim()) || string.IsNullOrEmpty(hidden.Value.Trim())) { flag = false; break; } dictionary.Add(hidden.Value, area.Value); } if (!flag) { this.ShowMessage("请输入评价内容呀!", false); } else { string msg = ""; foreach (KeyValuePair<string, string> pair in dictionary) { int productId = Convert.ToInt32(pair.Key.Split(new char[] { '&' })[0].ToString()); string str2 = pair.Value; ProductReviewInfo target = new ProductReviewInfo(); target.ReviewDate = DateTime.Now; target.ProductId = productId; target.UserId = HiContext.Current.User.UserId; target.UserName = HiContext.Current.User.Username; target.UserEmail = HiContext.Current.User.Email; target.ReviewText = str2; ValidationResults results = Hishop.Components.Validation.Validation.Validate<ProductReviewInfo>(target, new string[] { "Refer" }); msg = string.Empty; if (!results.IsValid) { foreach (ValidationResult result in (IEnumerable<ValidationResult>) results) { msg = msg + Formatter.FormatErrorMessage(result.Message); } break; } int buyNum = 0; int reviewNum = 0; ProductBrowser.LoadProductReview(productId, out buyNum, out reviewNum); if (buyNum == 0) { msg = "您没有购买此商品,因此不能进行评论"; break; } if (reviewNum >= buyNum) { msg = "您已经对此商品进行了评论,请再次购买后方能再进行评论"; break; } if (!ProductProcessor.InsertProductReview(target)) { msg = "评论失败,请重试"; break; } } if (msg != "") { this.ShowMessage(msg, false); } else { this.Page.ClientScript.RegisterClientScriptBlock(base.GetType(), "success", string.Format("<script>alert(\"{0}\");window.location.href=\"{1}\"</script>", "评论成功", Globals.GetSiteUrls().UrlData.FormatUrl("user_UserProductReviews"))); } } } }