public object GetCyclerMasterObject(int pintMasterID) { PRO_DCOptionMasterDS dsOption = new PRO_DCOptionMasterDS(); DataRow drowData = dsOption.GetDCOptionMaster(pintMasterID); PRO_DCOptionMasterVO voOption = new PRO_DCOptionMasterVO(); try { voOption.DCOptionMasterID = Convert.ToInt32(drowData[PRO_DCOptionMasterTable.DCOPTIONMASTERID_FLD]); } catch {} try { voOption.AsOfDate = Convert.ToDateTime(drowData[PRO_DCOptionMasterTable.ASOFDATE_FLD]); } catch {} try { voOption.UseCacheAsBegin = Convert.ToBoolean(drowData[PRO_DCOptionMasterTable.USECACHE_ASBEGIN_FLD]); } catch {} voOption.CCNID = Convert.ToInt32(drowData[PRO_DCOptionMasterTable.CCNID_FLD]); try { voOption.LastUpdate = Convert.ToDateTime(drowData[PRO_DCOptionMasterTable.LASTUPDATE_FLD]); } catch {} try { voOption.PlanHorizon = Convert.ToInt32(drowData[PRO_DCOptionMasterTable.PLANHORIZON_FLD]); } catch {} try { voOption.PlanningPeriod = Convert.ToDateTime(drowData[PRO_DCOptionMasterTable.PLANNINGPERIOD_FLD]); } catch {} try { voOption.Version = Convert.ToInt32(drowData[PRO_DCOptionMasterTable.VERSION_FLD]); } catch {} return(voOption); }
public void UpdateOver(DataTable pdtbData, DataTable pdtbOverData, ArrayList parrResultMasterID, StringBuilder psbResultMasterID, object pobjCycle) { PRO_DCPResultDetailDS dsDCPDetail = new PRO_DCPResultDetailDS(); PRO_DCOptionMasterVO voCycle = (PRO_DCOptionMasterVO)pobjCycle; string strResultMasterIDs = "0"; #region check result master id in order to delete master data // get the list of master id which will not be deleted DataTable dtbNotDeleteID = dsDCPDetail.GetNotDeleteMasterID(psbResultMasterID.ToString(), voCycle.DCOptionMasterID); foreach (DataRow drowData in dtbNotDeleteID.Rows) { parrResultMasterID.Remove(drowData[PRO_DCPResultMasterTable.DCPRESULTMASTERID_FLD].ToString()); } foreach (string strMasterID in parrResultMasterID) { if (pdtbData.Select(PRO_DCPResultDetailTable.DCPRESULTMASTERID_FLD + "=" + strMasterID).Length == 0 && pdtbOverData.Select(PRO_DCPResultDetailTable.DCPRESULTMASTERID_FLD + "=" + strMasterID).Length == 0) { strResultMasterIDs += "," + strMasterID; } } #endregion StringBuilder sbOverID = new StringBuilder(); foreach (DataRow drowOver in pdtbOverData.Rows) { sbOverID.Append(drowOver[PRO_DCPResultDetailTable.DCPRESULTDETAILID_FLD].ToString()).Append(","); } sbOverID.Append("0"); // avoid exception // delete over data first dsDCPDetail.DeleteOverData(psbResultMasterID.ToString(), strResultMasterIDs, sbOverID.ToString()); // update quantity of over item dsDCPDetail.UpdateOver(pdtbOverData); // update new data to dcp table DataSet dstData = new DataSet(); dstData.Tables.Add(pdtbData); dsDCPDetail.UpdateDataSet(dstData); }