public static int GetArticleGroupId(GmConnection conn, string tag)
{
GmCommand cmd = conn.CreateCommand("select top(1) Id from Articles where IsGroup=1 and Tag=@Tag");
cmd.AddString("Tag", tag);
return(cmd.ExecuteScalarInt32());
}
public static int GetArticleId(GmConnection conn, string tag)
{
int articleId = 0;
if (!String.IsNullOrWhiteSpace(tag))
{
GmCommand cmd = conn.CreateCommand("select Id from Articles where Tag=@Tag");
cmd.AddString("Tag", tag);
articleId = cmd.ExecuteScalarInt32();
}
return(articleId);
}
