/// <summary>
/// 查询Tag名称是否存在
/// </summary>
/// <param name="tag">Tag名称</param>
/// <returns>true存在,false不存在</returns>
public bool CheckTagIsExit(string tag)
{
ObjektCollection <Objekt> oc = new ObjektCollection <Objekt>(Klass.ForId("FeTag@Klass"), new WhereClause("\"tag\" = '" + tag + "'"));
if (oc == null)
{
return(false);
}
return(true);
}
/// <summary>
/// 设置指定对象的seo关键字。
/// </summary>
/// <param name="keys"></param>
/// <param name="relationshipName"></param>
/// <param name="sourceId"></param>
public static void SetObjektSeo(List <string> keys, string relationshipName, string sourceId)
{
List <FeSeoKey> entityKeys = new List <FeSeoKey>();
foreach (string key in keys)
{
FeSeoKey entity = new ObjektCollection <FeSeoKey>(Klass.ForId("FeSeoKey@Klass"), new WhereClause("\"key\" = '" + key + "'")).TryGetSingleResult();
if (entity == null)
{
entity = new FeSeoKey();
entity.Key = key;
entity.Save();
}
IEnumerable <FeSeoKey> query = from t in entityKeys
where t.Key == entity.Key
select t;
if (query.Count() == 0)
{
entityKeys.Add(entity);
}
}
Objekt objekt = ObjektFactory.Find(sourceId);
List <RelationshipObjekt> relationshipList = objekt.ROCC.GetROC(relationshipName).ToList();
List <RelationshipObjekt> deleteList = new List <RelationshipObjekt>();
foreach (RelationshipObjekt item3 in relationshipList)
{
IEnumerable <FeSeoKey> existQuery2 = from t in entityKeys
where t.Id == item3.Related.Id
select t;
if (existQuery2.Count() == 0)
{
deleteList.Add(item3);
}
}
foreach (RelationshipObjekt item4 in deleteList)
{
item4.Delete();
item4.Save();
}
foreach (FeSeoKey item5 in entityKeys)
{
IEnumerable <RelationshipObjekt> existQuery = from t in relationshipList
where t.Related.Id == item5.Id
select t;
if (existQuery.Count() == 0)
{
RelationshipObjekt relationship = ObjektFactory.New <RelationshipObjekt>(Klass.ForName(relationshipName));
relationship.Source = objekt;
relationship.Related = item5;
relationship.Save();
}
}
}
/// <summary>
/// 获取图片包中原图文件
/// </summary>
/// <returns></returns>
public File SourceImageFile()
{
if (!IsImagePack)
{
throw new Exception("当前文件并不是图片包");
}
string fileName = File.Name.Substring(0, File.Name.Length - 10);
string sql = "\"parent\" = '" + File.Id + "' and \"name\" = '" + fileName + "'";
ObjektCollection <File> oc = new ObjektCollection <File>(Klass.ForId("File@Klass"), new WhereClause(sql));
return(oc.GetSingleResult());
}
/// <summary>
/// 创建新增对象排序。
/// </summary>
/// <returns></returns>
public static decimal NewSortOrder()
{
ObjektCollection <FeArticle> oc = new ObjektCollection <FeArticle>(Klass.ForId("FeArticle@Klass"), new WhereClause("\"sortOrder\" is not null"));
oc.OrderByClause.Add(new OrderByCell("sortOrder", Order.Desc));
FeArticle entity = oc.FirstOrDefault();
int sort2 = 1;
if (entity != null && entity.IsExists() && entity.SortOrder.HasValue)
{
sort2 = (int)entity.SortOrder.Value;
sort2++;
}
return(sort2);
}
/// <summary>
/// 创建新增对象排序。
/// </summary>
/// <returns></returns>
public static decimal NewSortOrder()
{
ObjektCollection <FeCharacter> oc = new ObjektCollection <FeCharacter>(Klass.ForId("FeCharacter@Klass"), new WhereClause("\"sortOrder\" is not null"));
oc.OrderByClause.Add(new OrderByCell("sortOrder", Order.Desc));
FeCharacter character = oc.FirstOrDefault();
int sort2 = 1;
if (character != null && character.IsExists() && character.SortOrder.HasValue)
{
sort2 = (int)character.SortOrder.Value;
sort2++;
}
return(sort2);
}
public void ChildrenDeleteCheck()
{
List <FeComment> feComment = new ObjektCollection <FeComment>(Klass.ForId("FeComment@Klass"), new WhereClause("\"parent\" = '" + base.Id + "'")).ToList();
if (feComment.Count > 0)
{
foreach (FeComment item in feComment)
{
List <FeArticleComment> feArticleCommentList = new ObjektCollection <FeArticleComment>(Klass.ForId("FeArticleComment@Klass"), new WhereClause("\"related\" = '" + item.Id + "'")).ToList();
foreach (FeArticleComment item2 in feArticleCommentList)
{
item2.Delete();
item2.Save();
}
}
}
}
/// <summary>
/// 设置指定对象的seo关键字。
/// </summary>
/// <param name="tags"></param>
/// <param name="relationshipName"></param>
/// <param name="sourceId"></param>
public static void SetObjektTag(List <string> tags, string relationshipName, string sourceId)
{
List <FeTag> entityTags = new List <FeTag>();
foreach (string tag in tags)
{
FeTag entity = new ObjektCollection <FeTag>(Klass.ForId("FeTag@Klass"), new WhereClause("\"tag\" = '" + tag + "'")).TryGetSingleResult();
if (entity == null)
{
entity = new FeTag();
entity.Tag = tag;
entity.From = ObjektFactory.Find <Value>("75d290896b3d40ad802c9d6b04d61a9b@Value");
entity.Save();
}
IEnumerable <FeTag> query = from t in entityTags
where t.Tag == entity.Tag
select t;
if (query.Count() == 0)
{
entityTags.Add(entity);
}
}
Objekt objekt = ObjektFactory.Find(sourceId);
List <RelationshipObjekt> relationshipList = objekt.ROCC.GetROC(relationshipName).ToList();
foreach (RelationshipObjekt item2 in relationshipList)
{
item2.Delete();
item2.Save();
}
foreach (FeTag item3 in entityTags)
{
RelationshipObjekt relationship = ObjektFactory.New <RelationshipObjekt>(Klass.ForName(relationshipName));
relationship.Source = objekt;
relationship.Related = item3;
relationship.Save();
}
}
/// <summary>
/// 添加删除业务逻辑。
/// </summary>
public override void BeforeDelete()
{
ObjektCollection <FeArticle> oc = new ObjektCollection <FeArticle>(Klass.ForId("FeArticle@Klass"), new WhereClause("\"category\" = '" + base.Id + "'"));
if (oc.Count > 0)
{
throw new Exception("请先删除分类下的所有文章");
}
ObjektCollection <FeChannel> channelOc = new ObjektCollection <FeChannel>(Klass.ForId("FeChannel@Klass"), new WhereClause("\"category\" = '" + base.Id + "'"));
if (channelOc.Count > 0)
{
throw new Exception("请先删除分类绑定的频道");
}
List <FeArticleCategory> children = GetChildren().ToList();
foreach (FeArticleCategory item in children)
{
item.Delete();
item.Save();
}
base.BeforeDelete();
}
/// <summary>
/// 子评论恢复处理
/// </summary>
public void ChildrenRevertCheck()
{
ObjektCollection <FeComment> feComment = new ObjektCollection <FeComment>(Klass.ForId("FeComment@Klass"), new WhereClause("\"parent\" = '" + base.Id + "'"));
if (feComment.Count > 0)
{
foreach (FeComment item in feComment)
{
item.Revert();
}
}
}
private ObjektCollection <FeArticleCategory> GetChildren()
{
return(new ObjektCollection <FeArticleCategory>(Klass.ForId("FeArticleCategory@Klass"), new WhereClause("\"parent\" = '" + base.Id + "'")));
}
/// <summary>
/// 清空文章分类所有数据。
/// </summary>
public static void DeleteAll()
{
ObjektCollection <FeArticleCategory> list = Klass.ForId("FeArticleCategory@Klass").GetInstances <FeArticleCategory>();
list.DeleteAll();
}
/// <summary>
/// 查询tag关键字。
/// 根据value模糊查询。
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public static List <FeTag> FindTags(string value)
{
ObjektCollection <FeTag> oc = new ObjektCollection <FeTag>(Klass.ForId("FeTag@Klass"), new WhereClause("\"tag\" like '%" + value + "%'"));
return(oc.ToList());
}
/// <summary>
/// 查询seo关键字。
/// 根据value模糊查询。
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public static List <FeSeoKey> FindSeoKes(string value)
{
ObjektCollection <FeSeoKey> oc = new ObjektCollection <FeSeoKey>(Klass.ForId("FeSeoKey@Klass"), new WhereClause("\"key\" like '%" + value + "%'"));
return(oc.ToList());
}