コード例 #1
0
        /// <summary>
        /// UpdateMasterAndDetail
        /// </summary>
        /// <param name="pdstDetailData"></param>
        /// <param name="pobjMasterData"></param>
        /// <author>Trada</author>
        /// <date>Friday, August 12 2005</date>

        public void UpdateMasterAndDetail(DataSet pdstDetailData, object pobjMasterData)
        {
            try
            {
                //Update Master
                MTR_MRPCycleOptionMasterVO objObject = (MTR_MRPCycleOptionMasterVO)pobjMasterData;
                MTR_MRPCycleOptionMasterDS dsMTR_MRPCycleOptionMaster = new MTR_MRPCycleOptionMasterDS();
                dsMTR_MRPCycleOptionMaster.Update(pobjMasterData);
                //Update Detail
                foreach (DataRow drow in pdstDetailData.Tables[0].Rows)
                {
                    if (drow.RowState == DataRowState.Added)
                    {
                        drow[MTR_MRPCycleOptionDetailTable.MRPCYCLEOPTIONMASTERID_FLD] = objObject.MRPCycleOptionMasterID;
                    }
                }
                MTR_MRPCycleOptionDetailDS dsMTR_MRPCycleOptionDetail = new MTR_MRPCycleOptionDetailDS();
                dsMTR_MRPCycleOptionDetail.UpdateDataSet(pdstDetailData);
            }
            catch (PCSDBException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
        /// <summary>
        /// Add
        /// </summary>
        /// <param name="pdstDetailData"></param>
        /// <param name="pobjMasterData"></param>
        /// <returns></returns>
        /// <author>Trada</author>
        /// <date>Thursday, August 11 2005</date>

        public int Add(DataSet pdstDetailData, object pobjMasterData)
        {
            try
            {
                //Add and Return ID
                MTR_MRPCycleOptionMasterDS dsMTR_MRPCycleOptionMaster = new MTR_MRPCycleOptionMasterDS();
                int pintMasterID = dsMTR_MRPCycleOptionMaster.AddAndReturnID(pobjMasterData);
                foreach (DataRow drow in pdstDetailData.Tables[0].Rows)
                {
                    drow[MTR_MRPCycleOptionDetailTable.MRPCYCLEOPTIONMASTERID_FLD] = pintMasterID;
                }
                //Update DataSet
                MTR_MRPCycleOptionDetailDS dsMTR_MRPCycleOptionDetail = new MTR_MRPCycleOptionDetailDS();
                dsMTR_MRPCycleOptionDetail.UpdateDataSet(pdstDetailData);
                return(pintMasterID);
            }
            catch (PCSDBException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #3
0
        /// <summary>
        /// GetCycleOptionMaster
        /// </summary>
        /// <param name="pintMasterID"></param>
        /// <returns></returns>
        /// <author>Trada</author>
        /// <date>Friday, August 12 2005</date>

        public DataTable GetCycleOptionMaster(int pintMasterID)
        {
            try
            {
                MTR_MRPCycleOptionMasterDS dsMTR_MRPCycleOptionMaster = new MTR_MRPCycleOptionMasterDS();
                return(dsMTR_MRPCycleOptionMaster.GetMRPCycleOptionMaster(pintMasterID));
            }
            catch (PCSDBException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #4
0
        /// <summary>
        /// DeleteCycleOptionMasterAndDetail
        /// </summary>
        /// <param name="pintCycleOptionMasterID"></param>
        /// <param name="pdstData"></param>
        /// <author>Trada</author>
        /// <date>Thursday, August 11 2005</date>

        public void DeleteCycleOptionMasterAndDetail(int pintCCNID, int pintCycleOptionMasterID, DataSet pdstData)
        {
            foreach (DataRow drow in pdstData.Tables[0].Rows)
            {
                if (drow.RowState != DataRowState.Deleted)
                {
                    drow.Delete();
                }
            }
            //Delete Detail
            MTR_MRPCycleOptionDetailDS dsMTR_MRPCycleOptionDetail = new MTR_MRPCycleOptionDetailDS();

            dsMTR_MRPCycleOptionDetail.UpdateDataSet(pdstData);
            //Delete MTR_CPO
            MTR_CPODS dsMTR_CPO = new MTR_CPODS();

            dsMTR_CPO.Delete(pintCCNID, pintCycleOptionMasterID);
            //Delete Master
            MTR_MRPCycleOptionMasterDS dsMTR_MRPCycleOptionMaster = new MTR_MRPCycleOptionMasterDS();

            dsMTR_MRPCycleOptionMaster.Delete(pintCycleOptionMasterID);
        }
コード例 #5
0
        public DateTime GetAsOfDate(int pintCycleID, bool pblnIsMPS)
        {
            MTR_MRPCycleOptionMasterDS dsMaster = new MTR_MRPCycleOptionMasterDS();

            return(dsMaster.GetAsOfDate(pintCycleID, pblnIsMPS));
        }