public void UpdatePersonTag(string faceId, string[] tags)
{
using (var db = new personrepositoryEntities())
{
var haveTags = db.persontags.Where(s => s.FaceID == faceId).Select(s => s.TagName).ToArray();
var newTags = tags.Except(haveTags).ToArray();
foreach (var tag in newTags)
{
persontag pt = new Repository.persontag()
{
FaceID = faceId,
TagName = tag
};
db.persontags.Add(pt);
}
db.SaveChanges();
}
}
public void AddPersonTag(string faceId, string[] tags)
{
using (var db = new personrepositoryEntities())
{
//删除旧标签
var sql = "delete from persontags where faceid='" + faceId + "'";
var count = db.Database.ExecuteSqlCommand(sql);
print("删除旧标签->" + count);
foreach (var tag in tags)
{
persontag pt = new Repository.persontag()
{
FaceID = faceId,
TagName = tag
};
db.persontags.Add(pt);
}
db.SaveChanges();
}
}
