public long m_lngUploadData(List <string> p_glsSQL) { long lngRes = -1; //OracleConnection conn = new OracleConnection(this.m_strGetDBConnetionString()); OracleConnection conn = new OracleConnection(com.digitalwave.iCare.middletier.DataCollection.clsDataUpload_Svc.m_strGetDbConnection()); OracleCommand oraCmd = conn.CreateCommand(); OracleTransaction oraTran = null; clsLogText log = new clsLogText(); try { conn.Open(); oraTran = conn.BeginTransaction(); oraCmd.Transaction = oraTran; int intLen = p_glsSQL.Count; for (int i = 0; i < intLen; i++) { log.Log2File(LogFilepath, LogNortitle + p_glsSQL[i].ToString()); oraCmd.CommandTimeout = 30000; oraCmd.CommandText = p_glsSQL[i].ToString(); lngRes = oraCmd.ExecuteNonQuery(); if (lngRes < 1) { p_glsSQL = null; oraTran.Rollback(); conn.Close(); conn.Dispose(); return(lngRes); } System.Threading.Thread.Sleep(100); } oraTran.Commit(); } catch (Exception Exp) { log.Log2File(LogFilepath, LogExctitle + Exp.Message); oraTran.Rollback(); MessageBox.Show(Exp.ToString()); } finally { conn.Close(); conn.Dispose(); } return(lngRes); }
public long m_lngUploadDataTest(List <string> p_glsSQL) { clsLogText log = new clsLogText(); int intLen = p_glsSQL.Count; for (int i = 0; i < intLen; i++) { log.Log2File(LogFilepath, LogNortitle + p_glsSQL[i].ToString()); } return(1); }
void logOut(string txtStr) { log.Log2File(strFileName, txtStr); }