/// <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; }