private void cmdExportToExcel_Click(object sender, EventArgs e)
{
try
{
ExcelUtlity.ExportGridEx(grdResult);
//saveFileDialog1.Filter = "Excel File(*.xls)|*.xls";
//saveFileDialog1.FileName = string.Format("{0}.xls", tieude);
////saveFileDialog1.ShowDialog();
//if (saveFileDialog1.ShowDialog() == DialogResult.OK)
//{
// string sPath = saveFileDialog1.FileName;
// var fs = new FileStream(sPath, FileMode.Create);
// fs.CanWrite.CompareTo(true);
// fs.CanRead.CompareTo(true);
// gridEXExporter1.Export(fs);
// fs.Dispose();
//}
//saveFileDialog1.Dispose();
//saveFileDialog1.Reset();
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
}
public void ExportToExcel()
{
var chartTitle = currentChartDto.ChartTitle;
var obj = new ExcelUtlity();
var labels = currentChartDto.Labels;
var values = currentChartDto.Values;
var list = new List <ExportClass>();
foreach (var seriesHandler in values)
{
var it = 0;
var seriesHandlerCounts = seriesHandler.Counts;
var seriesHandlerDoubleCounts = seriesHandler.DoubleCounts;
if (seriesHandlerCounts != null)
{
foreach (var seriesHandlerCount in seriesHandlerCounts)
{
list.Add(new ExportClass
{
Serie = seriesHandler.SerieTitle,
Item = labels.ElementAt(it),
Nombre = seriesHandlerCount
});
it++;
}
}
else if (seriesHandlerDoubleCounts != null)
{
foreach (var seriesHandlerDoubleCount in seriesHandlerDoubleCounts)
{
list.Add(new ExportClass
{
Serie = seriesHandler.SerieTitle,
Item = labels.ElementAt(it),
Nombre = seriesHandlerDoubleCount
});
it++;
}
}
}
var dt = ConvertToDataTable(list);
var myDocumentPath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
obj.WriteDataTableToExcel(dt, "MOTS", $"{myDocumentPath}\\MOTS_Export.xlsx", chartTitle);
}
private void cmdXuatExcel_Click(object sender, EventArgs e)
{
try
{
if (grdList.RowCount <= 0)
{
Utility.ShowMsg("Không có dữ liệu", "Thông báo");
grdList.Focus();
return;
}
ExcelUtlity.ExportGridEx(grdList);
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi:" + exception.Message);
}
}
private void cmdExportToExcel_Click(object sender, EventArgs e)
{
try
{
if (radChuyenDen.Checked)
{
ExcelUtlity.ExportGridEx(grdChuyenDen);
}
else
{
ExcelUtlity.ExportGridEx(grdChuyendi);
}
////Janus.Windows.GridEX.GridEXRow[] gridExRows = grdList.GetCheckedRows();
//if (grdChuyenDen.RowCount <= 0||grdChuyendi.RowCount <=0)
//{
// Utility.ShowMsg("Không có dữ liệu", "Thông báo");
// return;
//}
//saveFileDialog1.Filter = "Excel File(*.xls)|*.xls";
//saveFileDialog1.FileName = string.Format("{0}.xls", tieude);
////saveFileDialog1.ShowDialog();
//if (saveFileDialog1.ShowDialog() == DialogResult.OK)
//{
// string sPath = saveFileDialog1.FileName;
// FileStream fs = new FileStream(sPath, FileMode.Create);
// fs.CanWrite.CompareTo(true);
// fs.CanRead.CompareTo(true);
// gridEXExporter1.Export(fs);
// fs.Dispose();
//}
//saveFileDialog1.Dispose();
//saveFileDialog1.Reset();
}
catch (Exception exception)
{
Utility.ShowMsg("Lỗi" + exception.Message);
}
}
private void cmdExportToExcel_Click(object sender, EventArgs e)
{
ExcelUtlity.ExportGridEx(grdResult);
}
private void cmdViewLog_Click(object sender, EventArgs e)
{
ExcelUtlity.ExportGridEx(grdLogInfomation);
}
