/// <summary>
/// 获取指定文章的相关联的其它文章信息（相同商户且相同应用）
/// </summary>
public XCLCMS.Data.Model.Custom.ArticleRelationDetailModel GetRelationDetail(XCLCMS.Data.Model.Custom.ArticleRelationDetailCondition condition)
{
var result = new XCLCMS.Data.Model.Custom.ArticleRelationDetailModel();
var model = this.GetModel(condition.ArticleID);
if (null == model)
{
return(result);
}
Database db = base.CreateDatabase();
string sql = RazorEngine.Engine.Razor.RunCompile(Properties.Resources.Article_GetRelationDetail, "XCLCMS.Data.DAL.Article.GetRelationDetail", null, new
{
ArticleRecordState = null == condition.ArticleRecordState ? string.Empty : " and tb_Article.RecordState=@ArticleRecordState",
IsASC = condition.IsASC
});
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "ArticleID", DbType.Int64, condition.ArticleID);
db.AddInParameter(dbCommand, "IsASC", DbType.Byte, condition.IsASC ? 1 : 0);
db.AddInParameter(dbCommand, "TopCount", DbType.Int32, condition.TopCount ?? 10);
db.AddInParameter(dbCommand, "ArticleRecordState", DbType.AnsiString, condition.ArticleRecordState);
db.AddInParameter(dbCommand, "FK_MerchantID", DbType.Int64, model.FK_MerchantID);
db.AddInParameter(dbCommand, "FK_MerchantAppID", DbType.Int64, model.FK_MerchantAppID);
var ds = db.ExecuteDataSet(dbCommand);
if (null != ds && null != ds.Tables && ds.Tables.Count == 3)
{
var lst = XCLNetTools.Generic.ListHelper.DataTableToList <XCLCMS.Data.Model.Article>(ds.Tables[0]);
if (lst.IsNotNullOrEmpty())
{
result.PreArticle = lst[0];
}
lst = XCLNetTools.Generic.ListHelper.DataTableToList <XCLCMS.Data.Model.Article>(ds.Tables[1]);
if (lst.IsNotNullOrEmpty())
{
result.NextArticle = lst[0];
}
result.SameTypeArticleList = XCLNetTools.Generic.ListHelper.DataTableToList <XCLCMS.Data.Model.Article>(ds.Tables[2]) as List <XCLCMS.Data.Model.Article>;
}
return(result);
}
/// <summary>
/// 获取指定文章的相关联的其它文章信息（相同商户且相同应用）
/// </summary>
public XCLCMS.Data.Model.Custom.ArticleRelationDetailModel GetRelationDetail(XCLCMS.Data.Model.Custom.ArticleRelationDetailCondition condition)
{
return(dal.GetRelationDetail(condition));
}
