public SiteMessageEntity GetModel(SiteMessageQuery query) { ISiteMessageService service = ServiceContainer.Instance.Container.Resolve <ISiteMessageService>(); SiteMessageEntity model = service.GetSiteMessage(query.JournalID, query.MessageID); return(model); }
public bool UpdateSiteMessage(SiteMessageEntity siteMessageEntity) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" MessageID=@MessageID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" Title=@Title"); sqlCommandText.Append(", Content=@Content"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.SiteMessage SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString())); db.AddInParameter(cmd, "@MessageID", DbType.Int64, siteMessageEntity.MessageID); db.AddInParameter(cmd, "@Title", DbType.AnsiString, siteMessageEntity.Title); db.AddInParameter(cmd, "@Content", DbType.AnsiString, siteMessageEntity.Content); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public bool AddSiteMessage(SiteMessageEntity siteMessageEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @CID"); sqlCommandText.Append(", @SendUser"); sqlCommandText.Append(", @ReciverID"); sqlCommandText.Append(", @Title"); sqlCommandText.Append(", @IsView"); sqlCommandText.Append(", @Content"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.SiteMessage ({0},SendDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, siteMessageEntity.JournalID); db.AddInParameter(cmd, "@CID", DbType.Int64, siteMessageEntity.CID); db.AddInParameter(cmd, "@SendUser", DbType.Int64, siteMessageEntity.SendUser); db.AddInParameter(cmd, "@ReciverID", DbType.Int64, siteMessageEntity.ReciverID); db.AddInParameter(cmd, "@Title", DbType.AnsiString, siteMessageEntity.Title); db.AddInParameter(cmd, "@IsView", DbType.Byte, siteMessageEntity.IsView); db.AddInParameter(cmd, "@Content", DbType.AnsiString, siteMessageEntity.Content); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public ActionResult Save(SiteMessageEntity model) { ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model.JournalID = CurAuthor.JournalID; model.Content = Server.UrlDecode(model.Content); ExecResult result = service.SaveSiteMessage(model); return(Json(new { result = result.result, msg = result.msg })); }
public List <SiteMessageEntity> MakeSiteMessageList(DataTable dt) { List <SiteMessageEntity> list = new List <SiteMessageEntity>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { SiteMessageEntity siteMessageEntity = MakeSiteMessage(dt.Rows[i]); list.Add(siteMessageEntity); } } return(list); }
public SiteMessageEntity GetSiteMessage(Int64 messageID) { SiteMessageEntity siteMessageEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 * FROM dbo.SiteMessage WITH(NOLOCK)"); sqlCommandText.Append(" WHERE MessageID=@MessageID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@MessageID", DbType.Int64, messageID); using (IDataReader dr = db.ExecuteReader(cmd)) { siteMessageEntity = MakeSiteMessage(dr); } return(siteMessageEntity); }
private SiteMessageEntity GetModel(Int64 MessageID) { SiteMessageEntity model = null; if (MessageID > 0) { SiteMessageQuery query = new SiteMessageQuery(); query.JournalID = CurAuthor.JournalID; query.MessageID = MessageID; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model = service.GetSiteMessageModel(query); } if (model == null) { model = new SiteMessageEntity(); } return(model); }
public SiteMessageEntity MakeSiteMessage(DataRow dr) { SiteMessageEntity siteMessageEntity = null; if (dr != null) { siteMessageEntity = new SiteMessageEntity(); siteMessageEntity.MessageID = (Int64)dr["MessageID"]; siteMessageEntity.JournalID = (Int64)dr["JournalID"]; siteMessageEntity.CID = (Int64)dr["CID"]; siteMessageEntity.IsView = (Byte)dr["IsView"]; siteMessageEntity.SendUser = (Int64)dr["SendUser"]; siteMessageEntity.ReciverID = (Int64)dr["ReciverID"]; siteMessageEntity.Title = (String)dr["Title"]; siteMessageEntity.Content = (String)dr["Content"]; siteMessageEntity.SendDate = (DateTime)dr["SendDate"]; } return(siteMessageEntity); }
public List <SiteMessageEntity> MakeSiteMessageList(IDataReader dr) { List <SiteMessageEntity> list = new List <SiteMessageEntity>(); while (dr.Read()) { SiteMessageEntity siteMessageEntity = new SiteMessageEntity(); siteMessageEntity.MessageID = (Int64)dr["MessageID"]; siteMessageEntity.JournalID = (Int64)dr["JournalID"]; siteMessageEntity.CID = (Int64)dr["CID"]; siteMessageEntity.IsView = (Byte)dr["IsView"]; siteMessageEntity.SendUser = (Int64)dr["SendUser"]; siteMessageEntity.ReciverID = (Int64)dr["ReciverID"]; siteMessageEntity.Title = (String)dr["Title"]; siteMessageEntity.Content = (String)dr["Content"]; siteMessageEntity.SendDate = (DateTime)dr["SendDate"]; list.Add(siteMessageEntity); } dr.Close(); return(list); }
public ActionResult AuthorSendMessage(Int64 CID, Int32 Status, SiteMessageEntity model) { var user = GetAuthorInfo(CID, Status); if (user == null) { return(Json(new { result = EnumJsonResult.failure.ToString(), msg = "获取接收人失败,发送站内消息失败!" })); } ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model.JournalID = CurAuthor.JournalID; model.SendUser = CurAuthor.AuthorID; model.Content = Server.UrlDecode(model.Content); //通过稿件编号获取接收人、接受地址 model.ReciverID = user.AuthorID; ExecResult result = service.SaveSiteMessage(model); return(Json(new { result = result.result, msg = result.msg })); }
public bool DeleteSiteMessage(SiteMessageEntity siteMessageEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("DELETE FROM dbo.SiteMessage"); sqlCommandText.Append(" WHERE MessageID=@MessageID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@MessageID", DbType.Int64, siteMessageEntity.MessageID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
/// <summary> /// 保存 /// </summary> /// <param name="model"></param> /// <returns></returns> public ExecResult Save(SiteMessageEntity model) { ExecResult execResult = new ExecResult(); bool result = false; model.Title = model.Title.TextFilter(); model.Content = model.Content.HtmlFilter(); if (model.MessageID == 0) { result = AddSiteMessage(model); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "发送站内消息成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "发送站内消息失败!"; } } else { result = UpdateSiteMessage(model); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "编辑站内消息成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "编辑站内消息失败!"; } } return(execResult); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="siteMessage">SiteMessageEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddSiteMessage(SiteMessageEntity siteMessage) { return(SiteMessageBusProvider.AddSiteMessage(siteMessage)); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="siteMessage">SiteMessageEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddSiteMessage(SiteMessageEntity siteMessage) { return(SiteMessageDataAccess.Instance.AddSiteMessage(siteMessage)); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="siteMessage">SiteMessageEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteSiteMessage(SiteMessageEntity siteMessage) { return(SiteMessageDataAccess.Instance.DeleteSiteMessage(siteMessage)); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="siteMessage">SiteMessageEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteSiteMessage(SiteMessageEntity siteMessage) { return(SiteMessageBusProvider.DeleteSiteMessage(siteMessage)); }
/// <summary> /// 更新存储媒介中的实体数据 /// </summary> /// <param name="siteMessage">SiteMessageEntity实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public bool UpdateSiteMessage(SiteMessageEntity siteMessage) { return(SiteMessageBusProvider.UpdateSiteMessage(siteMessage)); }
public ExecResult Save(SiteMessageEntity model) { ISiteMessageService service = ServiceContainer.Instance.Container.Resolve <ISiteMessageService>(); return(service.Save(model)); }