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