JumboTCMS_src/JumboTCMS.DAL/normal/AdvDAL.cs

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

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

/*
 * 程序名称: JumboTCMS(将博内容管理系统通用版)
 * 
 * 程序版本: 7.x
 * 
 * 程序作者: 子木将博 (QQ：791104444@qq.com，仅限商业合作)
 * 
 * 版权申明: http://www.jumbotcms.net/about/copyright.html
 * 
 * 技术答疑: http://forum.jumbotcms.net/
 * 
 */

using System;
using System.Data;
using System.Web;
using JumboTCMS.Utils;
using JumboTCMS.DBUtility;

namespace JumboTCMS.DAL
{
    /// <summary>
    /// 广告表信息
    /// </summary>
    public class AdvDAL : Common
    {
        public AdvDAL()
        {
            base.SetupSystemDate();
        }
        public string GetAdvBody(string _id)
        {
            using (DbOperHandler _doh = new Common().Doh())
            {
                string _body = "";
                _doh.Reset();
                _doh.SqlCmd = "select * from [jcms_normal_adv] where id=" + _id;
                DataTable dt = _doh.GetDataTable();
                if (dt.Rows.Count == 0)
                {
                    return null;
                }
                string _advname = dt.Rows[0]["Title"].ToString();
                string _type = dt.Rows[0]["AdvType"].ToString().ToLower();
                string _width = dt.Rows[0]["width"].ToString();
                string _height = dt.Rows[0]["height"].ToString();
                string _content = dt.Rows[0]["Content"].ToString();
                string _url = dt.Rows[0]["Url"].ToString();
                string _picurl = dt.Rows[0]["Picurl"].ToString();
                switch (_type)
                {
                    case "img":
                        if (_url.Length > 10)
                            _body = string.Format("<!--" + _advname + "开始--><a href='{3}' target='_blank'><img src='{0}' width='{1}' height='{2}' border='0' /></a><!--" + _advname + "结束-->", _picurl, _width, _height, _url);
                        else
                            _body = string.Format("<!--" + _advname + "开始--><img src='{0}' width='{1}' height='{2}' border='0' /><!--" + _advname + "结束-->", _picurl, _width, _height);
                        break;
                    case "flash":
                        _body = "<!--" + _advname + "开始--><object classid='clsid:d27cdb6e-ae6d-11cf-96b8-444553540000' codebase='http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0' width='" + _width + "' height='" + _height + "' align='middle'><param name='allowScriptAccess' value='sameDomain' /><param name='movie' value='" + _picurl + "' /><param name='quality' value='high' /><param name='bgcolor' value='#ffffff' /><embed src='" + _picurl + "' quality='high' bgcolor='#ffffff' width='" + _width + "' height='" + _height + "' align='middle' allowScriptAccess='sameDomain' type='application/x-shockwave-flash' pluginspage='http://www.macromedia.com/go/getflashplayer' /></object><!--" + _advname + "结束-->";
                        break;