public decimal GetTotalApprovedQuantityByItem(int orderId, int itemId, int itemUnitId, int modeId) { var query = HCMIS.Repository.Queries.Balance.SelectTotalApprovedQty( orderId,itemId, itemUnitId, modeId); var balance = new Balance(); balance.LoadFromRawSql(query); return balance.Getdecimal("TotalRequested"); }