DAL/DALnews.cs

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

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

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

namespace DAL
{
   public class DALnews
    {
        //删除某条新闻
        public int DeleNews(CNews news)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("delete from tb_news where NewsID = @id");
            SqlParameter[] par ={
                                    new SqlParameter ("@id",SqlDbType.Int,4)
                                };
            par[0].Value = news.News_id;
            return DBHelperSQL.ExecuteSql(sql.ToString(), par);
        }

        //通过新闻标题查询新闻
        public DataSet SelNN(int a, int b, string c, CNews news)
        {
            string sql = "select * from tb_news where NewsName like '%" + news.News_name + "%'";
            DataSet ds = SQLHelper.PagedataSet(sql, a, b, c);
            return ds;
        }

        //通过新闻作者查询新闻
        public DataSet SelNEd(int a, int b, string c, CNews news)
        {
            string sql = "select * from tb_news where NewsEditor  like '%" + news.News_editor + "%'";
            DataSet ds = SQLHelper.PagedataSet(sql, a, b, c);
            return ds;
        }

        //通过新闻标题查询是否有新闻
        public int CountNa(CNews news)
        {
            string sql = "select count(*) from tb_news where NewsName like '%" + news.News_name + "%'";
            int result = Convert.ToInt32(DBHelperSQL.ExecuteSqlCell(sql));
            return result;
        }


        //通过新闻作者查询是否有新闻
        public int CountEd(CNews news)
        {
            string sql = "select count(*) from tb_news where NewsEditor like '%" + news.News_editor + "%'";
            int result = Convert.ToInt32(DBHelperSQL.ExecuteSqlCell(sql));
            return result;
        }

        //获得数据库中一行的数据
        public SqlDataReader NewsRow(CNews news)
        {