dataselect.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace DBO
{
    public class DataSelect
    {
        #region 返回 DataSet 对象获取所有相应信息  SqlGetAllInfo(string procName, bool isProc,string tableName)
        /// <summary>
        /// 返回 DataSet 对象获取所有相应信息
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="isProc"></param>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public static DataSet SqlGetAllInfo(string procName, bool isProc, string tableName)
        {
            string getDBO = ReadAppData.getDataOnwer;
            DataSet objDataset = new DataSet();
            SqlDataAdapter objAdapter = new SqlDataAdapter(getDBO + "." + procName, CreateConnection.ObjConnection);
            if (isProc == false)
            {
                objAdapter.SelectCommand.CommandText = procName;
            }
            if (isProc == true)
            {
                objAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
            }
            objAdapter.Fill(objDataset, tableName);
            return objDataset;
        }
        #endregion


        #region 有参 返回 DataSet 对象获取所有相应信息 SqlGetAllInfo(string procName, bool isProc, string tableName,params SqlParameter[] sqlParms)
        /// <summary>
        /// 返回 DataSet 对象获取所有相应信息
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="isProc"></param>
        /// <param name="tableName"></param>
        /// <param name="sqlParms"></param>
        /// <returns></returns>
        public static DataSet SqlGetAllInfo(string procName, bool isProc, string tableName, params SqlParameter[] sqlParms)
        {
            string getDBO = ReadAppData.getDataOnwer;
            DataSet objDataset = new DataSet();
            SqlDataAdapter objAdapter = new SqlDataAdapter(getDBO + "." + procName, CreateConnection.ObjConnection);
            if (isProc == false)
            {
                objAdapter.SelectCommand.CommandText = procName;
            }
            if (isProc == true)
            {
                objAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
            }
            objAdapter.SelectCommand.Parameters.AddRange(sqlParms);
            objAdapter.Fill(objDataset, tableName);
            return objDataset;
        }
        #endregion

        #region  返回 SqlDataReader 对象获取所有相应信息应信息 SqlCreateDataReader(string procName, bool isProc)
        /// <summary>
        /// 返回 DataSet 对象获取所有相应信息
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="isProc"></param>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public static SqlDataReader SqlCreateDataReader(string procName, bool isProc)
        {
            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;
            }
            //获取记录条数
            //执行读取
            return objCommand.ExecuteReader(CommandBehavior.CloseConnection);

        }
        #endregion

        #region  返回 SqlDataReader 对象获取所有相应信息应信息 SqlCreateDataReader(string procName, bool isProc,params SqlParameter[] sqlParms)
        /// <summary>
        /// 返回 DataSet 对象获取所有相应信息
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="isProc"></param>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public static SqlDataReader SqlCreateDataReader(string procName, bool isProc,params SqlParameter[] sqlParms)
        {
            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(sqlParms);
            //执行读取
            return objCommand.ExecuteReader(CommandBehavior.CloseConnection);

        }
        #endregion

        #region  返回 SqlDataReader 对象获取所有相应信息应信息 SqlCreateDataReader(string sql)
        /// <summary>
        /// 返回 DataSet 对象获取所有相应信息
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="isProc"></param>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public static SqlDataReader SqlCreateDataReader(string sql)
        {
            SqlCommand objCommand = new SqlCommand(sql, CreateConnection.ObjConnection);
            //返回 SqlDataReader 对象
            return objCommand.ExecuteReader(CommandBehavior.CloseConnection);

        }
        #endregion

        //获取实体类数据
        #region  返回 SqlDataReader 对象获取所有相应信息应信息 SqlCreateDataReader(string sql)
        ///// <summary>
        ///// 返回 DataSet 对象获取所有相应信息
        ///// </summary>
        ///// <param name="procName"></param>
        ///// <param name="isProc"></param>
        ///// <param name="tableName"></param>
        ///// <returns></returns>
        //public static void SqlCreateDataReader(string sql,params string name)
        //{
        //    SqlCommand objCommand = new SqlCommand(sql, CreateConnection.ObjConnection);
        //    //返回 SqlDataReader 对象
        //    return objCommand.ExecuteReader(CommandBehavior.CloseConnection);

        //}
        #endregion
    }
}