NewsColInfoOpe.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using Model;

namespace AccessDal
{
    /// <summary>
    /// 新闻类别数据库操作类
    /// </summary>
    public class NewsColInfoOpe
    {
        /// <summary>
        /// 添加新闻类别
        /// </summary>
        /// <param name="cimg"></param>
        /// <param name="cname"></param>
        /// <param name="addtime"></param>
        /// <returns></returns>
        public static int AddNewsColInfo(string cimg, string cname, string addtime)
        {
            OleDbParameter[] p = 
            {
                new OleDbParameter("@cimg",cimg),
                new OleDbParameter("@cname",cname),
                new OleDbParameter("@addtime",addtime)
            };
            string sql = "insert into NewsColInfo (CImg,CName,AddTime) values(@cimg,@cname,@addtime)";
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text,sql,p);
        }
        /// <summary>
        /// 删除新闻类别
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static int DeleteNewsColInfo(int id)
        {
            string sql = "delete from NewsColInfo where ID="+id;
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text,sql);
        }
        /// <summary>
        /// 修改新闻类别
        /// </summary>
        /// <param name="cimg"></param>
        /// <param name="cname"></param>
        /// <param name="addtime"></param>
        /// <param name="id"></param>
        /// <returns></returns>
        public static int UpdateNewsColInfo(string cimg, string cname, string addtime, int id)
        {
            OleDbParameter[] p = 
            {
                new OleDbParameter("@cimg",cimg),
                new OleDbParameter("@cname",cname),
                new OleDbParameter("@addtime",addtime),
                new OleDbParameter("@id",id)
            };
            string sql = "update NewsColInfo set CImg=@cimg,CName=@cname,AddTime=@addtime where ID=@id";