commenttask.sql.cs

来自「该项目中对 SQLHelper 类进行了简单封装」· CS 代码 · 共 33 行

/* 
 * CommentTask.SQL.cs @Microsoft Visual Studio 2008 <.NET Framework 3.5>
 * AfritXia
 * 2008-01-28
 * 
 * Copyright(c) http://www.AfritXia.NET/
 * 
 */

using System;

namespace NET.AfritXia.MyHome.DBTask.Access2000
{
	partial class CommentTask
	{
		// 添加新文章评论
		private const string SQL_Append = @"
			insert into [Comment] ( [BelongToArticleUID], [PostUser], [TextContent], [ClientIP] ) 
			values ( @BelongToArticleUID, @PostUser, @TextContent, @ClientIP )";

		// 删除评论信息
		private const string SQL_Delete = @"
			delete from [Comment] where [CommentUID] = @CommentUID";

		// 浏览评论信息
		private const string SQL_ViewCommentList = @"
			select * from [Comment] where [BelongToArticleUID] = @BelongToArticleUID";

		// 浏览单个评论信息
		private const string SQL_ViewComment = @"
			select * from [Comment] where [CommentUID] = @CommentUID";
	}
}