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() }); }