CreateSQLSentence/NewsSentence.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DAL;
using Model;
using IDAL;
//51-aspx
namespace CreateSQLSentence
{
    public class NewsSentence : I_NewsManage
    {
        SQLAccess sqlManager = new SQLAccess();
        #region I_NewsManage 成员
        /// <summary>
        /// 根据新闻类别号查询新闻
        /// </summary>
        /// <param name="classID">新闻类别号</param>
        /// <returns>查询的结果</returns>
        public DataSet SelectNewsByCID(News newsObject)
        {
            StringBuilder sqlSentence = new StringBuilder();
            sqlSentence.Append("select * from Tab_News where NewClassID=" + newsObject.NewClassID1);
            return sqlManager.ExecuteDataSet(sqlSentence.ToString());
        }
        /// <summary>
        /// 根据新闻号查询新闻
        /// </summary>
        /// <param name="newsObject">新闻号</param>
        /// <returns>查询的结果</returns>
        public DataSet SelectNewsByID(News newsObject)
        {
            StringBuilder sqlSentence = new StringBuilder();
            sqlSentence.Append("select * from Tab_News where NewID=" + newsObject.NewID1);
            return sqlManager.ExecuteDataSet(sqlSentence.ToString());
        }
        #endregion
    }
}