public static byte[] ExportStock_SymbolPermLongToExcel(stock_SymbolPermLongExtensionCollection stock_SymbolPermLongExtensionCollection, string templatePath) { Dictionary<string, object> model = new Dictionary<string, object>(); model["stock_SymbolPermLongExtensionCollection"] = stock_SymbolPermLongExtensionCollection; return ExportToExcel(model, templatePath); }
public virtual stock_SymbolPermLongExtensionCollection Export_SymbolPermLongList(DateTime permDate, string market) { try { Database database = DatabaseFactory.CreateDatabase("DestinationConnection"); DbCommand dbCommand = database.GetStoredProcCommand("spMarketReview"); database.AddInParameter(dbCommand, "@PermDate", DbType.DateTime, permDate); database.AddInParameter(dbCommand, "@Market", DbType.String, market.ToString()); stock_SymbolPermLongExtensionCollection stock_SymbolPermLongExtensionCollection = new stock_SymbolPermLongExtensionCollection(); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { stock_SymbolPermLongExtension stock_SymbolPermLongExtension = Createstock_SymbolPermLongExtensionFromReader(reader); stock_SymbolPermLongExtensionCollection.Add(stock_SymbolPermLongExtension); } reader.Close(); } return stock_SymbolPermLongExtensionCollection; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessGetstock_SymbolPermLongListException, ex); } }
private void Export_symbolPermLong() { stock_SymbolPermLongExtensionCollection stock_SymbolPermLongExtensionCollection = new stock_SymbolPermLongExtensionCollection(); stock_SymbolPermLongExtensionCollection = stock_SymbolPermLongService.Export_SymbolPermLongList(ApplicationHelper.ConvertStringToDate(exportDateInput.Text), exportMarketInput.Value); byte[] data = Vfs.WebCrawler.Destination.Business.ExportService.ExportStock_SymbolPermLongToExcel(stock_SymbolPermLongExtensionCollection, ApplicationHelper.GetFullPath(ApplicationHelper.ExportSymbolPermLong)); Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment; filename=\"InfoMartketReview.xls\""); Response.AddHeader("Content-Length", data.Length.ToString()); Response.OutputStream.Flush(); Response.OutputStream.Write(data, 0, data.Length); Response.OutputStream.Flush(); }