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);
}
