Case.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using System.Data;
using System.Data.OleDb;
namespace AccessDal
{
    public class Case
    {
        /// <summary>
        /// 添加一条案例信息
        /// </summary>
        /// <param name="ccid">类别ID</param>
        /// <param name="caseimg">案例图片</param>
        /// <param name="casename">案例名称</param>
        /// <param name="casedesc">案例简介</param>
        /// <param name="casecontent">案例详细内容</param>
        /// <param name="casetime">案例发生时间</param>
        /// <param name="addtime">添加时间</param>
        /// <returns>返回Int，表示是否成功</returns>
        public static int Add(int ccid,string caseimg,string casename,string casedesc,string casecontent,string casetime,string addtime)
        {
            string sql = "INSERT INTO CaseInfo ( [CCID] ,[CaseImg] ,[CaseName] ,[CaseDesc] ,[CaseContent] ,[CaseTime] ,[AddTime] ) VALUES (@CCID,@CaseImg,@CaseName,@CaseDesc,@CaseContent,@CaseTime,@AddTime)";
            OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@CCID", ccid), new OleDbParameter("@CaseImg", caseimg), new OleDbParameter("@CaseName", casename), new OleDbParameter("@CaseDesc", casedesc), new OleDbParameter("@CaseContent", casecontent), new OleDbParameter("@CaseTime", casetime), new OleDbParameter("@AddTime", addtime) };
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, p);
        }
        /// <summary>
        /// 修改案例信息
        /// </summary>
        /// <param name="ccid">类别ID</param>
        /// <param name="caseimg">案例图片</param>
        /// <param name="casename">案例名称</param>
        /// <param name="casedesc">案例简介</param>
        /// <param name="casecontent">案例详细内容</param>
        /// <param name="casetime">案例发生时间</param>
        /// <param name="addtime">修改时间</param>
        /// <param name="id">案例ID</param>
        /// <returns>返回Int，表示是否成功</returns>
        public static int Update(int ccid, string caseimg, string casename, string casedesc, string casecontent, string casetime, string addtime,int id)
        {
            string sql = "update CaseInfo set [CCID] = @CCID,[CaseImg] = @CaseImg,[CaseName] = @CaseName,[CaseDesc] = @CaseDesc,[CaseContent] = @CaseContent,[CaseTime] = @CaseTime,[AddTime] = @AddTime where ID=@ID";
            OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@CCID", ccid), new OleDbParameter("@CaseImg", caseimg), new OleDbParameter("@CaseName", casename), new OleDbParameter("@CaseDesc", casedesc), new OleDbParameter("@CaseContent", casecontent), new OleDbParameter("@CaseTime", casetime), new OleDbParameter("@AddTime", addtime),new OleDbParameter("@ID",id) };
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, p);
        }
       /// <summary>
       /// 修改案例浏览数
       /// </summary>
       /// <param name="id">案例ID</param>
        /// <returns>返回Int，表示是否成功</returns>
        public static int Update(int id)
        {
            string sql = "update CaseInfo set [ReadCount]=[ReadCount]+1 where ID=@ID";
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, new OleDbParameter("@ID", id));
        }
        /// <summary>
        /// 修改案例状态（是否置顶）
        /// </summary>
        /// <param name="id">案例ID</param>
        /// <param name="istop">是否置顶</param>