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