addsale.aspx.cs

通过对现在流行的各种销售管理软件的分析

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;
using System.Configuration;

namespace SellManageJane
{
	/// <summary>
	/// Addsale 的摘要说明。
	/// </summary>
	public class Addsale : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.TextBox fm_remark;
		protected System.Web.UI.WebControls.TextBox fm_amount;
		protected System.Web.UI.WebControls.TextBox fm_price;
		protected System.Web.UI.WebControls.TextBox fm_title;
		protected System.Web.UI.WebControls.TextBox fm_customer_id;
		protected System.Web.UI.WebControls.TextBox fm_goods_id;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.Button Button6;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.TextBox TextBox5;
		protected System.Web.UI.WebControls.TextBox TextBox6;
		protected System.Web.UI.WebControls.Button Button7;
		protected System.Web.UI.WebControls.Button Button8;
		protected System.Web.UI.WebControls.Button Button9;
		protected System.Web.UI.WebControls.TextBox TextBox7;
		protected System.Web.UI.WebControls.TextBox TextBox8;
		protected System.Web.UI.WebControls.TextBox TextBox9;
		protected System.Web.UI.WebControls.TextBox TextBox10;
		protected System.Web.UI.WebControls.TextBox TextBox11;
		protected System.Web.UI.WebControls.Button Button10;
		protected System.Web.UI.WebControls.Button Button11;
		protected System.Web.UI.WebControls.Button Button12;
		protected System.Web.UI.WebControls.TextBox TextBox13;
		protected System.Web.UI.WebControls.TextBox TextBox14;
		protected System.Web.UI.WebControls.TextBox TextBox15;
		protected System.Web.UI.WebControls.TextBox TextBox16;
		protected System.Web.UI.WebControls.TextBox TextBox17;
		protected System.Web.UI.WebControls.TextBox TextBox18;
		protected System.Web.UI.WebControls.Button Button15;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.HtmlControls.HtmlInputText DatePicker1;
		protected System.Web.UI.WebControls.TextBox TextBox12;
		protected System.Web.UI.WebControls.TextBox title;
		protected System.Web.UI.WebControls.TextBox price;
		protected System.Web.UI.WebControls.TextBox costPrice;
		protected System.Web.UI.WebControls.TextBox amount;
		protected System.Web.UI.WebControls.TextBox remark;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Reset1;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		SqlConnection conn;
		SqlCommand com;
		SqlDataReader dr;
		DataSet goodsData;
		DataSet customerData;
		SqlDataAdapter ada;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator2;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator3;
		SqlDataAdapter ada1;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			conn = new SqlConnection(ConfigurationSettings.AppSettings["connStr"].ToString());
			conn.Open();
			ada=new SqlDataAdapter("select goodsId from goods",conn);
			goodsData = new DataSet();
			ada.Fill(goodsData,"goods");
			this.DropDownList1.DataSource=goodsData;
			this.DropDownList1.DataMember="goods";
			this.DropDownList1.DataTextField=goodsData.Tables[0].Columns["goodsId"].ToString();

			ada1 = new SqlDataAdapter("select customerId from customer",conn);
			customerData = new DataSet();
			ada1.Fill(customerData,"customer");
			this.DropDownList2.DataSource=customerData;
			this.DropDownList2.DataMember="customer";
			this.DropDownList2.DataTextField=customerData.Tables[0].Columns["customerId"].ToString();
			this.DataBind();
			
		}

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

		}
		#endregion

		private void Button15_Click(object sender, System.EventArgs e)
		{
			try
			{
				com = new SqlCommand("insert into Sale values('"+this.DropDownList1.SelectedItem.Text+"','"+this.DropDownList2.SelectedItem.Text+"','"+this.title.Text+"','"+this.price.Text+"','"+this.costPrice.Text+"','"+this.amount.Text+"','"+this.DatePicker1.Value+"','"+this.remark.Text+"')",conn);
				dr = com.ExecuteReader();
				if(!dr.Read())
				{
					RegisterStartupScript("msg","<script>alert('添加销售信息成功！！！');</script>");
					Response.Redirect("Editsale.aspx");
				}	
				conn.Close();
			}
			catch(Exception ex)
			{
				Response.Write(ex.Message);
			}
		}	
	}
}