protected void ASPxButtonExportExcel_Click(object sender, EventArgs e)
{
string fileName = "Daily Encounters";
XlsxExportOptionsEx options;
options = new XlsxExportOptionsEx() { ExportType = ExportType.WYSIWYG };
ASPxPivotGridExporter.ExportXlsxToResponse(fileName, options, true);
}
private void btnExportar_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Estas seguro que desea Exportar el reporte", "◄ AVISO | LEASEIN ►", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
Cursor.Current = Cursors.WaitCursor;
try
{
DevExpress.Export.ExportSettings.DefaultExportType = ExportType.DataAware;
XlsxExportOptionsEx options = new XlsxExportOptionsEx();
options.CustomizeSheetHeader += options_CustomizeSheetHeader;
//options.CustomizeCell += op_CustomizeCell;
string file = "REPORTE MEMORIAS.xlsx";
dgvMemorias.ExportToXlsx(file, options);
System.Diagnostics.Process.Start(file);
}
catch (Exception ex)
{
//MessageBox.Show("Error al exportar la informacion debido a: " + ex.ToString(), "◄ AVISO | LEASEIN ►", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
MessageBox.Show("Error al exportar la informacion | Si tiene un reporte de MEMORIAS ya abierto, cierrelo.", " ◄ AVISO | LEASEIN ►", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
Cursor.Current = Cursors.Default;
}
}
private void ExportExcel(object sender, ItemClickEventArgs e) {
SaveFileDialog dialog = new SaveFileDialog {
Filter = @"Excel Files (*.xlsx)|*.xlsx",
RestoreDirectory = true
};
if (dialog.ShowDialog() == DialogResult.OK) {
XlsxExportOptionsEx advOptions = new XlsxExportOptionsEx {
ExportType = DevExpress.Export.ExportType.DataAware,
TextExportMode = TextExportMode.Value,
SheetName = Settings.ActiveHost.Server
};
try {
gridControl1.ExportToXlsx(dialog.FileName, advOptions);
Output.Current.Add($"Export to Excel: {dialog.FileName}");
}
catch (Exception ex) {
Output.Current.Add("Export to Excel failed", ex.Message);
XtraMessageBox.Show(ex.Message.Replace(". ", "." + Environment.NewLine), ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void ExportExCel(GridControl _GridControl, GridView _Gridview, string Sheet)
{
try
{
// SaveFile.InitialDirectory = My.Computer.FileSystem.SpecialDirectories.MyDocuments
SaveFile.Filter = "Excel files (*.xlsx)|*.xlsx|CSV Files (*.csv)|*.csv|XLS Files (*.xls)|*xls";
string path = "";
if (SaveFile.ShowDialog() == DialogResult.OK)
{
FileInfo fi = new FileInfo(SaveFile.FileName);
string FileName = SaveFile.FileName;
path = fi.FullName;
// Customize export options
(_GridControl.MainView as GridView).OptionsPrint.PrintHeader = true;
XlsxExportOptionsEx advOptions = new XlsxExportOptionsEx
{
AllowGrouping = DevExpress.Utils.DefaultBoolean.False,
ShowTotalSummaries = DevExpress.Utils.DefaultBoolean.False,
SheetName = Sheet
};
_Gridview.ExportToXlsx(path, advOptions);
// Open the created XLSX file with the default application.
Process.Start(path).Dispose();
}
else
{
return;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
public static void TabloDisariAktar(this GridView tablo, DosyaTuru dosyaTuru, string dosyaFormati, string excelSayfaAdi = null)
{
if (Messages.TabloExportMessage(dosyaFormati) != DialogResult.Yes)
{
return;
}
if (!Directory.Exists(Application.StartupPath + @"\Temp"))
{
Directory.CreateDirectory(Application.StartupPath + @"\Temp");
}
var dosyaAdi = Guid.NewGuid().ToString();
var filePath = $@"{Application.StartupPath}\Temp\{dosyaAdi}";
switch (dosyaTuru)
{
case DosyaTuru.ExcelStandart:
{
var opt = new XlsxExportOptionsEx
{
ExportType = ExportType.Default,
SheetName = excelSayfaAdi,
TextExportMode = TextExportMode.Text,
};
filePath = filePath + ".Xlsx";
tablo.ExportToXlsx(filePath, opt);
}
break;
case DosyaTuru.ExcelFormatli:
{
var opt = new XlsxExportOptionsEx
{
ExportType = ExportType.WYSIWYG,
SheetName = excelSayfaAdi,
TextExportMode = TextExportMode.Text,
};
filePath = filePath + ".Xlsx";
tablo.ExportToXlsx(filePath, opt);
}
break;
case DosyaTuru.ExcelFormatsiz:
{
var opt = new CsvExportOptionsEx
{
ExportType = ExportType.WYSIWYG,
TextExportMode = TextExportMode.Text,
};
filePath = filePath + ".Csv";
tablo.ExportToCsv(filePath, opt);
}
break;
case DosyaTuru.WordDosyasi:
{
filePath = filePath + ".Rtf";
tablo.ExportToRtf(filePath);
}
break;
case DosyaTuru.PdfDosyasi:
{
filePath = filePath + ".Pdf";
tablo.ExportToPdf(filePath);
}
break;
case DosyaTuru.TxtDosyasi:
{
var opt = new TextExportOptions {
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Txt";
tablo.ExportToText(filePath, opt);
}
break;
}
if (!File.Exists(filePath))
{
Messages.HataMesaji("Tablo Verileri Dosyaya Aktarılamadı.");
return;
}
Process.Start(filePath);
}
public static void ExportExcel(GridControl gridControl, GridView MainGridView)
{
SaveFileDialog dialog = null;
try
{
dialog = new SaveFileDialog();
dialog.Filter = "Excel files|*.xlsx";
if (dialog.ShowDialog() == DialogResult.OK)
{
gridControl.BeginUpdate();
List <GridColumn> gcs = new List <GridColumn>();
RepositoryItemCheckEdit temp = null;
foreach (GridColumn gc in MainGridView.Columns)
{
if (gc.ColumnEdit is RepositoryItemCheckEdit)
{
temp = gc.ColumnEdit as RepositoryItemCheckEdit;
gcs.Add(gc);
gc.ColumnEdit = new RepositoryItemTextEdit();
}
}
if (gridControl.LevelTree != null && gridControl.LevelTree.Nodes.Count > 0)
{
MainGridView.ZoomView();
MainGridView.OptionsPrint.PrintDetails = true;
foreach (GridLevelNode gln in gridControl.LevelTree.Nodes)
{
setPrintDTL(gln);
}
}
MainGridView.OptionsPrint.AutoWidth = false;
XlsxExportOptionsEx opt = new XlsxExportOptionsEx(TextExportMode.Value);
opt.ExportType = DevExpress.Export.ExportType.WYSIWYG;
gridControl.ExportToXlsx(dialog.FileName, opt);
if (gridControl.LevelTree != null && gridControl.LevelTree.Nodes.Count > 0)
{
MainGridView.NormalView();
foreach (GridLevelNode gln in gridControl.LevelTree.Nodes)
{
donePrintDTL(gln);
}
}
foreach (GridColumn gc in gcs)
{
gc.ColumnEdit = temp;
}
if (DevExpress.XtraEditors.XtraMessageBox.Show("Хадгалсан файлаа нээх үү?", "Асуулт", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Process.Start(dialog.FileName);
}
}
}
catch (Exception ex)
{
gridControl.EndUpdate();
DevExpress.XtraEditors.XtraMessageBox.Show("ExportExcel: " + ex.Message);
}
finally
{
gridControl.EndUpdate();
dialog = null;
}
}
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;
}
}
private void btnGuiMail_Click(object sender, EventArgs e)
{
if (XtraMessageBox.Show("Bạn muốn gửi mail ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
D_GIAODICH gdb = new D_GIAODICH();
List <string> vs = new List <string>();
if ((txtFileDinhKem.EditValue ?? string.Empty) != string.Empty)
{
vs = txtFileDinhKem.EditValue.ToString().Split(',').ToList();
}
int n = lstDaiLy.CheckedItems.Count;
if (n == 0)
{
XuLyGiaoDien.Alert("Chưa chọn đại lý cần gửi", Form_Alert.enmType.Info);
}
else
{
try
{
O_CAUHINHSMTP cauHinhSMTPO = cauHinhSMTPD.DuLieu();
O_MAUEMAIL ma = new D_MAUEMAIL().DuLieu()[0];
SmtpClient client = new SmtpClient();
client.Port = cauHinhSMTPO.Port;
client.Host = cauHinhSMTPO.Host;
client.EnableSsl = cauHinhSMTPO.SSL;
client.Timeout = 10000;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential(cauHinhSMTPO.Email, cauHinhSMTPO.Password);
grvCTCongNo.Columns["Hang"].Width = 50;
grvCTCongNo.Columns["SoVeVN"].Width = 90;
grvCTCongNo.Columns["LuyKe"].Width = 90;
grvCTCongNo.Columns["GiaThu"].Width = 90;
grvCTCongNo.Columns["GiaHeThong"].Width = 90;
grvCTCongNo.Columns["TaiKhoanCo"].Width = 90;
grvCTCongNo.Columns["TenKhach"].Width = 250;
grvCTCongNo.OptionsPrint.AutoWidth = false;
grvCTCongNo.OptionsView.ColumnAutoWidth = false;
XlsxExportOptionsEx opt = new XlsxExportOptionsEx();
opt.CustomizeCell += op_CustomizeCell;
opt.SheetName = "Bản Công Nợ";
bool sendOK = false;
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
for (int i = 0; i < n; i++)
{
O_DAILY dl = lstDaiLy.GetItem(lstDaiLy.CheckedIndices[0]) as O_DAILY;
if (!dl.GuiMail)
{
int index1 = lstDaiLy.FindItem(0, true, delegate(ListBoxFindItemArgs ei) { ei.IsFound = object.Equals(dl.ID, ei.ItemValue); });
lstDaiLy.SetItemChecked(index1, false);
continue;
}
lstInt.Add(dl.ID);
string daily = string.Format("{0}", dl.ID);
List <O_GIAODICH> lstCongNo = gdb.LayDanhSachCN((DateTime)dtpTuNgay.EditValue, (DateTime)dtpDenNgay.EditValue, daily, true);
txtMauEmail.HtmlText = ma.NoiDung.Replace("{0}", dl.MaDL).Replace("{1}", XuLyDuLieu.NotVietKey(dl.Ten));
if ((dl.EmailKeToan ?? string.Empty) == string.Empty)
{
goto RE1;
}
string[] EmailKeToanString = Regex.Replace(dl.EmailKeToan, @"\t|\n|\r", "|").Replace("||", "|").Split('|');
for (int ii = 0; ii < EmailKeToanString.Count(); ii++)
{
if (EmailKeToanString[ii].Length > 5)
{
MailMessage mm = new MailMessage();
mm.From = new MailAddress("*****@*****.**", "Thành Hoàng");
mm.BodyEncoding = UTF8Encoding.UTF8;
mm.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
mm.IsBodyHtml = true;
RichEditMailMessageExporter exporter = new RichEditMailMessageExporter(txtMauEmail, mm);
exporter.Export();
mm.To.Add(new MailAddress(EmailKeToanString[ii]));
//mm.To.Add(new MailAddress("*****@*****.**"));
if (lstCongNo.Count > 1)
{
XuLyGiaoDien.wait.SetWaitFormDescription("Gửi cho: " + dl.Ten + " (" + (i + 1) + "/" + n + ").");
CTGiaoDichDindingSource.DataSource = lstCongNo;
mm.Subject = "Công Nợ - " + dl.Ten + " - Từ ngày " + ((DateTime)dtpTuNgay.EditValue).ToString("dd_MM_yyyy") + " - đến ngày " + ((DateTime)dtpDenNgay.EditValue).ToString("dd_MM_yyyy");
#region Xuất excel
gridCTCongNo.ForceInitialize();
string strFile = @"C:\CongNo\" + dl.Ten + " - " + ((DateTime)dtpTuNgay.EditValue).ToString("dd_MM_yyyy") + " - " + ((DateTime)dtpDenNgay.EditValue).ToString("dd_MM_yyyy") + ".xlsx";
Directory.CreateDirectory(@"C:\CongNo");
gridCTCongNo.ExportToXlsx(strFile, opt);
#endregion
mm.Attachments.Add(new Attachment(strFile));
foreach (string g in vs)
{
if (g.Count() > 0)
{
mm.Attachments.Add(new Attachment(g));
}
}
client.Send(mm);
sendOK = true;
mm.Attachments.Dispose();
if (File.Exists(strFile))
{
File.Delete(strFile);
}
}
}
}
RE1 :
int index = lstDaiLy.FindItem(0, true, delegate(ListBoxFindItemArgs ei) { ei.IsFound = object.Equals(dl.ID, ei.ItemValue); });
lstDaiLy.SetItemChecked(index, false);
}
if (sendOK)
{
XuLyGiaoDien.Alert("Gửi mail thành công", Form_Alert.enmType.Success);
}
else
{
XuLyGiaoDien.Alert("Gửi mail không thành công", Form_Alert.enmType.Warning);
}
}
catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Thông báo"); }
gdb.ChayCapNhatLuyKe(lstInt);
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
}
}
protected void buttonSaveAs_Click(object sender, EventArgs e)
{
foreach (DevExpress.Web.ASPxPivotGrid.PivotGridField field in ASPxPivotGrid1.Fields)
{
if (field.ValueFormat != null && !string.IsNullOrEmpty(field.ValueFormat.FormatString))
{
field.UseNativeFormat = checkCustomFormattedValuesAsText.Checked ? DefaultBoolean.False : DefaultBoolean.True;
}
}
ASPxPivotGridExporter1.OptionsPrint.PrintColumnAreaOnEveryPage = checkPrintColumnAreaOnEveryPage.Checked;
ASPxPivotGridExporter1.OptionsPrint.PrintRowAreaOnEveryPage = checkPrintRowAreaOnEveryPage.Checked;
ASPxPivotGridExporter1.OptionsPrint.MergeColumnFieldValues = checkMergeColumnFieldValues.Checked;
ASPxPivotGridExporter1.OptionsPrint.MergeRowFieldValues = checkMergeRowFieldValues.Checked;
ASPxPivotGridExporter1.OptionsPrint.PrintFilterHeaders = checkPrintFilterFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False;
ASPxPivotGridExporter1.OptionsPrint.PrintColumnHeaders = checkPrintColumnFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False;
ASPxPivotGridExporter1.OptionsPrint.PrintRowHeaders = checkPrintRowFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False;
ASPxPivotGridExporter1.OptionsPrint.PrintDataHeaders = checkPrintDataFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False;
const string fileName = "PivotGrid";
XlsxExportOptionsEx options;
switch (listExportFormat.SelectedIndex)
{
case 0:
ASPxPivotGridExporter1.ExportPdfToResponse(fileName);
break;
case 1:
options = new XlsxExportOptionsEx()
{
ExportType = ExportType.WYSIWYG
};
ASPxPivotGridExporter1.ExportXlsxToResponse(fileName, options);
break;
case 2:
ASPxPivotGridExporter1.ExportMhtToResponse(fileName, "utf-8", "ASPxPivotGrid Printing Sample", true);
break;
case 3:
ASPxPivotGridExporter1.ExportRtfToResponse(fileName);
break;
case 4:
ASPxPivotGridExporter1.ExportTextToResponse(fileName);
break;
case 5:
ASPxPivotGridExporter1.ExportHtmlToResponse(fileName, "utf-8", "ASPxPivotGrid Printing Sample", true);
break;
case 6:
options = new XlsxExportOptionsEx()
{
ExportType = ExportType.DataAware,
AllowGrouping = allowGroupingCheckBox.Checked ? DefaultBoolean.True : DefaultBoolean.False,
TextExportMode = exportCellValuesAsText.Checked ? TextExportMode.Text : TextExportMode.Value,
AllowFixedColumns = allowFixedColumns.Checked ? DefaultBoolean.True : DefaultBoolean.False,
AllowFixedColumnHeaderPanel = allowFixedColumns.Checked ? DefaultBoolean.True : DefaultBoolean.False,
RawDataMode = exportRawData.Checked
};
ASPxPivotGridExporter1.ExportXlsxToResponse(fileName, options);
break;
}
}
public static void TableExport(this GridView table, FileType fileType, string fileFormat, string excelPageName = null)
{
if (Messages.TableExportMessage(fileFormat) != DialogResult.Yes)
{
return;
}
if (!Directory.Exists(Application.StartupPath + @"\Temp"))
{
Directory.CreateDirectory(Application.StartupPath + @"\Temp");
}
var fileName = Guid.NewGuid().ToString();
var filePath = $@"{Application.StartupPath}\Temp\{fileName}";
switch (fileType)
{
case FileType.ExcelStandart:
{
var opt = new XlsxExportOptionsEx
{
ExportType = DevExpress.Export.ExportType.Default,
SheetName = excelPageName,
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Xlsx";
table.ExportToXlsx(filePath, opt);
}
break;
case FileType.ExcelFormat:
{
var opt = new XlsxExportOptionsEx
{
ExportType = DevExpress.Export.ExportType.WYSIWYG,
SheetName = excelPageName,
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Xlsx";
table.ExportToXlsx(filePath, opt);
}
break;
case FileType.ExcelUnformatted:
{
var opt = new CsvExportOptionsEx
{
ExportType = DevExpress.Export.ExportType.WYSIWYG,
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Csv";
table.ExportToCsv(filePath, opt);
}
break;
case FileType.WordFile:
{
filePath = filePath + ".Rtf";
table.ExportToRtf(filePath);
}
break;
case FileType.PdfFile:
{
filePath = filePath + ".Pdf";
table.ExportToPdf(filePath);
}
break;
case FileType.TxtFile:
{
var opt = new TextExportOptions {
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Txt";
table.ExportToText(filePath, opt);
}
break;
}
if (!File.Exists(filePath))
{
Messages.ErrorMessage("File not found.");
return;
}
Process.Start(filePath);
}
/// <summary>
/// ''' Procedimiento que permite exportar un archivo a excel.
/// ''' </summary>
/// ''' <param name="formato">Especifica el formato al que se exportará la información del grid</param>
/// ''' <param name="DxGridControl">Grid que contiene la información a exportar</param>
/// ''' <param name="AbrirArchivo">Indica si se debe abrir el archivo al terminar el proceso de exportación.</param>
/// ''' <param name="MostrarSaveDialog">Indica si se mostrará un cuadro de diálogo para guardar el archivo</param>
/// ''' <param name="FileName">Indica el nombre del archivo, si se envia vacio se almacenara la ruta donde se encuentra el ejecutable y se le dara un nombre por default</param>
/// ''' <remarks></remarks>
public void ExportarDXGridControl(FormatosArchivo formato, GridControl DxGridControl, bool AbrirArchivo = true, bool MostrarSaveDialog = true, string FileName = "")
{
// DevExpress.Export.ExportSettings.DefaultExportType = DevExpress.Export.ExportType.WYSIWYG
try
{
SaveFileDialog SaveDlg = new SaveFileDialog
{
InitialDirectory = @"c:\\",
FileName = FileName
};
switch (formato)
{
case FormatosArchivo.csv:
{
SaveDlg.Filter = "Archivos separado por comas csv (.csv) | *.csv";
SaveDlg.DefaultExt = ".csv";
if (MostrarSaveDialog)
{
if (SaveDlg.ShowDialog() == DialogResult.OK)
{
FileName = SaveDlg.FileName;
}
else
{
return;
}
}
else if (FileName == "")
{
FileName = Environment.CurrentDirectory + @"\GridExportado.csv";
}
DxGridControl.ExportToCsv(FileName);
break;
}
case FormatosArchivo.Excel:
{
SaveDlg.Filter = "Archivos de Excel (.xlsx) | *.xlsx";
SaveDlg.DefaultExt = ".xlsx";
if (MostrarSaveDialog)
{
if (SaveDlg.ShowDialog() == DialogResult.OK)
{
FileName = SaveDlg.FileName;
}
else
{
return;
}
}
else if (FileName == "")
{
FileName = Environment.CurrentDirectory + @"\GridExportado.xlsx";
}
XlsxExportOptionsEx options = new XlsxExportOptionsEx
{
ExportType = DevExpress.Export.ExportType.WYSIWYG
};
DxGridControl.ExportToXlsx(FileName, options);
break;
}
case FormatosArchivo.html:
{
SaveDlg.Filter = "Archivos html (.html) | *.html";
SaveDlg.DefaultExt = ".html";
if (MostrarSaveDialog)
{
if (SaveDlg.ShowDialog() == DialogResult.OK)
{
FileName = SaveDlg.FileName;
}
else
{
return;
}
}
else if (FileName == "")
{
FileName = Environment.CurrentDirectory + @"\GridExportado.html";
}
DxGridControl.ExportToHtml(FileName);
break;
}
case FormatosArchivo.pdf:
{
SaveDlg.Filter = "Archivos de Adobe Reader (.pdf) | *.pdf";
SaveDlg.DefaultExt = ".pdf";
if (MostrarSaveDialog)
{
if (SaveDlg.ShowDialog() == DialogResult.OK)
{
FileName = SaveDlg.FileName;
}
else
{
return;
}
}
else if (FileName == "")
{
FileName = Environment.CurrentDirectory + @"\GridExportado.pdf";
}
DxGridControl.ExportToPdf(FileName);
break;
}
case FormatosArchivo.rtf:
{
SaveDlg.Filter = "Archivos de texto enriquecido Reader (.rtf) | *.rtf";
SaveDlg.DefaultExt = ".rtf";
if (MostrarSaveDialog)
{
if (SaveDlg.ShowDialog() == DialogResult.OK)
{
FileName = SaveDlg.FileName;
}
else
{
return;
}
}
else if (FileName == "")
{
FileName = Environment.CurrentDirectory + @"\GridExportado.rtf";
}
DxGridControl.ExportToRtf(FileName);
break;
}
case FormatosArchivo.text:
{
SaveDlg.Filter = "Archivos de texto e (.txt) | *.txt";
SaveDlg.DefaultExt = ".txt";
if (MostrarSaveDialog)
{
if (SaveDlg.ShowDialog() == DialogResult.OK)
{
FileName = SaveDlg.FileName;
}
else
{
return;
}
}
else if (FileName == "")
{
FileName = Environment.CurrentDirectory + @"\GridExportado.rtf";
}
DxGridControl.ExportToText(FileName);
break;
}
}
if (AbrirArchivo)
{
Process.Start(FileName);
}
}
catch (Exception ex)
{
MessageBox.Show("Imposible exportar los datos del control. Causa: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public FyForm()
{
InitializeComponent();
InitFilterPanel();
FFVM = mvvmContext.GetViewModel <FyFormViewModel>();
mvvmContext.SetBinding(this.dateBegin, e => e.Text, "BeginTime");
mvvmContext.SetBinding(this.dateEnd, e => e.Text, "EndTime");
mvvmContext.SetBinding(this.txtDoctor, e => e.EditValue, "Doctor");
mvvmContext.SetBinding(this.txtPatient, e => e.EditValue, "Patient");
mvvmContext.SetBinding(this.gridControl1, e => e.DataSource, "cfhead");
mvvmContext.SetBinding(this.gridControl2, e => e.DataSource, "Dv");
mvvmContext.BindCommand <FyFormViewModel>(this.btnQuery, x => x.Query());
mvvmContext.BindCommand <FyFormViewModel>(this.btnImport, x => x.Import());
this.btnExportExcel.Click += (x, y) =>
{
XlsxExportOptionsEx op = new XlsxExportOptionsEx()
{
ShowGridLines = false,
SheetName = "门诊处方汇总表",
ShowPageTitle = DevExpress.Utils.DefaultBoolean.True,
ShowTotalSummaries = DevExpress.Utils.DefaultBoolean.True,
};
op.BandedLayoutMode = DevExpress.Export.BandedLayoutMode.LinearBandsAndColumns;
this.gridControl2.ExportToXlsx(@"C:\Users\Lenovo\Desktop\处方明细汇总表.xlsx", op);
};
mvvmContext.SetBinding(this.comDoctor, e => e.Text, "SelectDate");
mvvmContext.SetBinding(this.lblTotlprice, e => e.Text, "Huizong");
this.gridView1.FocusedRowChanged += (x, y) => {
Cfhead obj;
if (y.FocusedRowHandle < 0)
{
obj = null;
}
obj = this.gridView1.GetRow(y.FocusedRowHandle) as Cfhead;
mvvmContext.GetViewModel <FyFormViewModel>().SelectRow = obj;
// MessageBox.Show(obj.opertime);
};
this.gridView1.RowClick += (s, e) =>
{
if (e.Clicks == 2)
{
GridView gv = s as GridView;
Cfhead dr = gv.GetRow(e.RowHandle) as Cfhead;
XtraDialogForm di = new XtraDialogForm();
di.CancelButton = new SimpleButton();
di.AutoSize = true;
di.StartPosition = FormStartPosition.CenterParent;
di.ShowInTaskbar = false;
di.Text = "患者处方历史记录";
di.MaximizeBox = di.MinimizeBox = false;
di.FormBorderStyle = FormBorderStyle.Fixed3D;;
TableControl tc = new TableControl(dr);
di.Controls.Add(tc);
di.ShowDialog();
}
};
mvvmContext.BindCommand <FyFormViewModel>(this.btnDelete, x => x.DeleteRow());
this.gridView3.RowClick += (x, y) =>
{
MessageBox.Show("hehe");
};
Init();
this.toggleSwitch1_Toggled(this.toggleSwitch1, new EventArgs());
}
