CaseCol.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using System.Data;
using System.Data.OleDb;
namespace AccessDal
{
   public class CaseCol
    {
       /// <summary>
       /// 添加一条案例类别
       /// </summary>
       /// <param name="ccimg">类别代表图片</param>
       /// <param name="ccname">类别名称</param>
       /// <param name="ccdesc">类别简介</param>
       /// <param name="addtime">添加时间</param>
        /// <returns>返回Int，表示是否成功</returns>
       public static int Add(string ccimg,string ccname,string ccdesc,string addtime)
       {
           string sql = "INSERT INTO CaseColInfo ( [CCImg],[CCName] ,[CCDesc] ,[AddTime] ) VALUES (@CCImg,@CCName,@CCDesc,@AddTime)";
           OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@CCImg", ccimg), new OleDbParameter("@CCName", ccname), new OleDbParameter("@CCDesc", ccdesc), new OleDbParameter("@AddTime",addtime) };
           return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, p);
       }
       /// <summary>
       /// 修改案例类别
       /// </summary>
       /// <param name="ccimg">类别代表图片</param>
       /// <param name="ccname">类别名称</param>
       /// <param name="ccdesc">类别简介</param>
       /// <param name="addtime">修改时间</param>
       /// <param name="id">类别ID</param>
       /// <returns>返回Int，表示是否成功</returns>
       public static int Update(string ccimg, string ccname, string ccdesc, string addtime, int id)
       {
           string sql = "update CaseColInfo set [CCImg] = @CCImg,[CCName] = @CCName,[CCDesc] = @CCDesc,[AddTime] = @AddTime where ID=@ID";
           OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@CCImg", ccimg), new OleDbParameter("@CCName", ccname), new OleDbParameter("@CCDesc", ccdesc), 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 Delete(int id)
       {
           string sql = "delete from CaseColInfo where ID=@ID";
           return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, new OleDbParameter("@ID",id));
       }
       /// <summary>
       /// 获取案例类别总条数
       /// </summary>
       /// <returns>返回案例类别总条数</returns>
       public static int GetCount()
       {
           string sql = "select count(ID) from CaseColInfo";
           return (int)OleHelper.ExecuteScalar(OleHelper.connString, CommandType.Text, sql);
       }
       /// <summary>
       /// 获取案例类别列表