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();
DataTable MeterInfoDT = BusinessLogicBridge.DataStore.getEMeterById(RoomTable.Rows[0]["current_electricity_id"].To <int>());
string pathname = "";
if (Directory.Exists(Path.Combine(filePath, "Report")) == false)
{
Directory.CreateDirectory(Path.Combine(filePath, "Report"));
}
if (MeterInfoDT.Rows[0]["meter_models"].ToString().Contains("SX") == true)
{
ReportDocuments.electricHourSX PrintElectric = new DXWindowsApplication2.ReportDocuments.electricHourSX();
pathname = DXWindowsApplication2.MainForm.CombinePaths(Environment.GetFolderPath(Environment.SpecialFolder.Personal), GeneralInfo.Rows[0]["path_all_document"].ToString(), "Report", "ElectricHourSX_" + 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();
}
else
{
ReportDocuments.electricHourMX PrintElectric = new DXWindowsApplication2.ReportDocuments.electricHourMX();
pathname = DXWindowsApplication2.MainForm.CombinePaths(Environment.GetFolderPath(Environment.SpecialFolder.Personal), GeneralInfo.Rows[0]["path_all_document"].ToString(), "Report", "ElectricHourMX_" + 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();
}
// Building, roomFrom, roomTo, dateFrom, dateTo
}
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();
DataTable MeterInfoDT = BusinessLogicBridge.DataStore.getEMeterById(RoomTable.Rows[0]["current_electricity_id"].To<int>());
string pathname = "";
if (Directory.Exists(Path.Combine(filePath, "Report")) == false)
{
Directory.CreateDirectory(Path.Combine(filePath, "Report"));
}
if (MeterInfoDT.Rows[0]["meter_models"].ToString().Contains("SX") == true)
{
ReportDocuments.electricHourSX PrintElectric = new DXWindowsApplication2.ReportDocuments.electricHourSX();
pathname = DXWindowsApplication2.MainForm.CombinePaths(Environment.GetFolderPath(Environment.SpecialFolder.Personal), GeneralInfo.Rows[0]["path_all_document"].ToString(), "Report", "ElectricHourSX_" + 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();
}
else {
ReportDocuments.electricHourMX PrintElectric = new DXWindowsApplication2.ReportDocuments.electricHourMX();
pathname = DXWindowsApplication2.MainForm.CombinePaths(Environment.GetFolderPath(Environment.SpecialFolder.Personal), GeneralInfo.Rows[0]["path_all_document"].ToString(), "Report", "ElectricHourMX_" + 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();
}
// Building, roomFrom, roomTo, dateFrom, dateTo
}
