コード例 #1
0
        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;
            }
        }
コード例 #2
0
        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);
            }
        }
コード例 #3
0
        //**************************************************************************
        ///    <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;
            }
        }