public bool DeleteData(ArrayList arrLOID)
{
bool ret = true;
OracleDBObj objDB = new OracleDBObj();
objDB.CreateConnection();
objDB.CreateTransaction();
try
{
foreach (double PDPLOID in arrLOID)
{
//Delete MaterialItem
MaterialItemDAL oDAL = new MaterialItemDAL();
double mtloid = GetMetrialItemLoid(PDPLOID);
oDAL.GetDataByLOID(mtloid, objDB.zTrans);
oDAL.DeleteCurrentData(objDB.zTrans);
//Delete PdProduct
PDProductDAL pDAL = new PDProductDAL();
pDAL.GetDataByLOID(PDPLOID, objDB.zTrans);
pDAL.DeleteCurrentData(objDB.zTrans);
//Delete PdOrder
PDOrderDAL poDAL = new PDOrderDAL();
double poloid = GetPdOrderLoid(PDPLOID);
poDAL.GetDataByLOID(poloid, objDB.zTrans);
poDAL.DeleteCurrentData(objDB.zTrans);
}
objDB.zTrans.Commit();
ret = true;
}
catch (Exception ex)
{
objDB.zTrans.Rollback();
_error = ex.Message;
ret = false;
}
objDB.CloseConnection();
return ret;
}
private bool UpdatePackageLost(string UserID, DataTable tempTable, OracleDBObj objDB, double PdpLoid)
{
bool ret = true;
double MILoid = 0;
for (int i = 0; i < tempTable.Rows.Count; i++)
{
MaterialItemDAL miDAL = new MaterialItemDAL();
DataTable dtt = GetMILoid(PdpLoid, Convert.ToDouble(tempTable.Rows[i]["MTRLOID"]));
if (dtt.Rows.Count > 0)
MILoid = Convert.ToDouble(dtt.Rows[0]["LOID"]); miDAL.WASTEQTYMAT = Convert.ToDouble(tempTable.Rows[i]["WASTEQTYMAT"]);
miDAL.GetDataByLOID(MILoid, null);
miDAL.RETURNQTY = Convert.ToDouble(tempTable.Rows[i]["RETURNQTY"]);
miDAL.CHANGEQTY = Convert.ToDouble(tempTable.Rows[i]["CHANGEQTY"]);
miDAL.REMARK = tempTable.Rows[i]["REMARK"].ToString();
miDAL.WASTEQTYMAT = Convert.ToDouble(tempTable.Rows[i]["WASTEQTYMAT"]);
miDAL.YIELDMAT = Convert.ToDouble(tempTable.Rows[i]["YIELDMAT"]);
ret = miDAL.UpdateCurrentData(UserID, objDB.zTrans);
if (ret == false)
{
_error = miDAL.ErrorMessage;
return false;
}
}
return true;
}
