public static void BatchUpdateRegisterRefundStatus(int refundSysNo, RMARefundStatus rmaRefundStatus)
{
DataCommand command = DataCommandManager.GetDataCommand("BatchUpdateRMARegisterRefundStatus");
command.SetParameterValue("@RefundSysNo", refundSysNo);
command.SetParameterValue("@RefundStatus", rmaRefundStatus);
command.ExecuteNonQuery();
}
public HistoryRefundAmount GetRefundCashAmtBySOSysNo(int soSysNo, RMARefundStatus Status)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetRefundCashAmtBySOSysNo");
dc.SetParameterValue("@SOSysNo", soSysNo);
dc.SetParameterValue("@Status", Status);
HistoryRefundAmount result = dc.ExecuteEntity <HistoryRefundAmount>();
return(result);
}
public HistoryRefundAmount GetRefundShipPriceBySOSysNoAndOtherStockID(int soSysNo, RMARefundStatus Status, string stockID)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetRefundShipPriceBySOSysNoAndOtherWareHouseNumber");
dc.SetParameterValue("@SOSysNo", soSysNo);
dc.SetParameterValue("@Status", Status);
dc.SetParameterValue("@InvoiceLocation", stockID);
HistoryRefundAmount result = dc.ExecuteEntity <HistoryRefundAmount>();
return(result);
}
public HistoryRefundAmount GetRefundShipPriceBySOSysNoAndStockID(int soSysNo, RMARefundStatus Status, string stockID)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetRefundShipPriceBySOSysNoAndWareHouseNumber");
dc.SetParameterValue("@SOSysNo", soSysNo);
dc.SetParameterValue("@Status", (int)Status);
dc.SetParameterValue("@InvoiceLocation", stockID);
object tmp = dc.ExecuteScalar();
return(new HistoryRefundAmount()
{
TotalShipPriceAmt = tmp == null ? 0m : tmp.ToDecimal()
});
}
