/// <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 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 });
}
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="SiteBlockEntity"></param>
/// <returns></returns>
public bool AddSiteBlock(SiteBlockEntity model)
{
return SiteBlockBusProvider.AddSiteBlock(model);
}
/// <summary>
/// 编辑内容块
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateSiteBlock(SiteBlockEntity model)
{
return SiteBlockBusProvider.UpdateSiteBlock(model);
}
/// <summary>
/// 保存内容块
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult Save(SiteBlockEntity model)
{
ExecResult execResult = new ExecResult();
bool result = false;
model.Title = model.Title.TextFilter();
model.Linkurl = model.Linkurl.TextFilter();
model.Note = model.Note.TextFilter();
if (model.BlockID == 0)
{
result = AddSiteBlock(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "新增内容块成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "新增内容块失败！";
}
}
else
{
result = UpdateSiteBlock(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "修改内容块成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "修改内容块失败！";
}
}
return execResult;
}
/// <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="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="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);
}
/// <summary>
/// 保存内容块数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult SaveSiteBlock(SiteBlockEntity model)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, SiteBlockEntity>(GetAPIUrl(APIConstant.SITEBLOCK_SAVE), model);
return result;
}