datascalar.cs

提供数据库访问 直接调用你的方法 根据需求 合理使用

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace DBO
{
    public class DataScalar
    {
        #region  获取 返回首行首列的数据 SqlGetSacalarRecord
        /// <summary>
        /// 获取 返回首行首列的数据
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="isProc"></param>
        /// <param name="objParm"></param>
        /// <returns></returns>
        public static object SqlGetSacalarRecord(string procName, bool isProc,params SqlParameter[] objParm)
        {
            string getDBO = ReadAppData.getDataOnwer;
            SqlCommand objCommand = new SqlCommand(getDBO + "." + procName, CreateConnection.ObjConnection);
            if (isProc == false)
            {
                objCommand.CommandText = procName;
            }
            if (isProc == true)
            {
                objCommand.CommandType = CommandType.StoredProcedure;
                objCommand.Parameters.AddRange(objParm);
            }
            return objCommand.ExecuteScalar();
        }
        #endregion

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

        #region 获取 返回首行首列的数据 SqlGetReaderRecord
        /// <summary>
        /// 获取 返回首一条的数据 
        /// </summary>
        /// <param name="procName">数据库存储过程名或 或用参数定义的SQL 语句</param>
        /// <param name="isProc">是不是存储过程</param>
        /// <param name="objParm">数据参数的 </param>
        /// <param name="ColumnIndex">列名索引</param>
        /// <returns></returns>
        public static object SqlGetReaderRecord(string procName, bool isProc,int ColumnIndex,params SqlParameter[] objParm)
        {
            object recordValue = null;
            string getDBO = ReadAppData.getDataOnwer;
            SqlCommand objCommand = new SqlCommand(getDBO + "." + procName, CreateConnection.ObjConnection);

            if (isProc == false)
            {
                objCommand.CommandText = procName;
            }
            if (isProc == true)
            {
                objCommand.CommandType = CommandType.StoredProcedure;
            }
            objCommand.Parameters.AddRange(objParm);
            //更具列名读取一条数据
            using (SqlDataReader objReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
            {
                if (objReader.Read())
                {
                    recordValue = objReader[ColumnIndex];
                }
            }
            return recordValue;
        }
        #endregion

        #region 获取 返回首行首列的数据 SqlGetReaderRecord
        /// <summary>
        /// 返回提条记录
        /// </summary>
        /// <param name="sql">操作数据命令的与语句</param>
        /// <param name="ColumnIndex">查询的列名</param>
        /// <returns></returns>
        public static object SqlGetReaderRecord(string sql, int ColumnIndex)
        {
            object recordValue = null;
            SqlCommand objCommand = new SqlCommand(sql, CreateConnection.ObjConnection);
            //更具列名读取一条数据
            using (SqlDataReader objReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
            {
                if (objReader.Read())
                {
                    recordValue = objReader[ColumnIndex];
                }
            }
            return recordValue;
        }
        #endregion
    }
}