dbservice.cs

《征服Ajax》原书的例题源码

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

namespace Db
{
	/// <summary>
	/// 数据库操作封装接口
	/// </summary>
	public interface DbService
	{
		/// <summary>
		/// 插入一条邮件记录
		/// </summary>
		/// <param name="from">发件人</param>
		/// <param name="to">收件人</param>
		/// <param name="subject">邮件主题</param>
		/// <param name="body">邮件正文</param>
		/// <param name="status">邮件状态</param>
		/// <param name="size">邮件大小</param>
		/// <returns>是否插入成功</returns>
		bool InsertMail(string from, string to, string subject, string body, int status, int size);

		/// <summary>
		/// 删除一条邮件记录
		/// </summary>
		/// <param name="id">邮件id</param>
		/// <returns>是否删除成功</returns>
		bool DeleteMail(int id);

		/// <summary>
		/// 改变邮件状态
		/// </summary>
		/// <param name="id">邮件id</param>
		/// <param name="read">状态</param>
		/// <returns>是否修改成功</returns>
		bool ChangeMailStatus(int id, int read);

		/// <summary>
		/// 修改邮件所在文件夹
		/// </summary>
		/// <param name="id">邮件id</param>
		/// <param name="folder">文件夹id</param>
		/// <returns>是否修改成功</returns>
		bool ChangeMailFolder(int id, int folder);

		/// <summary>
		/// 输出邮件列表的HTML
		/// </summary>
		/// <param name="sql">查询SQL语句</param>
		/// <param name="strXslPath">XSLT文件路径</param>
		/// <param name="writer">IO输出</param>
		void WriteMailList(string sql, string strXslPath, System.IO.TextWriter writer);
	}
}