private string SelectDt(string MashineID) { string[] arrField = new string[1]; string[] arrValue = new string[1]; string rtstr = "error"; DataTable dt; try { string tablename = "sfcdata.barautbind"; OraDB oraDB = new OraDB(SQL_ora_server, SQL_ora_user, SQL_ora_pwd); if (oraDB.isConnect()) { arrField[0] = "BB01"; arrValue[0] = MashineID; DataSet s = oraDB.selectSQLwithOrder(tablename.ToUpper(), arrField, arrValue); dt = s.Tables[0]; if (dt.Rows.Count > 0) { rtstr = (string)dt.Rows[0]["BB01"] + ";" + (string)dt.Rows[0]["BB02"] + ";" + (string)dt.Rows[0]["BB03"] + ";" + (string)dt.Rows[0]["BB04"] + ";" + (string)dt.Rows[0]["BLUID"] + ";" + (string)dt.Rows[0]["BB06"] + ";" + (string)dt.Rows[0]["BB07"]; } } oraDB.disconnect(); } catch (Exception ex) { Log.Default.Error("Class1.SelectDt", ex.Message); } return(rtstr); }
/// <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> /// 返回Command 自己执行带参数的sql /// </summary> /// <param name="tsConnectId"></param> /// <returns></returns> public static OracleCommand GetOraCommand(String dbStr) { OraDB loOraDB = new OraDB(); loOraDB.Open(dbStr); return(loOraDB.GetOraCommand()); }
public XmlDocument DoExchange(XmlDocument request) { XmlDocument response = new XmlDocument(); Sys system = GetSystem(); try { if (Auth.VerifySignHttp(Context, ref request)) { response = OraDB.CallStoredProc(system.SystemId, ref request); } else { response = VerifySignFail(); Context.Response.StatusCode = 401; Context.Response.StatusDescription = "Unauthorized"; } } catch (Exception ex) { response = GetInternalErrorResponse(); logger.Error(ex, "Произошла ошибка!"); } finally { Auth.MakeSignHttp(Context, ref response); } return(response); }
/// <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); }
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; }
public static OracleCommand GetOraCommand(String tsConnectId) { OraDB loOraDB = new OraDB(); loOraDB.Open(); loOraDB.BeginTransaction(); return(loOraDB.GetOraCommand()); }
/// <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); }
private async Task <bool> Update_A_Row(DP6SQLROW row) { return(await((Func <Task <bool> >)(() => { return Task.Run(() => { try { string[] arrField = new string[1]; string[] arrValue = new string[1]; OraDB oraDB = new OraDB("qwer", "sfcabar", "sfcabar*168"); string tablename = "sfcdata.barautbind"; if (oraDB.isConnect()) { IsTCPConnect = true; arrField[0] = "SCBARCODE"; arrValue[0] = row.Bar; DataSet s = oraDB.selectSQL(tablename.ToUpper(), arrField, arrValue); SinglDt = s.Tables[0]; if (SinglDt.Rows.Count == 0) { MsgText = AddMessage("未查询到 " + row.Bar + " 信息"); oraDB.disconnect(); return false; } else { string[,] arrFieldAndNewValue = { { "BLDATE", ("to_date('" + row.BLDATE + "', 'yyyy/mm/dd hh24:mi:ss')").ToUpper() }, { "BLID", row.BLID }, { "BLNAME", row.BLNAME }, { "BLUID", row.BLUID }, { "BLMID", row.BLMID } }; string[,] arrFieldAndOldValue = { { "SCBARCODE", row.Bar } }; oraDB.updateSQL2(tablename.ToUpper(), arrFieldAndNewValue, arrFieldAndOldValue); s = oraDB.selectSQL(tablename.ToUpper(), arrField, arrValue); SinglDt = s.Tables[0]; oraDB.disconnect(); MsgText = AddMessage("条码 " + row.Bar + " 已更新"); return true; } } else { IsTCPConnect = false; MsgText = AddMessage("数据库链接失败"); return false; } } catch (Exception ex) { IsTCPConnect = false; MsgText = AddMessage("数据插入失败: " + ex.Message); Console.WriteLine(ex.Message); return false; } } ); }))()); }
public string TestConnectDb() { try { return(OraDB.DoTestQuery()); } catch (Exception ex) { logger.Error(ex, "Произошла ошибка!"); return(ex.Message); } }
private Sys GetSystem() { try { long requestSystemID = Convert.ToInt64(Context.Request.Headers.Get("eKassir-PointID")); if (requestSystemID == 0) { throw new Exception("Не указан http-заголовок eKassir-PointID"); } return(OraDB.GetSystem(requestSystemID)); } catch (Exception causeEx) { throw new Exception("Не удалось получить информацию", causeEx); } }
private bool LookforDt(string barcode) { bool r = false; string[] arrField = new string[1]; string[] arrValue = new string[1]; try { string tablename = "FLUKE_DATA"; OraDB oraDB = new OraDB("zdtdb", "ictdata", "ictdata*168"); if (oraDB.isConnect()) { arrField[0] = "BARCODE"; arrValue[0] = barcode; DataSet s = oraDB.selectSQL(tablename.ToUpper(), arrField, arrValue); DataTable SinglDt = s.Tables[0]; if (SinglDt.Rows.Count < BarcodeItemNum) { ModelPrint("条码 " + barcode + " 记录 " + SinglDt.Rows.Count.ToString() + " < " + BarcodeItemNum.ToString() + " 合法"); r = true; } else { ModelPrint("条码 " + barcode + " 记录 " + SinglDt.Rows.Count.ToString() + " >= " + BarcodeItemNum.ToString() + " 非法"); r = false; } } else { ModelPrint("数据库连接失败"); r = true; } oraDB.disconnect(); } catch (Exception ex) { ModelPrint(ex.Message); r = true; } return(r); }
private void button1_Click(object sender, EventArgs e) { MessageBox.Show("11111"); OraDB DB = new OraDB(); MessageBox.Show("22222"); DB.Connect(); MessageBox.Show("3333"); List <String> data = null; string sql = "select * from tab"; MessageBox.Show(sql); data = DB.GetQueryResults <string>(sql, delegate(OracleDataReader reader) { MessageBox.Show("---------"); string val = reader[0].ToString(); MessageBox.Show(val); System.Diagnostics.Debug.WriteLine(val); return(val); }); MessageBox.Show("--2222-------"); System.Diagnostics.Debug.WriteLine(data); MessageBox.Show("--3333-------"); clsClassfication cls = new clsClassfication(); MessageBox.Show("--4442-------"); cls.load("1"); cls.CATE_NAME = "AAAAAAAAAAAA"; MessageBox.Show("--5552-------"); cls.update("2222"); List <clsClassfication> lst = clsClassfication.getList("11", "", false); //cls.insert("22", "2"); MessageBox.Show("--2666-------"); }
/// <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:例子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 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> /// 返回Command 自己执行带参数的sql /// </summary> /// <param name="tsConnectId"></param> /// <returns></returns> public static OracleCommand GetOraCommand(String dbStr) { OraDB loOraDB = new OraDB(); loOraDB.Open(dbStr); return loOraDB.GetOraCommand(); }