App_Code/Album.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;

namespace ASPNETAJAXWeb.AjaxAlbum
{
	public class Album
	{
		public Album()
		{
			///
		}

		public DataSet GetCategorys()
		{	///获取连接字符串
			string connectionString = ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
			///创建连接
			SqlConnection con = new SqlConnection(connectionString);
			///创建SQL语句
			string cmdText = "SELECT * FROM Category";
			///创建SqlDataAdapter
			SqlDataAdapter da = new SqlDataAdapter(cmdText,con);
			///定义DataSet
			DataSet ds = new DataSet();
			try
			{   ///打开连接
				con.Open();
				///填充数据
				da.Fill(ds,"DataTable");
			}
			catch(Exception ex)
			{   ///抛出异常
				throw new Exception(ex.Message,ex);
			}
			finally
			{   ///关闭连接
				con.Close();
			}

			return ds;
		}

		public DataSet GetCategoryAndPhoto()
		{	///获取连接字符串
			string connectionString = ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
			///创建连接
			SqlConnection con = new SqlConnection(connectionString);
			///创建SQL语句
			string cmdText = "SELECT A.*, "
				+ "(SELECT COUNT(*) FROM Photo AS B WHERE B.CategoryID = A.ID) AS PhotoCount, "
				+ "(SELECT TOP 1 C.ID FROM Photo AS C WHERE C.CategoryID = A.ID ORDER BY CreateDate DESC) AS PhotoID, "
				+ "(SELECT TOP 1 D.Title FROM Photo AS D WHERE D.CategoryID = A.ID ORDER BY CreateDate DESC) AS PhotoTitle, "
				+ "(SELECT TOP 1 E.Url FROM Photo AS E WHERE E.CategoryID = A.ID ORDER BY CreateDate DESC) AS PhotoUrl "
				+ "FROM Category AS A";
			///创建SqlDataAdapter
			SqlDataAdapter da = new SqlDataAdapter(cmdText,con);
			///定义DataSet
			DataSet ds = new DataSet();
			try