lwordtask.sql.cs

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

/* 
 * LWordTask.SQL.cs @Microsoft Visual Studio 2005 <.NET Framework 2.0>
 * AfritXia
 * 2007-01-15
 * 
 * Copyright(c) http://www.AfritXia.NET/
 * 
 */

using System;

namespace NET.AfritXia.MyHome.DBTask.Access2000
{
	partial class LWordTask
	{
		// 添加留言信息
		private const string SQL_Append = @"
			insert into [LWord] ( [PostUser], [TextContent], [ClientIP] ) values ( @PostUser, @TextContent, @ClientIP )";

		// 删除留言信息
		private const string SQL_Delete = @"
			delete from [LWord] where [LWordUID] = @LWordUID";

		// 获取留单个的言信息
		private const string SQL_ViewLWord = @"
			select * from [LWord] where [LWordUID] = @LWordUID";

		/// <summary>
		/// 浏览留言列表
		/// </summary>
		/// <param name="startRecord"></param>
		/// <param name="maxRecords"></param>
		/// <returns></returns>
		private static string SQL_ViewLWordList(int startRecord, int maxRecords)
		{
			string sqlCmdText = @"
				select * from LWord as L where L.LWordUID in (
				select top {1} [LWordUID] from ( 
				select top {0} [LWordUID] from [LWord] order by [LWordUID] desc ) as X order by X.[LWordUID] asc ) 
				order by L.[LWordUID] desc";

			return String.Format(sqlCmdText, (startRecord + maxRecords), maxRecords);
		}
	}
}