Example #1
0
 public static OracleCommand GetOraCommand(String tsConnectId)
 {
     OraDB loOraDB = new OraDB();
     loOraDB.Open();
     loOraDB.BeginTransaction();
     return loOraDB.GetOraCommand();
 }
Example #2
0
        /// <summary>
        /// 带事务执行SQL文:例子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 bool ExeuseSQL(string[] sql)
        {
            bool result = true;
            try
            {
                OraDB conspy = new OraDB();
                conspy.Open();
                conspy.BeginTransaction();
                try
                {
                    for (int i = 0; i < sql.Length; i++)
                    {
                        conspy.ExecSqlTrans(sql[i]);
                    }
                    conspy.Commit();
                }
                catch (Exception e)
                {
                    String lsError = e.Message;
                    conspy.Rollback();
                    result = false;
                }
                conspy.Close();

            }
            catch (Exception e)
            {
                String lsError = e.Message;
                result = false;
            }
            return result;
        }
Example #3
0
 /// <summary>
 /// 执行SQL文
 /// </summary>
 /// <param name="sql">SQL文</param>
 /// <param name="connectID">连接取"DefaultSQL","Oracle","Sybase"等值</param>
 /// <returns>返回结果,错误返回-1</returns>
 public static int ExecSQL(string strFileName, string sql, ref string ErrorInfo)
 {
     OraDB myol = new OraDB();
     myol.Open();
     int i = myol.ExecSQL(sql,ref  ErrorInfo);
     myol.Close();
     return i;
 }
Example #4
0
 public static int ExecSP(String SPName)
 {
     OraDB oledb = new OraDB();
     oledb.Open();
     int i = oledb.ExecSP(SPName);
     oledb.Close();
     return i;
 }
Example #5
0
        /// <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;
        }
Example #6
0
 /// <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;
 }
Example #7
0
 /// <summary>
 /// 返回Command 自己执行带参数的sql
 /// </summary>
 /// <param name="tsConnectId"></param>
 /// <returns></returns>
 public static OracleCommand GetOraCommand(String dbStr)
 {
     OraDB loOraDB = new OraDB();
     loOraDB.Open(dbStr);
     return loOraDB.GetOraCommand();
 }