/// <summary> /// 把ResourcesTree内容保存到Excel中 /// </summary> public static void SaveResourcesTreeExportToExcel(DevExpress.XtraScheduler.UI.ResourcesTree reTree) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "Excel files (*.xlsx)|*.xlsx"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; //dlg.Title = "保存为Excel文件"; dlg.Title = new FileHandler().f.tsmiBcwexc.Text; if (dlg.ShowDialog() == DialogResult.OK) { string fileName = dlg.FileName; reTree.ExportToXlsx(fileName); //MessageHandler.ShowMessageBox("导出成功"); MessageHandler.ShowMessageBox(new FileHandler().f.tsmiDccg.Text); } }
/// <summary> /// 把TreeList内容保存到Excel中 /// </summary> /// <param name="TL">TreeList控件</param> public static void SaveTreeListControlExportToExcel(DevExpress.XtraTreeList.TreeList TL) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "Excel files (*.xlsx)|*.xlsx"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; //dlg.Title = "保存为Excel文件"; dlg.Title = new FileHandler().f.tsmiBcwexc.Text; if (dlg.ShowDialog() == DialogResult.OK) { string fileName = dlg.FileName; //GV.ExportToExcelOld(Filename); TL.ExportToXlsx(fileName); //MessageHandler.ShowMessageBox("导出成功"); MessageHandler.ShowMessageBox(new FileHandler().f.tsmiDccg.Text); } }
/// <summary> /// 把DataGridView内容保存到Excel中 /// </summary> /// <param name="dgv">DataGridView控件</param> public void SaveDataGridViewExportToExcel(DataGridView dgv) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "Excel files (*.xls)|*.xls"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; //dlg.CreatePrompt = true; //dlg.Title = "保存为Excel文件"; dlg.Title = f.tsmiBcwexc.Text; if (dlg.ShowDialog() == DialogResult.OK) { Stream myStream; myStream = dlg.OpenFile(); StreamWriter sw = new StreamWriter(myStream, Encoding.GetEncoding("gb2312")); string columnTitle = ""; try { //写入列标题 for (int i = 0; i < dgv.ColumnCount; i++) { if (dgv.Columns[i].Visible) { columnTitle += dgv.Columns[i].HeaderText; columnTitle += "\t"; } } columnTitle = columnTitle.Substring(0, columnTitle.Length - 1); sw.WriteLine(columnTitle); //写入内容 for (int j = 0; j < dgv.Rows.Count; j++) { string columnValue = ""; for (int k = 0; k < dgv.Columns.Count; k++) { if (dgv.Columns[k].Visible) { if (dgv.Rows[j].Cells[k].Value == null) { columnValue += ""; } else { columnValue += dgv.Rows[j].Cells[k].Value.ToString().Trim(); } columnValue += "\t"; } } columnValue = columnValue.Substring(0, columnValue.Length - 1); sw.WriteLine(columnValue); } //MessageHandler.ShowMessageBox("导出成功"); MessageHandler.ShowMessageBox(f.tsmiDccg.Text); } finally { sw.Close(); myStream.Close(); } } }
/// <summary> /// 处理异常方法 /// </summary> /// <param name="exceptionText">异常信息文本</param> /// <param name="exception">异常实例</param> public static void HandleException(string exceptionText, Exception exception) { //MessageHandler.ShowMessageBox(exceptionText + " 错误信息:" + exception.Message); MessageHandler.ShowMessageBox(exceptionText + f.tsmiCwxx.Text + exception.Message); new ExceptionHandler().OutputLog(exceptionText, exception); }
/// <summary> /// 处理报表打印 /// </summary> /// <param name="tableNameStr">数据表名</param> /// <param name="bindingDataSet">绑定的DataSet</param> /// <param name="paraList">参数列表</param> /// <param name="handleType">处理类型:1 预览 2 打印 3 设计</param> public void XtraReport_Handle(string tableNameStr, DataSet bindingDataSet, List <Parameter> paraList, int handleType) { FrmDocumentTempletDAO docDAO = new FrmDocumentTempletDAO(); DataTable docTempletTable = docDAO.QueryDocTemplet(tableNameStr); if (docTempletTable.Rows.Count == 0) { //MessageHandler.ShowMessageBox("未查询到当前单据模板的信息记录,操作错误。"); MessageHandler.ShowMessageBox(f.tsmiWcxddq.Text); return; } string path = DataTypeConvert.GetString(docTempletTable.Rows[0]["DocPath"]) + DataTypeConvert.GetString(docTempletTable.Rows[0]["DocFileName"]); string docVerStr = DataTypeConvert.GetString(docTempletTable.Rows[0]["DocVersion"]); string iniPath = System.Windows.Forms.Application.StartupPath + "\\Report\\DocTemplet.ini"; string sectionStr = "DocTemplet"; FileHandler fileHandler = new FileHandler(); if (File.Exists(path)) { if (File.Exists(iniPath)) { string localVerStr = fileHandler.IniReadValue(iniPath, sectionStr, tableNameStr); if (localVerStr != docVerStr && handleType != 3) { Byte[] fileByte = docDAO.QueryDocTemplet_FileByte(tableNameStr); fileHandler.ByteArrayToFile(fileByte, path); fileHandler.IniWriteValue(iniPath, sectionStr, tableNameStr, docVerStr); } } else { Byte[] fileByte = docDAO.QueryDocTemplet_FileByte(tableNameStr); fileHandler.ByteArrayToFile(fileByte, path); fileHandler.IniWriteValue(iniPath, sectionStr, tableNameStr, docVerStr); } } else { Byte[] fileByte = docDAO.QueryDocTemplet_FileByte(tableNameStr); fileHandler.ByteArrayToFile(fileByte, path); fileHandler.IniWriteValue(iniPath, sectionStr, tableNameStr, docVerStr); } XtraReport report = new XtraReport(); report.LoadLayout(path); report.DataSource = bindingDataSet; if (paraList != null) { foreach (Parameter para in paraList) { try { report.Parameters[para.Name].Value = para.Value; } catch { report.Parameters.Add(para); } } } report.RequestParameters = false; report.CreateDocument(); ReportPrintTool rptPrintTool = new ReportPrintTool(report); PrintingSystemBase prtSysBase = rptPrintTool.PrintingSystem; prtSysBase.SetCommandVisibility(new PrintingSystemCommand[] { //PrintingSystemCommand.Background, //PrintingSystemCommand.ClosePreview, //PrintingSystemCommand.Customize, //PrintingSystemCommand.DocumentMap, //PrintingSystemCommand.EditPageHF, //PrintingSystemCommand.ExportCsv, //PrintingSystemCommand.ExportFile, //PrintingSystemCommand.ExportGraphic, //PrintingSystemCommand.ExportHtm, //PrintingSystemCommand.ExportMht, //PrintingSystemCommand.ExportPdf, //PrintingSystemCommand.ExportRtf, //PrintingSystemCommand.ExportTxt, //PrintingSystemCommand.ExportXls, //PrintingSystemCommand.ExportXlsx, //PrintingSystemCommand.ExportXps, //PrintingSystemCommand.File, //PrintingSystemCommand.FillBackground , //PrintingSystemCommand.Find, //PrintingSystemCommand.HandTool, //PrintingSystemCommand.Magnifier, //PrintingSystemCommand.MultiplePages, //PrintingSystemCommand.Open, //PrintingSystemCommand.PageLayout, //PrintingSystemCommand.PageLayoutContinuous, //PrintingSystemCommand.PageMargins, //PrintingSystemCommand.PageOrientation, //PrintingSystemCommand.PageSetup, //PrintingSystemCommand.PaperSize, PrintingSystemCommand.Parameters, //PrintingSystemCommand.Pointer, //PrintingSystemCommand.Print, //PrintingSystemCommand.PrintDirect , //PrintingSystemCommand.Save, //PrintingSystemCommand.SendCsv, //PrintingSystemCommand.SendFile, //PrintingSystemCommand.SendGraphic, //PrintingSystemCommand.SendMht, //PrintingSystemCommand.SendPdf, //PrintingSystemCommand.SendRtf, //PrintingSystemCommand.SendTxt, //PrintingSystemCommand.SendXls, //PrintingSystemCommand.SendXlsx, //PrintingSystemCommand.SendXps, PrintingSystemCommand.SubmitParameters, //PrintingSystemCommand.View, //PrintingSystemCommand.Watermark }, DevExpress.XtraPrinting.CommandVisibility.None); switch (handleType) { case 1: XtraReport_Preview(report); break; case 2: XtraReport_Print(report); break; case 3: XtraReport_Designer(report, path); break; } }