public static DataTable GetReceiptStatusList()
        {
            string query =
                HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList();
            Receipt receipt = new Receipt();

            receipt.LoadFromRawSql(query);
            System.Data.DataTable tbl = receipt.DataTable;
            query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList2();
            receipt.FlushData();
            receipt.LoadFromRawSql(query);

            tbl.Merge(receipt.DataTable);
            return(tbl);
        }
        public static DataTable GetReceiptStatusList()
        {
            string query =
                HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList();
            Receipt receipt = new Receipt();
            receipt.LoadFromRawSql(query);
            System.Data.DataTable tbl = receipt.DataTable;
            query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList2();
            receipt.FlushData();
            receipt.LoadFromRawSql(query);

            tbl.Merge(receipt.DataTable);
            return tbl;
        }