SenBiTeSolution.DBUtility/DbHelperOleDb.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
//www.51aspx.com
namespace SenBiTeSolution.DBUtility
{
    public class DbHelperOleDb
    {
        /// <summary>
        /// 数据库连接字符串
        /// </summary>
        public static string connectionString = ConfigurationManager.AppSettings["ConnString"].ToString();

        public DbHelperOleDb()
        {
        }

        #region 公用方法
        /// <summary>
        /// 取得最大的ID
        /// </summary>
        /// <param name="filedName">字段名，一般指ID</param>
        /// <param name="tableName">表名</param>
        /// <returns>int</returns>
        public static int GetMaxID(string filedName, string tableName)
        {
            string sqlString = "select max(" + filedName + ") from " + tableName;
            object obj = GetSignal(sqlString);
            if (object.Equals(obj, null) || object.Equals(obj, DBNull.Value))
            {
                return 0;
            }
            else
            {
                return int.Parse(obj.ToString());
            }
        }

        /// <summary>
        /// 判断数据是否存在
        /// </summary>
        /// <param name="sqlString"></param>
        /// <returns></returns>
        public static bool Exists(string sqlString)
        {
            object obj = GetSignal(sqlString);
            int cmdresult = 0;
            if (object.Equals(obj, null) || object.Equals(obj, DBNull.Value))
            {
                cmdresult = 0;
            }
            else
            {
                cmdresult = int.Parse(obj.ToString());
            }