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