/// <summary>
/// 执行SQL文到DataSet:例子DataSet loginDS=sysConfig.exeusesql("Login.aspx.cs123",strsql,"DefaultSQL","dt");
/// </summary>
/// <param name="sql">SQL文</param>
/// <param name="connectID">连接取"DefaultSQL","Oracle","Sybase"等值</param>
/// <returns></returns>
public static int SelectSQL(string strFileName, string sql, ref DataSet ds, ref string ErrorInfo)
{
int iResult = -1;
string strMyError = "";
DataSet tempds = new DataSet();
try
{
//查看日志设置级别
//if (sql.ToLower().StartsWith("select"))
//{
//}
//else
//{
// if (strFileName.StartsWith("UserONline.aspx"))
// {
// }
// else
// {
// DBlog(strFileName, connectID, sql);//打log
// }
//}
OraDB conspy = new OraDB();
conspy.Open();
iResult = conspy.SelectDataToDataSet(tempds, sql, ref strMyError);
ds = tempds.Copy();
conspy.Close();
}
catch (Exception e)
{
//重新开始执行3次，如果失败就放弃
//for (int i = 0; i < 3; i++)
//{
// try
// {
// OLEDB conspy = new OLEDB(connectID);
// conspy.Open();
// iResult = conspy.SelectDataToDataSet(tempds, sql, ref strMyError);
// conspy.Close();
// ds = tempds.Copy();
// break;
// }
// catch (Exception f)
// {
// ErrorInfo = f.Message;//设置错误信息
// }
//}
//DBErrorlog(strFileName, connectID, sql);//打log
//DBErrorlog(strFileName, connectID, e.Message);
//DBErrorlog(strFileName, "", "============================================================================================================");
}
return iResult;
}
/// <summary>
/// 执行SQL文到DataSet:例子DataSet loginDS=sysConfig.exeusesql("Login.aspx.cs123",strsql,"DefaultSQL","dt");
/// </summary>
/// <param name="strFileName"></param>
/// <param name="sql"></param>
/// <param name="ds"></param>
/// <param name="ErrorInfo"></param>
/// <returns></returns>
public static int SelectSQL(string strFileName, string sql, ref DataSet ds, ref string ErrorInfo)
{
int iResult = -1;
string strMyError = "";
DataSet tempds = new DataSet();
OraDB conspy = new OraDB();
conspy.Open();
try
{
iResult = conspy.SelectDataToDataSet(tempds, sql, ref strMyError);
ds = tempds.Copy();
}
catch (Exception e)
{
throw e;
}
finally
{
conspy.Close();
}
return iResult;
}