public void UpdateAll(DataSet dstData, object pobjProduct) { // TODO: Add BomBO.UpdateDataSet implementation try { //update dataset BOM ITM_BOMDS dsBOM = new ITM_BOMDS(); DataSet dstBOM = new DataSet(); dstBOM.Tables.Add(dstData.Tables[ITM_BOMTable.TABLE_NAME].Copy()); dsBOM.UpdateDataSet(dstBOM); //update dataset Hierarchy DataSet dstHierarchy = new DataSet(); dstHierarchy.Tables.Add(dstData.Tables[ITM_HierarchyTable.TABLE_NAME].Copy()); ITM_HierarchyDS dsHierarchyDS = new ITM_HierarchyDS(); dsHierarchyDS.UpdateDataSet(dstData); //update Product new ITM_ProductDS().UpdateForBom(pobjProduct); dstData.AcceptChanges(); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public ArrayList CheckBussinessForBOM(DataTable pdtbComponent, int pintProductID) { try { ArrayList arrReturn = new ArrayList(); ITM_HierarchyDS dsHierarchy = new ITM_HierarchyDS(); DataTable dtbParent = dsHierarchy.ListParentOfProduct(pintProductID); dsHierarchy = null; //compare to find a wrong component for (int i = 0; i < pdtbComponent.Rows.Count; i++) { if (pdtbComponent.Rows[i].RowState != DataRowState.Deleted) { foreach (DataRow drow in dtbParent.Rows) { if (pdtbComponent.Rows[i][ITM_BOMTable.COMPONENTID_FLD].ToString().Trim() == drow[0].ToString().Trim()) { arrReturn.Add(pdtbComponent.Rows[i][ITM_BOMTable.COMPONENTID_FLD].ToString().Trim() + ";" + i.ToString()); } } } } return(arrReturn); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
//************************************************************************** /// <Description> /// add a new Product Item into database and return its new ID /// </Description> /// <Inputs> /// /// </Inputs> /// <Outputs> /// /// </Outputs> /// <Returns> /// /// </Returns> /// <Authors> /// THIENHD /// </Authors> /// <History> /// 15-Dec-2004 /// </History> /// <Notes> /// </Notes> //************************************************************************** public int AddAndReturnID(object pObjectDetail, int pintCopyFromProductID) { // TODO: Add ProductItemInfoBO.Add implementation try { if (ValidateBusiness(pObjectDetail)) { ITM_ProductDS objITM_ProductDS = new ITM_ProductDS(); int intNewlyAddedProductID = objITM_ProductDS.AddAndReturnID(pObjectDetail); if (pintCopyFromProductID > 0) { //we have to copy its BOM, routing, and hearachy //1.Copy from BOM ITM_BOMDS dsITM_BOMDS = new ITM_BOMDS(); dsITM_BOMDS.CopyBOM(pintCopyFromProductID, intNewlyAddedProductID); //2.Copy from Routing ITM_RoutingDS dsITM_RoutingDS = new ITM_RoutingDS(); dsITM_RoutingDS.CopyRouting(pintCopyFromProductID, intNewlyAddedProductID); //3.Copy hearachy ITM_HierarchyDS dsITM_HierarchyDS = new ITM_HierarchyDS(); dsITM_HierarchyDS.CopyHierarchy(pintCopyFromProductID, intNewlyAddedProductID); } return(intNewlyAddedProductID); } else { return(-1); } } catch (PCSException ex) { throw ex; } catch (Exception ex) { throw ex; } }