public static int RunOracleNonQuery(string sql)
{
try
{
string user = CommonCLS.UserName;
string pwd = CommonCLS.PASSWORD;
int result;
SqlOracle sqlOrl = null;
sqlOrl = new SqlOracle("Data Source=" + CommonCLS.TNS + "; User Id=" + user + ";Password="******";");
result = sqlOrl.ExecuteNonquery(sql);
return(result);
}
catch (System.Exception ex)
{
return(0);
}
}
/// <summary>
/// 手动建立目的表
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static int CreateTBL(string strSql, string account, string pwd, string tns)
{
try
{
//string user = CommonCLS.UserName;
//string pwd = CommonCLS.PASSWORD;
int result;
SqlOracle sqlOrl = null;
sqlOrl = new SqlOracle("Data Source=" + tns + "; User Id=" + account + ";Password="******";");
result = sqlOrl.ExecuteNonquery(strSql);
return(result);
}
catch (System.Exception ex)
{
return(0);
}
}
