先佔個位置,後續會繼續更新
List<IqcDYCPartInfo> iqc= new List<IqcDYCPartInfo>();
ParallelOptions options = new ParallelOptions
{
MaxDegreeOfParallelism = 10 // 限制最多4个线程
};
var detail2 = new List<IqcDYCPartInfo>();
Parallel.ForEach(details, options, item =>
{//,xx_erp_check_f(PartNo,LotNo)
if(item != null)
{
try{
using (var conn1 = new OracleConnection(str))
{
conn1.Open(); // 显式打开连接(Dapper不会自动打开)
string cmd2 = "select xx_erp_check_f('" + item.PartNo + "','" + item.LotNo + "') as num from dual";
var qty = conn1.ExecuteScalar<int>(cmd2);
if (qty== 0)
{
detail2.Add(item);
}
}
}catch(Exception ex)
{
Console.WriteLine(ex);
}
}
});