public static DataSet RunOracleByManager(string sql)
{
try
{
string user = CommonCLS.MangerUserName;
string pwd = CommonCLS.MangerPASSWORD;
DataSet result = new DataSet();
SqlOracle sqlOrl = null;
sqlOrl = new SqlOracle("Data Source=" + CommonCLS.TNS + "; User Id=" + user + ";Password="******";");
result = sqlOrl.GetDataSet(sql);
return(result);
}
catch (System.Exception ex)
{
return(null);
}
}
public static DateTime GetSysDate()
{
try
{
string user = CommonCLS.UserName;
string pwd = CommonCLS.PASSWORD;
DataSet result = new DataSet();
SqlOracle sqlOrl = null;
sqlOrl = new SqlOracle("Data Source=" + CommonCLS.TNS + "; User Id=" + user + ";Password="******";");
result = sqlOrl.GetDataSet("select to_char(sysdate,'YYYY/MM/DD HH:mi:SS') from dual");
if (result != null && result.Tables[0].Rows.Count > 0)
{
return(Convert.ToDateTime(result.Tables[0].Rows[0].ItemArray[0].ToString()));
}
else
{
return(Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/ss HH:MI:SS").Replace("-", "/")));
}
}
catch (System.Exception ex)
{
return(Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/ss HH:MI:SS").Replace("-", "/")));
}
}
