public DataTable GetPDReturnItemBlank()
{
CtrlDeliveryItemDAL itemDAL = new CtrlDeliveryItemDAL();
return DALObj.GetPDReturnItemListBlank();
}
public bool UpdateData(string userID, CtrlDeliveryData data)
{
bool ret = true;
if (ValidateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
//DALObj.CODE = data.CODE;
DALObj.CARNO = data.CARNO;
DALObj.DELIVERYDATE = data.DELIVERYDATE;
DALObj.DELIVERYNAME = data.DELIVERYNAME;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, obj.zTrans);
else
ret = DALObj.InsertCurrentData(userID, obj.zTrans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
CtrlDeliveryItemDAL itemDAL = new CtrlDeliveryItemDAL();
itemDAL.DeleteDataByCtrlDelivery(data.LOID, obj.zTrans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
CtrlDeliveryItemData item = (CtrlDeliveryItemData)data.ITEM[i];
itemDAL.BOXQTY = item.BOXQTY;
itemDAL.CADDRESS = item.CADDRESS;
itemDAL.CNAME = item.CNAME;
itemDAL.CONTACTNAME = item.CONTACTNAME;
itemDAL.CTEL = item.CTEL;
itemDAL.CTRLDELIVERY = DALObj.LOID;
itemDAL.REQUISITION = item.REQUISITION;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, obj.zTrans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
}
else
ret = false;
return ret;
}
public DataTable GetDeliveryItem(double ctrldelivery)
{
CtrlDeliveryItemDAL itemDAL = new CtrlDeliveryItemDAL();
return SearchDAL.GetDeliveryItemList(ctrldelivery);
}
public DataTable GetDeliveryItemBlank()
{
CtrlDeliveryItemDAL itemDAL = new CtrlDeliveryItemDAL();
return SearchDAL.GetDeliveryItemListBlank();
}
public bool DeleteData(ArrayList arrData)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
CtrlDeliveryItemDAL itemDAL = new CtrlDeliveryItemDAL();
for (int i = 0; i < arrData.Count; i++)
{
DALObj.GetDataByLOID(Convert.ToDouble(arrData[i]), obj.zTrans);
itemDAL.DeleteDataByCtrlDelivery(Convert.ToDouble(arrData[i]), obj.zTrans);
ret = DALObj.DeleteCurrentData(obj.zTrans);
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;
}