onlineshopping.aspx.cs

用VC++做的一个网上小型网购物系统,需要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 System.Data .SqlClient ;

namespace _2.D._3
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DropDownList ddlcustid;
		protected System.Web.UI.WebControls.Label lblwelcome;
		protected System.Web.UI.WebControls.TextBox txtqty;
		protected System.Web.UI.WebControls.TextBox txtccc;
		protected System.Web.UI.WebControls.TextBox txtccn;
		protected System.Web.UI.WebControls.Label lblqty;
		protected System.Web.UI.WebControls.Label lblmessage;
		protected System.Web.UI.WebControls.Label lbldetails;
		protected System.Web.UI.WebControls.Label lblcid;
		protected System.Web.UI.WebControls.Label lblccn;
		protected System.Web.UI.WebControls.LinkButton lbnflowers;
		protected System.Web.UI.WebControls.LinkButton lbntoys;
		protected System.Web.UI.WebControls.Button bnsubmit;
		protected System.Web.UI.WebControls.DataGrid dgpdetail;
		protected System.Web.UI.WebControls.Label lblccc;
		protected System.Web.UI.WebControls.RequiredFieldValidator Rfvcustid;
		protected System.Web.UI.WebControls.RequiredFieldValidator Rfvqty;
		protected System.Web.UI.WebControls.RequiredFieldValidator Rfvccc;
		protected System.Web.UI.WebControls.RequiredFieldValidator Rvfccn;
		protected System.Web.UI.WebControls.RegularExpressionValidator Revqty;
		protected System.Web.UI.WebControls.RegularExpressionValidator Revccn;
		protected System.Web.UI.WebControls.LinkButton lbnbooks;
	
		public static string prid,pprice;
		SqlConnection myConnection;
		private void Page_Load(object sender, System.EventArgs e)
		{
			
		}

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

		}
		#endregion

		private void dgpdetail_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		    TableCell itemCell = e.Item .Cells [1];
			TableCell itemCell1 = e.Item .Cells [4];
			prid = itemCell.Text;
			pprice=itemCell1.Text;
			DataSet dscust = new DataSet ();

			myConnection = new SqlConnection ("server=172.21.10.20;database=WebShoppe;user id =sa;password=;");
			SqlDataAdapter mcommand= new SqlDataAdapter ("select CustID from CustomerDetails",myConnection);
			mcommand.Fill (dscust,"CustomerDetails");
			DataTable dt = new DataTable ();
			DataRow[] dr = new DataRow [100];
			ArrayList customers = new ArrayList();
            dt = dscust.Tables ["CustomerDetails"];
			dr = dt.Select ();
			for (int i=0;i<dr.Length ;i++)
			{
			  customers.Add (dr[i]["CustID"].ToString ());
			}
			ddlcustid.DataSource = customers;
			ddlcustid.DataBind ();
			lblcid.Visible = true;
			lblqty.Visible = true;
			lblccc.Visible = true;
			lblccn.Visible = true;
			ddlcustid.Visible = true;
			txtqty.Visible = true;
			txtccc.Visible = true;
			txtccn.Visible =true;
			bnsubmit.Visible =true;
			lbldetails.Visible =true;
		}

		private void lbntoys_Click(object sender, System.EventArgs e)
		{
			dgpdetail.Visible=true;
			myConnection = new SqlConnection("server=172.21.10.20;database=WebShoppe;user id=sa;password=;");
			SqlDataAdapter datoys = new SqlDataAdapter("select * from ToysDetails", myConnection);
			DataSet ds = new DataSet();							
			datoys.Fill(ds,"ToysDetails");		
			dgpdetail.DataSource=ds;
			dgpdetail.DataBind();
		}

		private void lbnflowers_Click(object sender, System.EventArgs e)
		{
			dgpdetail.Visible =true;
			myConnection = new SqlConnection ("server=172.21.10.20;database=WebShoppe;user id =sa;password=;");
			SqlDataAdapter daflowers = new SqlDataAdapter ("select * from FlowersDetails",myConnection);
			DataSet ds = new DataSet ();
			daflowers.Fill (ds,"FlowersDetails");
			dgpdetail.DataSource = ds;
			dgpdetail.DataBind ();
		}

		private void lbnbooks_Click(object sender, System.EventArgs e)
		{
			dgpdetail.Visible =true;
			myConnection = new SqlConnection ("server=172.21.10.20;database=WebShoppe;user id =sa;password=;");
			SqlDataAdapter dabooks = new SqlDataAdapter ("select * from BooksDetails",myConnection);
			DataSet ds = new DataSet ();
			dabooks.Fill (ds,"BooksDetails");
			dgpdetail.DataSource = ds;
			dgpdetail.DataBind ();
		}

		private void bnsubmit_Click(object sender, System.EventArgs e)
		{
			if(!Page.IsValid)
			{
				lbldetails.Text = "There is some problem with the details that you have entered.Please ensure that all fields have proper values.";
			}
			else
			{
				DataSet dscust = new DataSet ();
				myConnection = new SqlConnection ("server=172.21.10.20;database=WebShoppe;user id =sa;password=");
				SqlCommand insertCmd = new SqlCommand ("insertrecords",myConnection);
				insertCmd.CommandType = CommandType.StoredProcedure ;
				insertCmd.Parameters .Add (new SqlParameter ("@invid",SqlDbType.NChar,10));
				insertCmd.Parameters .Add (new SqlParameter ("@idate",SqlDbType.NChar,10));
				insertCmd.Parameters .Add (new SqlParameter ("@prodid",SqlDbType.NChar,10));
				insertCmd.Parameters .Add (new SqlParameter ("@custid",SqlDbType.NChar,10));
				insertCmd.Parameters .Add (new SqlParameter ("@qt",SqlDbType.Int));
				insertCmd.Parameters .Add (new SqlParameter ("@prodprice",SqlDbType.Int));
				insertCmd.Parameters .Add (new SqlParameter ("@tprice",SqlDbType.Int));
				insertCmd.Parameters .Add (new SqlParameter ("@ccc",SqlDbType.NChar,10));
				insertCmd.Parameters .Add (new SqlParameter ("@ccn",SqlDbType.NChar,10));
                insertCmd.Parameters["@idate"].Value =System.DateTime .Today .ToString ();
				insertCmd.Parameters["@custid"].Value =ddlcustid.SelectedItem .ToString ();
                insertCmd.Parameters["@qt"].Value =System.Convert .ToInt16 (txtqty.Text );
				insertCmd.Parameters["@prodprice"].Value =pprice.ToString ();
			    insertCmd.Parameters["@tprice"].Value =(System.Convert.ToInt16 (insertCmd.Parameters ["@qt"].Value .ToString ()))*(System.Convert.ToInt16 (insertCmd.Parameters ["@prodprice"].Value .ToString ()));
			    insertCmd.Parameters ["@ccc"].Value =txtccc.Text .ToString ();
				insertCmd.Parameters ["@ccn"].Value =txtccn.Text .ToString ();
				insertCmd.Parameters ["@prodid"].Value =prid.ToString ();
				DataSet dsinv = new DataSet ();
				SqlDataAdapter mcommand = new SqlDataAdapter ("select InvID from OrderDetails",myConnection);
				mcommand.Fill (dsinv,"OrderDetails");
				DataTable dt = new DataTable ();
				DataRow[] dr = new DataRow [100];
				dt = dsinv.Tables ["OrderDetails"];
				string id;
				id = dt.Rows [dt.Rows .Count -1]["InvID"].ToString ();
				string str;
				str = id.Substring (1,3);
				int y;
				y = System.Convert .ToInt16 (str);
                y = y+1;

				if(y>1 && y<=9)
				{
					insertCmd.Parameters ["@invid"].Value = "I00" + y;
				}

				if(y>9 && y<=99)
				{
					insertCmd.Parameters ["@invid"].Value = "I0" + y;
				}

				if(y>99)
				{
					insertCmd.Parameters ["@invid"].Value = "I" + y;
				}
				try
				{
					insertCmd.Connection .Open ();
					insertCmd.ExecuteNonQuery ();
				}
				catch(System.FormatException exc)
				{
				   lblmessage.Text = "Source:" + exc.Source ;
				}
                string cid = ddlcustid.SelectedItem .Value ;
				Response.Redirect ("Orders.aspx?cid=" + System.Web .HttpUtility .UrlEncode (cid));
			}
		}


	}
}