public void Add(PartColumns col)
{
Parts.Add(col);
}
private bool ExtractProduct(Worksheet sheet)
{
SearchOptions options = new SearchOptions();
options.MatchEntireCellContents = true;
options.SearchIn = SearchIn.Values;
// Find Cells in spreadsheet by 'Item Number'
IEnumerable <Cell> productCells = sheet.Search("Item Number", options);
if (productCells == null)
{
return(false);
}
// Find Cells in spreadsheet by 'PartName'
IEnumerable <Cell> partCells = sheet.Search("PartName", options);
if (partCells == null)
{
return(false);
}
int i = 0;
foreach (Cell c1 in productCells)
{
ProductColumns productRec = new ProductColumns();
// Read Item Number
productRec.Code = sheet.Cells[c1.RowIndex, c1.ColumnIndex + 1].Value.ToString().Trim();
// Read Product Description
productRec.Name = sheet.Cells[c1.RowIndex + 1, c1.ColumnIndex + 1].Value.ToString().Trim();
// Read Product Picture
productRec.Image = new Bitmap(sheet.Pictures[i].Image.NativeImage,
new Size(300, (int)(sheet.Pictures[i].Image.NativeImage.Height * (300.0 / sheet.Pictures[i].Image.NativeImage.Width))));
int j = 1;
Cell c2 = partCells.ElementAt <Cell>(i);
while (j > 0)
{
PartColumns partRec = new PartColumns();
// Read PartName
partRec.Name = sheet.Cells[c2.RowIndex + j, c2.ColumnIndex].Value.ToString().Trim();
// Read Materials
partRec.MaterialNo = sheet.Cells[c2.RowIndex + j, c2.ColumnIndex + 1].Value.ToString().Trim();
// Read Materiral Name
partRec.MaterialName = sheet.Cells[c2.RowIndex + j, c2.ColumnIndex + 2].Value.ToString().Trim();
if (string.IsNullOrWhiteSpace(partRec.Name) == false)
{
productRec.Add(partRec);
j++;
}
else
{
j = 0;
}
}
bomRec.Add(productRec);
i++;
}
return(true);
}
private bool InsertPart(PartColumns col, SqlTransaction trans)
{
string jobNo = "";
string extendJobNo = "";
cheQuery.ProfJobSet.Type = EReportType.Chemical;
cheQuery.ProfJobSet.JobNo = "";
cheQuery.ProfJobSet.AreaNo = bomSet.AreaNo;
cheQuery.ProfJobSet.ItemNo = col.MaterialNo;
cheQuery.ProfJobSet.ExtendASTM = true;
cheQuery.ProfJobSet.Select(trans);
int rowCount = cheQuery.ProfJobSet.RowCount;
if (rowCount > 0)
{
cheQuery.ProfJobSet.Fetch(0);
jobNo = cheQuery.ProfJobSet.JobNo;
if (string.IsNullOrWhiteSpace(jobNo) == false)
{
cheMainSet.RecNo = jobNo;
cheMainSet.ReportApproval = EReportApproval.None;
cheMainSet.AreaNo = EReportArea.None;
cheMainSet.From = "";
cheMainSet.To = "";
cheMainSet.MaterialNo = "";
cheMainSet.Select(trans);
if (cheMainSet.Empty == true)
{
if (rowCount > 1)
{
// Find jobno for additional test results
for (int i = 1; i < cheQuery.ProfJobSet.RowCount; i++)
{
cheQuery.ProfJobSet.Fetch(i);
if (cheQuery.ProfJobSet.Image == null)
{
extendJobNo = cheQuery.ProfJobSet.JobNo;
break;
}
}
cheQuery.ProfJobSet.Fetch(0);
}
cheQuery.Insert(extendJobNo, trans);
}
}
}
partSet.ProductNo = productSet.RecNo;
partSet.JobNo = jobNo;
partSet.MaterialNo = col.MaterialNo;
partSet.Name = col.Name;
partSet.MaterialName = col.MaterialName;
partSet.Insert(trans);
return((string.IsNullOrWhiteSpace(jobNo) == false) ? true : false);
}