Backup/AccessDal/Company.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using System.Data;
using System.Data.OleDb;
namespace AccessDal
{
   public class Company
    {
       /// <summary>
       /// 添加一条公司信息
       /// </summary>
       /// <param name="comtitle">公司信息标题</param>
        /// <param name="comcontent">公司信息内容</param>
       /// <param name="addtime">添加时间</param>
       /// <returns>返回Int，表示是否成功</returns>
       public static int Add(string comtitle,string comcontent,string addtime)
       {
           string sql = "INSERT INTO CompanyInfo ( [ComTitle] ,[ComContent] ,[AddTime] ) VALUES (@ComTitle,@ComContent,@AddTime)";
           OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@ComTitle", comtitle), new OleDbParameter("@ComContent", comcontent), new OleDbParameter("@AddTime", addtime) };
           return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, p);
       }
       /// <summary>
       /// 修改公司信息
       /// </summary>
       /// <param name="comtitle">公司信息标题</param>
       /// <param name="comcontent">公司信息内容</param>
       /// <param name="addtime">修改时间</param>
       /// <param name="id">公司信息ID</param>
       /// <returns>返回Int，表示是否成功</returns>
       public static int Update(string comtitle,string comcontent,string addtime,int id)
       {
           string sql="update CompanyInfo set [ComTitle] = @ComTitle,[ComContent] = @ComContent,[AddTime] = @AddTime where ID=@ID";
              OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@ComTitle", comtitle), new OleDbParameter("@ComContent", comcontent), 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 CompanyInfo 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 CompanyInfo";
           return (int)OleHelper.ExecuteScalar(OleHelper.connString, CommandType.Text, sql);
       }
      /// <summary>
      /// 获取公司信息列表
      /// </summary>
      /// <param name="start">起始值</param>