private void btnAddAffiche_Click(object sender, EventArgs e) { AfficheInfo target = new AfficheInfo(); target.Title = txtAfficheTitle.Text.Trim(); target.Content = fcContent.Text; target.AddedDate = DateTime.Now; ValidationResults results = Hishop.Components.Validation.Validation.Validate<AfficheInfo>(target, new string[] { "ValAfficheInfo" }); string msg = string.Empty; if (!results.IsValid) { foreach (ValidationResult result in (IEnumerable<ValidationResult>)results) { msg = msg + Formatter.FormatErrorMessage(result.Message); } ShowMsg(msg, false); } else if (NoticeHelper.CreateAffiche(target)) { txtAfficheTitle.Text = string.Empty; fcContent.Text = string.Empty; ShowMsg("成功发布了一条公告", true); } else { ShowMsg("添加公告失败", false); } }
private void btnEditAffiche_Click(object sender, EventArgs e) { AfficheInfo info2 = new AfficheInfo(); info2.AfficheId = this.afficheId; info2.Title = this.txtAfficheTitle.Text.Trim(); info2.Content = this.fcContent.Text; info2.AddedDate = DateTime.Now; AfficheInfo target = info2; ValidationResults results = Hishop.Components.Validation.Validation.Validate<AfficheInfo>(target, new string[] { "ValAfficheInfo" }); string msg = string.Empty; if (!results.IsValid) { foreach (ValidationResult result in (IEnumerable<ValidationResult>) results) { msg = msg + Formatter.FormatErrorMessage(result.Message); } this.ShowMsg(msg, false); } else { target.AfficheId = this.afficheId; if (SubsiteCommentsHelper.UpdateAffiche(target)) { this.ShowMsg("成功修改了当前公告信息", true); } else { this.ShowMsg("修改公告信息错误", false); } } }
public override bool AddAffiche(AfficheInfo affiche) { DbCommand sqlStringCommand = database.GetSqlStringCommand("INSERT INTO Hishop_Affiche(Title, Content, AddedDate) VALUES (@Title, @Content, @AddedDate)"); database.AddInParameter(sqlStringCommand, "Title", DbType.String, affiche.Title); database.AddInParameter(sqlStringCommand, "Content", DbType.String, affiche.Content); database.AddInParameter(sqlStringCommand, "AddedDate", DbType.DateTime, affiche.AddedDate); return (database.ExecuteNonQuery(sqlStringCommand) == 1); }
public static bool CreateAffiche(AfficheInfo affiche) { if (null == affiche) { return false; } Globals.EntityCoding(affiche, true); return CommentsProvider.Instance().AddAffiche(affiche); }
public override bool AddAffiche(AfficheInfo affiche) { DbCommand sqlStringCommand = database.GetSqlStringCommand("INSERT INTO distro_Affiche(DistributorUserId,Title, Content, AddedDate) VALUES (@DistributorUserId,@Title, @Content, @AddedDate)"); database.AddInParameter(sqlStringCommand, "Title", DbType.String, affiche.Title); database.AddInParameter(sqlStringCommand, "Content", DbType.String, affiche.Content); database.AddInParameter(sqlStringCommand, "AddedDate", DbType.DateTime, affiche.AddedDate); database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.User.UserId); return (database.ExecuteNonQuery(sqlStringCommand) == 1); }
public override bool UpdateAffiche(AfficheInfo affiche) { DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_Affiche SET Title = @Title, AddedDate = @AddedDate, Content = @Content WHERE AfficheId = @AfficheId"); database.AddInParameter(sqlStringCommand, "Title", DbType.String, affiche.Title); database.AddInParameter(sqlStringCommand, "Content", DbType.String, affiche.Content); database.AddInParameter(sqlStringCommand, "AddedDate", DbType.DateTime, affiche.AddedDate); database.AddInParameter(sqlStringCommand, "AfficheId", DbType.Int32, affiche.AfficheId); return (database.ExecuteNonQuery(sqlStringCommand) == 1); }
public static AfficheInfo PopulateAffiche(IDataReader reader) { if (null == reader) { return null; } AfficheInfo info = new AfficheInfo(); info.AfficheId = (int) reader["AfficheId"]; if (reader["Title"] != DBNull.Value) { info.Title = (string) reader["Title"]; } info.Content = (string) reader["Content"]; info.AddedDate = (DateTime) reader["AddedDate"]; return info; }
public abstract bool AddAffiche(AfficheInfo affiche);
public abstract bool UpdateAffiche(AfficheInfo affiche);