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