protected void ExportExcelUnitHourManual(DataTable RoomTable) { DataTable GeneralInfo = BusinessLogicBridge.DataStore.getGeneralConfig(); string filePath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); filePath = filePath + @"\" + GeneralInfo.Rows[0]["path_all_document"].ToString(); string pathname = ""; if (Directory.Exists(Path.Combine(filePath, "Report")) == false) { Directory.CreateDirectory(Path.Combine(filePath, "Report")); } ReportDocuments.waterHourSX PrintElectric = new DXWindowsApplication2.ReportDocuments.waterHourSX(); pathname = DXWindowsApplication2.MainForm.CombinePaths(Environment.GetFolderPath(Environment.SpecialFolder.Personal), GeneralInfo.Rows[0]["path_all_document"].ToString(), "Report", "WaterHour_" + DateTime.Now.ToString("yyyyMMdd") + ".xls"); PrintElectric.loopGenDataRow(RoomTable, lookUpEditBuilding.Text, lookUpEditRoomFrom.EditValue.To <int>(), lookUpEditRoomTo.EditValue.To <int>(), dateEditUnitHour.EditValue.To <DateTime>()); //PrintElectric.ExportToXls(pathname); PrintElectric.ShowPreview(); }
protected void ExportExcelUnitHourManual(DataTable RoomTable) { DataTable GeneralInfo = BusinessLogicBridge.DataStore.getGeneralConfig(); string filePath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); filePath = filePath + @"\" + GeneralInfo.Rows[0]["path_all_document"].ToString(); string pathname = ""; if (Directory.Exists(Path.Combine(filePath, "Report")) == false) { Directory.CreateDirectory(Path.Combine(filePath, "Report")); } ReportDocuments.waterHourSX PrintElectric = new DXWindowsApplication2.ReportDocuments.waterHourSX(); pathname = DXWindowsApplication2.MainForm.CombinePaths(Environment.GetFolderPath(Environment.SpecialFolder.Personal), GeneralInfo.Rows[0]["path_all_document"].ToString(), "Report", "WaterHour_" + DateTime.Now.ToString("yyyyMMdd") + ".xls"); PrintElectric.loopGenDataRow(RoomTable, lookUpEditBuilding.Text, lookUpEditRoomFrom.EditValue.To<int>(), lookUpEditRoomTo.EditValue.To<int>(), dateEditUnitHour.EditValue.To<DateTime>()); //PrintElectric.ExportToXls(pathname); PrintElectric.ShowPreview(); }