App_Code/Adpic/ad.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Data;

namespace BLL.Ad
{
    /// <summary>
    ///广告管理
    /// </summary>
    public class ad
    {
        public static string detailTbl = "Bs_ad";
        public static string kindTbl = "BS_AdKindCode";
        public ad()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
        }

        /// <summary>
        /// 获取广告列表
        /// </summary>
        /// <param name="code">广告类别编码,null或者""则返回全部</param>
        /// <param name="pagesize">条数size,0返回全部</param>
        /// <returns></returns>
        public static DataTable getad(string code, int size)
        { 
           string top= size > 0 ? "  top "+ size:"";
           string where = " 1=1 ";
           if (code != "" &&code != null)
           {
               where += string.Format(" and  {0}='{1}'", kindTbl, code);     
           }
           string sql = string.Format("select {0} * from {1} where  {2} order by sortno,id desc ",top,detailTbl,where);
           return CSA.DAL.DBAccess.getRS(sql);
        }
        ///<summary>
        ///获取单条广告
        ///</summary>
        ///<param name="code">广告类别编码,null赐返回全部</param>
        ///<returns></returns>
        public static DataRow getonead(string code)
        {
          string  where = "";
            if (code != null)
            {
                where = string.Format(" and  {0} ='{1}'", kindTbl, code);
            }
            string sql = string.Format("select *  from {0} where 1=1 {1} order by sortno,id desc",detailTbl,where);
           DataTable dt= CSA.DAL.DBAccess.getRS(sql);
           if (dt.Rows.Count > 0)
           {
               return dt.Rows[0];
           }
           return null;
        }