// 导出Excel
private void barBtnExport_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
var dtExport = (DataTable)this.gcOCN_CLJBXX.DataSource;
if (dtExport == null || dtExport.Rows.Count < 1)
{
MessageBox.Show("当前没有数据可以下载！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var dialogResult = saveFileDialog1.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
var options = new XlsExportOptions()
{
TextExportMode = TextExportMode.Value, ExportMode = XlsExportMode.SingleFile
};
this.gcOCN_CLJBXX.ExportToXls(saveFileDialog1.FileName, options);
var excelBuilder = new ExcelHelper(saveFileDialog1.FileName);
excelBuilder.DeleteColumns(1, 1);
excelBuilder.SaveFile();
if (MessageBox.Show("保存成功，是否打开文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog1.FileName);
}
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//导出Excel
private void barBtnExport_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
var dtExport = (DataTable)this.gcDataInfo.DataSource;
if (dtExport == null || dtExport.Rows.Count < 1)
{
MessageBox.Show("当前没有数据可以操作！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
var options = new XlsExportOptions()
{
TextExportMode = TextExportMode.Value, ExportMode = XlsExportMode.SingleFile
};
this.gcDataInfo.ExportToXls(saveFileDialog.FileName, options);
if (MessageBox.Show("操作成功，是否打开文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static DefinisanaStampa VratiStampeRezervisanihBrojevaPredmeta(UlogovaniKorisnik korisnik, PregledRezervacijaZaglavlje zaglavlje)
{
var guid = Guid.NewGuid().ToString();
var stampa = new DefinisanaStampa {
Naziv = "Pregled rezervacija"
};
stampa.Link = string.Format("{0}{1}/{2}.pdf", PutanjaAplikacije.PutanjaStampeWeb, guid, stampa.Naziv);
var report = new PregledRezervacijeReport();
report.LoadLayout(PutanjaAplikacije.PutanjaReportPregledBrojeva + "\\PregledRezervacijeReport.repx");
report.PostaviPodatke(zaglavlje);
report.CreateDocument();
if (!Directory.Exists(string.Format("{0}{1}", PutanjaAplikacije.PutanjaStampe, guid)))
{
Directory.CreateDirectory(string.Format("{0}{1}", PutanjaAplikacije.PutanjaStampe, guid));
}
report.ExportToPdf(string.Format("{0}{1}\\{2}.pdf", PutanjaAplikacije.PutanjaStampe, guid, stampa.Naziv));
var opt = new XlsExportOptions {
ShowGridLines = true
};
report.ExportToXls(string.Format("{0}{1}\\{2}.xls", PutanjaAplikacije.PutanjaStampe, guid, stampa.Naziv), opt);
return(stampa);
}
public HttpResponseMessage ExportToXls(string reportId, string accessId, string parameters = null, string entityId = null)
{
var report = GetXtraReport(reportId, parameters, entityId, accessId);
XlsExportOptions exportOptions = report.ExportOptions.Xls;
exportOptions.ExportMode = XlsExportMode.SingleFilePageByPage;
var memoryStream = new MemoryStream();
report.ExportToXls(memoryStream);
memoryStream.Position = 0;
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
response.Content = new ByteArrayContent(memoryStream.ToArray());
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/xls");
response.Content.Headers.ContentLength = memoryStream.Length;
response.Content.Headers.ContentDisposition =
new ContentDispositionHeaderValue("attachment")
{
FileName = $"{report.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName}.xls",
};
return(response);
}
private void btnExport_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
saveFileDialog.FileName = "预测数据";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions();
options.TextExportMode = TextExportMode.Value;
//options.ExportMode = XlsExportMode.SingleFile;
this.gvParam.ExportToXls(saveFileDialog.FileName, options);
MessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//导出Excel
private void barBtnExport_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
//记录操作日志
LogUtils.ReviewLogManager.ReviewLog(Properties.Settings.Default.LocalUserName, String.Format("{0}-{1}", this.Text, this.barBtnExport.Caption));
var dtExport = (DataTable)this.gcDataInfo.DataSource;
if (dtExport == null || dtExport.Rows.Count < 1)
{
XtraMessageBox.Show("当前没有数据可以操作！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
this.gvDataInfo.Columns["check"].Visible = false;
var options = new XlsExportOptions()
{
TextExportMode = TextExportMode.Value, ExportMode = XlsExportMode.SingleFile
};
this.gcDataInfo.ExportToXls(saveFileDialog.FileName, options);
this.gvDataInfo.Columns["check"].Visible = true;
if (XtraMessageBox.Show("操作成功，是否打开文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("导出失败：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExportDetail_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (this.gcDetail.DataSource == null || this.gcDetail.MainView.RowCount == 0)
{
return;
}
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
saveFileDialog.FileName = "油耗参数明细";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions();
options.TextExportMode = TextExportMode.Value;
this.gcDetail.ExportToXls(saveFileDialog.FileName, options);
MessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static bool ExportData(GridControl grdDataSource, string reportName)
{
ExportForm oneForm = new ExportForm();
oneForm.ShowDialog();
if (oneForm.DialogResult != DialogResult.OK)
{
return(false);
}
string reportFile = Path.Combine(oneForm.ExportPath,
string.Format("{0}_{1}.xls", reportName, DateTime.Now.ToString("yyyyMMddHHmmss")));
XlsExportOptions options = new XlsExportOptions();
options.SheetName = reportName;
grdDataSource.ExportToXls(reportFile, options); //,DevExpress.XtraPrinting.XlsExportOptions.;
if (oneForm.IsAutoOpenPath)
{
FileInfo fi = new FileInfo(reportFile);
if (fi.Exists)
{
System.Diagnostics.Process.Start(reportFile);
}
else
{
//file doesn't exist
}
}
return(true);
}
//导出
private void btnExportDetail_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
SaveFileDialog saveFileDialog = new SaveFileDialog()
{
FileName = "油耗参数明细页面数据",
Title = "导出Excel",
Filter = "Excel文件(*.xls)|*.xls"
};
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions()
{
TextExportMode = TextExportMode.Value
};
this.gcDetail.ExportToXls(saveFileDialog.FileName, options);
MessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void barButtonItem2_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (this.gridControl1.DataSource == null)
{
return;
}
SaveFileDialog saveFileDialog = new SaveFileDialog()
{
Title = "导出Excel", Filter = "Excel文件(*.xls)|*.xls", FileName = "油耗历史变化"
};
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions()
{
TextExportMode = TextExportMode.Value
};
this.gridControl1.ExportToXls(saveFileDialog.FileName, options);
MessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private static void SetXlsOptions(XlsExportOptions xlsExportOptions, string SheetName)
{
xlsExportOptions.SheetName = string.IsNullOrEmpty(SheetName) ? "Document" : SheetName;
xlsExportOptions.ShowGridLines = true;
xlsExportOptions.TextExportMode = TextExportMode.Value;
xlsExportOptions.Suppress65536RowsWarning = true;
}
/// <summary>
/// 明细导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonDetail_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
SaveFileDialog saveFileDialog = new SaveFileDialog()
{
FileName = "明细信息",
Title = "导出Excel",
Filter = "Excel文件(*.xls)|*.xls"
};
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions();
options.SheetName = "明细";
options.ShowGridLines = false;
options.TextExportMode = TextExportMode.Value;
this.gridControl2.ExportToXls(saveFileDialog.FileName, options);
MessageBox.Show("导出成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// DevExpress通用导出Excel,支持多个控件同时导出在同一个Sheet表
/// eg:ExportToXlsx("",gridControl1,gridControl2);
/// 将gridControl1和gridControl2的数据一同导出到同一张工作表
/// </summary>
/// <param name="title">文件名</param>
/// <param name="panels">控件集</param>
public static void ExportToExcel(string title, GridControl panels)
{
var saveFileDialog = new SaveFileDialog();
saveFileDialog.FileName = title;
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx|Excel文件(*.xls)|*.xls";
DialogResult dialogResult = saveFileDialog.ShowDialog();
if (dialogResult == DialogResult.Cancel)
{
return;
}
string FileName = saveFileDialog.FileName;
var ps = new PrintingSystem();
CompositeLink link = new CompositeLink(ps);
ps.Links.Add(link);
link.Links.Add(CreatePrintableLink(panels));
link.Landscape = true;//横向
//判断是否有标题，有则设置
//link.CreateDocument(); //建立文档
try
{
int count = 1;
//在重复名称后加（序号）
while (File.Exists(FileName))
{
if (FileName.Contains(")."))
{
int start = FileName.LastIndexOf("(");
int end = FileName.LastIndexOf(").") - FileName.LastIndexOf("(") + 2;
FileName = FileName.Replace(FileName.Substring(start, end), string.Format("({0}).", count));
}
else
{
FileName = FileName.Replace(".", string.Format("({0}).", count));
}
count++;
}
if (FileName.LastIndexOf(".xlsx") >= FileName.Length - 5)
{
XlsxExportOptions options = new XlsxExportOptions();
link.ExportToXlsx(FileName, options);
}
else
{
XlsExportOptions options = new XlsExportOptions();
link.ExportToXls(FileName, options);
}
if (DevExpress.XtraEditors.XtraMessageBox.Show("保存成功，是否打开文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(FileName);//打开指定路径下的文件
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message);
}
}
private void MENUEXCEL_Click(object sender, EventArgs e)
{
try {
var grabarArchivo = new SaveFileDialog();
grabarArchivo.Filter = "Excel(xls)|*.xls";
grabarArchivo.Title = "Exportar Excel";
grabarArchivo.DefaultExt = "xls";
grabarArchivo.FileName = "";
grabarArchivo.OverwritePrompt = true;
grabarArchivo.ShowDialog();
if (grabarArchivo.FileName != "")
{
gridView1.BestFitColumns();
gridView1.OptionsPrint.AutoWidth = false;
// Saves the Image via a FileStream created by the OpenFile method.
var fs = (FileStream)grabarArchivo.OpenFile();
var options = new XlsExportOptions();
options.ShowGridLines = true;
options.UseNativeFormat = false;
gridView1.BestFitColumns();
gridView1.OptionsPrint.AutoWidth = false;
gridView1.ExportToXls(fs, options);
fs.Close();
}
} catch (Exception ex) {
Log.EscribirLog(ex.Message);
MessageBox.Show("Error al generar archivo Excel: ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void BindingPostedData(DataTable dtb, string filepath, out string fullfilename)
{
fullfilename = string.Empty;
try
{
//fullfilename = string.Format(@"{0}\\IF001-ASM-FG-{1:yyyyMMddHHmm}.XLS", filepath, DateTime.Now);
var filename = (from fileid in dtb.AsEnumerable()
select fileid.Field <string>("FILE_ID")).First <string>();
fullfilename = string.Format(@"{0}\\{1}", filepath, filename);
this.grdPostedData.DataSource = dtb;
var optXls = new XlsExportOptions()
{
SheetName = filename.Replace(".XLS", "")
};
this.grvPostedData.ExportToXls(fullfilename, optXls);
}
catch (Exception ex)
{
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
public async Task <ActionResult> XLS_NotarisDetailAll(string strFilterExpression)
{
string strFilterExp = string.Empty;
if (string.IsNullOrEmpty(strFilterExpression))
{
strFilterExp = "1 = 1";
}
else
{
strFilterExp = strFilterExpression;
}
HttpResponseMessage responseMessage = await client.GetAsync(string.Format("{0}/XLS_NotarisDetailAll/{1}", url, strFilterExp));
if (responseMessage.IsSuccessStatusCode)
{
var responseData = responseMessage.Content.ReadAsStringAsync().Result;
var myData = JsonConvert.DeserializeObject <IEnumerable <vwNotarisTabular> >(responseData);
XlsExportOptions xlsOption = new XlsExportOptions();
GridViewExtension.WriteXlsToResponse(GridSettingHelper.XLS_NotarisDetailAll(strFilterExp), myData, "XLS_NotarisDetailAll", xlsOption);
return(new EmptyResult());
}
return(View("Error"));
}
public async Task <ActionResult> XLS_ListRekanan(string strFilterExpression)
{
string strFilterExp = string.Empty;
if (string.IsNullOrEmpty(strFilterExpression))
{
strFilterExp = "1 = 1";
}
else
{
strFilterExp = strFilterExpression;
}
HttpResponseMessage responseMessage = await client.GetAsync(string.Format("{0}/XLS_RekByIdSupervisor/{1}/{2}", url, tokenContainer.SupervisorId.ToString(), strFilterExp));
if (responseMessage.IsSuccessStatusCode)
{
var responseData = responseMessage.Content.ReadAsStringAsync().Result;
var myData = JsonConvert.DeserializeObject <IEnumerable <fXLS_RekByIdSupervisor_Result> >(responseData);
XlsExportOptions xlsOption = new XlsExportOptions();
GridViewExtension.WriteXlsToResponse(GridSettingHelper.XLS_DaftarRekanan(strFilterExp), myData, "XLSRekanan", xlsOption);
return(new EmptyResult());
}
return(View("Error"));
}
protected void mnuPrincipal_ItemClick(object source, MenuItemEventArgs e)
{
try
{
switch (e.Item.Name)
{
case "btnExport":
{
ASPxGridViewExporter1.GridViewID = "gv";
XlsExportOptions xlsOpciones = new XlsExportOptions(TextExportMode.Text, true, false);
ASPxGridViewExporter1.DataBind();
ASPxGridViewExporter1.WriteXlsToResponse(xlsOpciones);
break;
}
case "btnLimpiar":
{
gv.DataSource = null;
gv.DataBind();
mnuPrincipal.Items[0].Enabled = false;
break;
}
default: break;
}
}
catch (Exception ex)
{
string a = ex.Message;
}
}
// 导出Vin
private void btnExport_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog saveFileDialog = new SaveFileDialog()
{
FileName = "VIN明细页面数据",
Title = "导出Excel",
Filter = "Excel文件(*.xls)|*.xls"
};
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions()
{
TextExportMode = TextExportMode.Value
};
this.gcVinData.ExportToXls(saveFileDialog.FileName, options);
if (MessageBox.Show("保存成功，是否打开文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static List <DefinisanaStampa> VratiStampePredmetaSaRokom(UlogovaniKorisnik korisnik, List <PredmetSaRokom> stavke)
{
var zaglavlje = new PregledPredmetaSaRokomZaglavlje {
Stavke = stavke
};
var dir = Directory.CreateDirectory(PutanjaAplikacije.PutanjaReportPregledPredmetaSaRokom);
var stampe = new List <DefinisanaStampa>();
var guid = Guid.NewGuid().ToString();
foreach (var file in dir.GetFiles())
{
var stampa = new DefinisanaStampa {
Naziv = file.Name.TrimEnd(".repx".ToArray())
};
stampa.Link = string.Format("{0}/{1}/{2}.pdf", PutanjaAplikacije.PutanjaStampeWeb, guid, stampa.Naziv);
var report = new PregledPredmetaSaRokomReport();
report.LoadLayout(file.FullName);
report.PostaviPodatke(zaglavlje);
report.CreateDocument();
if (!Directory.Exists(string.Format("{0}{1}", PutanjaAplikacije.PutanjaStampe, guid)))
{
Directory.CreateDirectory(string.Format("{0}{1}", PutanjaAplikacije.PutanjaStampe, guid));
}
report.ExportToPdf(string.Format("{0}{1}\\{2}.pdf", PutanjaAplikacije.PutanjaStampe, guid, stampa.Naziv));
var opt = new XlsExportOptions {
ShowGridLines = true
};
report.ExportToXls(string.Format("{0}{1}\\{2}.xls", PutanjaAplikacije.PutanjaStampe, guid, stampa.Naziv), opt);
stampe.Add(stampa);
}
return(stampe);
}
public static void ExportToExcel(string title, params IPrintable[] panels)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.FileName = title;
saveFileDialog.Title = string.Format("{0} Excel", UnitField.Export);
saveFileDialog.Filter = "Excel (*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
{
return;
}
string text = saveFileDialog.FileName;
PrintingSystem expr_43 = new PrintingSystem();
CompositeLink compositeLink = new CompositeLink(expr_43);
expr_43.Links.Add(compositeLink);
for (int i = 0; i < panels.Length; i++)
{
IPrintable printable = panels[i];
compositeLink.Links.Add(ExportToExcelHelper.CreatePrintableLink(printable));
}
compositeLink.Landscape = true;
try
{
int num = 1;
while (File.Exists(text))
{
if (text.Contains(")."))
{
int startIndex = text.LastIndexOf("(", StringComparison.Ordinal);
int length = text.LastIndexOf(").", StringComparison.Ordinal) - text.LastIndexOf("(", StringComparison.Ordinal) + 2;
text = text.Replace(text.Substring(startIndex, length), string.Format("({0}).", num));
}
else
{
text = text.Replace(".", string.Format("({0}).", num));
}
num++;
}
if (text.LastIndexOf(".xlsx", StringComparison.Ordinal) >= text.Length - 5)
{
XlsxExportOptions options = new XlsxExportOptions();
compositeLink.ExportToXlsx(text, options);
}
else
{
XlsExportOptions options2 = new XlsExportOptions();
compositeLink.ExportToXls(text, options2);
}
if (XtraMessageBox.Show(UnitField.ExportOK, UnitField.SystemMessage, MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
{
Process.Start(text);
}
}
catch (Exception arg_16F_0)
{
XtraMessageBox.Show(arg_16F_0.Message);
}
}
public static List <DefinisanaStampa> VratiStampeAktivnihPredmeta(UlogovaniKorisnik korisnik, DateTime datum, AktivniPredmetiViewModel vm)
{
var dir = Directory.CreateDirectory(PutanjaAplikacije.PutanjaReportPregledAktivnihPredmeta);
var stampe = new List <DefinisanaStampa>();
var guid = Guid.NewGuid().ToString();
var zaglavlje = new PregledAktivnihPredmetaZaglavlje
{
Datum = datum,
NazivUstanove = DmsData.Naziv,
};
//var vm = VratiAktivnePredmete(korisnik, datum);
if (vm != null)
{
zaglavlje.NazivKolone1 = vm.NazivKolone1;
zaglavlje.NazivKolone2 = vm.NazivKolone2;
zaglavlje.NazivKolone3 = vm.NazivKolone3;
zaglavlje.NazivKolone4 = vm.NazivKolone4;
zaglavlje.NazivKolone5 = vm.NazivKolone5;
zaglavlje.NazivKolone6 = vm.NazivKolone6;
zaglavlje.NazivKolone7 = vm.NazivKolone7;
zaglavlje.NazivKolone8 = vm.NazivKolone8;
zaglavlje.NazivKolone9 = vm.NazivKolone9;
zaglavlje.NazivKolone10 = vm.NazivKolone10;
zaglavlje.NazivKolone11 = vm.NazivKolone11;
if (vm.AktivniPredmeti != null && vm.AktivniPredmeti.Count > 0)
{
zaglavlje.Predmeti.AddRange(vm.AktivniPredmeti);
}
}
foreach (var file in dir.GetFiles())
{
var stampa = new DefinisanaStampa();
stampa.Naziv = file.Name.TrimEnd(".repx".ToArray());
stampa.Link = string.Format("{0}/{1}/{2}.pdf", PutanjaAplikacije.PutanjaStampeWeb, guid, stampa.Naziv);
var report = new PregledAktivnihPredmetaReport();
report.LoadLayout(file.FullName);
report.PostaviPodatke(zaglavlje);
report.CreateDocument();
if (!Directory.Exists(string.Format("{0}{1}", PutanjaAplikacije.PutanjaStampe, guid)))
{
Directory.CreateDirectory(string.Format("{0}{1}", PutanjaAplikacije.PutanjaStampe, guid));
}
report.ExportToPdf(string.Format("{0}{1}\\{2}.pdf", PutanjaAplikacije.PutanjaStampe, guid, stampa.Naziv));
var opt = new XlsExportOptions();
opt.ShowGridLines = true;
report.ExportToXls(string.Format("{0}{1}\\{2}.xls", PutanjaAplikacije.PutanjaStampe, guid, stampa.Naziv), opt);
stampe.Add(stampa);
}
return(stampe);
}
public static List <DefinisanaStampa> VratiStampePrimopredajnogZapisnika(UlogovaniKorisnik korisnik, short?idOrgana, short?idKlase, string oznakaKlase, short?idJedinice, string oznakaJedinice, DateTime datum, int?idKreatora, string nazivOrgana, string nazivKlase, string nazivJedinice, string nazivKreatora, bool samoArhiviran)
{
DirectoryInfo dir = null;
if (samoArhiviran)
{
dir = Directory.CreateDirectory(PutanjaAplikacije.PutanjaReportPregledZapisnikaArhivirani);
}
else
{
dir = Directory.CreateDirectory(PutanjaAplikacije.PutanjaReportPregledZapisnika);
}
var stampe = new List <DefinisanaStampa>();
var guid = Guid.NewGuid().ToString();
var zaglavlje = new PregledPretrazenihPredmetaZaglavlje
{
Datum = datum,
NazivJedinice = nazivJedinice,
NazivKlase = nazivKlase,
NazivKreatora = nazivKreatora,
NazivOrgana = nazivOrgana
};
var predmeti = VratiPredmetePretrage(korisnik, idOrgana, idKlase, oznakaKlase, idJedinice, oznakaJedinice, datum, idKreatora, samoArhiviran);
if (predmeti.Count > 0)
{
zaglavlje.Predmeti.AddRange(predmeti);
}
foreach (var file in dir.GetFiles())
{
var stampa = new DefinisanaStampa();
stampa.Naziv = file.Name.TrimEnd(".repx".ToArray());
stampa.Link = string.Format("{0}/{1}/{2}.pdf", PutanjaAplikacije.PutanjaStampeWeb, guid, stampa.Naziv);
var report = new PregledPretrazenihPredmetaReport();
report.LoadLayout(file.FullName);
report.PostaviPodatke(zaglavlje);
report.CreateDocument();
if (!Directory.Exists(string.Format("{0}{1}", PutanjaAplikacije.PutanjaStampe, guid)))
{
Directory.CreateDirectory(string.Format("{0}{1}", PutanjaAplikacije.PutanjaStampe, guid));
}
report.ExportToPdf(string.Format("{0}{1}\\{2}.pdf", PutanjaAplikacije.PutanjaStampe, guid, stampa.Naziv));
var opt = new XlsExportOptions();
opt.ShowGridLines = true;
report.ExportToXls(string.Format("{0}{1}\\{2}.xls", PutanjaAplikacije.PutanjaStampe, guid, stampa.Naziv), opt);
stampe.Add(stampa);
}
return(stampe);
}
/// <summary>
/// 导出为EXCEL。
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExportExcel_Click(object sender, EventArgs e)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "Excel文件(*.xls)|*.xls";
dlg.FilterIndex = 1;
dlg.RestoreDirectory = true;
if (dlg.ShowDialog() == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions();
this.gvLot.ExportToXls(dlg.FileName, options);
}
}
private void ExportToEx(string filename, string ext)
{
try
{
this.VisibleColumnNoExport(false);
this.printSystem = new PrintingSystem();
this.printCompageLink = new PrintableComponentLink(this.printSystem)
{
Component = this._exportView.GridControl
};
//this.printCompageLink.RtfReportFooter = "1234";
this.printCompageLink.CreateDocument();
//if (this.waitDialog != null)
// this.waitDialog.SetCaption("Exporting Data ...");
switch (ext.ToUpper())
{
case "XLS":
var optXls = new XlsExportOptions()
{
SheetName = (string.IsNullOrEmpty(_sheetName) ? "Sheet1" : _sheetName)
};
this.printCompageLink.PrintingSystem.ExportToXls(filename, optXls);
break;
case "XLSX":
var optXlsx = new XlsxExportOptions()
{
SheetName = (string.IsNullOrEmpty(_sheetName) ? "Sheet1" : _sheetName)
};
this.printCompageLink.PrintingSystem.ExportToXlsx(filename, optXlsx);
break;
default:
break;
}
this.VisibleColumnNoExport(true);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void outport_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions();
gridView3.ExportToXls(saveFileDialog.FileName, options);
DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
protected virtual void CustomExport(object sender, CustomExportEventArgs e)
{
//Customize Export Options
if (e.ExportTarget == ExportTarget.Xls)
{
XlsExportOptions options = (XlsExportOptions)e.ExportOptions;
if (options == null)
{
options = new XlsExportOptions();
}
options.SheetName = View.Caption;
options.ShowGridLines = true;
e.ExportOptions = options;
}
}
/// <summary>
/// 导出方法
/// </summary>
public void ExportExcel(GridControl gridCtrl)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
XlsExportOptions options = new XlsExportOptions();
gridCtrl.ExportToXls(saveFileDialog.FileName, options);
DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 导出Excel(xls)
/// </summary>
/// <param name="gv"></param>
private static void ExportXls(GridView gv)
{
var saveFileDialog = new SaveFileDialog {
FileName = DateTime.Now.ToString(BaseSystemInfo.DateFormat) + "打印数据", Title = @"导出Excel", Filter = @"Excel文件(*.xls)|*.xls", OverwritePrompt = false
}; //已存在文件是否覆盖提示
var dialogResult = saveFileDialog.ShowDialog();
if (dialogResult != DialogResult.OK)
{
return;
}
while (System.IO.File.Exists(saveFileDialog.FileName) && XtraMessageBox.Show("该文件名已存在，是否覆盖？", AppMessage.MSG0000, MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
if (dialogResult != DialogResult.Yes)
{
return;
}
}
if (string.IsNullOrEmpty(saveFileDialog.FileName))
{
return;
}
try
{
var options = new XlsExportOptions
{
// Excel 导出Sheet名称
SheetName = string.Format("{0}商家的打印数据-{1}", BaseSystemInfo.UserInfo.NickName, DateTime.Now.ToString(BaseSystemInfo.DateTimeFormat)),
TextExportMode = TextExportMode.Text,
ShowGridLines = true
};
if (gv.Columns.ColumnByFieldName("Check") != null)
{
gv.Columns["Check"].Visible = false;
}
gv.ExportToXls(saveFileDialog.FileName, options);
if (gv.Columns.ColumnByFieldName("Check") != null)
{
gv.Columns["Check"].Visible = true;
}
// ExcelHelper.SetAutoFilter(saveFileDialog.FileName);
OpenFile(saveFileDialog.FileName);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message.Contains("正由另一进程使用") ? "数据导出失败！文件正由另一个程序占用！" :ex.Message, AppMessage.MSG0000);
}
}
internal static void Export(string fileName, XlsExportOptions xlsExportOptions)
{
XtraReport1 report = new XtraReport1();
nwindDataSet ds = new nwindDataSet();
nwindDataSetTableAdapters.CategoriesTableAdapter cta = new WindowsApplication1.nwindDataSetTableAdapters.CategoriesTableAdapter();
cta.Fill(ds.Categories);
report.Category.Value = ds.Categories[0].CategoryID;
report.PrintingSystem.ExportOptions.PrintPreview.ShowOptionsBeforeExport = false;
report.CreateDocument();
report.ExportToXls(fileName, xlsExportOptions);
Excel.Application ObjExcel = new Excel.Application();
Workbook ObjWorkBookGeneral;
Worksheet ObjWorkSheet;
Workbook ObjWorkBookTemp = ObjExcel.Workbooks.Open(Environment.CurrentDirectory + "\\" + fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
ObjWorkBookGeneral = ObjExcel.Workbooks.Open(Environment.CurrentDirectory + "\\" + fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
((Worksheet)ObjWorkBookGeneral.Sheets[1]).Name = ds.Categories[0].Description.Length > 30 ? ds.Categories[0].Description.Substring(0, 30) : ds.Categories[0].Description;
bool isObjWorkBookTempClosed = false;
try {
for (int i = 1; i < ds.Categories.Count; i++)
{
report.Category.Value = ds.Categories[i].CategoryID;
report.CreateDocument();
report.ExportToXls("temp_" + fileName + ".xls");
ObjWorkBookTemp = ObjExcel.Workbooks.Open(Environment.CurrentDirectory + "\\temp_" + fileName + ".xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
isObjWorkBookTempClosed = false;
ObjWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)ObjWorkBookTemp.Sheets[1];
ObjWorkSheet.Name = ds.Categories[i].Description.Length > 30 ? ds.Categories[i].Description.Substring(0, 30) : ds.Categories[i].Description;
ObjWorkSheet.Copy(Type.Missing, ObjWorkBookGeneral.Sheets[ObjWorkBookGeneral.Sheets.Count]);
ObjWorkBookTemp.Close(Microsoft.Office.Interop.Excel.XlSaveAction.xlSaveChanges, Type.Missing, Type.Missing);
isObjWorkBookTempClosed = true;
}
} finally {
if (!isObjWorkBookTempClosed)
{
ObjWorkBookTemp.Close(Microsoft.Office.Interop.Excel.XlSaveAction.xlSaveChanges, Type.Missing, Type.Missing);
}
ObjWorkBookGeneral.Close(Microsoft.Office.Interop.Excel.XlSaveAction.xlSaveChanges, Type.Missing, Type.Missing);
ObjExcel.Quit();
File.Delete(Environment.CurrentDirectory + "\\temp_" + fileName + ".xls");
}
}
private void btnCustomerExport_ItemClick(object sender, ItemClickEventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel|.xls";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
string fileName = saveFileDialog.FileName;
XlsExportOptions options = new XlsExportOptions(TextExportMode.Value, true, true);
try
{
gridViewFrontRecord.ExportToXls(fileName, options);
}
catch (Exception ex)
{
XtraMessageBox.Show(string.Format("保存失败：{0}", ex.ToString()), "保存失败", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
public static void ExportXLS(GridControl grid, string tenBaoCao, string FileName)
{
#region Thiết kế trước khi in
if(grid != null)
{
GridView view = grid.MainView as GridView;
if(view != null)
{
//view.AppearancePrint.EvenRow.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.EvenRow.Options.UseFont = true;
//view.AppearancePrint.FilterPanel.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.FilterPanel.Options.UseFont = true;
//view.AppearancePrint.FooterPanel.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.FooterPanel.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.FooterPanel.Options.UseBorderColor = true;
//view.AppearancePrint.FooterPanel.Options.UseFont = true;
//view.AppearancePrint.GroupFooter.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.GroupFooter.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.GroupFooter.Options.UseBorderColor = true;
//view.AppearancePrint.GroupFooter.Options.UseFont = true;
//view.AppearancePrint.GroupRow.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.GroupRow.Font = new System.Drawing.Font("Times New Roman", 11F, System.Drawing.FontStyle.Bold);
//view.AppearancePrint.GroupRow.Options.UseBorderColor = true;
//view.AppearancePrint.GroupRow.Options.UseFont = true;
//view.AppearancePrint.HeaderPanel.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.HeaderPanel.Font = new System.Drawing.Font("Times New Roman", 11F, System.Drawing.FontStyle.Bold);
//view.AppearancePrint.HeaderPanel.Options.UseBorderColor = true;
//view.AppearancePrint.HeaderPanel.Options.UseFont = true;
//view.AppearancePrint.HeaderPanel.Options.UseTextOptions = true;
//view.AppearancePrint.HeaderPanel.Options.UseBackColor = true;
//view.AppearancePrint.HeaderPanel.BackColor = Color.FromArgb(192, 255, 255);
//view.AppearancePrint.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//view.AppearancePrint.HeaderPanel.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
//view.AppearancePrint.Lines.BackColor = System.Drawing.Color.Black;
//view.AppearancePrint.Lines.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.Lines.Options.UseBackColor = true;
//view.AppearancePrint.Lines.Options.UseFont = true;
//view.AppearancePrint.OddRow.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.OddRow.Options.UseFont = true;
//view.AppearancePrint.Preview.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.Preview.Options.UseFont = true;
//view.AppearancePrint.Row.BorderColor = System.Drawing.Color.Black;
//view.AppearancePrint.Row.Font = new System.Drawing.Font("Times New Roman", 11F);
//view.AppearancePrint.Row.Options.UseBorderColor = true;
//view.AppearancePrint.Row.Options.UseFont = true;
//view.AppearancePrint.EvenRow.BackColor = Color.MintCream;
//view.OptionsPrint.EnableAppearanceEvenRow = true;
}
}
#endregion
var r = new rptCommon();
r.m_lbl_ten_bao_cao.Text = tenBaoCao.ToUpper();
//r.PaperKind = System.Drawing.Printing.PaperKind.A4;
//r.Landscape = true;
//r.TenCoSo = "Khách sạn Sao Mai"; // tu tu tính
//r.DiaChi = "384 Nguyễn Văn Linh, Dư Hàng Kênh – Lê Chân – Hải Phòng"; // tu tu tinh
r.Bands[BandKind.Detail].Controls.Add(CopyGridControl(grid));
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "xls files (*.xls)|*.xls|All files (*.*)|*.*";
saveFileDialog1.RestoreDirectory = true;
saveFileDialog1.FileName = FileName;
if(saveFileDialog1.ShowDialog() == DialogResult.OK)
{
XlsExportOptions opt = new XlsExportOptions();
opt.TextExportMode = TextExportMode.Value;
r.ExportToXls(saveFileDialog1.FileName, opt);
XtraMessageBox.Show("Xuất báo cáo thành công!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void MenuExportar_Click(object sender, EventArgs e)
{
try
{
var grabarArchivo = new SaveFileDialog();
grabarArchivo.Filter = "Excel(xls)|*.xls";
grabarArchivo.Title = "Exportar Excel";
grabarArchivo.DefaultExt = "xls";
grabarArchivo.FileName = "";
grabarArchivo.OverwritePrompt = true;
grabarArchivo.ShowDialog();
if (grabarArchivo.FileName != "")
{
// Saves the Image via a FileStream created by the OpenFile method.
var fs = (FileStream)grabarArchivo.OpenFile();
var options = new XlsExportOptions();
options.ShowGridLines = true;
options.UseNativeFormat = false;
gridView1.BestFitColumns();
gridView1.OptionsPrint.AutoWidth = false;
gridView1.ExportToXls(fs, options);
fs.Close();
}
}
catch (Exception ex)
{
Log.EscribirLog(ex.Message);
MessageBox.Show("Error al generar archivo Excel: ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void xuat_excel()
{
XlsExportOptions opt = new XlsExportOptions();
opt.SheetName = "NHAP_LIEU";
opt.TextExportMode = TextExportMode.Value;
string path = WinFormControls.saveFileDialog("DANH_SACH_NHAN_VIEN");
if (!String.IsNullOrEmpty(path))
{
m_grv.ExportToXls(path, opt);
var excel = new Microsoft.Office.Interop.Excel.Application();
excel.Visible = true;
Microsoft.Office.Interop.Excel.Workbooks books = excel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook openexcel = books.Open(path);
}
}
protected void mnuPrincipal_ItemClick(object source, MenuItemEventArgs e)
{
try
{
switch (e.Item.Name)
{
case "btnExport":
{
ASPxGridViewExporter1.GridViewID = "gv";
XlsExportOptions xlsOpciones = new XlsExportOptions(TextExportMode.Text, true, false);
ASPxGridViewExporter1.DataBind();
ASPxGridViewExporter1.WriteXlsToResponse(xlsOpciones);
break;
}
case "btnLimpiar":
{
gv.DataSource = null;
gv.DataBind();
mnuPrincipal.Items[0].Enabled = false;
break;
}
default: break;
}
}
catch (Exception ex)
{
string a = ex.Message;
}
}
protected void mnuPrincipal_ItemClick(object source, MenuItemEventArgs e)
{
try
{
switch (e.Item.Name)
{
case "btnExport":
{
ASPxGridViewExporter1.GridViewID = "gv";
gv.DataSource = Tabla;
ASPxGridViewExporter1.DataBind();
if (ASPxGridViewExporter1 != null)
{
XlsExportOptions xlsExportOptions = new XlsExportOptions(TextExportMode.Text, true, false);
string Titulo = ucEstado.Text.Trim() + " - " + ucOrigen.Text.Trim() + " " + deAnoMes.Text;
xlsExportOptions.SheetName = Titulo;
ASPxGridViewExporter1.WriteXlsToResponse(xlsExportOptions);
}
break;
}
case "btnLimpiar":
{
gv.DataSource = null;
gv.DataBind();
break;
}
default: break;
}
}
catch(Exception ex)
{
}
}
public void ExportUsers()
{
using (var dialog = new SaveFileDialog())
{
dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
dialog.FileName = string.Format("InactiveUsers({0}).xls", DateTime.Now.ToString("MMddyy-hmmtt"));
dialog.Filter = "Excel files|*.xls";
dialog.Title = "Export Inactive Users";
if (dialog.ShowDialog() == DialogResult.OK)
{
gridColumnUsersSelected.Visible = false;
var options = new XlsExportOptions();
options.SheetName = Path.GetFileNameWithoutExtension(dialog.FileName);
options.TextExportMode = TextExportMode.Text;
options.ExportHyperlinks = true;
options.ShowGridLines = true;
options.ExportMode = XlsExportMode.SingleFile;
printableComponentLink.CreateDocument();
printableComponentLink.PrintingSystem.ExportToXls(dialog.FileName, options);
gridColumnUsersSelected.Visible = true;
if (File.Exists(dialog.FileName))
Process.Start(dialog.FileName);
}
}
}
protected void mnuPrincipal_ItemClick(object source, MenuItemEventArgs e)
{
switch (e.Item.Name)
{
case "btnQuerySKU":
QuerySKU();
break;
case "btnOP":
if (gvHome.Selection.Count == 1)
{
string Pauta = string.Empty;
Pauta = "OP CERTIFICADO " + gvHome.GetSelectedFieldValues("año")[0].ToString() + gvHome.GetSelectedFieldValues("mes")[0].ToString() + " " + gvHome.GetSelectedFieldValues("IdentifEspacio")[0].ToString() + " - " + gvHome.GetSelectedFieldValues("IdentifOrigen")[0].ToString();
string filename = Pauta + System.DateTime.Now.Hour.ToString().PadLeft(2, '0') +
System.DateTime.Now.Minute.ToString().PadLeft(2, '0') +
System.DateTime.Now.Second.ToString().PadLeft(2, '0') + ".xlsx";
TextBox1.Text = Server.MapPath("~/Excel/");
switch (TextBox1.Text)
{
case "": { break; }
default:
{
try
{
System.IO.FileInfo fileinfo = new FileInfo(@TextBox1.Text);
bool dExiste = fileinfo.Directory.Exists;
if (dExiste)
{
lblErrorLineas.Text = "";
string[] dirs = Directory.GetFiles(@TextBox1.Text);
if (dirs.Length > 0)
{
filename = @TextBox1.Text + filename;
dExiste = false;
for (int i = 0; i <= dirs.Length - 1; i++)
{
if (dirs[i].ToString() == filename)
{
dExiste = true;
break;
}
}
}
if (dExiste == false)
{
//ACA VA LA LLAMADA A LA FUNCION DEL HELPER
// ES EL CORE, YA TENEMOS EL NOMBRE DE ARCHIVO Y LA RUTA
CertificadoCabDTO Cabecera = Certificados.Read( gvHome.GetSelectedFieldValues("PautaId")[0].ToString(),gvHome.GetSelectedFieldValues("IdentifOrigen")[0].ToString());
List<CertificadoDetDTO> Detalle = Certificados.ReadAllLineas(Cabecera);
List<CertificadoSKUDTO> SKUS = Certificados.GetSKUs(Cabecera.PautaId,Cabecera.IdentifOrigen);
EspacioContDTO Espacio = CRUDHelper.Read(string.Format("IdentifEspacio = '{0}'", Cabecera.IdentifEspacio), BusinessMapper.GetDaoByEntity(BusinessMapper.eEntities.EspacioCont));
csOP_Helper Helper = new csOP_Helper("CERTIFICADO", "", CertificadoCab.PautaId,Cabecera, Detalle, SKUS, Espacio,filename);
System.IO.FileInfo toDownload = new FileInfo(filename);
if (toDownload.Exists == true)
{
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" + toDownload.Name);
Response.AddHeader("Content-Length", toDownload.Length.ToString());
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml";
Response.WriteFile(filename);
Response.End();
}
}
}
}
catch (Exception ex)
{
string a = string.Empty;
a = ex.Message;
lblErrorLineas.Text = "Ruta no válida.";
}
break;
}
}
}
else
{
lblErrorHome.Text = "Debe seleccionar una línea";
}
break;
case "btnCost":
Business.Certificados.CalcularCosto(CertificadoCab, Costos, mycert, ((Accendo)this.Master).Usuario.UserName);
lblErrorLineas.Text = "Se calculo correctamente";
break;
case "btnExport":
case "btnExportXls":
{
if (ASPxGridViewExporter1 != null)
{
XlsExportOptions xlsExportOptions = new XlsExportOptions(TextExportMode.Text, true, false);
ASPxGridViewExporter1.WriteXlsToResponse(xlsExportOptions);
}
break;
}
case "btnExportPdf":
if (ASPxGridViewExporter1 != null)
ASPxGridViewExporter1.WritePdfToResponse();
break;
default: break;
}
}
public ActionResult ExportTo(string statgridid, int categoryid)
{
string categoryname = categoryid != 0
? _categoryRepostitory.Find(categoryid).Name
: _stateCategoryRepostitory.Find(statgridid).Name;
var settings = (PivotGridSettings)Session["Setting"];
var options = new XlsExportOptions
{
SheetName = categoryname + "管控节点进度汇总表",
ExportMode = XlsExportMode.SingleFile,
TextExportMode = TextExportMode.Text
};
//var output = new MemoryStream();
var filename = "嘉定供电公司" + categoryname + "项目全要素管控系统节点进度汇总统计表.xls";
return PivotGridExtension.ExportToXls(settings, GetLogsModel(statgridid, categoryid),filename, true,options);
}
public void ExportToXls(Stream stream, XlsExportOptions options)
{
report.ExportToXls(stream, options);
}
