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