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