/// <summary> /// 编辑内容块 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateSiteBlock(SiteBlockEntity model) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" BlockID=@BlockID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" Title=@Title"); sqlCommandText.Append(", Linkurl=@Linkurl"); sqlCommandText.Append(", TitlePhoto=@TitlePhoto"); sqlCommandText.Append(", Note=@Note"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.SiteBlock SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString())); db.AddInParameter(cmd, "@BlockID", DbType.Int64, model.BlockID); db.AddInParameter(cmd, "@Title", DbType.AnsiString, model.Title); db.AddInParameter(cmd, "@Linkurl", DbType.AnsiString, model.Linkurl); db.AddInParameter(cmd, "@TitlePhoto", DbType.AnsiString, model.TitlePhoto); db.AddInParameter(cmd, "@Note", DbType.AnsiString, model.Note); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
/// <summary> /// 新增内容块 /// </summary> /// <param name="SiteResourceEntity"></param> /// <returns></returns> public bool AddSiteBlock(SiteBlockEntity model) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @ChannelID"); sqlCommandText.Append(", @Title"); sqlCommandText.Append(", @Linkurl"); sqlCommandText.Append(", @TitlePhoto"); sqlCommandText.Append(", @Note"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.SiteBlock ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID); db.AddInParameter(cmd, "@ChannelID", DbType.Int64, model.ChannelID); db.AddInParameter(cmd, "@Title", DbType.AnsiString, model.Title); db.AddInParameter(cmd, "@Linkurl", DbType.AnsiString, model.Linkurl); db.AddInParameter(cmd, "@TitlePhoto", DbType.AnsiString, model.TitlePhoto); db.AddInParameter(cmd, "@Note", DbType.AnsiString, model.Note); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public SiteBlockEntity GetModel(SiteBlockQuery query) { ISiteBlockService service = ServiceContainer.Instance.Container.Resolve <ISiteBlockService>(); SiteBlockEntity model = service.GetSiteBlockModel(query.BlockID); return(model); }
public ActionResult Save(SiteBlockEntity model) { ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model.JournalID = CurAuthor.JournalID; ExecResult result = service.SaveSiteBlock(model); return(Json(new { result = result.result, msg = result.msg })); }
/// <summary> /// 组装数据 /// </summary> /// <param name="dr"></param> /// <returns></returns> private SiteBlockEntity MakeSiteBlockModel(IDataReader dr) { SiteBlockEntity model = new SiteBlockEntity(); model.BlockID = (Int64)dr["BlockID"]; model.JournalID = (Int64)dr["JournalID"]; model.ChannelID = (Int64)dr["ChannelID"]; model.Title = (String)dr["Title"]; model.Linkurl = (String)dr["Linkurl"]; model.TitlePhoto = (String)dr["TitlePhoto"]; model.Note = (String)dr["Note"]; model.AddDate = (DateTime)dr["AddDate"]; return(model); }
/// <summary> /// 获取内容块实体 /// </summary> /// <param name="ResourceID"></param> /// <returns></returns> public SiteBlockEntity GetSiteBlockModel(Int64 BlockID) { SiteBlockEntity item = null; string strSql = string.Format("SELECT TOP 1 * FROM dbo.SiteBlock with(nolock) WHERE BlockID={0}", BlockID); DbCommand cmd = db.GetSqlStringCommand(strSql); using (IDataReader dr = db.ExecuteReader(cmd)) { if (dr.Read()) { item = MakeSiteBlockModel(dr); } dr.Close(); } return(item); }
private SiteBlockEntity GetModel(Int64 BlockID) { SiteBlockEntity model = null; if (BlockID > 0) { SiteBlockQuery query = new SiteBlockQuery(); query.JournalID = CurAuthor.JournalID; query.BlockID = BlockID; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model = service.GetSiteBlockModel(query); } if (model == null) { model = new SiteBlockEntity(); } return(model); }
/// <summary> /// 编辑内容块 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateSiteBlock(SiteBlockEntity model) { return(SiteBlockDataAccess.Instance.UpdateSiteBlock(model)); }
/// <summary> /// 新增内容块 /// </summary> /// <param name="SiteBlockEntity"></param> /// <returns></returns> public bool AddSiteBlock(SiteBlockEntity model) { return(SiteBlockDataAccess.Instance.AddSiteBlock(model)); }
public ExecResult Save(SiteBlockEntity model) { ISiteBlockService service = ServiceContainer.Instance.Container.Resolve <ISiteBlockService>(); return(service.Save(model)); }