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