public static int DelData(string id)
{
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.DelData(id);
return(result);
}
catch (System.Exception ex)
{
return(0);
}
}
public static int RunOracleNonQuery(string sql, byte[] bFile)
{
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.BLOBOPERATE(sql, bFile);
return(result);
}
catch (System.Exception ex)
{
return(0);
}
}
public static DataSet RunOracleSP(string storedProcName)
{
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.GetDataSetBySP(storedProcName);
return(result);
}
catch (System.Exception ex)
{
return(null);
}
}
/// <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);
}
}
/// <summary>
/// 自动建立目的表
/// </summary>
/// <param name="sql"></param>
/// <param name="tablename"></param>
/// <param name="iFLG"></param>
/// <param name="dtTable"></param>
/// <param name="strTableSpace"></param>
/// <returns></returns>
public static int CreateTBL(string sql, string tablename, int iFLG, DataTable dtTable, string strTableSpace, 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.CreateTable(sql, tablename, iFLG, dtTable, strTableSpace);
return(result);
}
catch (System.Exception ex)
{
return(0);
}
}
public static int RunOracleNonQuerySp(string storedProcName, OracleParameter[] parameters)
{
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.ExecuteNonqueryBySP(storedProcName, parameters);
return(result);
}
catch (System.Exception ex)
{
return(0);
}
}
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("-", "/")));
}
}
