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