/// <summary> /// 带事务执行SQL文:例子DataSet loginDS=sysConfig.exeusesql("Login.aspx.cs123",strsql,"DefaultSQL","dt"); /// </summary> /// <param name="sql">SQL文</param> /// <param name="connectID">连接取"DefaultSQL","Oracle","Sybase"等值</param> /// <returns></returns> public static bool ExeuseSQL(string[] sql) { bool result = true; try { OraDB conspy = new OraDB(); conspy.Open(); conspy.BeginTransaction(); try { for (int i = 0; i < sql.Length; i++) { conspy.ExecSqlTrans(sql[i]); } conspy.Commit(); } catch (Exception e) { String lsError = e.Message; conspy.Rollback(); result = false; } finally { conspy.Close(); } } catch (Exception e) { String lsError = e.Message; result = false; } return(result); }
/// <summary> /// 执行SQL文到DataSet:例子DataSet loginDS=sysConfig.exeusesql("Login.aspx.cs123",strsql,"DefaultSQL","dt"); /// </summary> /// <param name="sql">SQL文</param> /// <param name="connectID">连接取"DefaultSQL","Oracle","Sybase"等值</param> /// <returns></returns> public static int SelectSQL(string strFileName, string sql, ref DataSet ds, ref string ErrorInfo) { int iResult = -1; string strMyError = ""; DataSet tempds = new DataSet(); try { //查看日志设置级别 //if (sql.ToLower().StartsWith("select")) //{ //} //else //{ // if (strFileName.StartsWith("UserONline.aspx")) // { // } // else // { // DBlog(strFileName, connectID, sql);//打log // } //} OraDB conspy = new OraDB(); conspy.Open(); iResult = conspy.SelectDataToDataSet(tempds, sql, ref strMyError); ds = tempds.Copy(); conspy.Close(); } catch (Exception e) { //重新开始执行3次,如果失败就放弃 //for (int i = 0; i < 3; i++) //{ // try // { // OLEDB conspy = new OLEDB(connectID); // conspy.Open(); // iResult = conspy.SelectDataToDataSet(tempds, sql, ref strMyError); // conspy.Close(); // ds = tempds.Copy(); // break; // } // catch (Exception f) // { // ErrorInfo = f.Message;//设置错误信息 // } //} //DBErrorlog(strFileName, connectID, sql);//打log //DBErrorlog(strFileName, connectID, e.Message); //DBErrorlog(strFileName, "", "============================================================================================================"); } return(iResult); }
/// <summary> /// 执行SQL文 /// </summary> /// <param name="sql">SQL文</param> /// <param name="connectID">连接取"DefaultSQL","Oracle","Sybase"等值</param> /// <returns>返回结果,错误返回-1</returns> public static int ExecSQL(string strFileName, string sql, ref string ErrorInfo) { OraDB myol = new OraDB(); myol.Open(); int i = myol.ExecSQL(sql,ref ErrorInfo); myol.Close(); return i; }
public static int ExecSP(String SPName) { OraDB oledb = new OraDB(); oledb.Open(); int i = oledb.ExecSP(SPName); oledb.Close(); return i; }
public static int ExecSP(String SPName) { OraDB oledb = new OraDB(); oledb.Open(); int i = oledb.ExecSP(SPName); oledb.Close(); return(i); }
/// <summary> /// 执行SQL文 /// </summary> /// <param name="sql">SQL文</param> /// <param name="connectID">连接取"DefaultSQL","Oracle","Sybase"等值</param> /// <returns>返回结果,错误返回-1</returns> public static int ExecSQL(string strFileName, string sql, ref string ErrorInfo) { OraDB myol = new OraDB(); myol.Open(); int i = myol.ExecSQL(sql, ref ErrorInfo); myol.Close(); return(i); }
/// <summary> /// 执行SQL文到DataSet:例子DataSet loginDS=sysConfig.exeusesql("Login.aspx.cs123",strsql,"DefaultSQL","dt"); /// </summary> /// <param name="strFileName"></param> /// <param name="sql"></param> /// <param name="ds"></param> /// <param name="ErrorInfo"></param> /// <returns></returns> public static int SelectSQL(string strFileName, string sql, ref DataSet ds, ref string ErrorInfo) { int iResult = -1; string strMyError = ""; DataSet tempds = new DataSet(); OraDB conspy = new OraDB(); conspy.Open(); try { iResult = conspy.SelectDataToDataSet(tempds, sql, ref strMyError); ds = tempds.Copy(); } catch (Exception e) { throw e; } finally { conspy.Close(); } return(iResult); }
protected void Page_Load(object sender, EventArgs e) { string url = @"http://autoever.hyundai.net/Webservices/SSO/SitemapWS.asmx"; string enccode = Request.Params["Encode"]; string companycode = Request.Params["CompanyCode"]; string strHKMCENC_ID = "RIDS"; string param = "<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><GetPlainText xmlns=\"http://tempuri.org/\">" + "<strEncID>" + strHKMCENC_ID + "</strEncID>" + "<strCompanyCode>" + companycode + "</strCompanyCode>" + "<strEncText>" + enccode + "</strEncText>" + "</GetPlainText></soap:Body></soap:Envelope>"; System.Diagnostics.Debug.WriteLine("----------22"); ServerXMLHTTP srv = new ServerXMLHTTP(); srv.open("POST", url, false, null, null); srv.setRequestHeader("Content-Type", "text/xml; charset=utf-8"); srv.setRequestHeader("SOAPAction", "http://tempuri.org/GetPlainText"); srv.send(param); Response.Clear(); string __res__ = srv.responseText; bool isLogin = false; try{ int val1 = __res__.IndexOf("<GetPlainTextResult>"); int val2 = __res__.IndexOf("</GetPlainTextResult>"); if (val1 <= 0 || val2 <= 0) { return; } string result = __res__.Substring(val1, (val2 - val1)); string[] token = System.Text.RegularExpressions.Regex.Split(result, "___"); for (int i = 0; i < token.Length; i++) { string[] value = System.Text.RegularExpressions.Regex.Split(token[i], "\\|\\|"); Session[value[0]] = value[1]; if ("User_ID".EndsWith(value[0])) { //Session["USERID"] = value[1]; string user = value[1]; // 그리고 사번.. OraDB DB = new OraDB(); DB.Connect(); try { string user_name = ""; string dept_code = ""; string login_sql = "select * from tb_person where user_id = '" + user + "'"; string object_id = DB.GetQueryResult <string>(login_sql, delegate(OracleDataReader reader) { string val = reader[0].ToString(); user_name = reader[1].ToString(); dept_code = reader[3].ToString(); return(val); }); if (object_id == null || "".Equals(object_id)) { isLogin = false; } else { Session["USERID"] = object_id; Session["USERNAME"] = user_name; Session["DEPTCODE"] = dept_code; isLogin = true; } DB.Close(); } catch (Exception eee) { System.Diagnostics.Debug.WriteLine(eee.Message); isLogin = false; } finally { DB.Close(); } } /* * if ("Dept_Code".EndsWith(value[0])) * { * Session["DEPTCODE"] = value[1]; * } * * if ("User_Name".EndsWith(value[0])) * { * Session["USERNAME"] = value[1]; * } */ } }catch (Exception ex) { Response.Write(ex.Message); } if (isLogin == false) { Response.Clear(); string res = "<script>alert('Access Dinied....');</script>"; Response.Write(res); return; } Response.Clear(); string res1 = "<script>this.location.href='/extjs/top.html';</script>"; Response.Write(res1); return; }
/// <summary> /// 执行SQL文到DataSet:例子DataSet loginDS=sysConfig.exeusesql("Login.aspx.cs123",strsql,"DefaultSQL","dt"); /// </summary> /// <param name="strFileName"></param> /// <param name="sql"></param> /// <param name="ds"></param> /// <param name="ErrorInfo"></param> /// <returns></returns> public static int SelectSQL(string strFileName, string sql, ref DataSet ds, ref string ErrorInfo) { int iResult = -1; string strMyError = ""; DataSet tempds = new DataSet(); OraDB conspy = new OraDB(); conspy.Open(); try { iResult = conspy.SelectDataToDataSet(tempds, sql, ref strMyError); ds = tempds.Copy(); } catch (Exception e) { throw e; } finally { conspy.Close(); } return iResult; }
/// <summary> /// 带事务执行SQL文:例子DataSet loginDS=sysConfig.exeusesql("Login.aspx.cs123",strsql,"DefaultSQL","dt"); /// </summary> /// <param name="sql">SQL文</param> /// <param name="connectID">连接取"DefaultSQL","Oracle","Sybase"等值</param> /// <returns></returns> public static bool ExeuseSQL(string[] sql) { bool result = true; try { OraDB conspy = new OraDB(); conspy.Open(); conspy.BeginTransaction(); try { for (int i = 0; i < sql.Length; i++) { conspy.ExecSqlTrans(sql[i]); } conspy.Commit(); } catch (Exception e) { String lsError = e.Message; conspy.Rollback(); result = false; } finally { conspy.Close(); } } catch (Exception e) { String lsError = e.Message; result = false; } return result; }