public bool DeleteData(ArrayList arrLOID)
{
bool ret = true;
OracleDBObj objDB = new OracleDBObj();
objDB.CreateConnection();
objDB.CreateTransaction();
try
{
foreach (double LOID in arrLOID)
{
SupplierDAL oDAL = new SupplierDAL();
oDAL.GetDataByLOID(LOID, objDB.zTrans);
oDAL.DeleteCurrentData(objDB.zTrans);
}
objDB.zTrans.Commit();
ret = true;
}
catch (Exception ex)
{
objDB.zTrans.Rollback();
_error = ex.Message;
ret = false;
}
objDB.CloseConnection();
return ret;
}
public bool UpdateData(string UserID, SupplierData supData)
{
Boolean ret = true;
SupplierDAL oDAL = new SupplierDAL();
oDAL.OnDB = false;
oDAL.GetDataByLOID(Convert.ToDouble(supData.LOID == "" ? "0" : supData.LOID), null);
SetDataToDAL(oDAL, supData);
if (oDAL.OnDB)
{
ret = oDAL.UpdateCurrentData(UserID, null);
}
else
{
ret = oDAL.InsertCurrentData(UserID, null);
}
if (ret == false)
_error = oDAL.ErrorMessage;
return ret;
}
//public bool NewRequisition(string userID, ProductReturnData data)
//{
// bool ret = true;
// OracleDBObj obj = new OracleDBObj();
// obj.CreateConnection();
// obj.CreateTransaction();
// try
// {
// DALObj.CODE = data.CODE;
// DALObj.DELIVERYDATE = data.DELIVERYDATE;
// DALObj.TYPE = data.TYPE;
// DALObj.CARNO = data.CARNO;
// DALObj.DELIVERYNAME = data.DELIVERYNAME;
// ret = DALObj.InsertCurrentData(userID, obj.zTrans);
// _LOID = DALObj.LOID;
// if (!ret)
// {
// throw new ApplicationException(DALObj.ErrorMessage);
// }
// obj.zTrans.Commit();
// obj.CloseConnection();
// }
// catch (Exception ex)
// {
// obj.zTrans.Rollback();
// obj.CloseConnection();
// ret = false;
// _error = ex.Message;
// }
// return ret;
//}
public SupplierData GetSupplierData(double supplier)
{
SupplierDAL sDAL = new SupplierDAL();
sDAL.GetDataByLOID(supplier, null);
SupplierData data = new SupplierData();
data.SUPPLIERNAME = sDAL.SUPPLIERNAME;
data.CNAME = sDAL.CNAME;
data.CLASTNAME = sDAL.CLASTNAME;
data.CADDRESS = sDAL.CADDRESS;
data.CTEL = sDAL.CTEL;
data.CFAX = sDAL.CFAX;
//return DALObj.GetSupplierData(supplier);
return data;
}
