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;
}
private bool InsertMaterialItemData(string UserID, DataTable tempTable, OracleDBObj objDB, double PdpLoid)
{
bool ret = true;
string sqlDelete = "DELETE FROM MATERIALITEM WHERE PDPRODUCT = " + PdpLoid + "";
OracleDB.ExecNonQueryCmd(sqlDelete, objDB.zTrans);
for (int i = 0; i < tempTable.Rows.Count; i++)
{
MaterialItemDAL miDAL = new MaterialItemDAL();
miDAL.PDPRODUCT = PdpLoid;
miDAL.PRODUCT = Convert.ToDouble(tempTable.Rows[i]["MTRLOID"]);
miDAL.ALLQTY = Convert.ToDouble(tempTable.Rows[i]["ALLQTY"]);
miDAL.USEQTY = Convert.ToDouble(tempTable.Rows[i]["USEQTY"]);
miDAL.WASTEQTYMAT = Convert.ToDouble(tempTable.Rows[i]["WASTEQTYMAT"]);
miDAL.WASTEQTYMAN = Convert.ToDouble(tempTable.Rows[i]["WASTEQTYMAN"]);
miDAL.RETURNQTY = Convert.ToDouble(tempTable.Rows[i]["RETURNQTY"]);
miDAL.CHANGEQTY = Convert.ToDouble(tempTable.Rows[i]["CHANGEQTY"]);
miDAL.UNIT = Convert.ToDouble(tempTable.Rows[i]["ULOID"]);
miDAL.ACTIVE = tempTable.Rows[i]["ACTIVE"].ToString();
miDAL.REMARK = tempTable.Rows[i]["REMARK"].ToString();
miDAL.YIELDMAT = Convert.ToDouble(tempTable.Rows[i]["YIELDMAT"]);
miDAL.YIELDMAM = Convert.ToDouble(tempTable.Rows[i]["YIELDMAM"]);
miDAL.PGROUP = tempTable.Rows[i]["PGROUP"].ToString();
ret = miDAL.InsertCurrentData(UserID, objDB.zTrans);
}
return ret;
}
private bool UpdateMaterial(string UserID, DataTable tempTable, OracleDBObj objDB, double PdpLoid)
{
bool ret = true;
string sqlDelete = "DELETE FROM MATERIALITEM WHERE PDPRODUCT = " + PdpLoid + "";
OracleDB.ExecNonQueryCmd(sqlDelete, objDB.zTrans);
double mtrLoid = 0;
for (int i = 0; i < tempTable.Rows.Count; i++)
{
if (Convert.ToDouble(tempTable.Rows[i]["MTRLOID"])!=mtrLoid)
{
MaterialItemDAL miDAL = new MaterialItemDAL();
miDAL.PDPRODUCT = PdpLoid;
miDAL.PRODUCT = Convert.ToDouble(tempTable.Rows[i]["MTRLOID"]);
mtrLoid = Convert.ToDouble(tempTable.Rows[i]["MTRLOID"]);
if (tempTable.Rows[i]["ALLQTY"].ToString() == "" || tempTable.Rows[i]["ALLQTY"] == null)
miDAL.ALLQTY = 0;
else
miDAL.ALLQTY = Convert.ToDouble(tempTable.Rows[i]["ALLQTY"]);
miDAL.USEQTY = Convert.ToDouble(tempTable.Rows[i]["USEQTY"]);
miDAL.WASTEQTYMAT = Convert.ToDouble(tempTable.Rows[i]["WASTEQTYMAT"]);
miDAL.WASTEQTYMAN = Convert.ToDouble(tempTable.Rows[i]["WASTEQTYMAN"]);
miDAL.RETURNQTY = Convert.ToDouble(tempTable.Rows[i]["RETURNQTY"]);
miDAL.CHANGEQTY = Convert.ToDouble(tempTable.Rows[i]["CHANGEQTY"]);
miDAL.UNIT = Convert.ToDouble(tempTable.Rows[i]["UNIT"]);
if (tempTable.Rows[i]["ACTIVE"].ToString() == "" || tempTable.Rows[i]["ACTIVE"] == null)
miDAL.ACTIVE = "1";
else
miDAL.ACTIVE = tempTable.Rows[i]["ACTIVE"].ToString();
miDAL.REMARK = tempTable.Rows[i]["REMARK"].ToString();
miDAL.YIELDMAT = Convert.ToDouble(tempTable.Rows[i]["YIELDMAT"]);
miDAL.YIELDMAM = Convert.ToDouble(tempTable.Rows[i]["YIELDMAM"]);
miDAL.PGROUP = tempTable.Rows[i]["PGROUP"].ToString();
ret = miDAL.InsertCurrentData(UserID, objDB.zTrans);
if (ret == false)
{
_error = miDAL.ErrorMessage;
return false;
}
}
}
return true;
}
