SuLei.DAL/sl_article.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Reflection;
using System.Collections.Generic;
using System.Data.SqlClient;
using SuLei.DBUtility;
using SuLei.Common;

namespace SuLei.DAL
{
	/// <summary>
	/// 数据访问类:文章内容
	/// </summary>
	public partial class sl_article
	{
        private string databaseprefix; //数据库表名前缀
        public sl_article(string _databaseprefix)
        {
            databaseprefix = _databaseprefix;
        }
		#region 基本方法================================
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string channel_name, int article_id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from " + databaseprefix + SLKeys.TABLE_CHANNEL_ARTICLE + channel_name);
            strSql.Append(" where id=@article_id");
            SqlParameter[] parameters = {
					new SqlParameter("@article_id", SqlDbType.Int,4)};
            parameters[0].Value = article_id;
            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string channel_name, string call_index)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from " + databaseprefix + SLKeys.TABLE_CHANNEL_ARTICLE + channel_name);
            strSql.Append(" where call_index=@call_index");
            SqlParameter[] parameters = {
					new SqlParameter("@call_index", SqlDbType.NVarChar,50)};
            parameters[0].Value = call_index;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }

		/// <summary>
		/// 增加一条数据
		/// </summary>
        public int Add(Model.sl_article model)
        {
            //查询频道名称
            string channelName = new DAL.sl_site_channel(databaseprefix).GetChannelName(model.channel_id);
            if (channelName.Length == 0)
            {