SenBiTeSolution.DAL/tbl_News.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using SenBiTeSolution.Model;
using System.Data;
using System.Data.OleDb;
using SenBiTeSolution.DBUtility;

namespace SenBiTeSolution.DAL
{
    public  class tbl_News
    {
        //增加一条新闻
        public int AddNews(Model.tbl_News news)
        {
            string sqlString = "insert into tbl_News(NewsTitle,NewsContent,CreateDate) values(@NewsTitle,@NewsContent,@CreateDate)";

            OleDbParameter[] parameters = new OleDbParameter[3];

            parameters[0] = new OleDbParameter("@NewsTitle", OleDbType.VarChar, 50);
            parameters[0].Value = news.NewsTitle;

            parameters[1] = new OleDbParameter("@NewsContent", OleDbType.VarChar, 3000);
            parameters[1].Value = news.NewsContent;

            parameters[2] = new OleDbParameter("@CreateDate", OleDbType.VarChar,20);
            parameters[2].Value = news.CreateDate;

            return  DbHelperOleDb.ExecuteSql(sqlString, 1, parameters);

        }

        //删除一条新闻
        public int DelNews(Model.tbl_News news)
        {
            string sqlString = "delete from tbl_News where ID=@ID";

            OleDbParameter[] parameters = new OleDbParameter[1];

            parameters[0] = new OleDbParameter("@ID", OleDbType.Integer, 4);
            parameters[0].Value = news.ID;

            return DbHelperOleDb.ExecuteSql(sqlString, 1, parameters);
        }

        //根据新闻ID修改新闻
        public int UpdateNews(Model.tbl_News news)
        {
            string sqlString = "update tbl_News set NewsTitle=@NewsTitle,NewsContent=@NewsContent,CreateDate=@CreateDate where ID=@ID";

            OleDbParameter[] parameters = new OleDbParameter[4];

            parameters[0] = new OleDbParameter("@NewsTitle",OleDbType.VarChar, 50);
            parameters[0].Value = news.NewsTitle;

            parameters[1] = new OleDbParameter("@NewsContent", OleDbType.VarChar, 3000);
            parameters[1].Value = news.NewsContent;