App_Code/DAO/Bs_AdDao.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>
/// 网站广告
/// </summary>
public class Bs_AdDao
{
    /// <summary>
    /// 获取网站广告
    /// </summary>
    /// <param name="adId">id</param>
    /// <returns></returns>
    public DataTable getAdById(string adId)
    {
        string strSql = string.Format("select * from bs_ad where id = {0}", adId);
        return CSA.DAL.DBAccess.getRS(strSql);
    }


    /// <summary>
    /// 获取广告列表
    /// </summary>
    /// <param name="adcode"></param>
    /// <returns></returns>
    public DataTable getAdByAdkindCode(string adcode)
    {

        string strSql = string.Format("select * from bs_ad where bs_adkindcode = '{0}'", adcode);
        return CSA.DAL.DBAccess.getRS(strSql);
    }

}