/// <summary> /// 执行sql语句或存储过程,返回DataSet /// </summary> /// <param name="ConnString">连接字符串,可以自定义,可以以使用SqlHelper_DG.ConnString</param> /// <param name="commandTextOrSpName">sql语句或存储过程名称</param> /// <param name="commandType">命令类型</param> /// <param name="dictionary">SqlParameter[]参数数组,允许空</param> /// <returns></returns> public static DataSet ExecuteDataSet(string commandTextOrSpName, CommandType commandType, Dictionary <string, object> dictionary) { using (SqlConnection_WR_Safe conn = new SqlConnection_WR_Safe(dataBaseType, ConnString_R, ConnString_RW)) { using (DbCommandCommon cmd = new DbCommandCommon(dataBaseType)) { PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType, dictionary); using (DbDataAdapterCommon da = new DbDataAdapterCommon(dataBaseType, cmd.DbCommand)) { DataSet ds = new DataSet(); da.Fill(ds); return(ds); } } } }
/** * Update At 2017-3-2 14:58:45 * Add the ExecuteDataTable Method into Sql_Helper_DG **/ /// <summary> /// 执行sql语句或存储过程,返回DataTable不带参数 /// </summary> /// <param name="ConnString">连接字符串,可以自定义,可以以使用SqlHelper_DG.ConnString</param> /// <param name="commandTextOrSpName">sql语句或存储过程名称</param> /// <param name="commandType">命令类型 有默认值CommandType.Text</param> /// <returns></returns> public static DataTable ExecuteDataTable(string commandTextOrSpName, CommandType commandType = CommandType.Text) { using (SqlConnection_WR_Safe conn = new SqlConnection_WR_Safe(dataBaseType, ConnString_R, ConnString_RW)) { using (DbCommandCommon cmd = new DbCommandCommon(dataBaseType)) { PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType); using (DbDataAdapterCommon da = new DbDataAdapterCommon(dataBaseType, cmd.DbCommand)) { DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables.Count > 0) { return(ds.Tables[0]); } return(default(DataTable)); } } } }