private void InsertProduct(ProductColumns col, SqlTransaction trans) { phyQuery.ProfJobSet.Type = EReportType.Physical; phyQuery.ProfJobSet.JobNo = ""; phyQuery.ProfJobSet.AreaNo = bomSet.AreaNo; phyQuery.ProfJobSet.ItemNo = col.Code; phyQuery.ProfJobSet.ExtendASTM = false; phyQuery.ProfJobSet.Select(trans); phyQuery.ProfJobSet.Fetch(); string jobNo = phyQuery.ProfJobSet.JobNo; if (string.IsNullOrWhiteSpace(jobNo) == false) { phyMainSet.RecNo = jobNo; phyMainSet.ReportApproval = EReportApproval.None; phyMainSet.AreaNo = EReportArea.None; phyMainSet.ProductNo = ""; phyMainSet.From = ""; phyMainSet.To = ""; phyMainSet.Select(trans); if (phyMainSet.Empty == true) { phyQuery.Insert(trans); } } productSet.BomNo = bomSet.RecNo; productSet.Valid = false; productSet.AreaNo = bomSet.AreaNo; productSet.Code = col.Code; productSet.JobNo = jobNo; productSet.Name = col.Name; productSet.Image = col.Image; productSet.Insert(trans); }
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); }
public void Add(ProductColumns col) { Products.Add(col); }