public static string GetDbConnection(string sConfigPara)
{
string connection_string = "";
try
{
//从Config配置文件中获取数据库连接字符串并返回OleDb连接
//System.Data.OleDb.OleDbConnection oleconn = new System.Data.OleDb.OleDbConnection(SunnyWMSClient.Properties.Settings.Default.CodeMaintainConnectionString);
if (CommonDa.GetDbType() == EnumDbTypes.PgSql)
{
connection_string = ConfigIO.GetConnectionString("postgresql_conn");
}
else if (CommonDa.GetDbType() == EnumDbTypes.Sqlite)
{
connection_string = ConfigIO.GetConnectionString("sqlite_conn");
if (sConfigPara.Trim() != "")
{
connection_string = ConfigIO.GetConnectionString(sConfigPara);
}
;
}
}
catch (Exception ex)
{
throw ex;
return("");
//return null;
}
return(connection_string);
}
public static string GetPgConnection()
{
try
{
//从Config配置文件中获取数据库连接字符串并返回OleDb连接
//System.Data.OleDb.OleDbConnection oleconn = new System.Data.OleDb.OleDbConnection(SunnyWMSClient.Properties.Settings.Default.CodeMaintainConnectionString);
string pg_connection_string = ConfigIO.GetConnectionString("postgresql_conn");
return(pg_connection_string);
}
catch (Exception ex)
{
throw ex;
return("");
//return null;
}
}