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