private Item readByPartNumberInList(BOMAccess bom, List <Item> list)
{
foreach (Item item in list)
{
if (item.PartNumber.Trim().ToLower() == bom.PartNumber.Trim().ToLower())
{
return(item);
}
}
return(null);
}
static public List <BOMAccess> readBySIF(SIF sif)
{
List <BOMAccess> recordset = new List <BOMAccess>();
DataRow[] table = readAll().Select("[Inquiry Number] = '"
+ sif.InquiryNumber + "' and Revision = '" + sif.Revision + "'");
for (int i = 0; i < table.Count(); i++)
{
BOMAccess bom = new BOMAccess();
bom.MaterialPosition = table[i]["Material Position"].ToString();
bom.PartNumber = table[i]["Part Number/Code ID"].ToString();
bom.Material = table[i]["Material/Assembly Description"].ToString();
bom.AssemblyDescription = table[i]["Assembly Description"].ToString();
bom.Status = table[i]["Status"].ToString();
bom.VendorQuoteEst = table[i]["Vendor Quote Est"].ToString();
bom.SalesComments = table[i]["Comments"].ToString();
bom.CapComAssm = table[i]["Cap Com Assm"].ToString();
bom.CommCode = table[i]["Component Lead Time"].ToString();
bom.Um = table[i]["UM"].ToString();
try
{
bom.PartCost = float.Parse(table[i]["Part Cost ($)"].ToString());
}
catch (Exception ex)
{
bom.PartCost = 0;
}
try
{
bom.NoRequired = float.Parse(table[i]["No Required"].ToString());
}
catch (Exception ex) {
bom.NoRequired = 0;
//bom.ImportComment = "BOM Line with incorrect field formatted: 'No Required', "
// + "please review it and export it agian if necessary. Error: " + ex.Message;
}
recordset.Add(bom);
}
return(recordset);
}
