1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Data;
  5
  6namespace SQLServerDAL
  7...{
  8    /**//// <summary>
  9    /// 业务逻辑层
 10    /// 新闻评论类
 11    /// </summary>
 12    public class answer
 13    ...{
 14        /**//// <summary>
 15        /// 实例化基类的对象
 16        /// </summary>
 17        DBbase db = new DBbase();
 18
 19        根据新闻ID删除该新闻的全部评论#region 根据新闻ID删除该新闻的全部评论
 20        /**//// <summary>
 21        /// 根据新闻ID删除该新闻的全部评论
 22        /// </summary>
 23        /// <param name="NewsID">新闻ID</param>
 24        /// <returns>true,false</returns>
 25        public bool DeleteAllByNewsID(int NewsID)
 26        ...{
 27            string strSQL = "delete from answer where newsID=" + NewsID;
 28            return db.ExecuteNonQuery(false, strSQL);
 29        }
 30        #endregion
 31
 32        获取全部新闻评论#region 获取全部新闻评论
 33        /**//// <summary>
 34        /// 获取全部新闻评论
 35        /// </summary>
 36        /// <returns>DataSet数据集</returns>
 37        public DataSet GetAllAnswer()
 38        ...{
 39            string strSQL = "select * from answer";
 40            return db.ReturnDataSet(strSQL);
 41        }
 42        #endregion
 43
 44        根据新闻ID查询该新闻的最新3条评论#region 根据新闻ID查询该新闻的最新3条评论
 45        /**//// <summary>
 46        /// 根据新闻ID查询该新闻的最新3条评论
 47        /// </summary>
 48        /// <param name="NewsID">新闻ID</param>
 49        /// <returns>DataSet数据集合</returns>
 50        public DataSet GetAnswerByNewsID(int NewsID)
 51        ...{
 52            string strSQL = "select top 3 * from answer where newsID=" + NewsID + " order by cindex DESC";
 53            return db.ReturnDataSet(strSQL);
 54        }
 55        #endregion
 56
 57        根据新闻ID查询该新闻的全部评论#region 根据新闻ID查询该新闻的全部评论
 58        /**//// <summary>
 59        /// 根据新闻ID查询该新闻的全部评论
 60        /// </summary>
 61        /// <param name="NewsID">新闻ID</param>
 62        /// <returns>DataSet数据集合</returns>
 63        public DataSet GetALLAnswerByNewsID(int NewsID)
 64        ...{
 65            string strSQL = "select  * from answer where newsID=" + NewsID;
 66            return db.ReturnDataSet(strSQL);
 67        }
 68        #endregion
 69
 70        根据新闻ID获取该新闻的评论的条数#region 根据新闻ID获取该新闻的评论的条数
 71        /**//// <summary>
 72        /// 根据新闻ID获取该新闻的评论的条数
 73        /// </summary>
 74        /// <param name="NewsID">新闻ＩＤ</param>
 75        /// <returns>DataSet数据集</returns>
 76        public DataSet GetCindexByNewsID(int NewsID)
 77        ...{
 78            string strSQL = "select max(cindex) as cindex  from answer where newsID=" + NewsID;
 79            return db.ReturnDataSet(strSQL);
 80        }
 81        #endregion
 82
 83        根据新闻ID添加评论#region 根据新闻ID添加评论
 84        /**//// <summary>
 85        /// 根据新闻ID添加评论
 86        /// </summary>
 87        /// <param name="Ma">实体层answer类的对象</param>
 88        /// <returns>DataSet数据集</returns>
 89        public bool AddAnswerByNewsID(Model.answer Ma)
 90        ...{
 91            int cindex=1;
 92            if (GetCindexByNewsID(Ma.newID).Tables[0].Rows[0][0].ToString() == "")
 93            ...{
 94                cindex=1;
 95            }
 96            else
 97            ...{
 98                cindex = int.Parse(GetCindexByNewsID(Ma.newID).Tables[0].Rows[0][0].ToString());
 99                cindex += 1;
100            }
101            string strSQL = "insert into answer (A_user,A_qq,A_email,A_word,A_time,newsID,cindex) values ('" + Ma.A_user + "','" + Ma.A_qq + "','" + Ma.A_email + "','" + Ma.A_word + "','" + Ma.A_time + "'," + Ma.newID + "," + cindex + ")";
102            return db.ExecuteNonQuery(false, strSQL);
103        }
104        #endregion
105    }
106}
107