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;
using System.Data.SqlClient;
using AjaxPro;

/// <summary>
/// Summary description for AjaxMethod
/// </summary>
public class AjaxMethod
{
	public AjaxMethod()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public static string ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"].ToString();

    #region GetDataSet
    public static DataSet GetDataSet(string sql)
    {
        SqlDataAdapter sda = new SqlDataAdapter(sql, ConnectionString);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        if (ds != null)
            return ds;
        else
            return null;
    }
    #endregion
    
    /// <summary>
    /// 獲取某個(gè)分類下圖片的id和photo_path信息
    /// </summary>
    /// <param name="iCategoryID">分類ID號(hào)</param>
    /// <returns>圖片信息(id, photo_path)的信息</returns>
    [AjaxMethod(HttpSessionStateRequirement.ReadWrite)]
    public static DataSet GetPhotoList(int iCategoryID)
    {
        string sql = string.Format("SELECT id, photo_path FROM Photo WHERE photo_category_id = {0}", iCategoryID);
        return GetDataSet(sql);
    }

    /// <summary>
    /// 獲取圖片信息(標(biāo)題、說明)
    /// </summary>
    /// <param name="id">圖片id</param>
    /// <returns>圖片信息</returns>
    [AjaxMethod(HttpSessionStateRequirement.ReadWrite)]
    public static DataSet GetPhotoInfo(int id)
    {
        string sql = string.Format("SELECT photo_title, photo_description FROM Photo WHERE id = {0}", id);

        return GetDataSet(sql);
    }
    
}