public void SetTagRelation(TagRelation tagRelation)
{
TagsDao.SetTagRelation(tagRelation);
}
internal static List<TagRelation> GetTagRelationByTagId(int tagId)
{
List<TagRelation> list = new List<TagRelation>();
SafeProcedure.ExecuteAndMapRecords(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.TagRelation_GetByTagId",
delegate(IRecord record)
{
TagRelation tag = new TagRelation();
tag.Id = record.GetInt32OrDefault(0, 0);
tag.TagId = record.GetInt32OrDefault(1, 0);
tag.ObjectId = record.GetInt32OrDefault(2, 0);
tag.ObjectType = (ObjectTypeDefine)(record.GetInt32OrDefault(3, 0));
tag.AddUserID = record.GetInt32OrDefault(4, 0);
tag.AddDate = record.GetDateTime(5);
list.Add(tag);
},
tagId);
return list;
}
internal static void SetTagRelation(TagRelation tagRelation)
{
if (tagRelation == null) return;
SafeProcedure.ExecuteNonQuery(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.TagRelation_SetRelation",
tagRelation.TagId,tagRelation.ObjectId,
(int)tagRelation.ObjectType,
tagRelation.AddUserID );
}
internal static TagRelation GetTagRelation(int tagId, int objectId, int objectType)
{
TagRelation tag = new TagRelation();
SafeProcedure.ExecuteAndMapRecords(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.TagRelation_Get",
delegate(IRecord record)
{
tag.Id = record.GetInt32OrDefault(0,0);
tag.TagId = record.GetInt32OrDefault(1, 0);
tag.ObjectId = record.GetInt32OrDefault(2, 0);
tag.ObjectType =(ObjectTypeDefine)(record.GetInt32OrDefault(3, 0));
tag.AddUserID = record.GetInt32OrDefault(4, 0);
tag.AddDate = record.GetDateTime(5);
},
tagId, objectId, objectType);
return tag;
}
