/// <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; } }
/// <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; } }
/// <summary> /// GetDetailByMasterID /// </summary> /// <param name="pintCycleOptionMasterID"></param> /// <returns></returns> /// <author>Trada</author> /// <date>Thursday, August 11 2005</date> public DataSet GetDetailByMasterID(int pintCycleOptionMasterID) { try { MTR_MRPCycleOptionDetailDS dsMTR_MRPCycleOptionDetail = new MTR_MRPCycleOptionDetailDS(); DataSet dstMTR_MRPCycleOptionDetail = new DataSet(); dstMTR_MRPCycleOptionDetail = dsMTR_MRPCycleOptionDetail.List(pintCycleOptionMasterID); return(dstMTR_MRPCycleOptionDetail); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }
/// <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); }