EquipmentManagement/Admin/ToExcel.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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 Data_Control;
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!="")
			{
                AddEquiDB add = new AddEquiDB();
                SqlConnection conn = add.GetConn();
                conn.Open();
                SqlCommand cmd = new SqlCommand(SQLSTR, conn);
                SqlDataReader dr = cmd.ExecuteReader();
				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文件。