datascalar.cs

来自「提供数据库访问 直接调用你的方法 根据需求 合理使用」· CS 代码 · 共 96 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace DBO.Access
{
    public class DataScalar
    {
        #region  获取 返回首行首列的数据 AccessGetSacalarRecord
        /// <summary>
        ///  获取 返回首行首列的数据
        /// </summary>
        /// <param name="accessStr">Access 数据库操作语句</param>
        /// <param name="isSaSafe">如果有参数</param>
        /// <param name="objParm"></param>
        /// <returns></returns>
        public static object AccessGetSacalarRecord(string accessStr, bool isSaSafe, params OleDbParameter[] objParm)
        {
            OleDbCommand objCommand = new OleDbCommand(accessStr, CreateConnection.ObjConnection);
            if (isSaSafe == true)
            {
                objCommand.Parameters.AddRange(objParm);
            }
            return objCommand.ExecuteScalar();
        }
        #endregion

        #region  获取 返回首行首列的数据 AccessGetSacalarRecord
        /// <summary>
        ///  获取 返回首行首列的数据 AccessGetSacalarRecord
        /// </summary>
        /// <param name="accessStr">Access 数据库操作语句</</param>
        /// <returns></returns>
        public static object AccessGetSacalarRecord(string accessStr)
        {
            OleDbCommand objCommand = new OleDbCommand(accessStr, CreateConnection.ObjConnection);
            return objCommand.ExecuteScalar();
        }
        #endregion

        #region 获取 返回首行首列的数据 AccessGetReaderRecord
        /// <summary>
        /// 获取 返回首一条的数据 
        /// </summary>
        /// <param name="procName">数据库存储过程名或 或用参数定义的SQL 语句</param>
        /// <param name="isProc">是不是存储过程</param>
        /// <param name="objParm">数据参数的 </param>
        /// <param name="ColumnIndex">列名索引</param>
        /// <returns></returns>
        public static object AccessGetReaderRecord(string accessStr, bool isSaSafe, int ColumnIndex, params OleDbParameter[] objParm)
        {
            object recordValue = null;

            OleDbCommand objCommand = new OleDbCommand(accessStr, CreateConnection.ObjConnection);
            if (isSaSafe == true)
            {
                objCommand.Parameters.AddRange(objParm);
            }
            //更具列名读取一条数据
            using (OleDbDataReader objReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
            {
                if (objReader.Read())
                {
                    recordValue = objReader[ColumnIndex];
                }
            }
            return recordValue;
        }
        #endregion

        #region 获取 返回首行首列的数据 AccessGetReaderRecord
        /// <summary>
        /// 获取 返回首行首列的数据 AccessGetReaderRecord
        /// </summary>
        /// <param name="accessStr"></param>
        /// <param name="ColumnIndex"></param>
        /// <returns></returns>
        public static object AccessGetReaderRecord(string accessStr, int ColumnIndex)
        {
            object recordValue = null;
            OleDbCommand objCommand = new OleDbCommand(accessStr, CreateConnection.ObjConnection);
            //更具列名读取一条数据
            using (OleDbDataReader objReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
            {
                if (objReader.Read())
                {
                    recordValue = objReader[ColumnIndex];
                }
            }
            return recordValue;
        }
        #endregion
    }
}