detailsorder.aspx.cs

webshop系统,功能齐全,代数据库.压缩包解压时没有密码

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;

namespace WebShop
{

public class detailsorder : System.Web.UI.Page
	{
	protected System.Web.UI.WebControls.Label Label7;
	protected System.Web.UI.WebControls.Label Label6;
	protected System.Web.UI.WebControls.Label Label5;
	protected System.Web.UI.WebControls.Label Label4;
	protected System.Web.UI.WebControls.Label lblInfo;
	protected System.Web.UI.WebControls.Label Label1;
	protected System.Web.UI.WebControls.Label nametxt;
	protected System.Web.UI.WebControls.Label emailtxt;
	protected System.Web.UI.WebControls.Label phonetxt;
	protected System.Web.UI.WebControls.Label addresstxt;
	protected System.Web.UI.WebControls.Label datetxt;
	protected System.Web.UI.WebControls.Button Button1;
	protected System.Web.UI.WebControls.Panel Panel1;
	protected System.Web.UI.WebControls.Label Label2;
	protected System.Web.UI.WebControls.Label Writer;
	protected System.Web.UI.WebControls.Label Price;



		public string id;

		private void ToExcel(System.Web.UI.Control ctl)
				{
		
		Response.Charset = "GB2312";
		
		Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.DateTime.Now.ToString("yyyyMMddhhmmss") + "_" + HttpUtility.UrlEncode(System.Text.Encoding.UTF8.GetBytes("表格")) + ".xls");       
		
		Response.ContentEncoding = System.Text.Encoding.UTF8;

		Response.ContentType = "application/ms-execl";

		ctl.Page.EnableViewState = false;
									  
		System.IO.StringWriter tw= new System.IO.StringWriter();
																			  
					
		System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw);


		ctl.RenderControl(hw);
						

		Response.Write(tw.ToString());
		Response.End();
			
			}


		private void ShowMsg(string Message,int MessageType)
		{
			this.lblInfo.Visible = true;
			if(MessageType==0)//Mission accomplished
			{
				this.lblInfo.Text = Message;
				this.lblInfo.ForeColor = Color.Blue;
			}
			else
			{
				this.lblInfo.Text = Message;
				this.lblInfo.ForeColor = Color.Red;
			}			
		}

		private void Bind()
		{
			try
			{
				DataSet ds = DataAccessLayer.Order.GetOrders_details(id);

				//ds.Tables[0].DefaultView.Sort = ViewState["Sort"].ToString();

				//this.Dglist.DataSource = ds.Tables[0].DefaultView;

				//this.Dglist.DataBind();

				nametxt.Text=ds.Tables[0].Rows[0]["name"].ToString();

				emailtxt.Text=ds.Tables[0].Rows[0]["mail"].ToString();

		        Writer.Text=ds.Tables[0].Rows[0]["author"].ToString();

				Price.Text=ds.Tables[0].Rows[0]["price"].ToString();

				phonetxt.Text=ds.Tables[0].Rows[0]["phone"].ToString();

				addresstxt.Text=ds.Tables[0].Rows[0]["address"].ToString();

				
				this.lblInfo.Text = "[订单编号]:" + ds.Tables[0].Rows[0]["orderid"].ToString();
			
				
			
			}
			catch(Exception ex)
			{
				ShowMsg(ex.Message,1);
			}			
		}
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			
			 id=Request["orderid"].ToString();

			Bind();
			

		}

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

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			//Response.Write("<script>window.open(detailsorderr_print.aspx?uid="+id+")</script>");

			
			//Response.Write("<script>openwin("+id+")</script>");

			ToExcel(Panel1);

		}

	}
}