BLL/Base/MAdModels.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text;
using System.Data.SqlClient;
namespace BLL.Models
{
    public class MAdModels
    {
        string[] str_files = {"ID","Adname","Adurl","Adpic","Flag","Adtitle" };
        /// <summary>
        /// 修改广告
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateMad(MODEL.MAD model) {

            bool ret = false;
            string str_sql = "update   [tb_mc_ad] set adtitle='"+model.Adtitle+"' ,adurl='"+model.Adurl+"',adpic='"+model.Adpic+"' where id=" +model.Id.ToString();
            Library.SqlProvider.SqlServer db = new Library.SqlProvider.SqlServer();
            DataTable dt = new DataTable();
            try
            {
                db.ExecuteNonQuery(COMM.PucConfig.ConnectionStringA, CommandType.Text, str_sql);
                ret = true;
            }
            catch (Exception ex) { }
            return ret;
        }
        /// <summary>
        /// 获取全部广告
        /// </summary>
        /// <returns></returns>
        public string AllMad(string start,string limit,string fiter) {

            string ret = string.Empty;
            string str_sql = "select top " + limit + " * from [tb_mc_ad] where id not in( select top  " + start + " id from [tb_mc_ad] order by id desc ) order by id desc";
            if (start == "0")
            {

                str_sql = " select top " + limit + " * from [tb_mc_ad] order by id desc ";
            }
            Library.SqlProvider.SqlServer db = new Library.SqlProvider.SqlServer();
            DataTable dt = new DataTable();
            string tcount = "0";
            try
            {
                dt = db.ExecuteDataset(COMM.PucConfig.ConnectionStringA, CommandType.Text, str_sql).Tables[0];
                tcount = db.ExecuteScalar(COMM.PucConfig.ConnectionStringA, CommandType.Text, "select count(*) from [tb_mc_ad] ").ToString();
            }
            catch (Exception ex) { }

            BLL.JSONHelper jsons = new BLL.JSONHelper();



            foreach (DataRow dr in dt.Rows)
            {