listmail.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
using Db;

public partial class server_ListMail : System.Web.UI.Page
{
	protected void Page_Load(object sender, EventArgs e)
	{
		if ((Request.QueryString["username"] != null) &&
			(Request.QueryString["temp"] != null) &&
			(Request.QueryString["type"] != null))
		{
			// 用户名
			string username = Request.QueryString["username"];

			// 显示类型
			int type = Convert.ToInt32(Request.QueryString["type"]);

			// XSLT样式表文件
			string templateName = Request.QueryString["temp"];

			// 查询SQL语句
			string strSql = "";
			switch (type)
			{
				// 收件箱
				case 0:
					strSql = string.Format("SELECT * FROM InboxView AS mail WHERE [to] = '{0}@localhost' ORDER BY [time] DESC FOR XML AUTO, ELEMENTS", username);
					break;

				// 已发送邮件
				case 1:
					strSql = string.Format("SELECT * FROM SendBoxView AS mail WHERE [from] = '{0}@localhost' ORDER BY [time] DESC FOR XML AUTO, ELEMENTS", username);
					break;

				// 已删除邮件
				default:
					strSql = string.Format("SELECT * FROM DeletedView AS mail WHERE ([from] = '{0}@localhost' AND status&0x2=0x2) OR ([to] = '{0}@localhost' AND status&0x2=0) ORDER BY [time] DESC FOR XML AUTO, ELEMENTS", username);
					break;
			}

			// 新建LocalDbService对象，用于访问本机数据库
			DbService dbService = new LocalDbService();

			// 在页面上输出返回数据（XML格式）与XSLT样式表的转换结果
			dbService.WriteMailList(strSql, Server.MapPath("~/xsl/" + templateName), Response.Output);
		}
	}
}