public static void export_Excel(string tenFile, GridView view, bool exportText = false)
{
SaveFileDialog sf = new SaveFileDialog();
sf.Filter = "Excel 2007-2010(*.xlsx) |*.xlsx|Excel 97-2003(*.xls)|*.xls";
sf.AddExtension = true;
sf.FileName = tenFile;
if (sf.ShowDialog() == DialogResult.OK)
{
if (sf.FileName.Contains(".xlsx"))
{
XlsxExportOptionsEx option = new XlsxExportOptionsEx();
if (exportText)
{
option.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Text;
}
option.ExportType = ExportType.WYSIWYG;
view.ExportToXlsx(sf.FileName, option);
}
else if (sf.FileName.Contains(".xls"))
{
XlsExportOptionsEx option = new XlsExportOptionsEx();
if (exportText)
{
option.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Text;
}
option.ExportType = ExportType.WYSIWYG;
view.ExportToXls(sf.FileName, option);
}
//if (XtraMessageBox.Show("Export excel, Bạn có muốn mở nó ngay?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
System.Diagnostics.Process.Start(sf.FileName);
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
DevExpress.XtraPrinting.XlsExportOptionsEx options = new XlsExportOptionsEx()
{
ExportType = DevExpress.Export.ExportType.WYSIWYG
};
options.SheetName = "DevExpress";
gridExporter.WriteXlsToResponse(options);
}
public ActionResult ExportTo(GridViewExportFormat?exportFormat, int companyId, DateTime d_From, DateTime d_To)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("tr-TR");
string _CompanyName = (from tt in DB.Companies
where tt.ID == companyId && tt.IS_DELETED == false
select new { tt.NAME }).FirstOrDefault().NAME;
if (exportFormat == null || !GridViewExportHelper.ExportFormatsInfo.ContainsKey(exportFormat.Value))
{
return(RedirectToAction("CompanyAlarmListPartial", companyId));
}
//DateTime dts = Convert.ToDateTime(datePck);
string date1 = Convert.ToString(d_From);
date1 = date1.Substring(0, date1.Length - 9);
DateTime date_1 = Convert.ToDateTime(date1);
DateTime date_2;
DateTime date2 = Convert.ToDateTime(d_To);
if (date2.Hour == 00)
{
date_2 = date2.AddHours(23);
date_2 = date_2.AddMinutes(59);
}
else
{
date_2 = date2;
}
var _list = (from tt in DB.AlarmStatus
join t in DB.Stations on tt.STATION_ID equals t.ID
where t.COMPANY_ID == companyId
select new { tt.INVERTER_ID, tt.ERROR_NUMBER, tt.START_DATE, tt.STATION_ID, tt.END_DATE, t.NAME }).OrderBy(X => X.START_DATE).ToList();
var _listInv = DB.Inverters.ToList();
var _listAlarmDesc = DB.AlarmDesc.ToList();
List <AlarmStatusDTO> _ListDataSource = new List <AlarmStatusDTO>();
for (int i = 0; i < _list.Count; i++)
{
AlarmStatusDTO alarmStatus = new AlarmStatusDTO();
alarmStatus.INVERTER_ID = _list[i].INVERTER_ID;
TBL_INVERTER _TblInv = _listInv.Where(x => x.ID == _list[i].INVERTER_ID).FirstOrDefault();
if (_TblInv != null)
{
alarmStatus.INV_NAME = _TblInv.NAME;
}
else
{
alarmStatus.INV_NAME = "-";
}
alarmStatus.ERROR_NUMBER = _list[i].ERROR_NUMBER;
//alarmStatus.STATUS = _list[i].STATUS;
alarmStatus.START_DATE = _list[i].START_DATE;
alarmStatus.STATION_NAME = _list[i].NAME;
alarmStatus.END_DATE = _list[i].END_DATE;
alarmStatus.STATION_ID = _list[i].STATION_ID;
alarmStatus.ERROR_NUMBER_NAME = _listAlarmDesc.Where(a => a.ERROR_NUMBER == _list[i].ERROR_NUMBER).FirstOrDefault().ERROR_DESC;
//switch (_list[i].ERROR_NUMBER)
//{
// case "0001":
// alarmStatus.ERROR_NUMBER_NAME = "Communication Error";
// break;
// case "0002":
// alarmStatus.ERROR_NUMBER_NAME = "Station Voltage L2 Fault";
// break;
// case "0003":
// alarmStatus.ERROR_NUMBER_NAME = "Station Voltage L1 Fault";
// break;
// case "0004":
// alarmStatus.ERROR_NUMBER_NAME = "Station Voltage L3 Fault";
// break;
// case "0005":
// alarmStatus.ERROR_NUMBER_NAME = "EKK No Connection";
// break;
// case "0006":
// alarmStatus.ERROR_NUMBER_NAME = "No Main Voltage";
// break;
// case "0007":
// alarmStatus.ERROR_NUMBER_NAME = "No Production";
// break;
// case "0008":
// alarmStatus.ERROR_NUMBER_NAME = "AC Voltage Fault";
// break;
//}
_ListDataSource.Add(alarmStatus);
}
List <CompanyAlarmStatusExportDTO> _ListExport = new List <CompanyAlarmStatusExportDTO>();
var _TempList = _ListDataSource.Where(x => x.START_DATE >= date_1 && x.START_DATE <= date_2) /*.OrderBy(x => x.START_DATE)*/.ToList();
for (int i = 0; i < _TempList.Count; i++)
{
CompanyAlarmStatusExportDTO _ExportDto = new CompanyAlarmStatusExportDTO();
_ExportDto.ID = i + 1;
_ExportDto.DEVICE = _TempList[i].INV_NAME;
_ExportDto.ERROR_DEFINITION = _TempList[i].ERROR_NUMBER_NAME;
_ExportDto.ALERT_START_DATE = _TempList[i].START_DATE.ToString();
_ExportDto.ALERT_END_DATE = _TempList[i].END_DATE.ToString();
_ExportDto.STATION_NAME = _TempList[i].STATION_NAME;
_ListExport.Add(_ExportDto);
}
string filename = _CompanyName + " (" + date1.ToString() + " - " + date2.ToShortDateString() + ")";
GridHelper gh = new GridHelper(companyId);
if (exportFormat == GridViewExportFormat.Xls)
{
XlsExportOptionsEx exportOptions = new XlsExportOptionsEx();
exportOptions.CustomizeCell += new DevExpress.Export.CustomizeCellEventHandler(exportOptions_CustomizeCell);
return(GridViewExtension.ExportToXls(gh.GridStationSetting, _ListExport, filename, exportOptions));
}
else if (exportFormat == GridViewExportFormat.Pdf)
{
return(GridViewExtension.ExportToPdf(gh.GridStationSetting, _ListExport, filename));
}
else if (exportFormat == GridViewExportFormat.Xlsx)
{
return(GridViewExtension.ExportToXlsx(gh.GridStationSetting, _ListExport, filename));
}
return(View(companyId));
}
public ActionResult ExportTo(GridViewExportFormat?exportFormat, int stationId, DateTime d_From, DateTime d_To)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("tr-TR");
string _stationName = (from tt in DB.Stations
where tt.ID == stationId && tt.IS_DELETED == false
select new { tt.NAME }).FirstOrDefault().NAME;
if (exportFormat == null || !GridViewExportHelper.ExportFormatsInfo.ContainsKey(exportFormat.Value))
{
return(RedirectToAction("AlarmListPartial", stationId));
}
//DateTime dts = Convert.ToDateTime(datePck);
string date1 = Convert.ToString(d_From);
date1 = date1.Substring(0, date1.Length - 9);
DateTime date_1 = Convert.ToDateTime(date1);
DateTime date_2;
DateTime date2 = Convert.ToDateTime(d_To);
if (date2.Hour == 00)
{
date_2 = date2.AddHours(23);
date_2 = date_2.AddMinutes(59);
}
else
{
date_2 = date2;
}
var stationName = DB.Stations.Where(a => a.ID == stationId).FirstOrDefault().NAME;
var _listAlarmDesc = DB.AlarmDesc.ToList();
var _list = DB.AlarmStatus.Where(x => x.STATION_ID == stationId).OrderBy(x => x.START_DATE).ToList();
var _listInv = DB.Inverters.ToList();
List <AlarmStatusDTO> _ListDataSource = new List <AlarmStatusDTO>();
for (int i = 0; i < _list.Count; i++)
{
AlarmStatusDTO alarmStatus = new AlarmStatusDTO();
alarmStatus.INVERTER_ID = _list[i].INVERTER_ID;
TBL_INVERTER _TblInv = _listInv.Where(x => x.ID == _list[i].INVERTER_ID).FirstOrDefault();
if (_TblInv != null)
{
alarmStatus.INV_NAME = _TblInv.NAME;
}
else
{
alarmStatus.INV_NAME = stationName;
}
alarmStatus.ERROR_NUMBER = _list[i].ERROR_NUMBER;
//alarmStatus.STATUS = _list[i].STATUS;
alarmStatus.START_DATE = _list[i].START_DATE;
alarmStatus.END_DATE = _list[i].END_DATE;
alarmStatus.STATION_ID = _list[i].STATION_ID;
alarmStatus.ERROR_NUMBER_NAME = _listAlarmDesc.Where(a => a.ERROR_NUMBER == _list[i].ERROR_NUMBER).FirstOrDefault().ERROR_DESC;
_ListDataSource.Add(alarmStatus);
}
List <AlarmStatusExportDTO> _ListExport = new List <AlarmStatusExportDTO>();
var _TempList = _ListDataSource.Where(x => x.START_DATE >= date_1 && x.START_DATE <= date_2) /*.OrderBy(x => x.START_DATE)*/.ToList();
for (int i = 0; i < _TempList.Count; i++)
{
AlarmStatusExportDTO _ExportDto = new AlarmStatusExportDTO();
_ExportDto.ID = i + 1;
_ExportDto.DEVICE = _TempList[i].INV_NAME;
_ExportDto.ERROR_DEFINITION = _TempList[i].ERROR_NUMBER_NAME;
_ExportDto.ALERT_START_DATE = _TempList[i].START_DATE.ToString();
_ExportDto.ALERT_END_DATE = _TempList[i].END_DATE.ToString();
_ListExport.Add(_ExportDto);
}
string filename = _stationName + " (" + date1.ToString() + " - " + date2.ToShortDateString() + ")";
GridHelper gh = new GridHelper(stationId);
if (exportFormat == GridViewExportFormat.Xls)
{
XlsExportOptionsEx exportOptions = new XlsExportOptionsEx();
exportOptions.CustomizeCell += new DevExpress.Export.CustomizeCellEventHandler(exportOptions_CustomizeCell);
return(GridViewExtension.ExportToXls(gh.GridStationSetting, _ListExport, filename, exportOptions));
}
else if (exportFormat == GridViewExportFormat.Pdf)
{
return(GridViewExtension.ExportToPdf(gh.GridStationSetting, _ListExport, filename));
}
else if (exportFormat == GridViewExportFormat.Xlsx)
{
return(GridViewExtension.ExportToXlsx(gh.GridStationSetting, _ListExport, filename));
}
return(View(stationId));
}
public static void XuatExcelv2Ten(string _fileName, DevExpress.XtraGrid.Views.Grid.GridView gridView1, GridControl gc)
{
//_fileName = Regex.Replace(_fileName, "[^0-9a-zA-Z]+", "") + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") ;
SaveFileDialog dialog = new SaveFileDialog();
dialog.Filter = "Excel 97-2003 Workbook(.xls)|*.xls| Excel Workbook(.xlsx) | *.xlsx";
dialog.FileName = _fileName.ToUpper();
DialogResult result = dialog.ShowDialog();
try
{
if (result == DialogResult.OK)
{
string fileName = dialog.FileName;
if (dialog.FilterIndex == 0)
{
XlsExportOptionsEx exportOptions = new XlsExportOptionsEx();
//exportOptions.CustomizeSheetHeader += options_CustomizeSheetHeader;
//exportOptions.TextExportMode = TextExportMode.Text;
exportOptions.ShowTotalSummaries = DevExpress.Utils.DefaultBoolean.True;
exportOptions.FitToPrintedPageWidth = false;
exportOptions.AllowSortingAndFiltering = DevExpress.Utils.DefaultBoolean.True;
exportOptions.ShowColumnHeaders = DevExpress.Utils.DefaultBoolean.True;
exportOptions.ShowPageTitle = DevExpress.Utils.DefaultBoolean.True;
gridView1.OptionsPrint.AutoWidth = false;
//
gridView1.AppearancePrint.HeaderPanel.Options.UseTextOptions = true;
gridView1.AppearancePrint.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
gridView1.AppearancePrint.HeaderPanel.TextOptions.Trimming = DevExpress.Utils.Trimming.Word;
gridView1.ColumnPanelRowHeight = 70;
gridView1.AppearancePrint.EvenRow.Options.UseTextOptions = true;
gridView1.AppearancePrint.EvenRow.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
gridView1.AppearancePrint.EvenRow.TextOptions.Trimming = DevExpress.Utils.Trimming.Word;
// gridView1.AppearancePrint.OddRow.Options.UseTextOptions = true;
gridView1.AppearancePrint.OddRow.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
gridView1.AppearancePrint.OddRow.TextOptions.Trimming = DevExpress.Utils.Trimming.Word;
gridView1.OptionsPrint.AllowMultilineHeaders = true;
gridView1.OptionsPrint.UsePrintStyles = true;
foreach (GridColumn c in gridView1.Columns)
{
c.AppearanceCell.Options.UseTextOptions = true;
c.AppearanceCell.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
}
gridView1.OptionsView.RowAutoHeight = true;
//gridView1.OptionsPrint.EnableAppearanceEvenRow = true;
//gridView1.OptionsPrint.EnableAppearanceOddRow = true;
gridView1.OptionsPrint.AllowMultilineHeaders = true;
exportOptions.ExportType = ExportType.WYSIWYG;
//exportOptions.ExportType = ExportType.DataAware;
gc.ExportToXls(fileName, exportOptions);
System.Diagnostics.Process.Start(fileName);
}
else
{
XlsxExportOptionsEx exportOptions = new XlsxExportOptionsEx();
//exportOptions.CustomizeSheetHeader += options_CustomizeSheetHeader;
//exportOptions.TextExportMode = TextExportMode.Text;
exportOptions.ShowTotalSummaries = DevExpress.Utils.DefaultBoolean.True;
exportOptions.FitToPrintedPageWidth = false;
exportOptions.AllowSortingAndFiltering = DevExpress.Utils.DefaultBoolean.True;
exportOptions.ShowColumnHeaders = DevExpress.Utils.DefaultBoolean.True;
exportOptions.ShowPageTitle = DevExpress.Utils.DefaultBoolean.True;
gridView1.OptionsPrint.AutoWidth = false;
//
gridView1.AppearancePrint.HeaderPanel.Options.UseTextOptions = true;
gridView1.AppearancePrint.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
gridView1.AppearancePrint.HeaderPanel.TextOptions.Trimming = DevExpress.Utils.Trimming.Word;
gridView1.ColumnPanelRowHeight = 70;
gridView1.AppearancePrint.EvenRow.Options.UseTextOptions = true;
gridView1.AppearancePrint.EvenRow.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
gridView1.AppearancePrint.EvenRow.TextOptions.Trimming = DevExpress.Utils.Trimming.Word;
// gridView1.AppearancePrint.OddRow.Options.UseTextOptions = true;
gridView1.AppearancePrint.OddRow.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
gridView1.AppearancePrint.OddRow.TextOptions.Trimming = DevExpress.Utils.Trimming.Word;
gridView1.OptionsPrint.AllowMultilineHeaders = true;
gridView1.OptionsPrint.UsePrintStyles = true;
foreach (GridColumn c in gridView1.Columns)
{
c.AppearanceCell.Options.UseTextOptions = true;
c.AppearanceCell.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
}
gridView1.OptionsView.RowAutoHeight = true;
//gridView1.OptionsPrint.EnableAppearanceEvenRow = true;
//gridView1.OptionsPrint.EnableAppearanceOddRow = true;
gridView1.OptionsPrint.AllowMultilineHeaders = true;
exportOptions.ExportType = ExportType.WYSIWYG;
//exportOptions.ExportType = ExportType.DataAware;
gc.ExportToXlsx(fileName, exportOptions);
System.Diagnostics.Process.Start(fileName);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ExportTo(GridViewExportFormat?exportFormat, int stationId, /*DateTime datePck,*/ DateTime dFrom, DateTime dTo /*, string filterString*/)
{
string _stationName = (from tt in DB.Stations
where tt.ID == stationId && tt.IS_DELETED == false
select new { tt.NAME }).FirstOrDefault().NAME;
if (exportFormat == null || !GridViewExportHelper.ExportFormatsInfo.ContainsKey(exportFormat.Value))
{
return(RedirectToAction("InvDetailReportPartial", stationId));
}
// DateTime dts = Convert.ToDateTime(datePck);
DateTime date1 = Convert.ToDateTime(dFrom);
DateTime date2 = Convert.ToDateTime(dTo);
DateTime date1_ = date1.Date;
DateTime date2_ = date2.Date;
date2_ = date2_.AddHours(23);
date2_ = date2_.AddMinutes(59);
GridHelper gh = new GridHelper(stationId);
var _TempInvOzet = (from x in DB.InvSums
join inv in DB.Inverters on x.Inv_Id equals inv.ID
where
x.STATION_ID == stationId
&&
date1_ <= x.Tarih.Value
&&
date2_ >= x.Tarih.Value
//&&
//date2.Month >= x.Tarih.Value.Month
//&&
//date1.Month <= x.Tarih.Value.Month
//&&
//date2.Day >= x.Tarih.Value.Day
//&&
//date1.Day <= x.Tarih.Value.Day
select new
{
x,
inv.NAME
}).OrderBy(X => X.x.Tarih.Value).ToList();
List <ExportEsso> ListExport = new List <ExportEsso>();
for (int i = 0; i < _TempInvOzet.Count; i++)
{
ExportEsso _cExportEsso = new ExportEsso();
_cExportEsso.Id = _TempInvOzet[i].x.Id;
_cExportEsso.DATE = _TempInvOzet[i].x.Tarih.Value.ToString("dd/MM/yyyy HH:mm");
_cExportEsso.INV = _TempInvOzet[i].NAME;
_cExportEsso.CRNT_AC = Convert.ToDecimal(_TempInvOzet[i].x.Akim_AC);
_cExportEsso.CRNT_DC = Convert.ToDecimal(_TempInvOzet[i].x.Akim_DC);
_cExportEsso.V_AC = Convert.ToDecimal(_TempInvOzet[i].x.Gerilim_AC);
_cExportEsso.V_DC = Convert.ToDecimal(_TempInvOzet[i].x.Gerilim_DC);
_cExportEsso.PWR_AC = Convert.ToDecimal(_TempInvOzet[i].x.Guc_AC);
_cExportEsso.PWR_DC = Convert.ToDecimal(_TempInvOzet[i].x.Guc_DC);
_cExportEsso.DAILY_YIELD = Convert.ToDecimal(_TempInvOzet[i].x.Gunluk_Enerji);
_cExportEsso.TOTAL_YIELD = Convert.ToDecimal(_TempInvOzet[i].x.Toplam_Enerji);
ListExport.Add(_cExportEsso);
}
if (exportFormat == GridViewExportFormat.Xls)
{
XlsExportOptionsEx exportOptions = new XlsExportOptionsEx();
exportOptions.CustomizeCell += new DevExpress.Export.CustomizeCellEventHandler(exportOptions_CustomizeCell);
string filename = _stationName + " (" + date1.ToShortDateString() + " - " + date2.ToShortDateString() + ")";
return(GridViewExtension.ExportToXls(gh.GridStationSettings, ListExport, filename, exportOptions));
}
else
{
return(GridViewExportHelper.ExportFormatsInfo[exportFormat.Value](
gh.GridStationSettings, ListExport));
}
}
