public void btnRefer_Click(object sender, EventArgs e)
{
ProductConsultationInfo target = new ProductConsultationInfo();
target.ConsultationDate = DateTime.Now;
target.ProductId = this.productId;
target.UserId = HiContext.Current.User.UserId;
target.UserName = this.txtUserName.Text;
target.UserEmail = this.txtEmail.Text;
target.ConsultationText = this.txtContent.Text;
ValidationResults results = Hishop.Components.Validation.Validation.Validate<ProductConsultationInfo>(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 (string.IsNullOrEmpty(this.txtConsultationCode.Value))
{
this.ShowMessage("请输入验证码", false);
}
else if (!HiContext.Current.CheckVerifyCode(this.txtConsultationCode.Value.Trim()))
{
this.ShowMessage("验证码不正确", false);
}
else if (ProductProcessor.InsertProductConsultation(target))
{
this.Page.ClientScript.RegisterClientScriptBlock(base.GetType(), "success", string.Format("<script>alert(\"{0}\");window.location.href=\"{1}\"</script>", "咨询成功，管理员回复即可显示", Globals.GetSiteUrls().UrlData.FormatUrl("productConsultations", new object[] { this.productId })));
}
else
{
this.ShowMessage("咨询失败，请重试", false);
}
}
public static bool ReplyProductConsultation(ProductConsultationInfo productConsultation)
{
return new ProductConsultationDao().ReplyProductConsultation(productConsultation);
}
private void AddProductConsultations(HttpContext context)
{
context.Response.ContentType = "application/json";
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
ProductConsultationInfo productConsultation = new ProductConsultationInfo {
ConsultationDate = DateTime.Now,
ConsultationText = context.Request["ConsultationText"],
ProductId = Convert.ToInt32(context.Request["ProductId"]),
UserEmail = currentMember.Email,
UserId = currentMember.UserId,
UserName = currentMember.UserName
};
if (ProductBrowser.InsertProductConsultation(productConsultation))
{
context.Response.Write("{\"success\":true}");
}
else
{
context.Response.Write("{\"success\":false, \"msg\":\"提交失败\"}");
}
}
public static bool ReplyProductConsultation(ProductConsultationInfo productConsultation)
{
return CommentsProvider.Instance().ReplyProductConsultation(productConsultation);
}
public override bool ReplyProductConsultation(ProductConsultationInfo productConsultation)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_ProductConsultations SET ReplyText = @ReplyText, ReplyDate = @ReplyDate, ReplyUserId = @ReplyUserId WHERE ConsultationId = @ConsultationId");
database.AddInParameter(sqlStringCommand, "ReplyText", DbType.String, productConsultation.ReplyText);
database.AddInParameter(sqlStringCommand, "ReplyDate", DbType.DateTime, productConsultation.ReplyDate);
database.AddInParameter(sqlStringCommand, "ReplyUserId", DbType.Int32, productConsultation.ReplyUserId);
database.AddInParameter(sqlStringCommand, "ConsultationId", DbType.Int32, productConsultation.ConsultationId);
return (database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public static ProductConsultationInfo PopulateProductConsultation(IDataRecord reader)
{
if (null == reader)
{
return null;
}
ProductConsultationInfo info = new ProductConsultationInfo();
info.ConsultationId = (int) reader["ConsultationId"];
info.ProductId = (int) reader["ProductId"];
info.UserId = (int) reader["UserId"];
info.UserName = (string) reader["UserName"];
info.ConsultationText = (string) reader["ConsultationText"];
info.ConsultationDate = (DateTime) reader["ConsultationDate"];
info.UserEmail = (string) reader["UserEmail"];
if (DBNull.Value != reader["ReplyText"])
{
info.ReplyText = (string) reader["ReplyText"];
}
if (DBNull.Value != reader["ReplyDate"])
{
info.ReplyDate = new DateTime?((DateTime) reader["ReplyDate"]);
}
if (DBNull.Value != reader["ReplyUserId"])
{
info.ReplyUserId = new int?((int) reader["ReplyUserId"]);
}
return info;
}
public static bool InsertProductConsultation(ProductConsultationInfo productConsultation)
{
Globals.EntityCoding(productConsultation, true);
return ProductProvider.Instance().InsertProductConsultation(productConsultation);
}
public override bool InsertProductConsultation(ProductConsultationInfo productConsultation)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Hishop_ProductConsultations(ProductId, UserId, UserName, UserEmail, ConsultationText, ConsultationDate)VALUES(@ProductId, @UserId, @UserName, @UserEmail, @ConsultationText, @ConsultationDate)");
this.database.AddInParameter(sqlStringCommand, "ProductId", DbType.Int32, productConsultation.ProductId);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.String, productConsultation.UserId);
this.database.AddInParameter(sqlStringCommand, "UserName", DbType.String, productConsultation.UserName);
this.database.AddInParameter(sqlStringCommand, "UserEmail", DbType.String, productConsultation.UserEmail);
this.database.AddInParameter(sqlStringCommand, "ConsultationText", DbType.String, productConsultation.ConsultationText);
this.database.AddInParameter(sqlStringCommand, "ConsultationDate", DbType.DateTime, productConsultation.ConsultationDate);
return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public abstract bool ReplyProductConsultation(ProductConsultationInfo productConsultation);
public abstract bool InsertProductConsultation(ProductConsultationInfo productConsultation);
public static bool InsertProductConsultation(ProductConsultationInfo productConsultation)
{
return new ProductConsultationDao().InsertProductConsultation(productConsultation);
}
