public bool UpdateSiteNotice(SiteNoticeEntity siteNoticeEntity) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" DesID=@DesID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" Title=@Title"); sqlCommandText.Append(", Keywords=@Keywords"); sqlCommandText.Append(", Description=@Description"); sqlCommandText.Append(", Content=@Content"); sqlCommandText.Append(", FjPath=@FjPath"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.SiteDescribe SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString())); db.AddInParameter(cmd, "@DesID", DbType.Int64, siteNoticeEntity.NoticeID); db.AddInParameter(cmd, "@Title", DbType.AnsiString, siteNoticeEntity.Title); db.AddInParameter(cmd, "@Keywords", DbType.AnsiString, siteNoticeEntity.Keywords); db.AddInParameter(cmd, "@Description", DbType.AnsiString, siteNoticeEntity.Description); db.AddInParameter(cmd, "@Content", DbType.AnsiString, siteNoticeEntity.Content); db.AddInParameter(cmd, "@FjPath", DbType.AnsiString, siteNoticeEntity.FjPath); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public SiteNoticeEntity GetModel(SiteNoticeQuery query) { ISiteNoticeService service = ServiceContainer.Instance.Container.Resolve <ISiteNoticeService>(); SiteNoticeEntity model = service.GetSiteNotice(query.NoticeID); return(model); }
public bool AddSiteNotice(SiteNoticeEntity siteNoticeEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @ChannelID"); sqlCommandText.Append(", @Title"); sqlCommandText.Append(", @Keywords"); sqlCommandText.Append(", @Description"); sqlCommandText.Append(", @Content"); sqlCommandText.Append(", @FjPath"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.SiteDescribe ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, siteNoticeEntity.JournalID); db.AddInParameter(cmd, "@ChannelID", DbType.Int64, siteNoticeEntity.ChannelID); db.AddInParameter(cmd, "@Title", DbType.String, siteNoticeEntity.Title); db.AddInParameter(cmd, "@Keywords", DbType.String, siteNoticeEntity.Keywords); db.AddInParameter(cmd, "@Description", DbType.String, siteNoticeEntity.Description); db.AddInParameter(cmd, "@Content", DbType.String, siteNoticeEntity.Content); db.AddInParameter(cmd, "@FjPath", DbType.String, siteNoticeEntity.FjPath); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public ActionResult Save(SiteNoticeEntity model) { ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model.JournalID = CurAuthor.JournalID; if (!string.IsNullOrWhiteSpace(model.Content)) { model.Content = Server.UrlDecode(model.Content); } ExecResult result = service.SaveSiteNotice(model); return(Json(new { result = result.result, msg = result.msg })); }
public List <SiteNoticeEntity> MakeSiteNoticeList(DataTable dt) { List <SiteNoticeEntity> list = new List <SiteNoticeEntity>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { SiteNoticeEntity siteNoticeEntity = MakeSiteNotice(dt.Rows[i]); list.Add(siteNoticeEntity); } } return(list); }
private SiteNoticeEntity GetModel(Int64 NoticeID) { SiteNoticeEntity model = null; if (NoticeID > 0) { SiteNoticeQuery query = new SiteNoticeQuery(); query.JournalID = CurAuthor.JournalID; query.NoticeID = NoticeID; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model = service.GetSiteNoticeModel(query); } if (model == null) { model = new SiteNoticeEntity(); } return(model); }
public SiteNoticeEntity GetSiteNotice(Int64 noticeID) { SiteNoticeEntity siteNoticeEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 DesID,JournalID,ChannelID,Title,Keywords,Description,Content,FjPath,AddDate FROM dbo.SiteDescribe WITH(NOLOCK)"); sqlCommandText.Append(" WHERE DesID=@DesID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@DesID", DbType.Int64, noticeID); using (IDataReader dr = db.ExecuteReader(cmd)) { siteNoticeEntity = MakeSiteNotice(dr); } return(siteNoticeEntity); }
public SiteNoticeEntity MakeSiteNotice(DataRow dr) { SiteNoticeEntity siteNoticeEntity = null; if (dr != null) { siteNoticeEntity = new SiteNoticeEntity(); siteNoticeEntity.NoticeID = (Int64)dr["DesID"]; siteNoticeEntity.JournalID = (Int64)dr["JournalID"]; siteNoticeEntity.ChannelID = (Int64)dr["ChannelID"]; siteNoticeEntity.Title = (String)dr["Title"]; siteNoticeEntity.Keywords = (String)dr["Keywords"]; siteNoticeEntity.Description = (String)dr["Description"]; siteNoticeEntity.Content = (String)dr["Content"]; siteNoticeEntity.FjPath = (String)dr["FjPath"]; siteNoticeEntity.AddDate = (DateTime)dr["AddDate"]; } return(siteNoticeEntity); }
public List <SiteNoticeEntity> MakeSiteNoticeList(IDataReader dr) { List <SiteNoticeEntity> list = new List <SiteNoticeEntity>(); while (dr.Read()) { SiteNoticeEntity siteNoticeEntity = new SiteNoticeEntity(); siteNoticeEntity.NoticeID = (Int64)dr["DesID"]; siteNoticeEntity.JournalID = (Int64)dr["JournalID"]; siteNoticeEntity.ChannelID = (Int64)dr["ChannelID"]; siteNoticeEntity.Title = (String)dr["Title"]; siteNoticeEntity.Keywords = (String)dr["Keywords"]; siteNoticeEntity.Description = (String)dr["Description"]; siteNoticeEntity.Content = (String)dr["Content"]; siteNoticeEntity.FjPath = (String)dr["FjPath"]; siteNoticeEntity.AddDate = (DateTime)dr["AddDate"]; list.Add(siteNoticeEntity); } dr.Close(); return(list); }
/// <summary> /// 保存站点公告 /// </summary> /// <param name="model"></param> /// <returns></returns> public ExecResult Save(SiteNoticeEntity model) { ExecResult execResult = new ExecResult(); bool result = false; model.Title = model.Title.TextFilter(); model.Keywords = model.Keywords.TextFilter(); model.Description = model.Description.TextFilter(); model.Content = model.Content.HtmlFilter(); if (model.NoticeID == 0) { result = AddSiteNotice(model); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "新增成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "新增失败!"; } } else { result = UpdateSiteNotice(model); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "修改成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "修改失败!"; } } return(execResult); }
public bool DeleteSiteNotice(SiteNoticeEntity siteNoticeEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("DELETE FROM dbo.SiteDescribe"); sqlCommandText.Append(" WHERE DesID=@DesID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@DesID", DbType.Int64, siteNoticeEntity.NoticeID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="siteNotice">SiteNoticeEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteSiteNotice(SiteNoticeEntity siteNotice) { return(SiteNoticeDataAccess.Instance.DeleteSiteNotice(siteNotice)); }
public ExecResult Save(SiteNoticeEntity model) { ISiteNoticeService service = ServiceContainer.Instance.Container.Resolve <ISiteNoticeService>(); return(service.Save(model)); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="siteNotice">SiteNoticeEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddSiteNotice(SiteNoticeEntity siteNotice) { return(SiteNoticeDataAccess.Instance.AddSiteNotice(siteNotice)); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="siteNotice">SiteNoticeEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteSiteNotice(SiteNoticeEntity siteNotice) { return(SiteNoticeBusProvider.DeleteSiteNotice(siteNotice)); }
/// <summary> /// 更新存储媒介中的实体数据 /// </summary> /// <param name="siteNotice">SiteNoticeEntity实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public bool UpdateSiteNotice(SiteNoticeEntity siteNotice) { return(SiteNoticeBusProvider.UpdateSiteNotice(siteNotice)); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="siteNotice">SiteNoticeEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddSiteNotice(SiteNoticeEntity siteNotice) { return(SiteNoticeBusProvider.AddSiteNotice(siteNotice)); }