public DataSet GetReturnGoodsDetail(int pintReturnedGoodsID)
{
SO_ReturnedGoodsDetailDS objSO_ReturnedGoodsDetailDS = new SO_ReturnedGoodsDetailDS();
DataSet dsData = objSO_ReturnedGoodsDetailDS.ListReturnedGoodsDetail(pintReturnedGoodsID);
return(dsData);
}
public void DeleteReturnedGoods(int pintReturnedGoodsMasterID)
{
//1. Variable
int enm_InspStatus = 8;
int constOldTranTypeID = (new MST_TranTypeDS()).GetTranTypeID(TransactionType.RETURN_GOODS_RECEIVE);
SO_ReturnedGoodsDetailDS objSO_ReturnedGoodsDetailDS = new SO_ReturnedGoodsDetailDS();
SO_ReturnedGoodsMasterDS objSO_ReturnedGoodsMasterDS = new SO_ReturnedGoodsMasterDS();
//2. Get ReturnedGoodsMaster
SO_ReturnedGoodsMasterVO voRuturnGoodsMaster = new SO_ReturnedGoodsMasterVO();
voRuturnGoodsMaster = (SO_ReturnedGoodsMasterVO)objSO_ReturnedGoodsMasterDS.GetObjectVO(pintReturnedGoodsMasterID);
//Get List ReturnGoodsDetail by ReturnGoodsMasterID
DataSet dsRGD = objSO_ReturnedGoodsDetailDS.ListReturnedGoodsDetail(pintReturnedGoodsMasterID);
foreach (DataRow row in dsRGD.Tables[0].Rows)
{
//Update Inventory
int MaslocID = (int)row[SO_ReturnedGoodsDetailTable.MASTERLOCATIONID_FLD];
int locID = (int)row[SO_ReturnedGoodsDetailTable.LOCATIONID_FLD];
int BinID = (int)row[SO_ReturnedGoodsDetailTable.BINID_FLD];
int ProductID = (int)row[SO_ReturnedGoodsDetailTable.PRODUCTID_FLD];
decimal decQuantityReceipt = (decimal)row[SO_ReturnedGoodsDetailTable.RECEIVEQUANTITY_FLD];
new InventoryUtilsBO().UpdateSubtractOHQuantity(voRuturnGoodsMaster.CCNID,
MaslocID,
locID,
BinID,
ProductID,
decQuantityReceipt,
string.Empty,
string.Empty);
}
// Update TransactionHistory
new MST_TransactionHistoryDS().UpdateTranType(voRuturnGoodsMaster.ReturnedGoodsMasterID, constOldTranTypeID, (int)TransactionTypeEnum.DeleteTransaction, enm_InspStatus);
//delete the detail first
objSO_ReturnedGoodsDetailDS.DeleteAllReturnedGoodsDetail(pintReturnedGoodsMasterID);
//delete the master later
objSO_ReturnedGoodsMasterDS.Delete(pintReturnedGoodsMasterID);
}