public void btnRefer_Click(object sender, EventArgs e) { if (!HiContext.Current.CheckVerifyCode(this.txtLeaveCode.Value)) { this.ShowMessage("验证码不正确", false); } else if (this.ValidateConvert() && (((HiContext.Current.User.UserRole == UserRole.Member) || (HiContext.Current.User.UserRole == UserRole.Underling)) || this.userRegion(this.txtLeaveUserName.Value, this.txtLeavePsw.Value))) { LeaveCommentInfo target = new LeaveCommentInfo(); target.UserName = Globals.HtmlEncode(this.txtUserName.Text); target.Title = Globals.HtmlEncode(this.txtTitle.Text); target.PublishContent = Globals.HtmlEncode(this.txtContent.Text); ValidationResults results = Hishop.Components.Validation.Validation.Validate<LeaveCommentInfo>(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 (CommentProcessor.InsertLeaveComment(target)) { this.Page.ClientScript.RegisterClientScriptBlock(base.GetType(), "success", string.Format("<script>alert(\"{0}\");window.location.href=\"{1}\"</script>", "留言成功,管理员回复后即可显示", Globals.GetSiteUrls().UrlData.FormatUrl("LeaveComments"))); } else { this.ShowMessage("留言失败", false); } this.txtTitle.Text = string.Empty; this.txtContent.Text = string.Empty; } } }
public static LeaveCommentInfo PopulateLeaveComment(IDataReader reader) { if (null == reader) { return null; } LeaveCommentInfo info = new LeaveCommentInfo(); info.LeaveId = (long) reader["LeaveId"]; if (reader["UserId"] != DBNull.Value) { info.UserId = new int?((int) reader["UserId"]); } if (reader["UserName"] != DBNull.Value) { info.UserName = (string) reader["UserName"]; } info.Title = (string) reader["Title"]; info.PublishContent = (string) reader["PublishContent"]; info.PublishDate = (DateTime) reader["PublishDate"]; info.LastDate = (DateTime) reader["LastDate"]; return info; }
public override bool InsertLeaveComment(LeaveCommentInfo leave) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("Insert into Hishop_LeaveComments(UserId,UserName,Title,PublishContent,PublishDate,LastDate) values(@UserId,@UserName,@Title,@PublishContent,@PublishDate,@LastDate)"); this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, leave.UserId); this.database.AddInParameter(sqlStringCommand, "UserName", DbType.String, leave.UserName); this.database.AddInParameter(sqlStringCommand, "Title", DbType.String, leave.Title); this.database.AddInParameter(sqlStringCommand, "PublishContent", DbType.String, leave.PublishContent); this.database.AddInParameter(sqlStringCommand, "PublishDate", DbType.DateTime, DataHelper.GetSafeDateTimeFormat(DateTime.Now)); this.database.AddInParameter(sqlStringCommand, "LastDate", DbType.DateTime, DataHelper.GetSafeDateTimeFormat(DateTime.Now)); return (this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public abstract bool InsertLeaveComment(LeaveCommentInfo leave);
public static bool InsertLeaveComment(LeaveCommentInfo leave) { Globals.EntityCoding(leave, true); return CommentProvider.Instance().InsertLeaveComment(leave); }