How would i replace the foreach loop below with the result of the Select statement instead of the dRow?
// Filter on rows with correct SchFitDate
DataRow[] result = dTable.Select("Date05 = #" + SchFitDate + "#");
foreach(DataRow dRow in uAdpt.UD110Data.UD110A.Rows)
{
if (dRow[ColumnStr] == System.DBNull.Value)
{
Serial = dRow["ChildKey1"].ToString();
return Serial;
}
}
Are you trying to query the Epicor-native tables?
If that is the case, I suggest this. I used this for notification of Job Release:
if(ttJobHead.Any())
{
foreach(var jobheadrow in ttJobHead){
company = jobheadrow.Company;
jobNum= (jobheadrow.JobNum).ToString();
qty = jobheadrow.ProdQty;
foreach (var JobProdRow in (from JobProd_Row in Db.JobProd
where JobProd_Row.Company == company && JobProd_Row.JobNum == jobNum
select JobProd_Row))
{
orderNum = JobProdRow.OrderNum ;
orderLine = JobProdRow.OrderLine ;
foreach (var OrderDtlRow in (from OrderDtl_Row in Db.OrderDtl
where OrderDtl_Row.Company == company && OrderDtl_Row.OrderNum == orderNum && OrderDtl_Row.OrderLine == orderLine
select OrderDtl_Row))
{
projectId = (OrderDtlRow.ProjectID).ToString() ;
foreach (var OrderHedRow in (from OrderHed_Row in Db.OrderHed
where OrderHed_Row.Company == company && OrderHed_Row.OrderNum == orderNum
select OrderHed_Row))
{
custNum = OrderHedRow.CustNum;
foreach (var CustomerRow in (from Customer_Row in Db.Customer
where Customer_Row.Company == company && Customer_Row.CustNum == custNum
select Customer_Row))
{
customer = CustomerRow.Name;
siteId = (CustomerRow["SiteID_c"]).ToString();
}
}
}
}
}
}
And if you want to iterate the tt tables, then this:
This was my result being the data after the select statement
DataTable dTable = uAdpt.UD110Data.UD110A;
DataRow[] result = dTable.Select("Date05 = #" + SchFitDate + "#");
for(int i = 0; i <result.Length; i++)
{
if (result[i][ColumnStr] == System.DBNull.Value)
{
Serial = result[i]["ChildKey1"].ToString();
return Serial;
}
}