?? ajaxmethod.cs
字號(hào):
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);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -