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); }