toexcel.aspx.cs

该系统采用asp+sql的实验室管理系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Datamodel;
using OWC;

namespace Sbgl.Admin
{
	/// <summary>
	/// ToExcel 的摘要说明。
	/// </summary>
	public partial class ToExcel : System.Web.UI.Page
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			string SQLSTR=Request.QueryString["SQLSTR"]==null?"":Request.QueryString["SQLSTR"].ToString();
			if(SQLSTR!="")
			{
				CreateDb mydb = new CreateDb();
				DBManager my = mydb.Createdb();
				my.OpenConn();
				IDataReader dr=my.ExecuteCreateReader(my.ExeCommand(SQLSTR));
				int FieldNumber = dr.FieldCount;
				if(FieldNumber == 0)
					Response.End();
				SpreadsheetClass xlsheet=new SpreadsheetClass();
				for(int i=0;i<FieldNumber;i++)
				{
					xlsheet.ActiveSheet.Cells[1,i+1]=dr.GetName(i).ToString();
	
				}
				int j=2;
				while(dr.Read())
				{
					for(int i=0;i<FieldNumber;i++)
					{
						
						xlsheet.ActiveSheet.Cells[j,i+1]=dr.GetValue(i).ToString();
					}
					j=j+1;
				}
				/*
				my.CloseConn();
				Response.Clear(); 
				Response.Buffer= true; 
				Response.Charset="GB2312";    
				Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls"); 
				Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
				Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 
				this.EnableViewState = false;    
				System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
				System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); 
				System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
				this.DataGrid1.RenderControl(oHtmlTextWriter); 
				*/
				try
				{
					//''Response.Write(oStringWriter.ToString());
					//Response.End();
					xlsheet.ActiveSheet.Export(Server.MapPath("test.xls"),OWC.SheetExportActionEnum.ssExportActionNone);
				}
				catch(Exception er)
				{
					throw (er);
				}
				finally
				{
					Response.Write("<script lanage=javascript>");
					Response.Write("window.close();");
					Response.Write("</script>");
				}
				//dr.Close();
			}
			else
			{
				Response.Write("<script lanage=javascript>");
				Response.Write("javascript:window.close();");
				Response.Write("</script>");
			}

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
			{
				e.Item.Attributes.Add("style","vnd.ms-excel.numberformat:@");
			}
		}
	}
}