nxcon.aspx.cs

主要功能： 1、 包括顾客信息、货品信息、定单信息的管理。 2、 按月统计销售业绩。 3、 报表设计。 4、 系统维护。

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.OleDb;

namespace jd
{
	/// <summary>
	/// WebForm3 的摘要说明。
	/// </summary>
	public class WebForm3 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Image Image1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label22;
		protected System.Web.UI.WebControls.Label L9;
		protected System.Web.UI.WebControls.Label L8;
		protected System.Web.UI.WebControls.Label L7;
		protected System.Web.UI.WebControls.Label L6;
		protected System.Web.UI.WebControls.Label L5;
		protected System.Web.UI.WebControls.HyperLink HyperLink10;
		protected System.Web.UI.WebControls.HyperLink HyperLink9;
		protected System.Web.UI.WebControls.Label Label21;
		protected System.Web.UI.WebControls.Label Label1;
		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 L3;
		protected System.Web.UI.WebControls.Label L4;
		protected System.Web.UI.WebControls.Label L2;
		protected System.Web.UI.WebControls.Label L1;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Image Image23;
		protected System.Web.UI.WebControls.Panel Panel4;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Label Label12;
		protected System.Web.UI.WebControls.Label L10;
		protected System.Web.UI.WebControls.Image Image3;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(Request["姓名"]==null)
			{
				Response.Redirect("nainex.aspx");//如果为空显示经销页
			}
			else
			{
				string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
				OleDbConnection conn=new OleDbConnection(connstr);
				conn.Open();
				string sql="select * from 顾客信息表 where 姓名='"+Request["姓名"]+"'";
				OleDbCommand comm=new OleDbCommand(sql,conn);
				OleDbDataReader mydata=comm.ExecuteReader();
				string str;
				while(mydata.Read())
				{
					for(int i=0;i<mydata.FieldCount;i++)
					{
						if(mydata.GetName(i)=="姓名")
						{
							this.L1.Text=mydata.GetValue(i).ToString();
						}
						if(mydata.GetName(i)=="性别")
						{
							this.L2.Text=mydata.GetValue(i).ToString();
						}
						if(mydata.GetName(i)=="地址")
						{
							this.L3.Text=mydata.GetValue(i).ToString();
						}
						if(mydata.GetName(i)=="联系电话")
						{
							this.L4.Text=mydata.GetValue(i).ToString();
						}
						if(mydata.GetName(i)=="需购物品")
						{
							this.L5.Text=mydata.GetValue(i).ToString();
						}
						if(mydata.GetName(i)=="物品数量")
						{
							this.L6.Text=mydata.GetValue(i).ToString();
						}
						if(mydata.GetName(i)=="邮编")
						{
							this.L7.Text=mydata.GetValue(i).ToString();
						}
						if(mydata.GetName(i)=="身份证")
						{
							this.L8.Text=mydata.GetValue(i).ToString();
						}
						if(mydata.GetName(i)=="订单")
						{
							str=mydata.GetValue(i).ToString();
							this.L9.Text=str;
						}
						if(mydata.GetName(i)=="购买货物")
						{
							str=mydata.GetValue(i).ToString();
							this.L10.Text=str;
						}
					}//for
				}//while
				mydata.Close();
				conn.Close();
			}//else
		}

		#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>close()</script>");//关闭nxcon.aspx
		}
	}
}