/// <summary>
/// タグを取得します
/// </summary>
public List<HNKTag> GetAll()
{
StringBuilder query = new StringBuilder();
query.Append("SELECT tags.id, tags.name, tags.update_date FROM tags");
query.Append(" ORDER BY name_yomi");
List<HNKTag> tags = new List<HNKTag> { };
using (SqlCommand cmd = new SqlCommand(query.ToString(), this.SqlConnection))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int i = -1;
HNKTag tag = new HNKTag();
if (!reader.IsDBNull(++i))
{
tag.Id = reader.GetInt32(i);
}
if (!reader.IsDBNull(++i))
{
tag.Name = reader.GetString(i);
}
if (!reader.IsDBNull(++i))
{
tag.UpdateDate = reader.GetDateTime(i);
}
if (tag.Id > 0)
{
tags.Add(tag);
}
}
}
}
return tags;
}
/// <summary>
/// 指定されたIDを持つタグを返します
/// </summary>
/// <param name="id">タグID。データベースのレコードIDと同じ</param>
public HNKTag GetTag(int id)
{
HNKTag tag = new HNKTag();
StringBuilder query = new StringBuilder();
query.Append("SELECT id, name, name_yomi From tags");
query.Append(" WHERE id = @id");
using (SqlCommand cmd = new SqlCommand(query.ToString(), this.SqlConnection))
{
SqlCommandHelper.AddSqlParameter(cmd, ParameterDirection.Input, "@id", SqlDbType.Int, id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int i = -1;
if (!reader.IsDBNull(++i))
{
tag.Id = reader.GetInt32(i);
}
if (!reader.IsDBNull(++i))
{
tag.Name = reader.GetString(i);
}
if (!reader.IsDBNull(++i))
{
tag.NameYomi = reader.GetString(i);
}
}
}
}
return tag;
}
/// <summary>
/// 指定されたIDを持つタグを返します
/// </summary>
/// <param name="tagIds">タグID。データベースのレコードIDと同じ</param>
public List<HNKTag> GetTags(List<int> tagIds)
{
List<HNKTag> tags = new List<HNKTag> { };
HNKTagSql sql = HNKTagSqlFactory.GetTags(tagIds);
using (SqlCommand cmd = new SqlCommand(sql.Query.ToString(), this.SqlConnection))
{
cmd.Parameters.AddRange(sql.Parameters.ToArray());
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int i = -1;
HNKTag tag = new HNKTag();
if (!reader.IsDBNull(++i))
{
tag.Id = reader.GetInt32(i);
}
if (!reader.IsDBNull(++i))
{
tag.Name = reader.GetString(i);
}
if (!reader.IsDBNull(++i))
{
tag.NameYomi = reader.GetString(i);
}
if (tag.Id > 0)
{
tags.Add(tag);
}
}
}
}
return tags;
}
