DAL/News.cs

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

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

using System;
using System.Collections.Generic;

using System.Text;
using System.Data.SqlClient;
using System.Data;
using Common;
namespace DAL
{
    public class News
    {
        public int add(Model.News mn)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append(" insert into news ");
            sql.Append(" (_title,_from,_author,_top,_click,_content,_cateid,_ispic) ");
            sql.Append(" values( @title,@from,@author,@top,@click,@content,@cateid,@ispic ) ");
            SqlParameter[] par = { new SqlParameter( "@title",SqlDbType.VarChar,50 ),
                                   new SqlParameter("@from",SqlDbType.VarChar,50),
                                   new SqlParameter("@author",SqlDbType.VarChar,50),
                                   new SqlParameter("@top",SqlDbType.VarChar,50),
                                   new SqlParameter("@click",SqlDbType.VarChar,50),
                                   new SqlParameter("@content",SqlDbType.VarChar,0),
                                   new SqlParameter("@cateid",SqlDbType.VarChar,50),
                                   new SqlParameter("@ispic",SqlDbType.VarChar,50)
                                 };
            par[0].Value = mn.Title;
            par[1].Value = mn.From;
            par[2].Value = mn.Author;
            par[3].Value = mn.Top;
            par[4].Value = mn.Click;
            par[5].Value = mn.Content;
            par[6].Value = mn.Cateid;
            par[7].Value = mn.Ispic;
            int result = DbHelperSQL.ExecuteSql(sql.ToString(),par);
            return result;
        }
        public int _delete(Model.News mn)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append(" delete from news where _id=@nid ");
            SqlParameter[] par = { new SqlParameter("@nid", SqlDbType.Int, 4) };
            par[0].Value = mn.ID;
            int result = DbHelperSQL.ExecuteSql(sql.ToString(),par);
            return result;
        }

        //通过删除新闻分类同时删除相关新闻
        public int _deletebycate(Model.Newscate mn)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append(" delete from news where _cateid=@nid ");
            SqlParameter[] par = { new SqlParameter("@nid", SqlDbType.Int, 4) };
            par[0].Value = mn.ID;
            int result = DbHelperSQL.ExecuteSql(sql.ToString(), par);
            return result;
        }

        public SqlDataReader datareader (Model.News mn)
        {