Dal/obj/DBanner.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;

namespace Dal
{
    public class DBanner
    {
        /// <summary>
        /// 分类下是否有内容
        /// </summary>
        /// <param name="NS_Id"></param>
        /// <returns></returns>
        public bool HasContent(int NS_Id)
        {
            return OLEDBHelper.HasRecord("select top 1 N_Id from Banner where N_Sortid=" + NS_Id.ToString(), null, CommandType.Text);
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public MBanner GetModel(int N_Id)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 N_Id,N_SortId,N_Name,N_Name2,N_Date,N_Order,N_Key,N_Click,N_Show,N_Special,N_Url,N_Pic,N_Pic2,N_Memo,N_Content,N_Title,N_Keywords,N_Description from Banner ");
            strSql.Append(" where N_Id=@N_Id ");
            SqlParameter[] parameters = {
					new SqlParameter("@N_Id", SqlDbType.Int,4)};
            parameters[0].Value = N_Id;

            MBanner model = null;
            SqlDataReader sdr = OLEDBHelper.ExeReader(strSql.ToString(), parameters, CommandType.Text);
            if (sdr.Read())
            {
                model = new MBanner();

                model.N_Id = int.Parse(sdr["N_Id"].ToString());


                model.N_Special = int.Parse(sdr["N_Special"].ToString());

                model.N_Url = sdr["N_Url"].ToString();
                model.N_Pic = sdr["N_Pic"].ToString();
                model.N_Pic2 = sdr["N_Pic2"].ToString();
                model.N_Memo = sdr["N_Memo"].ToString();
                model.N_Content = sdr["N_Content"].ToString();
                model.N_Title = sdr["N_Title"].ToString();
                model.N_Keywords = sdr["N_Keywords"].ToString();
                model.N_Description = sdr["N_Description"].ToString();

                model.N_SortId = int.Parse(sdr["N_SortId"].ToString());

                model.N_Name = sdr["N_Name"].ToString();
                model.N_Name2 = sdr["N_Name2"].ToString();