protected void ExportExcelManual(DataTable RoomTable)
        {
            DataTable GeneralInfo = BusinessLogicBridge.DataStore.getGeneralConfig();
            string    filePath    = Environment.GetFolderPath(Environment.SpecialFolder.Personal);

            filePath = filePath + @"\" + GeneralInfo.Rows[0]["path_all_document"].ToString();

            ReportDocuments.waterAccumulate PrintElectric = new DXWindowsApplication2.ReportDocuments.waterAccumulate();

            if (Directory.Exists(Path.Combine(filePath, "Report")) == false)
            {
                Directory.CreateDirectory(Path.Combine(filePath, "Report"));
            }

            string pathname = DXWindowsApplication2.MainForm.CombinePaths(Environment.GetFolderPath(Environment.SpecialFolder.Personal), GeneralInfo.Rows[0]["path_all_document"].ToString(), "Report", "Water_" + DateTime.Now.ToString("yyyyMMdd") + ".pdf");

            // Building, roomFrom, roomTo, dateFrom, dateTo

            PrintElectric.loopGenDataRow(RoomTable, lookUpEditBuilding.Text, lookUpEditRoomFrom.Text, lookUpEditRoomTo.Text);

            //PrintElectric.ExportToXls(pathname);
            PrintElectric.ShowPreview();
        }
        protected void ExportExcelManual(DataTable RoomTable)
        {
            DataTable GeneralInfo   = BusinessLogicBridge.DataStore.getGeneralConfig();
            string filePath         = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
            filePath                = filePath + @"\" + GeneralInfo.Rows[0]["path_all_document"].ToString();

            ReportDocuments.waterAccumulate PrintElectric = new DXWindowsApplication2.ReportDocuments.waterAccumulate();

            if (Directory.Exists(Path.Combine(filePath, "Report")) == false)
            {
                Directory.CreateDirectory(Path.Combine(filePath, "Report"));
            }

            string pathname = DXWindowsApplication2.MainForm.CombinePaths(Environment.GetFolderPath(Environment.SpecialFolder.Personal), GeneralInfo.Rows[0]["path_all_document"].ToString(), "Report", "Water_" + DateTime.Now.ToString("yyyyMMdd") + ".pdf");

            // Building, roomFrom, roomTo, dateFrom, dateTo

            PrintElectric.loopGenDataRow(RoomTable, lookUpEditBuilding.Text, lookUpEditRoomFrom.Text, lookUpEditRoomTo.Text);

            //PrintElectric.ExportToXls(pathname);
            PrintElectric.ShowPreview();
        }