detailscom.aspx.cs

.net环境下开发的,很好哦,这是我门最近做的一个电子商务的作业 实现了很多功能,是典型的C2C模式,很有利用价值,大家下载了多给我提意见

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 System.Data.SqlClient;
namespace secondhand
{
	/// <summary>
	/// detailscom 的摘要说明。
	/// </summary>
	public class detailscom : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Image Image1;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Label Label11;
		protected System.Web.UI.WebControls.Label Label12;
		protected System.Web.UI.WebControls.Label Label13;
		protected System.Web.UI.WebControls.Label Label14;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			string ID=Request["ID"];

			string ec=System.Configuration.ConfigurationSettings.AppSettings["ec"];
			SqlConnection conn = new SqlConnection(ec);
			conn.Open();
			SqlCommand cmd=new SqlCommand("select comname,introduction,'一口价' as deal_auction,price,img,userid,date,expire_date "+
				"from commdotyInfo where deal_auction='1' and commodityid='"+ID+"'",conn);
			SqlDataReader dr=cmd.ExecuteReader();
			if(dr.Read())
			{
				Image1.ImageUrl=dr["img"].ToString();
				Label8.Text=dr["comName"].ToString();
				Label9.Text=dr["introduction"].ToString();
				Label10.Text=dr["deal_auction"].ToString();
				Label11.Text=dr["price"].ToString();
				Label12.Text=dr["userid"].ToString();
				Label13.Text=dr["date"].ToString();
				Label14.Text=dr["expire_date"].ToString();

			}
			else
			{
				dr.Close();
				SqlCommand cmmd=new SqlCommand("select comname,introduction,'拍卖' as deal_auction,price,img,userid,date,expire_date "+
					"from commdotyInfo where deal_auction='0' and commodityid='"+ID+"'",conn);
				SqlDataReader ddr=cmmd.ExecuteReader();
				if(ddr.Read())
				{
					Image1.ImageUrl=ddr["img"].ToString();
					Label8.Text=ddr["comName"].ToString();
					Label9.Text=ddr["introduction"].ToString();
					Label10.Text=ddr["deal_auction"].ToString();
					Label11.Text=ddr["price"].ToString();
					Label12.Text=ddr["userid"].ToString();
					Label13.Text=ddr["date"].ToString();
					Label14.Text=ddr["expire_date"].ToString();

				}

			}

		}

		#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)
		{
			string ID=Request["ID"];
			if(Label10.Text=="一口价")
				Response.Redirect("李金旭.aspx?ID="+ID);
			else
				if(Label10.Text=="拍卖")
				Response.Redirect("郝凯博.aspx?ID="+ID);
		}
	}
}