using System;
using System.Data.OleDb;
using System.Data.Common;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
namespace DataConvert.Lib
{
public static class SQLHelper
{
/// <summary>
/// 获取数据
/// </summary>
/// <param name="cmdtxt">SQL</param>
/// <param name="DBType">连接名称</param>
/// <returns>DataSet</returns>
public static DataSet GetDBDataSet(string cmdtxt, string DBType)
{
DataSet dsOrder = new DataSet();
ConnectionStringSettings sDB = ConfigurationManager.ConnectionStrings[DBType];
if (sDB.ProviderName != "")
{
DbProviderFactory fDB = DbProviderFactories.GetFactory(sDB.ProviderName);
using (DbConnection connDB = fDB.CreateConnection())
{
connDB.ConnectionString = sDB.ConnectionString;
try
{
connDB.Open();
DbCommand cmdDB = connDB.CreateCommand();
cmdDB.CommandText = cmdtxt;
DbDataAdapter da = fDB.CreateDataAdapter();
da.SelectCommand = cmdDB;
da.Fill(dsOrder);
connDB.Close();
}
catch (Exception ex)
{
LOG.WriteLog(DateTime.Now.ToString("[yyyy-MM-dd HH:mm:ss:fff]") + " " + ex.ToString());
connDB.Close();
}
}
}
else
{
using (OleDbConnection connOleDb = new OleDbConnection(sDB.ConnectionString))
{
try
{
connOleDb.Open();
OleDbCommand commOleDb = connOleDb.CreateCommand();
OleDbDataAdapter daOleDb = new OleDbDataAdapter();
commOleDb.CommandText = cmdtxt;
daOleDb.SelectCommand = commOleDb;
daOleDb.Fill(dsOrder);
connOleDb.Close();
}
catch (Exception e)
{
LOG.WriteLog(DateTime.Now.ToString("[yyyy-MM-dd HH:mm:ss:fff]") + " " + e.ToString());
connOleDb.Close();
}
}
}
return dsOrder;
}
/// <summary>
/// 执行上传SQL
/// </summary>
/// <param name="cmdtxt">SQL</param>
/// <param name="DBType">连接名称</param>
/// <returns></returns>
public static string ExcuteSQL(string cmdtxt, string DBType)
{
string str = string.Empty;
ConnectionStringSettings sDB = ConfigurationManager.ConnectionStrings[DBType];
if (sDB.ProviderName != "")
{
DbProviderFactory fDB = DbProviderFactories.GetFactory(sDB.ProviderName);
using (DbConnection connDB = fDB.CreateConnection())
{
connDB.ConnectionString = sDB.ConnectionString;
try
{
connDB.Open();
DbCommand cmdDB = connDB.CreateCommand();
cmdDB.CommandText = cmdtxt;
cmdDB.ExecuteNonQuery();
connDB.Close();
}
catch (Exception ex)
{
LOG.WriteLog(DateTime.Now.ToString("[yyyy-MM-dd HH:mm:ss:fff]") + " " + ex.ToString());
connDB.Close();
str = ex.Message;
}
}
}
else
{
using (OleDbConnection connOleDb = new OleDbConnection(sDB.ConnectionString))
{
try
{
connOleDb.Open();
OleDbCommand commOleDb = connOleDb.CreateCommand();
commOleDb.CommandText = cmdtxt;
commOleDb.ExecuteNonQuery();
connOleDb.Close();
}
catch (Exception e)
{
LOG.WriteLog(DateTime.Now.ToString("[yyyy-MM-dd HH:mm:ss:fff]") + " " + e.ToString());
connOleDb.Close();
str = e.Message;
}
}
}
return str;
}
public static string ExcuteByteSql(string cmdtxt, byte[] b)
{
string str = string.Empty;
string cnnstr = "provider=OraOLEDB.Oracle;data source=*;User Id=*;Password=*;";
//OleDbConnection con = new OleDbConnection(cnnstr);
using (OleDbConnection con = new OleDbConnection(cnnstr))
{
try
{
con.Open();
OleDbCommand cmd = new OleDbCommand(cnnstr, con);
cmd.CommandType = CommandType.Text;
cmd.CommandText = cnnstr;
cmd.CommandText = cmdtxt;
cmd.Parameters.Add("p", System.Data.OleDb.OleDbType.Binary, b.Length);
cmd.Parameters["p"].Value = b;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
LOG.WriteLog(DateTime.Now.ToString("[yyyy-MM-dd HH:mm:ss:fff]") + " " + e.ToString());
con.Close();
str = e.Message;
}
}
return str;
}
}
}
SQLHelper(oracle)
最新推荐文章于 2024-01-13 08:29:29 发布