Hidistro.SqlDal/VShop/BannerDao.cs

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

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

namespace Hidistro.SqlDal.VShop
{
    using Hidistro.Entities;
    using Hidistro.Entities.VShop;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Text;

    public class BannerDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public bool DelTplCfg(int id)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(new StringBuilder(" delete from Hishop_Banner where BannerId=@BannerId").ToString());
            this.database.AddInParameter(sqlStringCommand, "BannerId", DbType.Int32, id);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public IList<BannerInfo> GetAllBanners()
        {
            IList<BannerInfo> list = new List<BannerInfo>();
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(new StringBuilder("select * from  Hishop_Banner where type=1 ORDER BY DisplaySequence ASC").ToString());
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                return ReaderConvert.ReaderToList<BannerInfo>(reader);
            }
        }

        public IList<NavigateInfo> GetAllNavigate()
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(new StringBuilder("select * from  Hishop_Banner where type=2 ORDER BY DisplaySequence ASC").ToString());
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                return ReaderConvert.ReaderToList<NavigateInfo>(reader);
            }
        }

        public int GetCountBanner()
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select count(BannerId) from Hishop_Banner where type=1");
            if (this.database.ExecuteScalar(sqlStringCommand) != DBNull.Value)
            {
                return Convert.ToInt32(this.database.ExecuteScalar(sqlStringCommand));
            }
            return 0;
        }

        private int GetMaxBannerSequence()
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select max(DisplaySequence) from Hishop_Banner");
            if (this.database.ExecuteScalar(sqlStringCommand) != DBNull.Value)
            {
                return (1 + Convert.ToInt32(this.database.ExecuteScalar(sqlStringCommand)));
            }
            return 1;
        }