shopdirectory.cs

主要是一个图片展示效果

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;

/// <summary>
/// ShopDirectory 的摘要说明
/// </summary>
public class ShopDirectory
{
	public ShopDirectory()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    private static string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();

    /// <summary>
    /// 添加购房指南
    /// </summary>
    /// <param name="title"></param>
    /// <param name="content"></param>
    /// <param name="classs"></param>
    /// <param name="source"></param>
    /// <returns></returns>
    public int ShopDirectoryAdd(string title,string content,string classs,string source)
    {
        string sql = "Insert Into R_ShopDirectory([Title],[Content],[Class],[Source]) Values('"+title+"','"+content+"','"+classs+"','"+source+"')";
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
        return result;
    }


    /// <summary>
    /// 返回指定类别的数据
    /// </summary>
    /// <returns></returns>
    public DataSet GetClassTitle(string classs)
    {
        string sql = "Select Top 7 ShopDirectoryId,Title,Time From R_ShopDirectory Where Class = '" + classs + "' Order By [Time] Desc";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings["ConnectionString"].ToString(), CommandType.Text, sql, null);
        return ds;
    }
}