/// <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));
}
