public static bool CheckOutStandingIssues(int warehouseID = 0) { Warehouse warehouse = new Warehouse(); warehouse.LoadAll(); string query = HCMIS.Repository.Queries.IssueDoc.SelectCheckOutStandingIssues(warehouseID, warehouse.RowCount, OrderStatus.Constant.ORDER_APPROVED, OrderStatus.Constant.ISSUED); IssueDoc issueDoc = new IssueDoc(); issueDoc.LoadFromRawSql(query); return(issueDoc.Getint("count") == 0); }