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("-", "/"))); } }